Upgraded from cpg 1.3.4 to 1.4.3. I was running Kubrick on 1.3.4, but had to switch themes. What I noticed is that some of my top_rated pics are no longer top rated. There are pics in my user_galleries with 102 votes and 73 votes, and my top rated starts at 19 votes and goes lower for the entire site. It doesn't even contain my 102 votes pic.
link?
http://www.fiwishop.com/cpg/cpg1/index.php
Look at the bottom you see the top rated. However, if you look at this album
http://www.fiwishop.com/cpg/cpg1/thumbnails.php?album=11
and press Top Rated, you will notice that the top rated is not in the correct order. You will also notice that the highest # of votes is 102 votes, and on the main page, the highest is 19 votes.
looks fine to me: in top-rated, the sort order is by results, not by number of votes.
How do I change it to by number of votes.
include/functions.inc.php
$query = "SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' AND votes >= '{$CONFIG['min_votes_for_rating']}' $META_ALBUM_SET ORDER BY pic_rating DESC, votes DESC, pid DESC $limit";
Change it to whatever you like.
Re-Ordered the last two items, put Votes Desc before pic_rating Desc, and all's fine and dandy.
Quote from: marcamillion on January 02, 2006, 11:44:31 AM
Upgraded from cpg 1.3.4 to 1.4.3. I was running Kubrick on 1.3.4, but had to switch themes.
I have just released the Theme "Kubrick" for cpg1.4.x (http://forum.coppermine-gallery.net/index.php?topic=28715.0)