Top Rated instead of Most Popular?

BryanG · January 29th, 2006, 12:11 PM

I've noticed that ReviewPost displays the "Most Popular" items. How do I change it to display the "Top Rated" items (the items with the highest score)?

Also, would it be possible to check to make sure there's more than one review, so that way any item that has received only one review and a 10 wont be listed on top.

The only thing similar I was able to find in a search was this thread:
Top Rated Bar and Highest Ratings PAL

But it seems to be out of date.

Thanks

Chuck S · January 30th, 2006, 09:33 AM

$query[] = "INSERT INTO {$rp_db_prefix}sort VALUES (1,'Most Active','ORDER BY disporder,lastpost DESC')";
$query[] = "INSERT INTO {$rp_db_prefix}sort VALUES (4,'Most Popular','ORDER BY disporder,rating DESC, views DESC')";

Most popular is highest rating sorted by views secondary. It has nothing to do with lastpost

The thread noted has already been changed in the current reviewpost

BryanG · January 30th, 2006, 01:05 PM

My top product that's showing up has been viewed 12,000+ times but only has a 5.5 rating where the second product has 10,000+ views and a 9.1 rating.

It's not listing the highest rated first...it's showing the one with the most views.

Chuck S · January 30th, 2006, 03:31 PM

This is what is in the reviewpost index file. Most popular is views here but you can change it like noted in that thread if you want it to operate differently

Code:

Content visible to verified customers only.

BryanG · February 2nd, 2006, 09:40 AM

I tried changing it and for some reason it's still showing the product with 12,000+ views and only a 5.5 rating.

I think it has to do with the fact that the average score is figured out on the showproduct page and the query is basing the rating on what's in the database, which is a 10 for the first review (but the second review was only a "1").

Chuck S · February 2nd, 2006, 09:51 AM

The average rating is stored in the products table

Just change the query noted to whatever ORDER BY you want

BryanG · February 2nd, 2006, 03:03 PM

I did that:

Code:

Content visible to verified customers only.

It still shows the one with the 12,000 views but 5.5 rating first. I even tried "ORDER by rating" by itself and I still get the same results.

Chuck S · February 2nd, 2006, 03:23 PM

Have you made sure to turn off the cache in Global Options so your seeing the results in real time?

BryanG · February 2nd, 2006, 03:28 PM

Yes. I even tried doing a complete refresh of the page (CTRL+R). Also tried clearing my browser cache.

Edit: Wanted to add that this is for the "Show Most Popular images on Index page?" option, not the "Most Popular PAL".

Changing the query option does change the PAL, but doesn't change the "Most Popular images on Index page" box.

Chuck S · February 2nd, 2006, 03:45 PM

This thread is about a PAL

If your trying to change the most popular images thats a whole separate file etc

pp-inc.php edit the display_gallery function

BryanG · February 2nd, 2006, 09:04 PM

Got it. It's changing now.

I fixed it by changing the order to:

ORDER BY ratings DESC, numreviews DESC

And now it gives me the top rated items with the most reviews in descending order.

But, I seem to have run into another problem...It's not changing the products on the showcat page even though, from what I understand from showcat.php, it's calling the same function from pp-inc.php as index.php does. Am I right?

Chuck S · February 2nd, 2006, 09:11 PM

Did you modify the proper query

There are multiple queries in each case for specific aspects

BryanG · February 2nd, 2006, 09:17 PM

Yup. I modified case "most_views", and that's what showcat.php calls.

From showcat.php:

Code:

Content visible to verified customers only.

BryanG · February 2nd, 2006, 09:21 PM

Nevermind...there's another query for catviews.

Chuck S · February 3rd, 2006, 06:01 AM

Yep there is a spefic query to limit the reviews by cat