X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=plugins%2Finsert.getUserName.php;h=7caa9a2444277a8a676921774a3b72a2afb11820;hb=40d68e6c9cd15ed2b68aec45a480458581cb47e9;hp=37ab6cd388a628851dc3088c9b6ffe076881ef16;hpb=50a40a33a496131e817df875607ea5542d096a64;p=platal.git diff --git a/plugins/insert.getUserName.php b/plugins/insert.getUserName.php index 37ab6cd..7caa9a2 100644 --- a/plugins/insert.getUserName.php +++ b/plugins/insert.getUserName.php @@ -1,6 +1,6 @@ xdb->query("SELECT alias FROM aliases - WHERE id={?} AND (type IN ('a_vie','alias') AND FIND_IN_SET('bestalias', flags))", $id); - return $res->fetchOneCell(); + $domain = Cookie::v('domain', 'login'); + if ($domain == 'hruid') { + return XDB::fetchOneCell('SELECT hruid + FROM accounts + WHERE uid = {?}', + $id); + } elseif ($domain == 'alias') { + return XDB::fetchOneCell('SELECT email + FROM email_source_account + WHERE uid = {?} AND type = \'alias_aux\'', + $id); } 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 XDB::fetchOneCell('SELECT email + FROM email_source_account + WHERE uid = {?} AND type != \'alias_aux\' + ORDER BY NOT FIND_IN_SET(\'bestalias\', flags), CHAR_LENGTH(email)', + $id); + } - return $login; - + return ''; } + +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>