Top rated Photos Top rated Photos
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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.

noworyz

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.3

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

1.4

ORDER BY pic_rating DESC, votes DESC, pid DESC

Different code, but the rating is still more important than the number of votes.

noworyz

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