Changeset 16

Timestamp:

Jun 12, 2009, 8:47:16 AM (15 years ago)

Author:

george

Message:

• Přidáno: Funkce pro vytvoření zálohy a obnovení databáze ze zálohy.
• Upraveno: Funkce přidávání úloh do fronty přesunuta do samostatné třídy Task.

Location:

trunk/www

Files:

• backup.php (modified) (2 diffs)
• emulator.php (modified) (4 diffs)
• form.php (modified) (1 diff)
• form_classes.php (modified) (2 diffs)
• server.php (modified) (6 diffs)
• table.php (modified) (1 diff)
• task.php (modified) (1 diff)

trunk/www/backup.php

@@ -4 +4 @@
 {
   var $Id;
+  var $Tash;
   
   function __construct($Database, $Id)
   {
     $this->Database = $Database;
+    $this->Task = new Task($Database);
     $this->Id = $Id;
     $DbResult = $this->Database->query('SELECT * FROM `Backup` WHERE `Id`='.$Id);
@@ -13 +15 @@
   }
   
-  function Restore($Id)
+  function Restore()
   {
-    
+    $this->Task->Add('Obnovení databáze', array(
+      'mysql --silent --skip-column-names -u server'.$ServerId.' -pserver'.$ServerId.' server'.$ServerId.'_mangos -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$ServerId.' -pserver'.$ServerId.' server'.$ServerId.'_mangos',
+      'mysql --silent --skip-column-names -u server'.$ServerId.' -pserver'.$ServerId.' server'.$ServerId.'_characters -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$ServerId.' -pserver'.$ServerId.' server'.$ServerId.'_characters',
+      'mysql --silent --skip-column-names -u server'.$ServerId.' -pserver'.$ServerId.' server'.$ServerId.'_realmd -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$ServerId.' -pserver'.$ServerId.' server'.$ServerId.'_realmd',
+      'mysql --silent --skip-column-names -u server'.$ServerId.' -pserver'.$ServerId.' server'.$ServerId.'_scriptdev2 -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$ServerId.' -pserver'.$ServerId.' server'.$ServerId.'_scriptdev2',
+      'mkdir /tmp/wowhosting',
+      'tar -xjf backup/'.$ServerId.'/backup.tar.bz2 -C /tmp/wowhosting',
+      'mysql --user server'.$ServerId.' --password server'.$ServerId.' server'.$ServerId.'_characters < /tmp/wowhosting/characters.sql',
+      'mysql --user server'.$ServerId.' --password server'.$ServerId.' server'.$ServerId.'_realmd < /tmp/wowhosting/realmd.sql',
+      'mysql --user server'.$ServerId.' --password server'.$ServerId.' server'.$ServerId.'_mangos < /tmp/wowhosting/mangos.sql',
+      'mysql --user server'.$ServerId.' --password server'.$ServerId.' server'.$ServerId.'_scriptdev2 < /tmp/wowhosting/scriptdev2.sql',
+      'rm -f /tmp/wowhosting',
+    ));
   }
   
-  function Save($Id)
+  function Create($ServerId)
   {
-    
+    $this->Task->Add('Záloha databáze serveru', array(
+      'mkdir /tmp/wowhosting',
+      'mysqldump --user server'.$ServerId.' --password server'.$ServerId.' --opt server'.$ServerId.'_characters > /tmp/wowhosting/characters.sql',
+      'mysqldump --user server'.$ServerId.' --password server'.$ServerId.' --opt server'.$ServerId.'_realmd > /tmp/wowhosting/realmd.sql',
+      'mysqldump --user server'.$ServerId.' --password server'.$ServerId.' --opt server'.$ServerId.'_mangos > /tmp/wowhosting/mangos.sql',
+      'mysqldump --user server'.$ServerId.' --password server'.$ServerId.' --opt server'.$ServerId.'_scriptdev2 > /tmp/wowhosting/scriptdev2.sql',
+      'tar -c -j /tmp/wowhosting > backup/'.$ServerId.'/backup.tar.bz2',
+      'rm -f /tmp/wowhosting',
+    ));
   }  
 }

trunk/www/emulator.php

@@ -5 +5 @@
   var $Id;
   var $Emulator;
+  var $Task;
   
   function __construct($Database, $Id)
   {
     $this->Database = $Database;
+    $this->Task = new Task(&$Database);
     $this->Id = $Id;
     $DbResult = $this->Database->query('SELECT * FROM `Emulator` WHERE `Id`='.$Id);
@@ -14 +16 @@
     $DbResult = $this->Database->query('SELECT * FROM `ClientVersion` WHERE `Id`='.$this->Emulator['ClientVersion']);
     $this->Emulator['ClientVersion'] = $DbResult->fetch_assoc();
-  }
-  
-  function AddTask($Title, $Task)
-  {
-    global $System;
-    
-    $this->Database->insert('Task', array('User' => $System->Modules['User']->User['Id'], 'Title' => $Title, 'Time' => 'NOW()', 'CommandList' => implode("\n", $Task)."\n"));
   }
   
@@ -40 +35 @@
     global $Config;
     
