2 require 'xnet.inc.php';
4 new_page('xnet/plan.tpl', AUTH_PUBLIC
);
5 $page->setType('plan');
7 $res = $globals->xdb
->iterator(
8 'SELECT dom.id, dom.nom as domnom, asso.diminutif, asso.nom
10 INNER JOIN groupex.asso ON dom.id = asso.dom
11 WHERE FIND_IN_SET("GroupesX", dom.cat) AND FIND_IN_SET("GroupesX", asso.cat)
12 ORDER BY dom.nom, asso.nom');
14 while ($tmp = $res->next()) { $groupesx[$tmp['id']][] = $tmp; }
15 $page->assign('groupesx', $groupesx);
17 $res = $globals->xdb
->iterator(
18 'SELECT dom.id, dom.nom as domnom, asso.diminutif, asso.nom
20 INNER JOIN groupex.asso ON dom.id = asso.dom
21 WHERE FIND_IN_SET("Binets", dom.cat) AND FIND_IN_SET("Binets", asso.cat)
22 ORDER BY dom.nom, asso.nom');
24 while ($tmp = $res->next()) { $binets[$tmp['id']][] = $tmp; }
25 $page->assign('binets', $binets);
27 $res = $globals->xdb
->iterator(
28 'SELECT asso.diminutif, asso.nom
30 WHERE cat LIKE "%Promotions%"
32 $page->assign('promos', $res);
34 $res = $globals->xdb
->iterator(
35 'SELECT asso.diminutif, asso.nom
37 WHERE FIND_IN_SET("Institutions", cat)
39 $page->assign('inst', $res);