From 593768bd0caac841bbe315a46a959cee639f44b9 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 2 Nov 2011 13:50:21 +0100 Subject: [PATCH] Fixes group notification on unsubscriptions. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- classes/group.php | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/classes/group.php b/classes/group.php index 72ce770..846f2b2 100644 --- a/classes/group.php +++ b/classes/group.php @@ -160,6 +160,21 @@ class Group XDB::execute('DELETE FROM group_members WHERE uid = {?} AND asso_id = {?}', $uid, $group_id); + self::fix_notification($group_id); + } + + static private function fix_notification($group_id) + { + $count = XDB::fetchOneCell("SELECT COUNT(uid) + FROM group_members + WHERE asso_id = {?} AND perms = 'admin' AND FIND_IN_SET('notify', flags)", + $group_id); + if ($count == 0) { + XDB::execute("UPDATE groups + SET flags = IF(flags = '', 'notify_all', CONCAT(flags, ',', 'notify_all')) + WHERE id = {?}", + $group_id); + } } } -- 2.1.4