diff options
author | Tor Andersson <tor@ccxvii.net> | 2021-07-18 15:16:28 +0200 |
---|---|---|
committer | Tor Andersson <tor@ccxvii.net> | 2021-07-18 15:16:28 +0200 |
commit | 4b39b1e0023d1470dd7abe2eb8eda54b41369516 (patch) | |
tree | 2c03cfc8cce53053a4600e099c99224386648318 | |
parent | 3fd3139de657545dbb4de24f198f271237405f2f (diff) | |
download | server-4b39b1e0023d1470dd7abe2eb8eda54b41369516.tar.gz |
Wait until game is at least 1 hour old before sending turn reminder.
-rw-r--r-- | server.js | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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"); |