Changeset 57

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.

Location:

trunk/www

Files:

• common/global.php (modified) (2 diffs)
• common/page.php (modified) (1 diff)
• design (deleted)
• global.php (deleted)
• include.php (modified) (3 diffs)
• index.php (modified) (5 diffs)
• init.php (added)
• model/realm.php (modified) (2 diffs)
• model/server.php (modified) (14 diffs)
• model/shell.php (modified) (4 diffs)
• model/user.php (modified) (3 diffs)
• shell.php (added)
• sql/updates/57.sql (added)
• view/base.php (modified) (1 diff)
• view/emulator.php (modified) (3 diffs)
• view/realm.php (modified) (4 diffs)
• view/server.php (modified) (14 diffs)

trunk/www/common/global.php

@@ -70 +70 @@
 );
 
+function ErrorHandler()
+{
+}
+  
 class System extends Module
 {
@@ -171 +175 @@
     return($Value.' '.$PrefixMultipliers[$PrefixType]['Definition'][$I][0].$Unit);
   }
+  
+  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);
+  }
 }
 

trunk/www/common/page.php

@@ -45 +45 @@
    ' | <a href="http://svn.zdechov.net/trac/wowhosting/log?verbose=on">Novinky</a>'.
    ' | Správce: '.$this->System->Config['Web']['Admin'].
-   ' | E-mail: '.$this->System->Config['Web']['AdminEmail'];
+   ' | E-mail: '.$this->System->Config['Web']['AdminEmail'].' | ';
     if($this->System->Config['Web']['ShowRuntimeInfo'] == true) $Output .= ' Doba generování: '.$Time.' s / '.ini_get('max_execution_time').' s | Použitá paměť: '.HumanSize(memory_get_peak_usage(FALSE)).' / '.ini_get('memory_limit').'B |';
   $Output .= '</i></div></body></html>';

trunk/www/include.php

@@ -1 +1 @@
 <?php
+
+// Change current directory to script location
+$BaseDir = substr($_SERVER['SCRIPT_FILENAME'], 0, strrpos($_SERVER['SCRIPT_FILENAME'], '/'));
+if($BaseDir != '') chdir($BaseDir);
 
 include('config.php');
@@ -25 +29 @@
 include('model/platform.php');
 include('model/history.php');
+include('model/shell.php');
 
 include('view/user.php');
@@ -39 +44 @@
 include('view/debug.php');
 
+include('init.php');
+
 ?>

trunk/www/index.php

@@ -2 +2 @@
 
 include('include.php');
-
-chdir(substr($_SERVER['SCRIPT_FILENAME'], 0, strrpos($_SERVER['SCRIPT_FILENAME'], '/')));
-
-$ScriptTimeStart = GetMicrotime();
-// SQL injection hack protection
-foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($Item);
-foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($Item);
-
-if(isset($_SERVER['REMOTE_ADDR'])) session_start();
-$Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password'], $Config['Database']['Database']);
-$Database->Prefix = $Config['Database']['Prefix'];
-$Database->charset($Config['Database']['Charset']);
-
-$System = new System($Database, null);
-$System->Config = $Config;
-$System->AddModule(new Log($Database, $System));
-$System->AddModule(new User($Database, $System));
-if(isset($_SERVER['REMOTE_ADDR'])) $System->Modules['User']->Check();
-  else $System->Modules['User']->User['Id'] = 0;
 
 class Index extends Page
@@ -116 +97 @@
         $Output .= $ServerView->Save();
       } else
-      if($_GET['Action'] == 'ServerEditDetailed')
-      {
-        $ServerView = new ServerView($this->Database, $this->System);
-        $Output .= $ServerView->EditDetailed();
-      } else
-      if($_GET['Action'] == 'ServerSaveDetailed')
-      {
-        $ServerView = new ServerView($this->Database, $this->System);
-        $Output .= $ServerView->SaveDetailed();
-      } else
       if($_GET['Action'] == 'ServerStart')
       {
@@ -161 +132 @@
         $Output .= $EmulatorView->Download();
       } else
+      if($_GET['Action'] == 'EmulatorAdd')
+      {
+        $EmulatorView = new EmulatorView($this->Database, $this->System);
+        $Output .= $EmulatorView->Add();
+      } else
+      if($_GET['Action'] == 'EmulatorAdd2')
+      {
+        $EmulatorView = new EmulatorView($this->Database, $this->System);
+        $Output .= $EmulatorView->AddFinish();
+      } else      
       if($_GET['Action'] == 'ServerDebug')
       {
@@ -196 +177 @@
         $Output .= $ServerView->AccountCreateFinish();
       } else      
-      if($_GET['Action'] == 'EmulatorAdd')
-      {
-        $EmulatorView = new EmulatorView($this->Database, $this->System);
-        $Output .= $EmulatorView->Add();
-      } else
-      if($_GET['Action'] == 'EmulatorAdd2')
-      {
-        $EmulatorView = new EmulatorView($this->Database, $this->System);
-        $Output .= $EmulatorView->AddFinish();
-      } else      
       if($_GET['Action'] == 'Info')
       {
@@ -265 +236 @@
         $RealmView = new RealmView($this->Database, $this->System);
         $Output .= $RealmView->ItemList();
+      } else
+      if($_GET['Action'] == 'RealmShow')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->Item();
+      } else
+      if($_GET['Action'] == 'RealmAdd')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->Add();
+      } else
+      if($_GET['Action'] == 'RealmCreate')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->Create();
+      } else
+      if($_GET['Action'] == 'RealmEdit')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->Edit();
+      } else
+      if($_GET['Action'] == 'RealmSave')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->Save();
+      } else
+      if($_GET['Action'] == 'RealmEditDetailed')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->EditDetailed();
+      } else
+      if($_GET['Action'] == 'RealmSaveDetailed')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->SaveDetailed();
+      } else
+      if($_GET['Action'] == 'RealmStart')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->Start();
+      } else
+      if($_GET['Action'] == 'RealmStop')
+      {
+        $RealmView = new RealmView($this->Database, $this->System);
+        $Output .= $RealmView->Stop();
       } else
       if($_GET['Action'] == 'Test')

trunk/www/model/realm.php

@@ -14 +14 @@
     $DbResult = $this->Database->query('SELECT * FROM `Realm` WHERE `Id`='.$Id);
     if($DbResult->num_rows > 0)
+    {
       $this->Data = $DbResult->fetch_assoc();
+      $DbResult = $this->Database->query('SELECT * FROM `Database` WHERE `Id`='.$this->Data['Database']);
+      if($DbResult->num_rows > 0) $this->Data['Database'] = $DbResult->fetch_assoc();
+        else $this->Data['Database'] = array('Emulator' => 0);
+      $DbResult = $this->Database->query('SELECT * FROM `Emulator` WHERE `Id`='.$this->Data['Database']['Emulator']);
+      if($DbResult->num_rows > 0) $this->Data['Database']['Emulator'] = $DbResult->fetch_assoc();
+        else $this->Data['Database']['Emulator'] = array('Client' => 0);
+      $DbResult = $this->Database->query('SELECT * FROM `Client` WHERE `Id`='.$this->Data['Database']['Emulator']['Client']);
+      if($DbResult->num_rows > 0) $this->Data['Database']['Emulator']['Client'] = $DbResult->fetch_assoc();
+        else $this->Data['Database']['Emulator']['Client'] = array();
+    }
   } 
 
   function GetState()
   {
+    global $System;
+    
     $State = array();
-    $State['WorlddPortState'] = $this->NetworkPortState('localhost', $this->Server['NetworkPortWorldd']);
+    $State['WorlddPortState'] = $System->NetworkPortState('localhost', $this->Data['NetworkPortWorldd']);
     $State['Online'] = $State['WorlddPortState'];
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = "realm'.$this->Id.'_characters"');
@@ -39 +52 @@
     return($State);
   }  
