Top rated Photos Top rated Photos
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Top rated Photos

Started by noworyz, December 06, 2005, 09:59:00 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

noworyz

December 06, 2005, 09:59:00 AM Last Edit: December 08, 2005, 08:24:28 AM by GauGau
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.

Nibbler

#1
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.

noworyz

#2
December 06, 2005, 07:00:15 PM
Thanks, I just wanted to make sure that something wasn;t wrong with my install!

Print
Go Up Pages1
User actions