Changeset 454 for trunk/includes/user.php

Timestamp:

Apr 13, 2010, 7:30:00 AM (15 years ago)

Author:

george

Message:

• Upraveno: WowLua.exe lze použít pro enGB i pro enUS. Zrušeno rozlišení.
• Upraveno: V třídě User volána databáze objektově přes mysqli.

File:

• trunk/includes/user.php (modified) (6 diffs)

trunk/includes/user.php

@@ -15 +15 @@
   var $Redirecting;
   var $Language;
+  var $System;
   
-  function __construct()
+  function __construct($System)
   {
+    $this->System = &$System;
     if(isset($_SESSION)) $this->Restore();    
       else $this->SetAnonymous();
@@ -29 +31 @@
   function Login($Name, $Password)
   {
-    global $Database;
-     
-    $DbResult = $Database->SQLCommand('SELECT `ID` FROM `User` WHERE LOWER(`Name`) = LOWER("'.$Name.'") AND `Pass` = '.$this->CryptPasswordSQL('"'.$Password.'"', '`Salt`'));
-    if(mysql_num_rows($DbResult) > 0)
+    $DbResult = $this->System->Database->query('SELECT `ID` FROM `User` WHERE LOWER(`Name`) = LOWER("'.$Name.'") AND `Pass` = '.$this->CryptPasswordSQL('"'.$Password.'"', '`Salt`'));
+    if($DbResult->num_rows > 0)
     {
-      $User = mysql_fetch_assoc($DbResult);
+      $User = $DbResult->fetch_assoc();
       $this->Id = $User['ID'];      
       $this->Load();
@@ -44 +44 @@
   function Logout()
   {
-    global $Database;
-
     if($this->Role != LICENCE_ANONYMOUS)
-      $Database->SQLCommand('UPDATE `User` SET `LastLogout` = NOW() WHERE `ID` = '.$this->Id);
+      $this->System->Database->query('UPDATE `User` SET `LastLogout` = NOW() WHERE `ID` = '.$this->Id);
     $this->SetAnonymous();
   }
@@ -53 +51 @@
   function Load()
   {
-    global $Database;
-    
-    $DbResult = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$this->Id);
-    $User = mysql_fetch_assoc($DbResult);
+    $DbResult = $this->System->Database->query('SELECT * FROM `User` WHERE `ID` = '.$this->Id);
+    $User = $DbResult->fetch_assoc();
     // Security: Password and Salt hash should not be loaded to variables
     $this->Id = $User['ID'];
@@ -98 +94 @@
   function Licence($Licence)
   {
-    global $Database;
- 
     if(!isset($_SERVER['REMOTE_ADDR'])) return(true); // Execution from command line
     else return($this->Role >= $Licence);    
@@ -116 +110 @@
   function UpdateState()
   {
-    global $Database;
-    
     if(array_key_exists('REMOTE_ADDR', $_SERVER)) 
-      $Database->SQLCommand('UPDATE `User` SET `LastIP` = "'.$_SERVER['REMOTE_ADDR'].'", `LastLogin` = NOW() WHERE `ID` = '.$this->Id);
+      $this->System->Database->query('UPDATE `User` SET `LastIP` = "'.$_SERVER['REMOTE_ADDR'].'", `LastLogin` = NOW() WHERE `ID` = '.$this->Id);
   }
 }