From fd29d12bca9b432eb42ec3fecdac28ffdb4393d1 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sun, 10 Dec 2023 18:49:57 +0100 Subject: Don't show abandoned games. --- server.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'server.js') diff --git a/server.js b/server.js index e852ca9..ba339fe 100644 --- a/server.js +++ b/server.js @@ -1322,7 +1322,7 @@ const QUERY_LIST_GAMES_OF_TITLE_READY = SQL(` `) const QUERY_LIST_GAMES_OF_TITLE_REPLACEMENT = SQL(` - select * from game_view where title_id=? and not is_private and status=1 and join_count < player_count + select * from game_view where title_id=? and not is_private and status=1 and join_count > 0 and join_count < player_count and not exists ( select 1 from contacts where me = owner_id and you = ? and relation < 0 ) order by mtime desc, ctime desc `) -- cgit v1.2.3