xdb->query("SELECT alias FROM aliases WHERE id={?} AND (type IN ('a_vie','alias') AND FIND_IN_SET('bestalias', flags))", $id); return $res->fetchOneCell(); } else { $res = $globals->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, "@")); } return $login; } ?>