 | |  | | | ReviewPost Bug Reports Let us know about any post installation problems you are having with ReviewPost. | 
July 31st, 2006, 01:02 PM
|
#1 (permalink)
| | Member Verified Customer
Join Date: Jul 2006
Posts: 53
| Number of Products
If a user submits a product and it needs to be moderated, the count of products reflects it even if it hasn't been approved as of yet. Any way to fix this?
Last edited by tj2653; July 31st, 2006 at 04:21 PM.
| 
|  | |
August 1st, 2006, 08:36 AM
|
#2 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,693
|
The stats simply show the correct total products number whether approved or not.
| |
| | |
August 28th, 2006, 01:04 PM
|
#3 (permalink)
| | Member Verified Customer
Join Date: Jul 2006
Posts: 53
| Quote:
Originally Posted by Chuck S  The stats simply show the correct total products number whether approved or not. | Is there an easy way to change this so it only counts the approved products? Many of my users are getting confused when a category shows that there is 1 product, but click only to see none (since the 1 is in the approval queue). I'm guessing I would add something like:
WHERE approved=1
to the mySQL call, but I'm not sure where the count is being done.
Thanks,
Cary
| |
| | |
August 28th, 2006, 05:03 PM
|
#4 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,693
|
Yes exactly you add something like that to the call and it would be in the pp-inc.php file or index.php file if your running an older version in the function get_statscache
| |
| | |
August 28th, 2006, 06:35 PM
|
#5 (permalink)
| | Member Verified Customer
Join Date: Jul 2006
Posts: 53
| Quote:
Originally Posted by Chuck S Yes exactly you add something like that to the call and it would be in the pp-inc.php file or index.php file if your running an older version in the function get_statscache | I tried: Code: Content visible to verified customers only.
to function get_statscache, but it didn't seem to do anything. I have caching off, so I don't think that matters. Any ideas?
| |
| | |
August 28th, 2006, 07:00 PM
|
#6 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,693
|
That would make a difference for sure as long as your reloading the cache
| |
| | |
August 30th, 2006, 08:42 PM
|
#7 (permalink)
| | Member Verified Customer
Join Date: Jul 2006
Posts: 53
| Quote:
Originally Posted by Chuck S That would make a difference for sure as long as your reloading the cache | I'm looking to have the number of approved products in the category listings -- that code just seems to change the total approved products statistics at the bottom of the page.
| |
| | |
August 30th, 2006, 08:50 PM
|
#8 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,693
|
edit your catrow function in pp-inc.php
| |
| | |
August 31st, 2006, 09:05 AM
|
#9 (permalink)
| | Member Verified Customer
Join Date: Jul 2006
Posts: 53
| Quote:
Originally Posted by Chuck S edit your catrow function in pp-inc.php | Hmm...not sure where I should be looking in it. It's not a mySQL call is it?
| |
| | |
August 31st, 2006, 09:28 AM
|
#10 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,693
|
Yes its the mysql query update_catcache however there is no specific way to do this since the number of products are pulled from the categories table.
Last edited by Chuck S; August 31st, 2006 at 09:34 AM.
| |
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread |  Linear Mode | | 
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | | All times are GMT -5. The time now is 01:26 PM. | |
