Conversation Between Yoda and Daniel M
Showing Comments 5 to 8 of 24
-
12-30-22Oh cool, yeah I get you! That makes a lot more sense to have a table of entries and then just grab the data when needed to get the final top 100 or ranked table. Sounds like the process for the host then is a lot more straightforward now - not trying to take away from the task - but more a question of thread presentation, sorting out posts etc.
Ah cool, I don't know how much interest I have in war films personally but I'll keep an eye on what the forum decides next and have a think anyway
-
12-29-22Assuming I'm understanding correctly, it already does that. It logs every single film on every ballot as individual rows in a database. It doesn't iterate anything, though, it just counts them dynamically as needed (ditto on point totals, which aren't stored anywhere but are simply calculated from the rankings on request).
The ballot table contains the userid, the TMDB id, the film's rank on the ballot, the total number of films on the ballot it was part of (so we can de-weight shorter ballots), and the time submitted.
Before wiping the table clean for the next countdown I copy and rename it, so it's all preserved at the same level of detail, theoretically allowing us to count all sorts of stuff across countdowns, at least from the point we started doing it this way.
As for next list, not sure. Presumably another genre list. War films was a close second last time, I think? -
12-29-22Potentially in the future! Although we're running out of lists to do
Looking back through the 60s thread and I'm loving the graphics I made, even a GIF for the header image... I must have had loads of time on my hands back then.
I love the additions you've brought in, the differentiated post types for the actual film reveals and even the list submission form. I'm guessing in the future you could get that so the post submission as well as just sending a PM to the host and sender, you could fire off to an online database like MySQL where you'd have three columns, a film ID from themoviedb, points which we add to each time and lists which we increment by 1?
I haven't worked in PHP in ages and use C# nowadays but could potentially give a hand with that as the process will be the same so will just come down to syntax. Like I said though we've worked our way through most of these lists anyway... are the any ideas what the next one could be?
Dynamic stuff can go too far. When I started programming my data wasn't normalized at all. Then I learned about joins and grabbing things on the fly and did that for everything...until it reached a certain level of traffic and/or complexity, at which point it can be necessary to go back to caching, to repeating data, in select circumstances. Kinda comes full circle like that. But in this case it goes very fast without caching.