From 44c0cc0bbb11cd17a7c4833791784b0cb5dc6748 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sat, 25 Feb 2023 13:03:45 +0100
Subject: Count invites as active games in header.

---
 schema.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index a3c0e2b..07c51bb 100644
--- a/schema.sql
+++ b/schema.sql
@@ -113,6 +113,14 @@ create view user_dynamic_view as
 				status = 1
 				and players.user_id = users.user_id
 				and active in ( players.role, 'Both', 'All' )
+		) + (
+			select
+				count(*)
+			from
+				players
+			where
+				players.user_id = users.user_id
+				and players.is_invite
 		) as active,
 		is_banned
 	from
-- 
cgit v1.2.3

