- require_once 'trombi.inc.php';
-
- $page->changeTpl('trombipromo.tpl');
- $page->assign('xorg_title', 'Polytechnique.org - Trombi Promo');
-
- if (is_null($promo)) {
- return;
- }
-
- $this->promo = $promo = intval($promo);
-
- if ($promo >= 1900 && ($promo < intval(date('Y')) || ($promo == intval(date('Y')) && intval(date('m')) >= 9))
- || ($promo == -1 && S::has_perms()))
- {
- $trombi = new Trombi(array($this, '_trombi_getlist'));
- $trombi->hidePromo();
- $trombi->setAdmin();
- $page->assign_by_ref('trombi', $trombi);
- } else {
- $page->trig('Promotion incorrecte (saisir au format YYYY). Recommence.');
- }
- }
-
- function vcard_escape($text)
- {
- return preg_replace('/[,;]/', '\\\\$0', $text);
- }
-
- function format_adr($params, &$smarty)
- {
- // $adr1, $adr2, $adr3, $postcode, $city, $region, $country
- extract($params['adr']);
- $adr = trim($adr1);
- $adr = trim("$adr\n$adr2");
- $adr = trim("$adr\n$adr3");
- return $this->vcard_text_encode(';;'
- . $this->vcard_escape($adr) . ';'
- . $this->vcard_escape($city) . ';'
- . $this->vcard_escape($region) . ';'
- . $this->vcard_escape($postcode) . ';'
- . $this->vcard_escape($country), false);
- }
-
- function vcard_text_encode($text, $escape = true)
- {
- if ($escape) {
- $text = $this->vcard_escape($text);
- }
- return str_replace("\n", "\\n", $text); //implode('\n', explode("\n", $text));
+ $page->changeTpl('profile/groupesx.tpl');
+ $page->assign('xorg_title', 'Polytechnique.org - Promo, Groupes X, Binets');
+
+ $req = XDB::query('
+ 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());