From 2b0ffdbba7f00ed9e34a1b27ceaae11b202dd0ed Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Wed, 12 Feb 2025 00:43:17 +0100
Subject: Games that time out should result in "None" instead of resign.

Clean up resignation handling.

Prepare for collectively abandoning games as well.
---
 schema.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 5fd189e..041761b 100644
--- a/schema.sql
+++ b/schema.sql
@@ -173,6 +173,7 @@ create view rated_games_view as
 		and moves >= player_count * 3
 		and user_count = player_count
 		and player_count > 1
+		and result != 'None'
 		and not exists (
 			select 1 from players where players.game_id = games.game_id and user_id = 0
 		)
@@ -720,6 +721,7 @@ begin
 		set score = (
 			case
 				when new.result is null then null
+				when new.result = 'None' then null
 				when new.result = role then 2
 				when new.result = 'Draw' then 1
 				when instr(new.result, role) then 1
-- 
cgit v1.2.3

