summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2021-06-19 13:19:33 +0200
committerTor Andersson <tor@ccxvii.net>2021-06-24 14:44:14 +0200
commitfb2f62ad6910f6514677b589bfc063c5fcf22558 (patch)
tree6bcfae6356d2b8cf93910599e702fc2f4bf5a374
parent84f49ec5097cd6b2d227fcd53b0c8e39845873a7 (diff)
downloadserver-fb2f62ad6910f6514677b589bfc063c5fcf22558.tar.gz
There can be only one rematch per game.
-rw-r--r--server.js2
1 files changed, 1 insertions, 1 deletions
diff --git a/server.js b/server.js
index 3d2213f..953c000 100644
--- a/server.js
+++ b/server.js
@@ -680,7 +680,7 @@ const QUERY_REMATCH_CREATE = db.prepare(`
$user_id, title_id, scenario, private, random, datetime('now'), datetime('now'), $magic, 0, NULL, '[]'
FROM games
WHERE game_id = $game_id AND NOT EXISTS (
- SELECT * FROM games WHERE status=0 AND description=$magic
+ SELECT * FROM games WHERE description=$magic
)
`);