From e501808878702874c2b1bd121ece146cfcacdd52 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sat, 23 Mar 2024 02:00:12 +0100 Subject: Update game status and result after patching. --- tools/patchgame.js | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/tools/patchgame.js b/tools/patchgame.js index e191df8..c2b0802 100755 --- a/tools/patchgame.js +++ b/tools/patchgame.js @@ -16,6 +16,8 @@ let insert_snap = db.prepare("insert into game_snap(game_id,snap_id,replay_id,st let update_state = db.prepare("update game_state set state=? where game_id=?") let update_active = db.prepare("update games set active=? where game_id=?") +let update_result = db.prepare("update games set status=?, result=? where game_id=?") + const CRC32C_TABLE = new Int32Array([ 0x00000000, 0xf26b8303, 0xe13b70f7, 0x1350f3f4, 0xc79a971f, 0x35f1141c, 0x26a1e7e8, 0xd4ca64eb, 0x8ad958cf, 0x78b2dbcc, 0x6be22838, 0x9989ab3b, 0x4d43cfd0, 0xbf284cd3, 0xac78bf27, 0x5e133c24, @@ -178,6 +180,11 @@ function patch_game(game_id, {validate_actions=true, save_snaps=true, delete_und update_active.run(state.active, game_id) update_state.run(JSON.stringify(state), game_id) + if (state.state === "game_over") + update_result.run(2, state.result, game_id) + else + update_result.run(1, null, game_id) + db.exec("commit") } catch (err) { -- cgit v1.2.3