View Single Post
Old July 31st, 2005, 12:27 PM   #20 (permalink)
robferrari
Member
Verified Customer
 
Join Date: Nov 2004
Posts: 49
Quote:
Originally Posted by omegatron
There is no issue here that I see. Here is a brand new install I am doing and you can test it

http://www.reeftalk.com/classifieds/index.php

Go ahead and run sendnotice.php yourself

http://www.reeftalk.com/classifieds/sendnotice.php

It does not expire ads that are not expired period and here is the query in sendnotice.php

// Close out expired ads
$query = "UPDATE {$Globals['pp_db_prefix']}products SET approved=2,status='$today' WHERE enddate < $today AND isauction=0";
$result = ppmysql_query($query,$link);

NOTICE WHERE enddate < $today
I believe you that it works fine on your new install. Please tell me why it may not be working on my individual install? I now have the latest version at 2.41. I have done no customizations. Are there any settings in the Options or Config that could cause it not to put the expiration out 90 days or for the sendnotice script to not accurately filter off that?

Trust me, I have a standard install, no customizations, the Db obviously works because everything else appears to be working fine. I have proven to you with my screen shots it isn't working, so please help.

If you can't help, tell me someone that can.
robferrari is offline   Reply With Quote