From 2b0ffdbba7f00ed9e34a1b27ceaae11b202dd0ed Mon Sep 17 00:00:00 2001 From: Tor Andersson 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