diff options
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 |