From 0fe005cc44ccbda54100ca37855723deb0ac51f0 Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Tue, 16 Oct 2007 22:32:08 +0200 Subject: [PATCH] Fix count of non subscribers Signed-off-by: Florent Bruneau --- modules/xnetgrp.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/xnetgrp.php b/modules/xnetgrp.php index 78df9a9..12f86c9 100644 --- a/modules/xnetgrp.php +++ b/modules/xnetgrp.php @@ -361,7 +361,7 @@ class XnetGrpModule extends PLModule 1, 1)) as letter, COUNT(*) FROM groupex.membres AS m LEFT JOIN auth_user_md5 AS u ON ( u.user_id = m.uid) - WHERE asso_id = {?} and (u.perms != \'pending\' OR u.perms IS NULL) + WHERE asso_id = {?} and (u.perms != \'pending\' OR m.email IS NOT NULL) GROUP BY letter ORDER BY letter', $globals->asso('id')); } else { -- 2.1.4