Limits Up
Welcome, Guest. Please login or register.
November 23, 2008, 08:24:03 AM

Pages: [1]
Print
Author Topic: Top Rated Profiles should sort by "rating AND number of rates"  (Read 118 times)
brusselsshrek
Sr. Member
****
Posts: 295



« on: September 05, 2008, 11:33:13 AM »

The Top Rated Profiles (/member/toprated_list.php ) should sort first by rating (obviously), but then by number of rates.  e.g. a profile with a 4.5 rating based on 8 people should be ahead of a 4.5 rating based on 3 people (since it is more reliable).

In SQL terms, I guess this is something like "ORDER BY rating, number_of_rates DESC".
Logged

http://romeobox.com - RomeoBox dating site
brusselsshrek
Sr. Member
****
Posts: 295



« Reply #1 on: October 27, 2008, 10:48:52 AM »

So, will you make this small improvement Skalfa?
Logged

http://romeobox.com - RomeoBox dating site
Adden
Administrator
Sr. Member
*****
Posts: 308



« Reply #2 on: October 29, 2008, 12:25:27 AM »

Hello brusselsshrek
At the current code version it ordered only by total score. In SQl terms it looks like:
ORDER BY `score` DESC, `activity_stamp`
As I understood, you suggested to add second order parameter: order by number of rates.
Am I right?
Logged
brusselsshrek
Sr. Member
****
Posts: 295



« Reply #3 on: October 29, 2008, 07:50:49 AM »

Yes, add "number of rates" as a second order sort parameter.
Logged

http://romeobox.com - RomeoBox dating site
Pages: [1]
Print
Jump to:  

You are here: Skalfa » Support » Discussion Boards