+  
+  function CreateDatabase()
+  {
+    $this->Database->query('CREATE DATABASE `realm'.$this->Id.'_mangos`');
+    $this->Database->query('CREATE DATABASE `realm'.$this->Id.'_characters`');
+    $this->Database->query('CREATE DATABASE `realm'.$this->Id.'_scriptdev2`');
+    $this->Database->query('GRANT ALL PRIVILEGES ON `realm'.$this->Id.'\_mangos` . * TO "server'.$this->Data['Server'].'"@"localhost" WITH GRANT OPTION');
+    $this->Database->query('GRANT ALL PRIVILEGES ON `realm'.$this->Id.'\_characters` . * TO "server'.$this->Data['Server'].'"@"localhost" WITH GRANT OPTION');
+    $this->Database->query('GRANT ALL PRIVILEGES ON `realm'.$this->Id.'\_scriptdev2` . * TO "server'.$this->Data['Server'].'"@"localhost" WITH GRANT OPTION');
+  }
+  
+  function DeleteDatabase()
+  {
+    $this->Database->query('DROP DATABASE `realm'.$this->Id.'_mangos`');
+    $this->Database->query('DROP DATABASE `realm'.$this->Id.'_characters`');
+    $this->Database->query('DROP DATABASE `realm'.$this->Id.'_scriptdev2`');
+  }
+
+  function ImportDatabase($Delete = false)
+  {
+    $this->Lock();
+    $CommandList = array(
+      'php www/shell.php RealmLock '.$this->Id,
+    );
+    if($Delete == true) 
+    {
+      $CommandList = array_merge($CommandList, array(
+        'mysql --silent --skip-column-names -u server'.$this->Data['Server'].' -pserver'.$this->Data['Server'].' realm'.$this->Id.'_mangos -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$this->Data['Server'].' -pserver'.$this->Data['Server'].' realm'.$this->Id.'_mangos',
+        'mysql --silent --skip-column-names -u server'.$this->Data['Server'].' -pserver'.$this->Data['Server'].' realm'.$this->Id.'_characters -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$this->Data['Server'].' -pserver'.$this->Data['Server'].' realm'.$this->Id.'_characters',
+      'mysql --silent --skip-column-names -u server'.$this->Data['Server'].' -pserver'.$this->Data['Server'].' realm'.$this->Id.'_scriptdev2 -e "show tables" | gawk \'{print "drop table " $1 ";"}\' | mysql -u server'.$this->Data['Server'].' -pserver'.$this->Data['Server'].' realm'.$this->Id.'_scriptdev2',
+      ));
+    }
+    // Lookup nearest database with full import
+    $DbResult = $this->Database->query('SELECT * FROM `Database` WHERE (`Emulator` <> 0) AND (`Revision` <= '.$this->Server['Database']['Revision'].') AND (`SourceFileName` <> "") ORDER BY `Revision` DESC');
+    $Database = $DbResult->fetch_assoc();
+    
+    $CommandList = array_merge($CommandList, array(
+      'mysql --user=server'.$this->Data['Server'].' --password=server'.$this->Data['Server'].' realm'.$this->Id.'_mangos < database/'.$Database['Id'].'/'.$Database['SourceFileName'],
+      'mysql --user=server'.$this->Data['Server'].' --password=server'.$this->Data['Server'].' realm'.$this->Id.'_scriptdev2 < emulator/'.$Database['Emulator']['Id'].'/source/src/bindings/ScriptDev2/sql/scriptdev2_create_structure.sql',
+      'mysql --user=server'.$this->Data['Server'].' --password=server'.$this->Data['Server'].' realm'.$this->Id.'_scriptdev2 < emulator/'.$Database['Emulator']['Id'].'/source/src/bindings/ScriptDev2/sql/scriptdev2_script_full.sql',
+      'mysql --user=server'.$this->Data['Server'].' --password=server'.$this->Data['Server'].' realm'.$this->Id.'_mangos < emulator/'.$Database['Emulator']['Id'].'/source/src/bindings/ScriptDev2/sql/mangos_scriptname_full.sql',
+      'mysql --user=server'.$this->Data['Server'].' --password=server'.$this->Data['Server'].' realm'.$this->Id.'_characters < emulator/'.$Database['Emulator']['Id'].'/share/mangos/sql/characters.sql',
+      'php www/shell.php RealmDatabaseChange '.$this->Id.' '.$Database['Id'],
+      'php www/shell.php RealmUnLock '.$this->Id,
+    ));    
+    $this->Task->Add('Inicializace databáze', $CommandList);
+    
+    if($Database['Id'] != $this->Server['Database']['Id']) 
+    {
+      $NewDatabaseId = $this->Server['Database']['Id'];
+      $this->Server['Database']['Id'] = $Database['Id'];
+      $this->Update($NewDatabaseId, false, false);
+    }
+    return('Úloha načtení nové databáze zařazena do fronty.');
+  } 
+
+  function Start()
+  {
+    $this->Lock();
+    $this->SaveConfiguration();
+    $this->Task->Add('Start světa', array(
+      'php www/shell.php RealmLock '.$this->Id,
+      'realm/'.$this->Id.'/bin/start.sh',
+      'php www/shell.php RealmUnLock '.$this->Id,
+    ));
+    return('Požadavek na start světa zařazen.');
+  }
+  
+  function Stop()
+  {
+    $this->Lock();
+    $this->Task->Add('Zastavení světa', array(
+      'php www/shell.php RealmLock '.$this->Id,
+      'realm/'.$this->Id.'/bin/stop.sh',
+      'php www/shell.php RealmUnLock '.$this->Id,
+    ));
+    return('Požadavek na zastavení světa zařazen.');
+  }
+
+  function UpdateRealmlist()
+  {
+    $Server = new Server($this->Database, $this->Data['Server']);
+    $Server->UpdateRealmList();
+  }
+  
+  function SaveConfiguration()
+  {
+    $this->SetupConfigurationFiles();
+    $this->UpdateRealmlist();
+    $this->UpdateScripts();
+  }
+
+  function UpdateScripts()
+  {
+    global $Config;
+    
+    $RealmBinDir = '../realm/'.$this->Id.'/bin/';
+    if(!file_exists($RealmBinDir)) mkdir($RealmBinDir, 0777, true);    
+    
+    // GDB script
+    $ScriptFileName = '../realm/'.$this->Id.'/bin/mangos.gdb';
+    $Content = array
+    (
+      'run -c realm/'.$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);    
+
+    // Start script
+    $ScriptFileName = '../realm/'.$this->Id.'/bin/start.sh';
+    $Content = array
+    (
+      '#!/bin/sh',
+      'if [ -z `ps -ef | grep \'SCREEN -A -m -d -S realm'.$this->Id.'-worldd\' | grep -v grep | awk \'{print $2}\'` ]',
+      'then',
+      'screen -A -m -d -S realm'.$this->Id.'-worldd realm/'.$this->Id.'/bin/worldd_restarter.sh',
+      'fi',
+    );
+    file_put_contents($ScriptFileName, implode("\n", $Content));
+    chmod($ScriptFileName, 0777);    
+
+    $ScriptFileName = '../realm/'.$this->Id.'/bin/worldd_restarter.sh';
+    $Content = array
+    (
+      '#!/bin/sh',
+      'while [ 1=1 ] ; do',
+      'gdb emulator/'.$this->Data['Database']['Emulator']['Id'].'/bin/mangos-worldd -x realm/'.$this->Id.'/bin/mangos.gdb --batch >>realm/'.$this->Id.'/log/mangos-worldd.log 2>>realm/'.$this->Id.'/log/mangos-worldd.err',
+      'cd www',
+      'php shell.php ServerProcessLog '.$this->Id.' >>realm/'.$this->Id.'/log/mangos_debug.log 2>>realm/'.$this->Id.'/log/mangos_debug.err',
+      'cd ..',
+      'sleep 3',
+      'done',
+    );
+    file_put_contents($ScriptFileName, implode("\n", $Content));
+    chmod($ScriptFileName, 0777);    
+
+    // Stop script
+    $ScriptFileName = '../realm/'.$this->Id.'/bin/stop.sh';
+    $Content = array
+    (
+      '#!/bin/sh',
+      'ps -ef | grep \'SCREEN -A -m -d -S realm'.$this->Id.'-worldd\' | grep -v grep | awk \'{print $2}\' | xargs -i kill {}',
+    );
+    file_put_contents($ScriptFileName, implode("\n", $Content));
+    chmod($ScriptFileName, 0777);    
+  }
+  
+  function SetupConfigurationFiles()
+  {
+    global $Config;
+    
+    $EmulatorEtcDir = '../emulator/'.$this->Data['Database']['Emulator']['Id'].'/etc/';
+    $RealmEtcDir = '../realm/'.$this->Id.'/etc/';
+    $RealmLogDir = '../realm/'.$this->Id.'/log/';
+    if(!file_exists($RealmEtcDir)) mkdir($RealmEtcDir, 0777, true);    
+    if(!file_exists($RealmLogDir)) mkdir($RealmLogDir, 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->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';
+    $EmulatorConfig->ParameterList['WorldServerPort'] = $this->Data['NetworkPortWorldd'];
+    $EmulatorConfig->ParameterList['Motd'] = $this->Data['Motd'];
+    print_r($this->Data);
+    $EmulatorConfig->ParameterList['DataDir'] = 'wowclient/'.$this->Data['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->Data['Type']];
+    $EmulatorConfig->Save($RealmEtcDir.'mangosd.conf');
+      
+    // scriptdev2.conf
+    $EmulatorConfig = new MangosConfigurationFile($this->Database);
+    $EmulatorConfig->Load($EmulatorEtcDir.'scriptdev2.conf');
+    $EmulatorConfig->ParameterList['ScriptDev2DatabaseInfo'] = 'localhost;3306;server'.$this->Data['Server'].';server'.$this->Data['Server'].';realm'.$this->Id.'_scriptdev2';
+    $EmulatorConfig->Save($RealmEtcDir.'scriptdev2.conf');  
+  }
+
+  function Update($DatabaseId, $DoBackup = true, $DoStop = true)
+  {
+    $this->Lock();
+    $Output = '';
+    
+    // Stop server before update
+    if($DoStop)
+    {
+      $Output .= $this->Stop();
+    }
+    
+    // Backup current 
+    if($DoBackup)
+    {
+      $Backup = new Backup($this->Database, 0);
+      $Output .= '<br />'.$Backup->Create($this->Id);
+    }
+    
+    // Do update
+    $Commands = array(
+     'php www/shell.php RealmLock '.$this->Id,
+    );
+    $DbResult = $this->Database->query('SELECT `Revision` FROM `Database` WHERE `Id` = '.$this->Server['Database']['Id']);
+    $DbRow = $DbResult->fetch_assoc();
+    $DatabaseRevisionStart = $DbRow['Revision'];
+    $DbResult = $this->Database->query('SELECT `Revision` FROM `Database` WHERE `Id` = '.$DatabaseId);
+    $DbRow = $DbResult->fetch_assoc();
+    $DatabaseRevisionEnd = $DbRow['Revision'];
+    $DbResult = $this->Database->query('SELECT * FROM `Database` WHERE (`Revision` > '.$DatabaseRevisionStart.') AND (`Revision` <= '.$DatabaseRevisionEnd.') ORDER BY `Revision`');
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Updates = explode("\n", $DbRow['Update']);
+      foreach($Updates as $Update)
+      if($Update != '')
+      {
+        $Parts = explode('|', $Update); 
+        $Command = 'mysql --user=server'.$this->Data['Server'].' --password=server'.$this->Data['Server'].' realm'.$this->Id.'_'.$Parts[0].' < database/'.$DbRow['Id'].'/'.$Parts[1];
+        $Commands[] = $Command;
+      }     
+    }
+    $Commands = array_merge($Commands, array(
+      'php www/shell.php RealmDatabaseChange '.$this->Id.' '.$DatabaseId,
+      'php www/shell.php RealmUnLock '.$this->Id,
+    ));
+
+    $this->Task->Add('Aktualizace databáze', $Commands);
+    $Output .= '<br />Úloha aktualizace serveru byla přidána do fronty.';
+    return($Output);
+  }
+  
+  function Lock()
+  {
+    $this->Database->update('Realm', 'Id='.$this->Id, array('Lock' => 1));
+  }
+  
+  function UnLock()
+  {
+    $this->Database->update('Realm', 'Id='.$this->Id, array('Lock' => 0));
+  }
+  
+  function ChangeDatabaseId($Id)
+  {
+    $this->Database->update('Realm', 'Id='.$this->Id, array('Database' => $Id));
+    $this->SaveConfiguration();
+  }
+  
+  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 realm/'.$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);
+  } 
+  
+  function ProcessLog()
+  {
+    $File = fopen('../realm/'.$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('RealmLog', array('Time' => 'NOW()', 'Realm' => $this->Id, 'Text' => $Data));
+      }         
+      sleep(1);
+    }
+    fclose($File);
+  }
+  
+  function GetUser()
+  {
+    $DbResult = $this->Database->select('Server', 'User', 'Id='.$this->Data['Server']);
+    $DbRow = $DbResult->fetch_assoc();
+    return($DbRow['User']);
+  }
 }
 

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]);
+  }  
 }
 

