From 6a72d2b30417c68e74b77d8dc6699573f9e033d5 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Fri, 5 Aug 2022 22:17:10 +0200 Subject: Fix patchgame script. --- tools/patchgame.js | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/tools/patchgame.js b/tools/patchgame.js index 1eeaf9c..86c0580 100644 --- a/tools/patchgame.js +++ b/tools/patchgame.js @@ -13,7 +13,7 @@ let db = new sqlite3("./db"); let game_id = process.argv[2]; let title_id = db.prepare("select title_id from games where game_id=?").pluck().get(game_id); let rules = require("../public/" + title_id + "/rules.js"); -let log = db.prepare("select rowid,* from game_replay where game_id=?").all(game_id); +let log = db.prepare("select * from game_replay where game_id=?").all(game_id); let save = db.prepare("select state from game_state where game_id=?").pluck().get(game_id); fs.writeFileSync("backup-" + game_id + ".txt", save); @@ -40,5 +40,5 @@ db.prepare("update game_state set active=?, state=? where game_id=?").run(game.a if (i < log.length) { console.log("BROKEN ENTRIES: %d", log.length-i); - console.log(`sqlite3 db "delete from game_replay where game_id=${game_id} and rowid>=${log[i].rowid}"`); + console.log(`sqlite3 db "delete from game_replay where game_id=${game_id} and replay_id>=${log[i].replay_id}"`); } -- cgit v1.2.3