Don't count games that end early (resigned/timed out) in stats.

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,