trunk/www/model/shell.php

@@ -1 +1 @@
 <?php
-
-include('global.php');
 
 class Shell extends Module
@@ -54 +52 @@
           $Server->UnLock();
         } else $Output = 'Jako druhý parameter je nutno zadat Id serveru.';
+      } else 
+      if($Command == 'RealmLock')
+      {
+        if((count($_SERVER['argv']) > 2) and is_numeric($_SERVER['argv'][2]))
+        {
+          $Realm = new Realm($this->Database, $_SERVER['argv'][2]);
+          $Realm->Lock();
+        } else $Output = 'Jako druhý parameter je nutno zadat Id světa.';
+      } else 
+      if($Command == 'RealmUnLock')
+      {
+        if((count($_SERVER['argv']) > 2) and is_numeric($_SERVER['argv'][2]))
+        { 
+          $Realm = new Realm($this->Database, $_SERVER['argv'][2]);
+          $Realm->UnLock();
+        } else $Output = 'Jako druhý parameter je nutno zadat Id světa.';
       } else 
       if($Command == 'EmulatorLock')
@@ -131 +145 @@
           $Server->ChangeDatabaseId($_SERVER['argv'][3]);
         } else $Output = 'Jako druhý parameter je nutno zadat Id serveru, jako třetí Id databáze.';
+      } else
+      if($Command == 'RealmDatabaseChange')
+      {
+        if((count($_SERVER['argv']) > 3) and is_numeric($_SERVER['argv'][2]) and is_numeric($_SERVER['argv'][3]))
+        {
+          $Realm = new Realm($this->Database, $_SERVER['argv'][2]);
+          $Realm->ChangeDatabaseId($_SERVER['argv'][3]);
+        } else $Output = 'Jako druhý parameter je nutno zadat Id světa, jako třetí Id databáze.';
       } else 
         $Output = 'Neznámý příkaz '.$Command;
@@ -138 +160 @@
 }
 
-$Shell = new Shell($Database);
-echo($Shell->Show());
-
 ?>

trunk/www/model/user.php

