From 420badd2916809e7b5048f3138f132e5bebfe636 Mon Sep 17 00:00:00 2001 From: Tor Andersson 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