Changeset 633 for trunk/inc/realm.php

Timestamp:

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

Author:

george

Message:

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

File:

• trunk/inc/realm.php (modified) (3 diffs)

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']);
+    }
   }