View Single Post
Old August 17th, 2005, 04:19 PM   #2 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,054
Hello

Well dont know how to tell you to recalculate things other than to set the status of the expired ads back to approved date and clear the stats table and rerun sendnotice

However I will answer your hypothesis that you think we dont insert a record

On an install we do indeed insert a record for the stats table so I show the files coded properly. If your install did not have a record of 1 then its unique to you. This is right in our install file.

$query[] = "CREATE TABLE {$pp_db_prefix}stats (id int(2) NOT NULL auto_increment, amt_sold float(12,2) NOT NULL default '0', ads_sold int(12) NOT NULL default '0', lastupdate INT(12) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM";
$query[] = "INSERT INTO {$pp_db_prefix}stats VALUES (1, 0, 0, 0)";
__________________
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