Changeset 681 for trunk/inc/server.php

Timestamp:

Jan 23, 2010, 1:32:45 PM (15 years ago)

Author:

george

Message:

• Upraveno: Nastavení počítačů, přihlašovacích serverů a světů přesunuto do databáze z konfiguračního souboru.

Location:

trunk

Files:

• . (modified) (1 prop)
• inc/server.php (modified) (6 diffs)

trunk

@@ -1 @@
-mm
-Thumbs.db
+gallery
+armory
+tester
+test
+minimanager
+mmfpm

@@ -1 @@
-mm
-Thumbs.db
+gallery
+armory
+tester
+test
+minimanager
+mmfpm

trunk/inc/server.php

@@ -13 +13 @@
     parent::__construct($System);
     $this->Id = $Id;
+    $DbResult = $this->Database->query('SELECT * FROM Logon WHERE Id='.$Id);
+    $this->Data = $DbResult->fetch_assoc();
+    $this->ServerDatabase = new Database($this->Data['DatabaseHost'], $this->Data['DatabaseUser'], $this->Data['DatabasePassword'], $this->Data['DatabaseRealmd']);
+    $this->ServerDatabase->select_db($this->Data['DatabaseRealmd']);
+    if($this->ServerDatabase->connect_error) 
+    {
+      die('Přihlášení k databázi serveru '.$this->Id.' selhalo: '.$this->ServerDatabase->connect_error);
+    }
+    $this->ServerDatabase->charset($this->Config['Database']['Charset']);
   }
 
@@ -44 +53 @@
   {
     $TotalCount = 0;
-    foreach($this->Config['Mangos']['RealmList'] as $Index => $Realm)
+    $DbResult = $this->Database->query('SELECT Id FROM Realm');
+    while($DbRow = $DbResult->fetch_assoc())
     {
-      $Realm = new Realm($this->System, $Index);
+      $Realm = new Realm($this->System, $DbRow['Id']);
       $TotalCount += $Realm->OnlineCharactersCount();
     }
@@ -61 +71 @@
   {
     $TotalCount = 0;
-    foreach($this->Config['Mangos']['RealmList'] as $Index => $Realm)
+    $DbResult = $this->Database->query('SELECT Id FROM Realm');
+    while($DbRow = $DbResult->fetch_assoc())
     {
-      $Realm = new Realm($this->System, $Index);
-      $TotalCount += $Realm->CharacterCount($Index);
+      $Realm = new Realm($this->System, $DbRow['Id']);
+      $TotalCount += $Realm->CharacterCount($DbRow['Id']);
     }
     return($TotalCount);
@@ -71 +82 @@
   public function AccountCount()
   {
-    $this->Database->select_db($this->Config['Mangos']['DatabaseRealmd']);
-    $row = $this->Database->query('SELECT COUNT(*) FROM account')->fetch_row();
+    $row = $this->ServerDatabase->query('SELECT COUNT(*) FROM account')->fetch_row();
     return($row[0]);
   }
@@ -362 +372 @@
   {
     $Output = '';
-    if(count($this->Config['Mangos']['RealmList']) > 1)
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Realm');
+    $DbRow = $DbResult->fetch_row();
+    $RealmCount = $DbRow[0];
+    
+    if($RealmCount > 1)
     { 
       if(array_key_exists('page', $_GET)) $Target = '?page='.$_GET['page'];
@@ -368 +382 @@
       $Output .= '<div style="text-align: center;"><form id="RealmSelection'.$FormNameSufix.'" action="'.$Target.'" method="post">'.
       '<div>Výběr světa <select name="RealmIndex" onchange="document.getElementById(\'RealmSelection'.$FormNameSufix.'\').submit()">';
-      foreach($this->Config['Mangos']['RealmList'] as $Index => $Realm)
+      
+      $DbResult = $this->Database->query('SELECT * FROM Realm');
+      while($Realm = $DbResult->fetch_assoc())
       {
-        if($_COOKIE['RealmIndex'] == $Index) $Selected = ' selected="selected"';
+        if($_COOKIE['RealmIndex'] == $Realm['Id']) $Selected = ' selected="selected"';
          else $Selected = '';
-        $Output .= '<option value="'.$Index.'"'.$Selected.'>'.$Realm['Name'].'</option>';
+        $Output .= '<option value="'.$Realm['Id'].'"'.$Selected.'>'.$Realm['Name'].'</option>';
       }
       $Output .= '</select></div>'.

@@ -1 @@
-mm
-Thumbs.db
+gallery
+armory
+tester
+test
+minimanager
+mmfpm