I have installed the media press rating plugin.
Users are rating media, and I have added a widget to the sidebar to show the top 5 rated media (photos).
Looking in the DB i can see which are the highest rated media, however these are not the top 5 displayed in the widget.
I have cleared all caches and the Gallery page loads the sidebar and it still contains a selection of lesser rated media.
The media displayed have all at some point been rate 5*. But, some have been rated 5* multiple times. I expected a function somewhere to total the count of ratings ie 5* + 5* =10* and is displayed with priority over an image only rated once, even if it was rated 5*.
Any ideas how I can correct this behaviour? I would prefer to list the top 5 most highly rated photos.
Mediapress rating v1.1.1
Theme memberlite v4.5.2
Thank you for posting. Please look at the following resource showing how we calculating top rated medias
We just made a query with avg function to calculate the average rating for individual media.
Do you want to list media order by no. of users rated?. Please let me know.
thanks for the reply.
I think I understand why its giving the same five photos every time the page is loaded, I wonder if it might be better (to achieve what I want) to sum the ratings per media item, and display the top five of them.
so an item may be rated 5,5,3,4,5, giving it a total of 22 from 5 ratings. another may be 5,5 5 total 15 from 3 ratings. The item with 22 should be displayed before the one with 15. In this scenario the first item has an average of 4.4 whereas the second, only rated 3 times has an average of 5 and would have priority over a more often rated item.
hope that makes sense!
can you help?
Thank you for the details. I have added support for showing Top Rated media by total rating count. Please upgrade to latest version and check.
thanks for the rapid support, exceptional for a free plugin!
I have replaced all the files on the wp site with the new download.
Cleared all the cache, selected top rated in the widget.
The results are completely random.
Media Id Total Rating Expected Position Actual Position
4906 10 4/5 or 6 1
5569 10 4/5 or 6 2
5572 0 0 5
5727 25 2 Not Displayed
5728 10 4/5 or 6 Not Displayed
6026 0 0 3
6029 0 0 4
6044 10 4/5 or 6 Not Displayed
6045 20 3 Not Displayed
6283 35 1 Not Displayed
I cant see any correlation between upload date, uploader etc. (there are more results in the excel from the DB)
You must be logged in to reply to this topic.