Click Here for photopost coupon Code

About photopost Company....

PhotoPost is PHP based software for your site that lets your users share and upload photos to galleries and to interact in photo discussions. Install it yourself, or let us get your gallery up and running in one day.
KEY FEATURES

* Photo uploads w/auto thumbnails via a web browser
* Fully integrates with vBulletin 3.x, UBB, & other forums
* Blends with your site's look and feel
* Member galleries with private album support
* 9,500 site owners have purchased PhotoPost to date
 

Mon-Fri 9am-4pm EST Visualize community tm Home|Product Details|Support|Demo|Example Galleries|Contact Us|Forums|Blog|Members|Buy PhotoPost PhotoPost Community > PhotoPost Support > PhotoPost Classifieds > Installation & Upgrades Questions about sendnotice.php and stats User NameRemember Me? Password RegisterFAQPhoto GalleryMembers ListCalendar Installation & Upgrades If you're having install or upgrade problems, post here. Go to Page... Thread Tools Rate Thread Display Modes August 16th, 2005, 12:34 PM #1 cdouglas Registered User Join Date: Aug 2005 Posts: 2 Questions about sendnotice.php and stats I have a new 2.41 install of classifieds that is up and working now.
I want to get the sendnotice.php working to do the email notifications.
As soon as I enabled, it people were getting send the same email sent over and over every 10 minutes.
I fixed that by adding an initial record to pp_stats with an id of 1.
Previously it did not exist.
The code should have checked for a record and if it wasnt there, done an insert. The problem now is that none of the stats such as items sold and dollar amounts got updated since the editproduct.php tries to update a record in pp_stats with an id of 1 that did not exist.
Is there a way for it to go recaculate those stats? The Scan DB / recalculate numbers did not work.
Thanks Chris cdouglas View Public Profile Find More Posts by cdouglas August 17th, 2005, 05:19 PM #2 Chuck S Photopost Developer Verified Customer Join Date: Jun 2002 Location: Abingdon,MD Posts: 36,245 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 Custom Developer and Support Engineer Please do not PM me for support or sales questions.
Thank you for your understanding.
Chuck S View Public Profile Visit Chuck S's homepage! Find More Posts by Chuck S August 18th, 2005, 01:56 PM #3 cdouglas Registered User Join Date: Aug 2005 Posts: 2 Thank you for your response.
I checked my installer and that line is in there as you said it was.
Why it didn't work on mine I dont know, but as soon as I created that record, the sold stats started working, as well as the notifications. cdouglas View Public Profile Find More Posts by cdouglas « Previous Thread | Next Thread » Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Rate This Thread Excellent Good Average Bad Terrible Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home General Forums PhotoPost Announcements Before You Buy PhotoPost Product FAQs General Discussion Show off your PhotoPost site! PhotoPost Support PhotoPost Pro How Do I...? Installation & Upgrades Bug Reports Import Scripts Suggestions PhotoPost vBGallery How Do I...? vBulletin 3.0.X vBulletin 3.5.X vBulletin 3.6x Installation & Upgrades vBulletin 3.0.X vBulletin 3.5.X vBulletin 3.6x Bug Reports vBulletin 3.0.X Bugs From 1.0.0 vBulletin 3.5.X vBulletin 3.6x Import Scripts Suggestions ReviewPost Pro How do I...? Installation & Upgrades Bug Reports Suggestions PhotoPost Classifieds How do I...? Installation & Upgrades Bug Reports Suggestions The Mod Corner PhotoPost Pro Mod Discussions PhotoPost Mods Integration Mods vBulletin Modifications UBBThreads Modifications Other Integrations Template Mods Styles & Themes Languages Photopost vBGallery Mod Discussions Languages Mod Requests Beta Mods VBGallery Mods vB 3.0.X Code vB3x Template vB 3.5.X Code vB3.5x Template vB 3.6X Code vB 3.6X Template ReviewPost Pro Mod Discussions ReviewPost Mods Template Mods Languages Styles & Themes PhotoPost Classifieds Classified Mods Mod Discussions Languages Template Mods Styles & Themes Similar Threads ThreadThread StarterForumRepliesLast Post Cron Job: sendnotice.phpMichael PInstallation & Upgrades54April 17th, 2007 08:48 PM Does sendnotice.php remove the ads from the database?Andy RInstallation & Upgrades7November 22nd, 2005 10:06 PM showmember.php user stats not shown(NOT A BUG)ArnieBug Reports1August 28th, 2005 08:46 PM Sendnotice.phpBryan ExSuggestions2June 22nd, 2004 04:58 PM All times are GMT -5.
The time now is 12:41 PM. Contact Us - PhotoPost - Archive - Privacy Statement - Top Powered by vBulletin® Version 3.6.7 Copyright ©2000 - 2007, Jelsoft Enterprises Ltd.
All Enthusiast Sites: ResellerRatings: Discount Shopping / Store Ratings Dealighted: Shopping Coupons, Bargains, Deals TechIMO.com: Tech Support and Discussion HOME | Copyright 2001-2007 ALL ENTHUSIAST, INC.
ALL RIGHTS RESERVED.