View Single Post
Old August 29th, 2005, 09:35 PM   #13 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,054
what do you mean to retain ads 180 days after they are closed??

If an ad expires it should be marked like so which means it will not show

// 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);


then in showcat where ads are shown see approved=1

$query .= "WHERE approved=1 $catcheck AND date > $searchdate $exclude_cat $sortcode";

So your losing me here saying you have it set to show 180 days after. Once an ad expires you should delete it or relist it
__________________
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