Changeset 816 for trunk/Modules/Export

Timestamp:

Feb 22, 2015, 11:20:50 PM (10 years ago)

Author:

chronos

Message:

• Modified: Tabs converted to spaces.
• Modified: Remove spaces from end of lines.
• Added: Code format script.

Location:

trunk/Modules/Export

Files:

• CreateAddon.php (modified) (15 diffs)
• Export.php (modified) (40 diffs)
• ExportOutput.php (modified) (26 diffs)
• Page.php (modified) (4 diffs)
• ProcessAoWoWExport.php (modified) (3 diffs)
• ProcessTask.php (modified) (1 diff)
• Progress.php (modified) (3 diffs)
• cmdmpqexport.php (modified) (13 diffs)

trunk/Modules/Export/CreateAddon.php

@@ -5 +5 @@
 class ExportAddon extends Export
 {
-  
+
   // Replace special codes by lua functions
   function ReplaceVarInText($string, $strlower = 'strlower')
   {
-    
+
     $string = str_replace('$N', '"..'.$strlower.'(UnitName("player")).."', $string);
     $string = str_replace('$n', '"..'.$strlower.'(UnitName("player")).."', $string);
@@ -17 +17 @@
     $string = str_replace('$r', '"..'.$strlower.'(UnitRace("player")).."', $string);
     $Gender = '$G';
-    while(strpos($string, $Gender) !== false) 
+    while(strpos($string, $Gender) !== false)
     {
       $Before = substr($string, 0, strpos($string, $Gender));
@@ -28 +28 @@
       $Woman = str_replace(' ', '', $Woman);
       $string = $Before.'"..gsub(gsub(UnitSex("player"), "^2$", "'.$Man.'"), "^3$", "'.$Woman.'").."'.$After;
-    } 
+    }
     $Gender = '$g';
-    while(strpos($string, $Gender) !== false) 
+    while(strpos($string, $Gender) !== false)
     {
       $Before = substr($string, 0, strpos($string, $Gender));
@@ -41 +41 @@
       $Woman = str_replace(' ', '', $Woman);
       $string = $Before.'"..gsub(gsub(UnitSex("player"), "^2$", "'.$Man.'"),"^3$", "'.$Woman.'").."'.$After;
-    } 
+    }
 
     $string = str_replace('$', '', $string);
     $string = str_replace("\r", '', $string);
     $string = str_replace("\n", '\r\n', $string);
-    return($string);    
+    return($string);
   }
 
@@ -53 +53 @@
     //  $string = mysql_escape_string($string);
     $string = strtolower($string);
-  
+
     $string = str_replace('"', '\"', $string);
-    $string = str_replace('$b$b', ' ', $string);  
-    $string = str_replace('$b $b', ' ', $string);   
-    $string = str_replace('$b', ' ', $string);  
-    $string = $this->ReplaceVarInText($string);  
+    $string = str_replace('$b$b', ' ', $string);
+    $string = str_replace('$b $b', ' ', $string);
+    $string = str_replace('$b', ' ', $string);
+    $string = $this->ReplaceVarInText($string);
     $string = str_replace("\r", ' ', $string);
     $string = str_replace("\n", ' ', $string);
@@ -64 +64 @@
     $string = str_replace('\\n', ' ', $string);
     $string = str_replace(' ', '', $string);
-//    while(strpos($string, '  ')) 
+//    while(strpos($string, '  '))
 //      $string = str_replace('  ', ' ', $string);
     return($string);
@@ -73 +73 @@
     $string = $this->Database->real_escape_string($string);
     $string = str_replace('$B', '\r\n', $string);
-    $string = str_replace('$b', '\r\n', $string); 
+    $string = str_replace('$b', '\r\n', $string);
     $string = $this->ReplaceVarInText($string,'');
     return($string);
@@ -104 +104 @@
   {
     global $TranslationTree, $CreatedFileList;
-   
+
     $Output = '';
     $this->LoadFilters();
-    
+
     $CreatedFileList = array();
     $CreatedFileListCount = array();
-    
+
     if(!file_exists($this->TempDir.'CzWoW/')) mkdir($this->TempDir.'CzWoW/', 0777, true);
-  
+
     $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `Group`.`TablePrefix` != ""');
     while($Group = $DbResult->fetch_assoc())
     {
     //získání čísla verze pro export
-      $ID = $this->Database->query('SELECT LastVersion FROM `Group` WHERE Id = '.$Group['Id']); 
+      $ID = $this->Database->query('SELECT LastVersion FROM `Group` WHERE Id = '.$Group['Id']);
       $LastVersion = $ID->fetch_assoc();
-      
+
       if ($LastVersion['LastVersion'] < $this->ClientVersion['BuildNumber'])
         $ExportVersion = $LastVersion['LastVersion'];
@@ -125 +125 @@
 
       foreach($TranslationTree[$Group['Id']]['Items'] as $Column)
-      if($Column['AddonFileName'] != '')  
+      if($Column['AddonFileName'] != '')
       {
         $this->AddProgress(1);
-        if(!isset($CreatedFileListCount[$Column['AddonFileName']])) 
+        if(!isset($CreatedFileListCount[$Column['AddonFileName']]))
         $CreatedFileListCount[$Column['AddonFileName']] = 0;
         $CreatedFileListCount[$Column['AddonFileName']]++;
         $FileIndex = $CreatedFileListCount[$Column['AddonFileName']];
-    
+
         $CreatedFileList[] = $Column['AddonFileName'].'_'.$FileIndex;
-        $FileName = $this->TempDir.'CzWoW/'.$Column['AddonFileName'].'_'.$FileIndex.'.lua';        
+        $FileName = $this->TempDir.'CzWoW/'.$Column['AddonFileName'].'_'.$FileIndex.'.lua';
         $Output .= $Column['AddonFileName'].': ';
         $i = 0;
@@ -140 +140 @@
         $Buffer = 'CZWOW_'.$Column['AddonFileName'].'_count='.$FileIndex.';CZWOW_'.$Column['AddonFileName'].'_'.$FileIndex.'={';
         $TableTexts = array();
-    
+
         //old version
         //get version before
@@ -146 +146 @@
         if ($ExportVersion == '') $BuildNumber = $this->ClientVersion['BuildNumber'];
         $ID = $this->Database->query('SELECT `BuildNumber` FROM `ClientVersion` WHERE '.
-        ' `Imported` = 1 AND `BuildNumber` < '.$BuildNumber.' ORDER BY  `BuildNumber` DESC LIMIT 1');  
-        if($ID->num_rows > 0) {        
+        ' `Imported` = 1 AND `BuildNumber` < '.$BuildNumber.' ORDER BY  `BuildNumber` DESC LIMIT 1');
+        if($ID->num_rows > 0) {
           $ExportVersionOld = $ID->fetch_assoc();
           $ExportVersionOld = $ExportVersionOld['BuildNumber'];
-        
-          $DbResult2 = $this->Database->query($this->BuildQuery($Group,$ExportVersionOld));        
-          while($Line = $DbResult2->fetch_assoc()) 
+
+          $DbResult2 = $this->Database->query($this->BuildQuery($Group,$ExportVersionOld));
+          while($Line = $DbResult2->fetch_assoc())
           {
-            $en = trim($this->ReplaceEnText($Line['En'.$Column['Column']]));  
+            $en = trim($this->ReplaceEnText($Line['En'.$Column['Column']]));
             $cz = $this->ReplaceCzText($Line[$Column['Column']]);
-            if(($en <> '') and ($cz <> '') and ($this->NotCancel($en))) 
+            if(($en <> '') and ($cz <> '') and ($this->NotCancel($en)))
             {
-               $TableTexts[$en] = $cz; 
+               $TableTexts[$en] = $cz;
             }
           }
         }
                 //last version
-       
-        $DbResult2 = $this->Database->query($this->BuildQuery($Group,$ExportVersion));        
-        while($Line = $DbResult2->fetch_assoc()) 
+
+        $DbResult2 = $this->Database->query($this->BuildQuery($Group,$ExportVersion));
+        while($Line = $DbResult2->fetch_assoc())
         {
-          $en = trim($this->ReplaceEnText($Line['En'.$Column['Column']]));  
+          $en = trim($this->ReplaceEnText($Line['En'.$Column['Column']]));
           $cz = $this->ReplaceCzText($Line[$Column['Column']]);
-          if(($en <> '') and ($cz <> '') and ($this->NotCancel($en))) 
+          if(($en <> '') and ($cz <> '') and ($this->NotCancel($en)))
           {
-             $TableTexts[$en] = $cz; 
+             $TableTexts[$en] = $cz;
           }
         }
-        
+
         foreach($TableTexts as $key => $value) {
             $Buffer .= "\n".'["'.$key.'"]="'.$value.'",';
             $i++;
         }
-        
-    
+
+
         $Buffer = $Buffer."\n};if not CZWOW_".$Column['AddonFileName']." then CZWOW_".$Column['AddonFileName']."=0; end; CZWOW_".$Column['AddonFileName']."=CZWOW_".$Column['AddonFileName']."+".$i.";\n";
 
@@ -193 +193 @@
     $Buffer = '';
     foreach($CreatedFileList as $CreatedFile)
-      $Buffer .= 'CZWOW_'.str_replace('_','_count=',$CreatedFile).';'."\n"; 
+      $Buffer .= 'CZWOW_'.str_replace('_','_count=',$CreatedFile).';'."\n";
     foreach($TranslationTree as $Group)
       foreach($TranslationTree[$Group['Id']]['Items'] as $Column)
-      if (($Column['AddonFileName'] != '') and (!in_array($Column['AddonFileName'].'_1', $CreatedFileList))) 
+      if (($Column['AddonFileName'] != '') and (!in_array($Column['AddonFileName'].'_1', $CreatedFileList)))
       {
-        $Buffer .= 'CZWOW_'.$Column['AddonFileName'].'_count=0;'."\n"; 
-    }
-    
+        $Buffer .= 'CZWOW_'.$Column['AddonFileName'].'_count=0;'."\n";
+    }
+
     file_put_contents($this->TempDir.'CzWoW/'.$CountFiles, $Buffer);
-  
-  
+
+
     // Generate file Translates.xml
     $Buffer = '<Ui xmlns="http://www.blizzard.com/wow/ui/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.blizzard.com/wow/ui/.\FrameXML\UI.xsd">'."\n";
@@ -218 +218 @@
   {
     global $TranslationTree;
-  
+
     $this->LoadFilters();
-  
+
     $Buffer = "local f=function(name, en, cz) CzWoW_interface[name]=cz;CzWoW_interface_entoname[en]=name; end; CzWoW_interface={};CzWoW_interface_entoname={ };\n";
     $Group = $TranslationTree[14]; // client table
     $Column['Column'] = 'Text';
-    
+
     $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `Group`.`TablePrefix` != "" AND `Group`.`Id` = 14');
     //$Group = $DbResult->fetch_assoc();
@@ -231 +231 @@
     else
       $CanGenerated = '';
-    
+
     $DbResult = $this->Database->query($this->BuildQuery($Group,$CanGenerated));
-    while($Line = $DbResult->fetch_array()) 
+    while($Line = $DbResult->fetch_array())
     {
       $Original = $this->my_trim($Line['En'.$Column['Column']]);
       $Translated = $this->my_trim($Line[$Column['Column']]);
-      if($this->ClientVersion['Version'] == '2.4.3') 
+      if($this->ClientVersion['Version'] == '2.4.3')
       {
         $Original = str_replace("|Hchannel:%d|h[%s]|h", '[%s]', $Original);
@@ -265 +265 @@
     $Buffer = '
  Čeština pro klienty:
-  Vytvořeno v projektu http://wowpreklad.zdechov.net/ 
+  Vytvořeno v projektu http://wowpreklad.zdechov.net/
   Obsahuje Fonty pro správné zobrazování českých znaků, WoW addon překládající
 texty
-  
+
  Instalace:
   Soubory rozbalte/zkopírujte do kořenové složky s hrou. Obvikle bývá
 "C:/Program Files/World of Warcraft/".
-  
+
  Verze:
-  Verze Addonu: '.$Line['Version'].' 
+  Verze Addonu: '.$Line['Version'].'
   Tato verze je pro verzi hry '.$this->ClientVersion['Version'].'
-  
+
  Změny ve verzích:
-  
+
     ';
     $DbResult = $System->Database->query('SELECT * FROM `CzWoWPackageVersion` ORDER BY `Date` DESC');
-    while($Line = $DbResult->fetch_assoc()) 
+    while($Line = $DbResult->fetch_assoc())
     {
       $Buffer .='
-  Verze: '.$Line['Version'].' 
+  Verze: '.$Line['Version'].'
   =============
   '.$Line['text'].'
-  
+
   ';
     }

trunk/Modules/Export/Export.php

@@ -13 +13 @@
   var $TempDir;
   var $SourceDir;
-  
+
   function Init()
   {
@@ -23 +23 @@
     if(!file_exists($this->SourceDir)) mkdir($this->SourceDir, 0777, true);
   }
-  
+
   function SaveAllUsers() {
-                $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$this->Id);
-                $Export = $DbResult->fetch_assoc();
-                if ($Export['AllUsers']) {
-                        $DbResult2 = $this->System->Database->query('SELECT ID FROM `User` WHERE `ID` NOT IN(SELECT `User` FROM `ExportUser` WHERE `Export`='.$this->Id.')');
-                        while($UserLine = $DbResult2->fetch_assoc())
-                        {
-                                                $Condition = ' WHERE `Export`='.$this->Id.' AND `User`='.$UserLine['ID'];
-                                                $DbResult = $this->System->Database->query('SELECT * FROM `ExportUser` '.$Condition); //,MAX(`Sequence`) as MaxSequence
-                                                if($DbResult->num_rows > 0)
-                                                {
-                                                //      $this->System->Database->query('UPDATE `ExportUser` SET `Sequence`='.$Value.$Condition);
-                                                } else
-                                                {
+    $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$this->Id);
+    $Export = $DbResult->fetch_assoc();
+    if ($Export['AllUsers']) {
+      $DbResult2 = $this->System->Database->query('SELECT ID FROM `User` WHERE `ID` NOT IN(SELECT `User` FROM `ExportUser` WHERE `Export`='.$this->Id.')');
+      while($UserLine = $DbResult2->fetch_assoc())
+      {
+            $Condition = ' WHERE `Export`='.$this->Id.' AND `User`='.$UserLine['ID'];
+            $DbResult = $this->System->Database->query('SELECT * FROM `ExportUser` '.$Condition); //,MAX(`Sequence`) as MaxSequence
+            if($DbResult->num_rows > 0)
+            {
+            //  $this->System->Database->query('UPDATE `ExportUser` SET `Sequence`='.$Value.$Condition);
+            } else
+            {
               $this->System->Database->query('INSERT INTO `ExportUser` (`Export`, `User`, `Sequence`) VALUES ('.$this->Id.', '.$UserLine['ID'].', 0)');
-                                                }
-                        }
-                        
+            }
+      }
+
       $this->System->Database->query('SET @I = 0');
-                        $this->System->Database->query('UPDATE `ExportUser` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$this->Id.' ORDER BY `Sequence`;');
-                }
-  }
-  
+      $this->System->Database->query('UPDATE `ExportUser` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$this->Id.' ORDER BY `Sequence`;');
+    }
+  }
+
   function LoadFilters()
-  {  
+  {
     $DbResult = $this->Database->query('SELECT * FROM `Export` WHERE `Id`='.$this->Id);
     if($DbResult->num_rows == 0) throw new Exception('Export '.$this->Id.' neexistuje');
-    $this->Export = $DbResult->fetch_assoc();   
+    $this->Export = $DbResult->fetch_assoc();
 
     // Filter selected users
     $this->UserNames = '';
     $DbResult = $this->Database->query('SELECT `ExportUser`.*, `User`.`Name`, `User`.`ID` FROM `ExportUser` '.
-        'LEFT JOIN `User` ON `User`.`ID`=`ExportUser`.`User` '.
-        'WHERE `ExportUser`.`Export`='.$this->Id.' ORDER BY `ExportUser`.`Sequence`');
+      'LEFT JOIN `User` ON `User`.`ID`=`ExportUser`.`User` '.
+      'WHERE `ExportUser`.`Export`='.$this->Id.' ORDER BY `ExportUser`.`Sequence`');
     while($UserLine = $DbResult->fetch_assoc())
     {
       $this->UserNames .= ', '.$UserLine['Name'];
     }
-    $this->UserNames = substr($this->UserNames, 2);      
-   
+    $this->UserNames = substr($this->UserNames, 2);
+
     if($this->Export['ClientVersion'] != '')
     {
       $DbResult = $this->Database->query('SELECT * FROM `ClientVersion` WHERE `Id`='.$this->Export['ClientVersion']);
       $this->ClientVersion = $DbResult->fetch_assoc();
-    } else $this->ClientVersion = '';    
-  }
-  
+    } else $this->ClientVersion = '';
+  }
+
   function BuildQuery($Group, $Version = '')
   {
     global $TranslationTree;
     $this->SaveAllUsers();
-    
-    if ($Version <> '') 
+
+    if ($Version <> '')
       $ExportVersion = $Version;
     else
       $ExportVersion = $this->ClientVersion['BuildNumber'];
 
-          $DbResultItem = $this->System->Database->query('SELECT * FROM `ExportGroupItem` WHERE `Export`='.$this->Id);
-                while($GroupItem = $DbResultItem->fetch_assoc())
-                {
-                  $GroupItems[$GroupItem['GroupItem']] = 1;
+    $DbResultItem = $this->System->Database->query('SELECT * FROM `ExportGroupItem` WHERE `Export`='.$this->Id);
+    while($GroupItem = $DbResultItem->fetch_assoc())
+    {
+      $GroupItems[$GroupItem['GroupItem']] = 1;
     }
     // Build selected columns
@@ -93 +93 @@
   //  $Columns = substr($Columns, 0, -2);
 
-    
+
     $Query = 'SELECT * FROM (SELECT '.$Columns.' T.`ID`,T.`Language`,T.`User`,T.`Entry`,T.`VersionEnd`,T.`VersionStart`, `User`.`Name` AS `UserName` FROM `'.$Group['TablePrefix'].'` AS `T`'.
     ' JOIN `ExportUser` ON (`ExportUser`.`User`=`T`.`User`) AND (`ExportUser`.`Export`='.$this->Id.') '.
@@ -105 +105 @@
     foreach($TranslationTree[$Group['Id']]['Items'] as $Column) {
       $OriginalColumns .= ' `T3`.`'.$Column['Column'].'` AS `En'.$Column['Column'].'`, ';
-      if (isset($GroupItems[$Column['Id']])) 
+      if (isset($GroupItems[$Column['Id']]))
         $OriginalColumns .= ' `T3`.`'.$Column['Column'].'` AS `'.$Column['Column'].'`, ';
     }
     $OriginalColumns = substr($OriginalColumns, 0, -2);
-    
+
     // Expand query for loading english texts
     $Query = 'SELECT `T4`.*, '.$OriginalColumns.' FROM ('.$Query.') AS `T4` '.
     ' LEFT JOIN `'.$Group['TablePrefix'].'` AS `T3` ON (`T3`.`Entry` = `T4`.`Entry`) '.
     'AND (`T3`.`Language` = '.$this->System->Config['OriginalLanguage'].') AND '.
-    '(`T3`.`VersionStart` = `T4`.`VersionStart`) AND (`T3`.`VersionEnd` = `T4`.`VersionEnd`)';  
+    '(`T3`.`VersionStart` = `T4`.`VersionStart`) AND (`T3`.`VersionEnd` = `T4`.`VersionEnd`)';
 
     return($Query);
   }
-  
+
   function NeedGeneration()
   {
@@ -130 +130 @@
     else return(true);
   // echo $file;
-    
+
     $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` '.
-        'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
-    $result = false;         
+      'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
+    $result = false;
     while($Group = $DbResult->fetch_assoc())
     {
@@ -146 +146 @@
         if ($DbResult2->num_rows > 0) {
           $result = true;
-        }  
-    }  
+        }
+    }
     return($result);
   }
-  
+
   function ExportToMangosSQL()
   {
     global $TranslationTree;
-  
+
     $this->LoadFilters();
-    
-    $Buffer = 
-      "-- Generováno projektem wowpreklad.zdechov.net\n". 
+
+    $Buffer =
+      "-- Generováno projektem wowpreklad.zdechov.net\n".
       "-- ===========================================\n".
       "--\n".
@@ -168 +168 @@
       "-- 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);
+      'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
     while($Group = $DbResult->fetch_assoc())
     {
       $Buffer .= $Group['TablePrefix'].', ';
     }
-    $Buffer .= "\n\n";  
+    $Buffer .= "\n\n";
 
     $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` '.
-        'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
+      'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
     while($Group = $DbResult->fetch_assoc())
     {
@@ -186 +186 @@
         $DbResult2 = $this->Database->query($this->BuildQuery($Group));
         if($DbResult2->num_rows > 0)
-        while($Line = $DbResult2->fetch_array()) 
+        while($Line = $DbResult2->fetch_array())
         {
           $Values = '';
@@ -199 +199 @@
           // Get multicolumn index
           $ColumnItems = explode(',', $Group['MangosTableIndex']);
-          if(count($ColumnItems) > 1) 
+          if(count($ColumnItems) > 1)
           {
             $Where = 'CONCAT(';
@@ -206 +206 @@
             $Where = substr($Where, 0, -7).')';
           } else $Where = '`'.$Group['MangosTableIndex'].'`';
-          $Where .= ' = "'.$Line[$Group['PrimaryKeyItem']].'";'; 
-          
+          $Where .= ' = "'.$Line[$Group['PrimaryKeyItem']].'";';
+
           $Line = 'UPDATE `'.$Group['MangosTable'].'` SET '.$Values.' WHERE '.$Where;
           $Line = str_replace("\n", '\n', $Line);
           $Line = str_replace("\r", '', $Line);
           $Buffer .= $Line."\n";
-        }     
+        }
       }
     }
@@ -218 +218 @@
     return($Buffer);
   }
-  
-  function ExportToAoWoWSQL() 
+
+  function ExportToAoWoWSQL()
   {
     global $TranslationTree, $AoWoWconf;
-  
+
     //require_once('../aowow/configs/config.php');
-  
+
     $Buffer = $this->ExportToMangosSQL();
-  
+
     /*
     // 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']);    
+    $Database2->select_db($AoWoWconf['mangos']['db']);
     $AoWoWTables = array(
-      'aowow_resistances' => 'Id', 
-      'aowow_spelldispeltype' => 'Id', 
+      'aowow_resistances' => 'Id',
+      'aowow_spelldispeltype' => 'Id',
       'aowow_skill' => 'skillID',
     );
-    foreach($AoWoWTables as $AoWoWTable => $IndexColum) 
+    foreach($AoWoWTables as $AoWoWTable => $IndexColum)
     {
       $Buffer .= '--'.$AoWoWTable.', ';
-      $Buffer .= "\n\n";  
+      $Buffer .= "\n\n";
       $Query = 'SELECT `name`,`'.$IndexColum.'` FROM `'.$AoWoWTable.'`';
       $DbResult = $Database2->query($Query);
-      while($Line = $DbResult->fetch_assoc()) 
+      while($Line = $DbResult->fetch_assoc())
       {
         $Ori_text = $Line['name'];
@@ -253 +253 @@
         $Tran = $DbResult2->fetch_assoc();
         //echo ($Line['name'].'='.$Tran['tran']);
-        if($Tran['Tran'] == '') 
+        if($Tran['Tran'] == '')
         {
           $DbResult2 = $Database2->query('SELECT `OptionText` AS `En`,
@@ -263 +263 @@
           $Tran = $DbResult2->fetch_assoc();
         }
-        
+
         if($Tran['Tran'] <> '')
           $Buffer .= 'UPDATE `'.$AoWoWTable.'` SET `name` = "'.addslashes($Tran['Tran']).'" WHERE '.$IndexColum.' = '.$Line[$IndexColum].' ;'."\n";
       }
-      $Buffer .= "\n\n";  
+      $Buffer .= "\n\n";
     }
     */
     if($this->Export['WithDiacritic'] != 1) $Buffer = utf2ascii($Buffer);
     return($Buffer);
-  }  
-  
-  function HaveVarible($String1, $String2, $StartChar = '$') 
+  }
+
+  function HaveVarible($String1, $String2, $StartChar = '$')
   {
           //Export only if translate have same varible %
-    
+
     if (strpos($String1,$StartChar) !== false) {
-    
+
       while ( strpos($String1,$StartChar) !== false) {
           $pos = strpos($String1,$StartChar);
@@ -291 +291 @@
        //   echo $pos.'-'.$varible.'-'.$String1.'-' .$String2.'
         //  ';
-     
+
           if (false === strpos($String2,$varible)) {
-              //  echo $varible; 
+              //  echo $varible;
             return(false);
           }
@@ -299 +299 @@
     }
     return (true);
-  }  
+  }
 
   function AddProgress($add = 1) {
@@ -312 +312 @@
   {
     global $TranslationTree;
-  
+
     $this->LoadFilters();
-        
+
     $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` '.
-        'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` '.
-        'WHERE `ExportGroup`.`Export`='.$this->Id.' AND `Group`.`DBCFileName` != ""');
+      'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` '.
+      'WHERE `ExportGroup`.`Export`='.$this->Id.' AND `Group`.`DBCFileName` != ""');
     $Output = 'Počet generovaných skupin: '.$DbResult->num_rows."\n";
     while($Group = $DbResult->fetch_assoc())
