- $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, '@', {?})
- 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 = {?})
- WHERE v.alias={?}
- ORDER BY redirect",
- $globals->mail->domain, $globals->mail->domain2,
- $globals->asso('id'), $globals->asso('id'), $lfull);
- $page->assign('mem', $res);
+ $emails = XDB::fetchColumn('SELECT redirect
+ FROM virtual_redirect AS vr
+ INNER JOIN virtual AS v USING(vid)
+ WHERE v.alias = {?}
+ ORDER BY redirect', $lfull);
+ $mem = array();
+ foreach ($emails as $email) {
+ $user = User::getSilent($email);
+ if ($user) {
+ $mem[] = array('user' => $user, 'email' => $email);
+ } else {
+ $mem[] = array('email' => $email);
+ }
+ }
+ $page->assign('mem', $mem);