View Single Post
Old March 15th, 2010, 01:42 PM   #7 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,662
I posted the query for you above. Nothing has really changed in the sendnotice script and the cron.php file is a duplicate of sendnotice.php except the print statements. For your ads to be expired then the enddate on those ads had to be less than the unixtimestamp of today.

Feel free to post the unixtimestamp of one of those ads but like I said this is an absolute here.

For expire those ads lets take the query I posted and construct what the query looks like in reality.

Say you ran the cron task right this minute

Quote:
UPDATE cp_products SET approved=2,status='1268682020' WHERE enddate < 1268682020 AND isauction=0
That would only expire ads where the enddate is less than that timestamp right there.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote