Changeset 290

Timestamp:

Dec 27, 2009, 1:08:48 PM (15 years ago)

Author:

george

Message:

• Upraveno: Kompletně přepracováno rozhraní pro export textů. Nyní systém přímo uchovává exporty překladatelů a nespoléhává se na serializovaný řetězec nastavení exportu. Nově lze své exporty vytvářet, upravovat a mazat. Exporty své či ostatních lze prohlížet a stahovat. Nově lze u exportů lépe vybrat překladatelé, jazyky, překladové skupiny, formáty a verze.
• Upraveno: Přidána třída Module a System pro podporu předávání parametrů objektům. Nově bude používána třída mysqli namísto třídy Database používající starý procedurální přístup.
• Upraveno: Do hlavního menu přidán opět odkaz Exporty, který umožní přístup k seznamu dostupných exportů.
• Přidáno: Funkce pro jednoduché zobrazování a ovládání záložek.
• Upraveno: Propagační bannery byly z hlavní stránky přesunuty do sekce Propagace.

Location:

trunk

Files:

• banners.php (modified) (1 diff)
• download.php (modified) (1 diff)
• export/cmd.php (modified) (5 diffs)
• export/export.php (modified) (1 diff)
• export/index.php (modified) (1 diff)
• includes/error.php (modified) (1 diff)
• includes/global.php (modified) (4 diffs)
• includes/global_function.php (modified) (4 diffs)
• index.php (modified) (1 diff)
• style/style.css (modified) (3 diffs)
• user.php (modified) (2 diffs)

trunk/banners.php

@@ -4 +4 @@
 
 ShowPage();
+
+$Banner = '<a href="'.$Config['Web']['BaseURL'].'"><img src="'.$Config['Web']['BaseURL'].'banners/baner_468_60.jpg" '.
+  'alt="baner_'.$Config['Web']['BaseURL'].'" title="Otevřený projekt překládání celé hry World of Warcraft" '.
+  'class="banner" height="60" width="468" /></a>';
+ 
+$BannerSmall = '<a href="'.$Config['Web']['BaseURL'].'"><img src="'.$Config['Web']['BaseURL'].'banners/baner_88_31.jpg" '.
+  'alt="baner_'.$Config['Web']['BaseURL'].'" title="Otevřený projekt překládání celé hry World of Warcraft" '.
+  'class="banner" height="31" width="88" /></a>';
+
+echo('<strong>Bannery:</strong><br />');
+  
+echo($Banner.' &nbsp;&nbsp;<textarea rows="2" cols="30">'.htmlspecialchars($Banner).'</textarea><br />');
+echo($BannerSmall.' &nbsp;&nbsp;<textarea rows="2" cols="30">'.htmlspecialchars($BannerSmall).'</textarea><br />');
   
 $ID = $Database->SQLCommand('SELECT * FROM `banner` WHERE `Show`=1 AND `DateLast` > (NOW() - INTERVAL 3 MONTH)');
   
-echo('<strong>Servery odkazující na nás:</strong> <br />
+echo('<br/><strong>Servery odkazující na nás:</strong> <br />
 <div style="font-size: 10px;">Seznam je automaticky aktualizován a zobrazeny jsou servery s aktivní bannerem mladším než tři měsíce.</div><br />');
 while($Line = mysql_fetch_assoc($ID)) 
 {
-  echo('<a href="'.$Line['LastURL'].'">'.$Line['Web'].'</a> '.$Line['Description'].' <br />');          
+  echo('<a href="'.$Line['LastURL'].'">'.$Line['Web'].'</a> '.$Line['Description'].' <br />');    
 }
   

trunk/download.php

@@ -71 +71 @@
 } else
 {
-  echo('<br /><h3><a href="export/">Export textů</a> - Export podle vlastního výběru do SQL, XML, LUA nebo Addonu</h3>'.
-    '<br />Exportovat podle zálohovaného nastavení:<form action="export" method="get"><div>'.
-    '<input name="action" value="output" type="hidden" />'.
-    '<textarea name="ExportSetting" rows="10" cols="40"></textarea>'.
-    '<input type="submit" value="Exportovat" /></div></form><br /><br />');
 
-if (Licence(LICENCE_USER)) 
+if(Licence(LICENCE_USER)) 
 {  
   $ID = $Database->SQLCommand('SELECT * FROM tasks WHERE User = '.$_SESSION['UserID'].' ORDER BY Date DESC LIMIT 10');

trunk/export/cmd.php

@@ -1 +1 @@
 <?php
 
-ini_set("memory_limit","100M");
+ini_set('memory_limit', '100M');
 
 if(!isset($_SERVER['REMOTE_ADDR']))
@@ -10 +10 @@
     {
       $index = substr($parameter,0,strpos($parameter, '='));
-          $parameter = substr($parameter,strpos($parameter, '=')+1);
-          //echo ($index.'  ----  '.$parameter);
+    $parameter = substr($parameter,strpos($parameter, '=')+1);
+    //echo ($index.'  ----  '.$parameter);
       $_GET[$index] = $parameter;
     }
-  }     
+  } 
 }
 
@@ -29 +29 @@
   foreach($FileList as $FileName)
   {
-        if(file_exists($Path.$FileName) and ($FileName != '.') and ($FileName != '..'))
-          {
+    if(file_exists($Path.$FileName) and ($FileName != '.') and ($FileName != '..'))
+    {
       //echo($Path.$FileName.'<br />');
-            if(is_dir($Path.$FileName)) CreateZipFromDir($Zip, $Path.$FileName.'/', $ZipPath.$FileName.'/');
-        else $Zip->addFile(file_get_contents($Path.$FileName), $ZipPath.$FileName);     
-          }          
+      if(is_dir($Path.$FileName)) CreateZipFromDir($Zip, $Path.$FileName.'/', $ZipPath.$FileName.'/');
+        else $Zip->addFile(file_get_contents($Path.$FileName), $ZipPath.$FileName); 
+    }          
   }
 }
@@ -44 +44 @@
     {
       $ExportSetting = unserialize($Line['ExportSetting']);
-          $_SESSION['User'] = $Line['UserName'];
-          $_SESSION['UserID'] = $Line['User'];          
+    $_SESSION['User'] = $Line['UserName'];
+    $_SESSION['UserID'] = $Line['User'];    
 
         if(function_exists('gzcompress')) 
         {
           $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/dbc/';
-              echo('Generování dbc souborů.. ');
+        echo('Generování dbc souborů.. ');
           ExportToDBC($ExportSetting);
           $SaveFilename = $Config['Web']['TempFolder'].$_SESSION['User'].'/CzWoW_DBC.zip';          
           $Zip = new zipfile();
-          CreateZipFromDir($Zip, $TempDir, 'DBFilesClient/');
-              $Buffer = $Zip->file();
+        CreateZipFromDir($Zip, $TempDir, 'DBFilesClient/');
+          $Buffer = $Zip->file();
           file_put_contents($SaveFilename, $Buffer);
-                  echo('Hotovo');
+        echo('Hotovo');
         } else echo('Funkce pro tvorbu Zip souboru není podporována!');
     }
@@ -64 +64 @@
 
 
-//      WriteLog('Generování dbc úloh', 2);
+//  WriteLog('Generování dbc úloh', 2);
 ?>

trunk/export/export.php

@@ -1 +1 @@
 <?php
 
