Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Top Rated sorted by # of votes  (Read 4295 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.02 seconds with 19 queries.