diff options
author | Philip Häusler <msquare@notrademark.de> | 2014-05-13 16:49:09 +0200 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2014-05-13 16:49:09 +0200 |
commit | d394ed2feec7801d7fb38240fc6f001d4367063c (patch) | |
tree | dea0c0ca4c4283d630ff1f0a84c158d7fd07b210 /includes/model | |
parent | f1145b8a5e8630e0180d35ff1ced2e934b872f01 (diff) |
notify coordinators about unconfirmed angeltypes
Diffstat (limited to 'includes/model')
-rw-r--r-- | includes/model/UserAngelTypes_model.php | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/includes/model/UserAngelTypes_model.php b/includes/model/UserAngelTypes_model.php index b9b44032..a9944ff1 100644 --- a/includes/model/UserAngelTypes_model.php +++ b/includes/model/UserAngelTypes_model.php @@ -4,6 +4,21 @@ */ /** + * Gets unconfirmed user angeltypes for angeltypes of which the given user is a coordinator. + * + * @param User $user + */ +function User_unconfirmed_AngelTypes($user) { + return sql_select(" + SELECT `UnconfirmedMembers`.*, `AngelTypes`.`name` FROM `UserAngelTypes` + JOIN `AngelTypes` ON `UserAngelTypes`.`angeltype_id`=`AngelTypes`.`id` + JOIN `UserAngelTypes` as `UnconfirmedMembers` ON `UserAngelTypes`.`angeltype_id`=`UnconfirmedMembers`.`angeltype_id` + WHERE `UserAngelTypes`.`user_id`=" . sql_escape($user['UID']) . " + AND `AngelTypes`.`restricted`=TRUE + AND `UnconfirmedMembers`.`confirm_user_id` IS NULL"); +} + +/** * Returns true if user is angeltype coordinator or has privilege admin_user_angeltypes. * * @param User $user |