X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=plugins%2Finsert.getUserName.php;h=9cc219f46f27965c9bf5f97953f5b8a47c553287;hb=fe13bc1d7ba9f72d452ec07baf8538a74b7c67b8;hp=b1846a34fb0eb5fbca8461b20bec51b9b84d8d0f;hpb=9f5bd98e936d8cef7ca9f774eeef64dbb8a1b079;p=platal.git

diff --git a/plugins/insert.getUserName.php b/plugins/insert.getUserName.php
index b1846a3..9cc219f 100644
--- a/plugins/insert.getUserName.php
+++ b/plugins/insert.getUserName.php
@@ -32,14 +32,14 @@ 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);
+                            WHERE  uid={?} 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')
+        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);