Renames domain value for users loging with their hruid. Ensures the rigth username...

[platal.git] / plugins / insert.getUserName.php

diff --git a/plugins/insert.getUserName.php b/plugins/insert.getUserName.php
index e8172fe..ce34a96 100644 (file)
--- a/plugins/insert.getUserName.php
+++ b/plugins/insert.getUserName.php
@@ -28,15 +28,22 @@ function smarty_insert_getUsername()
         return '';
     }
 
-    if (Cookie::v('domain', 'login') != 'alias') {
+    $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\' AND FIND_IN_SET(\'bestalias\', flags)',
+                                   WHERE  uid = {?} AND type = \'alias_aux\'',
                                  $id);
     } else {
         return XDB::fetchOneCell('SELECT  email
                                     FROM  email_source_account
-                                   WHERE  uid = {?} AND type = \'alias_aux\'',
+                                   WHERE  uid = {?} AND type != \'alias_aux\'
+                                ORDER BY  NOT FIND_IN_SET(\'bestalias\', flags), MIN(email)',
                                  $id);
     }