On the osu! website multiplayer games will generate a log of the session showing:
People joining
People leaving
Outcome of matches (including scores)
This would require a table storing:
Multiplayer games
Multiplayer game actions (leaving, joining, played, disbanded)
Multiplayer game sessions (result after a match containing game type, global mods, win condition, etc)
Scores (which we already have but would require us utilising soft deletes and storing failure state)
The real problem comes when trying to link a submitted score to a game, there are some options I've thought of:
Hopefully find something in the score submission request that tells us
Bancho looks up the most recent score (with some time cut off), this requires us to store every score but would allow us to support recent scores but feels very hacky
Utilise score frame from client to generate score based on it, though we don't wanna overstep on web so maybe store multiplayer scores in another table
On the osu! website multiplayer games will generate a log of the session showing:
This would require a table storing:
The real problem comes when trying to link a submitted score to a game, there are some options I've thought of:
This requires a fair bit of thought