X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=plugins%2Finsert.getUserName.php;h=ce34a9661fa761c926b46037370c97e9db5a1c3e;hb=cc86e4ea3fc9b6a7101d500501f83d04532e6434;hp=70a70f72accd6c8704e83b4c40ea7315feddd48b;hpb=40565fa2f8bd3c20646f194b36c893cb3696f3c2;p=platal.git

diff --git a/plugins/insert.getUserName.php b/plugins/insert.getUserName.php
index 70a70f7..ce34a96 100644
--- a/plugins/insert.getUserName.php
+++ b/plugins/insert.getUserName.php
@@ -1,6 +1,6 @@
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2008 Polytechnique.org                              *
+ *  Copyright (C) 2003-2011 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -21,33 +21,33 @@
 
 function smarty_insert_getUsername()
 {
-    global $globals;
-
     $id = Cookie::i('uid', -1);
-    $id = S::v($_SESSION['uid'], $id);
+    $id = S::v('uid', $id);
 
-    if ($id<0) {
-        return "";
+    if ($id < 0) {
+        return '';
     }
 
-    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();
+    $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 = 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), MIN(email)',
+                                 $id);
+    }
 
-     return $login;
+     return '';
 }
 
 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: