Changeset 633

Timestamp:

Sep 12, 2009, 10:50:39 PM (15 years ago)

Author:

george

Message:

• Opraveno: Zobrazování seznamu světů při jejich nedostupnosti.

Location:

trunk

Files:

• inc/realm.php (modified) (3 diffs)
• index.php (modified) (1 diff)
• pages/realmlist.wtf (modified) (1 diff)
• pages/server.php (modified) (1 diff)

trunk/inc/realm.php

@@ -10 +10 @@
     $this->Id = $Id;
     $this->Database = new Database($this->Config['Mangos']['RealmList'][$Id]['DatabaseHost'], $this->Config['Mangos']['RealmList'][$Id]['DatabaseUser'], $this->Config['Mangos']['RealmList'][$Id]['DatabasePassword'], $this->Config['Mangos']['RealmList'][$Id]['DatabaseCharacters']);
-    if(mysqli_connect_error()) 
+    if($this->Database->connect_error) 
     {
-      die('Přihlášení k databázi realmu '.$this->Id.' selhalo'); //: '.mysqli_connect_error());
+      //die('Přihlášení k databázi realmu '.$this->Id.' selhalo: '.$this->Database->connect_error);
     }
     $this->Database->charset($this->Config['Database']['Charset']);
@@ -19 +19 @@
   function OnlineCharactersCount()
   {
-    $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);    
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `characters` WHERE `online` = 1');
-    $DbRow = $DbResult->fetch_row();
-    return($DbRow[0]);
+    if($this->Database->connect_error) return(0);
+    else {
+      $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);    
+      $DbResult = $this->Database->query('SELECT COUNT(*) FROM `characters` WHERE `online` = 1');
+      $DbRow = $DbResult->fetch_row();
+      return($DbRow[0]);
+    }
   }
 
@@ -42 +45 @@
   public function CharacterCount()
   {
-    $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);    
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `characters`');
-    $DbRow = $DbResult->fetch_row();
-    return($DbRow[0]);
+    if($this->Database->connect_error) return('');
+    else {
+      $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);    
+      $DbResult = $this->Database->query('SELECT COUNT(*) FROM `characters`');
+      $DbRow = $DbResult->fetch_row();
+      return($DbRow[0]);
+    }
   }
   
   public function GuidToCharName($guid)
   {
-    $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);
-    $row = $this->Database->query('SELECT `name` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1')->fetch_array();
-    return($row['name']);
+    if($this->Database->connect_error) return(0);
+    else {
+      $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);
+      $row = $this->Database->query('SELECT `name` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1')->fetch_array();
+      return($row['name']);
+    }
   }
   

trunk/index.php

@@ -126 +126 @@
   '<script type="text/javascript">
   <!--
-  document.write("<a href=\"http://counter.cnw.cz\" target=\"_parent\"><img src=\"http://counter.cnw.cz/trackit.cgi?wowzdechov&amp;t4&amp;" + escape(top.document.referrer) + "\" alt=\"CNW:Tracker\" border=\"0\" width=\"0\" height=\"0\"></a>");
+  document.write("<a href=\"http://counter.cnw.cz\" target=\"_parent\"><img src=\"http://counter.cnw.cz/trackit.cgi?wowzdechov&t4&" + escape(top.document.referrer) + "\" alt=\"CNW:Tracker\" border=\"0\" width=\"1\" height=\"1\"><\/a>");
   // -->
   </script>'.

trunk/pages/realmlist.wtf

@@ -1 @@
-set realmlist wow.zdechov.net
+set realmlist heroesoffantasy.cz

trunk/pages/server.php

@@ -68 +68 @@
   $Output .= '<table class="BaseTable" style="width: 100%; margin: 5px;">
   <tr>
-    <th colspan="2">Server '.($Index + 1).'</td>
+    <th colspan="2">Server '.$Index.'</td>
   </tr>
   <tr>