Changeset 57 for trunk/www/model/server.php

Timestamp:

Aug 4, 2009, 5:32:06 PM (15 years ago)

Author:

george

Message:

• Opraveno: Dále posunuta funkčnost podpory více světů na server.

File:

• trunk/www/model/server.php (modified) (14 diffs)

trunk/www/model/server.php

@@ -1 +1 @@
 <?php
 
-function ErrorHandler()
-{
-}
-  
 class Server extends Module
 {
@@ -35 +31 @@
   {
     $this->Database->query('CREATE DATABASE `server'.$this->Id.'_realmd`');
-    $this->Database->query('CREATE DATABASE `server'.$this->Id.'_mangos`');
-    $this->Database->query('CREATE DATABASE `server'.$this->Id.'_characters`');
-    $this->Database->query('CREATE DATABASE `server'.$this->Id.'_scriptdev2`');
     $this->Database->query('CREATE USER "server'.$this->Id.'"@"localhost" IDENTIFIED BY "server'.$this->Id.'"');
     $this->Database->query('GRANT ALL PRIVILEGES ON `server'.$this->Id.'\_realmd` . * TO "server'.$this->Id.'"@"localhost" WITH GRANT OPTION');
-    $this->Database->query('GRANT ALL PRIVILEGES ON `server'.$this->Id.'\_mangos` . * TO "server'.$this->Id.'"@"localhost" WITH GRANT OPTION');
-    $this->Database->query('GRANT ALL PRIVILEGES ON `server'.$this->Id.'\_characters` . * TO "server'.$this->Id.'"@"localhost" WITH GRANT OPTION');
-    $this->Database->query('GRANT ALL PRIVILEGES ON `server'.$this->Id.'\_scriptdev2` . * TO "server'.$this->Id.'"@"localhost" WITH GRANT OPTION');
   }
   
@@ -48 +38 @@
   {
     $this->Database->query('DROP DATABASE `server'.$this->Id.'_realmd`');
-    $this->Database->query('DROP DATABASE `server'.$this->Id.'_mangos`');
-    $this->Database->query('DROP DATABASE `server'.$this->Id.'_characters`');
-    $this->Database->query('DROP DATABASE `server'.$this->Id.'_scriptdev2`');
     $this->Database->query('DROP USER "server'.$this->Id.'"@"localhost"');
   }
@@ -63 +50 @@
     {
       $CommandList = array_merge($CommandList, array(
-        'mysql --silent --skip-column-names -u server'.$this->Id.' -pserver'.$this->Id.' server'.$this->Id.'_mangos -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$this->Id.' -pserver'.$this->Id.' server'.$this->Id.'_mangos',
-        'mysql --silent --skip-column-names -u server'.$this->Id.' -pserver'.$this->Id.' server'.$this->Id.'_characters -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$this->Id.' -pserver'.$this->Id.' server'.$this->Id.'_characters',
       'mysql --silent --skip-column-names -u server'.$this->Id.' -pserver'.$this->Id.' server'.$this->Id.'_realmd -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$this->Id.' -pserver'.$this->Id.' server'.$this->Id.'_realmd',
-      'mysql --silent --skip-column-names -u server'.$this->Id.' -pserver'.$this->Id.' server'.$this->Id.'_scriptdev2 -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$this->Id.' -pserver'.$this->Id.' server'.$this->Id.'_scriptdev2',
       ));
     }
@@ -74 +58 @@
     
     $CommandList = array_merge($CommandList, array(
-      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_mangos < database/'.$Database['Id'].'/'.$Database['SourceFileName'],
-      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_scriptdev2 < emulator/'.$Database['Emulator']['Id'].'/source/src/bindings/ScriptDev2/sql/scriptdev2_create_structure.sql',
-      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_scriptdev2 < emulator/'.$Database['Emulator']['Id'].'/source/src/bindings/ScriptDev2/sql/scriptdev2_script_full.sql',
-      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_mangos < emulator/'.$Database['Emulator']['Id'].'/source/src/bindings/ScriptDev2/sql/mangos_scriptname_full.sql',
       'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_realmd < emulator/'.$Database['Emulator']['Id'].'/share/mangos/sql/realmd.sql',
-      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_characters < emulator/'.$Database['Emulator']['Id'].'/share/mangos/sql/characters.sql',
       'php www/shell.php ServerDatabaseChange '.$this->Id.' '.$Database['Id'],
       'php www/shell.php ServerUnLock '.$this->Id,
@@ -116 +95 @@
     return('Požadavek na zastavení serveru zařazen.');
   }
-  
-  function NetworkPortState($Address, $Port, $Timeout = 1)
-  {
-    set_error_handler('ErrorHandler');
-    if($Socket = @fsockopen($Address, $Port, $ERROR_NO, $ERROR_STR, (float)$Timeout))
-    {
-      fclose($Socket);
-      $Result = true;
-    } else $Result = false;
-    restore_error_handler();
-    return($Result);
-  }
-  
+   
   function GetState()
   {
+    global $System;
+    
     $State = array();
-    $State['RealmdPortState'] = $this->NetworkPortState('localhost', $this->Server['NetworkPortRealmd']);
+    $State['RealmdPortState'] = $System->NetworkPortState('localhost', $this->Server['NetworkPortRealmd']);
     $State['Online'] = $State['RealmdPortState'];
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = "server'.$this->Id.'_realmd"');
@@ -160 +129 @@
     global $Config;
     
-    $this->Database->query('UPDATE server'.$this->Id.'_realmd.realmlist SET name="'.addslashes($this->Server['Name']).'", address="'.$Config['Web']['Host'].'", port='.($this->Server['NetworkPortWorldd']));
+    $this->Database->query('TRUNCATE TABLE server'.$this->Id.'_realmd.realmlist');
+    $DbResult = $this->Database->select('Realm', '*', 'Server = '.$this->Id);
+    while($Realm = $DbResult->fetch_assoc())
+    {
+      $this->Database->insert('server'.$this->Id.'_realmd`.`realmlist', array('name' => addslashes($Realm['Name']), 'address' => $Config['Web']['Host'], 'port' => $Realm['NetworkPortWorldd']));
+    }
   }
   
@@ -175 +149 @@
     
     $ServerBinDir = '../server/'.$this->Id.'/bin/';
-    if(!file_exists($ServerBinDir)) mkdir($ServerBinDir, 0777, true);    
-    
-    // GDB script
-    $ScriptFileName = '../server/'.$this->Id.'/bin/mangos.gdb';
-    $Content = array
-    (
-      'run -c server/'.$this->Id.'/etc/mangosd.conf',
-      'info thread',
-    );
-    for($I = 1; $I < $Config['MangosWorlddThreadCountMax']; $I++)
-      $Content[] = 'thread apply '.$I.' bt full';
-    file_put_contents($ScriptFileName, implode("\n", $Content));
-    chmod($ScriptFileName, 0666);    
+    if(!file_exists($ServerBinDir)) mkdir($ServerBinDir, 0777, true);       
 
     // Start script
@@ -198 +160 @@
       'screen -A -m -d -S server'.$this->Id.'-realmd emulator/'.$this->Server['Database']['Emulator']['Id'].'/bin/mangos-realmd -c server/'.$this->Id.'/etc/realmd.conf',
       'fi',
-      'if [ -z `ps -ef | grep \'SCREEN -A -m -d -S server'.$this->Id.'-worldd\' | grep -v grep | awk \'{print $2}\'` ]',
-      'then',
-      'screen -A -m -d -S server'.$this->Id.'-worldd server/'.$this->Id.'/bin/worldd_restarter.sh',
-      'fi',
-    );
-    file_put_contents($ScriptFileName, implode("\n", $Content));
-    chmod($ScriptFileName, 0777);    
-
-    $ScriptFileName = '../server/'.$this->Id.'/bin/worldd_restarter.sh';
-    $Content = array
-    (
-      '#!/bin/sh',
-      'while [ 1=1 ] ; do',
-      'gdb emulator/'.$this->Server['Database']['Emulator']['Id'].'/bin/mangos-worldd -x server/'.$this->Id.'/bin/mangos.gdb --batch >>server/'.$this->Id.'/log/mangos-worldd.log 2>>server/'.$this->Id.'/log/mangos-worldd.err',
-      'cd www',
-      'php shell.php ServerProcessLog '.$this->Id.' >>server/'.$this->Id.'/log/mangos_debug.log 2>>server/'.$this->Id.'/log/mangos_debug.err',
-      'cd ..',
-      'sleep 3',
-      'done',
     );
     file_put_contents($ScriptFileName, implode("\n", $Content));
@@ -227 +170 @@
       '#!/bin/sh',
       'ps -ef | grep \'SCREEN -A -m -d -S server'.$this->Id.'-realmd\' | grep -v grep | awk \'{print $2}\' | xargs -i kill {}',
-      'ps -ef | grep \'SCREEN -A -m -d -S server'.$this->Id.'-worldd\' | grep -v grep | awk \'{print $2}\' | xargs -i kill {}',
     );
     file_put_contents($ScriptFileName, implode("\n", $Content));
