Changeset 15 for trunk/www/server.php

Timestamp:

Jun 12, 2009, 8:09:48 AM (15 years ago)

Author:

george

Message:

• Přidáno: Nastavení parametrů gcc překladu emulátoru přes konfigurační soubor.
• Přidáno: Podpora řazení dle sloupců v tabulkách.
• Upraveno: Nezjišťovat informace o stavu serverů z tabulek mangosu, ale ukládat stavové informace serverů přímo do tabulky Server. Nutno provádět aktualizaci tabulky.

File:

• trunk/www/server.php (modified) (3 diffs)

trunk/www/server.php

@@ -18 +18 @@
     $this->Id = $Id;
     $DbResult = $this->Database->query('SELECT * FROM `Server` WHERE `Id`='.$Id);
-    $this->Server = $DbResult->fetch_assoc();
-    $DbResult = $this->Database->query('SELECT * FROM `Database` WHERE `Id`='.$this->Server['Database']);
-    if($DbResult->num_rows > 0) $this->Server['Database'] = $DbResult->fetch_assoc();
-      else $this->Server['Database'] = array('Emulator' => 0);
-    $DbResult = $this->Database->query('SELECT * FROM `Emulator` WHERE `Id`='.$this->Server['Database']['Emulator']);
-    if($DbResult->num_rows > 0) $this->Server['Database']['Emulator'] = $DbResult->fetch_assoc();
-      else $this->Server['Database']['Emulator'] = array('ClientVersion' => 0);
-    $DbResult = $this->Database->query('SELECT * FROM `ClientVersion` WHERE `Id`='.$this->Server['Database']['Emulator']['ClientVersion']);
-    if($DbResult->num_rows > 0) $this->Server['Database']['Emulator']['ClientVersion'] = $DbResult->fetch_assoc();
-      else $this->Server['Database']['Emulator']['ClientVersion'] = array();
+    if($DbResult->num_rows > 0)
+    {
+      $this->Server = $DbResult->fetch_assoc();
+      $DbResult = $this->Database->query('SELECT * FROM `Database` WHERE `Id`='.$this->Server['Database']);
+      if($DbResult->num_rows > 0) $this->Server['Database'] = $DbResult->fetch_assoc();
+        else $this->Server['Database'] = array('Emulator' => 0);
+      $DbResult = $this->Database->query('SELECT * FROM `Emulator` WHERE `Id`='.$this->Server['Database']['Emulator']);
+      if($DbResult->num_rows > 0) $this->Server['Database']['Emulator'] = $DbResult->fetch_assoc();
+        else $this->Server['Database']['Emulator'] = array('ClientVersion' => 0);
+      $DbResult = $this->Database->query('SELECT * FROM `ClientVersion` WHERE `Id`='.$this->Server['Database']['Emulator']['ClientVersion']);
+      if($DbResult->num_rows > 0) $this->Server['Database']['Emulator']['ClientVersion'] = $DbResult->fetch_assoc();
+        else $this->Server['Database']['Emulator']['ClientVersion'] = array();
+    }
   }
   
@@ -125 +128 @@
       $DbResult = $this->Database->query('SELECT COUNT(*) FROM server'.$this->Id.'_characters.characters AS T WHERE T.online = 1');
       $DbRow = $DbResult->fetch_row();
-      $State['OnlinePlayerCount'] = $DbRow[0];
+      $State['CharacterOnlineCount'] = $DbRow[0];
       $DbResult = $this->Database->query('SELECT COUNT(*) FROM server'.$this->Id.'_characters.characters AS T');
       $DbRow = $DbResult->fetch_row();
@@ -237 +240 @@
     $Config->Save($ServerEtcDir.'scriptdev2.conf');  
   }
+  
+  function UpdateServerList()
+  {
+    $DbResult = $this->Database->select('Server', 'Id');
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Server = new Server($this->Database, $DbRow['Id']);
+      $ServerState = $Server->GetState();
+      $this->Database->update('Server', 'Id='.$DbRow['Id'], array(
+        'Online' => $ServerState['Online'], 
+        'CharacterOnlineCount' => $ServerState['CharacterOnlineCount'],
+        'CharacterCount' => $ServerState['CharacterCount'],
+        'AccountCount' => $ServerState['AccountCount'],
+      ));
+    }    
+  }
 }