@@ -323 +323 @@
       $this->AddProgress(2);
       $Output .= $Group['Name'].', ';
-      if(file_exists($this->SourceDir.$this->ClientVersion['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc')) 
+      if(file_exists($this->SourceDir.$this->ClientVersion['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc'))
       {
         // Load string column index list
         $DbResult2 = $this->Database->query('SELECT * FROM `GroupItem` '.
-                'JOIN `GroupItemDBC` ON `GroupItem`.`Id` = `GroupItemDBC`.`GroupItem` AND `GroupItemDBC`.`ClientVersion` = '.$this->ClientVersion['Id'].'  WHERE `GroupItem`.`Group` = '.$Group['Id']);      
+          'JOIN `GroupItemDBC` ON `GroupItem`.`Id` = `GroupItemDBC`.`GroupItem` AND `GroupItemDBC`.`ClientVersion` = '.$this->ClientVersion['Id'].'  WHERE `GroupItem`.`Group` = '.$Group['Id']);
         $ColumnIndexes = array();
         $ColumnFormat = array();
@@ -347 +347 @@
               $CanExport = false;
               $Output .= ', NE='.$DbRow['ID'];
-            }  
+            }
             if (!$this->HaveVarible($DbRow[$Column['Column']],$DbRow['En'.$Column['Column']])) {
               $CanExport = false;
               $Output .= ', NE='.$DbRow['ID'];
-            }  
+            }
           }
 
           if ($CanExport)
             $LookupTable[$DbRow[$Group['PrimaryKeyItem']]] = $DbRow;
-          
+
         }
-      
+
         // Open original DBC file
         $SourceDBCFile = new DBCFile();
         $SourceDBCFile->OpenFile($this->SourceDir.$this->ClientVersion['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc', $ColumnFormat);
-        
+
         // Create new DBC file
         if(!file_exists($this->TempDir.'dbc/')) mkdir ($this->TempDir.'dbc/', 0777, true);
@@ -375 +375 @@
         $Output .= "\n\r";
         $RowCount = $SourceDBCFile->GetRecordCount();
-        $FieldCount = $SourceDBCFile->GetFieldCount();        
+        $FieldCount = $SourceDBCFile->GetFieldCount();
         for($Row = 0; $Row < $RowCount; $Row++)
         {
           $Line = $SourceDBCFile->GetLine($Row);
-                    
+
           // Get multicolumn index value
           $PrimaryKeyItem = '';
           $ColumnItems = explode(',', $Group['DBCIndex']);
-          if(count($ColumnItems) > 1) 
+          if(count($ColumnItems) > 1)
           {
             foreach($ColumnItems as $ColumnItem)
@@ -391 +391 @@
 
           if(array_key_exists($PrimaryKeyItem, $LookupTable))
-          {            
+          {
             // Replace text columns
-            $LookupTableItem = $LookupTable[$PrimaryKeyItem];          
+            $LookupTableItem = $LookupTable[$PrimaryKeyItem];
             foreach($TranslationTree[$Group['Id']]['Items'] as $GroupItem)
-            {  
+            {
               if(array_key_exists($GroupItem['Id'], $ColumnIndexes))
                 $Line[$ColumnIndexes[$GroupItem['Id']]] = $LookupTableItem[$GroupItem['Column']];
@@ -401 +401 @@
           }
           $NewDBCFile->SetLine($Row, $Line);
-          
+
           // Show completion progress
           $Progress = round($Row / $RowCount * 100);
@@ -412 +412 @@
             $OldProgress = $Progress;
           }
-        }   
-        $NewDBCFile->Commit();              
+        }
+        $NewDBCFile->Commit();
       } else $Output .= ShowMessage('Zdrojový soubor '.$this->SourceDirRelative.$this->ClientVersion['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc'.' nenalezen.'."\n", MESSAGE_CRITICAL);
     }
@@ -423 +423 @@
   {
     global $TranslationTree;
-  
+
     $this->LoadFilters();
 
@@ -440 +440 @@
       $File2 = new FileStream();
       $File2->CreateFile($this->TempDir.'lua/'.$Group['LuaFileName'].'.lua');
-      
+
       $LookupTable = array();
       $DbResult2 = $this->Database->query($this->BuildQuery($Group));
@@ -454 +454 @@
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
               $CanExport = false;
-            }  
+            }
             if (!$this->HaveVarible($DbRow[$Column['Column']],$DbRow['En'.$Column['Column']])) {
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
               $CanExport = false;
-            }  
+            }
             if (!$this->HaveVarible($DbRow['En'.$Column['Column']],$DbRow[$Column['Column']],'%')) {
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
               $CanExport = false;
-            }  
+            }
             if (!$this->HaveVarible($DbRow[$Column['Column']],$DbRow['En'.$Column['Column']],'%')) {
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
               $CanExport = false;
-            }  
+            }
             if (!$this->HaveVarible($DbRow[$Column['Column']],$DbRow['En'.$Column['Column']],'\\')) {
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
               $CanExport = false;
-            }  
+            }
             if (!$this->HaveVarible($DbRow['En'.$Column['Column']],$DbRow[$Column['Column']],'\\')) {
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
@@ -478 +478 @@
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
               $CanExport = false;
-            }  
+            }
             if (!$this->HaveVarible($DbRow['En'.$Column['Column']],$DbRow[$Column['Column']],'|')) {
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
@@ -486 +486 @@
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
               $CanExport = false;
-            }  
+            }
             if (!$this->HaveVarible($DbRow['En'.$Column['Column']],$DbRow[$Column['Column']],chr(10))) {
               if ($CanExport) $Output .= ', NE='.$DbRow['ID'];
@@ -492 +492 @@
             }
           }
-            
+
         if ($CanExport)
             $LookupTable[$DbRow['ShortCut']] = $DbRow;
       }
-        
+
       while(!$File->EOF())
       {
@@ -505 +505 @@
           $Value['ShortCut'] = trim($LineParts[0]);
           $Line = trim($LineParts[1]);
-          
+
           if($Line[0] == '"')
           {
@@ -519 +519 @@
 //            $Value['Text'] = addslashes(stripslashes($Value['Text']));
             $Line = trim(substr($Line, strpos($TempLine, '"') + 1)); // Skip closing quote and semicolon                                                                  {
-          } else 
+          } else
           {
             // Nonstring value
@@ -552 +552 @@
     return($Output);
   }
