From 76da927e841af2de8c47f2d0a177ecebb9c5b5f8 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Mon, 19 Jul 2021 17:18:27 +0200 Subject: Only list public games that the owner has joined. --- server.js | 10 ++++++++++ 1 file changed, 10 insertions(+) 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 `); -- cgit v1.2.3