Top Rated sorted by # of votes Top Rated sorted by # of votes
 

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 sorted by # of votes

Started by Juanito, June 08, 2005, 04:52:02 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

Juanito

June 08, 2005, 04:52:02 PM Last Edit: June 09, 2005, 10:42:45 PM by kegobeer
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!

Nibbler

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

Juanito

#2
June 09, 2005, 10:40:06 PM
thanx so much! works like a charm. wasn't expecting such a fast reply. thanks again!
Print
Go Up Pages1
User actions