-    $this->AddTask('Stažení emulátoru', array(
+    $this->Task->Add('Stažení emulátoru', array(
       'cd '.$Config['BaseDir'].'emulator/'.$this->Id.'/',
       'git clone git://github.com/mangos/mangos.git source',
@@ -55 +50 @@
     global $Config;
     
-    $this->AddTask('Překlad emulátoru', array(
+    $this->Task->Add('Překlad emulátoru', array(
       'cd '.$Config['BaseDir'].'emulator/'.$this->Id.'/source',
       'autoreconf -ifv',

trunk/www/form.php

@@ -78 +78 @@
     foreach($this->Definition['Items'] as $Index => $Item)
     {
-      $this->Values[$Item['Name']] = $DbRow[$Item['Name']];
+      $this->Values[$Index] = $DbRow[$Index];
     }
   }

trunk/www/form_classes.php

@@ -76 +76 @@
   'ServerList' => array(
     'Title' => 'Server',
-    'Table' => '(SELECT `ClientVersion`.`Version`, `Server`.`Name`, `Server`.`Id`, `Server`.`NetworkPortRealmd`, `User`.`Name` AS `UserName` FROM `Server` JOIN `User` ON `User`.`Id` = `Server`.`User` JOIN `Database` ON `Database`.`Id` = `Server`.`Database` JOIN `Emulator` ON `Emulator`.`Id` = `Database`.`Emulator` JOIN `ClientVersion` ON `ClientVersion`.`Id` = `Emulator`.`ClientVersion`) AS T',
+    'Table' => '(SELECT `ClientVersion`.`Version`, `Server`.`Name`, `Server`.`Id`, `Server`.`NetworkPortRealmd`, `User`.`Name` AS `UserName`, Server.Online, Server.CharacterOnlineCount, Server.CharacterCount, Server.AccountCount FROM `Server` JOIN `User` ON `User`.`Id` = `Server`.`User` JOIN `Database` ON `Database`.`Id` = `Server`.`Database` JOIN `Emulator` ON `Emulator`.`Id` = `Database`.`Emulator` JOIN `ClientVersion` ON `ClientVersion`.`Id` = `Emulator`.`ClientVersion`) AS T',
     'Items' => array(
       'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => ''),
@@ -83 +83 @@
       'Version' => array('Type' => 'Integer', 'Caption' => 'Verze', 'Default' => 0),
       'Online' => array('Type' => 'OnlineState', 'Caption' => 'Stav', 'Default' => 0),
-      'CharacterCount' => array('Type' => 'Integer', 'Caption' => 'Hráčů online', 'Default' => 0),
+      'CharacterOnlineCount' => array('Type' => 'Integer', 'Caption' => 'Hráčů online', 'Default' => 0),
       'AccountCount' => array('Type' => 'Integer', 'Caption' => 'Účtů', 'Default' => 0),
       'CharacterCount' => array('Type' => 'Integer', 'Caption' => 'Postav', 0),

trunk/www/server.php

@@ -9 +9 @@
   var $Id;
   var $Server;
+  var $Task;
   var $WorlddBaseNetworkPort = 8085;
   var $RealmdBaseNetworkPort = 3724;
@@ -16 +17 @@
   {
     $this->Database = $Database;
+    $this->Task = new Task(&$Database);
     $this->Id = $Id;
     $DbResult = $this->Database->query('SELECT * FROM `Server` WHERE `Id`='.$Id);
@@ -31 +33 @@
         else $this->Server['Database']['Emulator']['ClientVersion'] = array();
     }
-  }
-  
-  function AddTask($Title, $Task)
-  {
-    global $System;
-    
-    $this->Database->insert('Task', array('User' => $System->Modules['User']->User['Id'], 'Title' => $Title, 'Time' => 'NOW()', 'CommandList' => implode("\n", $Task)."\n"));
-  }
+  } 
   
   function CreateDatabase()
@@ -79 +74 @@
       array_unshift($CommandList, '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');
     }
-    $this->AddTask('Inicializace databáze', $CommandList);
-  }
+    $this->Task->Add('Inicializace databáze', $CommandList);
+  } 
   
   function AddServer($Version)
@@ -89 +84 @@
   function Start()
   {
-    $this->AddTask('Start emulátoru', array(
+    $this->Task->Add('Start emulátoru', array(
       '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',
       'screen -A -m -d -S server'.$this->Id.'-worldd server/'.$this->Id.'/bin/start.sh',
@@ -98 +93 @@
   function Stop()
   {
-    $this->AddTask('Zastavení emulátoru', array(
+    $this->Task->Add('Zastavení emulátoru', array(
       'server/'.$this->Id.'/bin/stop.sh',
     ));

trunk/www/table.php

@@ -26 +26 @@
     foreach($QueryParts as $Part)
     {
-      $Part2 = explode('=', $Part);
-      $QueryItems[$Part2[0]] = $Part2[1];
+      if($Part != '')
+      {
+        $Part2 = explode('=', $Part);
+        $QueryItems[$Part2[0]] = $Part2[1];
+      }
     }
     $QueryItems['Order'] = $_GET['Order'];

trunk/www/task.php

@@ -8 +8 @@
   {
     $this->Database = $Database;
-  }  
+  }
+  
+  function Add($Title, $Task)
+  {
+    global $System;
+    
+    $this->Database->insert('Task', array('User' => $System->Modules['User']->User['Id'], 'Title' => $Title, 'Time' => 'NOW()', 'CommandList' => implode("\n", $Task)."\n"));
+  } 
 
   function ProcessAll()