X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=inline;f=plugins%2Finsert.getUserName.php;h=7caa9a2444277a8a676921774a3b72a2afb11820;hb=2adffe8ddcca5267e0ae621284de5b372d635537;hp=ce34a9661fa761c926b46037370c97e9db5a1c3e;hpb=d05cf8d4ad0bba8aa4e053ede5f9dccb9b0c88fa;p=platal.git diff --git a/plugins/insert.getUserName.php b/plugins/insert.getUserName.php index ce34a96..7caa9a2 100644 --- a/plugins/insert.getUserName.php +++ b/plugins/insert.getUserName.php @@ -43,7 +43,7 @@ function smarty_insert_getUsername() return XDB::fetchOneCell('SELECT email FROM email_source_account WHERE uid = {?} AND type != \'alias_aux\' - ORDER BY NOT FIND_IN_SET(\'bestalias\', flags), MIN(email)', + ORDER BY NOT FIND_IN_SET(\'bestalias\', flags), CHAR_LENGTH(email)', $id); }