see highest/lowest winrate teammates (bayer)

[albertlyuan]

op.gg?

[Nbayer2011]

Basically have a section when looking at an individual player's last recorded games, in the previous x games (5,10,20, etc.), show the most frequent teammates/their win rate together. Would also need a minimum number of games of the previous x games to show up.

[Nbayer2011]

[albertlyuan]

things to consider:

• do we create a new table that tracks winrates betwee each player?
• how many players are in "recently played with"

currently tables are the following schema:

• games //game information
  • game_id (int)
    • loser_1 (UID)
    • loser_2 (UID)
    • loser_3 (UID)
    • winner_1 (UID)
    • winner_2 (UID)
    • winner_3 (UID)
    • timestamp (str)
    • winner_pulled (bool)
• player_history //history of players elo & wins
  • (uid)
    • game_id (int)
    • elo (int)
    • game_id (int)
    • losses (int)
    • name (uid)
    • timestamp (str)
    • wins (int)
• player_now //the players current stats
  • (uid)
    • most_recent_game (int)
    • elo (float)
    • wins (int)
    • losses (int)
• player_uid //mapping from display name to uid
  • name (str)

[Nbayer2011]

On op.gg and other sites they have a separate table like in the screenshot. On op.gg they use the last 20 games and that usually works pretty well with team size. My thinking was that we could reduce the number of recent games because mini sessions have so many frequent games across teammates with there being a small sample size of players to choose from in each session. Maybe like last 10 games and make the minimum number of games played together like 3 or 4?

[albertlyuan]

go ahead, dont forget to make new branch, lmk if any questions on how to do stuff. heres my js cheatsheet https://docs.google.com/document/d/1TOcJr4qtyhYfjY3BzNRYofMSqvqI8fqlA81uBQU65mY/edit?usp=sharing