X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=plugins%2Finsert.getUserName.php;h=47e6251bb9df514a596ae73dde83af992840895e;hb=e46cf8c46341b447cc3701c8afcc9baec3da11e5;hp=bd7af29768404b4b66766f0b1e44a627368e72bb;hpb=8d84c630f353ef0534e02325507ed35cc2f0d28f;p=platal.git diff --git a/plugins/insert.getUserName.php b/plugins/insert.getUserName.php index bd7af29..47e6251 100644 --- a/plugins/insert.getUserName.php +++ b/plugins/insert.getUserName.php @@ -31,20 +31,20 @@ function smarty_insert_getUsername() } if (Cookie::v('domain', 'login') != 'alias') { - $res = XDB::query("SELECT alias FROM aliases - WHERE id={?} AND (type IN ('a_vie','alias') AND FIND_IN_SET('bestalias', flags))", $id); - return $res->fetchOneCell(); + $res = 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 = 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(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;