summaryrefslogtreecommitdiff
path: root/includes/model/User_model.php
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2015-12-20 11:36:12 +0100
committerPhilip Häusler <msquare@notrademark.de>2015-12-20 11:36:12 +0100
commit0ac05d251c0df5fa09a27b7686acc5690b436f31 (patch)
tree12e39fff0fd2c62a624a8c6ee51af4664d557ade /includes/model/User_model.php
parent2cb44fe51752bece6413d3a4745cfba79df21884 (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.php4
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`");
}