diff options
| author | Tor Andersson <tor@ccxvii.net> | 2022-01-27 01:05:11 +0100 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2022-01-27 01:05:35 +0100 |
| commit | ed0e6a2ae0dee1e9eb26466d0ffaaf73a3cdf445 (patch) | |
| tree | 4044fe43210deda3371c1d4c1dfcbd587b927671 /server.js | |
| parent | 3995598069f086594c539fca75aee583861b9406 (diff) | |
| download | server-ed0e6a2ae0dee1e9eb26466d0ffaaf73a3cdf445.tar.gz | |
Show user stats per-role.
Diffstat (limited to 'server.js')
| -rw-r--r-- | server.js | 4 |
1 files changed, 3 insertions, 1 deletions
@@ -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) { |