+ function handler_aadmin(&$page, $lfull = null)
+ {
+ global $globals;
+
+ if (!$globals->asso('mail_domain') || is_null($lfull)) {
+ return PL_NOT_FOUND;
+ }
+
+ new_groupadmin_page('xnet/groupe/alias-admin.tpl');
+
+ if (Env::has('add_member')) {
+ $add = Env::v('add_member');
+ if (strstr($add, '@')) {
+ list($mbox,$dom) = explode('@', strtolower($add));
+ } else {
+ $mbox = $add;
+ $dom = 'm4x.org';
+ }
+ if ($dom == 'polytechnique.org' || $dom == 'm4x.org') {
+ $res = XDB::query(
+ "SELECT a.alias, b.alias
+ FROM x4dat.aliases AS a
+ LEFT JOIN x4dat.aliases AS b ON (a.id=b.id AND b.type = 'a_vie')
+ WHERE a.alias={?} AND a.type!='homonyme'", $mbox);
+ if (list($alias, $blias) = $res->fetchOneRow()) {
+ $alias = empty($blias) ? $alias : $blias;
+ XDB::query(
+ "INSERT INTO x4dat.virtual_redirect (vid,redirect)
+ SELECT vid, {?}
+ FROM x4dat.virtual
+ WHERE alias={?}", "$alias@m4x.org", $lfull);
+ $page->trig("$alias@m4x.org ajouté");
+ } else {
+ $page->trig("$mbox@polytechnique.org n'existe pas.");
+ }
+ } else {
+ XDB::query(
+ "INSERT INTO x4dat.virtual_redirect (vid,redirect)
+ SELECT vid,{?}
+ FROM x4dat.virtual
+ WHERE alias={?}", "$mbox@$dom", $lfull);
+ $page->trig("$mbox@$dom ajouté");
+ }
+ }
+
+ if (Env::has('del_member')) {
+ XDB::query(
+ "DELETE FROM x4dat.virtual_redirect
+ USING x4dat.virtual_redirect
+ INNER JOIN x4dat.virtual USING(vid)
+ WHERE redirect={?} AND alias={?}", Env::v('del_member'), $lfull);
+ pl_redirect('alias/admin/'.$lfull);
+ }
+
+ global $globals;
+ $res = XDB::iterator(
+ "SELECT redirect,
+ IF(u.nom IS NOT NULL, IF(u.nom_usage<>'', u.nom_usage, u.nom), m.nom) AS nom,
+ IF(u.prenom IS NOT NULL, u.prenom, m.prenom) AS prenom,
+ IF(u.promo IS NOT NULL, u.promo, 'extérieur') AS promo,
+ IF(m2.perms, m2.perms = 'admin', m.perms = 'admin') AS admin,
+ a.alias
+ FROM x4dat.virtual_redirect AS vr
+ INNER JOIN x4dat.virtual AS v USING(vid)
+ LEFT JOIN x4dat.aliases AS a ON(vr.redirect = CONCAT(a.alias, CONCAT('@', {?}))
+ OR vr.redirect = CONCAT(a.alias, CONCAT('@', {?})))
+ LEFT JOIN x4dat.auth_user_md5 AS u ON(a.id = u.user_id)
+ LEFT JOIN groupex.membres AS m2 ON(u.user_id = m2.uid AND m2.asso_id = {?})
+ LEFT JOIN groupex.membres AS m ON(m.email = vr.redirect AND m.asso_id = {?})
+ WHERE v.alias={?}
+ ORDER BY redirect",
+ $globals->mail->domain, $globals->mail->domain2,
+ $globals->asso('id'), $globals->asso('id'), $lfull);
+ $page->assign('mem', $res);
+ }
+
+ function handler_acreate(&$page)
+ {
+ global $globals;
+
+ if (!$globals->asso('mail_domain')) {
+ return PL_NOT_FOUND;
+ }
+ new_groupadmin_page('xnet/groupe/alias-create.tpl');
+
+ if (!Post::has('submit')) {
+ return;
+ }
+
+ if (!Post::has('liste')) {
+ $page->trig('champs «addresse souhaitée» vide');
+ return;
+ }
+ $liste = Post::v('liste');
+ if (!preg_match("/^[a-zA-Z0-9\-\.]*$/", $liste)) {
+ $page->trig('le nom de l\'alias ne doit contenir que des lettres,'
+ .' chiffres, tirets et points');
+ return;
+ }
+
+ $new = $liste.'@'.$globals->asso('mail_domain');
+ $res = XDB::query('SELECT COUNT(*) FROM x4dat.virtual WHERE alias={?}', $new);
+ $n = $res->fetchOneCell();
+ if ($n) {
+ $page->trig('cet alias est déjà pris');
+ return;
+ }
+
+ XDB::query('INSERT INTO x4dat.virtual (alias,type) VALUES({?}, "user")', $new);
+
+ pl_redirect("alias/admin/$new");
+ }
+