From 44c0cc0bbb11cd17a7c4833791784b0cb5dc6748 Mon Sep 17 00:00:00 2001 From: Tor Andersson 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(+) 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