From d394ed2feec7801d7fb38240fc6f001d4367063c Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Tue, 13 May 2014 16:49:09 +0200 Subject: notify coordinators about unconfirmed angeltypes --- includes/model/UserAngelTypes_model.php | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'includes/model/UserAngelTypes_model.php') 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 @@ -3,6 +3,21 @@ * User angeltypes model */ +/** + * 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. * -- cgit v1.2.3-54-g00ecf