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. --- schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'schema.sql') 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 ( -- cgit v1.2.3