summaryrefslogtreecommitdiff
path: root/server.js
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2024-10-21 14:45:41 +0200
committerTor Andersson <tor@ccxvii.net>2024-10-21 14:45:41 +0200
commitcfcc9d74367beff6181ad27c8da73940abfdf4a9 (patch)
tree3d5358629b7039e5188363e8c1c07189cb9a777c /server.js
parent419b6653b5177e599558991aaa6dbe71803a0f87 (diff)
downloadserver-cfcc9d74367beff6181ad27c8da73940abfdf4a9.tar.gz
Don't list "closed" tournament seeds.
Diffstat (limited to 'server.js')
-rw-r--r--server.js3
1 files changed, 2 insertions, 1 deletions
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
`)