For the Victories statistic in !me and !best, the SQL queries need to know which games have been completed. Right now they check if a game has 5 rounds and assumes then that it is complete. This is wrong, because the game has 5 rounds at the start of the 5th round, so if you do !me before the round is complete, it will already count that game.
A possible solution is to add a state column to the games table which is switched to "finished" after the game results are calculated. Then the !me and !best queries can use that instead. It will likely also be faster than the current solution.
For the Victories statistic in !me and !best, the SQL queries need to know which games have been completed. Right now they check if a game has 5 rounds and assumes then that it is complete. This is wrong, because the game has 5 rounds at the start of the 5th round, so if you do
!mebefore the round is complete, it will already count that game.A possible solution is to add a
statecolumn to thegamestable which is switched to"finished"after the game results are calculated. Then the !me and !best queries can use that instead. It will likely also be faster than the current solution.