diff options
author | Tor Andersson <tor@ccxvii.net> | 2022-05-22 16:46:06 +0200 |
---|---|---|
committer | Tor Andersson <tor@ccxvii.net> | 2022-05-22 16:46:36 +0200 |
commit | d721c8755e5fd5c8398d4f965070f89dd549b258 (patch) | |
tree | 9656e5353cab1a10e13bfb56fdd08a32d7df0650 /server.js | |
parent | ea9492b6387e74771c00e3b3a1971c8b4dcb7a81 (diff) | |
download | server-d721c8755e5fd5c8398d4f965070f89dd549b258.tar.gz |
Don't require owner to have joined public games.
Required for tournament games (where administrator is the owner) to show.
Diffstat (limited to 'server.js')
-rw-r--r-- | server.js | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -940,14 +940,14 @@ const SQL_INSERT_REMATCH = SQL(` const QUERY_LIST_GAMES = SQL(` SELECT * FROM game_view WHERE is_private=0 AND status=? - AND EXISTS ( SELECT 1 FROM players WHERE players.game_id = game_view.game_id AND user_id = game_view.owner_id ) + AND EXISTS ( SELECT 1 FROM players WHERE players.game_id = game_view.game_id ) ORDER BY mtime DESC `); const QUERY_LIST_GAMES_OF_TITLE = SQL(` SELECT * FROM game_view WHERE is_private=0 AND title_id=? AND status=? - AND EXISTS ( SELECT 1 FROM players WHERE players.game_id = game_view.game_id AND user_id = game_view.owner_id ) + AND EXISTS ( SELECT 1 FROM players WHERE players.game_id = game_view.game_id ) ORDER BY mtime DESC LIMIT ? `); |