From 420badd2916809e7b5048f3138f132e5bebfe636 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Thu, 22 Aug 2024 18:21:14 +0200
Subject: Don't count unstarted games as "waiting" in header.

---
 schema.sql | 10 +---------
 1 file changed, 1 insertion(+), 9 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 9df5b93..14b3096 100644
--- a/schema.sql
+++ b/schema.sql
@@ -144,15 +144,7 @@ create view user_dynamic_view as
 			where
 				owner_id = users.user_id
 				and status = 0
-				and (
-					join_count = 0
-					or (
-						join_count = player_count
-						and not exists (
-							select 1 from players where players.game_id = games.game_id and players.is_invite
-						)
-					)
-				)
+				and join_count = 0
 		) as waiting,
 		is_banned
 	from
-- 
cgit v1.2.3