@@ -243 +185 @@
     if(!file_exists($ServerLogDir)) mkdir($ServerLogDir, 0777, true);    
     
-    // mangosd.conf
-    $EmulatorConfig = new MangosConfigurationFile($this->Database);
-    $EmulatorConfig->Load($EmulatorEtcDir.'mangosd.conf.dist');
-    $EmulatorConfig->ParameterList['LoginDatabaseInfo'] = 'localhost;3306;server'.$this->Id.';server'.$this->Id.';server'.$this->Id.'_realmd';
-    $EmulatorConfig->ParameterList['WorldDatabaseInfo'] = 'localhost;3306;server'.$this->Id.';server'.$this->Id.';server'.$this->Id.'_mangos';
-    $EmulatorConfig->ParameterList['CharacterDatabaseInfo'] = 'localhost;3306;server'.$this->Id.';server'.$this->Id.';server'.$this->Id.'_characters';
-    $EmulatorConfig->ParameterList['ScriptDev2DatabaseInfo'] = 'localhost;3306;server'.$this->Id.';server'.$this->Id.';server'.$this->Id.'_scriptdev2';
-    $EmulatorConfig->ParameterList['WorldServerPort'] = $this->Server['NetworkPortWorldd'];
-    $EmulatorConfig->ParameterList['Motd'] = $this->Server['Motd'];
-    $EmulatorConfig->ParameterList['DataDir'] = 'wowclient/'.$this->Server['Database']['Emulator']['Client']['Version'];
-    $EmulatorConfig->ParameterList['LogsDir'] = 'server/'.$this->Id.'/log';
-    $EmulatorConfig->ParameterList['LogLevel'] = 1;
-    $EmulatorConfig->ParameterList['PlayerLimit'] = $Config['MaxOnlinePlayerCountPerServer'];
-    $EmulatorConfig->ParameterList['PlayerSaveInterval'] = 300000;    
-    $EmulatorConfig->ParameterList['LogSQL'] = 0;
-    $ServerTypes = array(0 => 0, 1 => 1, 2 => 6, 3 => 8);
-    $EmulatorConfig->ParameterList['GameType'] = $ServerTypes[$this->Server['Type']];
-    $EmulatorConfig->Save($ServerEtcDir.'mangosd.conf');
-   
     // realmd.conf
     $EmulatorConfig = new MangosConfigurationFile($this->Database);
