forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: marcamillion on January 02, 2006, 11:44:31 am

Title: Problems with Top Rated Images
Post by: 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. 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.

Title: Re: Problems with Top Rated Images
Post by: Joachim Müller on January 02, 2006, 12:31:33 pm

link?

Title: Re: Problems with Top Rated Images
Post by: marcamillion on January 03, 2006, 03:04:52 am

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.

Title: Re: Problems with Top Rated Images
Post by: Joachim Müller on January 03, 2006, 08:04:27 am

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

Title: Re: Problems with Top Rated Images
Post by: marcamillion on January 03, 2006, 06:18:35 pm

How do I change it to by number of votes.

Title: Re: Problems with Top Rated Images
Post by: Nibbler on January 03, 2006, 06:42:42 pm

include/functions.inc.php

Code: [Select]

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

Title: Re: Problems with Top Rated Images
Post by: marcamillion on January 03, 2006, 07:08:43 pm

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

Title: Re: Problems with Top Rated Images
Post by: Joachim Müller on March 07, 2006, 09:38:21 am

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)