From b1797f70e5a49dbd238f16746410d3a4ed1c68ff Mon Sep 17 00:00:00 2001 From: Vincent Zanotti Date: Tue, 20 May 2008 01:19:18 +0200 Subject: [PATCH] =?utf8?q?Fixes=20"patte=20cass=C3=A9e"=20page=20for=20Goo?= =?utf8?q?gle=20Apps=20users.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Vincent Zanotti --- modules/email.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/modules/email.php b/modules/email.php index b321981..0e3f170 100644 --- a/modules/email.php +++ b/modules/email.php @@ -527,7 +527,8 @@ L'équipe d'administration mail->domain . '>'; } else { $page->assign('email',$email); $sel = XDB::query( - "SELECT e1.uid, e1.panne != 0 AS panne, count(e2.uid) AS nb_mails, + "SELECT e1.uid, e1.panne != 0 AS panne, + (count(e2.uid) + IF(FIND_IN_SET('googleapps', u.mail_storage), 1, 0)) AS nb_mails, u.nom, u.prenom, u.promo, a.alias AS forlife FROM emails as e1 LEFT JOIN emails as e2 ON(e1.uid = e2.uid -- 2.1.4