Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Problems with Top Rated Images  (Read 5319 times)

0 Members and 1 Guest are viewing this topic.

marcamillion

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 110
Problems with Top Rated Images
« 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.
« Last Edit: January 03, 2006, 07:43:59 pm by Nibbler »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Problems with Top Rated Images
« Reply #1 on: January 02, 2006, 12:31:33 pm »

link?
Logged

marcamillion

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 110
Re: Problems with Top Rated Images
« Reply #2 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Problems with Top Rated Images
« Reply #3 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.
Logged

marcamillion

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 110
Re: Problems with Top Rated Images
« Reply #4 on: January 03, 2006, 06:18:35 pm »

How do I change it to by number of votes.
Logged

Nibbler

  • Guest
Re: Problems with Top Rated Images
« Reply #5 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.
Logged

marcamillion

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 110
Re: Problems with Top Rated Images
« Reply #6 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Problems with Top Rated Images
« Reply #7 on: March 07, 2006, 09:38:21 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
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.