@@ -148 +148 @@
       else 
       {
-        $this->Database->update('User', 'Id='.$Row['Id'], array('LastLoginTime' => 'NOW()', 'LastIpAddress' => GetRemoteAddress()));            
+        $this->Database->update('User', 'Id='.$Row['Id'], array('LastLoginTime' => 'NOW()', 'LastIpAddress' => GetRemoteAddress()));      
         $this->Database->update('UserOnline', 'SessionId="'.$SID.'"', array('User' => $Row['Id']));
         // načtení stavu stromu
@@ -216 +216 @@
   function CheckPermission($Module, $Operation, $ItemType = '', $ItemIndex = 0)
   {
-        $DbResult = $this->Database->select('PermissionOperation', 'Id', '`Module`="'.$Module.'" AND `Item`="'.$ItemType.'" AND `ItemId`='.$ItemIndex.' AND `Operation`="'.$Operation.'"');
+  $DbResult = $this->Database->select('PermissionOperation', 'Id', '`Module`="'.$Module.'" AND `Item`="'.$ItemType.'" AND `ItemId`='.$ItemIndex.' AND `Operation`="'.$Operation.'"');
     if($DbResult->num_rows > 0)
     {
@@ -272 +272 @@
     return($Output);
   }
+  
+  function ServerCount()
+  {
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Server WHERE User='.$this->User['Id']);
+    $DbRow = $DbResult->fetch_row();
+    return($DbRow[0]);
+  }
+
+  function RealmCount()
+  {
+    $Total = 0;
+    $DbResult = $this->Database->query('SELECT Id FROM Server WHERE User='.$this->User['Id']);
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Server = new Server($this->Database, $DbRow['Id']);
+      $Total += $Server->RealmCount();
+    }
+    return($Total);   
+  }
 }
 

trunk/www/view/base.php

@@ -24 +24 @@
     {
       $Output .= '<div><a href="?Action=ServerList&amp;Filter=User">Moje servery</a></div>';
-      $Output .= '<div><a href="?Action=RealmList&amp;Filter=User">Moje světy</a></div>';
+      //$Output .= '<div><a href="?Action=RealmList&amp;Filter=User">Moje světy</a></div>';
       //$Output .= '<div><a href="?Action=DebugList&amp;Id='.$Server['Id'].'">Ladící záznamy</a></div>';
       //$Output .= '<div><a href="?Action=BackupList&amp;Id='.$Server['Id'].'">Zálohy</a></div>';

trunk/www/view/emulator.php

@@ -92 +92 @@
       $Form->LoadValuesFromForm();
       $Form->SaveValuesToDatabase(0);
-      $Output = $this->SystemMessage('Přidání nového emulátoru', 'Emulátor přidán.');
+      $Output = $this->System->SystemMessage('Přidání nového emulátoru', 'Emulátor přidán.');
     } else $Output = USER_BAD_ROLE;
     return($Output);    
@@ -103 +103 @@
       $Emulator = new Emulator($this->Database, $_GET['Id']);
       $Emulator->Download();       
-      $Output = $this->SystemMessage('Stažení emulátoru', 'Úloha zařazena do fronty');
-      $Output .= $this->ShowTaskList();
-    } else $Output = $this->SystemMessage('Stažení emulátoru', 'Nebylo zadáno Id');
+      $Output = $this->System->SystemMessage('Stažení emulátoru', 'Úloha zařazena do fronty');
+      $TaskView = new TaskView($this->Database, $this->System);
+      $Output .= $TaskView->ItemList();
+    } else $Output = $this->System->SystemMessage('Stažení emulátoru', 'Nebylo zadáno Id');
     return($Output);
   }
@@ -115 +116 @@
       $Emulator = new Emulator($this->Database, $_GET['Id']);
       $Emulator->Compile();       
-      $Output = $this->SystemMessage('Překlad emulátoru', 'Úloha zařazena do fronty');
-      $Output .= $this->ShowTaskList();
-    } else $Output = $this->SystemMessage('Překlad emulátoru', 'Nebylo zadáno Id');
+      $Output = $this->System->SystemMessage('Překlad emulátoru', 'Úloha zařazena do fronty');
+      $TaskView = new TaskView($this->Database, $this->System);
+      $Output .= $TaskView->ItemList();
+    } else $Output = $this->System->SystemMessage('Překlad emulátoru', 'Nebylo zadáno Id');
     return($Output);
   }

trunk/www/view/realm.php

@@ -4 +4 @@
 {
   var $ItemFormClass = array(
-    'Title' => 'Nastavení',
-    'Table' => 'Svět',
+    'Title' => 'Nastavení světa',
+    'Table' => 'Realm',
     'SubmitText' => 'Uložit',
     'Items' => array(
@@ -31 +31 @@
     ),
   );
-
+  var $CreateFormClass = array(
+    'Title' => 'Nový svět',
+    'Table' => 'Realm',
+    'SubmitText' => 'Vytvořit',
+    'Items' => array(
+      'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => 'Svět'),
+      'Description' => array('Type' => 'Text', 'Caption' => 'Popis', 'Default' => ''),
+      'Homepage' => array('Type' => 'Hyperlink', 'Caption' => 'Webové stránky', 'Default' => ''),
+      'Type' => array('Type' => 'ServerType', 'Caption' => 'Typ', 'Default' => 0),
+      'Database' => array('Type' => 'Database', 'Caption' => 'Databáze', 'Default' => 0),
+      'Motd' => array('Type' => 'String', 'Caption' => 'Zpráva dne', 'Default' => 'Vítejte na free WoW serveru'),
+    ),
+  );
+  var $EditFormClass = array(
+    'Title' => 'Nastavení',
+    'Table' => 'Realm',
+    'SubmitText' => 'Uložit',
+    'Items' => array(
+      'Name' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => 'WoW server'),
+      'Description' => array('Type' => 'Text', 'Caption' => 'Popis', 'Default' => ''),
+      'Homepage' => array('Type' => 'Hyperlink', 'Caption' => 'Webové stránky', 'Default' => ''),
+      'Type' => array('Type' => 'ServerType', 'Caption' => 'Typ', 'Default' => 0),
+      'Database' => array('Type' => 'Database', 'Caption' => 'Databáze', 'Default' => 0),
+      'Motd' => array('Type' => 'String', 'Caption' => 'Zpráva dne', 'Default' => 'Vítejte na free WoW serveru'),
+      'RealmId' => array('Type' => 'Hidden', 'Caption' => 'Id', 'Default' => 0),
+      //'TimeCreation' => array('Type' => 'DateTime', 'Caption' => 'Datum založení', 'Default' => 'NOW()'),
+    ),
+  );
+  var $SettingDetailedFormClass = array(
+    'Title' => 'Podrobné nastavení serveru',
+    'Table' => '',
+    'Items' => array(
+      'ServerId' => array('Type' => 'Hidden', 'Caption' => 'Id', 'Default' => 0),
+      'SkipCinematics' => array('Type' => 'SkipCinematics', 'Caption' => 'Zobrazovat úvodní video', 'Default' => ''),
+      'StartPlayerLevel' => array('Type' => 'Integer', 'Caption' => 'Počáteční úroveň hráčů', 'Default' => 1),
+      'MaxPlayerLevel' => array('Type' => 'Integer', 'Caption' => 'Max. úroveň hráčů', 'Default' => 80),
+      'StartHeroicPlayerLevel' => array('Type' => 'Integer', 'Caption' => 'Počáteční úroveň hrdinských postav', 'Default' => 55),
+      'StartPlayerMoney' => array('Type' => 'Integer', 'Caption' => 'Počáteční množství peněz', 'Default' => 0),
+      'StartHonorPoints' => array('Type' => 'Integer', 'Caption' => 'Počáteční počet bodů cti', 'Default' => 0),
+      'MaxHonorPoints' => array('Type' => 'Integer', 'Caption' => 'Max. počet bodů cti', 'Default' => 75000),
+      'StartArenaPoints' => array('Type' => 'Integer', 'Caption' => 'Počáteční počet bodů arén', 'Default' => 0),
+      'MaxArenaPoints' => array('Type' => 'Integer', 'Caption' => 'Max. počet bodů arén', 'Default' => 5000),
+      'MaxArenaPoints' => array('Type' => 'Integer', 'Caption' => 'Max. počet bodů arén', 'Default' => 5000),
+      'InstantLogout' => array('Type' => 'SecurityLevel', 'Caption' => 'Povolit okamžitého odhlášení', 'Default' => 1),
+      'DisableWaterBreath' => array('Type' => 'SecurityLevel', 'Caption' => 'Zakázat dýchání pod vodou', 'Default' => 1),          
+      'AllFlightPaths' => array('Type' => 'Boolean', 'Caption' => 'Povoleny všechny létací cesty', 'Default' => 0),          
+      'AlwaysMaxSkillForLevel' => array('Type' => 'Boolean', 'Caption' => 'Vždy max. dovednost na úroveň', 'Default' => 0),          
+      'ActivateWeather' => array('Type' => 'Boolean', 'Caption' => 'Aktivní počasí', 'Default' => 1),          
+      'CastUnstuck' => array('Type' => 'Boolean', 'Caption' => 'Povolit odblokovací kouzlo pomocí .start', 'Default' => 1),          
+      'MinPetitionSigns' => array('Type' => 'Integer', 'Caption' => 'Min. počet podpisů k zápisu spolku', 'Default' => 9),          
+      'MaxGroupXPDistance' => array('Type' => 'Integer', 'Caption' => 'Max. rozdíl XP ve skupině', 'Default' => 74),          
+      'MailDeliveryDelay' => array('Type' => 'Integer', 'Caption' => 'Zpoždění doručení pošty', 'Default' => 3600),          
+      'Event.Announce' => array('Type' => 'Boolean', 'Caption' => 'Ohlašování událostí', 'Default' => 0),          
+      'AllowTwoSide.Accounts' => array('Type' => 'Boolean', 'Caption' => 'Povolit účty s postavami obou stran', 'Default' => 0),          
+      'AllowTwoSide.Interaction.Chat' => array('Type' => 'Boolean', 'Caption' => 'Povolit komunikaci mezi stranami', 'Default' => 0),          
+      'AllowTwoSide.Interaction.Channel' => array('Type' => 'Boolean', 'Caption' => 'Povolit kanály mezi stranami', 'Default' => 0),
+      'AllowTwoSide.WhoList' => array('Type' => 'Boolean', 'Caption' => 'Povolit obě strany v seznamu přítomných', 'Default' => 0),               
+    ),
+  );  
 
   function ItemList()
   {
     global $Config;
+    
+    if(array_key_exists('Id', $_GET)) $ServerId = $_GET['Id'];
     
     $Realm = new Realm($this->Database, 0);
@@ -42 +102 @@
     $Table = new Table($this->ItemListFormClass);
     //$Table->OnRow = array($this, 'ShowRealmListOnRow');
+    $Table->Definition['Table'] = substr($Table->Definition['Table'], 0, -1).' WHERE `Realm`.`Server`='.$ServerId.')';
     $Table->Definition['Items']['Id'] = array('Type' => 'Hidden', 'Caption' => '', 'Default' => '');
     $Table->LoadValuesFromDatabase($this->Database);
@@ -63 +124 @@
     return($Output);
   } 
