From cfcc9d74367beff6181ad27c8da73940abfdf4a9 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Mon, 21 Oct 2024 14:45:41 +0200 Subject: Don't list "closed" tournament seeds. --- server.js | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'server.js') diff --git a/server.js b/server.js index 10eafc0..fdc4b2c 100644 --- a/server.js +++ b/server.js @@ -2704,6 +2704,7 @@ const TM_SEED_LIST_ALL = SQL(` sum(level is 1) as queue_size, sum(user_id is ?) as is_queued from tm_seeds left join tm_queue using(seed_id) + where is_open group by seed_id order by seed_name `) @@ -2714,7 +2715,7 @@ const TM_SEED_LIST_TITLE = SQL(` sum(level is 1) as queue_size, sum(user_id is ?) as is_queued from tm_seeds left join tm_queue using(seed_id) - where title_id = ? + where title_id = ? and is_open group by seed_id order by seed_name `) -- cgit v1.2.3