Problems with Top Rated Images

[marcamillion]

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.

[Joachim Müller]

link?

[marcamillion]

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.

[Joachim Müller]

looks fine to me: in top-rated, the sort order is by results, not by number of votes.

[marcamillion]

How do I change it to by number of votes.

[Nibbler]

include/functions.inc.php

Code Select Expand

$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.

[marcamillion]

Re-Ordered the last two items, put Votes Desc before pic_rating Desc, and all's fine and dandy.

[Joachim Müller]

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