summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--server.js10
1 files changed, 10 insertions, 0 deletions
diff --git a/server.js b/server.js
index 4b909b8..7c9de8e 100644
--- a/server.js
+++ b/server.js
@@ -552,6 +552,11 @@ const QUERY_LIST_GAMES_OF_TITLE = db.prepare(`
) AS is_your_turn
FROM game_view
WHERE title_id = $title_id AND private = 0
+ AND EXISTS (
+ SELECT 1 FROM players
+ WHERE players.game_id = game_view.game_id
+ AND user_id = game_view.owner_id
+ )
ORDER BY status ASC, mtime DESC
`);
@@ -1432,6 +1437,11 @@ const QUERY_LIST_GAMES = db.prepare(`
) AS is_your_turn
FROM game_view
WHERE private = 0 AND status < 2
+ AND EXISTS (
+ SELECT 1 FROM players
+ WHERE players.game_id = game_view.game_id
+ AND user_id = game_view.owner_id
+ )
ORDER BY status ASC, mtime DESC
`);