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.