From 8019fe4e78a2ce4b03f3b2d2d11458f59a0224ad Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sun, 17 Nov 2024 23:13:44 +0100
Subject: handle deleted players in tournament pool display

---
 server.js | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'server.js')

diff --git a/server.js b/server.js
index 1443611..175a517 100644
--- a/server.js
+++ b/server.js
@@ -2798,7 +2798,7 @@ const TM_SELECT_GAMES = SQL(`
 		tm_rounds.*,
 		games.status,
 		games.moves,
-		json_group_object(role, name) as role_names,
+		json_group_object(role, coalesce(name, 'null')) as role_names,
 		json_group_object(role, score) as role_scores
 	from
 		tm_rounds
@@ -2819,8 +2819,8 @@ const TM_SELECT_PLAYERS_2P = SQL(`
 			select
 				pool_id,
 				u1.user_id as user_id,
-				u1.name as name,
-				u2.name as opponent,
+				coalesce(u1.name, 'null') as name,
+				coalesce(u2.name, 'null') as opponent,
 				json_group_array(json_array(game_id, p1.score)) as result
 			from
 				tm_rounds
-- 
cgit v1.2.3