From d522f92b5b23f71ef1db365462b3a64ba3f702ae Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Tue, 10 May 2011 21:40:34 +0200 Subject: [PATCH] Only retrieves uids from MLs users if there are some. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- modules/xnetgrp.php | 22 +++++++++++++--------- 1 file changed, 13 insertions(+), 9 deletions(-) diff --git a/modules/xnetgrp.php b/modules/xnetgrp.php index 2fda2ef..de4f48c 100644 --- a/modules/xnetgrp.php +++ b/modules/xnetgrp.php @@ -460,15 +460,19 @@ class XnetGrpModule extends PLModule } $nonusers = array_unique($nonusers); $uids = array_unique($uids); - $uids = XDB::fetchColumn('SELECT a.uid - FROM accounts AS a - WHERE a.uid IN {?} AND NOT EXISTS (SELECT * - FROM group_members AS g - WHERE a.uid = g.uid AND g.asso_id = {?})', - $uids, $globals->asso('id')); - - $users = User::getBulkUsersWithUIDs($uids); - usort($users, 'User::compareDirectoryName'); + if (count($uids)) { + $uids = XDB::fetchColumn('SELECT a.uid + FROM accounts AS a + WHERE a.uid IN {?} AND NOT EXISTS (SELECT * + FROM group_members AS g + WHERE a.uid = g.uid AND g.asso_id = {?})', + $uids, $globals->asso('id')); + + $users = User::getBulkUsersWithUIDs($uids); + usort($users, 'User::compareDirectoryName'); + } else { + $users = array(); + } sort($nonusers); $page->assign('users', $users); -- 2.1.4