Rewrite is_your_turn SQL statements.

Now they should work in all lobby views.

1 files changed, 0 insertions, 3 deletions

diff --git a/tools/sql/schema.txt b/tools/sql/schema.txt
index 71b6f72..e731c8c 100644
--- a/tools/sql/schema.txt
+++ b/tools/sql/schema.txt
@@ -153,12 +153,9 @@ CREATE VIEW game_view AS
 		, games.status
 		, games.result
 		, games.active AS active_role
-		, active.user_id AS active_id
-		, active.user_name AS active_name
 		-- , games.state
 	FROM games
 	JOIN titles USING ( title_id )
 	JOIN users AS owner ON games.owner_id = owner.user_id
 	LEFT JOIN player_list_view AS players USING ( game_id )
-	LEFT JOIN player_view AS active ON games.game_id = active.game_id AND games.active = active.role
 	;