X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fprofile%2Fgroups.inc.php;h=38367f176da26e9dde58d23dc7760a4e71baa27e;hb=9f5bd98e936d8cef7ca9f774eeef64dbb8a1b079;hp=5fb7b4525fa286361f3744281bec02955792a2fb;hpb=2553b7686e0678b8e27858a7c377e73ecb410aec;p=platal.git diff --git a/modules/profile/groups.inc.php b/modules/profile/groups.inc.php index 5fb7b45..38367f1 100644 --- a/modules/profile/groups.inc.php +++ b/modules/profile/groups.inc.php @@ -1,6 +1,6 @@ assign('mygroups', XDB::iterator("SELECT a.nom, a.site, a.diminutif, a.unsub_url, a.pub, m.perms - FROM groupex.asso AS a - INNER JOIN groupex.membres AS m ON (m.asso_id = a.id) + FROM #groupex#.asso AS a + INNER JOIN #groupex#.membres AS m ON (m.asso_id = a.id) WHERE m.uid = {?} AND (a.cat = 'GroupesX' OR a.cat = 'Institutions')", S::i('uid'))); $page->assign('listgroups', XDB::iterator("SELECT a.nom, a.diminutif, a.sub_url, IF (a.cat = 'Institutions', a.cat, d.nom) AS dom - FROM groupex.asso AS a - LEFT JOIN groupex.dom AS d ON (d.id = a.dom) + FROM #groupex#.asso AS a + LEFT JOIN #groupex#.dom AS d ON (d.id = a.dom) WHERE a.inscriptible != 0 AND (a.cat = 'GroupesX' OR a.cat = 'Institutions') ORDER BY a.cat, a.dom, a.nom"));