Changeset 40

Timestamp:

Jun 16, 2009, 6:16:36 PM (15 years ago)

Author:

george

Message:

• Opraveno: Chyba načtení uptime serveru pokud chybí tato tabulka v novém místě.

File:

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

trunk/www/server.php

@@ -137 +137 @@
       $DbRow = $DbResult->fetch_row();
       $State['AccountCount'] = $DbRow[0];
-      $DbResult = $this->Database->query('SELECT uptime FROM server'.$this->Id.'_realmd.uptime AS T ORDER BY T.startstring DESC');
-      $DbRow = $DbResult->fetch_assoc();
-      $State['Uptime'] = $DbRow['uptime'];
+      $DbResult = $this->Database->query('SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = "server'.$this->Id.'_realmd" AND TABLE_NAME = "uptime"');
+      $DbRow = $DbResult->fetch_row();
+      if($DbRow[0] > 0)
+      {
+        $DbResult = $this->Database->query('SELECT uptime FROM server'.$this->Id.'_realmd.uptime AS T ORDER BY T.startstring DESC');
+        $DbRow = $DbResult->fetch_assoc();
+        $State['Uptime'] = $DbRow['uptime'];
+      } else $State['Uptime'] = 0;
     } else
     {