From 6d541440787ff4ce37f4c779311bb48e90d8420c Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Mon, 1 Jan 2024 17:37:35 +0100 Subject: Don't count games that end early (resigned/timed out) in stats. --- server.js | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'server.js') diff --git a/server.js b/server.js index 9cf75c2..b6d3175 100644 --- a/server.js +++ b/server.js @@ -2935,11 +2935,9 @@ const SQL_GAME_STATS = SQL(` result, count(1) as n from - game_view + rated_games_view where - is_opposed - and ( status = ${STATUS_FINISHED} or status = ${STATUS_ARCHIVED} ) - and ( title_id not in ( select title_id from titles where is_symmetric ) ) + ( title_id not in ( select title_id from titles where is_symmetric ) ) group by title_id, player_count, -- cgit v1.2.3