From fb2f62ad6910f6514677b589bfc063c5fcf22558 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sat, 19 Jun 2021 13:19:33 +0200 Subject: There can be only one rematch per game. --- server.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 ) `); -- cgit v1.2.3