I’d be happy to help. I’ve done it in the past for some years but got overwhelmed. I figure each of us could take an award or two at a time and update it? I can start with the “best individual” awards. As for the template, hopefully someone with access will see this.
Just finished Best Individual NPC. Now I remember why I stopped; it’s pretty tedious! Glad that someone’s on this. I’ll keep going with more ‘best individual’ stuff; Puzzle was already done earlier this year.
Edit: Just did Best individual PC. Going to stop for now, let other people work on it. If it’s not done by the time others run out of steam, I’ll add the rest.
Thanks for sending your usernames. You can now edit templates.
If each year’s XYZZY page were to have an event infobox – edit or create the page with Form:Event to add one – and each page were to have an award called, say, “Best individual NPC” then a simple query could list every year and game winning the award of that name.
I remembered that some Spring Thing event pages have infoboxes mentioning prize winners, so just now added a database query showing the “Best in show” ribbon winners for each year: https://www.ifwiki.org/Spring_Thing#Best_in_Show. I hope that helps to show what’s possible.
Yes I think so. It depends on how detailed you want each list to be. At the minute the query will only return the game name (not additional information like “Glulx”, or even author). Our big job for 2023 will be adding a database structure for games, which should improve that situation.
Yes I think I it could. As long as you pick a consistent name for the awards (eg “Best Game winner” and “Best Game finalist”) then you could formulate a query to show all XYZZY events with awards of that name.
This should be easy. On the XYZZY 2019 page you’d have these awards: (1) “Best Game winner” (Creme de la Creme); (2) “Best game finalist” (separate entries for Skybreak, Turandot, Zozzled). We would just understand that the winner was also a finalist.
An optional “Notes” column might be good here. It would work to describe the puzzle, and might work in other circumstances too. The awards on the relevant XYZZY year pages could be “Best puzzle finalist” and “Best puzzle winner”. Once you’ve got that, the queries should be easy to write.
This is something you could change now as it’s not related to the database. Until we sort out the games database/table the queries couldn’t replicate what’s there. So you might as well make the change manually. Even with the “Notes” column, instead of
I guess you could use the Notes column to add any of this information, but it really belongs more to the game than to the award or event, so it would be better to wait until we sort out the game database table.