summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2021-07-18 15:16:28 +0200
committerTor Andersson <tor@ccxvii.net>2021-07-18 15:16:28 +0200
commit4b39b1e0023d1470dd7abe2eb8eda54b41369516 (patch)
tree2c03cfc8cce53053a4600e099c99224386648318
parent3fd3139de657545dbb4de24f198f271237405f2f (diff)
downloadserver-4b39b1e0023d1470dd7abe2eb8eda54b41369516.tar.gz
Wait until game is at least 1 hour old before sending turn reminder.
-rw-r--r--server.js2
1 files changed, 1 insertions, 1 deletions
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");