-  
+
   function GetReadme() {
     $_GET['ExportId'] = $this->Id;
     $PageExport = new PageExport($this->System);
-    $this->LoadFilters();  
+    $this->LoadFilters();
     $Output = '';
     //generation readme
@@ -572 +572 @@
   '<meta http-equiv="content-type" content="application/xhtml+xml; charset=utf-8" />'.
   '<title>Čeština pro WoW</title>'.
-'</head><body>'. 
+'</head><body>'.
 '<h1>České WoW - čestina pro klienta hry World of Warcraft</h1>'.
- 
+
 '<table cellspacing="10"><tr><td valign="top">'.
- 
+
 '<p>Texty přebírány z projektu <a href="http://wowpreklad.zdechov.net/">wowpreklad.zdechov.net</a><br>'.
 '<a href="http://wowpreklad.zdechov.net/export/?Action=View&ExportId='.$this->Id.'&Tab=0">Export '.$this->Id.'</a></p><br>'.
- 
- 
+
+
 '<p><strong>Vlastnosti</strong>'.
 '<ul>'.
@@ -591 +591 @@
 '</p>'.
 '<br>'.
- 
+
 '<h2>Nejčastější otázky</h2>'.
-'<p><strong>Jak mám vyhledávat věci v aukci nebo výpravy na internetu s nainstalovanou češtinou?</strong><br>  
-Pokud používáte addon, který mění názvy předmětů jenom zdánlivě pro vás, potřebujete pro vyhledávání v aukci zjistit původní anglický název. Tento název zjistíte jednoduše držením klávesy shift a kliknutím na předmět při otevřené aukci, nebo chatu. Vytvořený odkaz v chatu, nebo text v aukci je v původním znění. Stejně zjistíte i název výpravy kliknutím se shift na výpravu v "quest logu". 
+'<p><strong>Jak mám vyhledávat věci v aukci nebo výpravy na internetu s nainstalovanou češtinou?</strong><br>
+Pokud používáte addon, který mění názvy předmětů jenom zdánlivě pro vás, potřebujete pro vyhledávání v aukci zjistit původní anglický název. Tento název zjistíte jednoduše držením klávesy shift a kliknutím na předmět při otevřené aukci, nebo chatu. Vytvořený odkaz v chatu, nebo text v aukci je v původním znění. Stejně zjistíte i název výpravy kliknutím se shift na výpravu v "quest logu".
 Pokud jste na serveru s českou lokalizaci (tedy nepoužíváte addon), musíte využít český název pro vyhledávání. Server by měl mít spuštěnou vlastní obdobu databáze wowhead.</p>'.
 
-'<p><strong>Po nainstalování češtiny a spouštění přes soubor WoWlua.exe mi klesl výrazně výkon</strong><br> 
-Problém může být spojen s použitím integrované grafiky místo herní.</p>'. 
-
-'<p><strong>Při spouštění hry přes soubor WoWLua.exe se mi neukládá žádné nastavení addonů a podobně</strong><br> 
-Problém může být způsoben špatně nastavenými právy u souboru WoWLua.exe. Můžete přenastavit práva, nebo spouštět jako správce.</p>'. 
-
-'<p><strong>Po spuštění souboru WoWLua.exe mi píše chybu:</strong><br> 
-Cannot stream required archive data. Please check the network connection. 
-Chyba může být způsobena tím, že jste nenainstalovali češtinu do adresáře se hrou. 
-Nebo jste nainstalovali do jiné verze hry, než je požadovaná. Může se vztahovat i na požadovanou lokalizaci (enUS, enGB)</p>'. 
-
-'<p><strong>Po nainstalování češtiny nemám žádné výpravy (questy) česky</strong><br> 
-Zkontrolujte si v přihlášení, jestli máte povolený addon CzWoW v seznamu addonů.</p>'. 
-
-'<p><strong>Addon mi hlásí spoustu chyb.</strong><br> 
-Chyba může být způsobena kolizí s jinými addony. Vyzkoušejte spuštění hry pouze s addonem CzWoW.</p>'. 
-
-'<p><strong>Ve hře se mi špatně zobrazuje diakritika (háčky, čárky)</strong><br> 
-Chyba je způsobena chybějícími fonty do hry. Potřebné fonty si stáhněte mezi soubory ke stažení.</p>'. 
-
-'<p><strong>Mám nainstalovánu češtinu a nejde mi spustit Wow.exe.</strong><br> 
-Pokud chcete opět spouštět hru přes původní Wow.exe v angličtině, musíte češtinu nejprve odinstalovat ze systému. Především se jedná o soubor Data/enGB/patch-enGB-5.MPQ či Data/enUS/patch-enUS-5.MPQ, který je nutno smazat. U novějších verzí se soubor může jmenovat wow-update-base-50000.MPQ.</p>'. 
-
-'<p><strong>Jak mám hru spustit?</strong><br> 
-Hru musíte spustit přes soubor WowLua.exe v kořenovém adresáři hry.</p>'. 
-
-'<p><strong>Mohu použít tuto češtinu na oficiálních serverech?</strong><br> 
+'<p><strong>Po nainstalování češtiny a spouštění přes soubor WoWlua.exe mi klesl výrazně výkon</strong><br>
+Problém může být spojen s použitím integrované grafiky místo herní.</p>'.
+
+'<p><strong>Při spouštění hry přes soubor WoWLua.exe se mi neukládá žádné nastavení addonů a podobně</strong><br>
+Problém může být způsoben špatně nastavenými právy u souboru WoWLua.exe. Můžete přenastavit práva, nebo spouštět jako správce.</p>'.
+
+'<p><strong>Po spuštění souboru WoWLua.exe mi píše chybu:</strong><br>
+Cannot stream required archive data. Please check the network connection.
+Chyba může být způsobena tím, že jste nenainstalovali češtinu do adresáře se hrou.
+Nebo jste nainstalovali do jiné verze hry, než je požadovaná. Může se vztahovat i na požadovanou lokalizaci (enUS, enGB)</p>'.
+
+'<p><strong>Po nainstalování češtiny nemám žádné výpravy (questy) česky</strong><br>
+Zkontrolujte si v přihlášení, jestli máte povolený addon CzWoW v seznamu addonů.</p>'.
+
+'<p><strong>Addon mi hlásí spoustu chyb.</strong><br>
+Chyba může být způsobena kolizí s jinými addony. Vyzkoušejte spuštění hry pouze s addonem CzWoW.</p>'.
+
+'<p><strong>Ve hře se mi špatně zobrazuje diakritika (háčky, čárky)</strong><br>
+Chyba je způsobena chybějícími fonty do hry. Potřebné fonty si stáhněte mezi soubory ke stažení.</p>'.
+
+'<p><strong>Mám nainstalovánu češtinu a nejde mi spustit Wow.exe.</strong><br>
+Pokud chcete opět spouštět hru přes původní Wow.exe v angličtině, musíte češtinu nejprve odinstalovat ze systému. Především se jedná o soubor Data/enGB/patch-enGB-5.MPQ či Data/enUS/patch-enUS-5.MPQ, který je nutno smazat. U novějších verzí se soubor může jmenovat wow-update-base-50000.MPQ.</p>'.
+
+'<p><strong>Jak mám hru spustit?</strong><br>
+Hru musíte spustit přes soubor WowLua.exe v kořenovém adresáři hry.</p>'.
+
+'<p><strong>Mohu použít tuto češtinu na oficiálních serverech?</strong><br>
 Ne úplně, protože se vystavujete riziku zablokování vašeho účtu z důvodu použití upravené hry. Na oficiálním serveru lze využít pouze Addon s češtinou CzWoW. Instalační soubor určený pro oficiální servery je už takto přizpůsoben.</p>'.
-  
+
 '</td><td>';
 
@@ -631 +631 @@
 
   $Output .= '</td></tr></table>'.
- 
- 
+
+
   '</body></html>';
   return $Output;
-}  
-  
+}
+
   function ExportToXML()
   {
     global $TranslationTree;
-  
+
     $this->LoadFilters();
 
@@ -653 +653 @@
     foreach(explode(',', $this->UserNames) as $UserName)
       $Buffer .= "      <user>".$UserName."</user>\n";
-    $Buffer .= 
+    $Buffer .=
     "    </contributors>\n".
     "  </meta>\n".
@@ -659 +659 @@
 
     $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` '.
-        'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
+      'JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
     while($Group = $DbResult->fetch_assoc())
     {
@@ -669 +669 @@
       $Buffer .= '    <group id="'.$Group['Id'].'" name="'.$Group['TablePrefix'].'">'."\n";
       $DbResult2 = $this->Database->query($this->BuildQuery($Group));
-      while($Line = $DbResult2->fetch_assoc()) 
+      while($Line = $DbResult2->fetch_assoc())
       {
         $Buffer .= '      <item id="'.$Line['Entry'].'" user="'.$Line['UserName'].'">'."\n";
@@ -681 +681 @@
         }
         $Buffer .= "      </item>\n";
-      }    
+      }
       $Buffer .= "    </group>\n";
     }
@@ -688 +688 @@
   "</document>";
     return($Buffer);
-  }    
+  }
 }
 
@@ -706 +706 @@
     $this->Dependencies = array();
   }
-  
+
   function Start()
   {
-        $this->System->RegisterPage('export', 'PageExport');
-        $this->System->RegisterMenuItem(array(
-        'Title' => 'Exporty',
-        'Hint' => 'Zde si můžete stáhnout přeložené texty',
-        'Link' => $this->System->Link('/export/'),
-        'Permission' => LICENCE_ANONYMOUS,
-        'Icon' => '',
+    $this->System->RegisterPage('export', 'PageExport');
+    $this->System->RegisterMenuItem(array(
+      'Title' => 'Exporty',
+      'Hint' => 'Zde si můžete stáhnout přeložené texty',
+      'Link' => $this->System->Link('/export/'),
+      'Permission' => LICENCE_ANONYMOUS,
+      'Icon' => '',
     ), 2);
   }

trunk/Modules/Export/ExportOutput.php

@@ -17 +17 @@
       //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); 
-    }          
+        else $Zip->addFile(file_get_contents($Path.$FileName), $ZipPath.$FileName);
+    }
   }
 }
@@ -25 +25 @@
 {
   global $System, $Config;
-  
-  $Output = '';
-  $Export = new Export($System);
-  $Export->Id = $ExportId;
-  $Export->Init(); 
-  if(function_exists('gzcompress')) 
+
+  $Output = '';
+  $Export = new Export($System);
+  $Export->Id = $ExportId;
+  $Export->Init();
+  if(function_exists('gzcompress'))
   {
     $SaveFilename = $Export->TempDir.'CzAoWoW_SQL.zip';
-    $SQLFilename = 'CzAoWoW_SQL.sql';        
+    $SQLFilename = 'CzAoWoW_SQL.sql';
     $BufferZip = $Export->ExportToAoWoWSQL();
     $ZipFile = new zipfile();
@@ -43 +43 @@
   //  'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
   //  '</script>';
-      
-  $Output .= 'Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
+
+  $Output .= 'Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '.
     '<a href="'.$System->Link('/'.$Export->TempDirRelative.'CzAoWoW_SQL.zip').'">'.$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.';
@@ -53 +53 @@
 {
   global $System, $Config;
-  
-  $Export = new Export($System);
-  $Export->Id = $ExportId;
-  
+
+  $Export = new Export($System);
+  $Export->Id = $ExportId;
+
   $Output = 'Vygenerovaný SQL kód: <br /><pre class="SQLCode">'.
      htmlspecialchars($Export->ExportToAoWoWSQL()).
@@ -66 +66 @@
 {
   global $System, $Config;
-  
-  $Output = '';
-  $Export = new Export($System);
-  $Export->Id = $ExportId;
-  $Export->Init();
-  if(function_exists('gzcompress')) 
+
+  $Output = '';
+  $Export = new Export($System);
+  $Export->Id = $ExportId;
+  $Export->Init();
+  if(function_exists('gzcompress'))
   {
     $SaveFilename = $Export->TempDir.'CzWoW_SQL.zip';
-    $SQLFilename = 'CzWoW_SQL.sql';        
+    $SQLFilename = 'CzWoW_SQL.sql';
     $BufferZip = $Export->ExportToMangosSQL();
     $ZipFile = new zipfile();
@@ -84 +84 @@
   //  'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
   //  '</script>';
-      
-  $Output .= 'Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
+
+  $Output .= 'Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '.
     '<a href="'.$System->Link('/'.$Export->TempDirRelative.'CzWoW_SQL.zip').'">'.$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.';
-  return($Output);  
+  return($Output);
 }
 
@@ -94 +94 @@
 {
   global $System;
-  
+
   $Export = new Export($System);
   $Export->Id = $ExportId;
@@ -107 +107 @@
 {
   global $System;
-  
-  if(function_exists('gzcompress')) 
+
+  if(function_exists('gzcompress'))
   {
     $Addon = new ExportAddon($System);
@@ -114 +114 @@
     $Addon->Init();
     $Output = $Addon->MakeAddon();
-    
+
     $Output .= 'Generování addonu...<br />';
-    $SaveFilename = $Addon->TempDir.'CzWoW_Addon-'.$Addon->ClientVersion['Version'].'.zip';          
+    $SaveFilename = $Addon->TempDir.'CzWoW_Addon-'.$Addon->ClientVersion['Version'].'.zip';
     $Zip = new zipfile();
     CreateZipFromDir($Zip, $Addon->TempDir.'CzWoW/', 'CzWoW/');
-    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/OptionsFrame.xml'), 'CzWoW/OptionsFrame.xml'); 
-    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/CzWoW.xml'), 'CzWoW/CzWoW.xml'); 
-    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/CzWoW.toc'), 'CzWoW/CzWoW.toc'); 
-    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/CzWoW.lua'), 'CzWoW/CzWoW.lua'); 
-    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/GameMenuFrame.xml'), 'CzWoW/GameMenuFrame.xml'); 
-    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/Localization.lua'), 'CzWoW/Localization.lua'); 
+    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/OptionsFrame.xml'), 'CzWoW/OptionsFrame.xml');
+    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/CzWoW.xml'), 'CzWoW/CzWoW.xml');
+    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/CzWoW.toc'), 'CzWoW/CzWoW.toc');
+    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/CzWoW.lua'), 'CzWoW/CzWoW.lua');
+    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/GameMenuFrame.xml'), 'CzWoW/GameMenuFrame.xml');
+    $Zip->addFile(file_get_contents(dirname(__FILE__).'/files/'.$Addon->ClientVersion['Version'].'/CzWoW/Localization.lua'), 'CzWoW/Localization.lua');
     $Buffer = $Zip->file();
     file_put_contents($SaveFilename, $Buffer);
@@ -132 +132 @@
   //  'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
   //  '</script>';
-      
-  $Output .= 'Soubor ke stažení: '. 
+
+  $Output .= 'Soubor ke stažení: '.
     '<a href="'.$System->Link('/'.$Addon->TempDirRelative.'CzWoW_Addon-'.$Addon->ClientVersion['Version'].'.zip').'">CzWoW_Addon-'.$Addon->ClientVersion['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.';
@@ -143 +143 @@
 {
   global $Config, $System;
-  
-  $Output = '';
-  $Export = new Export($System);
-  $Export->Id = $ExportId;
-  $Export->Init();
-  if(function_exists('gzcompress')) 
+
+  $Output = '';
+  $Export = new Export($System);
+  $Export->Id = $ExportId;
+  $Export->Init();
+  if(function_exists('gzcompress'))
   {
     $SaveFilename = $Export->TempDir.'CzWoW_XML.zip';
-    $SQLFilename = 'CzWoW_XML.sql';        
+    $SQLFilename = 'CzWoW_XML.sql';
     $BufferZip = $Export->ExportToXML();
     $ZipFile = new zipfile();
@@ -161 +161 @@
   // 'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
   // '</script>';
-      
-  $Output .= 'Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
+
+  $Output .= 'Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '.
     '<a href="'.$System->Link('/'.$Export->TempDirRelative.'CzWoW_XML.zip').'">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.';
@@ -171 +171 @@
 {
   global $System;
-  
+
   $Export = new Export($System);
   $Export->Id = $ExportId;
@@ -188 +188 @@
   $Export->Id = $ExportId;
   $Export->Init();
-  
+
   $Output = '';
   if(array_key_exists('Regenerate', $_POST))
@@ -199 +199 @@
   $Output .= '<form action="?Action=View&amp;Tab=7&amp;ExportId='.$ExportId.'" method="post"><input type="submit" name="Regenerate" value="Přegenerovat"/></form><br />';
   $Output .= 'U DBC souborů export textů funguje jinak, protože generování je náročné, jsou požadavky zařazovány do fronty a postupně zpracovávány.<br />DBC soubory je nutné zabalit do souboru patch-enGB-5.MPQ uvnitř složky "DBFilesClient" a hru spouštět přes upravený spouštěcí soubor. Zabalit je můžete pomocí programu <a href="../download/mpqediten32.zip">Ladik\'s MPQ Editor</a>. Stav vygenerování můžete sledovat na této stránce.<br /><br />';
-    
+
   $DbResult = $System->Database->query('SELECT * FROM ExportTask WHERE Export = '.$ExportId);
   if($DbResult->num_rows == 0)
@@ -206 +206 @@
     $System->ModuleManager->Modules['Log']->WriteLog('Zadání úlohy pro vygenerování dbc souboru', LOG_TYPE_DOWNLOAD);
     $System->Database->query('UPDATE `ExportTask` SET `Progress`=0 WHERE `Export`='.$Export->Id);
-  }  
-  
+  }
+
   $DbResult = $System->Database->query('SELECT * FROM `ExportTask` WHERE `Export` = '.$ExportId);
   $ExportTask = $DbResult->fetch_assoc();
@@ -216 +216 @@
     while($Group = $DbResult->fetch_assoc())
     {
-      if(file_exists($Export->TempDir.'dbc/'.$Group['DBCFileName'].'.dbc')) 
-        $Output .= '<a href="'.$System->Link('/'.$Export->TempDirRelative.'dbc/'.$Group['DBCFileName'].'.dbc').'">'.$Group['DBCFileName'].'.dbc</a><br/>';
+      if(file_exists($Export->TempDir.'dbc/'.$Group['DBCFileName'].'.dbc'))
+        $Output .= '<a href="'.$System->Link('/'.$Export->TempDirRelative.'dbc/'.$Group['DBCFileName'].'.dbc').'">'.$Group['DBCFileName'].'.dbc</a><br/>';
     }
   } else {
     $Output .= ShowProgress($Export);
 
-  } 
+  }
   return($Output);
 }
@@ -232 +232 @@
 
 
-        $Output .= '<script src="http://code.jquery.com/jquery-latest.js"></script>'.
+      $Output .= '<script src="http://code.jquery.com/jquery-latest.js"></script>'.
                '<script>'.
                   '$(document).ready(function() {'.
@@ -241 +241 @@
                '</script>';
 
-    
+
       $Output .= ' <strong><div id="progress"></div></strong><br />';
 
@@ -248 +248 @@
     if($DbResult->num_rows > 0) {
       $System->ModuleManager->Modules['Log']->WriteLog('ProcesTask nepracuje přes 2 hodiny, pravděpodobně nepracuje!', LOG_TYPE_ERROR);
-  
+
     }
     return ($Output);
@@ -256 +256 @@
 {
   global $System;
-  
+
   $Export = new Export($System);
   $Export->Id = $ExportId;
@@ -272 +272 @@
   $Output .= '<form action="?Action=View&amp;Tab=7&amp;ExportId='.$ExportId.'" method="post"><input type="submit" name="Regenerate" value="Přegenerovat"/></form><br />';
   $Output .= 'U souhrné instalace češtiny funguje export textů jinak, protože generování je náročné, jsou požadavky zařazovány do fronty a postupně zpracovávány.<br /><br />';
-    
+
   $DbResult = $System->Database->query('SELECT * FROM ExportTask WHERE Export = '.$ExportId);
   if($DbResult->num_rows == 0)
@@ -278 +278 @@
     $System->Database->query('INSERT INTO ExportTask (`Export` ,`TimeStart` ) VALUES ('.$ExportId.', NOW())');
     $System->ModuleManager->Modules['Log']->WriteLog('Zadání úlohy pro vygenerování dbc souboru', LOG_TYPE_DOWNLOAD);
-  }  
-  
+  }
+
   $DbResult = $System->Database->query('SELECT * FROM `ExportTask` WHERE `Export` = '.$ExportId);
   $ExportTask = $DbResult->fetch_assoc();
@@ -287 +287 @@
 
   } else {
-    
+
     $Output .= ShowProgress($Export);
   }
@@ -296 +296 @@
 {
   global $System, $Config;
-  
-  $Export = new Export($System);
-  $Export->Id = $ExportId;
-  $Export->Init();
-
-  if(function_exists('gzcompress')) 
+
+  $Export = new Export($System);
+  $Export->Id = $ExportId;
+  $Export->Init();
+
+  if(function_exists('gzcompress'))
   {
     $Output = 'Generování lua souborů...<br />';
     $Export->ExportToLua();
-    $SaveFilename = $Export->TempDir.'CzWoW_Lua.zip';          
+    $SaveFilename = $Export->TempDir.'CzWoW_Lua.zip';
     $ZipFile = new zipfile();
     CreateZipFromDir($ZipFile, $Export->TempDir.'lua/', '');
@@ -315 +315 @@
   //  'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 3000)'.
   //  '</script>';
-      
-  $Output .= '<strong>Soubory:</strong><br/>'.  
+
+  $Output .= '<strong>Soubory:</strong><br/>'.
     'Souhrný archív <a href="'.$System->Link('/'.$Export->TempDirRelative.'CzWoW_Lua.zip').'">CzWoW_Lua.zip</a><br />';
   $DbResult = $System->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `Group`.`LuaFileName` != ""');

trunk/Modules/Export/Page.php

@@ -14 +14 @@
 class PageExport extends Page
 {
-        function ExportList()
-        {
-                $Output = '<a href="?Action=ViewList">'.T('All').'</a>';
-                if($this->System->User->Licence(LICENCE_USER))
-                {
-                        $Output .= ' <a href="?Action=ViewList&amp;Filter=Others">Ostatních</a>'.
-                                        ' <a href="?Action=ViewList&amp;Filter=My">'.T('Mine').'</a>';
-                }
-        
-                if($this->System->User->Licence(LICENCE_USER))
-                        $Output .= '<br/><div style="text-align: center;"><a href="?Action=Create">'.T('Create new export').'</a></div><br/>';
-                
-                $Filter = '';
-                if(array_key_exists('Filter', $_GET))
-                {
-                        if($_GET['Filter'] == 'My') $Filter = ' WHERE `Export`.`User` = '.$this->System->User->Id;
-                        if($_GET['Filter'] == 'Others') $Filter = ' WHERE `Export`.`User` != '.$this->System->User->Id;
-                }
-        
-                $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` '.$Filter);
-                $DbRow = $DbResult->fetch_row();
-                $PageList = GetPageList($DbRow[0]);
-        
-                $Output .= '<h3>'.T('List of export').'</h3>'.
-                                $PageList['Output'];
-        
-                $TableColumns = array(
-                                array('Name' => 'TimeCreate', 'Title' => T('Time made')),
-                                array('Name' => 'UserName', 'Title' => T('Translator')),
-                                array('Name' => 'Title', 'Title' => T('Name od export')),
-                                //  array('Name' => 'UserCount', 'Title' => 'Vybraných překladatelů'),
-                                //  array('Name' => 'GroupCount', 'Title' => 'Překladových skupin'),
-                                array('Name' => 'OutputType', 'Title' => T('Type of output')),
-                                array('Name' => 'ClientVersion', 'Title' => T('Client version')),
-                                array('Name' => 'UsedCount', 'Title' => T('Viewed count')),
-                                array('Name' => '', 'Title' => T('Action')),
-                );
-                $Order = GetOrderTableHeader($TableColumns, 'TimeCreate', 1);
-                $Output .= '<table class="BaseTable">'.
-                                $Order['Output'];
-        
-                $DbResult = $this->System->Database->query('SELECT `User`.`Name` AS `UserName`, `Export`.`Id`, `Export`.`TimeCreate`, `Export`.`Title`, `Export`.`User`, `Export`.`UsedCount`, '.
+  function ExportList()
+  {
+    $Output = '<a href="?Action=ViewList">'.T('All').'</a>';
+    if($this->System->User->Licence(LICENCE_USER))
+    {
+      $Output .= ' <a href="?Action=ViewList&amp;Filter=Others">Ostatních</a>'.
+          ' <a href="?Action=ViewList&amp;Filter=My">'.T('Mine').'</a>';
+    }
+
+    if($this->System->User->Licence(LICENCE_USER))
+      $Output .= '<br/><div style="text-align: center;"><a href="?Action=Create">'.T('Create new export').'</a></div><br/>';
+
+    $Filter = '';
+    if(array_key_exists('Filter', $_GET))
+    {
+      if($_GET['Filter'] == 'My') $Filter = ' WHERE `Export`.`User` = '.$this->System->User->Id;
+      if($_GET['Filter'] == 'Others') $Filter = ' WHERE `Export`.`User` != '.$this->System->User->Id;
+    }
+
+    $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` '.$Filter);
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
+
+    $Output .= '<h3>'.T('List of export').'</h3>'.
+        $PageList['Output'];
+
+    $TableColumns = array(
+        array('Name' => 'TimeCreate', 'Title' => T('Time made')),
+        array('Name' => 'UserName', 'Title' => T('Translator')),
+        array('Name' => 'Title', 'Title' => T('Name od export')),
+        //  array('Name' => 'UserCount', 'Title' => 'Vybraných překladatelů'),
+        //  array('Name' => 'GroupCount', 'Title' => 'Překladových skupin'),
+        array('Name' => 'OutputType', 'Title' => T('Type of output')),
+        array('Name' => 'ClientVersion', 'Title' => T('Client version')),
+        array('Name' => 'UsedCount', 'Title' => T('Viewed count')),
+        array('Name' => '', 'Title' => T('Action')),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'TimeCreate', 1);
+    $Output .= '<table class="BaseTable">'.
+        $Order['Output'];
+
+    $DbResult = $this->System->Database->query('SELECT `User`.`Name` AS `UserName`, `Export`.`Id`, `Export`.`TimeCreate`, `Export`.`Title`, `Export`.`User`, `Export`.`UsedCount`, '.
       '(SELECT Version FROM `ClientVersion` WHERE `ClientVersion`.`Id`=`Export`.`ClientVersion`) AS `ClientVersion`, '.
       '(SELECT Id FROM `ClientVersion` WHERE `ClientVersion`.`Id`=`Export`.`ClientVersion`) AS `ClientVersionId`, '.
@@ -62 +62 @@
       '(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 = $DbResult->fetch_assoc())
-                {
-                        $Action = '<a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=0">'.T('View').'</a> '.
-                          '<a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=7">'.T('Make export').'</a>';
-                        if($Export['User'] == $this->System->User->Id) $Action .= ' <a href="?Action=Delete&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\''.T('Realy delete item?').'\');">'.T('Delete').'</a>';
-                        if($this->System->User->Id != null) $Action .= ' <a href="?Action=Clone&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\''.T('Realy clone item?').'\');">'.T('Clone').'</a>';
-                        $Output .= '<tr><td>'.HumanDate($Export['TimeCreate']).'</td>'.
-                                        '<td><a href="'.$this->System->Link('/user.php?user='.$Export['User']).'">'.$Export['UserName'].'</a></td>'.
-                                        '<td>'.$Export['Title'].'</td>'.
-                                        '<td>'.$Export['OutputType'].'</td>'.
-                                        '<td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.$Export['ClientVersionId']).'">'.$Export['ClientVersion'].'</a></td>'.
-                                        '<td>'.$Export['UsedCount'].'</td>'.
-                                        '<td>'.$Action.'</td></tr>';
-                }
-                $Output .= '</table>'.
-                                $PageList['Output'];
-        
-                return($Output);
-        }
-        
-        function ExportCreate()
-        {
-                if($this->System->User->Licence(LICENCE_USER))
-                {
-                        $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `User`='.$this->System->User->Id);
-                        $DbRow = $DbResult->fetch_row();
-                        if($DbRow[0] < $this->System->Config['MaxExportPerUser'])
-                        {
-                                $Output = '<form action="?Action=CreateFinish" method="post">'.
-                                                '<fieldset><legend>'.T('Creation of new export').'</legend>'.
-                                                '<table><tr><td>'.T('Identification').':</td><td><input type="text" name="Title" /></td></tr>'.
-                                                '<tr><td>'.T('Description').':</td><td><textarea name="Description" cols="54" rows="10"></textarea></td></tr>'.
-                                                '<tr><td colspan="2"><input type="submit" value="'.T('Create').'" /></td></tr>'.
-                                                '</table></fieldset></form>';
-                        } else $Output = ShowMessage(T('You can\'t create another export. Max for one user is').$this->System->Config['MaxExportPerUser'].'.', MESSAGE_CRITICAL);
-                } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
-                return($Output);
-        }
-        
-        function ExportCreateFinish()
-        {
-                if($this->System->User->Licence(LICENCE_USER))
-                {
-                        if(array_key_exists('Title', $_POST) and array_key_exists('Description', $_POST))
-                        {
-                                $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `User`='.$this->System->User->Id);
-                                $DbRow = $DbResult->fetch_row();
-                                if($DbRow[0] < $this->System->Config['MaxExportPerUser'])
-                                {
-                                        $this->System->Database->query('INSERT INTO `Export` (`Title`, `User`, `TimeCreate`, `WithDiacritic`, `Description`) VALUES ("'.$_POST['Title'].'", '.$this->System->User->Id.', NOW(), 1, "'.$_POST['Description'].'")');
-                                        $ExportId = $this->System->Database->insert_id;
-                                        $Output = ShowMessage(T('New export created.<br />Direct link to export').': <a href="?Action=View&amp;ExportId='.$ExportId.'">'.T('here').'</a>');
-                                        $this->System->ModuleManager->Modules['Log']->WriteLog(T('New export created').' <a href="'.$this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">'.$ExportId.'</a>.', LOG_TYPE_EXPORT);
-                                        $_GET['Filter'] = 'my';
-                                        $this->ExportList();
-                                } else $Output = ShowMessage(T('You can\'t create another export. Max for one user is').' '.$this->System->Config['MaxExportPerUser'].'.', MESSAGE_CRITICAL);
-                        } else $Output = ShowMessage(T('Missing data in form.'), MESSAGE_CRITICAL);
-                } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
-                return($Output);
-        }
-        
-        function ExportDelete()
-        {
-                if($this->System->User->Licence(LICENCE_USER))
-                {
-                        $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE (`Id`='.($_GET['ExportId'] * 1).') AND (`User`='.$this->System->User->Id.')');
-                        if($DbResult->num_rows > 0)
-                        {
-                                $this->System->Database->query('DELETE FROM `ExportGroup` WHERE `Export`='.$_GET['ExportId']);
-                                $this->System->Database->query('DELETE FROM `ExportGroupItem` WHERE `Export`='.$_GET['ExportId']);
-                                $this->System->Database->query('DELETE FROM `ExportLanguage` WHERE `Export`='.$_GET['ExportId']);
-                                $this->System->Database->query('DELETE FROM `ExportTask` WHERE `Export`='.$_GET['ExportId']);
-                                $this->System->Database->query('DELETE FROM `ExportUser` WHERE `Export`='.$_GET['ExportId']);
-                                $this->System->Database->query('DELETE FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                                DeleteDirectory('../tmp/Export/'.$_GET['ExportId'].'/');
-                                $Output = ShowMessage(T('Export deleted.'));
-                                $_GET['Filter'] = 'my';
-                                $this->System->ModuleManager->Modules['Log']->WriteLog('Smazán export '.$_GET['ExportId'], LOG_TYPE_EXPORT);
-                                $Output .= $this->ExportList();
-                        } else $Output = ShowMessage(T('Export not found.'), MESSAGE_CRITICAL);
-                } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
-                return($Output);
-        }
-        
-        function SaveAllUsers()
-        {
-         global $System;
-            $Export = new Export($System);
+    while($Export = $DbResult->fetch_assoc())
+    {
+      $Action = '<a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=0">'.T('View').'</a> '.
+        '<a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=7">'.T('Make export').'</a>';
+      if($Export['User'] == $this->System->User->Id) $Action .= ' <a href="?Action=Delete&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\''.T('Realy delete item?').'\');">'.T('Delete').'</a>';
+      if($this->System->User->Id != null) $Action .= ' <a href="?Action=Clone&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\''.T('Realy clone item?').'\');">'.T('Clone').'</a>';
+      $Output .= '<tr><td>'.HumanDate($Export['TimeCreate']).'</td>'.
+          '<td><a href="'.$this->System->Link('/user.php?user='.$Export['User']).'">'.$Export['UserName'].'</a></td>'.
+          '<td>'.$Export['Title'].'</td>'.
+          '<td>'.$Export['OutputType'].'</td>'.
+          '<td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.$Export['ClientVersionId']).'">'.$Export['ClientVersion'].'</a></td>'.
+          '<td>'.$Export['UsedCount'].'</td>'.
+          '<td>'.$Action.'</td></tr>';
+    }
+    $Output .= '</table>'.
+        $PageList['Output'];
+
+    return($Output);
+  }
+
+  function ExportCreate()
+  {
+    if($this->System->User->Licence(LICENCE_USER))
+    {
+      $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `User`='.$this->System->User->Id);
+      $DbRow = $DbResult->fetch_row();
+      if($DbRow[0] < $this->System->Config['MaxExportPerUser'])
+      {
+        $Output = '<form action="?Action=CreateFinish" method="post">'.
+            '<fieldset><legend>'.T('Creation of new export').'</legend>'.
+            '<table><tr><td>'.T('Identification').':</td><td><input type="text" name="Title" /></td></tr>'.
+            '<tr><td>'.T('Description').':</td><td><textarea name="Description" cols="54" rows="10"></textarea></td></tr>'.
+            '<tr><td colspan="2"><input type="submit" value="'.T('Create').'" /></td></tr>'.
+            '</table></fieldset></form>';
+      } else $Output = ShowMessage(T('You can\'t create another export. Max for one user is').$this->System->Config['MaxExportPerUser'].'.', MESSAGE_CRITICAL);
+    } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
+    return($Output);
+  }
+
+  function ExportCreateFinish()
+  {
+    if($this->System->User->Licence(LICENCE_USER))
+    {
+      if(array_key_exists('Title', $_POST) and array_key_exists('Description', $_POST))
+      {
+        $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `User`='.$this->System->User->Id);
+        $DbRow = $DbResult->fetch_row();
+        if($DbRow[0] < $this->System->Config['MaxExportPerUser'])
+        {
+          $this->System->Database->query('INSERT INTO `Export` (`Title`, `User`, `TimeCreate`, `WithDiacritic`, `Description`) VALUES ("'.$_POST['Title'].'", '.$this->System->User->Id.', NOW(), 1, "'.$_POST['Description'].'")');
+          $ExportId = $this->System->Database->insert_id;
+          $Output = ShowMessage(T('New export created.<br />Direct link to export').': <a href="?Action=View&amp;ExportId='.$ExportId.'">'.T('here').'</a>');
+          $this->System->ModuleManager->Modules['Log']->WriteLog(T('New export created').' <a href="'.$this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">'.$ExportId.'</a>.', LOG_TYPE_EXPORT);
+          $_GET['Filter'] = 'my';
+          $this->ExportList();
+        } else $Output = ShowMessage(T('You can\'t create another export. Max for one user is').' '.$this->System->Config['MaxExportPerUser'].'.', MESSAGE_CRITICAL);
+      } else $Output = ShowMessage(T('Missing data in form.'), MESSAGE_CRITICAL);
+    } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
+    return($Output);
+  }
+
+  function ExportDelete()
+  {
+    if($this->System->User->Licence(LICENCE_USER))
+    {
+      $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE (`Id`='.($_GET['ExportId'] * 1).') AND (`User`='.$this->System->User->Id.')');
+      if($DbResult->num_rows > 0)
+      {
+        $this->System->Database->query('DELETE FROM `ExportGroup` WHERE `Export`='.$_GET['ExportId']);
+        $this->System->Database->query('DELETE FROM `ExportGroupItem` WHERE `Export`='.$_GET['ExportId']);
+        $this->System->Database->query('DELETE FROM `ExportLanguage` WHERE `Export`='.$_GET['ExportId']);
+        $this->System->Database->query('DELETE FROM `ExportTask` WHERE `Export`='.$_GET['ExportId']);
+        $this->System->Database->query('DELETE FROM `ExportUser` WHERE `Export`='.$_GET['ExportId']);
+        $this->System->Database->query('DELETE FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+        DeleteDirectory('../tmp/Export/'.$_GET['ExportId'].'/');
+        $Output = ShowMessage(T('Export deleted.'));
+        $_GET['Filter'] = 'my';
+        $this->System->ModuleManager->Modules['Log']->WriteLog('Smazán export '.$_GET['ExportId'], LOG_TYPE_EXPORT);
+        $Output .= $this->ExportList();
+      } else $Output = ShowMessage(T('Export not found.'), MESSAGE_CRITICAL);
+    } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
+    return($Output);
+  }
+
+  function SaveAllUsers()
+  {
+   global $System;
+      $Export = new Export($System);
       $Export->Id = $_GET['ExportId'];
       $Export->SaveAllUsers();
-      
-  }
-        
-        function ExportViewTranslators()
-        {
-                global $TranslationTree;
-        
-                $Output = '';
-                $DisabledInput = array(false => ' disabled="disabled"', true => '');
-                $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                $Export = $DbResult->fetch_assoc();
-                if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
-                else $Editable = false;
-        
-                if(array_key_exists('Operation', $_POST))
-                {
-                        if($_POST['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 = $this->System->Database->query('SELECT * FROM `ExportUser` '.$Condition);
-                                                if($DbResult->num_rows > 0)
-                                                {
-                                                        if(!$Selected) $this->System->Database->query('DELETE FROM `ExportUser` '.$Condition);
-                                                        else $this->System->Database->query('UPDATE `ExportUser` SET `Sequence`='.$Value.$Condition);
-                                                } else
-                                                {
-                                                        if($Selected) $this->System->Database->query('INSERT INTO `ExportUser` (`Export`, `User`, `Sequence`) VALUES ('.$_GET['ExportId'].', '.$UserId.', '.$Value.')');
-                                                }
-                                        }
-                                }
-        
-                          if (array_key_exists('AllUsers', $_POST)) { 
+
+  }
+
+  function ExportViewTranslators()
+  {
+    global $TranslationTree;
+
+    $Output = '';
+    $DisabledInput = array(false => ' disabled="disabled"', true => '');
+    $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+    $Export = $DbResult->fetch_assoc();
+    if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
+    else $Editable = false;
+
+    if(array_key_exists('Operation', $_POST))
+    {
+      if($_POST['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 = $this->System->Database->query('SELECT * FROM `ExportUser` '.$Condition);
+            if($DbResult->num_rows > 0)
+            {
+              if(!$Selected) $this->System->Database->query('DELETE FROM `ExportUser` '.$Condition);
+              else $this->System->Database->query('UPDATE `ExportUser` SET `Sequence`='.$Value.$Condition);
+            } else
+            {
+              if($Selected) $this->System->Database->query('INSERT INTO `ExportUser` (`Export`, `User`, `Sequence`) VALUES ('.$_GET['ExportId'].', '.$UserId.', '.$Value.')');
+            }
+          }
+        }
+
+        if (array_key_exists('AllUsers', $_POST)) {
             //add allusers to export
-                                                $this->System->Database->query('UPDATE `Export` SET `AllUsers`=1 WHERE `Id`='.$_GET['ExportId']);
-            
-                  //update export stat
+            $this->System->Database->query('UPDATE `Export` SET `AllUsers`=1 WHERE `Id`='.$_GET['ExportId']);
+
+            //update export stat
             $Export['AllUsers'] = 1;
             $this->SaveAllUsers();
           } else {
-                  //update export stat
+            //update export stat
             $Export['AllUsers'] = 0;
-                                                $this->System->Database->query('UPDATE `Export` SET `AllUsers`=0 WHERE `Id`='.$_GET['ExportId']);
+            $this->System->Database->query('UPDATE `Export` SET `AllUsers`=0 WHERE `Id`='.$_GET['ExportId']);
           }
 
-                                // Recalculate sequence number
-                                $this->System->Database->query('SET @I = 0');
-                                $this->System->Database->query('UPDATE `ExportUser` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$_GET['ExportId'].' ORDER BY `Sequence`;');
-                                $Output .= ShowMessage(T('Select saved.'));
-                        }
-                }
-        
-                $TableColumns = array(
-                                array('Name' => 'Name', 'Title' => T('Name')),
-                                array('Name' => 'TranslatedCount', 'Title' => T('Translated count')),
-                                array('Name' => 'XP', 'Title' => T('Level')),
-                                array('Name' => 'XP', 'Title' => T('Experience')), 
-                                array('Name' => '', 'Title' => T('Select')),
-                                array('Name' => 'Sequence2', 'Title' => T('Order')),
-                );
-                $Order = GetOrderTableHeader($TableColumns, 'TranslatedCount', 1);
-                if($Order['Column'] != 'Sequence2') $InitialOrder = ', '.substr($Order['SQL'], 10);
-                else $InitialOrder = '';
-        
-                $Query = 'SELECT (@I := @I + 1) AS `Sequence2`, `TT`.* FROM (SELECT `ExportUser`.`Sequence`, `T`.`ID`, `T`.`TranslatedCount`, `T`.`Name`, `T`.`XP` FROM (SELECT `User`.`ID`, `User`.`Name`, `User`.`XP`, `TranslatedCount` FROM `User`) AS T';
-                $Query .=' LEFT JOIN `ExportUser` ON `ExportUser`.`Export` = '.$_GET['ExportId'].' AND `ExportUser`.`User`=`T`.`ID`';
-                $Query .=' WHERE `T`.`TranslatedCount` > 0 ORDER BY COALESCE(`ExportUser`.`Sequence`, 100000000)'.$InitialOrder.') AS `TT`';
-        
-                $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS `X`');
-                $DbRow = $DbResult->fetch_row();
-                $PageList = GetPageList($DbRow[0]);
-        
-                $Output .= '<form name="Translators" action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
-                                '<h3>'.T('Translators').'</h3>';
-                if($Editable)
-                {
-                        $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
-                                        '<input type="hidden" name="Operation" value="Save"/><br />'.
-                                        ' <span onclick="CheckAllCheckbox();">'.CheckBox('CheckAll', False, 'CheckAll').' '.T('Select all on page').'</span> <br />'.
-                                        ' <span>'.CheckBox('AllUsers', $Export['AllUsers']).' '.T('Export allways from all users').'</span> '.
-                                        '<br />'.
-                                        T('Select users from list which you want to export from. And edit their order.').'<br />'.
-                                        T('Order is done by numeric value which is can be edit to desirable order. Lines with same number will be renumbered in ascending order.');
-                }
-        
-                $Output .= $PageList['Output'].
-                '<table class="BaseTable">'.
-                $Order['Output'];
-        
-                $Query = 'SELECT * FROM ('.$Query.') AS `TX` '.$Order['SQL'].$PageList['SQLLimit'];
-                $this->System->Database->query('SET @I = 0');
-                $DbResult = $this->System->Database->query($Query);
-                while($UserLine = $DbResult->fetch_assoc())
-                {
-                        $XP = GetLevelMinMax($UserLine['XP']);
-                        $Checked = $UserLine['Sequence'] != '';
-                        $Selection = CheckBox('sel'.$UserLine['ID'], $Checked, '', 'CheckBox', ((!$Editable) or ($Export['AllUsers'])));
-                        $Sequence = '<input type="text" name="seq'.$UserLine['ID'].'" style="text-align: center; width: 40px;" value="'.$UserLine['Sequence2'].'"'.$DisabledInput[$Editable].'/>';
-                        $Output .= '<tr>'.
-                                        '<td><a href="'.$this->System->Link('/TranslationList.php?user='.$UserLine['ID'].'&amp;state=2&amp;group=0').'" title="Zobrazit všechny jeho přeložené texty">'.$UserLine['Name'].'</a></td>'.
-                                        '<td>'.$UserLine['TranslatedCount'].'</td>'.
-                                        '<td>'.$XP['Level'].'</td>'.
-                                        '<td>'.ProgressBar(150, round($XP['XP'] / $XP['MaxXP'] * 100, 2), $XP['XP'].' / '.$XP['MaxXP']).'</td>'.
-                                        '<td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>';
-                }
-                $Output .= '</table>'.
-                                '</form>'.
-                                $PageList['Output'];
-                return($Output);
-        }
-        
-        function ExportViewGeneral()
-        {
-                $DisabledInput = array(false => ' disabled="disabled"', true => '');
-                $DisabledTextArea = array(false => ' readonly="yes"', true => '');
-                $Output = '<h3>Obecná nastavení</h3>';
-                $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                $Export = $DbRows->fetch_assoc();
-                if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
-                else $Editable = false;
-        
-                if(array_key_exists('Operation', $_POST))
-                        if($_POST['Operation'] == 'Save')  if($Editable and array_key_exists('Title', $_POST) and array_key_exists('Description', $_POST))
-                        {
-                                if(array_key_exists('WithDiacritic', $_POST)) $WithDiacritic = 1;
-                                else $WithDiacritic = 0;
-                                if (array_key_exists('Featured', $_POST)) $Export['Featured'] = 1;
-                                $this->System->Database->query('UPDATE `Export` SET `Title`="'.$_POST['Title'].'", `Featured`='.$Export['Featured'].', `Description`="'.$_POST['Description'].'", `WithDiacritic`='.$WithDiacritic.' WHERE Id='.$Export['Id']);
-                                $Export['Title'] = $_POST['Title'];
-                                $Export['Description'] = $_POST['Description'];
-                                $Export['WithDiacritic'] = $WithDiacritic;
-                                $Output .= ShowMessage('Nastavení uloženo.');
-                        }
-        
-                        if($Export['WithDiacritic'] == 1) $WithDiacritic = ' checked="checked"';
-                        else $WithDiacritic = '';
-                        $Output .= '<form action="?Action=View&amp;Tab=0&amp;ExportId='.$Export['Id'].'" method="post">'.
-                                        '<table>';
-                        if($this->System->User->Id != null)
-                        {
-                                $Output .= '<input type="hidden" name="Operation" value="Save"/>'.
-                                                '<tr><td colspan="2">';
+        // Recalculate sequence number
+        $this->System->Database->query('SET @I = 0');
+        $this->System->Database->query('UPDATE `ExportUser` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$_GET['ExportId'].' ORDER BY `Sequence`;');
+        $Output .= ShowMessage(T('Select saved.'));
+      }
+    }
+
+    $TableColumns = array(
+        array('Name' => 'Name', 'Title' => T('Name')),
+        array('Name' => 'TranslatedCount', 'Title' => T('Translated count')),
+        array('Name' => 'XP', 'Title' => T('Level')),
+        array('Name' => 'XP', 'Title' => T('Experience')),
+        array('Name' => '', 'Title' => T('Select')),
+        array('Name' => 'Sequence2', 'Title' => T('Order')),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'TranslatedCount', 1);
+    if($Order['Column'] != 'Sequence2') $InitialOrder = ', '.substr($Order['SQL'], 10);
+    else $InitialOrder = '';
+
+    $Query = 'SELECT (@I := @I + 1) AS `Sequence2`, `TT`.* FROM (SELECT `ExportUser`.`Sequence`, `T`.`ID`, `T`.`TranslatedCount`, `T`.`Name`, `T`.`XP` FROM (SELECT `User`.`ID`, `User`.`Name`, `User`.`XP`, `TranslatedCount` FROM `User`) AS T';
+    $Query .=' LEFT JOIN `ExportUser` ON `ExportUser`.`Export` = '.$_GET['ExportId'].' AND `ExportUser`.`User`=`T`.`ID`';
+    $Query .=' WHERE `T`.`TranslatedCount` > 0 ORDER BY COALESCE(`ExportUser`.`Sequence`, 100000000)'.$InitialOrder.') AS `TT`';
+
+    $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS `X`');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
+
+    $Output .= '<form name="Translators" action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
+        '<h3>'.T('Translators').'</h3>';
+    if($Editable)
+    {
+      $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
+          '<input type="hidden" name="Operation" value="Save"/><br />'.
+          ' <span onclick="CheckAllCheckbox();">'.CheckBox('CheckAll', False, 'CheckAll').' '.T('Select all on page').'</span> <br />'.
+          ' <span>'.CheckBox('AllUsers', $Export['AllUsers']).' '.T('Export allways from all users').'</span> '.
+          '<br />'.
+          T('Select users from list which you want to export from. And edit their order.').'<br />'.
+          T('Order is done by numeric value which is can be edit to desirable order. Lines with same number will be renumbered in ascending order.');
+    }
+
+    $Output .= $PageList['Output'].
+    '<table class="BaseTable">'.
+    $Order['Output'];
+
+    $Query = 'SELECT * FROM ('.$Query.') AS `TX` '.$Order['SQL'].$PageList['SQLLimit'];
+    $this->System->Database->query('SET @I = 0');
+    $DbResult = $this->System->Database->query($Query);
+    while($UserLine = $DbResult->fetch_assoc())
+    {
+      $XP = GetLevelMinMax($UserLine['XP']);
+      $Checked = $UserLine['Sequence'] != '';
+      $Selection = CheckBox('sel'.$UserLine['ID'], $Checked, '', 'CheckBox', ((!$Editable) or ($Export['AllUsers'])));
+      $Sequence = '<input type="text" name="seq'.$UserLine['ID'].'" style="text-align: center; width: 40px;" value="'.$UserLine['Sequence2'].'"'.$DisabledInput[$Editable].'/>';
+      $Output .= '<tr>'.
+          '<td><a href="'.$this->System->Link('/TranslationList.php?user='.$UserLine['ID'].'&amp;state=2&amp;group=0').'" title="Zobrazit všechny jeho přeložené texty">'.$UserLine['Name'].'</a></td>'.
+          '<td>'.$UserLine['TranslatedCount'].'</td>'.
+          '<td>'.$XP['Level'].'</td>'.
+          '<td>'.ProgressBar(150, round($XP['XP'] / $XP['MaxXP'] * 100, 2), $XP['XP'].' / '.$XP['MaxXP']).'</td>'.
+          '<td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>';
+    }
+    $Output .= '</table>'.
+        '</form>'.
+        $PageList['Output'];
+    return($Output);
+  }
+
+  function ExportViewGeneral()
+  {
+    $DisabledInput = array(false => ' disabled="disabled"', true => '');
+    $DisabledTextArea = array(false => ' readonly="yes"', true => '');
+    $Output = '<h3>Obecná nastavení</h3>';
+    $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+    $Export = $DbRows->fetch_assoc();
+    if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
+    else $Editable = false;
+
+    if(array_key_exists('Operation', $_POST))
+      if($_POST['Operation'] == 'Save')  if($Editable and array_key_exists('Title', $_POST) and array_key_exists('Description', $_POST))
+      {
+        if(array_key_exists('WithDiacritic', $_POST)) $WithDiacritic = 1;
+        else $WithDiacritic = 0;
+        if (array_key_exists('Featured', $_POST)) $Export['Featured'] = 1;
+        $this->System->Database->query('UPDATE `Export` SET `Title`="'.$_POST['Title'].'", `Featured`='.$Export['Featured'].', `Description`="'.$_POST['Description'].'", `WithDiacritic`='.$WithDiacritic.' WHERE Id='.$Export['Id']);
+        $Export['Title'] = $_POST['Title'];
+        $Export['Description'] = $_POST['Description'];
+        $Export['WithDiacritic'] = $WithDiacritic;
+        $Output .= ShowMessage('Nastavení uloženo.');
+      }
+
+      if($Export['WithDiacritic'] == 1) $WithDiacritic = ' checked="checked"';
+      else $WithDiacritic = '';
+      $Output .= '<form action="?Action=View&amp;Tab=0&amp;ExportId='.$Export['Id'].'" method="post">'.
+          '<table>';
+      if($this->System->User->Id != null)
+      {
+        $Output .= '<input type="hidden" name="Operation" value="Save"/>'.
+            '<tr><td colspan="2">';
         if($Editable) $Output .= ' <input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/>';
-        $Output .= ' <a href="?Action=Clone&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\''.T('Realy clone item?').'\');">'.T('Clone').'</a> ';
+        $Output .= ' <a href="?Action=Clone&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\''.T('Realy clone item?').'\');">'.T('Clone').'</a> ';
         if($this->System->User->Licence(LICENCE_ADMIN))
           $Output .= CheckBox('Featured', $Export['Featured'], '', 'CheckBox', !$Editable). ' '.T('Recommended').' ';
         $Output .= '</td></tr>';
-                        }
-                        $Output .= '<tr><td>'.T('Identification').':</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].'>'.$Export['Description'].'</textarea></td></tr>'.
-                                        '<tr><td>'.T('With diacritics').'</td><td><input type="checkbox" name="WithDiacritic" '.$WithDiacritic.''.$DisabledInput[$Editable].'/></td></tr>'.
-                                        '</table></form>';
-                        return($Output);
-        }
-        
-        function ExportViewLanguages()
-        {
-                global $TranslationTree;
-        
-                $Output = '';
-                $DisabledInput = array(false => ' disabled="disabled"', true => '');
-                $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                $Export = $DbRows->fetch_assoc();
-                if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
-                else $Editable = false;
-        
-                if(array_key_exists('Operation', $_POST))
-                {
-                        if($_POST['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 = $this->System->Database->query('SELECT * FROM `ExportLanguage` '.$Condition);
-                                                if($DbResult->num_rows > 0)
-                                                {
-                                                        if(!$Selected) $this->System->Database->query('DELETE FROM `ExportLanguage` '.$Condition);
-                                                        else $this->System->Database->query('UPDATE `ExportLanguage` SET `Sequence`='.$Value.$Condition);
-                                                } else
-                                                {
-                                                        if($Selected) $this->System->Database->query('INSERT INTO `ExportLanguage` (`Export`, `Language`, `Sequence`) VALUES ('.$_GET['ExportId'].', '.$LanguageId.', '.$Value.')');
-                                                }
-                                        }
-                                }
-        
-                                // Recalculate sequence number
-                                $this->System->Database->query('SET @I = 0');
-                                $this->System->Database->query('UPDATE `ExportLanguage` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$_GET['ExportId'].' ORDER BY `Sequence`;');
-                                $Output .= ShowMessage('Výběr uložen.');
-                        }
-                }
-        
-                $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 = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS X');
-                $DbRow = $DbResult->fetch_row();
-                $PageList = GetPageList($DbRow[0]);
-        
-                $TableColumns = array(
-                                array('Name' => 'Name', 'Title' => T('Name')),
-                                array('Name' => '', 'Title' => T('Select')),
-                                array('Name' => 'Sequence2', 'Title' => T('Order')),
-                );
-                $Order = GetOrderTableHeader($TableColumns, 'Sequence2');
-                $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
-                                '<h3>'.T('Languages').'</h3>';
-                if($Editable)
-                {
-                        $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
-                                        '<input type="hidden" name="Operation" value="Save"/>'.
-                                        '<br />'.
-                                        T('Select languades from list witch you want to export from. And edit theirs order.').'<br />'.
-                                        T('Order is done by numeric value which is can be edit to desirable order. Lines with same number will be renumbered in ascending order.');
-                }
-        
-                $Output .= $PageList['Output'].
-                '<table class="BaseTable">'.
-                $Order['Output'];
-        
-                $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
-                $this->System->Database->query('SET @I = 0');
-                $DbResult = $this->System->Database->query($Query);
-                while($Langugage = $DbResult->fetch_assoc())
-                {
-                        $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].'/>';
-                        $Output .= '<tr>
-                        <td>'.$Langugage['Name'].'</td>
-                        <td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>';
-                }
-                $Output .= '</table>'.
-                                '</form>'.
-                                $PageList['Output'];
-                return($Output);
-        }
-        
-        function ExportViewGroups()
-        {
-                global $TranslationTree;
-        
-                $Output = '';
-                $DisabledInput = array(false => ' disabled="disabled"', true => '');
-                $DbRows = $this->System->Database->query('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
-                $Export = $DbRows->fetch_assoc();
-                if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
-                else $Editable = false;
-        
-                if(array_key_exists('Operation', $_POST))
-                {
-                        if($_POST['Operation'] == 'Save')
-                        {
-                                //print_r($_POST);
-                                // Update user selection page
-                                foreach($_POST as $Index => $Value)
-                                {
-                                        if(substr($Index, 0, 3) == 'seq')
-                                        {
-                                                $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 = $this->System->Database->query('SELECT * FROM `ExportGroup` '.$Condition);
-                                                if($DbResult->num_rows > 0)
-                                                {
-                                                        if(!$Selected) $this->System->Database->query('DELETE FROM `ExportGroup` '.$Condition);
-                                                } else
-                                                {
-                                                        if($Selected) $this->System->Database->query('INSERT INTO `ExportGroup` (`Export`, `Group`) VALUES ('.$_GET['ExportId'].', '.$GroupId.')');
-                                                }
-                                        }
-                                }
-                                $Output .= ShowMessage(T('Select saved.'));
-                        }
-          //items
-      foreach($TranslationTree as $Group) 
-                {
-                //  echo $Group['Id'].' ';
+      }
+      $Output .= '<tr><td>'.T('Identification').':</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].'>'.$Export['Description'].'</textarea></td></tr>'.
+          '<tr><td>'.T('With diacritics').'</td><td><input type="checkbox" name="WithDiacritic" '.$WithDiacritic.''.$DisabledInput[$Editable].'/></td></tr>'.
+          '</table></form>';
+      return($Output);
+  }
+
+  function ExportViewLanguages()
+  {
+    global $TranslationTree;
+
+    $Output = '';
+    $DisabledInput = array(false => ' disabled="disabled"', true => '');
+    $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+    $Export = $DbRows->fetch_assoc();
+    if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
+    else $Editable = false;
+
+    if(array_key_exists('Operation', $_POST))
+    {
+      if($_POST['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 = $this->System->Database->query('SELECT * FROM `ExportLanguage` '.$Condition);
+            if($DbResult->num_rows > 0)
+            {
+              if(!$Selected) $this->System->Database->query('DELETE FROM `ExportLanguage` '.$Condition);
+              else $this->System->Database->query('UPDATE `ExportLanguage` SET `Sequence`='.$Value.$Condition);
+            } else
+            {
+              if($Selected) $this->System->Database->query('INSERT INTO `ExportLanguage` (`Export`, `Language`, `Sequence`) VALUES ('.$_GET['ExportId'].', '.$LanguageId.', '.$Value.')');
+            }
+          }
+        }
+
+        // Recalculate sequence number
+        $this->System->Database->query('SET @I = 0');
+        $this->System->Database->query('UPDATE `ExportLanguage` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$_GET['ExportId'].' ORDER BY `Sequence`;');
+        $Output .= ShowMessage('Výběr uložen.');
+      }
+    }
+
+    $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 = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS X');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
+
+    $TableColumns = array(
+        array('Name' => 'Name', 'Title' => T('Name')),
+        array('Name' => '', 'Title' => T('Select')),
+        array('Name' => 'Sequence2', 'Title' => T('Order')),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'Sequence2');
+    $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
+        '<h3>'.T('Languages').'</h3>';
+    if($Editable)
+    {
+      $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
+          '<input type="hidden" name="Operation" value="Save"/>'.
+          '<br />'.
+          T('Select languades from list witch you want to export from. And edit theirs order.').'<br />'.
+          T('Order is done by numeric value which is can be edit to desirable order. Lines with same number will be renumbered in ascending order.');
+    }
+
+    $Output .= $PageList['Output'].
+    '<table class="BaseTable">'.
+    $Order['Output'];
+
+    $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
+    $this->System->Database->query('SET @I = 0');
+    $DbResult = $this->System->Database->query($Query);
+    while($Langugage = $DbResult->fetch_assoc())
+    {
+      $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].'/>';
+      $Output .= '<tr>
+      <td>'.$Langugage['Name'].'</td>
+      <td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>';
+    }
+    $Output .= '</table>'.
+        '</form>'.
+        $PageList['Output'];
+    return($Output);
+  }
+
+  function ExportViewGroups()
+  {
+    global $TranslationTree;
+
+    $Output = '';
+    $DisabledInput = array(false => ' disabled="disabled"', true => '');
+    $DbRows = $this->System->Database->query('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+    $Export = $DbRows->fetch_assoc();
+    if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
+    else $Editable = false;
+
+    if(array_key_exists('Operation', $_POST))
+    {
+      if($_POST['Operation'] == 'Save')
+      {
+        //print_r($_POST);
+        // Update user selection page
+        foreach($_POST as $Index => $Value)
+        {
+          if(substr($Index, 0, 3) == 'seq')
+          {
+            $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 = $this->System->Database->query('SELECT * FROM `ExportGroup` '.$Condition);
+            if($DbResult->num_rows > 0)
+            {
+              if(!$Selected) $this->System->Database->query('DELETE FROM `ExportGroup` '.$Condition);
+            } else
+            {
+              if($Selected) $this->System->Database->query('INSERT INTO `ExportGroup` (`Export`, `Group`) VALUES ('.$_GET['ExportId'].', '.$GroupId.')');
+            }
+          }
+        }
+        $Output .= ShowMessage(T('Select saved.'));
+      }
+      //items
+      foreach($TranslationTree as $Group)
+      {
+      //  echo $Group['Id'].' ';
         foreach($TranslationTree[$Group['Id']]['Items'] as $Column) {
           if(array_key_exists('item'.$Column['Id'], $_POST)) $Selected = true;
@@ -452 +452 @@
           //we will save only forbitten collums and need to be visible
           $Selected = !$Selected;
-          if (!$Column['Visible']) $Selected = false;  
-
-                                                $Condition = ' WHERE `Export`='.$_GET['ExportId'].' AND `GroupItem`='.$Column['Id'];
-                                                $DbResult = $this->System->Database->query('SELECT * FROM `ExportGroupItem` '.$Condition);
-                                                if($DbResult->num_rows > 0)
-                                                {
-                                                        if(!$Selected) $this->System->Database->query('DELETE FROM `ExportGroupItem` '.$Condition);
-                                                } else
-                                                {
-                                                        if($Selected) $this->System->Database->query('INSERT INTO `ExportGroupItem` (`Export`, `GroupItem`) VALUES ('.$_GET['ExportId'].', '.$Column['Id'].')');
-                                                }
+          if (!$Column['Visible']) $Selected = false;
+
+            $Condition = ' WHERE `Export`='.$_GET['ExportId'].' AND `GroupItem`='.$Column['Id'];
+            $DbResult = $this->System->Database->query('SELECT * FROM `ExportGroupItem` '.$Condition);
+            if($DbResult->num_rows > 0)
+            {
+              if(!$Selected) $this->System->Database->query('DELETE FROM `ExportGroupItem` '.$Condition);
+            } else
+            {
+              if($Selected) $this->System->Database->query('INSERT INTO `ExportGroupItem` (`Export`, `GroupItem`) VALUES ('.$_GET['ExportId'].', '.$Column['Id'].')');
+            }
 
         }
       }
-                }
-        
-                $Query = 'SELECT `Group`.*, `ExportGroup`.`Id` AS `ExportGroupId` FROM `Group` LEFT JOIN `ExportGroup` ON `ExportGroup`.`Export`='.$_GET['ExportId'].' AND `Group`=`Group`.`Id`';
-        
-                $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS X');
-                $DbRow = $DbResult->fetch_row();
-                $PageList = GetPageList($DbRow[0]);
-        
-                $TableColumns = array(
-                                array('Name' => '', 'Title' => T('Select')),
-                                array('Name' => 'Name', 'Title' => T('Name')),
-                                array('Name' => 'MangosTable', 'Title' => 'Mangos/DBC/Lua'),
-                //              array('Name' => 'DBCFileName', 'Title' => 'DBC soubor'),
-                //              array('Name' => 'LuaFileName', 'Title' => 'Lua soubor'),
-                                array('Name' => '', 'Title' => T('Items of tranlation')),
-                );
-                $Order = GetOrderTableHeader($TableColumns, 'Name');
-                $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
-                                '<h3>Překladové skupiny</h3>';
-                if($Editable)
-                {
-                        $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
-                                        '<input type="hidden" name="Operation" value="Save"/>'.
-                                        ' <span onclick="CheckAllCheckbox();">'.CheckBox('CheckAll', False, 'CheckAll').' '.T('Select all').'</span> '.
-                                        '<br />'.
-                                        T('Select translation groups witch you want to export.').'<br />';
-                }
-        
-                $Output .= $PageList['Output'].
-                '<table class="BaseTable">'.
-                $Order['Output'];
-
-          $DbResultItem = $this->System->Database->query('SELECT * FROM `ExportGroupItem` WHERE `Export`='.$_GET['ExportId']);
-                while($GroupItem = $DbResultItem->fetch_assoc())
-                {
-                  $GroupItems[$GroupItem['GroupItem']] = 1;
-    }
-        
-                $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
-                $DbResult = $this->System->Database->query($Query);
-                while($Group = $DbResult->fetch_assoc())
-                {
+    }
+
+    $Query = 'SELECT `Group`.*, `ExportGroup`.`Id` AS `ExportGroupId` FROM `Group` LEFT JOIN `ExportGroup` ON `ExportGroup`.`Export`='.$_GET['ExportId'].' AND `Group`=`Group`.`Id`';
+
+    $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS X');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
+
+    $TableColumns = array(
+        array('Name' => '', 'Title' => T('Select')),
+        array('Name' => 'Name', 'Title' => T('Name')),
+        array('Name' => 'MangosTable', 'Title' => 'Mangos/DBC/Lua'),
+    //    array('Name' => 'DBCFileName', 'Title' => 'DBC soubor'),
+    //    array('Name' => 'LuaFileName', 'Title' => 'Lua soubor'),
+        array('Name' => '', 'Title' => T('Items of tranlation')),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'Name');
+    $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
+        '<h3>Překladové skupiny</h3>';
+    if($Editable)
+    {
+      $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
+          '<input type="hidden" name="Operation" value="Save"/>'.
+          ' <span onclick="CheckAllCheckbox();">'.CheckBox('CheckAll', False, 'CheckAll').' '.T('Select all').'</span> '.
+          '<br />'.
+          T('Select translation groups witch you want to export.').'<br />';
+    }
+
+    $Output .= $PageList['Output'].
+    '<table class="BaseTable">'.
+    $Order['Output'];
+
+    $DbResultItem = $this->System->Database->query('SELECT * FROM `ExportGroupItem` WHERE `Export`='.$_GET['ExportId']);
+    while($GroupItem = $DbResultItem->fetch_assoc())
+    {
+      $GroupItems[$GroupItem['GroupItem']] = 1;
+    }
+
+    $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
+    $DbResult = $this->System->Database->query($Query);
+    while($Group = $DbResult->fetch_assoc())
+    {
       $Columns = '';
       foreach($TranslationTree[$Group['Id']]['Items'] as $Column) {
         if ($Column['Visible'])  $Columns .= CheckBox('item'.$Column['Id'], !isset($GroupItems[$Column['Id']]), '', 'CheckBox', !$Editable).' '.$Column['Name'].' <br />';
       }
-                        $Checked = $Group['ExportGroupId'] != '';
-                        $Selection = CheckBox('sel'.$Group['Id'], $Checked, '', 'CheckBox', !$Editable);
-                        $Output .= '<tr>'.
-                                        '<td>'.$Selection.'<input type="hidden" name="seq'.$Group['Id'].'"/></td>'.
-                                        '<td>'.$Group['Name'].'</td><td>';
-                                        if ($Group['MangosTable'] <> '')
-                                          $Output .= $Group['MangosTable'].'.sql ';
-                                        if ($Group['LuaFileName'] <> '')
-                                          $Output .= $Group['LuaFileName'].'.lua ';
-                                        if ($Group['DBCFileName'] <> '')
-                                          $Output .= $Group['DBCFileName'].'.dbc ';
-      
-      $Output .=                '</td><td>';
-      $Output .=        $Columns.       '</td>';
+      $Checked = $Group['ExportGroupId'] != '';
+      $Selection = CheckBox('sel'.$Group['Id'], $Checked, '', 'CheckBox', !$Editable);
+      $Output .= '<tr>'.
+          '<td>'.$Selection.'<input type="hidden" name="seq'.$Group['Id'].'"/></td>'.
+          '<td>'.$Group['Name'].'</td><td>';
+          if ($Group['MangosTable'] <> '')
+            $Output .= $Group['MangosTable'].'.sql ';
+          if ($Group['LuaFileName'] <> '')
+            $Output .= $Group['LuaFileName'].'.lua ';
+          if ($Group['DBCFileName'] <> '')
+            $Output .= $Group['DBCFileName'].'.dbc ';
+
+      $Output .=    '</td><td>';
+      $Output .=  $Columns. '</td>';
       $Output .=     '</tr>';
-                }
-                $Output .= '</table>'.
-                                '</form>'.
-                                $PageList['Output'];
-                return($Output);
-        }
-        
-        function ExportViewOutputFormat()
-        {
-                $Output = '';
-                $DisabledInput = array(false => ' disabled="disabled"', true => '');
-                if(array_key_exists('ExportId', $_GET))
-                {
-                        $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                        if($DbRows->num_rows > 0)
-                        {
-                                $Export = $DbRows->fetch_assoc();
-                                if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
-                                else $Editable = false;
-        
-                                if(array_key_exists('Operation', $_POST))
-                                        if($_POST['Operation'] == 'Save')
-                                        {
-                                                if(array_key_exists('OutputType', $_POST) and ($_POST['OutputType'] * 1 > 0))
-                                                {
-                                                  $this->System->Database->query('UPDATE Export SET OutputType='.$_POST['OutputType'].' WHERE Id='.$_GET['ExportId']);
-                                                  $Output .= ShowMessage(T('Select saved.'));
-                                          } else $Output .= ShowMessage(T('Format wasn\'t selected'), MESSAGE_CRITICAL);
-                                        }
-        
-                                        $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                                        $Export = $DbResult->fetch_assoc();
-        
-                                        $Output .= '<h3>'.T('Format the generated output').'</h3>'.
-                                                        '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">';
-                                        if($Editable)
-                                        {
-                                                $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
-                                                                '<input type="hidden" name="Operation" value="Save"/>'.
-                                                                '<br />';
-                                        }
-                                        $DbResult = $this->System->Database->query('SELECT * FROM `ExportOutputType` ORDER BY `Name`');
-                                        while($ExportFormat = $DbResult->fetch_assoc())
-                                        {
-                                                $Output .= RadioButton('OutputType', $ExportFormat['Id'], $Export['OutputType'] == $ExportFormat['Id'], '', !$Editable).' '.$ExportFormat['Name'].'<br/>';
-                                        }
-                                        $Output .= '</form>';
-                        } else $Output .= ShowMessage(T('Item not found'), MESSAGE_CRITICAL);
-                } else $Output .= ShowMessage(T('Is isn\'t select'), MESSAGE_CRITICAL);
-                return($Output);
-        }
-        
-        function ExportViewVersion()
-        {
-                $Output = '';
-                $DisabledInput = array(false => ' disabled="disabled"', true => '');
-                $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                $Export = $DbRows->fetch_assoc();
-                if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
-                else $Editable = false;
-        
-                if(array_key_exists('Operation', $_POST))
-                        if(($_POST['Operation'] == 'Save') and (array_key_exists('ClientVersion', $_POST)))
-                        {
-                                $this->System->Database->query('UPDATE `Export` SET `ClientVersion`='.$_POST['ClientVersion'].' WHERE `Id`='.$_GET['ExportId']);
-                                $Output .= ShowMessage(T('Select saved.'));
-                        }
-        
-                        $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                        $Export = $DbResult->fetch_assoc();
-        
-                        if($Export['OutputType'] == '') $Output .= ShowMessage('Nevybrán typ exportu', MESSAGE_CRITICAL);
-                        else {
-                                $Query = 'SELECT `ClientVersion`.* FROM `ExportVersion` '.
-                                  'LEFT JOIN `ClientVersion` ON `ClientVersion`.`Id`=`ExportVersion`.`ClientVersion` WHERE `ExportType`='.$Export['OutputType'];
-        
-                                $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS `X`');
-                                $DbRow = $DbResult->fetch_row();
-                                $PageList = GetPageList($DbRow[0]);
-        
-                                $TableColumns = array(
-                                                array('Name' => 'Version', 'Title' => T('Version')),
-                                                array('Name' => 'BuildNumber', 'Title' => T('Build')),
-                                                array('Name' => 'ReleaseDate', 'Title' => T('Release date')),
-                                                array('Name' => 'Title', 'Title' => T('Name2')),
-                                                array('Name' => '', 'Title' => T('Select')),
-                                );
-                                $Order = GetOrderTableHeader($TableColumns, 'BuildNumber', 1);
-                                $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
-                                                '<h3>'.T('Client version').'</h3>';
-        
-                                if($Editable)
-                                {
-                                        $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
-                                                        '<input type="hidden" name="Operation" value="Save"/>'.
-                                                        '<br />'.
-                                                        T('Select version of game client witch you want to export.').'<br />';
-                                }
-                                $Output .= $PageList['Output'].
-                                '<table class="BaseTable">'.
-                                $Order['Output'];
-        
-                                $Query = 'SELECT * FROM ('.$Query.') AS `TX` '.$Order['SQL'].$PageList['SQLLimit'];
-                                $DbResult = $this->System->Database->query($Query);
-                                while($Version = $DbResult->fetch_assoc())
-                                {
-                                        $Output .= '<tr><td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.$Version['Id']).'">'.
-                                                        $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>';
-        
-                                }
-                                $Output .= '</table>'.
-                                                '</form>'.
-                                                $PageList['Output'];
-                        }
-                        return($Output);
-        }
-        
-        function ExportViewOutput()
-        {
-                $Output = '';
-                $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                $Export = $DbResult->fetch_assoc();
-                if($Export['OutputType'] == '') $Output .= ShowMessage('Nevybrán typ exportu', MESSAGE_CRITICAL);
-                else if($Export['ClientVersion'] == '') $Output .= ShowMessage(T('Export don\'t have selected version of client'), MESSAGE_CRITICAL);
-                else {
-                        $DbResult = $this->System->Database->query('SELECT * FROM `ExportOutputType` WHERE `Id`='.$Export['OutputType']);
-                        if($DbResult->num_rows > 0)
-                        {
-                                $DbResult = $this->System->Database->query('SELECT * FROM `ExportVersion` WHERE (`ExportType`='.$Export['OutputType'].') AND (`ClientVersion`='.$Export['ClientVersion'].')');
-                                if($DbResult->num_rows > 0)
-                                {
-                                  if (array_key_exists('Auto', $_GET) == false)  
-                                          $this->System->Database->query('UPDATE `Export` SET `UsedCount` = `UsedCount` + 1 WHERE `Id`='.$Export['Id']);
-                                        $Output = ExportOutput($Export['Id'], $Export['OutputType']);
-                                } else $Output = ShowMessage(T('Export don\'t have selected version of client'), MESSAGE_CRITICAL);
-                        } else $Output = ShowMessage(T('Format output isn\'t select').'.', MESSAGE_CRITICAL);
-                }
-                return($Output);
-        }
-        
-        function ExportViewStat($Where = '')
-        {
-                $Export = new Export($this->System);
-                $Export->Id = $_GET['ExportId'];
-                $Export->Init();
-                $Export->LoadFilters();
-        
-                if(($Export->Export['ClientVersion'] == '') or ($Export->ClientVersion['BuildNumber'] == ''))
-                        $Output = ShowMessage(T('Export don\'t have selected version of client'), MESSAGE_CRITICAL);
-                else {
-                        $GroupListQuery = 'SELECT `Group`.* FROM `Group` '.
-                                        ' JOIN `ExportGroup` ON (`ExportGroup`.`Export`='.$Export->Id.') AND (`ExportGroup`.`Group`=`Group`.`Id`)';
-                        $Query = '';
-                        $UnionItems = array();
-                        $DbResult = $this->System->Database->query($GroupListQuery.$Where);
-                        while($DbRow = $DbResult->fetch_assoc())
-                        {
-                                $UnionItems[] = 'SELECT (SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
-                                                ' SELECT `T`.* FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
-                                                ' JOIN `ExportUser` ON (`ExportUser`.`User`=`T`.`User`) AND (`ExportUser`.`Export`='.$Export->Id.') '.
-                                                ' JOIN `ExportLanguage` ON (`ExportLanguage`.`Export`='.$Export->Id.')'.
-                                                ' WHERE (`Complete` = 1) AND (`VersionStart` <= '.$Export->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$Export->ClientVersion['BuildNumber'].')'.
-                                                ') AS `C1`) AS `Translated`, '.
-                                                '(SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
-                                                ' SELECT `T`.* FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
-                                                ' WHERE (`Language` = '.$this->System->Config['OriginalLanguage'].') AND (`VersionStart` <= '.$Export->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$Export->ClientVersion['BuildNumber'].')'.
-                                                ') AS `C2`) AS `Total`, "'.$DbRow['Name'].'" AS `Name`';
-                        }
-                        $Query = substr($Query, 0, - 6);
-        
-                        $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$GroupListQuery.') AS `T`');
-                        $DbRow = $DbResult->fetch_row();
-                        $PageList = GetPageList($DbRow[0]);
-                        $Output = '<h3>'.T('Statistic of coplection selected groups').'</h3>'.
-                                $PageList['Output'];
-        
-                        $Output .= '<table class="BaseTable">';
-                        $TableColumns = array(
-                                array('Name' => 'Name', 'Title' => T('Name')),
-                                array('Name' => 'Translated', 'Title' => T('Translated count')),
-                                array('Name' => 'Total', 'Title' => T('English')),
-                                array('Name' => 'Percent', 'Title' => T('Percent')),
-                        );
-        
-                        $Order = GetOrderTableHeader($TableColumns, 'Name', 0);
-                        $Output .= $Order['Output'];
-        
-                        $Translated = 0;
-                        $Total = 0;
-                        if(count($UnionItems) > 0)
-                        {
-                                $ID = $this->System->Database->query('SELECT *, ROUND(`Translated` / `Total` * 100, 2) AS `Percent` FROM ('.implode(' UNION ALL ', $UnionItems).') AS `C3` '.$Order['SQL'].$PageList['SQLLimit']);
-                                while($Group = $ID->fetch_assoc())
-                                {
-                                        $Output .= '<tr><td>'.$Group['Name'].'</td><td>'.$Group['Translated'].'</td><td>'.$Group['Total'].'</td><td>'.ProgressBar(150, $Group['Percent']).'</td></tr>';
-                                        $Translated += $Group['Translated'];
-                                        $Total += $Group['Total'];
-                                }
-                        }
-                        if($Total > 0) $Percent = $Translated / $Total * 100;
-                        else $Percent = 100;
-        
-                        $Output .= '<tr><td><strong>'.T('Altogether').'</strong></td><td><strong>'.$Translated.'</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.ProgressBar(150, round($Percent, 2)).'</strong></td></tr>';
-                        $Output .= '</table>';
-                }
-                return($Output);
-        }
-        
-        function ExportView()
-        {
-                $Output = '';
-                if(array_key_exists('ExportId', $_GET) and is_numeric($_GET['ExportId']))
-                {
-                        $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                        if($DbResult->num_rows > 0)
-                        {
-                                $Export = $DbResult->fetch_assoc();
-        
-                                $DbResult = $this->System->Database->query('SELECT * FROM `User` WHERE `ID`='.$Export['User']);
-                                $UserLine = $DbResult->fetch_assoc();
-                                $Output .= 'Export <strong><a href="?Action=View&amp;Tab=6&amp;ExportId='.$Export['Id'].'">'.$_GET['ExportId'].'</a></strong> překladatele <strong>'.$UserLine['Name'].'</strong> s označením <strong>'.$Export['Title'].'</strong>';
-                                $Output .= ShowTabs(array(T('General'), T('Translators'), 'Překlady', T('Languages'), T('Format'), T('Version'), T('Statistic'), T('Output')));
-                                $Output .= '<div id="content">';
-                                if($_SESSION['Tab'] == TAB_GENERAL) $Output .= $this->ExportViewGeneral();
-                                else if($_SESSION['Tab'] == TAB_TRANSLATORS) $Output .= $this->ExportViewTranslators();
-                                else if($_SESSION['Tab'] == TAB_GROUPS) $Output .= $this->ExportViewGroups();
-                                else if($_SESSION['Tab'] == TAB_LANGUAGES) $Output .= $this->ExportViewLanguages();
-                                else if($_SESSION['Tab'] == TAB_OUTPUT_FORMAT) $Output .= $this->ExportViewOutputFormat();
-                                else if($_SESSION['Tab'] == TAB_VERSION) $Output .= $this->ExportViewVersion();
-                                else if($_SESSION['Tab'] == TAB_STAT) $Output .= $this->ExportViewStat();
-                                else if($_SESSION['Tab'] == TAB_OUTPUT) $Output .= $this->ExportViewOutput();
-                                else $Output .= $this->ExportViewGeneral();
-        
-                                $Output .= '</div>';
-                        } else $Output .= ShowMessage(T('Export not found.'), MESSAGE_CRITICAL);
-                } else $Output .= ShowMessage(T('Is isn\'t select'), MESSAGE_CRITICAL);
-                return($Output);
-        }
-        
-        function ExportClone()
-        {
-                if($this->System->User->Licence(LICENCE_USER))
-                {
-                        if(array_key_exists('ExportId', $_GET) and is_numeric($_GET['ExportId']))
-                        {
-                                $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `User`='.$this->System->User->Id);
-                                $DbRow = $DbResult->fetch_row();
-                                if($DbRow[0] < $this->System->Config['MaxExportPerUser'])
-                                {
-                                  $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-                                  if($DbResult->num_rows > 0)
-                                  {
-                                    $DbRow = $DbResult->fetch_assoc();
-                                    unset($DbRow['Id']);
-                                    $DbRow['UsedCount'] = '0';
-                                    $DbRow['User'] = $this->System->User->Id;                             
-                                    $DbRow['TimeCreate'] = 'NOW()';
-                                    $DbRow['Title'] .= ' - '.T('clone');
+    }
+    $Output .= '</table>'.
+        '</form>'.
+        $PageList['Output'];
+    return($Output);
+  }
+
+  function ExportViewOutputFormat()
+  {
+    $Output = '';
+    $DisabledInput = array(false => ' disabled="disabled"', true => '');
+    if(array_key_exists('ExportId', $_GET))
+    {
+      $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+      if($DbRows->num_rows > 0)
+      {
+        $Export = $DbRows->fetch_assoc();
+        if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
+        else $Editable = false;
+
+        if(array_key_exists('Operation', $_POST))
+          if($_POST['Operation'] == 'Save')
+          {
+            if(array_key_exists('OutputType', $_POST) and ($_POST['OutputType'] * 1 > 0))
+            {
+              $this->System->Database->query('UPDATE Export SET OutputType='.$_POST['OutputType'].' WHERE Id='.$_GET['ExportId']);
+              $Output .= ShowMessage(T('Select saved.'));
+            } else $Output .= ShowMessage(T('Format wasn\'t selected'), MESSAGE_CRITICAL);
+          }
+
+          $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+          $Export = $DbResult->fetch_assoc();
+
+          $Output .= '<h3>'.T('Format the generated output').'</h3>'.
+              '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">';
+          if($Editable)
+          {
+            $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
+                '<input type="hidden" name="Operation" value="Save"/>'.
+                '<br />';
+          }
+          $DbResult = $this->System->Database->query('SELECT * FROM `ExportOutputType` ORDER BY `Name`');
+          while($ExportFormat = $DbResult->fetch_assoc())
+          {
+            $Output .= RadioButton('OutputType', $ExportFormat['Id'], $Export['OutputType'] == $ExportFormat['Id'], '', !$Editable).' '.$ExportFormat['Name'].'<br/>';
+          }
+          $Output .= '</form>';
+      } else $Output .= ShowMessage(T('Item not found'), MESSAGE_CRITICAL);
+    } else $Output .= ShowMessage(T('Is isn\'t select'), MESSAGE_CRITICAL);
+    return($Output);
+  }
+
+  function ExportViewVersion()
+  {
+    $Output = '';
+    $DisabledInput = array(false => ' disabled="disabled"', true => '');
+    $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+    $Export = $DbRows->fetch_assoc();
+    if($this->System->User->Licence(LICENCE_USER) and ($this->System->User->Id == $Export['User'])) $Editable = true;
+    else $Editable = false;
+
+    if(array_key_exists('Operation', $_POST))
+      if(($_POST['Operation'] == 'Save') and (array_key_exists('ClientVersion', $_POST)))
+      {
+        $this->System->Database->query('UPDATE `Export` SET `ClientVersion`='.$_POST['ClientVersion'].' WHERE `Id`='.$_GET['ExportId']);
+        $Output .= ShowMessage(T('Select saved.'));
+      }
+
+      $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+      $Export = $DbResult->fetch_assoc();
+
+      if($Export['OutputType'] == '') $Output .= ShowMessage('Nevybrán typ exportu', MESSAGE_CRITICAL);
+      else {
+        $Query = 'SELECT `ClientVersion`.* FROM `ExportVersion` '.
+          'LEFT JOIN `ClientVersion` ON `ClientVersion`.`Id`=`ExportVersion`.`ClientVersion` WHERE `ExportType`='.$Export['OutputType'];
+
+        $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS `X`');
+        $DbRow = $DbResult->fetch_row();
+        $PageList = GetPageList($DbRow[0]);
+
+        $TableColumns = array(
+            array('Name' => 'Version', 'Title' => T('Version')),
+            array('Name' => 'BuildNumber', 'Title' => T('Build')),
+            array('Name' => 'ReleaseDate', 'Title' => T('Release date')),
+            array('Name' => 'Title', 'Title' => T('Name2')),
+            array('Name' => '', 'Title' => T('Select')),
+        );
+        $Order = GetOrderTableHeader($TableColumns, 'BuildNumber', 1);
+        $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
+            '<h3>'.T('Client version').'</h3>';
+
+        if($Editable)
+        {
+          $Output .= '<input type="submit" value="'.T('Save').'" '.$DisabledInput[$Editable].'/>'.
+              '<input type="hidden" name="Operation" value="Save"/>'.
+              '<br />'.
+              T('Select version of game client witch you want to export.').'<br />';
+        }
+        $Output .= $PageList['Output'].
+        '<table class="BaseTable">'.
+        $Order['Output'];
+
+        $Query = 'SELECT * FROM ('.$Query.') AS `TX` '.$Order['SQL'].$PageList['SQLLimit'];
+        $DbResult = $this->System->Database->query($Query);
+        while($Version = $DbResult->fetch_assoc())
+        {
+          $Output .= '<tr><td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.$Version['Id']).'">'.
+              $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>';
+
+        }
+        $Output .= '</table>'.
+            '</form>'.
+            $PageList['Output'];
+      }
+      return($Output);
+  }
+
+  function ExportViewOutput()
+  {
+    $Output = '';
+    $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+    $Export = $DbResult->fetch_assoc();
+    if($Export['OutputType'] == '') $Output .= ShowMessage('Nevybrán typ exportu', MESSAGE_CRITICAL);
+    else if($Export['ClientVersion'] == '') $Output .= ShowMessage(T('Export don\'t have selected version of client'), MESSAGE_CRITICAL);
+    else {
+      $DbResult = $this->System->Database->query('SELECT * FROM `ExportOutputType` WHERE `Id`='.$Export['OutputType']);
+      if($DbResult->num_rows > 0)
+      {
+        $DbResult = $this->System->Database->query('SELECT * FROM `ExportVersion` WHERE (`ExportType`='.$Export['OutputType'].') AND (`ClientVersion`='.$Export['ClientVersion'].')');
+        if($DbResult->num_rows > 0)
+        {
+          if (array_key_exists('Auto', $_GET) == false)
+            $this->System->Database->query('UPDATE `Export` SET `UsedCount` = `UsedCount` + 1 WHERE `Id`='.$Export['Id']);
+          $Output = ExportOutput($Export['Id'], $Export['OutputType']);
+        } else $Output = ShowMessage(T('Export don\'t have selected version of client'), MESSAGE_CRITICAL);
+      } else $Output = ShowMessage(T('Format output isn\'t select').'.', MESSAGE_CRITICAL);
+    }
+    return($Output);
+  }
+
+  function ExportViewStat($Where = '')
+  {
+    $Export = new Export($this->System);
+    $Export->Id = $_GET['ExportId'];
+    $Export->Init();
+    $Export->LoadFilters();
+
+    if(($Export->Export['ClientVersion'] == '') or ($Export->ClientVersion['BuildNumber'] == ''))
+      $Output = ShowMessage(T('Export don\'t have selected version of client'), MESSAGE_CRITICAL);
+    else {
+      $GroupListQuery = 'SELECT `Group`.* FROM `Group` '.
+          ' JOIN `ExportGroup` ON (`ExportGroup`.`Export`='.$Export->Id.') AND (`ExportGroup`.`Group`=`Group`.`Id`)';
+      $Query = '';
+      $UnionItems = array();
+      $DbResult = $this->System->Database->query($GroupListQuery.$Where);
+      while($DbRow = $DbResult->fetch_assoc())
+      {
+        $UnionItems[] = 'SELECT (SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
+            ' SELECT `T`.* FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
+            ' JOIN `ExportUser` ON (`ExportUser`.`User`=`T`.`User`) AND (`ExportUser`.`Export`='.$Export->Id.') '.
+            ' JOIN `ExportLanguage` ON (`ExportLanguage`.`Export`='.$Export->Id.')'.
+            ' WHERE (`Complete` = 1) AND (`VersionStart` <= '.$Export->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$Export->ClientVersion['BuildNumber'].')'.
+            ') AS `C1`) AS `Translated`, '.
+            '(SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
+            ' SELECT `T`.* FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
+            ' WHERE (`Language` = '.$this->System->Config['OriginalLanguage'].') AND (`VersionStart` <= '.$Export->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$Export->ClientVersion['BuildNumber'].')'.
+            ') AS `C2`) AS `Total`, "'.$DbRow['Name'].'" AS `Name`';
+      }
+      $Query = substr($Query, 0, - 6);
+
+      $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$GroupListQuery.') AS `T`');
+      $DbRow = $DbResult->fetch_row();
+      $PageList = GetPageList($DbRow[0]);
+      $Output = '<h3>'.T('Statistic of coplection selected groups').'</h3>'.
+        $PageList['Output'];
+
+      $Output .= '<table class="BaseTable">';
+      $TableColumns = array(
+        array('Name' => 'Name', 'Title' => T('Name')),
+        array('Name' => 'Translated', 'Title' => T('Translated count')),
+        array('Name' => 'Total', 'Title' => T('English')),
+        array('Name' => 'Percent', 'Title' => T('Percent')),
+      );
+
+      $Order = GetOrderTableHeader($TableColumns, 'Name', 0);
+      $Output .= $Order['Output'];
+
+      $Translated = 0;
+      $Total = 0;
+      if(count($UnionItems) > 0)
+      {
+        $ID = $this->System->Database->query('SELECT *, ROUND(`Translated` / `Total` * 100, 2) AS `Percent` FROM ('.implode(' UNION ALL ', $UnionItems).') AS `C3` '.$Order['SQL'].$PageList['SQLLimit']);
+        while($Group = $ID->fetch_assoc())
+        {
+          $Output .= '<tr><td>'.$Group['Name'].'</td><td>'.$Group['Translated'].'</td><td>'.$Group['Total'].'</td><td>'.ProgressBar(150, $Group['Percent']).'</td></tr>';
+          $Translated += $Group['Translated'];
+          $Total += $Group['Total'];
+        }
+      }
+      if($Total > 0) $Percent = $Translated / $Total * 100;
+      else $Percent = 100;
+
+      $Output .= '<tr><td><strong>'.T('Altogether').'</strong></td><td><strong>'.$Translated.'</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.ProgressBar(150, round($Percent, 2)).'</strong></td></tr>';
+      $Output .= '</table>';
+    }
+    return($Output);
+  }
+
+  function ExportView()
+  {
+    $Output = '';
+    if(array_key_exists('ExportId', $_GET) and is_numeric($_GET['ExportId']))
+    {
+      $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+      if($DbResult->num_rows > 0)
+      {
+        $Export = $DbResult->fetch_assoc();
+
+        $DbResult = $this->System->Database->query('SELECT * FROM `User` WHERE `ID`='.$Export['User']);
+        $UserLine = $DbResult->fetch_assoc();
+        $Output .= 'Export <strong><a href="?Action=View&amp;Tab=6&amp;ExportId='.$Export['Id'].'">'.$_GET['ExportId'].'</a></strong> překladatele <strong>'.$UserLine['Name'].'</strong> s označením <strong>'.$Export['Title'].'</strong>';
+        $Output .= ShowTabs(array(T('General'), T('Translators'), 'Překlady', T('Languages'), T('Format'), T('Version'), T('Statistic'), T('Output')));
+        $Output .= '<div id="content">';
+        if($_SESSION['Tab'] == TAB_GENERAL) $Output .= $this->ExportViewGeneral();
+        else if($_SESSION['Tab'] == TAB_TRANSLATORS) $Output .= $this->ExportViewTranslators();
+        else if($_SESSION['Tab'] == TAB_GROUPS) $Output .= $this->ExportViewGroups();
+        else if($_SESSION['Tab'] == TAB_LANGUAGES) $Output .= $this->ExportViewLanguages();
+        else if($_SESSION['Tab'] == TAB_OUTPUT_FORMAT) $Output .= $this->ExportViewOutputFormat();
+        else if($_SESSION['Tab'] == TAB_VERSION) $Output .= $this->ExportViewVersion();
+        else if($_SESSION['Tab'] == TAB_STAT) $Output .= $this->ExportViewStat();
+        else if($_SESSION['Tab'] == TAB_OUTPUT) $Output .= $this->ExportViewOutput();
+        else $Output .= $this->ExportViewGeneral();
+
+        $Output .= '</div>';
+      } else $Output .= ShowMessage(T('Export not found.'), MESSAGE_CRITICAL);
+    } else $Output .= ShowMessage(T('Is isn\'t select'), MESSAGE_CRITICAL);
+    return($Output);
+  }
+
+  function ExportClone()
+  {
+    if($this->System->User->Licence(LICENCE_USER))
+    {
+      if(array_key_exists('ExportId', $_GET) and is_numeric($_GET['ExportId']))
+      {
+        $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `User`='.$this->System->User->Id);
+        $DbRow = $DbResult->fetch_row();
+        if($DbRow[0] < $this->System->Config['MaxExportPerUser'])
+        {
+          $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+          if($DbResult->num_rows > 0)
+          {
+            $DbRow = $DbResult->fetch_assoc();
+            unset($DbRow['Id']);
+            $DbRow['UsedCount'] = '0';
+            $DbRow['User'] = $this->System->User->Id;
+            $DbRow['TimeCreate'] = 'NOW()';
+            $DbRow['Title'] .= ' - '.T('clone');
             $DbRow['Featured'] = 0;
-                                          $this->System->Database->insert('Export', $DbRow);
-                                    $ExportId = $this->System->Database->insert_id;                                     
-                                    $this->System->Database->query('INSERT INTO `ExportGroup` (SELECT NULL AS `Id`, '.$ExportId.' AS `Export`, `Group` FROM `ExportGroup` WHERE `Export`='.$_GET['ExportId'].')');
-                                    $this->System->Database->query('INSERT INTO `ExportGroupItem` (SELECT NULL AS `Id`, '.$ExportId.' AS `Export`, `GroupItem` FROM `ExportGroupItem` WHERE `Export`='.$_GET['ExportId'].')');
-                                    $this->System->Database->query('INSERT INTO `ExportLanguage` (SELECT NULL AS `Id`, '.$ExportId.' AS `Export`, `Language`, `Sequence` FROM `ExportLanguage` WHERE `Export`='.$_GET['ExportId'].')');
-                                    $this->System->Database->query('INSERT INTO `ExportUser` (SELECT NULL AS `Id`, '.$ExportId.' AS `Export`, `User`, `Sequence` FROM `ExportUser` WHERE `Export`='.$_GET['ExportId'].')');
-                                          $Output = ShowMessage(T('Clone export created.<br />Direct link to export').': <a href="?Action=View&amp;ExportId='.$ExportId.'">zde</a>');
-                                          $this->System->ModuleManager->Modules['Log']->WriteLog(T('Clone export created').' <a href="'.$this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">'.$ExportId.'</a>.', LOG_TYPE_EXPORT);
-                                          $_GET['Filter'] = 'my';
-                                          $this->ExportList();
-                                        } else $Output = ShowMessage('Zdrojový export nenalezen', MESSAGE_CRITICAL);
-                                } else $Output = ShowMessage('Nemůžete vytvářet další export. Max. počet na uživatele je '.
-                                        $this->System->Config['MaxExportPerUser'].'.', MESSAGE_CRITICAL);
-                        } else $Output = ShowMessage(T('Export not found.'), MESSAGE_CRITICAL);
-                } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
-                return($Output);
-        }
-        
-        function Show()
-  {
-        $this->Title = T('Export');
+            $this->System->Database->insert('Export', $DbRow);
+            $ExportId = $this->System->Database->insert_id;
+            $this->System->Database->query('INSERT INTO `ExportGroup` (SELECT NULL AS `Id`, '.$ExportId.' AS `Export`, `Group` FROM `ExportGroup` WHERE `Export`='.$_GET['ExportId'].')');
+            $this->System->Database->query('INSERT INTO `ExportGroupItem` (SELECT NULL AS `Id`, '.$ExportId.' AS `Export`, `GroupItem` FROM `ExportGroupItem` WHERE `Export`='.$_GET['ExportId'].')');
+            $this->System->Database->query('INSERT INTO `ExportLanguage` (SELECT NULL AS `Id`, '.$ExportId.' AS `Export`, `Language`, `Sequence` FROM `ExportLanguage` WHERE `Export`='.$_GET['ExportId'].')');
+            $this->System->Database->query('INSERT INTO `ExportUser` (SELECT NULL AS `Id`, '.$ExportId.' AS `Export`, `User`, `Sequence` FROM `ExportUser` WHERE `Export`='.$_GET['ExportId'].')');
+            $Output = ShowMessage(T('Clone export created.<br />Direct link to export').': <a href="?Action=View&amp;ExportId='.$ExportId.'">zde</a>');
+            $this->System->ModuleManager->Modules['Log']->WriteLog(T('Clone export created').' <a href="'.$this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">'.$ExportId.'</a>.', LOG_TYPE_EXPORT);
+            $_GET['Filter'] = 'my';
+            $this->ExportList();
+          } else $Output = ShowMessage('Zdrojový export nenalezen', MESSAGE_CRITICAL);
+        } else $Output = ShowMessage('Nemůžete vytvářet další export. Max. počet na uživatele je '.
+          $this->System->Config['MaxExportPerUser'].'.', MESSAGE_CRITICAL);
+      } else $Output = ShowMessage(T('Export not found.'), MESSAGE_CRITICAL);
+    } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
+    return($Output);
+  }
+
+  function Show()
+  {
+    $this->Title = T('Export');
     if(array_key_exists('Action', $_GET))
     {
@@ -820 +820 @@
     } else $Output = $this->ExportList();
     return($Output);
-  } 
+  }
 }

trunk/Modules/Export/ProcessAoWoWExport.php

@@ -5 +5 @@
 include_once('../../includes/global.php');
 //include_once('../../includes/dbc.php');
-include_once('Export.php');    
-include_once('Page.php');    
+include_once('Export.php');
+include_once('Page.php');
 
   $System = new System();
   $System->DoNotShowPage = true;
-        $System->Run();
+    $System->Run();
 
 $Output = '';
 
-if(defined('STDIN') == false) 
+if(defined('STDIN') == false)
 {
   $Output = T('Access denied');
   exit($Output);
-} 
+}
 
 foreach($_SERVER['argv'] as $parameter)
@@ -36 +36 @@
   $Export->Id = $Config['AoWoWExportId'];
 } else $Export->Id = 37;
-  $Output .= $Export->Init();                   
+  $Output .= $Export->Init();
   $SQL = $Export->ExportToAoWoWSQL();
 echo 'Hotovo
@@ -89 +89 @@
 }
 $Files = scandir(dirname(__FILE__).'/../../aowow/cache/templates/wowhead');
-foreach($Files as $File) 
+foreach($Files as $File)
 {
   $End = substr($File, strlen($File) - 3);

trunk/Modules/Export/ProcessTask.php

@@ -12 +12 @@
   $System = new System();
   $System->DoNotShowPage = true;
-        $System->Run();
+    $System->Run();
 
 function SetProgress($Export,$per) {

trunk/Modules/Export/Progress.php

@@ -2 +2 @@
 
 include_once(dirname(__FILE__).'/../../includes/global.php');
-  
+
   $System = new System();
   $System->DoNotShowPage = true;
   $System->Run();
-    
+
 
     $Output = '';
@@ -12 +12 @@
     ' LEFT JOIN `Export` ON `Export`.`Id` = `ExportTask`.`Export` WHERE  (`Export`.`OutputType` = 9 OR  `Export`.`OutputType` = 10 ) AND `TimeFinish` IS NULL  OR `Export` ='.$_GET['RedirectId'].' ORDER BY `Progress` DESC');// `Export`='.$Export->Id
     while($Task = $DbResult->fetch_assoc()) {
-      $Export = '<a href="'.$System->Link('/export/?Action=View&ExportId='.$Task['Export']).'">'.$Task['Export'].'</a>';         
+      $Export = '<a href="'.$System->Link('/export/?Action=View&ExportId='.$Task['Export']).'">'.$Task['Export'].'</a>';
       if ($_GET['RedirectId'] == $Task['Export'])
         $Export = ''.$Export.' (tento)';
@@ -19 +19 @@
       'setTimeout("parent.location.href=\''.$System->Link('/export/?Action=View&Tab=7&ExportId='.$_GET['RedirectId']).'\'", 500)'.
       '</script>';
-    }    
+    }
 
     echo $Output;

trunk/Modules/Export/cmdmpqexport.php

@@ -5 +5 @@
 include_once(dirname(__FILE__).'/../../includes/global.php');
 //include_once('../../includes/dbc.php');
-include_once('Export.php');    
-include_once('Page.php');    
+include_once('Export.php');
+include_once('Page.php');
 
   $System = new System();
   $System->DoNotShowPage = true;
-        $System->Run();
+    $System->Run();
 $PageExport = new PageExport($System);
 
@@ -17 +17 @@
 $Output = '';
 
-if(defined('STDIN') == false) 
+if(defined('STDIN') == false)
 {
   $Output = T('Access denied');
   exit($Output);
-} 
+}
 
 foreach($_SERVER['argv'] as $parameter)
@@ -37 +37 @@
   $Output .= 'Usage ExportId=id_export - for write export info<br />';
   $Output .= 'Usage needgeneration=id_export - for write export info<br />';
-  
+
   $Output .= 'type_export={lua,dbc,addon} <br />';
   $Output = str_replace('<br />','
@@ -46 +46 @@
   $Export = new Export($System);
   $Export->Id = $_GET['lua'];
-  $Output .= $Export->Init();                   
+  $Output .= $Export->Init();
   $Output .= $Export->ExportToLua();
   $Output = str_replace('<br/>','
@@ -56 +56 @@
   $Export = new Export($System);
   $Export->Id = $_GET['version'];
-  $Export->LoadFilters();   
+  $Export->LoadFilters();
   $Output .= $Export->ClientVersion['Version'];
   $Output = str_replace('<br/>','
@@ -66 +66 @@
   $Export = new Export($System);
   $Export->Id = $_GET['dbc'];
-  $Output .= $Export->Init();                   
+  $Output .= $Export->Init();
   $Output .= $Export->ExportToDbc();
   $Output = str_replace('<br/>','
@@ -85 +85 @@
 
 if(array_key_exists('needgeneration', $_GET)) {
-        $DbRows = $System->Database->query('SELECT `ClientVersion`.`Version` as Version, `Export`.`Id`,`Export`.`ClientVersion`,`Export`.`OutputType`,`Export`.`Title`,`Export`.`Description` FROM `Export` JOIN `ClientVersion` as `ClientVersion` ON `ClientVersion`.`Id`=`Export`.`ClientVersion` WHERE `Featured`=1 ORDER BY `ClientVersion`.`BuildNumber` DESC');
+  $DbRows = $System->Database->query('SELECT `ClientVersion`.`Version` as Version, `Export`.`Id`,`Export`.`ClientVersion`,`Export`.`OutputType`,`Export`.`Title`,`Export`.`Description` FROM `Export` JOIN `ClientVersion` as `ClientVersion` ON `ClientVersion`.`Id`=`Export`.`ClientVersion` WHERE `Featured`=1 ORDER BY `ClientVersion`.`BuildNumber` DESC');
   while ($DbExport = $DbRows->fetch_assoc()) {
   $Export = new Export($System);
   $Export->Id = $DbExport['Id'];
-  $Output .= $Export->Init();                   
+  $Output .= $Export->Init();
   if ($Export->NeedGeneration()) {
     $DbResult = $System->Database->query('SELECT * FROM ExportTask WHERE Export = '.$Export->Id);
@@ -95 +95 @@
     {
       $System->Database->query('INSERT INTO ExportTask (`Export` ,`TimeStart` ) VALUES ('.$Export->Id.', NOW())');
-    } else  
+    } else
       $System->Database->query('UPDATE ExportTask SET `TimeStart` = NOW(), `Progress` = 0, `TimeFinish` = NULL WHERE Export = '.$Export->Id);
 
@@ -113 +113 @@
   $Export = new Export($System);
   $Export->Id = $_GET['ExportId'];
-  $Export->LoadFilters();  
-  
+  $Export->LoadFilters();
+
   //generation readme
   $Output .= '<?xml version="1.0" encoding="utf-8"?\>'.
@@ -129 +129 @@
   '<meta http-equiv="content-type" content="application/xhtml+xml; charset=utf-8" />'.
   '<title>Čeština pro WoW</title>'.
-'</head><body>'. 
+'</head><body>'.
 '<h1>České WoW - čestina pro klienta hry World of Warcraft</h1>'.
- 
+
 '<table cellspacing="10"><tr><td valign="top">'.
- 
+
 '<p>Texty přebírány z projektu <a href="http://wowpreklad.zdechov.net/">wowpreklad.zdechov.net</a><br>'.
 '<a href="http://wowpreklad.zdechov.net/export/?Action=View&ExportId='.$_GET['ExportId'].'&Tab=0">Export '.$_GET['ExportId'].'</a></p><br>'.
- 
- 
+
+
 '<p><strong>Vlastnosti</strong>'.
 '<ul>'.
@@ -148 +148 @@
 '</p>'.
 '<br>'.
- 
+
 '<h2>Nejčastější otázky</h2>'.
 '<p><strong>Jak mám hru spustit?</strong><br>'.
@@ -155 +155 @@
 '<p><strong>Mohu použít tuto češtinu na oficiálních serverech?</strong><br>'.
 'Ne úplně, protože se vystavujete riziku zablokování vašeho účtu z důvodu použití upravené hry. Na oficiálním serveru lze využít pouze Addon s češtinou CzWoW.</p>'.
- 
+
 '<p><strong>Mám nainstalovánu češtinu a nejde mi spustit Wow.exe.</strong><br>'.
 'Pokud chcete opět spouštět hru přes původní Wow.exe v angličtině, musíte češtinu nejprve odinstalovat ze systému. Především se jedná o soubor Data/enGB/patch-enGB-5.MPQ či Data/enUS/patch-enUS-5.MPQ, který je nutno smazat.</p>'.
- 
+
 '<p><strong>Nedaří se mi provést aktualizaci klienta s nainstalovanou češtinou.</strong><br>'.
 'Před aktualizací na novější verzi klienta musíte nejprve češtinu odinstalovat. Čeština totiž mění v rámci patch MPQ souboru některé soubory hry, což oficiální instalátory vyhodnotí jako poškození hry.</p>'.
-  
+
 '</td><td>';
 
@@ -167 +167 @@
 
   $Output .= '</td></tr></table>'.
- 
- 
+
+
   '</body></html>';
-  
+
 }
 //$_GET['ExportId']