X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fprofile.php;h=fe2aa43148bfaf99793ad31363b6d0a0a81085ed;hb=1f53925a716bf5cb97ed624a6787a8319eb2bcff;hp=66d5c31eb2d92a076019291ba627a513ed5cfeb4;hpb=a1d792172431297cb927aa3291ef132f372bd168;p=platal.git

diff --git a/modules/profile.php b/modules/profile.php
index 66d5c31..fe2aa43 100644
--- a/modules/profile.php
+++ b/modules/profile.php
@@ -675,11 +675,12 @@ class ProfileModule extends PLModule
         $page->assign('xorg_title', 'Polytechnique.org - Promo, Groupes X, Binets');
         
         $req = XDB::query('
-            SELECT m.asso_id, a.nom, diminutif, COUNT(e.eid) AS events, mail_domain AS lists
-            FROM groupex.membres AS m 
-            INNER JOIN groupex.asso AS a ON(m.asso_id = a.id)
-            LEFT JOIN groupex.evenements AS e ON(e.asso_id = m.asso_id)
-            WHERE uid = {?} GROUP BY m.asso_id ORDER BY a.nom', S::i('uid'));
+            SELECT m.asso_id, a.nom, diminutif, a.logo IS NOT NULL AS has_logo, 
+                   COUNT(e.eid) AS events, mail_domain AS lists
+              FROM groupex.membres AS m 
+        INNER JOIN groupex.asso AS a ON(m.asso_id = a.id)
+         LEFT JOIN groupex.evenements AS e ON(e.asso_id = m.asso_id AND e.archive = 0)
+             WHERE uid = {?} GROUP BY m.asso_id ORDER BY a.nom', S::i('uid'));
         $page->assign('assos', $req->fetchAllAssoc());
     }