summaryrefslogtreecommitdiff
path: root/server.js
diff options
context:
space:
mode:
Diffstat (limited to 'server.js')
-rw-r--r--server.js4
1 files changed, 3 insertions, 1 deletions
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) {