- $res = XDB::query("
- SELECT v.alias
- FROM virtual AS v
- INNER JOIN virtual_redirect USING(vid)
- INNER JOIN aliases AS a ON(id={?} AND a.type='a_vie')
- WHERE redirect = CONCAT(a.alias, {?})
- OR redirect = CONCAT(a.alias, {?})",
- $id, "@".$globals->mail->domain, "@".$globals->mail->domain2);
- $alias = $res->fetchOneCell();
- return substr($alias, 0, strpos($alias, "@"));
+ $res = XDB::query("
+ SELECT v.alias
+ FROM virtual AS v
+ INNER JOIN virtual_redirect USING (vid)
+ INNER JOIN aliases AS a ON (uid = {?} AND a.type = 'a_vie')
+ WHERE redirect = CONCAT(a.alias, {?}) OR redirect = CONCAT(a.alias, {?})",
+ $id, '@' . $globals->mail->domain, '@' . $globals->mail->domain2);
+ $aliases = $res->fetchAllAssoc();
+ foreach ($aliases as $alias) {
+ list($login, $domain) = explode('@', $alias['alias']);
+ if ($domain == $globals->mail->alias_dom || $domain == $globals->mail->alias_dom2) {
+ return $login;
+ }
+ }