From 75566438c2ba942abf3849b724e318cfa050f1ad Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Fri, 22 Dec 2023 17:32:02 +0100
Subject: Move more player/game info stuff into SQL.

Update invite_count with triggers.

Add games.is_ready generated column.
Add games.is_opposed generated column.

Add player_view with is_active column.
---
 views/head.pug | 15 ++++-----------
 views/join.pug |  2 +-
 2 files changed, 5 insertions(+), 12 deletions(-)

(limited to 'views')

diff --git a/views/head.pug b/views/head.pug
index 77ab73b..e47033a 100644
--- a/views/head.pug
+++ b/views/head.pug
@@ -61,14 +61,10 @@ mixin gamelist(list,hide_title=0)
 					else if (item.status === 2) className += " finished"
 					else if (item.status === 3) className += " archived"
 					if (item.is_unread) chat_icon = "\u{1f4dd}"
-					if (item.pace === 0) pace_icon = "", pace_text = ""
+					if (item.is_match) pace_icon = EMOJI_MATCH
 					else if (item.pace === 1) pace_icon = EMOJI_LIVE, pace_text = "Live!"
 					else if (item.pace === 2) pace_icon = EMOJI_FAST, pace_text = "Fast - many moves per day"
 					else if (item.pace === 3) pace_icon = EMOJI_SLOW, pace_text = "Slow - one move per day"
-					let invite_count = 0
-					for (let p of item.players)
-						if (p.is_invite)
-							invite_count++
 
 				div(class=className)
 					div.game_head
@@ -81,12 +77,9 @@ mixin gamelist(list,hide_title=0)
 
 						case item.status
 							when 0
-								if item.join_count === item.player_count
-									a(class="command" href=`/join/${item.game_id}`) Start
-								else
-									a(class="command" href=`/join/${item.game_id}`) Join
+								a(class="command" href=`/join/${item.game_id}`) Join
 							when 1
-								if item.join_count !== item.player_count || invite_count > 0
+								if !item.is_ready
 									a(class="command" href="/join/"+item.game_id) Join
 								else if item.is_yours
 									if item.your_role
@@ -124,7 +117,7 @@ mixin gamelist(list,hide_title=0)
 								when 0
 									div Created: #{item.ctime}
 								when 1
-									div Changed: #{item.mtime}
+									div Last move: #{item.mtime}
 								when 2
 									div Finished: #{item.mtime}
 									div Result: !{item.result}
diff --git a/views/join.pug b/views/join.pug
index 2fc9287..37c245b 100644
--- a/views/join.pug
+++ b/views/join.pug
@@ -57,7 +57,7 @@ html
 			if game.status > 1
 				p Finished #{game.mtime}.
 			else if game.status > 0
-				p Last changed #{game.mtime}.
+				p Last move #{game.mtime}.
 
 			unless game.human_options === "None"
 				p Options: #{game.human_options}.
-- 
cgit v1.2.3