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 sorted by # of votes  (Read 4952 times)

0 Members and 1 Guest are viewing this topic.

Juanito

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Top Rated sorted by # of votes
« on: June 08, 2005, 04:52:02 pm »

i tried searching the forums for this, but no luck. i'm trying to sort the Top Rated page by the highest number of votes to the lowest, instead of by the highest rated to lowest rated. any help is appreciated. thanks!
« Last Edit: June 09, 2005, 10:42:45 pm by kegobeer »
Logged

Nibbler

  • Guest
Re: Top Rated sorted by # of votes
« Reply #1 on: June 08, 2005, 04:55:17 pm »

open functions.inc.php, search for toprated, change the ordering in the query from

Code: [Select]
ORDER BY ROUND((pic_rating+1)/2000) DESC, votes DESC, filename
to

Code: [Select]
ORDER BY votes DESC, filename
Logged

Juanito

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 32
Re: Top Rated sorted by # of votes
« Reply #2 on: June 09, 2005, 10:40:06 pm »

thanx so much! works like a charm. wasn't expecting such a fast reply. thanks again!
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.