* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
- '%grp/lists' => $this->make_hook('lists', AUTH_MDP),
- '%grp/lists/create' => $this->make_hook('create', AUTH_MDP),
+ '%grp/lists' => $this->make_hook('lists', AUTH_MDP, 'groupmember'),
+ '%grp/lists/create' => $this->make_hook('create', AUTH_MDP, 'groupmember'),
'%grp/lists/archives' => $this->make_hook('archives', AUTH_COOKIE),
'%grp/lists/moderate' => $this->make_hook('moderate', AUTH_MDP),
'%grp/lists/archives' => $this->make_hook('archives', AUTH_COOKIE),
'%grp/lists/moderate' => $this->make_hook('moderate', AUTH_MDP),
'%grp/lists/check' => $this->make_hook('check', AUTH_MDP),
'%grp/lists/sync' => $this->make_hook('sync', AUTH_MDP),
'%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),
+ '%grp/alias/admin' => $this->make_hook('aadmin', AUTH_MDP, 'groupadmin'),
+ '%grp/alias/create' => $this->make_hook('acreate', AUTH_MDP, 'groupadmin'),
/* hack: lists uses that */
'profile' => $this->make_hook('profile', AUTH_PUBLIC),
/* 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);
USING x4dat.virtual AS v
LEFT JOIN x4dat.virtual_redirect USING(vid)
WHERE v.alias={?}', $alias);
$ann = 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,
$ann = 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,
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,
"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,
"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(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)
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.aliases AS a ON(vr.redirect = CONCAT(a.alias, '@', {?})
+ OR vr.redirect = CONCAT(a.alias, '@', {?}))
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 = {?})
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 = {?})
$res = XDB::query('SELECT COUNT(*) FROM x4dat.virtual WHERE alias={?}', $new);
$n = $res->fetchOneCell();
if ($n) {
$res = XDB::query('SELECT COUNT(*) FROM x4dat.virtual WHERE alias={?}', $new);
$n = $res->fetchOneCell();
if ($n) {