From 25279f5d6bbe3a55451faaf1dc830d4a0795a665 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Mon, 29 Apr 2024 09:46:23 +0200 Subject: Show more detail in rewind links. --- server.js | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'server.js') diff --git a/server.js b/server.js index e9baf8d..e13a227 100644 --- a/server.js +++ b/server.js @@ -1254,6 +1254,7 @@ const SQL_FINISH_GAME = SQL(` `) const SQL_REWIND_GAME = SQL("update games set status=1,moves=?,active=?,mtime=datetime() where game_id=?") +const SQL_SELECT_REWIND = SQL("select snap_id, state->>'$.active' as active, state->>'$.state' as state from game_snap where game_id=? order by snap_id desc") const SQL_UPDATE_GAME_ACTIVE = SQL("update games set active=?,mtime=datetime(),moves=moves+1 where game_id=?") const SQL_UPDATE_GAME_MOVES = SQL("update games set moves=? where game_id=?") @@ -1890,7 +1891,7 @@ app.get("/join/:game_id", function (req, res) { if (game.owner_id === req.user.user_id) friends = SQL_SELECT_CONTACT_FRIEND_NAMES.all(req.user.user_id) if (req.user.user_id === 1) - rewind = SQL_SELECT_SNAP_COUNT.get(game_id) + rewind = SQL_SELECT_REWIND.all(game_id) } let ready = (game.status === STATUS_OPEN) && is_game_ready(game.player_count, players) -- cgit v1.2.3