forum.coppermine-gallery.net

No Support => Feature requests => Topic started by: nickelas on August 25, 2011, 10:59:35 am

Title: Default sort order for files - rated
Post by: nickelas 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/ (http://uppsalafoto.se/galleri/)

Title: Re: Default sort order for files - rated
Post by: emerym 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

Title: Re: Default sort order for files - rated
Post by: Αndré on August 30, 2011, 04:52:50 pm

Quote from: emerym 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.

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.

Quote from: nickelas 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.

Valid feature request.