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

diff --git a/plugins/insert.getUserName.php b/plugins/insert.getUserName.php
index bd7af29..9cc219f 100644
--- a/plugins/insert.getUserName.php
+++ b/plugins/insert.getUserName.php
@@ -1,6 +1,6 @@
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2009 Polytechnique.org                              *
+ *  Copyright (C) 2003-2010 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -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  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')
-                 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(uid={?} 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;