From 70bf508aaf09447da1102f8701275430d05cf5ae Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sun, 23 Feb 2025 00:46:37 +0100 Subject: Only show recently finished tournaments in the pool list. --- server.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/server.js b/server.js index 34b2ed9..3bc3e13 100644 --- a/server.js +++ b/server.js @@ -2959,7 +2959,7 @@ const TM_POOL_LIST_TITLE_FINISHED = SQL(` `) const TM_POOL_LIST_SEED_ACTIVE = SQL("select * from tm_pool_active_view where seed_id = ?") -const TM_POOL_LIST_SEED_FINISHED = SQL("select * from tm_pool_finished_view where seed_id = ?") +const TM_POOL_LIST_SEED_FINISHED = SQL("select * from tm_pool_finished_view where seed_id = ? and finish_date > date('now', '-14 days')") const TM_SELECT_QUEUE_BLACKLIST = SQL(` with qq as ( -- cgit v1.2.3