Can I add to Edit Ad function?
 

I had a book seller create a bunch of ads and he didn't select "Never Expire".... :rolleyes:

So, now his ads keep expiring even if they haven't sold and get marked SOLD, which means I have to go into each ad and do a RE-LIST all the time .... :D

Is there anyway I can add the capability to Edit Ad to turn ON the field (have it show) in order to change all his ads to "Never Exire"?

Thanks Chuck.. :)

Regards,
Doug

There is no ability to edit an expiration term. The duration is set on upload and is not editable to the user for obvious reasons which is why you do not see such a feature.

Thanks Chuck .. :)

So, even during the re-list function, the ad duration can't be changed or prompted for?

Regards,
Doug

No if one relists it it is relisted for the duration one uploaded it with

I am sure you understand why duration is not changeable. Simply a user could simply just edit an ad and never have to rebuy to relist etc.

Ahh... ok, for paying advertisers .. I see... :)

We don't charge, so it's academic to us ...

Is there any other way (or edit) on a temp basis I can get this seller's ads changed to "Never Expire", short of retyping every one of them into the system again?

Thanks Chuck.. :)

Regards,
Doug

UPDATE cp_products SET duration=9999,enddate=2080101600;

Maybe something like that?

Thanks Chuck .. :)

Appreciate that ....

I'll give it a try, but before I did, is there a way of just limiting the changes to specific user ID's?

Regards,
Doug

UPDATE cp_products SET duration=9999,enddate=2080101600 WHERE userid=someuserid;

Hi Chuck ... :)

Ok, I've worked up the courage to execute this SQL command (never done it before) and I thought I'd check with you again, just to make sure you don't think that if I typed this:

UPDATE cp_products SET duration=9999,enddate=2080101600 WHERE userid=1129

.. that there would be anything you see that could affect our vBulletin database. The UserID I want to set his all his ads to "never expire" is 1129...

Thanks ...

Regards,
Doug

issuing an update on a classifieds products table has nothing to do with your vbulletin database ;)

Ok ... :)

I guess I'll give it a shot then ... :p

Thanks Chuck ...

Regards,
Doug

Edit: Executed and the response was:

Affected Rows: 58 (0.0017s)

Which is how many ads that user had in the system, so I think it might have worked .. :D

So, now I are a programmer ... :p

LOL yes that means it updated 58 records in your table.

Thanks again Chuck ... :)

If I don't speak to you before, I'd like to wish you and yours a very Merry Christmas and best wishes for a successful and prosperous New Year ... :D

Regards,
Doug

Yep you too. It is almost that time isn't it how time flies when your having fun. ;)