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

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

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