From f8aaf2a6f573b15777601c38513d9a7c869f1462 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Fri, 16 Jul 2021 13:15:07 +0200 Subject: Rewrite is_your_turn SQL statements. Now they should work in all lobby views. --- tools/sql/schema.txt | 3 --- 1 file changed, 3 deletions(-) (limited to 'tools') 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 ; -- cgit v1.2.3