Changeset 4 for trunk/www/server.php

Timestamp:

Jun 8, 2009, 9:50:59 PM (15 years ago)

Author:

george

Message:

• Přidáno: Zkušební formulář pro uložení nastavení serveru.
• Přidáno: Podpora pro načítání, změnu a ukládání konfiguračních souborů.
• Přidáno: Funkce pro start a zastavení emulátoru.
• Upraveno: V tabulce Task se nyní uchovávají úlohy k provedení včetně názvu operace a v jedné úloze může být více příkazů.

File:

• trunk/www/server.php (modified) (3 diffs)

trunk/www/server.php

@@ -12 +12 @@
     $DbResult = $this->Database->query('SELECT * FROM `Server` WHERE `Id`='.$Id);
     $this->Server = $DbResult->fetch_assoc();
+    $DbResult = $this->Database->query('SELECT * FROM `Database` WHERE `Id`='.$this->Server['Database']);
+    $this->Server['Database'] = $DbResult->fetch_assoc();
+    $DbResult = $this->Database->query('SELECT * FROM `Emulator` WHERE `Id`='.$this->Server['Database']['Emulator']);
+    $this->Server['Database']['Emulator'] = $DbResult->fetch_assoc();
   }
   
-  function AddTask($Task)
+  function AddTask($Title, $Task)
   {
-    $this->Database->insert('Task', array('Server' => $this->Server['Id'], 'Time' => 'NOW()', 'Command' => $Task));    
+    $this->Database->insert('Task', array('Server' => $this->Server['Id'], 'Title' => $Title, 'Time' => 'NOW()', 'CommandList' => implode("\n", $Task)));
   }
   
@@ -25 +29 @@
     $DbResult = $this->Database->query('SELECT `Revision` FROM `Emulator` WHERE `Id`='.$Database['Emulator']);
     $Emulator = $DbResult->fetch_assoc();
-    $this->AddTask('mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_mangos < emu/mangos/'.$Emulator['Revision'].'/udb/'.$Database['SourceFileName']);
-    $this->AddTask('mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_scriptdev2 < emu/mangos/'.$Emulator['Revision'].'/source/src/bindings/ScriptDev2/sql/scriptdev2_create_structure.sql');
-    $this->AddTask('mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_scriptdev2 < emu/mangos/'.$Emulator['Revision'].'/source/src/bindings/ScriptDev2/sql/scriptdev2_script_full.sql');
-    $this->AddTask('mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_mangos < emu/mangos/'.$Emulator['Revision'].'/source/src/bindings/ScriptDev2/sql/mangos_scriptname_full.sql');
-    $this->AddTask('mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_realmd < emu/mangos/'.$Emulator['Revision'].'/mangos/sql/realmd.sql');
-    $this->AddTask('mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_characters < emu/mangos/'.$Emulator['Revision'].'/mangos/sql/characters.sql');
+    $this->AddTask('Inicializace databáze', array(
+      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_mangos < emu/mangos/'.$Emulator['Revision'].'/udb/'.$Database['SourceFileName'],
+      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_scriptdev2 < emu/mangos/'.$Emulator['Revision'].'/source/src/bindings/ScriptDev2/sql/scriptdev2_create_structure.sql',
+      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_scriptdev2 < emu/mangos/'.$Emulator['Revision'].'/source/src/bindings/ScriptDev2/sql/scriptdev2_script_full.sql',
+      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_mangos < emu/mangos/'.$Emulator['Revision'].'/source/src/bindings/ScriptDev2/sql/mangos_scriptname_full.sql',
+      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_realmd < emu/mangos/'.$Emulator['Revision'].'/mangos/sql/realmd.sql',
+      'mysql --user=server'.$this->Id.' --password=server'.$this->Id.' server'.$this->Id.'_characters < emu/mangos/'.$Emulator['Revision'].'/mangos/sql/characters.sql'));
   }
   
@@ -40 +45 @@
   function Start()
   {
+    AddTask('Start emulátoru', array(
+      'screen -A -m -d -S server'.$this->Id.'-realmd emu/mangos/'.$this->Server['Database']['Emulator']['Revision'].'/bin/mangos-realmd -c server/'.$this->Id.'/etc/realmd.conf',
+      'screen -A -m -d -S server'.$this->Id.'-realmd emu/mangos/'.$this->Server['Database']['Emulator']['Revision'].'/bin/mangos-worldd -c server/'.$this->Id.'/etc/mangosd.conf',
+    ));
   }
   
   function Stop()
   {
+    AddTask('Zastavení emulátoru', array(
+      '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 {}',
+    ));
   }
 }