Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Top rated Photos  (Read 5077 times)

0 Members and 1 Guest are viewing this topic.

noworyz

  • Contributor
  • Coppermine regular visitor
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 76
    • eGriz.com
Top rated Photos
« 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.
« Last Edit: December 08, 2005, 08:24:28 am by GauGau »
Logged

Nibbler

  • Guest
Re: Top rated Photos
« Reply #1 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.
Logged

noworyz

  • Contributor
  • Coppermine regular visitor
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 76
    • eGriz.com
Re: Top rated Photos
« Reply #2 on: December 06, 2005, 07:00:15 pm »

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

Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.