Changeset 681 for trunk/inc/realm.php


Ignore:
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:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk

    • Property svn:ignore
      •  

        old new  
        1 mm
        2 Thumbs.db
         1gallery
         2armory
         3tester
         4test
         5minimanager
         6mmfpm
  • trunk/inc/realm.php

    r634 r681  
    1111    parent::__construct($System);
    1212    $this->Id = $Id;
    13     $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']);
    14     if($this->Database->connect_error)
     13    $DbResult = $this->Database->query('SELECT * FROM Realm WHERE Id='.$Id);
     14    $this->Data = $DbResult->fetch_assoc();
     15    $this->CharactersDatabase = new Database($this->Data['DatabaseHost'], $this->Data['DatabaseUser'], $this->Data['DatabasePassword'], $this->Data['DatabaseCharacters']);
     16    $this->CharactersDatabase->select_db($this->Data['DatabaseCharacters']);
     17    if($this->CharactersDatabase->connect_error)
    1518    {
    16       //die('Přihlášení k databázi realmu '.$this->Id.' selhalo: '.$this->Database->connect_error);
     19      die('Přihlášení k databázi realmu '.$this->Id.' selhalo: '.$this->Database->connect_error);
    1720    }
    18     $this->Database->charset($this->Config['Database']['Charset']);
     21    $this->CharactersDatabase->charset($this->Config['Database']['Charset']);
     22   
     23    $this->MangosDatabase = new Database($this->Data['DatabaseHost'], $this->Data['DatabaseUser'], $this->Data['DatabasePassword'], $this->Data['DatabaseMangos']);
     24    $this->MangosDatabase->select_db($this->Data['DatabaseMangos']);
     25    if($this->MangosDatabase->connect_error)
     26    {
     27      die('Přihlášení k databázi realmu '.$this->Id.' selhalo: '.$this->MangosDatabase->connect_error);
     28    }
     29    $this->MangosDatabase->charset($this->Config['Database']['Charset']);
    1930  }
    2031 
    2132  function OnlineCharactersCount()
    2233  {
    23     if($this->Database->connect_error) return(0);
     34    if($this->CharactersDatabase->connect_error) return(0);
    2435    else {
    25       $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);   
    26       $DbResult = $this->Database->query('SELECT COUNT(*) FROM `characters` WHERE `online` = 1');
     36      $DbResult = $this->CharactersDatabase->query('SELECT COUNT(*) FROM `characters` WHERE `online` = 1');
    2737      $DbRow = $DbResult->fetch_row();
    2838      return($DbRow[0]);
     
    4757  public function CharacterCount()
    4858  {
    49     if($this->Database->connect_error) return('');
     59    if($this->CharactersDatabase->connect_error) return('');
    5060    else {
    51       $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);   
    52       $DbResult = $this->Database->query('SELECT COUNT(*) FROM `characters`');
     61      $DbResult = $this->CharactersDatabase->query('SELECT COUNT(*) FROM `characters`');
    5362      $DbRow = $DbResult->fetch_row();
    5463      return($DbRow[0]);
     
    5867  public function GuidToCharName($guid)
    5968  {
    60     if($this->Database->connect_error) return(0);
     69    if($this->CharactersDatabase->connect_error) return(0);
    6170    else {
    62       $this->Database->select_db($this->Config['Mangos']['RealmList'][$this->Id]['DatabaseCharacters']);
    63       $row = $this->Database->query('SELECT `name` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1')->fetch_array();
     71      $row = $this->CharactersDatabase->query('SELECT `name` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1')->fetch_array();
    6472      return($row['name']);
    6573    }
     
    8997        $edited = str_replace(")]", ";", $edited);          // 5 - selected guid
    9098        $edited_arr = explode(";",$edited);
    91         if($edited_arr[4] == "player") $sel_name = " - ".$this -> GuidToCharName($edited_arr[5]);
     99        if($edited_arr[4] == "player") $sel_name = " - ".$this->GuidToCharName($edited_arr[5]);
    92100          else $sel_name = '';
    93         $human_date = $this -> HumanDate ($edited_arr[0]);
     101        $human_date = $this -> HumanDate($edited_arr[0]);
    94102        echo('<tr>
    95103            <td><font size="2">'.$human_date.'</font></td>
     
    107115        $edited = str_replace(")", "", $edited);
    108116        $edited_arr = explode(";",$edited);
    109         $human_date = $this -> HumanDate ($edited_arr[0]);
     117        $human_date = $this -> HumanDate($edited_arr[0]);
    110118        echo('<tr>
    111119            <td><font size="2">'.$human_date.'</font></td>
Note: See TracChangeset for help on using the changeset viewer.