From 4b39b1e0023d1470dd7abe2eb8eda54b41369516 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sun, 18 Jul 2021 15:16:28 +0200 Subject: Wait until game is at least 1 hour old before sending turn reminder. --- server.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/server.js b/server.js index 0e934df..264ef6e 100644 --- a/server.js +++ b/server.js @@ -1008,7 +1008,7 @@ const QUERY_LIST_YOUR_TURN = db.prepare(` FROM games JOIN players ON games.game_id = players.game_id AND ( games.active = players.role OR games.active = 'Both' OR games.active = 'All' ) JOIN users ON users.user_id = players.user_id AND users.notifications = 1 - WHERE games.status = 1 AND datetime('now') > datetime(games.mtime, '+1 minute') + WHERE games.status = 1 AND datetime('now') > datetime(games.mtime, '+1 hour') `); const QUERY_LIST_UNSTARTED_GAMES = db.prepare("SELECT * FROM game_view WHERE status = 0"); -- cgit v1.2.3