forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: Vadim on February 15, 2005, 12:44:50 am

Title: Top rated sorting bug
Post by: Vadim on February 15, 2005, 12:44:50 am

Hi,

I've noticed, that Top rated pictures are not sorted coorectly
Look here: http://coppermine.sourceforge.net/demo/displayimage.php?album=toprated&cat=0&pos=0 , this picture has  4.5 / 5, and this http://coppermine.sourceforge.net/demo/displayimage.php?album=toprated&cat=0&pos=1 (which is on the 2nd place) 4.7 / 5

I think that the solution is to change sort order query in include/functions.inc.php Line 703 to

Code: [Select]

$result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' AND votes >= '{$CONFIG['min_votes_for_rating']}' $ALBUM_SET ORDER BY ROUND(((pic_rating+1)/2000), 2) DESC, votes DESC, filename $limit");
When adding ROUND()  parameter sorting becomes more accurate

Title: Re: Top rated sorting bug
Post by: Joachim Müller on February 15, 2005, 06:24:08 am

http://forum.coppermine-gallery.net/index.php?topic=7315.0

Title: Re: Top rated sorting bug
Post by: Casper on February 16, 2005, 12:07:22 am

also http://forum.coppermine-gallery.net/index.php?topic=10009.0