Changeset 49 for trunk/www/user.php

Timestamp:

Jun 20, 2009, 4:22:51 PM (15 years ago)

Author:

george

Message:

• Opraveno: Sledování uživatelů online.

File:

• trunk/www/user.php (modified) (2 diffs)

trunk/www/user.php

@@ -45 +45 @@
     $SID = session_id();
 
+    // Lookup user record
+    $Query = $this->Database->select('UserOnline', '*', 'SessionId="'.$SID.'"');
+    if($Query->num_rows == 0)
+      $this->Database->insert('UserOnline', array('SessionId' => $SID, 'User' => $this->AnonymousUserId, 'LoginTime' => 'NOW()', 'ActivityTime' => 'NOW()', 'IpAddress' => GetRemoteAddress(), 'HostName' => gethostbyaddr(GetRemoteAddress()), 'ScriptName' => $_SERVER['PHP_SELF']));
+    //echo($this->Database->LastQuery);
+
     // Check login
     $Query = $this->Database->select('UserOnline', '*', 'SessionId="'.$SID.'"');
@@ -70 +76 @@
     // Lookup user record
     $Query = $this->Database->select('UserOnline', '*', 'SessionId="'.$SID.'"');
-    if($Query->num_rows > 0)
-    {
-      // Refresh time of last access
-      $this->Database->update('UserOnline', 'SessionId="'.$SID.'"', array('ActivityTime' => 'NOW()'));
-    } else $this->Database->insert('UserOnline', array('SessionId' => $SID, 'User' => $this->AnonymousUserId, 'LoginTime' => 'NOW()', 'ActivityTime' => 'NOW()', 'IpAddress' => GetRemoteAddress(), 'HostName' => gethostbyaddr(GetRemoteAddress()), 'ScriptName' => $_SERVER['PHP_SELF']));
-    //echo($this->Database->LastQuery);
-
-    // Check login
-    $Query = $this->Database->select('UserOnline', '*', 'SessionId="'.$SID.'"');
-    $Row = $Query->fetch_assoc();
-    if($Row['User'] != $this->AnonymousUserId) 
-    {
-      $Query = $this->Database->select('User', '*', 'Id='.$Row['User']);
-      $this->User = $Query->fetch_assoc();
-      $Result = USER_LOGGED;
-    } else 
-    {
-      $Query = $this->Database->select('User', '*', 'Id='.$this->AnonymousUserId);
-      $this->User = $Query->fetch_assoc();
-      $Result = USER_NOT_LOGGED;
-    }
+    if($Query->num_rows == 0)
+      $this->Database->insert('UserOnline', array('SessionId' => $SID, 'User' => $this->AnonymousUserId, 'LoginTime' => 'NOW()', 'ActivityTime' => 'NOW()', 'IpAddress' => GetRemoteAddress(), 'HostName' => gethostbyaddr(GetRemoteAddress()), 'ScriptName' => $_SERVER['PHP_SELF']));
+
+    // Refresh time of last access
+    $this->Database->update('UserOnline', 'SessionId="'.$SID.'"', array('ActivityTime' => 'NOW()'));
 
     //$this->LoadPermission($this->User['Role']);