-function ExportToMangosSQL($Setting)
+include_once('../includes/system.php');
+
+class Export extends Module
 {
-  global $Database, $Config, $TranslationTree, $LanguageList;
-  
-  $AnoNe = array('Ne', 'Ano');
-  if($_SESSION['UserID'] != '')
-  {
-    $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE ID='.$_SESSION['UserID']);
-    $User = mysql_fetch_assoc($DbResult);
-  } else $User = array('user' => 'Neznámý');
-
-  $WhereLang = '';
-  foreach($LanguageList as $Language)
-    if($Language['Enabled'] == 1)
-      if(isset($Setting['language'.$Language['Id']]))  $WhereLang .= ' OR (Language = '.$Language['Id'].')'; 
-  if($WhereLang == '') $WhereLang = 1; 
-    else $WhereLang = '('.substr($WhereLang, 4).')';
-
-  $SelectedUsers = '';  
-  foreach($Setting['users-selection'] as $Item)
-    $SelectedUsers .= ','.$Item;
-  $SelectedUsers = substr($SelectedUsers, 1);
-
-  if($SelectedUsers == '') $Where = 0;
-    else $Where = 'ID IN ('.$SelectedUsers.')';
-  
-  $UserNames = '';
-  $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE '.$Where);
-  while($DbRow = mysql_fetch_assoc($DbResult))
-    $UserNames .= ','.$DbRow['user'];
-  $UserNames = substr($UserNames, 1);    
+  var $Id;
+  var $AnoNe = array('Ne', 'Ano');
+  var $WhereLang;
+  var $WhereUsers;
+  var $SelectedUsers;
+  var $UserNames;
+  var $User;
+  var $ClientVersion;
+  
+  function LoadFilters()
+  {  
+    $DbResult = $this->Database->query('SELECT * FROM `Export` WHERE Id='.$this->Id);
+    $this->Export = $DbResult->fetch_assoc();
+
+    // Filter selected languages
+    $this->WhereLang = '';
+    $DbResult = $this->Database->query('SELECT * FROM `ExportLanguage` WHERE Export='.$this->Id.' ORDER BY Sequence');
+    while($Language = $DbResult->fetch_assoc())
+      $this->WhereLang .= ' OR (Language = '.$Language['Language'].')'; 
+    if($this->WhereLang == '') $WhereLang = 1; 
+      else $this->WhereLang = '('.substr($this->WhereLang, 4).')';
+
+    // Filter selected users
+    $this->SelectedUsers = '';  
+    $DbResult = $this->Database->query('SELECT * FROM `ExportUser` WHERE Export='.$this->Id.' ORDER BY Sequence');
+    while($User = $DbResult->fetch_assoc())
+      $this->SelectedUsers .= ','.$User['User'];
+    $this->SelectedUsers = substr($this->SelectedUsers, 1);
+
+    if($this->SelectedUsers == '') $Where = 0;
+      else $Where = 'ID IN ('.$this->SelectedUsers.')';
+  
+    $this->UserNames = '';
+    $DbResult = $this->Database->query('SELECT user FROM `user` WHERE '.$Where);
+    while($DbRow = $DbResult->fetch_assoc())
+      $this->UserNames .= ','.$DbRow['user'];
+    $this->UserNames = substr($this->UserNames, 1);    
    
-  if($SelectedUsers == '') $WhereUsers = 1; 
-    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
-
-  $Buffer = 
-  "-- Generováno projektem wowpreklad.zdechov.net\n". 
-  "-- ===========================================\n".
-  "--\n".
-  "-- Web projektu: ".$Config['Web']['BaseURL']."\n".
-  "-- Datum exportu: ".date("j.n.Y  H:i:s")."\n".
-  "-- Znaková sada: ".$Config['Database']['Charset']." / ".$Config['Web']['Charset']."\n".
-  "-- Diakritika: ".$AnoNe[$Setting['Diacritics']]."\n".
-  "-- Vygeneroval uživatel: ".$User['user']."\n".
-  "-- Vzato od uživatelů: ".$UserNames."\n".
-  "-- Generované tabulky: ";
-  foreach($TranslationTree as $Group)
-    if($Group['MangosTable'] != '')
-      if(in_array($Group['Id'], $Setting['groups']))
-        $Buffer .= $Group['MangosTable'].', ';
-  $Buffer .= "\n\n";  
-
-  foreach($TranslationTree as $Group)
-  if(in_array($Group['Id'], $Setting['groups'])) 
-  { 
-        if($Group['MangosTable'] != '')
-        {
-      $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' AND '.$WhereLang.' AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';      
+    if($this->SelectedUsers == '') $WhereUsers = 1; 
+      else $this->WhereUsers = '(User IN ('.$this->SelectedUsers.'))';
+
+    if($_SESSION['UserID'] != '')
+    {
+      $DbResult = $this->Database->query('SELECT user FROM `user` WHERE ID='.$_SESSION['UserID']);
+      $this->User = $DbResult->fetch_assoc();
+    } else $this->User = array('user' => 'Neznámý');
+
+    $DbResult = $this->Database->query('SELECT `BuildNumber` FROM `wow_client_version` WHERE `Id`='.$this->Export['ClientVersion']);
+    $DbRow = $DbResult->fetch_assoc();
+    $this->ClientVersion = $DbRow['BuildNumber'];
+  }
+
+  function ExportToMangosSQL()
+  {
+    global $TranslationTree, $LanguageList;
+  
+    $this->LoadFilters();
+    
+    $Buffer = 
+      "-- Generováno projektem wowpreklad.zdechov.net\n". 
+      "-- ===========================================\n".
+      "--\n".
+      "-- Web projektu: ".$this->Config['Web']['BaseURL']."\n".
+      "-- Datum exportu: ".date("j.n.Y  H:i:s")."\n".
+      "-- Znaková sada: ".$this->Config['Database']['Charset']." / ".$this->Config['Web']['Charset']."\n".
+      "-- Diakritika: ".$this->AnoNe[$this->Export['WithDiacritic']]."\n".
+      "-- Vygeneroval uživatel: ".$this->User['user']."\n".
+      "-- Vzato od uživatelů: ".$this->UserNames."\n".
+      "-- Generované tabulky: ";
+    
+    $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
+    while($Group = $DbResult->fetch_assoc())
+    {
+       $Buffer .= $Group['MangosTable'].', ';
+    }
+    $Buffer .= "\n\n";  
+
+    $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
+    while($Group = $DbResult->fetch_assoc())
+    {
+      if($Group['MangosTable'] != '')
+      {
+        $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.$this->ClientVersion.' AND VersionEnd >= '.$this->ClientVersion.' AND '.$this->WhereLang.' AND '.$this->WhereUsers.' ORDER BY FIELD(User, '.$this->SelectedUsers.')) AS T GROUP BY T.entry';  
+        //echo($Query);
+        $Buffer .= "\n\n-- ".$Group['Name']."\n\n";
+        $DbResult2 = $this->Database->query($Query);
+        while($Line = $DbResult2->fetch_array()) 
+        {
+          $Values = '';
+          foreach($TranslationTree[$Group['Id']]['Items'] as $GroupItem)
+          {
+            if($GroupItem['MangosColumn'] == '') $GroupItem['MangosColumn'] = $GroupItem['Column'];
+            $Values .= ', `'.$GroupItem['MangosColumn'].'`="'.addslashes($Line[$GroupItem['Column']]).'"';
+          }
+          $Values = substr($Values, 2);
+          $Buffer .= 'UPDATE `'.$Group['MangosTable'].'` SET '.$Values.' WHERE `'.$Group['MangosTableIndex'].'` = '.$Line['entry'].';'."\n"; 
+        }     
+      }
+    }
+    if($this->Export['WithDiacritic'] != 1) $Buffer = utf2ascii($Buffer);
+    return($Buffer);
+  }
+  
+  function ExportToAoWoWSQL() 
+  {
+    global $Config, $TranslationTree, $AoWoWconf, $LanguageList;
+  
+    require_once('../aowow/configs/config.php');
+  
+    $Buffer = $this->ExportToMangosSQL();
+ 
+    $this->LoadFilters();
+
+    // Data to aowow
+
+    $Database2 = new mysqli($this->Config['Database']['Host'], $this->Config['Database']['User'], $this->Config['Database']['Password'], $this->Config['Database']['Database']);
+    $Database2->query('SET NAMES '.$this->Config['Database']['Charset']);
+    $Database2->select_db($AoWoWconf['mangos']['db']);    
+    $AoWoWTables = array('aowow_resistances' => 'Id', 'aowow_spelldispeltype' => 'Id', 'aowow_skill' => 'skillID');
+    foreach($AoWoWTables as $AoWoWTable => $IndexColum) 
+    {
+      $Buffer .= '--'.$AoWoWTable.', ';
+      $Buffer .= "\n\n";  
+      $Query = 'SELECT name,'.$IndexColum.' FROM '.$AoWoWTable;
+      $DbResult = $Database2->query($Query);
+      while($Line = $DbResult->fetch_assoc()) 
+      {
+        $Ori_text = $Line['name'];
+        $DbResult2 = $Datbase2->query('SELECT text as en,
+        (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
+         WHERE tableen.entry = tabletran.entry AND (Complete = 1) AND '.$WhereLang.'
+          AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.') LIMIT 1) as tran
+         FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE
+          text = "'.addslashes($Ori_text).'" LIMIT 1');
+        $Tran = $DbResult2->fetch_assoc();
+        //echo ($Line['name'].'='.$Tran['tran']);
+        if($Tran['tran'] == '') 
+        {
+          $DbResult2 = $Database2->query('SELECT OptionText as en,
+          (SELECT OptionText FROM '.$this->Config['Database']['Database'].'.npc_option as tabletran
+           WHERE tableen.entry = tabletran.entry AND (Complete = 1) AND '.$this->WhereLang.'
+            AND '.$this->WhereUsers.' ORDER BY FIELD(User, '.$this->SelectedUsers.') LIMIT 1) as tran
+          FROM '.$this->Config['Database']['Database'].'.npc_option as tableen WHERE
+            OptionText = "'.addslashes($Ori_text).'" LIMIT 1');
+          $Tran = $DbResult2->fetch_assoc();
+        }
+        
+        if($Tran['tran'] <> '')
+          $Buffer .= 'UPDATE `'.$AoWoWTable.'` SET name = "'.addslashes($Tran['tran']).'" WHERE '.$IndexColum.' = '.$Line[$IndexColum].' ;'."\n";
+      }
+      $Buffer .= "\n\n";  
+    }
+    if($this->Export['WithDiacritic'] != 1) $Buffer = utf2ascii($Buffer);
+    return($Buffer);
+  }  
+ 
+  
+  function ExportToXML()
+  {
+    global $TranslationTree, $LanguageList;
+  
+    $this->LoadFilters($this->Id);
+
+    $Buffer = '<?xml version="1.0" encoding="utf-8"?>'."\n".
+    "<document>\n".
+    "  <meta>\n".
+    "    <projecturl>".$this->Config['Web']['BaseURL']."</projecturl>\n".
+    "    <time>".date('r')."</time>\n".
+    "    <diacritics mode=".'"'.$this->Export['WithDiacritic'].'"'." />\n".
+    "    <author>".$this->User['user']."</author>\n".
+    "    <contributors>\n";
+    foreach(explode(',', $this->UserNames) as $UserName)
+      $Buffer .= "      <user>".$UserName."</user>\n";
+    $Buffer .= 
+    "    </contributors>\n".
+    "  </meta>\n".
+    "  <translation>\n";
+
+    $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
+    while($Group = $DbResult->fetch_assoc())
+    {
+      if($Group['MangosTable'] == '')
+      {
+        $Group['MangosTable'] = $Group['TablePrefix'];
+        $Group['MangosTableIndex'] = 'entry';
+      }
+      $Query = 'SELECT *,(SELECT user FROM user WHERE user.ID=T.User) as UserName FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.$this->ClientVersion.' AND VersionEnd >= '.$this->ClientVersion.' AND '.$this->WhereLang.' AND '.$this->WhereUsers.' ORDER BY FIELD(User, '.$this->SelectedUsers.')) AS T GROUP BY T.entry'; 
       //echo($Query);
-      $Buffer .= "\n\n-- ".$Group['Name']."\n\n";
-      $ID = $Database->SQLCommand($Query);
-      while($Line = mysql_fetch_array($ID)) 
-      {
-            $Values = '';
-            foreach($Group['Items'] as $GroupItem)
-            {
-              if($GroupItem['MangosColumn'] == '') $GroupItem['MangosColumn'] = $GroupItem['Column'];
-              $Values .= ', `'.$GroupItem['MangosColumn'].'`="'.addslashes($Line[$GroupItem['Column']]).'"';
-            }
-        $Values = substr($Values, 2);
-        $Buffer .= 'UPDATE `'.$Group['MangosTable'].'` SET '.$Values.' WHERE `'.$Group['MangosTableIndex'].'` = '.$Line['entry'].';'."\n"; 
-      }
-    }    
+      $Buffer .= '    <group id="'.$Group['Id'].'" name="'.$Group['TablePrefix'].'">'."\n";
+      $DbResult2 = $this->Database->query($Query);
+      while($Line = $DbResult2->fetch_assoc()) 
+      {
+        $Buffer .= '      <item id="'.$Line['entry'].'" user="'.$Line['UserName'].'">'."\n";
+        $Values = '';
+        foreach($TranslationTree[$Group['Id']]['Items'] as $GroupItem)
+        {
+          if($GroupItem['MangosColumn'] == '') $GroupItem['MangosColumn'] = $GroupItem['Column'];
+          if($Line[$GroupItem['Column']] != '')
+          $Buffer .= '        <text index="'.$GroupItem['Id'].'" name="'.$GroupItem['Column'].'">'.addslashes($Line[$GroupItem['Column']]).'</text>'."\n";
+        }
+        $Buffer .= "      </item>\n";
+      }    
+      $Buffer .= "    </group>\n";
+    }
+    if($this->Export['WithDiacritic'] != 1) $Buffer = utf2ascii($Buffer);
+    $Buffer .= "  </translation>\n".
+  "</document>";
+    return($Buffer);
+  }      
+
+  function ExportToDBC()
+  {
+    global $TranslationTree, $LanguageList;
+  
+    $this->LoadFilters();
+
+    $TempDir = $this->Config['Web']['TempFolder'].$_SESSION['User'].'/dbc/';
+    if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
+
+  
+    foreach($TranslationTree as $Group)
+    if(in_array($Group['Id'], $Setting['groups']) and ($Group['DBCFileName'] != '')) 
+    { 
+      echo($Group['Name'].'... ');
+      $DBCFile = new DBCFile();
+      $DBCFile->OpenFile('../source/'.$Setting['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
+      $DBCFile2 = new DBCFile();
+      $DBCFile2->CreateFile($TempDir.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
+      $Count = $DBCFile->GetRecordCount();
+      //if($Group['DBCFileName'] == 'Spell') $Count = 1000;
+      $Line = $DBCFile->GetLine(0);
+      $DBCFile2->SetRecordCount($Count);   
+      for($I = 0; $I < $Count; $I++)
+      {
+        $Line = $DBCFile->GetLine($I);
+        $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' AND (entry='.$Line[0].')  AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';       
+        $DbResult = $this->Database->query($Query);
+        if($DbResult->num_rows > 0)
+        {
+          $DbRow = $DbResult->fetch_assoc();
+          //  if($Setting['Diacritics'] != 1) $Buffer = utf2ascii($Buffer);
+
+          foreach($Group['Items'] as $GroupItem)
+            if(GetDBCColumnIndex($Setting['Version'],$Group['DBCFileName'],$GroupItem['Column']) != '')
+          $Line[GetDBCColumnIndex($this->Export['ClientVersion'],$Group['DBCFileName'],$GroupItem['Column'])] = $DbRow[$GroupItem['Column']];
+          //print_r($Line);
+        }
+        $DBCFile2->SetLine($I, $Line);
+        echo('.');
+      }
+      $DBCFile2->Commit();
+      echo('Hotovo <br />');
+    }
   }
-  if($Setting['Diacritics'] != 1) $Buffer = utf2ascii($Buffer);
-  return($Buffer);
-}
-  
-function ExportToAoWoWSQL($Setting) 
-{
-  global $Database, $Config, $TranslationTree, $AoWoWconf, $LanguageList;
-  
-        require_once('../aowow/configs/config.php');
-        
-  $Buffer = ExportToMangosSQL($Setting);
+
+  function ExportToLua()
+  {
+    global $TranslationTree, $LanguageList;
+  
+    $this->LoadFilters();
+
+    $TempDir = $this->Config['Web']['TempFolder'].$_SESSION['User'].'/lua/';
+    if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
+  
+    $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `group`.`LuaFileName` != ""');
+    while($Group = $DbResult->fetch_assoc())
+    {
+      echo($Group['Name'].'... ');
+      $File = new FileStream();
+      $File->OpenFile('../source/'.$this->ClientVersion.'/lua/'.$Group['LuaFileName'].'.lua');
+      $File2 = new FileStream();
+      $File2->CreateFile($TempDir.''.$Group['LuaFileName'].'.lua');
  
-  $AnoNe = array('Ne', 'Ano');
-  if($_SESSION['UserID'] != '')
-  {
-    $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE ID='.$_SESSION['UserID']);
-    $User = mysql_fetch_assoc($DbResult);
-  } else $User = array('user' => 'Neznámý');
-
-  $WhereLang = '';
-  foreach($LanguageList as $Language)
-    if($Language['Enabled'] == 1)
-      if(isset($Setting['language'.$Language['Id']]))  $WhereLang .= ' OR (Language = '.$Language['Id'].')'; 
-  if($WhereLang == '') $WhereLang = 1;
-    else $WhereLang = '('.substr($WhereLang, 4).')';
-
-  $SelectedUsers = '';  
-  foreach($Setting['users-selection'] as $Item)
-    $SelectedUsers .= ','.$Item;
-  $SelectedUsers = substr($SelectedUsers, 1);
-
-  if($SelectedUsers == '') $Where = 0;
-    else $Where = 'ID IN ('.$SelectedUsers.')';
-  
-  $UserNames = '';
-  $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE '.$Where);
-  while($DbRow = mysql_fetch_assoc($DbResult))
-    $UserNames .= ','.$DbRow['user'];
-  $UserNames = substr($UserNames, 1);    
-   
-  if($SelectedUsers == '') $WhereUsers = 1; 
-    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
-
-        // Data to aowow
-
-        $Database->SelectDatabase($AoWoWconf['mangos']['db']);    
-        $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
-  $AoWoWTables = array('aowow_resistances' => 'Id', 'aowow_spelldispeltype' => 'Id', 'aowow_skill' => 'skillID');
-        foreach($AoWoWTables as $AoWoWTable => $IndexColum) 
-  {
-        $Buffer .= '--'.$AoWoWTable.', ';
-    $Buffer .= "\n\n";  
-          $Query = 'SELECT name,'.$IndexColum.' FROM '.$AoWoWTable;
-    $ID = $Database->SQLCommand($Query);
-                while($Line = mysql_fetch_assoc($ID)) 
-    {
-                        $Ori_text = $Line['name'];
-                $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
-                (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
-                 WHERE tableen.entry = tabletran.entry AND (Complete = 1) AND '.$WhereLang.'
-                  AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.') LIMIT 1) as tran
-                 FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE
-                  text = "'.addslashes($Ori_text).'" LIMIT 1'));
-                        //echo ($Line['name'].'='.$Tran['tran']);
-                        if ($Tran['tran'] == '') 
-      {
-                        $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT OptionText as en,
-                        (SELECT OptionText FROM '.$Config['Database']['Database'].'.npc_option as tabletran
-                         WHERE tableen.entry = tabletran.entry AND (Complete = 1) AND '.$WhereLang.'
-                          AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.') LIMIT 1) as tran
-                        FROM '.$Config['Database']['Database'].'.npc_option as tableen WHERE
-                        OptionText = "'.addslashes($Ori_text).'" LIMIT 1'));
-      }
-                  if ($Tran['tran'] <> '')
-                          $Buffer .= 'UPDATE `'.$AoWoWTable.'` SET name = "'.addslashes($Tran['tran']).'" WHERE '.$IndexColum.' = '.$Line[$IndexColum].' ;'."\n";
-    }
-        $Buffer .= "\n\n";  
-        }
-        if($Setting['Diacritics'] != 1) $Buffer = utf2ascii($Buffer);
-        return($Buffer);
-}  
- 
-  
-function ExportToXML($Setting)
-{
-  global $Database, $Config, $TranslationTree, $LanguageList;
-  
-  $AnoNe = array('Ne', 'Ano');
-  if($_SESSION['UserID'] != '')
-  {
-    $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE ID='.$_SESSION['UserID']);
-    $User = mysql_fetch_assoc($DbResult);
-  } else $User = array('user' => 'Neznámý');
-
-  $WhereLang = '';
-  foreach($LanguageList as $Language)
-    if($Language['Enabled'] == 1)
-      if(isset($Setting['language'.$Language['Id']]))  $WhereLang .= ' OR (Language = '.$Language['Id'].')'; 
-  if($WhereLang == '') $WhereLang = 1; 
-    else $WhereLang = '('.substr($WhereLang, 4).')';
-
-  $SelectedUsers = '';  
-  foreach($Setting['users-selection'] as $Item)
-    $SelectedUsers .= ','.$Item;
-  $SelectedUsers = substr($SelectedUsers, 1);
-
-  if($SelectedUsers == '') $Where = 0;
-    else $Where = 'ID IN ('.$SelectedUsers.')';
-  
-  $UserNames = '';
-  $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE '.$Where);
-  while($DbRow = mysql_fetch_assoc($DbResult))
-    $UserNames .= ','.$DbRow['user'];
-  $UserNames = substr($UserNames, 1);    
-   
-  if($SelectedUsers == '') $WhereUsers = 1; 
-    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
-
-  $Buffer = '<?xml version="1.0" encoding="utf-8"?>'."\n".
-  "<document>\n".
-  "  <meta>\n".
-  "    <projecturl>".$Config['Web']['BaseURL']."</projecturl>\n".
-  "    <time>".date('r')."</time>\n".
-  "    <diacritics mode=".'"'.$Setting['Diacritics'].'"'." />\n".
-  "    <author>".$User['user']."</author>\n".
-  "    <contributors>\n";
-  foreach(explode(',', $UserNames) as $UserName)
-    $Buffer .= "      <user>".$UserName."</user>\n";
-  $Buffer .= 
-  "    </contributors>\n".
-  "  </meta>\n".
-  "  <translation>\n";
-
-  foreach($TranslationTree as $Group)
-  if(in_array($Group['Id'], $Setting['groups'])) 
-  { 
-        if($Group['MangosTable'] == '')
-        {
-          $Group['MangosTable'] = $Group['TablePrefix'];
-          $Group['MangosTableIndex'] = 'entry';
-        }
-    $Query = 'SELECT *,(SELECT user FROM user WHERE user.ID=T.User) as UserName FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' AND '.$WhereLang.' AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';       
-    //echo($Query);
-    $Buffer .= '    <group id="'.$Group['Id'].'" name="'.$Group['TablePrefix'].'">'."\n";
-    $ID = $Database->SQLCommand($Query);
-    while($Line = mysql_fetch_array($ID)) 
-    {
-      $Buffer .= '      <item id="'.$Line['entry'].'" user="'.$Line['UserName'].'">'."\n";
-          $Values = '';
-          foreach($Group['Items'] as $GroupItem)
-          {
-            if($GroupItem['MangosColumn'] == '') $GroupItem['MangosColumn'] = $GroupItem['Column'];
-                if($Line[$GroupItem['Column']] != '')
-                  $Buffer .= '        <text index="'.$GroupItem['Id'].'" name="'.$GroupItem['Column'].'">'.addslashes($Line[$GroupItem['Column']]).'</text>'."\n";
-          }
-          $Buffer .= "      </item>\n";
-    }    
-        $Buffer .= "    </group>\n";
-  }
-  if($Setting['Diacritics'] != 1) $Buffer = utf2ascii($Buffer);
-  $Buffer .= "  </translation>\n".
-  "</document>";
-  return($Buffer);
-}      
-
-function ExportToDBC($Setting)
-{
-  global $Database, $Config, $TranslationTree, $LanguageList;
-  
-  $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/dbc/';
-  if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
- 
-  if($_SESSION['UserID'] != '')
-  {
-    $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE ID='.$_SESSION['UserID']);
-    $User = mysql_fetch_assoc($DbResult);
-  } else $User = array('user' => 'Neznámý');
-
-  $WhereLang = '';
-  foreach($LanguageList as $Language)
-    if($Language['Enabled'] == 1)
-      if(isset($Setting['language'.$Language['Id']]))  $WhereLang .= ' OR (Language = '.$Language['Id'].')'; 
-  if($WhereLang == '') $WhereLang = 1; 
-    else $WhereLang = '('.substr($WhereLang, 4).')';
-
-  $SelectedUsers = '';  
-  foreach($Setting['users-selection'] as $Item)
-    $SelectedUsers .= ','.$Item;
-  $SelectedUsers = substr($SelectedUsers, 1);
-
-  if($SelectedUsers == '') $Where = 0;
-    else $Where = 'ID IN ('.$SelectedUsers.')';
-  
-  $UserNames = '';
-  $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE '.$Where);
-  while($DbRow = mysql_fetch_assoc($DbResult))
-    $UserNames .= ','.$DbRow['user'];
-  $UserNames = substr($UserNames, 1);    
-   
-  if($SelectedUsers == '') $WhereUsers = 1; 
-    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
-  
-  foreach($TranslationTree as $Group)
-  if(in_array($Group['Id'], $Setting['groups']) and ($Group['DBCFileName'] != '')) 
-  { 
-        echo($Group['Name'].'... ');
-            $DBCFile = new DBCFile();
-            $DBCFile->OpenFile('../source/'.$Setting['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
-            $DBCFile2 = new DBCFile();
-            $DBCFile2->CreateFile($TempDir.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
-                $Count = $DBCFile->GetRecordCount();
-        //if($Group['DBCFileName'] == 'Spell') $Count = 1000;
-                $Line = $DBCFile->GetLine(0);
-            $DBCFile2->SetRecordCount($Count);   
-            for($I = 0; $I < $Count; $I++)
-            {
-              $Line = $DBCFile->GetLine($I);
-                  $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' AND (entry='.$Line[0].')  AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';       
-                  $DbResult = $Database->SQLCommand($Query);
-                  if(mysql_num_rows($DbResult) > 0)
-                  {
-                    $DbRow = mysql_fetch_assoc($DbResult);
-                //  if($Setting['Diacritics'] != 1) $Buffer = utf2ascii($Buffer);
-
-                foreach($Group['Items'] as $GroupItem)
-                      if(GetDBCColumnIndex($Setting['Version'],$Group['DBCFileName'],$GroupItem['Column']) != '')
-                        $Line[GetDBCColumnIndex($Setting['Version'],$Group['DBCFileName'],$GroupItem['Column'])] = $DbRow[$GroupItem['Column']];
-                  //print_r($Line);
-                  }
-              $DBCFile2->SetLine($I, $Line);
-                  echo('.');
-            }
-    $DBCFile2->Commit();
-    echo('Hotovo <br />');
+      while(!$File->EOF())
+      {
+        $Line = $File->ReadLine();
+        if(strpos($Line, '=') !== false)
+        {
+          $LineParts = explode(';', $Line);
+          $LineParts2 = explode('=', $LineParts[0]);
+          $Value['ShortCut'] = trim($LineParts2[0]);
+          $Value['Text'] = substr(trim($LineParts2[1]), 1, -1);
+          $Value['Comment'] = addslashes(substr(trim($LineParts[1]), 3));
+
+          $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$this->WhereLang.' AND '.$this->WhereUsers.' AND (ShortCut="'.$Value['ShortCut'].'") AND VersionStart <= '.$this->ClientVersion.' AND VersionEnd >= '.$this->ClientVersion.' ORDER BY FIELD(User, '.$this->SelectedUsers.')) AS T GROUP BY T.entry';
+          //echo($Query);
+          $DbResult2 = $this->Database->query($Query);
+          if($DbResult2->num_rows > 0)
+          {
+            $DbRow = $DbResult2->fetch_assoc();
+            $Value['Text'] = $DbRow['Text'];
+            $Value['Comment'] = $DbRow['Comment'];
+            //echo('.');
+          }
+          $NewLine = $Value['ShortCut'].' = "'.$Value['Text'].'";';
+          if($Value['Comment'] != '') $NewLine .= ' -- '.$Value['Comment'];
+          $NewLine .= "\n";
+          $File2->WriteLine($NewLine);
+        } else $File2->WriteLine($Line."\n");
+      }
+      echo('Hotovo <br />');
+    }
   }
 }
 
-function ExportToLua($Setting)
-{
-  global $Database, $Config, $TranslationTree, $LanguageList;
-  
-  $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/lua/';
-  if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
- 
-  if($_SESSION['UserID'] != '')
-  {
-    $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE ID='.$_SESSION['UserID']);
-    $User = mysql_fetch_assoc($DbResult);
-  } else $User = array('user' => 'Neznámý');
-
-  $WhereLang = '';
-  foreach($LanguageList as $Language)
-    if($Language['Enabled'] == 1)
-      if(isset($Setting['language'.$Language['Id']]))  $WhereLang .= ' OR (Language = '.$Language['Id'].')'; 
-  if($WhereLang == '') $WhereLang = 1; 
-    else $WhereLang = '('.substr($WhereLang, 4).')';
-
-  $SelectedUsers = '';  
-  foreach($Setting['users-selection'] as $Item)
-    $SelectedUsers .= ','.$Item;
-  $SelectedUsers = substr($SelectedUsers, 1);
-
-  if($SelectedUsers == '') $Where = 0;
-    else $Where = 'ID IN ('.$SelectedUsers.')';
-  
-  $UserNames = '';
-  $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE '.$Where);
-  while($DbRow = mysql_fetch_assoc($DbResult))
-    $UserNames .= ','.$DbRow['user'];
-  $UserNames = substr($UserNames, 1);    
-   
-  if($SelectedUsers == '') $WhereUsers = 1; 
-    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
-  
-  foreach($TranslationTree as $Group)
-  if(in_array($Group['Id'], $Setting['groups']) and ($Group['LuaFileName'] != '')) 
-  { 
-        echo($Group['Name'].'... ');
-    $File = new FileStream();
-    $File->OpenFile('../source/'.$Setting['Version'].'/lua/'.$Group['LuaFileName'].'.lua');
-    $File2 = new FileStream();
-    $File2->CreateFile($TempDir.''.$Group['LuaFileName'].'.lua');
-
-    while(!$File->EOF())
-        {
-          $Line = $File->ReadLine();
-          if(strpos($Line, '=') !== false)
-          {
-                $LineParts = explode(';', $Line);
-        $LineParts2 = explode('=', $LineParts[0]);
-                $Value['ShortCut'] = trim($LineParts2[0]);
-                $Value['Text'] = substr(trim($LineParts2[1]), 1, -1);
-                $Value['Comment'] = addslashes(substr(trim($LineParts[1]), 3));
-
-            $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' AND (ShortCut="'.$Value['ShortCut'].'") AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';
-                //echo($Query);
-            $DbResult = $Database->SQLCommand($Query);
-            if(mysql_num_rows($DbResult) > 0)
-            {
-              $DbRow = mysql_fetch_assoc($DbResult);
-                  $Value['Text'] = $DbRow['Text'];
-                  $Value['Comment'] = $DbRow['Comment'];
-              //echo('.');
-                }
-                $NewLine = $Value['ShortCut'].' = "'.$Value['Text'].'";';
-                if($Value['Comment'] != '') $NewLine .= ' -- '.$Value['Comment'];
-                $NewLine .= "\n";
-                $File2->WriteLine($NewLine);
-          } else $File2->WriteLine($Line."\n");
-        }
-    echo('Hotovo <br />');
-  }
-}
-
 ?>

trunk/export/index.php

@@ -3 +3 @@
 session_start();
 
-// příkaz:
-
-//php index.php "action=result" 'ExportSetting=a:10:{s:11:"users-order";s:838:",459,1,2,499,304,462,407,379,58,400,392,119,281,590,277,159,192,588,503,586,131,195,288,208,537,426,337,146,30,122,598,399,596,28,8,319,174,33,165,188,269,18,84,331,578,591,147,579,592,289,303,567,243,502,144,285,161,568,351,163,547,262,256,141,536,301,318,214,486,172,154,466,446,335,127,563,76,293,173,325,580,290,153,543,23,196,509,552,237,389,317,177,52,594,416,539,473,573,17,5,139,452,148,362,210,346,35,553,71,68,394,143,369,515,448,140,445,32,171,211,347,226,152,403,245,217,27,7,268,549,86,81,348,370,476,132,562,307,575,583,291,555,548,16,474,182,556,535,320,252,359,264,338,533,405,577,250,221,582,197,230,72,242,213,409,472,186,554,523,492,378,413,512,581,352,518,485,602,601,604,603,606,607,595,609,617,614,618,616,613,622,624,638,641,643,626,627,648,639,652,642,650,26,156,640,633,635,653,637,654,636,284,531,585,629,651,647";s:15:"users-selection";a:44:{i:0;s:3:"459";i:1;s:1:"1";i:2;s:1:"2";i:3;s:3:"499";i:4;s:3:"304";i:5;s:3:"462";i:6;s:3:"407";i:7;s:3:"379";i:8;s:3:"400";i:9;s:3:"281";i:10;s:3:"277";i:11;s:3:"159";i:12;s:3:"588";i:13;s:3:"503";i:14;s:3:"586";i:15;s:3:"131";i:16;s:3:"195";i:17;s:3:"288";i:18;s:3:"208";i:19;s:3:"537";i:20;s:3:"426";i:21;s:3:"337";i:22;s:3:"122";i:23;s:3:"319";i:24;s:3:"174";i:25;s:3:"165";i:26;s:3:"188";i:27;s:3:"269";i:28;s:2:"18";i:29;s:3:"331";i:30;s:3:"578";i:31;s:3:"579";i:32;s:3:"592";i:33;s:3:"567";i:34;s:3:"568";i:35;s:3:"446";i:36;s:3:"580";i:37;s:3:"362";i:38;s:3:"549";i:39;s:3:"562";i:40;s:3:"556";i:41;s:3:"618";i:42;s:3:"613";i:43;s:3:"622";}s:6:"groups";a:18:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"4";i:4;s:1:"5";i:5;s:1:"6";i:6;s:1:"7";i:7;s:1:"8";i:8;s:2:"10";i:9;s:2:"11";i:10;s:2:"12";i:11;s:2:"13";i:12;s:2:"14";i:13;s:2:"15";i:14;s:2:"16";i:15;s:2:"17";i:16;s:2:"18";i:17;s:2:"19";}s:10:"Diacritics";b:1;s:11:"language-cz";b:1;s:11:"language-sk";b:1;s:14:"language-other";b:0;s:6:"Export";s:11:"AoWoWImport";s:9:"language1";b:0;s:9:"language2";b:0;}'
-
-// Load commandline parameters
-if(!array_key_exists('REMOTE_ADDR', $_SERVER))
-{
-  foreach($_SERVER['argv'] as $parameter)
-  {
-    if(strpos($parameter, '=') !== false)
+include_once('../includes/global.php');
+include_once('export_output.php');
+
+function ExportList()
+{
+  global $Database;
+  
+  echo('<a href="?Action=ViewList">Všechny</a>');
+  if(Licence(LICENCE_USER))
+  {
+    echo(' <a href="?Action=ViewList&amp;Filter=Others">Ostatních</a>');
+    echo(' <a href="?Action=ViewList&amp;Filter=My">Moje</a>');
+  }
+  
+  $Filter = '';
+  if(array_key_exists('Filter', $_GET))
+  {
+    if($_GET['Filter'] == 'My') $Filter = ' WHERE `Export`.`User` = '.$_SESSION['UserID'];
+    if($_GET['Filter'] == 'Others') $Filter = ' WHERE `Export`.`User` != '.$_SESSION['UserID'];
+  }
+  
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Export` '.$Filter);
+  $DbRow = mysql_fetch_row($DbResult);
+  $PageList = GetPageList($DbRow[0]);    
+
+  echo('<h3>Seznam exportů</h3>');
+  echo($PageList['Output']);
+
+  $TableColumns = array(
+    array('Name' => 'TimeCreate', 'Title' => 'Čas vytvoření'), 
+    array('Name' => 'UserName', 'Title' => 'Překladatel'), 
+    array('Name' => 'Title', 'Title' => 'Popis'), 
+    array('Name' => 'UsedCount', 'Title' => 'Počet stažení'), 
+    array('Name' => 'UserCount', 'Title' => 'Překladatelů'), 
+    array('Name' => 'GroupCount', 'Title' => 'Překladových skupin'), 
+    array('Name' => '', 'Title' => 'Akce'), 
+  );  
+  $Order = GetOrderTableHeader($TableColumns, 'TimeCreate');
+  echo('<table class="BaseTable">');
+  echo($Order['Output']);
+
+  $DbResult = $Database->SQLCommand('SELECT `user`.`user` AS `UserName`, `Export`.*, (SELECT COUNT(*) FROM ExportGroup WHERE ExportGroup.Export=Export.Id) AS GroupCount, (SELECT COUNT(*) FROM ExportUser WHERE ExportUser.Export=Export.Id) AS UserCount FROM `Export` LEFT JOIN `user` ON `user`.`ID`=`Export`.`User` '.$Filter.$Order['SQL'].$PageList['SQLLimit']);
+  while($Export = mysql_fetch_assoc($DbResult))
+  {
+    $Action = '<a href="?Action=View&amp;ExportId='.$Export['Id'].'">Zobrazit</a>';
+    if($Export['User'] == $_SESSION['UserID']) $Action .= ' <a href="?Action=Delete&amp;ExportId='.$Export['Id'].'"><div onclick="return confirmAction(\'Opravdu smazat položku?\');">Smazat</div></a>';
+    echo('<tr><td>'.$Export['TimeCreate'].'</td><td>'.$Export['UserName'].'</td><td>'.$Export['Title'].'</td><td>'.$Export['UsedCount'].'</td><td>'.$Export['UserCount'].'</td><td>'.$Export['GroupCount'].'</td><td>'.$Action.'</td></tr>');
+  }
+  echo('</table>');
+  echo($PageList['Output']);
+    
+  if(Licence(LICENCE_USER)) echo('<br/><div style="text-align: center;"><a href="?Action=Create">Vytvořit nový export</a></div>');
+}
+
+function ExportCreate()
+{
+  if(Licence(LICENCE_USER))
+  {   
+    echo('<form action="?Action=CreateFinish" method="post">'.
+      '<fieldset><legend>Vytvoření nového exportu</legend>'.
+      '<table><tr><td>Titulek:</td><td><input type="text" name="Title" /></td></tr>'.
+      '<tr><td colspan="2"><input type="submit" value="Vytvořit" /></td></tr>'.
+      '</table></fieldset></form>');
+  } else echo('Nemáte oprávnění');
+}
+
+function ExportCreateFinish()
+{
+  global $Database;
+  
+  if(Licence(LICENCE_USER))
+  {   
+    if(array_key_exists('Title', $_POST))
     {
-      $index = substr($parameter,0,strpos($parameter, '='));
-      $parameter = substr($parameter,strpos($parameter, '=')+1);
-      //echo ($index.'  ----  '.$parameter);
-      $_GET[$index] = $parameter;
+      $Database->SQLCommand('INSERT INTO `Export` (`Title`, `User`, `TimeCreate`) VALUES ("'.$_POST['Title'].'", '.$_SESSION['UserID'].', NOW())');
+      $ExportId = mysql_insert_id();
+      echo('Nový export vytvořen.<br/>Přímý odkaz na tento export: <a href="?Action=View&amp;ExportId='.$ExportId.'">zde</a><br/><br/>');
+      $_GET['Filter'] = 'my';
+      ExportList();
+    } else echo('Chybí údaje formuláře');
+  } else echo('Nemáte oprávnění');
+}
+
+function ExportDelete()
+{
+  global $Database;
+  
+  if(Licence(LICENCE_USER))
+  {   
+    if(array_key_exists('ExportId', $_GET))
+    {
+      $Database->SQLCommand('DELETE FROM Export WHERE Id='.$_GET['ExportId']);
+      echo('Export smazán.<br/><br/>');
+      $_GET['Filter'] = 'my';
+      ExportList();
+    } else echo('Nebylo zadáno Id');
+  } else echo('Nemáte oprávnění');
+}
+
+function ExportViewTranslators()
+{
+  global $Database, $TranslationTree, $Config;
+
+  $DisabledInput = array(false => ' disabled="disabled"', true => '');
+  if(array_key_exists('ExportId', $_GET))
+  {
+    $DbRows = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+    if(mysql_num_rows($DbRows) > 0)
+    {    
+      $Export = mysql_fetch_assoc($DbRows);
+      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+        else $Editable = false;
+        
+        
+  if(array_key_exists('Operation', $_GET))
+  {
+    if($_GET['Operation'] == 'Save')
+    {
+      //print_r($_POST);
+      // Update user selection page
+      foreach($_POST as $Index => $Value)
+      {
+        if(substr($Index, 0, 3) == 'seq') 
+        {
+          $UserId = substr($Index, 3) * 1;
+          if(array_key_exists('sel'.$UserId, $_POST)) $Selected = true; 
+            else $Selected = false;
+          $Condition = ' WHERE Export='.$_GET['ExportId'].' AND User='.$UserId;
+          $DbResult = $Database->SQLCommand('SELECT * FROM ExportUser '.$Condition);
+          if(mysql_num_rows($DbResult) > 0)
+          {
+            if(!$Selected) $Database->SQLCommand('DELETE FROM ExportUser '.$Condition);
+              else $Database->SQLCommand('UPDATE ExportUser SET Sequence='.$Value.$Condition);
+          } else
+          {
+            if($Selected) $Database->SQLCommand('INSERT INTO ExportUser (Export, User, Sequence) VALUES ('.$_GET['ExportId'].', '.$UserId.', '.$Value.')');
+          }         
+        }
+      }
+      
+      // Recalculate sequence number
+      $Database->SQLCommand('SET @I = 0');
+      $Database->SQLCommand('UPDATE ExportUser SET Sequence = (@I := @I + 1) WHERE Export='.$_GET['ExportId'].' ORDER BY Sequence;');
     }
-  } 
-}
-
-if(!array_key_exists('ExportSetting', $_SESSION))
-  if(array_key_exists('ExportSetting', $_COOKIE)) 
-    $_SESSION['ExportSetting'] = $_COOKIE['ExportSetting'];
-  else $_SESSION['ExportSetting'] = '';
-  
-setcookie('ExportSetting', $_SESSION['ExportSetting'], time() + 60 * 60 * 24 * 100);
-include('../includes/global.php');
-include('../includes/zip.lib.php');
-include('export.php');    
-include('create_addon.php');
-include('../includes/dbc.php');
-
-ShowPage();
-
-function CheckBox($Name, $Checked = false, $Id = '', $Class = '')
-{
-  if($Id) $Id = ' id="'.$Id.'"'; else $Id = '';
-  if($Class) $Class = ' class="'.$Class.'"'; else $Class = '';
-  if($Checked) $Checked = ' checked="checked"'; else $Checked = '';
-  return('<input type="checkbox" value="checked" name="'.$Name.'"'.$Checked.$Id.$Class.' />');
-}
-
-function RadioButton($Name, $Value, $Checked = false, $onclick = '')
-{
-  if($Checked) $Checked = ' checked="checked"'; else $Checked = '';
-  return('<input onclick="'.$onclick.'" type="radio" name="'.$Name.'" value="'.$Value.'"'.$Checked.' />');
-}
-
-function SelectOption($Name, $Text, $Selected = false)
-{
-  if($Selected) $Selected = ' selected="selected"'; else $Selected = '';
-  return('<option value="'.$Name.'"'.$Selected.'>'.$Text.'</option>');
-}
-
-function GetVersions($out)
-{
-  global $Database,$TranslationTree,$Config;
-  $result = 'null';
-  if ($out == 'VerseCZ') $out = 'Addon';
-  if (($out == 'XMLCompressed') or ($out == 'XMLDirect'))  $out = 'sources'; 
-  if (($out == 'MangosSQLCompressed') or ($out == 'MangosSQLDirect') or ($out == 'AoWoWSQLCompressed') or ($out == 'AoWoWSQLDirect') or ($out == 'AoWoWImport'))  $out = 'sql'; 
-  switch($out)
-  {
-    case 'Addon':
-      $Addon_verses = scandir('files', 1);
-      unset($Addon_verses[count($Addon_verses) - 1]);
-      unset($Addon_verses[count($Addon_verses) - 1]);
-      unset($Addon_verses[count($Addon_verses) - 1]);
-    $result = '[';
-    foreach($Addon_verses as $version) {
-      $result .= "'".$version."',";
+  }
+
+  $Columns = '';
+  $Joins = '';
+  foreach($TranslationTree as $Group)
+    if($Group['TablePrefix'] != '')
+    {
+      $Columns .= 'COALESCE(T'.$Group['Id'].'.Count, 0) + ';
+      $Joins .= ' LEFT JOIN (SELECT User, COUNT(User) as Count FROM `'.$Group['TablePrefix'].'` WHERE (Complete = 1) AND (Language <> 0) GROUP BY User) as T'.$Group['Id'].' ON user.ID=T'.$Group['Id'].'.User';
+    }
+  $Query = 'SELECT (@I := @I + 1) AS Sequence2, ExportUser.Sequence, T.ID, T.TranslatedCount, T.user, T.XP FROM (SELECT user.ID, user.user, user.XP, ('.substr($Columns, 0, -3).') as TranslatedCount FROM `user`'.$Joins.') AS T';
+  $Query .=' LEFT JOIN ExportUser ON ExportUser.Export = '.$_GET['ExportId'].' AND ExportUser.User=T.ID';
+  $Query .=' WHERE T.TranslatedCount > 0 ORDER BY COALESCE(Sequence, 100)';
+
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$Query.') AS X');
+  $DbRow = mysql_fetch_row($DbResult);
+  $PageList = GetPageList($DbRow[0]);    
+  
+  $TableColumns = array(
+    array('Name' => 'user', 'Title' => 'Jméno'), 
+    array('Name' => 'TranslatedCount', 'Title' => 'Překladů'), 
+    array('Name' => 'XP', 'Title' => 'Úroveň'), 
+    array('Name' => '', 'Title' => 'Výběr'), 
+    array('Name' => 'Sequence2', 'Title' => 'Pořadí'), 
+  );  
+  $Order = GetOrderTableHeader($TableColumns, 'TranslatedCount');
+  echo('<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'&amp;Operation=Save" method="post">');
+  echo('<h3>Překladatelé</h3>');
+  echo('<input type="submit" value="Uložit výběr" '.$DisabledInput[$Editable].'/><br />'.
+   'Zvolte ze seznamu uživatele, od kterých chcete načítat překlady a upravte jejich pořadí.<br />'.
+    'Pořadí řádků je dáno číselnou hodnotou, kterou lze změnit na požadované pořadí. Řádky se stejným pořadovým číslem budou přečíslovány vzestupně.');
+
+  echo($PageList['Output']);
+  echo('<table class="BaseTable">');
+  echo($Order['Output']);
+
+  $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
+  $Database->SQLCommand('SET @I = 0');
+  $DbResult = $Database->SQLCommand($Query);
+  while($User = mysql_fetch_assoc($DbResult))
+  {
+    $Checked = $User['Sequence'] != '';
+    $Selection = CheckBox('sel'.$User['ID'], $Checked, '', 'CheckBox', !$Editable);
+    $Sequence = '<input type="text" name="seq'.$User['ID'].'" style="text-align: center; width: 40px;" value="'.$User['Sequence2'].'"'.$DisabledInput[$Editable].'/>';
+    echo('<tr>
+    <td><a href="'.$Config['Web']['BaseURL'].'/TranslationList.php?user='.$User['ID'].'&amp;action=userall" title="Zobrazit všechny jeho přeložené texty">'.$User['user'].'</a></td>
+    <td>'.$User['TranslatedCount'].'</td>
+      <td><img src="'.$Config['Web']['TempFolder'].$User['user'].'/level.png" alt="Úroveň uživatele" /></td>
+    <td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>');
+  }
+  echo('</table>');
+  echo('</form>');
+  echo($PageList['Output']);
+    } else echo('Položka nenalezena');
+  } else echo('Nebylo zadáno Id');
+}
+
+function ExportViewGeneral()
+{
+  global $Database;
+  
+  $DisabledInput = array(false => ' disabled="disabled"', true => '');
+  $DisabledTextArea = array(false => ' readonly="yes"', true => '');
+  echo('<h3>Obecná nastavení</h3>');
+  if(array_key_exists('ExportId', $_GET))
+  {
+    $DbRows = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+    if(mysql_num_rows($DbRows) > 0)
+    {    
+      $Export = mysql_fetch_assoc($DbRows);
+      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+        else $Editable = false;
+      if($Export['WithDiacritic'] == 1) $WithDiacritic = ' checked="checked"'; else $WithDiacritic = '';
+      echo('<form action="?Action=ModifyFinish&amp;ExportId='.$Export['Id'].'" method="post">'.
+        '<table>'.
+        '<tr><td colspan="2"><input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/></td></tr>'.
+'<tr><td>Označení:</td><td><input type="text" style="width: 400px" name="Title" value="'.$Export['Title'].'"'.$DisabledInput[$Editable].'/></td></tr>'.
+        '<tr><td>Popis:</td><td><textarea name="Description" cols="54" rows="10"'.$DisabledTextArea[$Editable].'></textarea></td></tr>'.
+        '<tr><td>Včetně háčků a čárek</td><td><input type="checkbox" name="WithDiacritic" '.$WithDiacritic.''.$DisabledInput[$Editable].'/></td></tr>'.
+      '</table></fieldset></form>');
+    } else echo('Položka nenalezena');
+  } else echo('Nebylo zadáno Id');
+}
+
+function ExportViewLanguages()
+{
+  global $Database, $TranslationTree, $Config;
+
+  $DisabledInput = array(false => ' disabled="disabled"', true => '');
+  if(array_key_exists('ExportId', $_GET))
+  {
+    $DbRows = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+    if(mysql_num_rows($DbRows) > 0)
+    {    
+      $Export = mysql_fetch_assoc($DbRows);
+      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+        else $Editable = false;
+        
+  if(array_key_exists('Operation', $_GET))
+  {
+    if($_GET['Operation'] == 'Save')
+    {
+      //print_r($_POST);
+      // Update user selection page
+      foreach($_POST as $Index => $Value)
+      {
+        if(substr($Index, 0, 3) == 'seq') 
+        {
+          $LanguageId = substr($Index, 3) * 1;
+          if(array_key_exists('sel'.$LanguageId, $_POST)) $Selected = true; 
+            else $Selected = false;
+          $Condition = ' WHERE Export='.$_GET['ExportId'].' AND Language='.$LanguageId;
+          $DbResult = $Database->SQLCommand('SELECT * FROM ExportLanguage '.$Condition);
+          if(mysql_num_rows($DbResult) > 0)
+          {
+            if(!$Selected) $Database->SQLCommand('DELETE FROM ExportLanguage '.$Condition);
+              else $Database->SQLCommand('UPDATE ExportLanguage SET Sequence='.$Value.$Condition);
+          } else
+          {
+            if($Selected) $Database->SQLCommand('INSERT INTO ExportLanguage (Export, Language, Sequence) VALUES ('.$_GET['ExportId'].', '.$LanguageId.', '.$Value.')');
+          }         
+        }
       }
-    $result = substr($result,0,strlen($result)-1);
-    $result .= "]";
-  break;
-    case 'sources':
-      $dirs = scandir('../source', 1);
-      unset($dirs[count($dirs) - 1]);
-      unset($dirs[count($dirs) - 1]);
-      unset($dirs[count($dirs) - 1]);
-    $result = '[';
-    foreach($dirs as $dir) {
-      $result .= "'".$dir."',";
-      }
-    $result = substr($result,0,strlen($result)-1);
-    $result .= "]";
-  break;
-    case 'sql':
-      $dirs = scandir('../source', 1);
-      unset($dirs[count($dirs) - 1]);
-      unset($dirs[count($dirs) - 1]);
-      unset($dirs[count($dirs) - 1]);
-    $result = '[';
-    foreach($dirs as $dir) {
-    if ($TranslationTree[1]['LastVersion'] >= GetBuildNumber($dir))
-        $result .= "'".$dir."',";
-      }
-    if ($result <> '[') $result = substr($result,0,strlen($result)-1);
-    $result .= "]";
-  break;
-    case 'DBC':
-      $sql = 'SELECT Version FROM wow_client_version WHERE DBCColumns_GameTips <> "" AND DBCColumns_Spell <> "" ORDER BY BuildNumber DESC';
-      $ID = $Database->SQLCommand($sql);
-    $result = '[';
-      while($Line = mysql_fetch_assoc($ID)) 
+      
+      // Recalculate sequence number
+      $Database->SQLCommand('SET @I = 0');
+      $Database->SQLCommand('UPDATE ExportLanguage SET Sequence = (@I := @I + 1) WHERE Export='.$_GET['ExportId'].' ORDER BY Sequence;');
+    }
+  }
+
+  $Query = 'SELECT (@I := @I + 1) AS Sequence2, Sequence, language.Id, Name FROM language';
+  $Query .=' LEFT JOIN ExportLanguage ON ExportLanguage.Export = '.$_GET['ExportId'].' AND ExportLanguage.Language=language.Id';
+  $Query .=' WHERE language.Enabled = 1 ORDER BY COALESCE(Sequence, 100)';
+
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$Query.') AS X');
+  $DbRow = mysql_fetch_row($DbResult);
+  $PageList = GetPageList($DbRow[0]);    
+  
+  $TableColumns = array(
+    array('Name' => 'Name', 'Title' => 'Název'), 
+    array('Name' => '', 'Title' => 'Výběr'), 
+    array('Name' => 'Sequence2', 'Title' => 'Pořadí'), 
+  );  
+  $Order = GetOrderTableHeader($TableColumns, 'Name');
+  echo('<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'&amp;Operation=Save" method="post">');
+  echo('<h3>Jazyky</h3>');
+  echo('<input type="submit" value="Uložit výběr" '.$DisabledInput[$Editable].'/><br />'.
+   'Zvolte ze seznamu dostupných jazyků, ze kterých chcete sestavit překlady a upravte jejich pořadí.<br />'.
+    'Pořadí řádků je dáno číselnou hodnotou, kterou lze změnit na požadované pořadí. Řádky se stejným pořadovým číslem budou přečíslovány vzestupně.');
+
+  echo($PageList['Output']);
+  echo('<table class="BaseTable">');
+  echo($Order['Output']);
+
+  $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
+  $Database->SQLCommand('SET @I = 0');
+  $DbResult = $Database->SQLCommand($Query);
+  while($Langugage = mysql_fetch_assoc($DbResult))
+  {
+    $Checked = $Langugage['Sequence'] != '';
+    $Selection = CheckBox('sel'.$Langugage['Id'], $Checked, '', 'CheckBox', !$Editable);
+    $Sequence = '<input type="text" name="seq'.$Langugage['Id'].'" style="text-align: center; width: 40px;" value="'.$Langugage['Sequence2'].'"'.$DisabledInput[$Editable].'/>';
+    echo('<tr>
+    <td>'.$Langugage['Name'].'</a></td>
+    <td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>');
+  }
+  echo('</table>');
+  echo('</form>');
+  echo($PageList['Output']);
+    } else echo('Položka nenalezena');
+  } else echo('Nebylo zadáno Id');
+}
+
+function ExportViewGroups()
+{
+  global $Database, $TranslationTree, $Config;
+
+  $DisabledInput = array(false => ' disabled="disabled"', true => '');
+  if(array_key_exists('ExportId', $_GET))
+  {
+    $DbRows = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+    if(mysql_num_rows($DbRows) > 0)
+    {    
+      $Export = mysql_fetch_assoc($DbRows);
+      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+        else $Editable = false;
+        
+  if(array_key_exists('Operation', $_GET))
+  {
+    if($_GET['Operation'] == 'Save')
+    {
+      //print_r($_POST);
+      // Update user selection page
+      foreach($_POST as $Index => $Value)
       {
-      $result .= "'".$Line['Version']."',";
-      }
-    $result = substr($result,0,strlen($result)-1);
-    $result .= "]";
-  break;
-    case 'Lua':
-      $dirs = scandir('../source', 1);
-    $result = '[';
-    foreach($dirs as $dir) {
-    $ok = true;
-        foreach($TranslationTree as $Group)
+        if(substr($Index, 0, 3) == 'seq') 
         {
-          if(($Group['LuaFileName'] != '') and ($Group['TablePrefix'] != ''))
+          $GroupId = substr($Index, 3) * 1;
+          if(array_key_exists('sel'.$GroupId, $_POST)) $Selected = true; 
+            else $Selected = false;
+          $Condition = ' WHERE `Export`='.$_GET['ExportId'].' AND `Group`='.$GroupId;
+          $DbResult = $Database->SQLCommand('SELECT * FROM `ExportGroup` '.$Condition);
+          if(mysql_num_rows($DbResult) > 0)
           {
-        if ((file_exists('../source/'.$dir.'/lua/'.$Group['LuaFileName'].'.lua') == false))
-        $ok = false;
+            if(!$Selected) $Database->SQLCommand('DELETE FROM `ExportGroup` '.$Condition);
+          } else
+          {
+            if($Selected) $Database->SQLCommand('INSERT INTO `ExportGroup` (`Export`, `Group`) VALUES ('.$_GET['ExportId'].', '.$GroupId.')');
+          }         
+        }
       }
     }
-    if ($ok) $result .= "'".$dir."',";
-      }
-    $result = substr($result,0,strlen($result)-1);
-    $result .= "]";
-  break;
-  }
-  return($result);
-}
-
-function WriteOption($str,$Selected)
-{
-  if ($str <> 'null')
-  {
-    $str = substr($str, 2, strlen($str) - 4);
-    $versions = explode("','", $str);
-    foreach($versions as $version) 
-    {
-      echo('<option value="'.$version.'"'); 
-      if($Selected == $version) echo(' selected="selected"'); 
-      echo('>'.$version.'</option>');
-    }
-  }
-}
-
-function WriteSetting($ExportSetting) 
-{
-  echo('<textarea rows="10" cols="100">'.serialize($ExportSetting).'</textarea><br />'.
-  'Odkaz ke stažení s vlastním nastavením: '.
-  '<a href="?action=output&amp;ExportSetting='.htmlspecialchars(serialize($ExportSetting)).'">Odkaz vlastního exportu</a><br />'.
-  'I když se nastavení ukládá, pro jistotu si jej můžete uložit nebo poslat příteli.');
-}
-
-if(array_key_exists('ExportSetting', $_GET)) 
-{
-  $ExportSetting = unserialize(stripcslashes(stripcslashes($_GET['ExportSetting'])));
-} else 
-{
-  if(array_key_exists('UserID', $_SESSION) and ($_SESSION['UserID'] != ''))
-  {
-    $DbResult = $Database->SQLCommand('SELECT ExportSetting FROM user WHERE ID='.$_SESSION['UserID']);
-    $DbRow = mysql_fetch_assoc($DbResult);
-    $ExportSetting = unserialize($DbRow['ExportSetting']);
-
-    //print_r($_POST);
-  } else $ExportSetting = unserialize($_SESSION['ExportSetting']);
-}
-if(!isset($ExportSetting['users-selection'])) $ExportSetting['users-selection'] = array();
-if(!isset($ExportSetting['Diacritics'])) $ExportSetting['Diacritics'] = 1;
-foreach($LanguageList as $Language)
-  if($Language['Enabled'] == 1)
-    if(!isset($ExportSetting['language'.$Language['Id']])) $ExportSetting['language'.$Language['Id']] = 1;
-if(!isset($ExportSetting['users-order'])) $ExportSetting['users-order'] = '';
-if(!isset($ExportSetting['Export'])) $ExportSetting['Export'] = 'Addon';
-if(!isset($ExportSetting['Version'])) $ExportSetting['Version'] = $Config['Web']['GameVersion'];
-if(!isset($ExportSetting['groups'])) $ExportSetting['groups'] = array();
-
-function CreateZipFromDir(&$Zip, $Path, $ZipPath)
-{
-  //echo($Path.'<br />');
-  $FileList = scandir($Path);
-  foreach($FileList as $FileName)
-  {
-    if(file_exists($Path.$FileName) and ($FileName != '.') and ($FileName != '..'))
-    {
-      //echo($Path.$FileName.'<br />');
-      if(is_dir($Path.$FileName)) CreateZipFromDir($Zip, $Path.$FileName.'/', $ZipPath.$FileName.'/');
-        else $Zip->addFile(file_get_contents($Path.$FileName), $ZipPath.$FileName); 
-    }          
-  }
-}
-
-if(!array_key_exists('action', $_GET)) $_GET['action'] = '';
-switch($_GET['action'])
-{
-  case 'result':
-    if (array_key_exists('Version',$_POST)) $ExportSetting['Version'] = $_POST['Version'];
-    if (array_key_exists('Export',$_POST)) $ExportSetting['Export'] = $_POST['Export'];
-    switch($ExportSetting['Export'])
-    {
-      case 'MangosSQLCompressed':
-        if(function_exists('gzcompress')) 
-        {
-          $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/';
-          if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
-          $SaveFilename = $TempDir.'CzWoW_SQL.zip';
-          $SQLFilename = 'CzWoW_SQL.sql';        
-          $BufferZip = ExportToMangosSQL($ExportSetting);
-          $ZipFile = new zipfile();
-          $ZipFile->addFile($BufferZip, $SQLFilename);
-          $Buffer = $ZipFile->file();
-          file_put_contents($SaveFilename, $Buffer);
-        } else echo('Funkce pro tvorbu Zip souboru není podporována!');
-        echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
-          'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
-          '</script>');
-      
-        echo('Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
-          '<a href="'.$SaveFilename.'">'.$SQLFilename.'</a><br />'.
-          'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
-        break;
-      case 'MangosSQLDirect':
-        echo('Vygenerovaný SQL kód: <br /><pre class="SQLCode">');
-        echo(htmlspecialchars(ExportToMangosSQL($ExportSetting)));
-        echo('</pre>');
-        break;
-      case 'AoWoWSQLCompressed':
-        if(function_exists('gzcompress')) 
-        {
-          $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/';
-          if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
-          $SaveFilename = $TempDir.'CzAoWoW_SQL.zip';
-          $SQLFilename = 'CzAoWoW_SQL.sql';        
-          $BufferZip = ExportToAoWoWSQL($ExportSetting);
-          $ZipFile = new zipfile();
-          $ZipFile->addFile($BufferZip, $SQLFilename);
-          $Buffer = $ZipFile->file();
-          file_put_contents($SaveFilename, $Buffer);
-        } else echo('Funkce pro tvorbu Zip souboru není podporována!');
-        echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
-          'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
-          '</script>');
-      
-        echo('Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
-          '<a href="'.$SaveFilename.'">'.$SQLFilename.'</a><br />'.
-          'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
-        break;
-      case 'AoWoWSQLDirect':
-        echo('Vygenerovaný SQL kód: <br /><pre class="SQLCode">');
-        echo(htmlspecialchars(ExportToAoWoWSQL($ExportSetting)));
-        echo('</pre>');
-        break;
-      case 'AoWoWImport':
-        require_once('../aowow/configs/config.php');
-      echo('<div style="font-size: xx-small;">');
-        echo('Gewneruji SQL kód ');
-        $AoWoWSQL = ExportToAoWoWSQL($ExportSetting);
-        echo('<strong>Hotovo</strong><br />');
-
-        $Database->SelectDatabase($AoWoWconf['mangos']['db']);    
-        $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
+  }
+
+  $Query = 'SELECT `group`.*, `ExportGroup`.`Id` AS `ExportGroupId` FROM `group` LEFT JOIN `ExportGroup` ON `ExportGroup`.`Export`='.$_GET['ExportId'].' AND `Group`=`group`.`Id`';
+
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$Query.') AS X');
+  $DbRow = mysql_fetch_row($DbResult);
+  $PageList = GetPageList($DbRow[0]);    
+  
+  $TableColumns = array(
+    array('Name' => 'Name', 'Title' => 'Jméno'), 
+    array('Name' => 'MangosTable', 'Title' => 'Tabulka MaNGOSu'), 
+    array('Name' => 'DBCFileName', 'Title' => 'DBC soubor'), 
+    array('Name' => 'LuaFileName', 'Title' => 'Lua soubor'), 
+    array('Name' => '', 'Title' => 'Výběr'), 
+  );  
+  $Order = GetOrderTableHeader($TableColumns, 'Name');
+  echo('<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'&amp;Operation=Save" method="post">');
+  echo('<h3>Překladové skupiny</h3>');
+  echo('<input type="submit" value="Uložit výběr" '.$DisabledInput[$Editable].'/><br />'.
+   'Zvolte ze překladových skupin, ze kterých chcete načítat překlady.<br />');
+
+  echo($PageList['Output']);
+  echo('<table class="BaseTable">');
+  echo($Order['Output']);
+
+  $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
+  $DbResult = $Database->SQLCommand($Query);
+  while($Group = mysql_fetch_assoc($DbResult))
+  {
+    $Checked = $Group['ExportGroupId'] != '';
+    $Selection = CheckBox('sel'.$Group['Id'], $Checked, '', 'CheckBox', !$Editable);
+    echo('<tr>'.
+    '<td>'.$Group['Name'].'</td>'.
+    '<td>'.$Group['MangosTable'].'</td>'.
+    '<td>'.$Group['DBCFileName'].'</td>'.
+    '<td>'.$Group['LuaFileName'].'</td>'.
+    '<td>'.$Selection.'<input type="hidden" name="seq'.$Group['Id'].'"/></td></tr>');
+  }
+  echo('</table>');
+  echo('</form>');
+  echo($PageList['Output']);
+    } else echo('Položka nenalezena');
+  } else echo('Nebylo zadáno Id');
+}
+
+function ExportViewOutputFormat()
+{
+  global $Database;
+  
+  $DisabledInput = array(false => ' disabled="disabled"', true => '');
+  if(array_key_exists('ExportId', $_GET))
+  {
+    $DbRows = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+    if(mysql_num_rows($DbRows) > 0)
+    {    
+      $Export = mysql_fetch_assoc($DbRows);
+      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+        else $Editable = false;
+  
+  if(array_key_exists('OutputType', $_POST))
+  {
+    $Database->SQLCommand('UPDATE Export SET OutputType='.$_POST['OutputType'].' WHERE Id='.$_GET['ExportId']);
+  }
+
+  $DbResult = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+  $Export = mysql_fetch_assoc($DbResult);
+  
+  echo('<h3>Formát generovaného výstupu</h3>');
+  echo('<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'&amp;Operation=Save" method="post">');
+  echo('<input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/><br/>');
+  $DbResult = $Database->SQLCommand('SELECT * FROM ExportOutputType ORDER BY Name');
+  while($ExportFormat = mysql_fetch_assoc($DbResult))
+  {
+    echo(RadioButton('OutputType', $ExportFormat['Id'], $Export['OutputType'] == $ExportFormat['Id'], '', !$Editable).' '.$ExportFormat['Name'].'<br/>');
+  }
+  echo('</form>');
+    } else echo('Položka nenalezena');
+  } else echo('Nebylo zadáno Id');
+}
+
+function ExportViewVersion()
+{
+  global $Database, $Config;
+
+  $DisabledInput = array(false => ' disabled="disabled"', true => '');
+  if(array_key_exists('ExportId', $_GET))
+  {
+    $DbRows = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+    if(mysql_num_rows($DbRows) > 0)
+    {    
+      $Export = mysql_fetch_assoc($DbRows);
+      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+        else $Editable = false;
         
-        echo('Aktualizuji aktuality ');
-        $Database->SQLCommand("UPDATE `aowow_news` SET `text_loc0` = 'Poslední aktualizace dat ".Date ("d. n. Y, H:i:s")." ', `text_loc8` = 'Poslední aktualizace dat ".Date ("d. n. Y, H:i:s")." ' WHERE `aowow_news`.`id` =3");
-        echo('<strong>Hotovo</strong><br />');
-
-        echo('Mažu dočasné soubory ');
-        $files = scandir('../aowow/cache/mangos');
-        foreach($files as $file) 
-        {
-          $end = substr($file, strlen($file) - 3);
-          if($end == 'aww') unlink('../aowow/cache/mangos/'.$file);
-        }
-        $files = scandir('../aowow/cache/templates/wowhead');
-        foreach($files as $file) 
-        {
-          $end = substr($file, strlen($file) - 3);
-          if ($end == 'php') unlink('../aowow/cache/templates/wowhead/'.$file);
-        }
-        echo ('<strong>Hotovo</strong><br />');
-
-        echo('Importuji do AoWoW ');
-        $BufferArray = explode(";\n", $AoWoWSQL);
-        foreach($BufferArray as $Line) 
-        {
-          if($Line <> '') $Database->SQLCommand($Line);
-          echo('. ');
-        }   
-        echo('<strong>Hotovo</strong><br />');
-    
-        // TODO   aowow_itemenchantmet, aowow_char_titles, aowow_factions, aowow_itemset, aowow_spelldispeltype, aowow_spellmechanic, aowow_spellrange, aowow_zones
-        
-        $Database->SelectDatabase($Config['Database']['Database']);    
-        $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
-    echo('</div>');
-        WriteLog('Plnění AoWoW databáze překladem', 4);
-        break;
-      case 'XMLCompressed':
-        if(function_exists('gzcompress')) 
-        {
-          $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/';
-          if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
-          $SaveFilename = $TempDir.'CzWoW_XML.zip';
-          $SQLFilename = 'CzWoW_XML.sql';        
-          $BufferZip = ExportToXML($ExportSetting);
-          $ZipFile = new zipfile();
-          $ZipFile->addFile($BufferZip, $SQLFilename);
-          $Buffer = $ZipFile->file();
-          file_put_contents($SaveFilename, $Buffer);
-        } else echo('Funkce pro tvorbu Zip souboru není podporována!');
-        echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
-          'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
-          '</script>');
-      
-        echo('Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
-          '<a href="'.$SaveFilename.'">CzWoW_SQL.zip</a><br />'.
-          'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
-        break;
-    case 'XMLDirect':
-        echo('Vygenerované XML: <br /><pre class="SQLCode">');
-        echo(htmlspecialchars(ExportToXML($ExportSetting)));
-        echo('</pre>');
-        break;
-    /*case 'Server':
-      if(Licence(LICENCE_ADMIN)) 
-    {
-      $Buffer = ExportToMangosSQL($ExportSetting);
-          $Database->SelectDatabase($Config['Database']['DatabaseMangos']);    
-          $BufferArray = explode("\n", $Buffer);
-      echo('Přenášení dat do serveru...<br />');
-          foreach($BufferArray as $Line) 
-          {
-      $Database->SQLCommand($Line);
-      echo('.');
-      }
-          echo("<br />Hotovo<br />");
-    } else echo('Nemáte oprávnění.');
-      break;*/
-    case 'Addon':
-      if(function_exists('gzcompress')) {
-              $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/CzWoW-'.$ExportSetting['Version'].'/';
-            echo('Generování addonu...'.$ExportSetting['Export'].'<br />');
-              MakeAddon($ExportSetting);
-              $SaveFilename = $Config['Web']['TempFolder'].$_SESSION['User'].'/CzWoW_Addon-'.$ExportSetting['Version'].'.zip';          
-              $Zip = new zipfile();
-          CreateZipFromDir($Zip, $TempDir, 'CzWoW/');
-              $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/OptionsFrame.xml'), 'CzWoW/OptionsFrame.xml'); 
-              $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/CzWoW.xml'), 'CzWoW/CzWoW.xml'); 
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/CzWoW.toc'), 'CzWoW/CzWoW.toc'); 
-              $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/CzWoW.lua'), 'CzWoW/CzWoW.lua'); 
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/GameMenuFrame.xml'), 'CzWoW/GameMenuFrame.xml'); 
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/Localization.lua'), 'CzWoW/Localization.lua'); 
-          $Buffer = $Zip->file();
-              file_put_contents($SaveFilename, $Buffer);
-            echo('Hotovo<br /><br />');
-          } else echo('Funkce pro tvorbu Zip souboru není podporována!');
-            echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
-              'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
-              '</script>');
-      
-            echo('Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
-              '<a href="'.$SaveFilename.'">CzWoW_Addon-'.$ExportSetting['Version'].'.zip</a><br />'.
-              'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
-        echo('<br /><strong>Použití ve hře</strong><br />Menu addonu ve hře vyvoláte povelem /czwow.');
-      break;
-    case 'VerseCZ':
-        if(function_exists('gzcompress')) 
-        {
-          $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT verse FROM verseclient ORDER BY DATE DESC LIMIT 1'));
-          $TempDir = $Config['Web']['TempFolder'].'Addon/CzWoW/';
-        echo('Generování addonu...<br />');
-          MakeAddon($ExportSetting);
-          MakeReadme($ExportSetting);
-
-          $SaveFilename = $Config['Web']['TempFolder'].'Addon/CzWoW_'.$Line['verse'].'.zip';          
-          $Zip = new zipfile();
-      CreateZipFromDir($Zip, $TempDir, 'Interface/AddOns/CzWoW/');
-          //addon
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/OptionsFrame.xml'), 'Interface/AddOns/CzWoW/OptionsFrame.xml');  
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/CzWoW.xml'), 'Interface/AddOns/CzWoW/CzWoW.xml');  
-      $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/CzWoW.toc'), 'Interface/AddOns/CzWoW/CzWoW.toc');  
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/CzWoW.lua'), 'Interface/AddOns/CzWoW/CzWoW.lua');  
-      $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/GameMenuFrame.xml'), 'Interface/AddOns/CzWoW/GameMenuFrame.xml');  
-      $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/CzWoW/Localization.lua'), 'Interface/AddOns/CzWoW/Localization.lua');  
-      //fonty
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/Fonts/FRIZQT__.ttf'), 'Fonts/FRIZQT__.ttf'); 
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/Fonts/MORPHEUS.ttf'), 'Fonts/MORPHEUS.ttf'); 
-          $Zip->addFile(file_get_contents('files/'.$ExportSetting['Version'].'/Fonts/SKURRI.ttf'), 'Fonts/SKURRI.ttf'); 
-          //readme
-          $Zip->addFile(file_get_contents($Config['Web']['TempFolder'].'Addon/CzWoW/CZWOW-Readme.txt'), 'CZWOW-Readme.txt');  
-               
-      $Buffer = $Zip->file();
-          file_put_contents($SaveFilename, $Buffer);
-             WriteLog('Vytvořena verze češtiny pro clienta '.$Line['verse'], 4);
-
-        echo('Hotovo<br /><br />');
-        } else echo('Funkce pro tvorbu Zip souboru není podporována!');
-              
-        echo('Odkaz ke stažení: '. 
-          '<a href="'.$SaveFilename.'">'.$SaveFilename.'</a><br />');
-      break;
-    case 'DBC':
-    
-      echo('<br /><br /><br />U dbc souborů export textů funguje jinak, protože generování je náročné na výpočet provádí se přes noc kdy je server nejmíň vytížen. Nyní jste zadali úlohu, která se provede v noci. Zítra si můžete stáhnout vygenerovaný soubor v sekci <a href="../download.php">Stahování</a>.<br /><br />Dbc soubory je nutné zabalit do souboru patch-enGB-5.MPQ uvnitř složky "DBFilesClient" a hru spouštět přes wowme.exe. Zabalit to můžete pomocí programu <a href="../download/mpqediten32.zip">Ladik\'s MPQ Editor</a>. Stav vygenerování můžete sledovat na stránce <a href="../download.php">Stahování</a>, kde si také můžete zítra stáhnout soubor.<br /><br />');
-    
-          //TODO: pouze jedna aktivní úloha na uživatele 
-        $sql = 'SELECT * FROM tasks WHERE Active = 1 AND User = '.$_SESSION['UserID'];
-        $ID = $Database->SQLCommand($sql);
-    if (mysql_num_rows($ID) > 0)
-    {
-      echo ('Nemůžete zadat stejný požadavek dvakrát za den. Bylo pouze aktualizováno nastavení exportu!');
-          $Database->SQLCommand('UPDATE `wowpreklad`.`tasks` SET `ExportSetting` = "'.addslashes(serialize($ExportSetting)).'" WHERE Active = 1 AND User = '.$_SESSION['UserID']);
-      } else {
-          $Database->SQLCommand('INSERT INTO `wowpreklad`.`tasks` (`User` ,`ExportSetting` ,`Date` ) VALUES ("'.$_SESSION['UserID'].'", "'.addslashes(serialize($ExportSetting)).'", NOW( ))');
-    }
-    WriteLog('Zadání úlohy pro vygenerování dbc souboru', 2);
-      
-    
-    /*
-        if(function_exists('gzcompress')) 
-        {
-          $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/dbc/';
-        echo('Generování dbc souborů...<br />');
-          ExportToDBC($ExportSetting);
-          $SaveFilename = $Config['Web']['TempFolder'].$_SESSION['User'].'/CzWoW_DBC.zip';          
-          $Zip = new zipfile();
-        CreateZipFromDir($Zip, $TempDir, 'DBCClientFiles/');
-          $Buffer = $Zip->file();
-          file_put_contents($SaveFilename, $Buffer);
-        echo('Hotovo<br /><br />');
-        } else echo('Funkce pro tvorbu Zip souboru není podporována!');
-        echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
-          'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
-          '</script>');
-      
-        echo('Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
-          '<a href="'.$SaveFilename.'">CzWoW_DBC.zip</a><br />'.
-          'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
-    echo('<br /><br /><strong>Použití ve hře</strong><br />Ze souborů vytvořte MPQ archív a nahrajte ho do hry do podsložky Data/enUS jako patch-enUS-5.MPQ. Hru spusťte pomocí programu WoWMe.exe (WoW Model Editor Fix).');
-    */
-   
-      break;
-    case 'Lua':
-        if(function_exists('gzcompress')) 
-        {
-          $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/lua/';
-        echo('Generování lua souborů...<br />');
-          ExportToLUA($ExportSetting);
-          $SaveFilename = $Config['Web']['TempFolder'].$_SESSION['User'].'/CzWoW_Lua.zip';          
-          $Zip = new zipfile();
-        CreateZipFromDir($Zip, $TempDir, '');
-          $Buffer = $Zip->file();
-          file_put_contents($SaveFilename, $Buffer);
-        echo('Hotovo<br /><br />');
-        } else echo('Funkce pro tvorbu Zip souboru není podporována!');
-        echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
-          'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
-          '</script>');
-      
-        echo('Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
-          '<a href="'.$SaveFilename.'">CzWoW_Lua.zip</a><br />'.
-          'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
-    echo('<br /><br /><strong>Použití ve hře</strong><br />Ze souborů vytvořte MPQ archív a nahrajte ho do hry do podsložky Data/enUS jako patch-enUS-5.MPQ. Hru spusťte pomocí programu WoWMe.exe (WoW Model Editor Fix).');
-      break;
-  }     
-    //statistika výstupu
-    if ($ExportSetting['Export'] <> 'AoWoWSQLDirect' and $ExportSetting['Export'] <> 'XMLDirect' and $ExportSetting['Export'] <> 'AoWoWImport' and $ExportSetting['Export'] <> 'MangosSQLDirect') {
-      echo '<br /><br />';
-          foreach($TranslationTree as $Group)
-          if($Group['TablePrefix'] != '' and (in_array($Group['Id'], $ExportSetting['groups']))) 
-          echo('<div class="state-image"><img alt="'.$Group['TablePrefix'].'" src="../img_statistic.php?group='.$Group['Id'].'&amp;user='.$_SESSION['UserID'].'" title="statistika překladů '.$Group['Name'].'"/></div>');
-        }
-    
-  WriteLog('Generování SQL výstupu: Typ exportu: <strong>'.$ExportSetting['Export'].'</strong>, Diakritika: <strong>'.$ExportSetting['Diacritics'].'</strong>', 2);
-    break;
-  case 'output':
-    if(array_key_exists('groups', $_POST)) $ExportSetting['groups'] = $_POST['groups'];
-    $ExportSetting['Diacritics'] = array_key_exists('Diacritics', $_POST);
-    foreach($LanguageList as $Language)
-      if($Language['Enabled'] == 1) 
-        $ExportSetting['language'.$Language['Id']] = array_key_exists('language'.$Language['Id'], $_POST);
-    
-    if(array_key_exists('ExportSetting', $_GET))
-      $ExportSetting = unserialize(stripcslashes(stripcslashes($_GET['ExportSetting'])));
-
-    echo('<strong>Krok 3. - Typ výstupu</strong><br /><br />');
-    echo('<form action="?action=result" method="post"><div>'.
-      '<table><tr><td>'.
-      '<fieldset><legend>Forma výstupu</legend>'.
-      RadioButton('Export', 'MangosSQLDirect', $ExportSetting['Export'] == 'MangosSQLDirect', 'UpdateVersion('.GetVersions('MangosSQLDirect').',\''.$ExportSetting['Version'].'\')').'MaNGOS SQL - přímo zobrazit<br />'.
-    RadioButton('Export', 'MangosSQLCompressed', $ExportSetting['Export'] == 'MangosSQLCompressed', 'UpdateVersion('.GetVersions('MangosSQLCompressed').',\''.$ExportSetting['Version'].'\')').'MaNGOS SQL - komprimovaný soubor<br />'.
-    RadioButton('Export', 'AoWoWSQLDirect', $ExportSetting['Export'] == 'AoWoWSQLDirect', 'UpdateVersion('.GetVersions('AoWoWSQLDirect').',\''.$ExportSetting['Version'].'\')').'AoWoW SQL - přímo zobrazit<br />'.
-    RadioButton('Export', 'AoWoWSQLCompressed', $ExportSetting['Export'] == 'AoWoWSQLCompressed', 'UpdateVersion('.GetVersions('AoWoWSQLCompressed').',\''.$ExportSetting['Version'].'\')').'AoWoW SQL - komprimovaný soubor<br />'.
-      RadioButton('Export', 'XMLDirect', $ExportSetting['Export'] == 'XMLDirect', 'UpdateVersion('.GetVersions('XMLDirect').',\''.$ExportSetting['Version'].'\')').'XML - přímo zobrazit<br />'.
-    RadioButton('Export', 'XMLCompressed', $ExportSetting['Export'] == 'XMLCompressed', 'UpdateVersion('.GetVersions('XMLCompressed').',\''.$ExportSetting['Version'].'\')').'XML - komprimovaný soubor<br />'.
-    RadioButton('Export', 'Addon', $ExportSetting['Export'] == 'Addon', 'UpdateVersion('.GetVersions('Addon').',\''.$ExportSetting['Version'].'\')').'Addon - komprimovaný soubor<br />'.
-    RadioButton('Export', 'Lua', $ExportSetting['Export'] == 'Lua', 'UpdateVersion('.GetVersions('Lua').',\''.$ExportSetting['Version'].'\')').'Lua skripty - komprimovaný soubor<br />');
-      if(Licence(LICENCE_USER)) {
-          echo(RadioButton('Export', 'DBC', $ExportSetting['Export'] == 'DBC', 'UpdateVersion('.GetVersions('DBC').',\''.$ExportSetting['Version'].'\')').'DBC - komprimovaný soubor (pouze přihlášení)<br />');
-    } else {
-      echo ('  <span style="padding: 20px"> Pro export do souborů dbc musíte být přihlášen</span>');
-    }
-      if(Licence(LICENCE_ADMIN)) {
-       //   echo(RadioButton('Export', 'DBC', $ExportSetting['Export'] == 'DBC', 'UpdateVersion('.GetVersions('DBC').',\''.$ExportSetting['Version'].'\')').'DBC - komprimovaný soubor (pouze admin)<br />');
-          echo(RadioButton('Export', 'AoWoWImport', $ExportSetting['Export'] == 'AoWoWImport', 'UpdateVersion('.GetVersions('AoWoWImport').',\''.$ExportSetting['Version'].'\')').'Importovat do AoWoW (pouze admin)<br />');
-        echo(RadioButton('Export', 'VerseCZ', $ExportSetting['Export'] == 'VerseCZ', 'UpdateVersion('.GetVersions('VerseCZ').',\''.$ExportSetting['Version'].'\')').'Vytvoření verze češtiny <a href="../download.php?createverse" Title="Před konečným exportováním napište popis k verzi" Target="_NEW">Popis k verzi</a> (pouze admin)<br />');
-      }
-    //echo('
-    echo('</fieldset>');
-    echo('<fieldset><legend>Dostupné verze výstupu</legend>');
-  echo('<select id="Version" size="5" name="Version">');
-  WriteOption(GetVersions($ExportSetting['Export']),$ExportSetting['Version']);
-    echo('</select></fieldset>');
-  echo('</td>');
-  echo('<td class="Description">Zvolte způsob, jakým mají být získána výstupní data. V případě přímého zobrazení může být do vašeho prohlížeče přenášeno vysoké množství dat, což může vést k jeho přetížení.<br /><br />Poté zvolte pro kterou verzi hry mají být data získána. Pokud verze není přesná zvolte nejbližší.<br /><br />Addon je potřeba nakopírovat do složky klienta Interface/AddOns a ve hře lze zpřístupnit jeho možnosti pomocí příkazu /czwow.<br />');
-  echo('</td></tr></table>');
-  echo('<br /><input type="submit" value="Dokončit" />');
-  echo('</div></form><br />');
-  echo('<fieldset><legend>Nastavení exportu pro zálohování</legend>');
-  WriteSetting($ExportSetting);    
-  echo ('</fieldset>');
-  break;
-  case 'parameters':
-    $ExportSetting['users-order'] = $_POST['users-order'];
-    $ExportSetting['users-selection'] = array();
-    $UsersList = explode(',', $_POST['users-order']);
-  foreach($UsersList as $Index => $Item)
-  {
-    if(array_key_exists('user_'.$Item, $_POST)) $ExportSetting['users-selection'][] = $Item;
-  }
-  //if(array_key_exists('users', $_POST)) $ExportSetting['users'] = $_POST['users'];
-    echo('<strong>Krok 2. - Volba parametrů</strong><br /><br />');
-    echo('<form action="?action=output" method="post"><div>');
-  echo('<table><tr><td>');
-    echo('<fieldset><legend>Jazyk</legend>'.
-      CheckBox('Diacritics', $ExportSetting['Diacritics'] == 'checked').'Včetně diakritiky<br /><br />');  
-    //echo('<input type="checkbox" name="Use" checked="true">Přidat výchovýběr databáze.<br />');
-
-    foreach($LanguageList as $Language)
-    if($Language['Enabled'] == 1)
-      echo(CheckBox('language'.$Language['Id'], $ExportSetting['language'.$Language['Id']] == 'checked').$Language['Name'].'<br />');
-      
-    echo('</fieldset><br /></td><td class="Description">Pro správné zobrazení českých znaků ve hře je nutné používat upravené <a href="download/ceske_fonty_do_wow.zip">počeštěné fonty</a>.<br />Vyberte jaké jazyky se mají uvažovat při exportu.</td></tr><tr><td><fieldset><legend>Skupiny textů</legend>');
-    echo('<select name="groups[]" size="15" multiple="multiple">');
-    foreach($TranslationTree as $Group)
-      if($Group['TablePrefix'] != '')
-        echo(SelectOption($Group['Id'], $Group['Name'].' ('.$Group['TablePrefix'].')', in_array($Group['Id'], $ExportSetting['groups'])));
-
-  echo('</select></fieldset><br /></td><td class="Description">Vyberte skupiny textů, z kterých bude sestaven export. Přidržením CTRL nebo SHIFT můžete provádět výběr více položek.</td></tr></table><input type="submit" value="Pokračovat" />');
-  echo('</div></form>');
-    break;
-  default:
-    echo('<strong>Krok 1. - Výběr překladatelů</strong><br /><br />');
-  echo('<script type="text/javascript" src="'.$Config['Web']['BaseURL'].'style/jquery.js"></script>
-<script type="text/javascript" src="'.$Config['Web']['BaseURL'].'style/jquery-ui.js"></script>
-<script type="text/javascript">
-$(document).ready(function()
-{
-  $("#users-table").sortable({ items: "tr", sort: SortComplete });  
-  $("#users-order").val($("#users-table").sortable(\'toArray\'));
-});
-
-function SortComplete()
-{
-  $("#users-order").val($("#users-table").sortable(\'toArray\')); 
-}
-</script>');
-    echo('<form id="ListUser" action="?action=parameters" method="post"><div>');
-
-    $Columns = '';
-    $Joins = '';
-
-  //řezení podle odkazu
-    if(array_key_exists('Order', $_GET)) $order = $_GET['Order'];
-    else  $order = 'T.TranslatedCount';
-    if(array_key_exists('Desc', $_GET)) $desc = $_GET['Desc']; 
-    else  $desc = '';
-    if($desc == '') $desc = 'DESC'; else $desc = '';
-    
-    foreach($TranslationTree as $Group)
-      if($Group['TablePrefix'] != '')
-      {
-      $Columns .= 'COALESCE(T'.$Group['Id'].'.Count, 0) + ';
-        $Joins .= ' LEFT JOIN (SELECT User, COUNT(User) as Count FROM `'.$Group['TablePrefix'].'` WHERE (Complete = 1) AND (Language <> 0) GROUP BY User) as T'.$Group['Id'].' ON user.ID=T'.$Group['Id'].'.User';
-      }
-    $Query = 'SELECT T.ID, T.TranslatedCount, T.user, T.XP FROM (SELECT user.ID, user.user, user.XP, ('.substr($Columns, 0, -3).') as TranslatedCount FROM `user`'.$Joins.') AS T WHERE T.TranslatedCount > 0 ORDER BY '.$order.' '.$desc;
-    $ID = $Database->SQLCommand($Query);
-
-  // Rebuild user order list
-  $Users = array();
-  while($Line = mysql_fetch_assoc($ID)) {
-     $Users[$Line['ID']] = $Line;
-     $UsersOrder[] = $Line['ID'];
-  }
-  //řazení podle posledního použitého
-  if(!array_key_exists('Order', $_GET)) {
-    $UsersOrder = explode(',', $ExportSetting['users-order']);
-    foreach($Users as $User)
-        if(!in_array($User['ID'], $UsersOrder)) $UsersOrder[] = $User['ID'];
-    foreach($UsersOrder as $Index => $UserId)
-        if(!array_key_exists($UserId, $Users)) unset($UsersOrder[$Index]);
-  }
-  $ExportSetting['users-order'] = implode(',', $UsersOrder);
-
-  if(array_key_exists('team', $_GET)) {
-    $ExportSetting['users-selection'] = array();
-    $Query = 'SELECT ID FROM user WHERE team = '.$_GET['team'];
-        $ID = $Database->SQLCommand($Query);
-        while($LineTeam = mysql_fetch_assoc($ID))
-      $ExportSetting['users-selection'][] = $LineTeam['ID'];
-  }
-
-
-  echo(' <input type="submit" value="Pokračovat" /> <span onclick="CheckAll()">'.CheckBox('CheckAll', False, 'CheckAll').' Zatrhnout vše</span> '); 
-  
-  echo('<table><tr><td>'.
-  '<table class="BaseTable" id="users-table"><tr>
-  <th><a href="?Order=user&amp;Desc='.$desc.'">Jméno</a></th>
-  <th><a href="?Order=T.TranslatedCount&amp;Desc='.$desc.'" title="Počet přeložených textů">Překladů</a></th>
-    <th><a href="?Order=XP&amp;Desc='.$desc.'">Úroveň</a></th>
-  <th></th></tr>');
-  //print_r($UsersOrder);    
-  // Show ordered user list  
-    foreach($UsersOrder as $UserId)
-    echo('<tr id="'.$UserId.'">
-    <td><a href="'.$Config['Web']['BaseURL'].'/TranslationList.php?user='.$UserId.'&amp;action=userall" title="Zobrazit všechny jeho přeložené texty">'.$Users[$UserId]['user'].'</a></td>
-    <td>'.$Users[$UserId]['TranslatedCount'].'</td>
-      <td><img src="'.$Config['Web']['TempFolder'].$Users[$UserId]['user'].'/level.png" alt="Úroveň uživatele" /></td>
-    <td>'.CheckBox('user_'.$UserId, in_array($UserId, $ExportSetting['users-selection']), '', 'CheckBox').'</td></tr>');
-    echo('</table></td><td class="Description">Zvolte ze seznamu uživatele, od kterých chcete načítat překlady a upravte jejich pořadí, takže od uživatelů výše budou brány překlady přednostně.<br />'.
-    'Řádky v tabulce můžete přesouvat metodou uchop a táhni.'.
-      '</td></tr></table>'.
-    '<div><input name="users-order" id="users-order" size="100" type="hidden" /><br />');
-  echo('<input type="submit" value="Pokračovat" /></div>');
-  echo('</div></form>');
-    break;
-}
-
-if(array_key_exists('UserID', $_SESSION) and ($_SESSION['UserID'] != ''))
-  $Database->SQLCommand('UPDATE user SET ExportSetting = "'.addslashes(serialize($ExportSetting)).'" WHERE ID='.$_SESSION['UserID']);
-  else $_SESSION['ExportSetting'] = serialize($ExportSetting);
-        
-//print_r($ExportSetting);
-
-ShowFooter();      
+  if(array_key_exists('ClientVersion', $_POST))
+  {
+    $Database->SQLCommand('UPDATE Export SET ClientVersion='.$_POST['ClientVersion'].' WHERE Id='.$_GET['ExportId']);
+  }
+
+  $DbResult = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+  $Export = mysql_fetch_assoc($DbResult);
+
+  $Query = 'SELECT wow_client_version.* FROM ExportVersion LEFT JOIN wow_client_version ON wow_client_version.Id=ExportVersion.ClientVersion WHERE ExportType='.$Export['OutputType'];
+
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$Query.') AS X');
+  $DbRow = mysql_fetch_row($DbResult);
+  $PageList = GetPageList($DbRow[0]);    
+  
+  $TableColumns = array(
+    array('Name' => 'Version', 'Title' => 'Verze'), 
+    array('Name' => 'BuildNumber', 'Title' => 'Sestavení'), 
+    array('Name' => 'ReleaseDate', 'Title' => 'Datum uvolnění'), 
+    array('Name' => 'Title', 'Title' => 'Titutek'), 
+    array('Name' => '', 'Title' => 'Výběr'),
+  );
+  $Order = GetOrderTableHeader($TableColumns, 'BuildNumber');
+  echo('<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">');
+  echo('<h3>Verze klienta</h3>');
+
+  echo('<input type="submit" value="Uložit výběr" '.$DisabledInput[$Editable].'/><br />
+   Vyberte pro jakou verzi herního klienta se budou texty exportovat.<br />');
+  echo($PageList['Output']);
+  echo('<table class="BaseTable">');
+  echo($Order['Output']);
+
+  $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
+  $DbResult = $Database->SQLCommand($Query);
+  while($Version = mysql_fetch_assoc($DbResult))
+  {
+    echo('<tr><td><a href="http://www.wowwiki.com/Patch_'.$Version['Version'].'">'.$Version['Version'].'</a></td><td>'.$Version['BuildNumber'].'</td><td>'.HumanDate($Version['ReleaseDate']).'</td><td>'.$Version['Title'].'</td><td>'.RadioButton('ClientVersion', $Version['Id'], $Export['ClientVersion'] == $Version['Id'], '', !$Editable
+    ).'</td></tr>');
+
+  }
+  echo('</table>');
+  echo('</form>');
+  echo($PageList['Output']);
+    } else echo('Položka nenalezena');
+  } else echo('Nebylo zadáno Id');
+}
+
+function ExportViewOutput()
+{
+  global $Database;
+  
+  $DbResult = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+  $Export = mysql_fetch_assoc($DbResult);
+  ExportOutput($Export['Id'], $Export['OutputType']);
+}
+
+function ExportView()
+{
+  global $Database;
+
+  $DbResult = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+  $Export = mysql_fetch_assoc($DbResult);
+  $DbResult = $Database->SQLCommand('SELECT * FROM user WHERE ID='.$Export['User']);
+  $User = mysql_fetch_assoc($DbResult);
+  echo('Export <strong><a href="?Action=View&amp;Tab=6&amp;ExportId='.$Export['Id'].'">'.$_GET['ExportId'].'</a></strong> překladatele <strong>'.$User['user'].'</strong> s označením <strong>'.$Export['Title'].'</strong>');
+  ShowTabs(array('Obecné', 'Překladatelé', 'Překlady', 'Jazyky', 'Formát', 'Verze', 'Výstup'));
+  echo('<div id="content">');
+  if($_SESSION['Tab'] == 0) ExportViewGeneral();
+  else if($_SESSION['Tab'] == 1) ExportViewTranslators();
+  else if($_SESSION['Tab'] == 2) ExportViewGroups();
+  else if($_SESSION['Tab'] == 3) ExportViewLanguages();
+  else if($_SESSION['Tab'] == 4) ExportViewOutputFormat();
+  else if($_SESSION['Tab'] == 5) ExportViewVersion();
+  else if($_SESSION['Tab'] == 6) ExportViewOutput();
+  
+  echo('</div>');
+}
+
+ShowPage();
+
+if(array_key_exists('Action', $_GET))
+{
+  if($_GET['Action'] == 'Create') ExportCreate();
+  else if($_GET['Action'] == 'CreateFinish') ExportCreateFinish();
+  else if($_GET['Action'] == 'View') ExportView();
+  else if($_GET['Action'] == 'Delete') ExportDelete();
+  else ExportList();
+} else ExportList();
+
+ShowFooter();
+
 ?>

trunk/includes/error.php

@@ -37 +37 @@
     {
       //print_r($Item);
-      if(array_key_exists('line', $Item))
-        $Error .= ' '.$Item['file'].'('.$Item['line'].")\t".$Item['function'];
-      else $Error .= ' '.$Item['file']."\t".$Item['function'];
+      if(!array_key_exists('line', $Item)) $Item['line'] = '';
+      if(!array_key_exists('file', $Item)) $Item['file'] = '';
+      if(!array_key_exists('function', $Item)) $Item['function'] = '';
+      $Error .= ' '.$Item['file'].'('.$Item['line'].")\t".$Item['function'];
       $Arguments = '';
       if(array_key_exists('args', $Item) and is_array($Item['args']))

trunk/includes/global.php

@@ -19 +19 @@
 include('global_function.php');
 include('rss.php');
+include_once('system.php');
 
 $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
@@ -26 +27 @@
 $TranslationTree = GetTranslationTree();
 $LanguageList = GetLanguageList();
+
+$System = new System();
+$System->Init();
 
 function GetMicrotime()
@@ -96 +100 @@
     $Config['Web']['BaseURL'].'index.php' => array(LICENCE_ANONYMOUS, 'Hlavní stránka', 'Domů'),
     'http://wow.zdechov.net/forum/viewforum.php?f=22' => array(LICENCE_ANONYMOUS, 'Diskuze na téma překládání', 'Fórum projektu'),
-    $Config['Web']['BaseURL'].'dictionary.php' => array(LICENCE_ANONYMOUS, 'Slovník WoW výrazů', 'Slovník'),
-    $Config['Web']['BaseURL'].'banners.php' => array(LICENCE_ANONYMOUS, 'Weby odkazující na tento projekt bennerem', 'Odkazují na nás'),
+    $Config['Web']['BaseURL'].'dictionary.php' => array(LICENCE_ANONYMOUS, 'Slovník WoW výrazů', 'Slovníček'),
     $Config['Web']['BaseURL'].'statistic.php' => array(LICENCE_ANONYMOUS, 'Stav dokončení překládů', 'Stav dokončení'),
     $Config['Web']['BaseURL'].'userlist.php?action=nofilter' => array(LICENCE_ANONYMOUS, 'Seznam registrovaných uživatelů', 'Překladatelé'),
     $Config['Web']['BaseURL'].'team.php?search=' => array(LICENCE_ANONYMOUS, 'Seznam překladatelských týmů', 'Týmy'),
-    $Config['Web']['BaseURL'].'download.php' => array(LICENCE_ANONYMOUS, 'Zde si můžete stáhnout přeložené texty', 'Stahování'),
+    $Config['Web']['BaseURL'].'export/' => array(LICENCE_ANONYMOUS, 'Zde si můžete stáhnout přeložené texty', 'Exporty'),
+    $Config['Web']['BaseURL'].'download.php' => array(LICENCE_ANONYMOUS, 'Stahování různých pomocných souborů a programů', 'Soubory'),
     $Config['Web']['BaseURL'].'info.php' => array(LICENCE_ANONYMOUS, 'Informace k překladu hry', 'Informace'),
     $Config['Web']['BaseURL'].'registrace.php' => array(LICENCE_ANONYMOUS, 'Registrace uživatele pro překládání', 'Registrace'),
     $Config['Web']['BaseURL'].'TranslationList.php?action=grouplist' => array(LICENCE_ANONYMOUS, 'Informace o překladových skupinách', 'Zdroje dat'), 
+    $Config['Web']['BaseURL'].'banners.php' => array(LICENCE_ANONYMOUS, 'Informace k propagaci tohoto projektu', 'Propagace'),
     $Config['Web']['BaseURL'].'version.php' => array(LICENCE_ANONYMOUS, 'Seznam verzí herního klienta', 'Verze hry'), 
     $Config['Web']['BaseURL'].'aowow' => array(LICENCE_ANONYMOUS, 'Vyhledávací databáze podobná WoWHead s překlady', 'AoWoW'), 
@@ -175 +180 @@
     if(Licence(LICENCE_MODERATOR)) $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['user'].'</a>';
     else $Name = $Line['user'];
-    if($Line['GM'] <> 0) $TextGM = '<small>('.$Moderators[$Line['GM']].')</small>';
-    else $TextGM = '';
+    //if($Line['GM'] <> 0) $TextGM = '<small>('.$Moderators[$Line['GM']].')</small>';
+    //else 
+    $TextGM = '';
     echo('<strong>'.$Name.'</strong>'.$TextGM.'<br />');
   }

trunk/includes/global_function.php

@@ -62 +62 @@
     if($PagesMin < ($CurrentPage - $Around))
     {
-      $Result.= ' .. ';
+      $Result.= ' ... ';
       $PagesMin = $CurrentPage - $Around;
     }
@@ -73 +73 @@
       }
     } 
-    if($PagesMax < ($PageCount - 1)) $Result .= ' .. ';
+    if($PagesMax < ($PageCount - 1)) $Result .= ' ... ';
     if($CurrentPage < ($PageCount - 1)) 
     {
@@ -374 +374 @@
 }
 
-
 function GetBuildNumber($Version)
 {
@@ -459 +458 @@
 }
 
+function LoadCommandLineParameters()
+{
+  if(!array_key_exists('REMOTE_ADDR', $_SERVER))
+  {
+    foreach($_SERVER['argv'] as $Parameter)
+    {
+      if(strpos($Parameter, '=') !== false)
+      {
+        $Index = substr($Parameter, 0, strpos($Parameter, '='));
+        $Parameter = substr($Parameter, strpos($Parameter, '=') + 1);
+        //echo($Index.'  ----  '.$Parameter);
+        $_GET[$Index] = $Parameter;
+      }
+    } 
+  }
+}
+
+function ShowTabs($Tabs)
+{
+  $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']);
+  
+  if(array_key_exists('Tab', $_GET)) $_SESSION['Tab'] = $_GET['Tab'];
+  if(!array_key_exists('Tab', $_SESSION)) $_SESSION['Tab'] = 0;
+  if(($_SESSION['Tab'] < 0) or ($_SESSION['Tab'] > (count($Tabs) - 1))) $_SESSION['Tab'] = 0;
+  echo('<div id="header">');
+  echo('<ul>');
+  foreach($Tabs as $Index => $Tab)
+  {
+    $QueryItems['Tab'] = $Index;
+    if($Index == $_SESSION['Tab']) $Selected = ' id="selected"'; 
+      else $Selected = '';
+    echo('<li'.$Selected.'><a href="?'.SetQueryStringArray($QueryItems).'">'.$Tab.'</a></li>');
+  }
+  echo('</ul></div>');
+}
+
+function CheckBox($Name, $Checked = false, $Id = '', $Class = '', $Disabled = false)
+{
+  if($Id) $Id = ' id="'.$Id.'"'; else $Id = '';
+  if($Class) $Class = ' class="'.$Class.'"'; else $Class = '';
+  if($Checked) $Checked = ' checked="checked"'; else $Checked = '';
+  if($Disabled) $Disabled = ' disabled="disabled"'; else $Disabled = '';
+  return('<input type="checkbox" value="checked" name="'.$Name.'"'.$Checked.$Disabled.$Id.$Class.' />');
+}
+
+function RadioButton($Name, $Value, $Checked = false, $OnClick = '', $Disabled = false)
+{
+  if($Checked) $Checked = ' checked="checked"'; else $Checked = '';
+  if($OnClick != '') $OnClick = ' onclick="'.$OnClick.'"'; else $OnClick = '';
+  if($Disabled) $Disabled = ' disabled="disabled"'; else $Disabled = '';
+  return('<input type="radio" name="'.$Name.'" value="'.$Value.'"'.$Checked.$Disabled.$OnClick.'/>');
+}
+
+function SelectOption($Name, $Text, $Selected = false)
+{
+  if($Selected) $Selected = ' selected="selected"'; else $Selected = '';
+  return('<option value="'.$Name.'"'.$Selected.'>'.$Text.'</option>');
+}
+
+
 ?>

trunk/index.php

@@ -116 +116 @@
   );
   ShowPage();
-  $Banner = '<a href="'.$Config['Web']['BaseURL'].'"><img src="'.$Config['Web']['BaseURL'].'banners/baner_468_60.jpg" '.
-    'alt="baner_'.$Config['Web']['BaseURL'].'" title="Otevřený projekt překládání celé hry World of Warcraft" '.
-    'class="banner" height="60" width="468" /></a>';
-  
-  $BannerSmall = '<a href="'.$Config['Web']['BaseURL'].'"><img src="'.$Config['Web']['BaseURL'].'banners/baner_88_31.jpg" '.
-    'alt="baner_'.$Config['Web']['BaseURL'].'" title="Otevřený projekt překládání celé hry World of Warcraft" '.
-    'class="banner" height="31" width="88" /></a>';
-  
-  echo('<strong>Bannery:</strong><br />');
-  
-  echo($Banner.' &nbsp;&nbsp;<textarea rows="2" cols="30">'.htmlspecialchars($Banner).'</textarea><br />');
-  echo($BannerSmall.' &nbsp;&nbsp;<textarea rows="2" cols="30">'.htmlspecialchars($BannerSmall).'</textarea><br />');
   
   echo('<br />'.  

trunk/style/style.css

@@ -3 +3 @@
   font-size: 14px;
   font-family: Verdana, Arial, SunSans-Regular, Sans-Serif;
-  color: #564b47;
+  color: #362b27;
   padding: 0px;
   margin: 0px;
@@ -21 +21 @@
 a:visited
 {
-  color:#c43300;
+  color: #c43300;
 }
 
 a:hover
 {
-  color: #c43300;
+  color: #c3300;
 }
 
@@ -345 +345 @@
   text-align: center;
 }
+
+#header ul 
+{
+  list-style: none;
+  padding: 0;
+  margin: 0;
+}
+    
+#header li 
+{
+  float: left;
+  border: 1px solid #bbb;
+  border-bottom-width: 0;
+  margin: 0;
+}
+    
+#header a 
+{
+  text-decoration: none;
+  display: block;
+  background: #eee;
+  padding: 0.24em 1em;
+  color: #c00;
+  text-align: center;
+}
+  
+#header a:hover 
+{
+  background: #fdd;
+}
+  
+#header #selected 
+{
+  border-color: black;
+}
+  
+#header #selected a 
+{
+  position: relative;
+  top: 1px;
+  background: white;
+  color: black;
+  font-weight: bold;
+}
+  
+#content 
+{
+  border: 1px solid black;
+  clear: both;
+  padding: 5px;
+}
+    

trunk/user.php

@@ -25 +25 @@
   
 if(array_key_exists('user', $_GET) and Licence(LICENCE_MODERATOR)) 
-{
-  
+{  
   $Query = 'SELECT *, (';
   foreach($TranslationTree as $Group)
     if($Group['TablePrefix'] != '')
-          $Query .= '(SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE User = '.$_GET['user'].' AND User <> 0 AND Complete = 1) + ';
+    $Query .= '(SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE User = '.$_GET['user'].' AND User <> 0 AND Complete = 1) + ';
   $Query .= '0) as NumberTranslate FROM `user` WHERE ID = '.$_GET['user'];
   $LineUser = mysql_fetch_array($Database->SQLCommand($Query));
@@ -36 +35 @@
   echo('ID: <strong>'.$_GET['user'].'</strong><br />');
   echo('Jméno: <strong>'.$LineUser['user'].'</strong><br />');
-  echo('Výchozí jazyk: <strong>'.$LineUser['Language'].'</strong><br />');
+  echo('Výchozí jazyk: <strong>'.$LanguageList[$LineUser['Language']]['Name'].'</strong><br />');
   echo('Poslední připojení: <strong>'.$LineUser['LastLogin'].'</strong><br />');
   echo('Poslední IP: <strong>'.$LineUser['LastIP'].'</strong><br />');