+ function handler_aadmin(&$page, $lfull = null)
+ {
+ global $globals;
+
+ if (!$globals->asso('mail_domain') || is_null($lfull)) {
+ return PL_NOT_FOUND;
+ }
+ $page->changeTpl('xnetlists/alias-admin.tpl');
+
+ if (Env::has('add_member')) {
+ S::assert_xsrf_token();
+
+ $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->trigSuccess("$alias@m4x.org ajouté");
+ } else {
+ $page->trigError("$mbox@{$globals->mail->domain} n'existe pas.");
+ }
+ } else {
+ XDB::query(
+ "INSERT INTO x4dat.virtual_redirect (vid,redirect)
+ SELECT vid,{?}
+ FROM x4dat.virtual
+ WHERE alias={?}", "$mbox@$dom", $lfull);
+ $page->trigSuccess("$mbox@$dom ajouté");
+ }
+ }
+
+ if (Env::has('del_member')) {
+ S::assert_xsrf_token();
+ 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 IF(r.login IS NULL, m.nom, IF(u.nom_usage != '', u.nom_usage, u.nom)) AS nom,
+ IF(r.login IS NULL, m.prenom, u.prenom) AS prenom,
+ IF(r.login IS NULL, 'extérieur', u.promo) AS promo,
+ m.perms = 'admin' AS admin, r.redirect, r.login AS alias
+ FROM (SELECT redirect AS redirect,
+ IF(SUBSTRING_INDEX(redirect, '@', -1) IN ({?}, {?}),
+ SUBSTRING_INDEX(redirect, '@', 1), NULL) AS login
+ FROM x4dat.virtual_redirect AS vr
+ INNER JOIN x4dat.virtual AS v USING(vid)
+ WHERE v.alias = {?}
+ ORDER BY redirect) AS r
+ LEFT JOIN aliases AS a ON (r.login IS NOT NULL AND r.login = a.alias)
+ LEFT JOIN auth_user_md5 AS u ON (u.user_id = a.id)
+ LEFT JOIN groupex.membres AS m ON (m.asso_id = {?} AND IF(r.login IS NULL, m.email = r.redirect, m.uid = u.user_id))",
+ $globals->mail->domain, $globals->mail->domain2,
+ $lfull, $globals->asso('id'));
+ $page->assign('mem', $res);
+ }
+
+ function handler_acreate(&$page)
+ {
+ global $globals;
+
+ if (!$globals->asso('mail_domain')) {
+ return PL_NOT_FOUND;
+ }
+ $page->changeTpl('xnetlists/alias-create.tpl');
+
+ if (!Post::has('submit')) {
+ return;
+ } else {
+ S::assert_xsrf_token();
+ }
+
+ if (!Post::has('liste')) {
+ $page->trigError('champs «adresse souhaitée» vide');
+ return;
+ }
+ $liste = Post::v('liste');
+ if (!preg_match("/^[a-zA-Z0-9\-\.]*$/", $liste)) {
+ $page->trigError('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->trigError('cet alias est déjà pris');
+ return;
+ }
+
+ XDB::query('INSERT INTO x4dat.virtual (alias,type) VALUES({?}, "user")', $new);
+
+ pl_redirect("alias/admin/$new");
+ }
+