From d288108a7d294389a21a3df9d3f7fbcc5697ffac Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Thu, 14 Mar 2024 20:03:52 +0100 Subject: Add and track score in player/role assignment. 2 points for a win, 1 point for a tie, 0 points for a loss. --- server.js | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'server.js') diff --git a/server.js b/server.js index 7ab5214..e9baf8d 100644 --- a/server.js +++ b/server.js @@ -3143,7 +3143,7 @@ const SQL_USER_STATS = SQL(` titles.title_name, scenario, role, - sum(role=result) as won, + sum(score) / 2 as won, count(*) as total from players @@ -3163,7 +3163,7 @@ const SQL_USER_STATS = SQL(` titles.title_name, scenario, null as role, - sum(role=result) as won, + sum(score) / 2 as won, count(*) as total from players -- cgit v1.2.3