emuler wrote:It is even more complicated than that. The best link for a film is usually, but not always, the last link posted in that thread. Many of the older threads have started with a really bad VHSrip and slowly progressed through several iterations (VCD, DVD, HDTV, WebDL, BluRay) to an AI enhanced version. Does one just count the last release, or all the releases put together? After all, people were interested enough in the film to download several versions as and when they became available.
Right, I hadn't even considered that! In that case, I think the best way to go about it would be to sum the likes of all the posts in a topic and divide that number by the total amount of posts in the topic. That would essentially get you the average likes for the topic, which would make it comparable to any other regardless of how many posts (or different released versions of a movie) each of them have. So it would actually take
a lot more requests than I had anticipated: one per topic
page + one per forum page, although I reckon it would still be a fairly simple query with direct access to the database.
Thanks!
I originally intended to do this for myself to discover the most popular movies posted here (going by views, which is not ideal as they are not
unique views and can be easily manipulated by just refreshing the page, yet they're the next best thing to likes and a good enough approximation), but once I had it I immediately thought it might also be useful to the other members so I decided to share it with everyone.