Don't count unstarted games as "waiting" in header.

1 files changed, 1 insertions, 9 deletions

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