diff options
author | Philip Häusler <msquare@notrademark.de> | 2015-12-20 11:36:12 +0100 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2015-12-20 11:36:12 +0100 |
commit | 0ac05d251c0df5fa09a27b7686acc5690b436f31 (patch) | |
tree | 12e39fff0fd2c62a624a8c6ee51af4664d557ade /includes/model/User_model.php | |
parent | 2cb44fe51752bece6413d3a4745cfba79df21884 (diff) |
#198 fixed: driving license feature completed - integrated into angeltypes
Diffstat (limited to 'includes/model/User_model.php')
-rw-r--r-- | includes/model/User_model.php | 4 |
1 files changed, 3 insertions, 1 deletions
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`"); } |