+  
+  function Item()
+  {
+    global $Config;
+    
+    $Id = $_GET['Id'];
+    $Realm = new Realm($this->Database, $Id);
+    //if(isset($Server->Server))
+    //{
+    $Output = '<h4>Podrobnosti světa</h4>';
+    $Form = new Form($this->ItemFormClass);
+    $Form->LoadValuesFromDatabase($Id);
+    $Form->Definition['Items']['Uptime'] = array('Type' => 'String', 'Caption' => 'Doba běhu', 'Default' => '');
+    $Form->Definition['Items']['UsedMemory'] = array('Type' => 'String', 'Caption' => 'Použitá paměť', 'Default' => '');    
+    $RealmStatus = $Realm->GetState();
+    unset($Form->Definition['Items']['NetworkPortWorldd']);
+    //$Form->Values['Uptime'] = $this->System->AddPrefixMultipliers($RealmStatus['Uptime'], '', 4, 'Time');
+    //$Form->Values['UsedMemory'] = $this->System->AddPrefixMultipliers($RealmStatus['UsedMemory'] * 1024, 'B', 4, 'Binary');
+    $Output .= $Form->ShowTable();
+    $Server = new Server($this->Database, $Realm->Data['Server']);
+    $Output .= '<div style="text-align: center">';
+    if((($this->System->Modules['User']->User['Role'] >= USER_ROLE_USER) and ($this->System->Modules['User']->User['Id'] == $Server->Server['User'])) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
+    {
+      $Output .= '<br /><a href="http://'.$this->System->Config['Web']['Host'].'/mysql/">Správa databáze</a> ';
+      if(array_key_exists('Id', $Realm->Data['Database']) and ($Realm->Data['Lock'] == 0))
+      {
+        if($ServerStatus['WorlddPortState'] == true) $Output .= ' <a href="?Action=RealmStop&amp;Id='.$Realm->Id.'">Zastavit</a>  <a href="?Action=RealmRestart&amp;Id='.$Realm->Id.'">Restartovat</a>';
+          else $Output .= ' <a href="?Action=RealmStart&amp;Id='.$Realm->Id.'">Spustit</a>';
+      }
+      if($Realm->Data['Lock'] == 0)
+      {
+        $Output .= ' <a href="?Action=RealmEdit&amp;Id='.$Realm->Id.'">Upravit základní nastavení</a>';
+        $Output .= ' <a href="?Action=RealmEditDetailed&amp;Id='.$Realm->Id.'">Upravit podrobné nastavení</a>';
+      }
+      //$Output .= ' <a href="?Action=ServerDatabaseImport&amp;Id='.$Server->Id.'">Načtení čisté databáze</a>';
+    }
+    $Output .= '</div>';    
+    return($Output);
+  } 
+  
+  function Add()
+  {
+    global $Config;
+    
+    if(array_key_exists('Id', $_GET))
+    {
+      $ServerId = $_GET['Id']; 
+    $Output = '';
+    if($this->System->Modules['User']->User['Role'] >= USER_ROLE_USER)
+    {
+      $DbResult = $this->Database->query('SELECT COUNT(*) FROM Realm');
+      $DbRow = $DbResult->fetch_row();
+      $RealmCount = $DbRow[0];
+      if($RealmCount < $Config['MaxRealmCount'])
+      {
+        if($this->System->Modules['User']->RealmCount() >= $Config['MaxServerCountPerUser']) $Output .= $this->System->SystemMessage('Nový svět', 'Na jeden účet lze vytvořit maximálně '.$Config['MaxServerCountPerUser'].' světů');
+        else 
+        {
+          $Form = new Form($this->CreateFormClass);
+          $Form->LoadValuesFromForm();
+          $Form->OnSubmit = '?Action=RealmCreate&amp;Id='.$ServerId;
+          $Output .= 'Tento formulář vám umožní si vytvořit nový svět. Pečlivě vyplňte požadované údaje.';
+          $Output .= $Form->ShowEditForm();
+        }
+      } else $Output .= $this->System->SystemMessage('Nový svět', 'Nelze vytvářet další světyservery');
+    } else $Output .= USER_BAD_ROLE;
+    } else $Output = $this->System->SystemMessage('Vytvoření světa', 'Nezadáno Id serveru');
+    return($Output);
+  }
+
+  function Create()
+  {
+    global $Config;   
+      
+    if(array_key_exists('Id', $_GET))
+    {
+      $ServerId = $_GET['Id']; 
+    if($this->System->Modules['User']->User['Role'] >= USER_ROLE_USER)
+    {
+      if($this->System->Modules['User']->RealmCount() >= $Config['MaxServerCountPerUser']) $Output = $this->System->SystemMessage('Nový svět', 'Na jeden účet lze vytvořit maximálně '.$Config['MaxServerCountPerUser'].' světů');
+      else 
+      {
+        // Allocate unused network port for realm
+        $DbResult = $this->Database->query('SELECT MAX(NetworkPortWorldd) FROM Realm');
+        $DbRow = $DbResult->fetch_row();
+        $NewPortWorldd = $DbRow[0] + 1;
+        if($NewPortWorldd < $Config['BaseNetworkPortWorldd']) $NewPortWorldd = $Config['BaseNetworkPortWorldd'];
+            
+        $Form = new Form($this->CreateFormClass, array());
+        $Form->LoadValuesFromForm();
+        $this->Database->insert('Realm', array('Name' => $Form->Values['Name'], 'Description' => $Form->Values['Description'], 'Server' => $ServerId, 'Motd' => $Form->Values['Motd'], 'Homepage' => $Form->Values['Homepage'], 'Type' => $Form->Values['Type'], 'Database' => $Form->Values['Database'], 'NetworkPortWorldd' => $NewPortWorldd, 'Lock' => 1, 'TimeCreate' => 'NOW()'));
+        $LastInsertId = $this->Database->insert_id;
+        $Realm = new Realm($this->Database, $LastInsertId);
+        $Realm->CreateDatabase();            
+        $Output = $this->System->SystemMessage('Vytvoření světu', $Realm->ImportDatabase(true));
+        $TaskView = new TaskView($this->Database, $this->System);
+        $Output .= $TaskView->ItemList();
+        //$UserOptions->LoadValuesFromDatabase($this->System->Modules['User']->User['Id']);
+        //$Form->OnSubmit = '?Action=ServerCreate';
+        //$Output .= $Form->ShowEditForm();
+      }
+    } else $Output = USER_BAD_ROLE;
+    } else $Output = $this->System->SystemMessage('Vytvoření světa', 'Nezadáno Id serveru');
+    return($Output);
+  }
+  
+  function Save()
+  {
+    $Output = '';
+    $Realm = new Realm($this->Database, $_POST['RealmId']);
+    if(($this->System->Modules['User']->User['Id'] == $Realm->GetUser()) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
+    {
+      $Form = new Form($this->EditFormClass, array());
+      $Form->LoadValuesFromForm();
+      $RealmId = $_POST['RealmId'];
+      unset($Form->Values['RealmId']);
+      $Output .= $this->System->SystemMessage('Upravit svět', 'Nastavení světa uloženo.');
+      $Form->SaveValuesToDatabase($_POST['RealmId']);
+      $Form->OnSubmit = '?Action=RealmSave';
+        
+      $Realm = new Realm($this->Database, $_POST['RealmId']);
+      $Realm->SaveConfiguration();
+      $Form->Values['RealmId'] = $RealmId;
+      $Output .= $Form->ShowEditForm();
+    } else $Output = $this->System->SystemMessage('Nastavení serveru', 'Nemáte oprávnění');
+    return($Output);
+  }
+
+  function Edit()
+  {
+    $Output = '';
+    $Realm = new Realm($this->Database, $_GET['Id']);
+    if(($this->System->Modules['User']->User['Id'] == $Realm->GetUser()) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
+    {
+      $Form = new Form($this->EditFormClass);
+      $Form->LoadValuesFromDatabase($_GET['Id']);
+      $Form->Values['RealmId'] = $_GET['Id'];
+      $Form->OnSubmit = '?Action=RealmSave';
+      $Output .= $Form->ShowEditForm();
+    } else $Output = $this->System->SystemMessage('Nastavení světa', 'Nemáte oprávnění');
+    return($Output);
+  }
+  
+  function EditDetailed()
+  {
+    $Output = '';
+    $Realm = new Realm($this->Database, $_GET['Id']);
+    if(($this->System->Modules['User']->User['Id'] == $Realm->GetUser()) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
+    {
+      $Form = new Form($this->SettingDetailedFormClass);
+      $EmulatorConfig = new MangosConfigurationFile($this->Database);
+      $EmulatorConfig->Load('../realm/'.$Realm->Id.'/etc/mangosd.conf');
+      $Form->Values = $EmulatorConfig->ParameterList;
+      $Form->Values['RealmId'] = $_GET['Id'];
+      $Form->OnSubmit = '?Action=RealmSaveDetailed';
+      $Output .= $Form->ShowEditForm();
+    } else $this->System->SystemMessage('Nastavení světa', 'Nemáte oprávnění');
+    return($Output);    
+  }
+  
+  function SaveDetailed()
+  {
+    $Output = '';
+    $Realm = new Realm($this->Database, $_POST['ServerId']);
+    if(($this->System->Modules['User']->User['Id'] == $Realm->GetUser()) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
+    {
+      $Form = new Form($this->$SettingDetailedFormClass, array());
+      $Form->LoadValuesFromForm();
+      $EmulatorConfig = new MangosConfigurationFile($this->Database);
+      $EmulatorConfig->Load('../realm/'.$Realm->Id.'/etc/mangosd.conf');
+      foreach($Form->Values as $Index => $Item)
+        $EmulatorConfig->ParameterList[$Index] = $Item;
+      $EmulatorConfig->Save('../server/'.$Realm->Id.'/etc/mangosd.conf');
+      $RealmId = $_POST['RealmId'];
+      unset($Form->Values['RealmId']);
+      $Output .= $this->System->SystemMessage('Upravit svět', 'Nastavení světa uloženo.');
+      //$Form->SaveValuesToDatabase($_POST['ServerId']);
+      $Form->OnSubmit = '?Action=RealmSaveDetailed';
+       
+      $Realm = new Realm($this->Database, $_POST['RealmId']);
+      $Realm->SaveConfiguration();
+      $Form->Values['RealmId'] = $RealmId;
+      $Output .= $Form->ShowEditForm();
+    } else $this->System->SystemMessage('Nastavení světa', 'Nemáte oprávnění');
+    return($Output);
+  }
+  
+  function Start()
+  {
+    $Output = '';
+    if($this->System->Modules['User']->User['Role'] >= USER_ROLE_USER)
+    {
+      $Realm = new Realm($this->Database, $_GET['Id']);
+      if(($this->System->Modules['User']->User['Id'] == $Realm->GetUser()) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
+      {
+        $Output .= $this->System->SystemMessage('Spuštění serveru', $Realm->Start());
+        $TaskView = new TaskView($this->Database, $this->System);
+        $Output .= $TaskView->ItemList();;
+      } else $this->System->SystemMessage('Spuštění serveru', 'Nemáte oprávnění');
+    } else $Output .= USER_BAD_ROLE;
+    return($Output);
+  }
+  
+  function Stop()
+  {
+    $Output = '';
+    if($this->System->Modules['User']->User['Role'] >= USER_ROLE_USER)
+    {
+      $Realm = new Realm($this->Database, $_GET['Id']);
+      if(($this->System->Modules['User']->User['Id'] == $Realm->GetUser()) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
+      {
+        $Output .= $this->System->SystemMessage('Zastavení serveru', $Realm->Stop());
+        $TaskView = new TaskView($this->Database, $this->System);
+        $Output .= $TaskView->ItemList();;
+      } else $this->System->SystemMessage('Zastavení serveru', 'Nemáte oprávnění');
+    } else $Output .= USER_BAD_ROLE;
+    return($Output);
+  }
 }
 

trunk/www/view/server.php

@@ -3 +3 @@
 class ServerView extends Module
 {
-  var $ViewFormClass = array(
+  var $ItemFormClass = array(
     'Title' => 'Nastavení',
     'Table' => 'Server',
@@ -39 +39 @@
       'Description' => array('Type' => 'Text', 'Caption' => 'Popis', 'Default' => ''),
       'Homepage' => array('Type' => 'Hyperlink', 'Caption' => 'Webové stránky', 'Default' => ''),
-      'Type' => array('Type' => 'ServerType', 'Caption' => 'Typ', 'Default' => 0),
+      //'Type' => array('Type' => 'ServerType', 'Caption' => 'Typ', 'Default' => 0),
       'Database' => array('Type' => 'Database', 'Caption' => 'Databáze', 'Default' => 0),
-      'Motd' => array('Type' => 'String', 'Caption' => 'Zpráva dne', 'Default' => 'Vítejte na free WoW serveru'),
+      //'Motd' => array('Type' => 'String', 'Caption' => 'Zpráva dne', 'Default' => 'Vítejte na free WoW serveru'),
     ),
   );
@@ -52 +52 @@
       'Description' => array('Type' => 'Text', 'Caption' => 'Popis', 'Default' => ''),
       'Homepage' => array('Type' => 'Hyperlink', 'Caption' => 'Webové stránky', 'Default' => ''),
-      'Type' => array('Type' => 'ServerType', 'Caption' => 'Typ', 'Default' => 0),
-      //'Database' => array('Type' => 'Database', 'Caption' => 'Databáze', 'Default' => 0),
-      'Motd' => array('Type' => 'String', 'Caption' => 'Zpráva dne', 'Default' => 'Vítejte na free WoW serveru'),
+      //'Type' => array('Type' => 'ServerType', 'Caption' => 'Typ', 'Default' => 0),
+      'Database' => array('Type' => 'Database', 'Caption' => 'Databáze', 'Default' => 0),
+      //'Motd' => array('Type' => 'String', 'Caption' => 'Zpráva dne', 'Default' => 'Vítejte na free WoW serveru'),
       'ServerId' => array('Type' => 'Hidden', 'Caption' => 'Id', 'Default' => 0),
       //'TimeCreation' => array('Type' => 'DateTime', 'Caption' => 'Datum založení', 'Default' => 'NOW()'),
@@ -71 +71 @@
     ),
   );  
-  var $SettingDetailedFormClass = array(
-    'Title' => 'Podrobné nastavení serveru',
-    'Table' => '',
-    'Items' => array(
-      'ServerId' => array('Type' => 'Hidden', 'Caption' => 'Id', 'Default' => 0),
-      'SkipCinematics' => array('Type' => 'SkipCinematics', 'Caption' => 'Zobrazovat úvodní video', 'Default' => ''),
-      'StartPlayerLevel' => array('Type' => 'Integer', 'Caption' => 'Počáteční úroveň hráčů', 'Default' => 1),
-      'MaxPlayerLevel' => array('Type' => 'Integer', 'Caption' => 'Max. úroveň hráčů', 'Default' => 80),
-      'StartHeroicPlayerLevel' => array('Type' => 'Integer', 'Caption' => 'Počáteční úroveň hrdinských postav', 'Default' => 55),
-      'StartPlayerMoney' => array('Type' => 'Integer', 'Caption' => 'Počáteční množství peněz', 'Default' => 0),
-      'StartHonorPoints' => array('Type' => 'Integer', 'Caption' => 'Počáteční počet bodů cti', 'Default' => 0),
-      'MaxHonorPoints' => array('Type' => 'Integer', 'Caption' => 'Max. počet bodů cti', 'Default' => 75000),
-      'StartArenaPoints' => array('Type' => 'Integer', 'Caption' => 'Počáteční počet bodů arén', 'Default' => 0),
-      'MaxArenaPoints' => array('Type' => 'Integer', 'Caption' => 'Max. počet bodů arén', 'Default' => 5000),
-      'MaxArenaPoints' => array('Type' => 'Integer', 'Caption' => 'Max. počet bodů arén', 'Default' => 5000),
-      'InstantLogout' => array('Type' => 'SecurityLevel', 'Caption' => 'Povolit okamžitého odhlášení', 'Default' => 1),
-      'DisableWaterBreath' => array('Type' => 'SecurityLevel', 'Caption' => 'Zakázat dýchání pod vodou', 'Default' => 1),          
-      'AllFlightPaths' => array('Type' => 'Boolean', 'Caption' => 'Povoleny všechny létací cesty', 'Default' => 0),          
-      'AlwaysMaxSkillForLevel' => array('Type' => 'Boolean', 'Caption' => 'Vždy max. dovednost na úroveň', 'Default' => 0),          
-      'ActivateWeather' => array('Type' => 'Boolean', 'Caption' => 'Aktivní počasí', 'Default' => 1),          
-      'CastUnstuck' => array('Type' => 'Boolean', 'Caption' => 'Povolit odblokovací kouzlo pomocí .start', 'Default' => 1),          
-      'MinPetitionSigns' => array('Type' => 'Integer', 'Caption' => 'Min. počet podpisů k zápisu spolku', 'Default' => 9),          
-      'MaxGroupXPDistance' => array('Type' => 'Integer', 'Caption' => 'Max. rozdíl XP ve skupině', 'Default' => 74),          
-      'MailDeliveryDelay' => array('Type' => 'Integer', 'Caption' => 'Zpoždění doručení pošty', 'Default' => 3600),          
-      'Event.Announce' => array('Type' => 'Boolean', 'Caption' => 'Ohlašování událostí', 'Default' => 0),          
-      'AllowTwoSide.Accounts' => array('Type' => 'Boolean', 'Caption' => 'Povolit účty s postavami obou stran', 'Default' => 0),          
-      'AllowTwoSide.Interaction.Chat' => array('Type' => 'Boolean', 'Caption' => 'Povolit komunikaci mezi stranami', 'Default' => 0),          
-      'AllowTwoSide.Interaction.Channel' => array('Type' => 'Boolean', 'Caption' => 'Povolit kanály mezi stranami', 'Default' => 0),
-      'AllowTwoSide.WhoList' => array('Type' => 'Boolean', 'Caption' => 'Povolit obě strany v seznamu přítomných', 'Default' => 0),               
-    ),
-  );  
   
   function ShowListOnRow($Row)
@@ -119 +88 @@
     $Output = '<h4>Seznam serverů</h4>';
     $Table = new Table($this->ItemListFormClass);
+    if(array_key_exists('Filter', $_GET))
+    {
+      if($_GET['Filter'] == 'User')
+        $Table->Definition['Table'] = substr($Table->Definition['Table'], 0, -1).' WHERE User='.$this->System->Modules['User']->User['Id'].')';
+    }
     $Table->OnRow = array($this, 'ShowListOnRow');
     $Table->Definition['Items']['Id'] = array('Type' => 'Hidden', 'Caption' => '', 'Default' => '');
@@ -136 +110 @@
       $DbResult = $this->Database->query('SELECT COUNT(*) FROM Server WHERE User='.$this->System->Modules['User']->User['Id']);
       $DbRow = $DbResult->fetch_row();
-      if(($ServerCount < $Config['MaxServerCount']) and ($DbRow[0] == 0))
+      if(($ServerCount < $Config['MaxServerCount']) and ($DbRow[0] < $Config['MaxServerCountPerUser']))
         $Output .= '<br /><div style="text-align: center;"><a href="?Action=ServerAdd">Vytvořit nový server</a></dev>';      
     }
@@ -151 +125 @@
     {
     $Output = '<h4>Podrobnosti serveru</h4>';
-    $Form = new Form($this->ViewFormClass);
+    $Form = new Form($this->ItemFormClass);
     $Form->LoadValuesFromDatabase($Id);
     $Form->Definition['Items']['Realmlist'] = array('Type' => 'String', 'Caption' => 'Adresa k připojení', 'Default' => '');    
@@ -176 +150 @@
       {
         $Output .= ' <a href="?Action=ServerEdit&amp;Id='.$Server->Id.'">Upravit základní nastavení</a>';
-        $Output .= ' <a href="?Action=ServerEditDetailed&amp;Id='.$Server->Id.'">Upravit podrobné nastavení</a>';
       }
       //$Output .= ' <a href="?Action=ServerDatabaseImport&amp;Id='.$Server->Id.'">Načtení čisté databáze</a>';
+      $Output .= ' <a href="?Action=RealmAdd&amp;Id='.$Server->Id.'">Vytvořit nový svět</a>';
     }
     $Output .= ' <a href="?Action=GameAccountRegister&amp;Id='.$Server->Id.'">Vytvoření herního účtu</a>';
@@ -204 +178 @@
         $DbResult = $this->Database->query('SELECT COUNT(*) FROM Server WHERE User='.$this->System->Modules['User']->User['Id']);
         $DbRow = $DbResult->fetch_row();
-        if($DbRow[0] > 0) $Output .= $this->System->SystemMessage('Nový server', 'Lze vytvořit pouze jeden server pro každý uživatelský účet.');
+        if($DbRow[0] >= $Config['MaxServerCountPerUser']) $Output .= $this->System->SystemMessage('Nový server', 'Na jeden účet lze vytvořit maximálně '.$Config['MaxServerCountPerUser'].' serverů');
         else 
         {
@@ -220 +194 @@
   function Create()
   {
+    global $Config;
+    
     $Output = '';
     if($this->System->Modules['User']->User['Role'] >= USER_ROLE_USER)
@@ -225 +201 @@
       $DbResult = $this->Database->query('SELECT COUNT(*) FROM Server WHERE User='.$this->System->Modules['User']->User['Id']);
       $DbRow = $DbResult->fetch_row();
-      if($DbRow[0] > 0) $Output .= $this->System->SystemMessage('Nový server', 'Lze vytvořit pouze jeden server pro každý uživatelský účet.');
+      if($DbRow[0] >= $Config['MaxServerCountPerUser']) $Output .= $this->System->SystemMessage('Nový server', 'Na jeden účet lze vytvořit maximálně '.$Config['MaxServerCountPerUser'].' serverů');
       else 
       {
-        $DbResult = $this->Database->query('SELECT MAX(NetworkPortRealmd), MAX(NetworkPortWorldd) FROM Server');
+        $DbResult = $this->Database->query('SELECT MAX(NetworkPortRealmd) FROM Server');
         $DbRow = $DbResult->fetch_row();
         $NewPortRealmd = $DbRow[0] + 1;
         if($NewPortRealmd < $Config['BaseNetworkPortRealmd']) $NewPortRealmd = $Config['BaseNetworkPortRealmd'];
-        $NewPortWorldd = $DbRow[1] + 1;
-        if($NewPortWorldd < $Config['BaseNetworkPortWorldd']) $NewPortWorldd = $Config['BaseNetworkPortWorldd'];
             
         $Form = new Form($this->CreateFormClass, array());
         $Form->LoadValuesFromForm();
-        $this->Database->insert('Server', array('Name' => $Form->Values['Name'], 'Description' => $Form->Values['Description'], 'User' => $this->System->Modules['User']->User['Id'], 'Motd' => $Form->Values['Motd'], 'Homepage' => $Form->Values['Homepage'], 'Type' => $Form->Values['Type'], 'Database' => $Form->Values['Database'], 'NetworkPortWorldd' => $NewPortWorldd, 'NetworkPortRealmd' => $NewPortRealmd, 'Lock' => 1, 'TimeCreate' => 'NOW()'));
+        $this->Database->insert('Server', array('Name' => $Form->Values['Name'], 'Description' => $Form->Values['Description'], 'User' => $this->System->Modules['User']->User['Id'], 'Homepage' => $Form->Values['Homepage'], 'Database' => $Form->Values['Database'], 'NetworkPortRealmd' => $NewPortRealmd, 'Lock' => 1, 'TimeCreate' => 'NOW()'));
         $LastInsertId = $this->Database->insert_id;
         $Server = new Server($this->Database, $LastInsertId);
         $Server->CreateDatabase();            
         $Output .= $this->System->SystemMessage('Vytvoření serveru', $Server->ImportDatabase(true));
-        $Output .= $this->ShowTaskList();
+        $TaskView = new TaskView($this->Database, $this->System);
+        $Output .= $TaskView->ItemList();
         //$UserOptions->LoadValuesFromDatabase($this->System->Modules['User']->User['Id']);
         //$Form->OnSubmit = '?Action=ServerCreate';
@@ -284 +259 @@
       $Form->OnSubmit = '?Action=ServerSave';
       $Output .= $Form->ShowEditForm();
-    } else $Output = $this->SystemMessage('Nastavení serveru', 'Nemáte oprávnění');
-    return($Output);
-  }
-  
-  function EditDetailed()
-  {
-    $Output = '';
-    $Server = new Server($this->Database, $_GET['Id']);
-    if(($this->System->Modules['User']->User['Id'] == $Server->Server['User']) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
-    {
-      $Form = new Form($this->$SettingDetailedFormClass);
-      $EmulatorConfig = new MangosConfigurationFile($this->Database);
-      $EmulatorConfig->Load('../server/'.$Server->Id.'/etc/mangosd.conf');
-      $Form->Values = $EmulatorConfig->ParameterList;
-      $Form->Values['ServerId'] = $_GET['Id'];
-      $Form->OnSubmit = '?Action=ServerSaveDetailed';
-      $Output .= $Form->ShowEditForm();
-    } else $this->System->SystemMessage('Nastavení serveru', 'Nemáte oprávnění');
-    return($Output);    
-  }
-  
-  function SaveDetailed()
-  {
-    $Output = '';
-    $Server = new Server($this->Database, $_POST['ServerId']);
-    if(($this->System->Modules['User']->User['Id'] == $Server->Server['User']) or ($this->System->Modules['User']->User['Role'] >= USER_ROLE_ADMINISTRATOR))
-    {
-      $Form = new Form($this->$SettingDetailedFormClass, array());
-      $Form->LoadValuesFromForm();
-      $EmulatorConfig = new MangosConfigurationFile($this->Database);
-      $EmulatorConfig->Load('../server/'.$Server->Id.'/etc/mangosd.conf');
-      foreach($Form->Values as $Index => $Item)
-        $EmulatorConfig->ParameterList[$Index] = $Item;
-      $EmulatorConfig->Save('../server/'.$Server->Id.'/etc/mangosd.conf');
-      $ServerId = $_POST['ServerId'];
-      unset($Form->Values['ServerId']);
-      $Output .= $this->System->SystemMessage('Upravit server', 'Nastavení serveru uloženo.');
-      //$Form->SaveValuesToDatabase($_POST['ServerId']);
-      $Form->OnSubmit = '?Action=ServerSaveDetailed';
-       
-      $Server = new Server($this->Database, $_POST['ServerId']);
-      $Server->SaveConfiguration();
-      $Form->Values['ServerId'] = $ServerId;
-      $Output .= $Form->ShowEditForm();
-    } else $this->System->SystemMessage('Nastavení serveru', 'Nemáte oprávnění');
-    return($Output);
-  }
+    } else $Output = $this->System->SystemMessage('Nastavení serveru', 'Nemáte oprávnění');
+    return($Output);
+  } 
   
   function Start()
@@ -341 +272 @@
       {
         $Output .= $this->System->SystemMessage('Spuštění serveru', $Server->Start());
-        $Output .= $this->ShowTaskList();
+        $TaskView = new TaskView($this->Database, $this->System);
+        $Output .= $TaskView->ItemList();;
       } else $this->System->SystemMessage('Spuštění serveru', 'Nemáte oprávnění');
     } else $Output .= USER_BAD_ROLE;
@@ -356 +288 @@
       {
         $Output .= $this->System->SystemMessage('Zastavení serveru', $Server->Stop());
-        $Output .= $this->ShowTaskList();
+        $TaskView = new TaskView($this->Database, $this->System);
+        $Output .= $TaskView->ItemList();;
       } else $this->System->SystemMessage('Zastavení serveru', 'Nemáte oprávnění');
     } else $Output .= USER_BAD_ROLE;