Changeset 48 for trunk/www/platform.php

Timestamp:

Jun 20, 2009, 1:46:49 PM (15 years ago)

Author:

george

Message:

• Upraveno: Změna typu databáze z MyISAM na InnoDB a doplnění cizích klíčů.
• Přidáno: Zobrazení počtu databází ve stavu systému.

File:

• trunk/www/platform.php (modified) (1 diff)

trunk/www/platform.php

@@ -50 +50 @@
     $State['MemoryTotal'] = $this->MemoryTotal();
     $State['Uptime'] = $this->SystemUptime();
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Server');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Server`');
     $DbRow = $DbResult->fetch_row();
     $State['ServerCount'] = $DbRow[0];
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Server WHERE Online = 1');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Server` WHERE `Online` = 1');
     $DbRow = $DbResult->fetch_row();
     $State['ServerOnlineCount'] = $DbRow[0];
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM User');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `User`');
     $DbRow = $DbResult->fetch_row();
     $State['UserCount'] = $DbRow[0];
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Emulator');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Emulator`');
     $DbRow = $DbResult->fetch_row();
     $State['EmulatorCount'] = $DbRow[0];
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Backup');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Backup`');
     $DbRow = $DbResult->fetch_row();
     $State['BackupCount'] = $DbRow[0];
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Task');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Task`');
     $DbRow = $DbResult->fetch_row();
     $State['TaskCount'] = $DbRow[0];
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Task WHERE State != 2');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Database`');
+    $DbRow = $DbResult->fetch_row();
+    $State['DatabaseCount'] = $DbRow[0];
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Task` WHERE `State` != 2');
     $DbRow = $DbResult->fetch_row();
     $State['TaskQueued'] = $DbRow[0];