5 stack win rate

[Haiethan1]

Have a command or add it to post match stats if it is a 5 stack and competitive. should run along the lines of

• check all of the games for the last two months
• run a query for a sorted games where there are 5 different users in the same match id
• sort through and create a mapping of which 5 users are in each game and calculate winrate

OR

• check only the 5 users queried. Either the 5 in the 5 stack, or 5 from a command
• run a query for all games in the last two months that the 5 stack have in common
• calculate winrate

[Haiethan1]

For the first option, we can create a table to store this information. maybe something like StackMatchStats where we have stack_size, stack_key (* more info below), match_date_utc, win/loss, etc if we need more

• stack_key can be an enum or a table named UserStacks of columns stack_key (PK), user_ids (alphabetically), last_match_date_utc

in both tables we will clear the rows after 2 months.