SQL to mass change duration of existing ads

[creativepart]

I've had a devil of a problem with old ads. Seems I didn't notice the "no expire" option was available and a lot of my users selected that option.

I've now gone in and changed the duration options in my templates, but I have about 45 ads in the database with a duration of 9999. I'd like to change all of those to 30 days and let them expire out of the system.

Could you please give me an example of an SQL command that I can run to mass change all ads in the product table with a duration of 9999 to a duration of 30?

I sure would appreciate it.

Thanks
Paul Green

[Chuck S]

UPDATE cp_products SET enddate='1174366800' WHERE enddate > ' 1174367450'

[creativepart]

Thanks, I appreciate that.

I have some sold ads that are not going away. I run the cron job daily and process the expired ads deletes. They don't show up if you peruse the cats, but they show up in the toppage random ads display on my forum.

They all have status numbers -- and none of the non-sold ads seem to have status numbers. Can you give me an SQL to delete all ads with a status number? (We don't have any auctions, if that matters.) There are only 22 of these and I can manually delete them. Why would these not go away???

One more question, I see today that my licenses expired earlier this month. I have PP, RP and PP-C products. Do I need to renew all three licenses? Or just one?

Thanks
Paul Green
PS. I was surprised that I didn't receive any email notice that my licenses expired as well.

[Chuck S]

You would renew whatever ones you want to have members access to

SOLD ADS should not be displayed anywhere you can selectively delete those or allow the cron task in admin to delete things over 2 weeks old