From ed0e6a2ae0dee1e9eb26466d0ffaaf73a3cdf445 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Thu, 27 Jan 2022 01:05:11 +0100
Subject: Show user stats per-role.

---
 server.js | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'server.js')

diff --git a/server.js b/server.js
index c288bc3..5cd511c 100644
--- a/server.js
+++ b/server.js
@@ -265,6 +265,7 @@ const SQL_USER_STATS = SQL(`
 	select
 		title_name,
 		scenario,
+		role,
 		sum(role=result) as won,
 		count(*) as total
 	from
@@ -277,7 +278,8 @@ const SQL_USER_STATS = SQL(`
 		and game_id in (select game_id from opposed_games)
 	group by
 		title_name,
-		scenario
+		scenario,
+		role
 	`);
 
 function is_blacklisted(mail) {
-- 
cgit v1.2.3