Can I add to Edit Ad function?

Badger · December 1st, 2010, 03:22 PM

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

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 ....

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

Chuck S · December 1st, 2010, 04:14 PM

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.

Badger · December 1st, 2010, 04:34 PM

Thanks Chuck ..

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

Regards,
Doug

Chuck S · December 1st, 2010, 05:36 PM

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.

Badger · December 2nd, 2010, 04:17 AM

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

Chuck S · December 2nd, 2010, 08:12 AM

UPDATE cp_products SET duration=9999,enddate=2080101600;

Maybe something like that?

Badger · December 4th, 2010, 12:13 PM

Quote:

Originally Posted by Chuck S

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

Chuck S · December 4th, 2010, 01:20 PM

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

Badger · December 9th, 2010, 07:46 AM

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

Chuck S · December 9th, 2010, 08:36 AM

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

Badger · December 9th, 2010, 08:47 AM

Ok ...

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

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 ..

So, now I are a programmer ...

Chuck S · December 9th, 2010, 08:56 AM

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

Badger · December 9th, 2010, 09:20 AM

Quote:

Originally Posted by Chuck S

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 ...

Regards,
Doug

Chuck S · December 9th, 2010, 11:24 AM

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