From 6d541440787ff4ce37f4c779311bb48e90d8420c Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Mon, 1 Jan 2024 17:37:35 +0100
Subject: Don't count games that end early (resigned/timed out) in stats.

---
 schema.sql | 2 +-
 server.js  | 6 ++----
 2 files changed, 3 insertions(+), 5 deletions(-)

diff --git a/schema.sql b/schema.sql
index 617c809..cd3be42 100644
--- a/schema.sql
+++ b/schema.sql
@@ -169,7 +169,7 @@ create view rated_games_view as
 		games
 	where
 		status > 1
-		and moves > 5
+		and moves > 6
 		and user_count = player_count
 		and player_count > 1
 		and not exists (
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