Changeset 63 for trunk/www/model/realm.php

Timestamp:

Aug 5, 2009, 8:06:27 AM (15 years ago)

Author:

george

Message:

• Přidáno: Funkce a skript pro aktualizaci stavových údajů. Bude prováděno každou minutu nebo automaticky přímo systémem při určitých operacích.
• Opraveno: Generování přístupu k databázi v nastavení emulátoru.

File:

• trunk/www/model/realm.php (modified) (4 diffs)

trunk/www/model/realm.php

@@ -213 +213 @@
     $EmulatorConfig = new MangosConfigurationFile($this->Database);
     $EmulatorConfig->Load($EmulatorEtcDir.'mangosd.conf.dist');
-    $EmulatorConfig->ParameterList['LoginDatabaseInfo'] = 'localhost;3306;server'.$this->Id.';server'.$this->Id.';server'.$this->Data['Server'].'_realmd';
-    $EmulatorConfig->ParameterList['WorldDatabaseInfo'] = 'localhost;3306;server'.$this->Id.';server'.$this->Id.';realm'.$this->Id.'_mangos';
+    $EmulatorConfig->ParameterList['LoginDatabaseInfo'] = 'localhost;3306;server'.$this->Data['Server'].';server'.$this->Data['Server'].';server'.$this->Data['Server'].'_realmd';
+    $EmulatorConfig->ParameterList['WorldDatabaseInfo'] = 'localhost;3306;server'.$this->Data['Server'].';server'.$this->Data['Server'].';realm'.$this->Id.'_mangos';
     $EmulatorConfig->ParameterList['CharacterDatabaseInfo'] = 'localhost;3306;server'.$this->Data['Server'].';server'.$this->Data['Server'].';realm'.$this->Id.'_characters';
     $EmulatorConfig->ParameterList['ScriptDev2DatabaseInfo'] = 'localhost;3306;server'.$this->Data['Server'].';server'.$this->Data['Server'].';realm'.$this->Id.'_scriptdev2';
@@ -307 +307 @@
     $Output = array();
     if(isset($this->Data['Database']['Emulator']['Id']))
-      exec('ps -aux|grep "emulator/'.$this->Data['Database']['Emulator']['Id'].'/bin/mangos-worldd -c realm/'.$this->Id.'/etc/mangosd.conf"| grep -v grep', $Output);
+      exec('ps aux|grep "emulator/'.$this->Data['Database']['Emulator']['Id'].'/bin/mangos-worldd -c realm/'.$this->Id.'/etc/mangosd.conf"| grep -v grep', $Output);
     if(count($Output) > 0)
     {
@@ -321 +321 @@
     while(true)
     {
-      $Reders = array($File);
-      if(stream_select($Reders, $Writers=null, $Except=null, 0, 15) < 1)
+      $Readers = array($File);
+      if(stream_select($Readers, $Writers=null, $Except=null, 0, 15) < 1)
       {
         continue;
@@ -343 +343 @@
     return($DbRow['User']);
   }
+  
+  function UpdateState()
+  {
+    $State = $this->GetState();
+    $this->Database->update('Realm', 'Id='.$this->Id, array(
+      'Online' => $State['Online'], 
+      'CharacterOnlineCount' => $State['CharacterOnlineCount'],
+      'CharacterCount' => $State['CharacterCount'],  
+    ));
+  }
+  
+  function UpdateStateAll()
+  {
+    $DbResult = $this->Database->select('Realm', 'Id');
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Realm = new Realm($this->Database, $DbRow['Id']);
+      $Realm->UpdateState();
+    }    
+  } 
 }