diff options
author | Tor Andersson <tor@ccxvii.net> | 2024-10-21 14:45:41 +0200 |
---|---|---|
committer | Tor Andersson <tor@ccxvii.net> | 2024-10-21 14:45:41 +0200 |
commit | cfcc9d74367beff6181ad27c8da73940abfdf4a9 (patch) | |
tree | 3d5358629b7039e5188363e8c1c07189cb9a777c /server.js | |
parent | 419b6653b5177e599558991aaa6dbe71803a0f87 (diff) | |
download | server-cfcc9d74367beff6181ad27c8da73940abfdf4a9.tar.gz |
Don't list "closed" tournament seeds.
Diffstat (limited to 'server.js')
-rw-r--r-- | server.js | 3 |
1 files changed, 2 insertions, 1 deletions
@@ -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 `) |