From 0ac05d251c0df5fa09a27b7686acc5690b436f31 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Sun, 20 Dec 2015 11:36:12 +0100 Subject: #198 fixed: driving license feature completed - integrated into angeltypes --- includes/model/User_model.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'includes/model/User_model.php') diff --git a/includes/model/User_model.php b/includes/model/User_model.php index bd3ec31f..d051b3e9 100644 --- a/includes/model/User_model.php +++ b/includes/model/User_model.php @@ -123,9 +123,11 @@ function Users_by_angeltype($angeltype) { `User`.*, `UserAngelTypes`.`id` as `user_angeltype_id`, `UserAngelTypes`.`confirm_user_id`, - `UserAngelTypes`.`coordinator` + `UserAngelTypes`.`coordinator`, + `UserDriverLicenses`.* FROM `User` JOIN `UserAngelTypes` ON `User`.`UID`=`UserAngelTypes`.`user_id` + LEFT JOIN `UserDriverLicenses` ON `User`.`UID`=`UserDriverLicenses`.`user_id` WHERE `UserAngelTypes`.`angeltype_id`='" . sql_escape($angeltype['id']) . "' ORDER BY `Nick`"); } -- cgit v1.2.3-54-g00ecf