@@ -269 +192 @@
     $EmulatorConfig->ParameterList['LogsDir'] = 'server/'.$this->Id.'/log';
     $EmulatorConfig->Save($ServerEtcDir.'realmd.conf');
-   
-    // scriptdev2.conf
-    $EmulatorConfig = new MangosConfigurationFile($this->Database);
-    $EmulatorConfig->Load($EmulatorEtcDir.'scriptdev2.conf');
-    $EmulatorConfig->ParameterList['ScriptDev2DatabaseInfo'] = 'localhost;3306;server'.$this->Id.';server'.$this->Id.';server'.$this->Id.'_scriptdev2';
-    $EmulatorConfig->Save($ServerEtcDir.'scriptdev2.conf');  
   }
   
@@ -379 +296 @@
   function GetUsedMemory()
   {
-    $Output = array();
-    if(isset($this->Server['Database']['Emulator']['Id']))
-      exec('ps -aux|grep "emulator/'.$this->Server['Database']['Emulator']['Id'].'/bin/mangos-worldd -c server/'.$this->Id.'/etc/mangosd.conf"| grep -v grep', $Output);
-    if(count($Output) > 0)
-    {
-      while(strpos($Output[0], '  ') > 0) $Output[0] = str_replace('  ', ' ', $Output[0]);
-      $Parts = explode(' ', $Output[0]);
-      return($Parts[4]);
-    } else return(0);
+    $UsedMemory = 0;
+    $DbResult = $this->Database->select('Realm', 'Id', 'Server='.$this->Id);
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Realm = new Realm($this->Database, $DbRow['Id']);
+      $UsedMemory += $Realm->GetUsedMemory();
+    }
+    return($UsedMemory);
   }  
 
@@ -400 +316 @@
     }
     return(implode("\n", $Output));
-  }
-  
-  function ProcessLog()
-  {
-    $File = fopen('../server/'.$this->Id.'/log/mangos-worldd.log', 'r');
-    while(true)
-    {
-      $Reders = array($File);
-      if(stream_select($Reders, $Writers=null, $Except=null, 0, 15) < 1)
-      {
-        continue;
-      } else
-      {
-        // read data from the fifo
-        $Data = fread($File, 1024);
-        echo($Data);
-        $this->Database->insert('ServerLog', array('Time' => 'NOW()', 'Server' => $this->Id, 'Text' => $Data));
-      }         
-      sleep(1);
-    }
-    fclose($File);
-  }
+  } 
+  
+  function RealmCount()
+  {
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Realm WHERE Server='.$this->Id);
+    $DbRow = $DbResult->fetch_row();
+    return($DbRow[0]);
+  }  
 }