User:Dessertmonkeyjk/sandbox

Handling Single and Team stats
With single tournaments, stats are tracked per competitor. With team tournaments however, this needs to handled differently and separate from single competitor stats themselves, partly to make getting team stats easier and reduce the headache that is filtering them out when querying them on competitor pages.

Plan is to first store teams in a new TeamsInfo table (either when they're first introduced or on their own Teams page), listing the team name and members in it. Afterwards, any match scores for the team are to be stored in TournamentTeamScores table. This works similar to how CompetitorInfo and TournamentCompetitorScores tables are handled.

Teams stats will then be query similar to competitors, but could be handled in two different ways. Either they're queried on a unique Teams page or on existing Competitor pages with additional steps. In case of Competitors, first need to filter based on what Teams they're in and then if the Team participated in tournament/event in question. Afterwards, it's just a matter of getting score data (win/loss/etc).

Mainly writing this down for reference later, a bit to keep track of. Also Team pages seems like a good idea since they keep reoccuring in multiple events.

Cargo Competitor query, tournament series
There's a growing need to filter Cargo competitor table by tournament series as it now stands on the wiki. Otherwise ISGP stats can be mixed up with IAS stats as well. Using the series parameter in the Infobox template for tournaments, hopefully, it can be sorted properly

Example 1 - Filter Al Molloy results for International Spyro Grand Prix series

Example 2 - Filter Al Molloy results for I'm A Speedrunner series

Example 3 - Filter Al Molloy results for I'm A Speedrunner (IAS8)

ISGP video playlist
YouTube playlist of ISGP ... videos

Cargo Competitor Table Lookup
Using Cargo to store competitor stats and pair up past aliases/usernames shared by them, it's possible to look up competitor scores easily for reference. Personally using this for now to quickly look up stats and check it against current stats on competitor pages as I plan to convert statistic tables to be driven by Cargo data.

Adding dates together
Using the Age_in_days template on its own will output the number of days between one or more dates. Tested how adding mutiple days using the output of this template works out to solve the need for it in pages such as ISGP Exhibition Championship.

(Days between 03/05/21 and 04/19/21) (Days between 04/28/21 and 05/05/21)

(Sum of days above)

Note: For some reason this template does not respect line breaks for whatever reason.