forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: noworyz on December 06, 2005, 09:59:00 am

Title: Top rated Photos
Post by: noworyz on December 06, 2005, 09:59:00 am

Did something change with this new release dealing with top rated photos?

It seemed like before the update that the picture with the most votes was listed higher on the list and now it seems that the photo with the best score such as 5/5 is listed higher.

Title: Re: Top rated Photos
Post by: Nibbler on December 06, 2005, 12:36:39 pm

1.3

Code: [Select]

ORDER BY ROUND((pic_rating+1)/2000) DESC, votes DESC
1.4

Code: [Select]

ORDER BY pic_rating DESC, votes DESC, pid DESC
Different code, but the rating is still more important than the number of votes.

Title: Re: Top rated Photos
Post by: noworyz on December 06, 2005, 07:00:15 pm

Thanks, I just wanted to make sure that something wasn;t wrong with my install!