'grp/lists/check' => $this->make_hook('check', AUTH_MDP),
'grp/lists/sync' => $this->make_hook('sync', AUTH_MDP),
+ 'grp/alias/admin' => $this->make_hook('aadmin', AUTH_MDP),
+ 'grp/alias/create' => $this->make_hook('acreate', AUTH_MDP),
+
/* hack: lists uses that */
'profile' => $this->make_hook('profile', AUTH_PUBLIC),
);
USING x4dat.virtual AS v
LEFT JOIN x4dat.virtual_redirect USING(vid)
WHERE v.alias={?}', $alias);
- $page->trig(Post::get('del_alias')." supprimé !");
+ $page->trig(Post::get('del_alias')." supprimé !");
}
$listes = $this->client->get_lists();
$page->assign('may_update', may_update());
}
+ function handler_create(&$page)
+ {
+ global $globals;
+
+ $this->prepare_client($page);
+
+ $page->changeTpl('xnet/groupe/listes-create.tpl');
+ $page->assign('force_list_super', may_update());
+
+ if (!Post::has('submit')) {
+ return;
+ }
+
+ if (!Post::has('liste')) {
+ $page->trig_run('champs «addresse souhaitée» vide');
+ }
+
+ $liste = Post::get('liste');
+
+ if (!preg_match("/^[a-zA-Z0-9\-]*$/", $liste)) {
+ $page->trig_run('le nom de la liste ne doit contenir que des lettres, chiffres et tirets');
+ }
+
+ $new = $liste.'@'.$globals->asso('mail_domain');
+ $res = $globals->xdb->query('SELECT COUNT(*) FROM x4dat.virtual WHERE alias={?}', $new);
+ $n = $res->fetchOneCell();
+
+ if($n) {
+ $page->trig_run('cet alias est déjà pris');
+ }
+ if(!Post::get('desc')) {
+ $page->trig_run('le sujet est vide');
+ }
+
+ require_once('platal/xmlrpc-client.inc.php');
+ require_once('lists.inc.php');
+ $ret = $this->client->create_list(
+ $liste, Post::get('desc'), Post::get('advertise'),
+ Post::get('modlevel'), Post::get('inslevel'),
+ array(Session::get('forlife')), array());
+
+ $dom = strtolower($globals->asso("mail_domain"));
+ $red = $dom.'_'.$liste;
+
+ if (!$ret) {
+ $page->kill("Un problème est survenu, contacter "
+ ."<a href='mailto:support@m4x.org'>support@m4x.org</a>");
+ return;
+ }
+ $globals->xdb->execute('INSERT INTO x4dat.virtual (alias,type)
+ VALUES({?},{?})', $liste.'@'.$dom, 'list');
+ $globals->xdb->execute('INSERT INTO x4dat.virtual_redirect (vid,redirect)
+ VALUES ({?}, {?})', mysql_insert_id(),
+ "$red+post@listes.polytechnique.org");
+ $globals->xdb->execute('INSERT INTO x4dat.virtual (alias,type)
+ VALUES({?},{?})', $liste.'-owner@'.$dom, 'list');
+ $globals->xdb->execute('INSERT INTO x4dat.virtual_redirect (vid,redirect)
+ VALUES ({?}, {?})', mysql_insert_id(),
+ "$red+owner@listes.polytechnique.org");
+ $globals->xdb->execute('INSERT INTO x4dat.virtual (alias,type)
+ VALUES({?},{?})', $liste.'-admin@'.$dom, 'list');
+ $globals->xdb->execute('INSERT INTO x4dat.virtual_redirect (vid,redirect)
+ VALUES ({?}, {?})', mysql_insert_id(),
+ "$red+admin@listes.polytechnique.org");
+ $globals->xdb->execute('INSERT INTO x4dat.virtual (alias,type)
+ VALUES({?},{?})', $liste.'-bounces@'.$dom, 'list');
+ $globals->xdb->execute('INSERT INTO x4dat.virtual_redirect (vid,redirect)
+ VALUES ({?}, {?})', mysql_insert_id(),
+ "$red+bounces@listes.polytechnique.org");
+
+ global $platal;
+ redirect(smarty_function_rel().'/'.$platal->ns.'lists/admin/'.$liste);
+ }
+
function handler_sync(&$page, $liste = null)
{
global $globals;
$ann = $globals->xdb->iterator(
"SELECT IF(m.origine='X',IF(u.nom_usage<>'', u.nom_usage, u.nom) ,m.nom) AS nom,
IF(m.origine='X',u.prenom,m.prenom) AS prenom,
- IF(m.origine='X',u.promo,'extérieur') AS promo,
+ IF(m.origine='X',u.promo,'extérieur') AS promo,
IF(m.origine='X',CONCAT(a.alias, '@polytechnique.org'),m.email) AS email,
IF(m.origine='X',FIND_IN_SET('femme', u.flags),0) AS femme,
m.perms='admin' AS admin,
$page->assign('not_in_list', $not_in_list);
}
+ function handler_aadmin(&$page, $lfull = null)
+ {
+ global $globals;
+
+ if (is_null($lfull)) {
+ return PL_NOT_FOUND;
+ }
+
+ new_groupadmin_page('xnet/groupe/alias-admin.tpl');
+
+ if (Env::has('add_member')) {
+ $add = Env::get('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 = $globals->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;
+ $globals->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 {
+ $globals->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')) {
+ $globals->xdb->query(
+ "DELETE FROM x4dat.virtual_redirect
+ USING x4dat.virtual_redirect
+ INNER JOIN x4dat.virtual USING(vid)
+ WHERE redirect={?} AND alias={?}", Env::get('del_member'), $lfull);
+ redirect("?liste=$lfull");
+ }
+
+ $res = $globals->xdb->iterator(
+ "SELECT redirect
+ FROM x4dat.virtual_redirect AS vr
+ INNER JOIN x4dat.virtual AS v USING(vid)
+ WHERE v.alias={?}
+ ORDER BY redirect", $lfull);
+ $page->assign('mem', $res);
+ }
+
+ function handler_acreate(&$page)
+ {
+ global $globals;
+
+ 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::get('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 = $globals->xdb->query('SELECT COUNT(*) FROM x4dat.virtual WHERE alias={?}', $new);
+ $n = $res->fetchOneCell();
+ if($n) {
+ $page->trig('cet alias est déjà pris');
+ return;
+ }
+
+ $globals->xdb->query('INSERT INTO x4dat.virtual (alias,type) VALUES({?}, "user")', $new);
+
+ global $platal;
+ redirect(smarty_function_rel()."/{$platal->ns}alias/admin/$new");
+ }
+
function handler_profile(&$page, $user = null)
{
redirect('https://www.polytechnique.org/profile/'.$user);
projects / platal.git / blobdiff