From d7aea575ff77cd37c326511e7ac5fe49067c63ad Mon Sep 17 00:00:00 2001 From: Igor Scheller Date: Sun, 14 Oct 2018 18:24:42 +0200 Subject: Replaced more sql queries and old data --- includes/controller/users_controller.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'includes/controller/users_controller.php') diff --git a/includes/controller/users_controller.php b/includes/controller/users_controller.php index 61b19231..c8d8a4a9 100644 --- a/includes/controller/users_controller.php +++ b/includes/controller/users_controller.php @@ -215,9 +215,9 @@ function user_controller() ); foreach ($shift['needed_angeltypes'] as &$needed_angeltype) { $needed_angeltype['users'] = DB::select(' - SELECT `ShiftEntry`.`freeloaded`, `User`.* + SELECT `ShiftEntry`.`freeloaded`, `users`.* FROM `ShiftEntry` - JOIN `User` ON `ShiftEntry`.`UID`=`User`.`UID` + JOIN `users` ON `ShiftEntry`.`UID`=`users`.`id` WHERE `ShiftEntry`.`SID` = ? AND `ShiftEntry`.`TID` = ? ', -- cgit v1.2.3-54-g00ecf