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: Default sort order for files - rated  (Read 4968 times)

0 Members and 1 Guest are viewing this topic.

nickelas

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 114
Default sort order for files - rated
« on: August 25, 2011, 10:59:35 am »

It would be most useful to be able to set the "Default sort order for files" to the rating of pictures.
Thanks,
http://uppsalafoto.se/galleri/
Logged
Human

emerym

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Default sort order for files - rated
« Reply #1 on: August 26, 2011, 12:56:14 pm »

Also, when showing the Top Rated, can the code take into account the vote and number of votes? At the moment the most voted image being given 5 stars is not first in the list.

Thanks, Mark
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Default sort order for files - rated
« Reply #2 on: August 30, 2011, 04:52:50 pm »

Also, when showing the Top Rated, can the code take into account the vote and number of votes? At the moment the most voted image being given 5 stars is not first in the list.
That's technically already the case:
Code: [Select]
ORDER BY pic_rating $DESC, r.votes $DESC, pid $DESC
As Coppermine won't display half stars it always rounds the vote result. The picture which is displayed at the first position is the picture with the best average voting.


Please don't hijack threads. It appears that your your post is related to the topic, but unfortunately it isn't and just clutters this feature request.




It would be most useful to be able to set the "Default sort order for files" to the rating of pictures.
Valid feature request.
Logged
Pages: [1]   Go Up
 

Page created in 0.026 seconds with 20 queries.