pl_redirect('alias/admin/'.$lfull);
}
+ global $globals;
$res = XDB::iterator(
- "SELECT redirect
+ "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", $lfull);
+ ORDER BY redirect",
+ $globals->mail->domain, $globals->mail->domain2,
+ $globals->asso('id'), $globals->asso('id'), $lfull);
$page->assign('mem', $res);
}