find and remove no expiration ads.

[rcull]

I can find non expiring ads in the sql database. They would be the ones with 9999 in the duration column. There is also and end date column.

When editing an ad, there doesn't seem to be a place to change the duration, so I can't just find the ad number and edit the ad.

How could I find non expireing ads and change them to expire. Will simply changeing the duration start the clock ticking?

Thanks

[Chuck S]

You would change them to say 30 instead of 9999 and yes they should expire when you run sendnotice.php

UPDATE cp_products SET duration=30 WHERE duration=9999;

[rcull]

Thanks for guessing I didn't know how to run a query and suggesting one. It worked great!

[Chuck S]

Glad to help!