Count invites as active games in header.

1 files changed, 8 insertions, 0 deletions

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