From 3fd3139de657545dbb4de24f198f271237405f2f Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sat, 17 Jul 2021 01:15:47 +0200 Subject: Set game modified time when it is started. --- server.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'server.js') diff --git a/server.js b/server.js index e5658c9..0e934df 100644 --- a/server.js +++ b/server.js @@ -612,7 +612,7 @@ const QUERY_IS_RANDOM = db.prepare("SELECT random FROM games WHERE game_id = ?") const QUERY_JOIN_GAME_TRY = db.prepare("INSERT OR IGNORE INTO players (user_id, game_id, role) VALUES (?,?,?)"); const QUERY_JOIN_GAME = db.prepare("INSERT INTO players (user_id, game_id, role) VALUES (?,?,?)"); const QUERY_PART_GAME = db.prepare("DELETE FROM players WHERE game_id = ? AND role = ?"); -const QUERY_START_GAME = db.prepare("UPDATE games SET status = 1, state = ?, active = ? WHERE game_id = ?"); +const QUERY_START_GAME = db.prepare("UPDATE games SET status = 1, state = ?, active = ?, mtime = datetime('now') WHERE game_id = ?"); const QUERY_CREATE_GAME = db.prepare(` INSERT INTO games (owner_id,title_id,scenario,private,random,ctime,mtime,description,status,state) -- cgit v1.2.3