Pokus o preklad username na userid

[mirrors/SokoMan.git] / lib / Sklad_Auth.class / lms.php

diff --git a/lib/Sklad_Auth.class/lms.php b/lib/Sklad_Auth.class/lms.php
index 7994b44d5585c7843e579197d7de6295c3c04594..3308c0204752af3300c131865f4d8d8fa9f2792d 100755 (executable)
--- a/lib/Sklad_Auth.class/lms.php
+++ b/lib/Sklad_Auth.class/lms.php
@@ -48,4 +48,21 @@ class Sklad_Auth extends Sklad_Auth_common {
                return true;
 
        }
+
+  function get_username_by_id($id) {
+               $LMS_CONFIG = (array)parse_ini_file('/etc/lms/lms.ini', true);
+
+               $dblink = @mysql_connect($LMS_CONFIG['database']['host'], $LMS_CONFIG['database']['user'], $LMS_CONFIG['database']['password']);
+               mysql_select_db($LMS_CONFIG['database']['database'], $dblink);
+
+               mysql_query("SET NAMES utf8");
+
+               $lQ = mysql_query("SELECT name FROM users WHERE id='".$id."' AND deleted=0");
+               $lA = mysql_fetch_array($lQ, MYSQL_ASSOC);
+               @mysql_close($dblink);
+
+               if(!is_array($lA)) return "USER($id)";
+
+               return($lA['name']);
+  }
 }