summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2023-12-10 18:49:57 +0100
committerTor Andersson <tor@ccxvii.net>2023-12-10 18:49:57 +0100
commitfd29d12bca9b432eb42ec3fecdac28ffdb4393d1 (patch)
tree118d95a7d1cf8b35c585a19febe7d9894627ecf5
parentadee63783dca7a8fae75cb4f8ac3889cef07469a (diff)
downloadserver-fd29d12bca9b432eb42ec3fecdac28ffdb4393d1.tar.gz
Don't show abandoned games.
-rw-r--r--server.js2
1 files changed, 1 insertions, 1 deletions
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
`)