Changeset 286

Timestamp:

Dec 22, 2009, 10:22:38 AM (15 years ago)

Author:

george

Message:

• Opraveno: Kontrola správného zadání Id překladové skupiny.
• Opraveno: Kontrola správného zadání Id překladového jazyka.
• Upraveno: Zobrazovat PageFooter pouze pokud již byl zobrazen PageHeader.
• Opraveno: Chyba určení počtu stránek pro zobrazení stránkování.

Location:

trunk

Files:

• TranslationList.php (modified) (14 diffs)
• action.php (modified) (5 diffs)
• comparison.php (modified) (8 diffs)
• dictionary.php (modified) (5 diffs)
• export/index.php (modified) (21 diffs)
• form.php (modified) (6 diffs)
• img_statistic.php (modified) (3 diffs)
• includes/global.php (modified) (6 diffs)
• includes/global_function.php (modified) (6 diffs)
• save.php (modified) (1 diff)
• statistic.php (modified) (2 diffs)
• style/style.css (modified) (1 diff)

trunk/TranslationList.php

@@ -6 +6 @@
 
 $TranslationItemPerPage = 200;
-if(array_key_exists('group', $_GET)) $GroupId = $_GET['group'] * 1; else $GroupId = 1;
+$GroupId = LoadGroupIdParameter();
 if(array_key_exists('connexion_id', $_GET)) { 
   $_SESSION['connexion_id'] = $_GET['connexion_id'];
-}
-$DbResult = $Database->SQLCommand('SELECT Id FROM `group` WHERE `Id`='.$GroupId);
-if(mysql_num_rows($DbResult) == 0)
-{
-  echo('Neexistující id překladové skupiny.');
-  ShowFooter();
-  die();
 }
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
@@ -144 +137 @@
 if($Action == 'connexion') 
 { //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1)
-        $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT Name FROM connexion WHERE `Id` = '.$_SESSION['connexion_id']));
+  $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT Name FROM connexion WHERE `Id` = '.$_SESSION['connexion_id']));
     echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
         <a title="Zde je seznam souvislostí" href="?group='.$GroupId.'&amp;action=connexion">Souvislosti</a> - > 
@@ -166 +159 @@
       <td>'.$Line['Name'].'</td>');
     }
-        echo ('</table>');
+  echo ('</table>');
 } else
 if($Action == 'nocomplete') 
@@ -196 +189 @@
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
         <a title="Přeložené questy přilášeného uživatele" href="?group='.$GroupId.'&amp;action=my">Moje překlady</a><br /><br />');
-  WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_SESSION['UserID'], '', 'my');
+  WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = '.$Table.'.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_SESSION['UserID'], '', 'my');
 } else
 if(($Action == 'mydevelop') and Licence(LICENCE_USER)) 
@@ -202 +195 @@
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
     <a title="Nedokončené texty" href="?group='.$GroupId.'&amp;action=mydevelop">Rozepsané překlady</a><br /><br />');
-  WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_SESSION['UserID'].' AND Complete = 0', '', 'mydevelop');
+  WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_SESSION['UserID'].' AND `Complete` = 0', '', 'mydevelop');
 } else      
 if($Action == 'users') 
@@ -208 +201 @@
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
         <strong>Vypsání textů od určitých uživatelů</strong><br /><br />');
-  $users = @$_POST['users'];
-  
-  $WhereUsers = '';
-    
+  if(array_key_exists('users', $_POST)) $users = $_POST['users'];
+    else $users = array();
+  
+  $WhereUsers = '';    
   for($i = 0; $i < Count($users); $i++)
   {
-    if($WhereUsers <> '') $WhereUsers .= ' OR User = '.$users[$i];
-      else $WhereUsers .= ' User = '.$users[$i];
-  }
-  WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where '.$WhereUsers, '', 'users');
+    if($WhereUsers <> '') $WhereUsers .= ' OR `User` = '.$users[$i];
+      else $WhereUsers .= ' `User` = '.$users[$i];
+  }
+  if($WhereUsers == '') $WhereUsers = '0';
+  
+  
+  WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE '.$WhereUsers, '', 'users');
 } else     
 if($Action == 'userall') 
 {
-  $ID = $Database->SQLCommand('SELECT user FROM user WHERE id = '.$_GET['user']);
+  $ID = $Database->SQLCommand('SELECT `user` FROM `user` WHERE `id` = '.$_GET['user']);
   $Line = mysql_fetch_row($ID);
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a>'.
@@ -232 +228 @@
   {
     if(array_key_exists('not', $_GET)) {
-       $sql = 'SELECT COUNT(*) FROM '.$Group['TablePrefix'].' WHERE Complete = 0 AND user='.$_GET['user'];
+       $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `Complete` = 0 AND `user`='.$_GET['user'];
          $ID = $Database->SQLCommand($sql);
          $Line = mysql_fetch_row($ID);
@@ -239 +235 @@
        $Total += $Line[0];
     } else {
-         $sql = 'SELECT COUNT(*) FROM '.$Group['TablePrefix'].' WHERE user='.$_GET['user'];
+         $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `user`='.$_GET['user'];
          $ID = $Database->SQLCommand($sql);
          $Line = mysql_fetch_row($ID);
@@ -289 +285 @@
   if(array_key_exists('user', $_GET))
   {
-    $ID = $Database->SQLCommand('SELECT user FROM user WHERE id = '.($_GET['user'] * 1));
+    $ID = $Database->SQLCommand('SELECT `user` FROM `user` WHERE `id` = '.($_GET['user'] * 1));
     if(mysql_num_rows($ID) > 0)
     {
@@ -296 +292 @@
         '<strong>Vypis překladů uživatele '.$Line[0].': </strong><br /><br />');
       if(array_key_exists('not', $_GET)) 
-        WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where Complete = 0 AND user = '.$_GET['user'], '', 'userid');
-      else WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_GET['user'], '', 'userid');
+        WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `Complete` = 0 AND `user` = '.$_GET['user'], '', 'userid');
+      else WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_GET['user'], '', 'userid');
     } else echo('Nebyl nalezen uživatel se zadaným id');
   } else echo('Je nutno zadat id uživatele.');
@@ -306 +302 @@
   else $Search = $_POST['search'];
   
-  $sql = 'SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
+  $sql = 'SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
     OR `entry` LIKE "%'.$Search.'%"
     OR `Language` LIKE "%'.$Search.'%"
@@ -323 +319 @@
   else $Search = $_POST['ID'];
  
-  $sql = 'SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"';
+  $sql = 'SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"';
     
   WriteQuests($sql, '', 'searchentry='.$Search);
@@ -333 +329 @@
         <strong>Výpis všech textů s limitem na stránku</strong><br /><br />');
 
-  WritePages('?group='.$GroupId.'&amp;action=all', ' AS items WHERE (items.Language = 0)');
-
-  WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0)', $_SESSION['limitx'].','.$_SESSION['limity'], 'all');
+  WritePages('?group='.$GroupId.'&amp;action=all', ' AS `items` WHERE (`items`.`Language` = 0)');
+
+  WriteQuests('SELECT * FROM `'.$Table.'` AS `items` WHERE (`items`.`Language` = 0)', $_SESSION['limitx'].','.$_SESSION['limity'], 'all');
 } else      
 if($Action == 'filter') 
@@ -359 +355 @@
         
   echo('<tr><td><form action="?group='.$GroupId.'&amp;action=users" method="post"><div>'.
-    '<select name="users[]" size="10" multiple="multiple">');
-        
-  $ID = $Database->SQLCommand('SELECT user, ID FROM `user` WHERE
-    EXISTS(SELECT 1 FROM '.$Table.' WHERE user = user.ID) ORDER BY user');
+    '<select name="users[]" size="10" multiple="multiple" class="UserList">');
+        
+  $ID = $Database->SQLCommand('SELECT `user`, `ID` FROM `user` WHERE
+    EXISTS(SELECT 1 FROM `'.$Table.'` WHERE `user` = `user`.`ID`) ORDER BY `user`');
   if($ID)
   while($Line = mysql_fetch_assoc($ID))

trunk/action.php

@@ -5 +5 @@
 ShowPage();
 
-if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
+$GroupId = LoadGroupIdParameter();
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
 if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';
@@ -16 +16 @@
   echo('<table class="BaseTable"><tr><th>Skupina</th><th>Výsledků</th></tr>');
   foreach($TranslationTree as $Group) {
-        $Table = $Group['TablePrefix'];
+    $Table = $Group['TablePrefix'];
   
-        $sql = 'SELECT count(*) FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
-        OR `entry` LIKE "%'.$Search.'%"
-        OR `User` LIKE "%'.$Search.'%"
-        OR `Complete` LIKE "%'.$Search.'%"';
-        foreach($Group['Items'] as $Item) {
-                if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"';
-        }
-        $Line = mysql_fetch_row($Database->SQLCommand($sql));
-        echo('<tr><td><a href="TranslationList.php?group='.$Group['Id'].'&amp;action=search&amp;search='.$Search.'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>');
+    $sql = 'SELECT count(*) FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
+      OR `entry` LIKE "%'.$Search.'%"
+      OR `User` LIKE "%'.$Search.'%"
+      OR `Complete` LIKE "%'.$Search.'%"';
+    foreach($Group['Items'] as $Item) {
+    if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"';
+    }
+    $Line = mysql_fetch_row($Database->SQLCommand($sql));
+  echo('<tr><td><a href="TranslationList.php?group='.$Group['Id'].'&amp;action=search&amp;search='.$Search.'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>');
   }
   
-        $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `user` WHERE `user` LIKE "%'.$Search.'%"'));
-        echo('<tr><td><a href="userlist.php?search='.$Search.'">Uživatelé</a></td><td>'.$Line[0].'</td></tr>');
-        $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `team` WHERE `name` LIKE "%'.$Search.'%" OR `description` LIKE "%'.$Search.'%"'));
-        echo('<tr><td><a href="team.php?search='.$Search.'">Týmy</a></td><td>'.$Line[0].'</td></tr>');
-        $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `verseclient` WHERE `text` LIKE "%'.$Search.'%"'));
-        echo('<tr><td><a href="download.php?addon">Čeština pro klienta</a></td><td>'.$Line[0].'</td></tr>');
-        echo('<tr><td><a href="aowow/?search='.$Search.'">Vyhledávací databáze AoWoW</a></td></tr>');
-        $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `dictionary` WHERE (`Text` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%") AND Language = 0'));
-        echo('<tr><td><a href="dictionary.php?search='.$Search.'">Slovníček</a></td><td>'.$Line[0].'</td></tr>');
+    $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `user` WHERE `user` LIKE "%'.$Search.'%"'));
+  echo('<tr><td><a href="userlist.php?search='.$Search.'">Uživatelé</a></td><td>'.$Line[0].'</td></tr>');
+    $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `team` WHERE `name` LIKE "%'.$Search.'%" OR `description` LIKE "%'.$Search.'%"'));
+  echo('<tr><td><a href="team.php?search='.$Search.'">Týmy</a></td><td>'.$Line[0].'</td></tr>');
+    $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `verseclient` WHERE `text` LIKE "%'.$Search.'%"'));
+  echo('<tr><td><a href="download.php?addon">Čeština pro klienta</a></td><td>'.$Line[0].'</td></tr>');
+  echo('<tr><td><a href="aowow/?search='.$Search.'">Vyhledávací databáze AoWoW</a></td></tr>');
+    $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `dictionary` WHERE (`Text` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%") AND Language = 0'));
+  echo('<tr><td><a href="dictionary.php?search='.$Search.'">Slovníček</a></td><td>'.$Line[0].'</td></tr>');
   
   echo('</table>');
@@ -45 +45 @@
 if(($Action == 'dbkit') and Licence(LICENCE_ADMIN)) 
 {
-        echo ('<form action="?action=dbkit" method="post">');
-        echo('Najít: <input type="text" name="find" /><br />');
-        echo('Nahradit: <input type="text" name="replace" /><br />');
-        echo('<input type="submit" value="Najít/nahradit" /><br />');
+  echo ('<form action="?action=dbkit" method="post">');
+  echo('Najít: <input type="text" name="find" /><br />');
+  echo('Nahradit: <input type="text" name="replace" /><br />');
+  echo('<input type="submit" value="Najít/nahradit" /><br />');
     echo('</form><br />');
-        echo ('<a href="?action=dbkit&amp;Take">Opravit data v sloupci Take</a><br />');
-        echo ('<a href="?action=dbkit&amp;ShortCut">Opravit data v sloupci ShortCut</a><br />');
-        
-        echo ('<br /><form action="?action=dbkit" method="post">');
-        echo('Vymazat log typ : <input type="text" name="Type" /> ');
-        echo('<input type="submit" value="Vymazat" /><br />');
+  echo ('<a href="?action=dbkit&amp;Take">Opravit data v sloupci Take</a><br />');
+  echo ('<a href="?action=dbkit&amp;ShortCut">Opravit data v sloupci ShortCut</a><br />');
+  
+  echo ('<br /><form action="?action=dbkit" method="post">');
+  echo('Vymazat log typ : <input type="text" name="Type" /> ');
+  echo('<input type="submit" value="Vymazat" /><br />');
     echo('</form><br />');
 
     if (array_key_exists('Type',$_POST)) {
-                        $sql = 'DELETE FROM log WHERE Type = '.$_POST['Type'];
-                    $Database->SQLCommand($sql);
-                        WriteLog('Vymazán log '.$_POST['Type'], 4);
-                        echo (' Vymazán log '.$_POST['Type']);
+        $sql = 'DELETE FROM log WHERE Type = '.$_POST['Type'];
+        $Database->SQLCommand($sql);
+      WriteLog('Vymazán log '.$_POST['Type'], 4);
+        echo (' Vymazán log '.$_POST['Type']);
     }
     
-        if (array_key_exists('find',$_POST)) {
-        echo ('Začínám nahrazovat: <br />');
-        $find = $_POST['find'];
-        $replace = $_POST['replace'];
-        
-          foreach($TranslationTree as $Group) {
-        $Table = $Group['TablePrefix'];
-        echo ($Table.' ');
-                
-                $sql = 'SELECT * FROM '.$Table.' WHERE (Language <> 0) AND (';
-                foreach($Group['Items'] as $Item) {
-                        if($Item['Column'] != '') $sql .= '`'.$Item['Column'].'` LIKE "%'.$find.'%" OR ';
-                }
-                $sql = substr($sql,0,strlen($sql)-4);
-                $sql .= ')';
-                
-            $ID = $Database->SQLCommand($sql);
-                while ($Line = mysql_fetch_assoc($ID)) {
-                        $sql = 'UPDATE '.$Table.' SET ';
-                        foreach($Group['Items'] as $Item) {
-                                $Column_text = addslashes(str_replace($find,$replace,$Line[$Item['Column']]));
-                                $sql .= ' '.$Item['Column'].' = "'.$Column_text.'",';
-                        }
-                        $sql = substr($sql,0,strlen($sql)-1);
-                        $sql .= ' WHERE ID = '.$Line['ID'];
-                    $Database->SQLCommand($sql);
-                    echo ('.');
-                }
-                
-                echo (' <strong>Hotovo</strong> <br />');
-                if (mysql_num_rows($ID) > 0) {
-                        WriteLog('Použita oprava DB ovlivněno '.mysql_num_rows($ID).' řádků z tabulky '.$Table.', "'.$find.'" nahrazeno za "'.$replace.'"', 4);
-                        echo (' Použita oprava DB ovlivněno '.mysql_num_rows($ID).' řádků z tabulky '.$Table.', "'.$find.'" nahrazeno za "'.$replace.'"<br />');
-                }
-          }
-        }
-        
-        //oprava dat v sloupci Take
+  if (array_key_exists('find',$_POST)) {
+      echo ('Začínám nahrazovat: <br />');
+      $find = $_POST['find'];
+      $replace = $_POST['replace'];
+      
+    foreach($TranslationTree as $Group) {
+      $Table = $Group['TablePrefix'];
+      echo ($Table.' ');
+    
+    $sql = 'SELECT * FROM '.$Table.' WHERE (Language <> 0) AND (';
+    foreach($Group['Items'] as $Item) {
+      if($Item['Column'] != '') $sql .= '`'.$Item['Column'].'` LIKE "%'.$find.'%" OR ';
+      }
+      $sql = substr($sql,0,strlen($sql)-4);
+      $sql .= ')';
+      
+      $ID = $Database->SQLCommand($sql);
+      while ($Line = mysql_fetch_assoc($ID)) {
+        $sql = 'UPDATE '.$Table.' SET ';
+      foreach($Group['Items'] as $Item) {
+        $Column_text = addslashes(str_replace($find,$replace,$Line[$Item['Column']]));
+        $sql .= ' '.$Item['Column'].' = "'.$Column_text.'",';
+        }
+        $sql = substr($sql,0,strlen($sql)-1);
+        $sql .= ' WHERE ID = '.$Line['ID'];
+        $Database->SQLCommand($sql);
+        echo ('.');
+      }
+    
+      echo (' <strong>Hotovo</strong> <br />');
+    if (mysql_num_rows($ID) > 0) {
+      WriteLog('Použita oprava DB ovlivněno '.mysql_num_rows($ID).' řádků z tabulky '.$Table.', "'.$find.'" nahrazeno za "'.$replace.'"', 4);
+        echo (' Použita oprava DB ovlivněno '.mysql_num_rows($ID).' řádků z tabulky '.$Table.', "'.$find.'" nahrazeno za "'.$replace.'"<br />');
+    }
+      }
+  }
+  
+  //oprava dat v sloupci Take
     if (array_key_exists('Take',$_GET)) {
-        echo ('Začínám opravovat Take: <br />');
-        
-          foreach($TranslationTree as $Group) {
-        $Table = $Group['TablePrefix'];
-        echo ($Table.' ');
-                
-                $sql = 'SELECT ID,entry as entry_tran, Take,
-                 (SELECT ID FROM '.$Table.' WHERE Language = 0 AND entry = entry_tran LIMIT 1) as ID_orig
-                  FROM '.$Table.' as tran WHERE (Language <> 0) AND ((Take = 0) OR (ID = Take) OR NOT EXISTS(SELECT 1 FROM '.$Table.' WHERE ID = tran.Take))';
-                
-            $ID = $Database->SQLCommand($sql);
-                while ($Line = mysql_fetch_assoc($ID)) {
-                        $sql = 'UPDATE '.$Table.' SET Take = '.$Line['ID_orig'].' WHERE ID = '.$Line['ID'];
-                    $Database->SQLCommand($sql);
-                    echo ('.');
-                }
-                
-                echo (' <strong>Hotovo</strong> <br />');
-                if (mysql_num_rows($ID) > 0) {
-                        WriteLog('Použita oprava DB na sloupec Take '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
-                        echo (' Použita oprava DB na sloupec Take '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'<br />');
-                }
-          }
-        }       
-        //oprava dat ShortCut
+      echo ('Začínám opravovat Take: <br />');
+    
+    foreach($TranslationTree as $Group) {
+      $Table = $Group['TablePrefix'];
+      echo ($Table.' ');
+    
+    $sql = 'SELECT ID,entry as entry_tran, Take,
+     (SELECT ID FROM '.$Table.' WHERE Language = 0 AND entry = entry_tran LIMIT 1) as ID_orig
+      FROM '.$Table.' as tran WHERE (Language <> 0) AND ((Take = 0) OR (ID = Take) OR NOT EXISTS(SELECT 1 FROM '.$Table.' WHERE ID = tran.Take))';
+      
+      $ID = $Database->SQLCommand($sql);
+      while ($Line = mysql_fetch_assoc($ID)) {
+        $sql = 'UPDATE '.$Table.' SET Take = '.$Line['ID_orig'].' WHERE ID = '.$Line['ID'];
+        $Database->SQLCommand($sql);
+        echo ('.');
+      }
+    
+      echo (' <strong>Hotovo</strong> <br />');
+    if (mysql_num_rows($ID) > 0) {
+      WriteLog('Použita oprava DB na sloupec Take '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
+        echo (' Použita oprava DB na sloupec Take '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'<br />');
+    }
+      }
+  } 
+  //oprava dat ShortCut
     if (array_key_exists('ShortCut',$_GET)) {
-        echo ('Začínám opravovat Take: <br />');
-                        
-                        
-                $Tables = array ('global_strings','glue_strings');      
+      echo ('Začínám opravovat Take: <br />');
+        
+      
+    $Tables = array ('global_strings','glue_strings');  
 
-          foreach($Tables as $Table) {
-        echo ($Table.' ');
-                $sql = 'SELECT gs_orig.ID, gs_tran.entry, gs_tran.ShortCut as ShortCut_tran, gs_orig.ShortCut  as ShortCut_orig FROM '.$Table.' as gs_tran JOIN '.$Table.' as gs_orig ON gs_orig.entry = gs_tran.entry WHERE gs_tran.Language <> 0 AND gs_tran.ShortCut <> gs_orig.ShortCut';           
-            $ID = $Database->SQLCommand($sql);
-                while ($Line = mysql_fetch_assoc($ID)) {
-                        $sql = 'UPDATE '.$Table.' SET ShortCut = '.$Line['ShortCut_orig'].' WHERE ID = '.$Line['ID'];
-                    $Database->SQLCommand($sql);
-                    echo ('.');
-                }
-                
-                echo (' <strong>Hotovo</strong> <br />');
-                if (mysql_num_rows($ID) > 0) {
-                        WriteLog('Použita oprava DB na sloupec ShortCut '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
-                        echo (' Použita oprava DB na sloupec ShortCut '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'<br />');
-                }
-          }
-        }       
+    foreach($Tables as $Table) {
+      echo ($Table.' ');
+    $sql = 'SELECT gs_orig.ID, gs_tran.entry, gs_tran.ShortCut as ShortCut_tran, gs_orig.ShortCut  as ShortCut_orig FROM '.$Table.' as gs_tran JOIN '.$Table.' as gs_orig ON gs_orig.entry = gs_tran.entry WHERE gs_tran.Language <> 0 AND gs_tran.ShortCut <> gs_orig.ShortCut';     
+      $ID = $Database->SQLCommand($sql);
+      while ($Line = mysql_fetch_assoc($ID)) {
+        $sql = 'UPDATE '.$Table.' SET ShortCut = '.$Line['ShortCut_orig'].' WHERE ID = '.$Line['ID'];
+        $Database->SQLCommand($sql);
+        echo ('.');
+      }
+    
+      echo (' <strong>Hotovo</strong> <br />');
+    if (mysql_num_rows($ID) > 0) {
+      WriteLog('Použita oprava DB na sloupec ShortCut '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
+        echo (' Použita oprava DB na sloupec ShortCut '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'<br />');
+    }
+      }
+  } 
 }
 
@@ -172 +172 @@
       Uživatel: ');
     if(Licence(LICENCE_USER)) echo('<b>'.$_SESSION['User'].'</b><br />'); 
-        else echo('<input type="text" name="user" /><br />');
+  else echo('<input type="text" name="user" /><br />');
     echo('Text zprávy: <br>
       <textarea  onkeydown="ResizeTextArea(this)" name="text" cols="40"></textarea> <br />
@@ -180 +180 @@
   {
     if(Licence(LICENCE_USER)) $user = $_SESSION['User']; 
-        else die('Pro vkládaní musíte byt registrováni!');
+  else die('Pro vkládaní musíte byt registrováni!');
     $text = $_POST['text'];
     $Database->SQLCommand("INSERT INTO `shoutbox` ( `user` , `text` , `date` , `IP` ) 

trunk/comparison.php

@@ -10 +10 @@
   //TODO: barevné porovnání
   //strcasecmp($String1, $String2) == 0 je totožné
-  //    echo $String1.'<br /><br />';
+  //  echo $String1.'<br /><br />';
   $ArrStr1 = explode(' ', $String1);
   $ArrStr2 = explode(' ', $String2);
-                
+    
   for($i = 0; $i < count($ArrStr1); $i++)
   {
-        if(isset($ArrStr2[$i]))
-        {
-          if($ArrStr1[$i] == $ArrStr2[$i])
-          {
-                echo($ArrStr1[$i].' ');
-          } else
-          {
-                $find = false;
-                for($j = 0; $j < count($ArrStr2); $j++)
-                {
-                  if(($ArrStr1[$i] == $ArrStr2[$j]) and ($find == false))
-                  {
-                        echo($ArrStr1[$i].' ');
-                        $find = true;
-                  }
-                }
-                if($find == false)
-                  echo('<span class="edit">'.$ArrStr1[$i].' </span>');
-          }
-        } else echo('<span class="edit">'.$ArrStr1[$i].' </span>');
+    if(isset($ArrStr2[$i]))
+    {
+      if($ArrStr1[$i] == $ArrStr2[$i])
+      {
+        echo($ArrStr1[$i].' ');
+      } else
+      {
+        $find = false;
+        for($j = 0; $j < count($ArrStr2); $j++)
+        {
+          if(($ArrStr1[$i] == $ArrStr2[$j]) and ($find == false))
+          {
+            echo($ArrStr1[$i].' ');
+            $find = true;
+          }
+        }
+        if($find == false)
+        echo('<span class="edit">'.$ArrStr1[$i].' </span>');
+      }
+    } else echo('<span class="edit">'.$ArrStr1[$i].' </span>');
   }
-  //    echo $ArrStr1[0];
+  //  echo $ArrStr1[0];
 }
 
-if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
+$GroupId = LoadGroupIdParameter();
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
 
@@ -48 +48 @@
   if((array_key_exists('ID1', $_GET)) and ($_GET['ID1'] <> -1))  //porovnání pouze 2 textů
   {
-        $TextID1 = $_GET['ID1'];  
-        $TextID2 = $_GET['ID2'];  
-        $WhereID = " AND (ID = $TextID1 OR ID = $TextID2 OR Language = 0)";     
+    $TextID1 = $_GET['ID1'];  
+    $TextID2 = $_GET['ID2'];  
+    $WhereID = ' AND (ID = '.$TextID1.' OR ID = '.$TextID2.' OR Language = 0)'; 
   } else $WhereID = '';
 
@@ -57 +57 @@
   while($Line = mysql_fetch_assoc($DataID))
   {
-        $BuffLine[$i] = $Line;
-        $i = $i + 1;    
+    $BuffLine[$i] = $Line;
+    $i = $i + 1;    
   }
  // if(!$Line) die('Překlad nenalezen.');
@@ -70 +70 @@
   foreach($Line as $Index => $LineItem)
   {
-        $LineUser = mysql_fetch_array($Database->SQLCommand('SELECT * FROM user WHERE id = '.$LineItem['User']));
+    $LineUser = mysql_fetch_array($Database->SQLCommand('SELECT * FROM user WHERE id = '.$LineItem['User']));
     echo('<th>'.$LineUser['user'].'</th>');
   }
@@ -78 +78 @@
   foreach($Line as $Index => $LineItem)
   {
-        echo('<td><a href="form.php?group='.$GroupId.'&amp;ID='.$LineItem['ID'].'">'.$LineItem['ID'].'</a></td>');
+    echo('<td><a href="form.php?group='.$GroupId.'&amp;ID='.$LineItem['ID'].'">'.$LineItem['ID'].'</a></td>');
   }
   echo('</tr>');
@@ -84 +84 @@
   foreach($Line as $Index => $LineItem)
   {
-        echo('<td><a href="form.php?group='.$GroupId.'&amp;ID='.$LineItem['Take'].'">'.$LineItem['Take'].'</a></td>');
+    echo('<td><a href="form.php?group='.$GroupId.'&amp;ID='.$LineItem['Take'].'">'.$LineItem['Take'].'</a></td>');
   }
   echo('</tr>');
@@ -90 +90 @@
   foreach($Line as $Index => $LineItem)
   {
-        echo('<td>');
-        WriteLanguagesWithoutSel($LineItem['Language']);
-        echo('</td>');
+    echo('<td>');
+    WriteLanguagesWithoutSel($LineItem['Language']);
+    echo('</td>');
   }
   echo('</tr>');
@@ -98 +98 @@
   foreach($Line as $Index => $LineItem)
   {
-        echo('<td>');
-        echo (GetVersionWOW($LineItem['VersionStart']).' - '.GetVersionWOW($LineItem['VersionEnd']));
-        echo('</td>');
+    echo('<td>');
+    echo (GetVersionWOW($LineItem['VersionStart']).' - '.GetVersionWOW($LineItem['VersionEnd']));
+    echo('</td>');
   }
   echo('</tr>');
   foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
   {          
-        if($Line[0][$TextItem['Column']] <> '')
-        {
-          echo('<tr><th>'.$TextItem['Name'].'</th>');
-          for($i = 0; $i < count($Line); $i++)
-          {
-        if($i > 0)
-                {
-          echo('<td>');
-          CompareString($Line[$i][$TextItem['Column']],$Line[$i - 1][$TextItem['Column']]);
-                  echo('</td>');
-                } else echo('<td>'.$Line[$i][$TextItem['Column']].'</td>');
+    if($Line[0][$TextItem['Column']] <> '')
+    {
+      echo('<tr><th>'.$TextItem['Name'].'</th>');
+      for($i = 0; $i < count($Line); $i++)
+      {
+        if($i > 0)
+        {
+          echo('<td>');
+          CompareString($Line[$i][$TextItem['Column']],$Line[$i - 1][$TextItem['Column']]);
+          echo('</td>');
+        } else echo('<td>'.$Line[$i][$TextItem['Column']].'</td>');
       }
-    echo ('</tr>');
+      echo ('</tr>');
     }
   }

trunk/dictionary.php

@@ -41 +41 @@
   foreach($TablesColumn as $Table => $Column) 
   {  
-    $sql = 'SELECT ID,'.$Column.',(SELECT Name FROM '.$Table.' as T WHERE O.entry = T.entry AND Language <> 0 LIMIT 1) as tran FROM '.$Table.' as O WHERE ';
-    $groupby = ' GROUP BY '.$Column;
+    $sql = 'SELECT `ID`,'.$Column.',(SELECT `Name` FROM '.$Table.' AS `T` WHERE `O`.`entry` = `T`.`entry` AND `Language` <> 0 LIMIT 1) AS `tran` FROM `'.$Table.'` AS `O` WHERE ';
+    $groupby = ' GROUP BY `'.$Column.'`';
   
     $ArrStr = explode(' ', $Text);
@@ -87 +87 @@
 }
 
-if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; 
-else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;
+ShowPage();
 
 if(!isset($_SESSION['language'])) 
@@ -94 +93 @@
   if(Licence(LICENCE_USER)) 
   {
-    $DbResult = $Database->SQLCommand('SELECT Language FROM user WHERE ID='.$_SESSION['UserID']);
+    $DbResult = $Database->SQLCommand('SELECT `Language` FROM `user` WHERE `ID`='.$_SESSION['UserID']);
     $User = mysql_fetch_assoc($DbResult);
     $_SESSION['language'] = $User['Language'];
   } else $_SESSION['language'] = 1;
 }
-if(array_key_exists('language', $_GET)) $_SESSION['language'] = $_GET['language'];
-
-ShowPage();
+if(array_key_exists('language', $_GET)) $_SESSION['language'] = LoadLanguageIdParameter();
 
 echo('<h3>Slovníček</h3>');
-  
+
 if(array_key_exists('group', $_GET)) 
 {   
-  if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
+  $GroupId = LoadGroupIdParameter();
   if(array_key_exists('mode', $_GET)) $mode = $_GET['mode']; else $mode = 0; //0 = přesné názvy, 1=všechny názvy, 2=nepřeložené
   $Table = $TranslationTree[$GroupId]['TablePrefix'];
@@ -227 +224 @@
   echo($PageList['Output']);
   echo('<table width="98%" class="BaseTable">
-    <tr><th>'.$LanguageList[0]['Name'].'</th>
+    <tr><th>Angličtina</th>
     <th>'.$LanguageList[$_SESSION['language']]['Name'].'</th>
     <th>Popis</th><th>Překladatel</th>');
@@ -233 +230 @@
     echo('</tr>');
   $ID = $Database->SQLCommand($sql_page);
-  while ($Line = mysql_fetch_assoc($ID)) 
+  while($Line = mysql_fetch_assoc($ID)) 
   {
     echo('<tr>

trunk/export/index.php

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

trunk/form.php

@@ -5 +5 @@
 ShowPage();
 
-if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
+$GroupId = LoadGroupIdParameter();
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
 if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';
@@ -11 +11 @@
 if(array_key_exists('ID', $_GET)) 
 {
-  $TextID = $_GET['ID'];  
+  $TextID = $_GET['ID'] * 1;  
 
   $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM '.$Table.' Where ID = '.$TextID));
@@ -42 +42 @@
     echo(' <b>Anglická, původní verze</b> ');
   }
-        echo('<br />');
-        echo ('Verze: <b>'.GetVersionWOW($Line['VersionStart']).' - '.GetVersionWOW($Line['VersionEnd'].'</b>'));
-        echo('<br />');
+  echo('<br />');
+  echo ('Verze: <b>'.GetVersionWOW($Line['VersionStart']).' - '.GetVersionWOW($Line['VersionEnd'].'</b>'));
+  echo('<br />');
    
   $version = mysql_fetch_array($Database->SQLCommand('SELECT count(*) FROM '.$Table.' Where entry = '.$Line['entry'].' AND Language <> 0'));
@@ -50 +50 @@
   {
     echo('<form action="comparison.php" method="get"><a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['entry'].'">Počet verzí: <strong>'.$version['count(*)'].'</strong></a>  
-            <input type="hidden" name="group" value="'.$GroupId.'" />
-            <input type="hidden" name="entry" value="'.$Line['entry'].'" />
-        <input type="hidden" name="ID2" value="'.$TextID.'" />
-        <select onchange="this.form.submit();" name="ID1">
-        <option value="-1">Vyberte text k porovnání</option>
-        <option value="-1">Zobrazit/porovnat všechny</option>'); 
-         $DataID = $Database->SQLCommand('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User  FROM '.$Table.' WHERE (entry = '.$Line['entry'].') AND (ID <> '.$Line['ID'].')');  
-         while($version = mysql_fetch_array($DataID))
-         {     
-                if ($version['ID'] == $Line['Take']) echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$version['User'].' (převzato)</option>');   
-        else {
-                  if (0 == $version['Language']) $version['User'] = 'Předloha';
-                  echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$version['User'].' ('.GetVersionWOW($version['VersionStart']).' - '.GetVersionWOW($version['VersionEnd']).')</option>');
-                }
+      <input type="hidden" name="group" value="'.$GroupId.'" />
+      <input type="hidden" name="entry" value="'.$Line['entry'].'" />
+      <input type="hidden" name="ID2" value="'.$TextID.'" />
+      <select onchange="this.form.submit();" name="ID1">
+      <option value="-1">Vyberte text k porovnání</option>
+      <option value="-1">Zobrazit/porovnat všechny</option>'); 
+   $DataID = $Database->SQLCommand('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User  FROM '.$Table.' WHERE (entry = '.$Line['entry'].') AND (ID <> '.$Line['ID'].')');  
+     while($version = mysql_fetch_array($DataID))
+     {     
+      if ($version['ID'] == $Line['Take']) echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$version['User'].' (převzato)</option>');   
+      else {
+      if (0 == $version['Language']) $version['User'] = 'Předloha';
+      echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$version['User'].' ('.GetVersionWOW($version['VersionStart']).' - '.GetVersionWOW($version['VersionEnd']).')</option>');
+    }
      }
-     echo('</select></form>');          
+     echo('</select></form>');    
   } else
   {
-          echo('<a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['entry'].'">Počet verzí: <strong>'.$version['count(*)'].'</strong></a>'); 
+      echo('<a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['entry'].'">Počet verzí: <strong>'.$version['count(*)'].'</strong></a>'); 
   }
 
@@ -75 +75 @@
   if(Licence(LICENCE_USER)) 
   {
-        if(($GroupId < 4) or ($GroupId == 10) or ($GroupId == 11)) echo ('<a href="dictionary.php?group='.$GroupId.'&amp;ID='.$LineAJ['ID'].'" target="_blank"  title="Zobrazit přeložené názvy věci, postav, a herních objektů k tomuto překladu">Vyhledat v názvech</a>');
+    if(($GroupId < 4) or ($GroupId == 10) or ($GroupId == 11)) echo ('<a href="dictionary.php?group='.$GroupId.'&amp;ID='.$LineAJ['ID'].'" target="_blank"  title="Zobrazit přeložené názvy věci, postav, a herních objektů k tomuto překladu">Vyhledat v názvech</a>');
     echo(' <input type="submit" value="Uložit do rozepsaných" name="save" title="Klikněte na uložit pro pozdější dokončení překladu" />
     <input type="submit" value="Dokončeno" name="End" title="Klikněte na Dokončeno jesli jsou všechny texty hotové a chcete již publikovat" /> ');
@@ -113 +113 @@
   {          
     if(($LineAJ[$TextItem['Column']] <> '') or ($Line[$TextItem['Column']] <> ''))  {
-        if ($TextItem['Name'] == 'Text' AND (($Table == 'global_strings') OR ($Table == 'glue_strings')))
-                echo('<tr><th>'.$LineAJ['ShortCut'].'</th>');
-         else
-                echo('<tr><th>'.$TextItem['Name'].'</th>');
-        echo ('<td>'.htmlspecialchars($LineAJ[$TextItem['Column']]).'</td>
+      if ($TextItem['Name'] == 'Text' AND (($Table == 'global_strings') OR ($Table == 'glue_strings')))
+        echo('<tr><th>'.$LineAJ['ShortCut'].'</th>');
+       else
+        echo('<tr><th>'.$TextItem['Name'].'</th>');
+        echo ('<td>'.htmlspecialchars($LineAJ[$TextItem['Column']]).'</td>
       <td><textarea rows="8" cols="40" onkeydown="ResizeTextArea(this)" class="textedit" id="'.$TextItem['Column'].'" name="'.$TextItem['Column'].'">'.htmlspecialchars($Line[$TextItem['Column']]).'</textarea></td></tr>');
     }
   } else
   {
-        echo('<input id="'.$TextItem['Column'].'" name="'.$TextItem['Column'].'" type="hidden" value="'.htmlspecialchars($Line[$TextItem['Column']]).'" />');
+  echo('<input id="'.$TextItem['Column'].'" name="'.$TextItem['Column'].'" type="hidden" value="'.htmlspecialchars($Line[$TextItem['Column']]).'" />');
   }
   echo('</table></div></form>');

trunk/img_statistic.php

@@ -6 +6 @@
 $FontFile = 'images/FRIZQT__.ttf';
 $TranslationTree = GetTranslationTree();
-$Group = $TranslationTree[$_GET['group']];
-if (array_key_exists('team', $_GET)) {
-        $team = ' AND User IN (SELECT ID FROM user WHERE team = '.$_GET['team'].')';
+$GroupId = LoadGroupIdParameter();
+$Group = $TranslationTree[$GroupId];
+if(array_key_exists('team', $_GET)) 
+{
+  $team = ' AND `User` IN (SELECT `ID` FROM `user` WHERE `team` = '.$_GET['team'].')';
 } else $team = '';
-if (array_key_exists('language', $_GET)) {
-        $language = ' AND Language = '.$_GET['language'].'';
+if(array_key_exists('language', $_GET)) 
+{
+  $language = ' AND `Language` = '.$_GET['language'].'';
 } else $language = '';
-if (array_key_exists('user', $_GET)) {
-    $DbResult = $Database->SQLCommand('SELECT user,ExportSetting FROM `user` WHERE ID='.$_GET['user']);
-    $User = mysql_fetch_assoc($DbResult);
-        $ExportSetting = unserialize($User['ExportSetting']);
-        $SelectedUsers = ''; 
-    foreach($ExportSetting['users-selection'] as $Item)
-      $SelectedUsers .= ','.$Item;
-    $SelectedUsers = substr($SelectedUsers, 1);
-        $user_sql = ' AND User IN ('.$SelectedUsers.')';
+if(array_key_exists('user', $_GET)) 
+{
+  $DbResult = $Database->SQLCommand('SELECT `user`,`ExportSetting` FROM `user` WHERE ID='.$_GET['user']);
+  $User = mysql_fetch_assoc($DbResult);
+  $ExportSetting = unserialize($User['ExportSetting']);
+  $SelectedUsers = ''; 
+  foreach($ExportSetting['users-selection'] as $Item)
+    $SelectedUsers .= ','.$Item;
+  $SelectedUsers = substr($SelectedUsers, 1);
+  $user_sql = ' AND `User` IN ('.$SelectedUsers.')';
 } else $user_sql = '';
 
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT max(VersionEnd) FROM '.$Group['TablePrefix']));
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT MAX(`VersionEnd`) FROM '.$Group['TablePrefix']));
 $BuildNumber_max = $ID[0];
 
-$where = 'VersionEnd = '.$BuildNumber_max.' AND (Language <> 0) AND (Complete = 1) '.$team.$language.$user_sql;
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE '.$where));
+$where = 'VersionEnd = '.$BuildNumber_max.' AND (`Language` <> 0) AND (`Complete` = 1) '.$team.$language.$user_sql;
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(`entry`)) FROM '.$Group['TablePrefix'].' WHERE '.$where));
 $NumberTranslate = $ID[0];
   
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE VersionEnd = '.$BuildNumber_max.' AND (Language = 0)'));
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(`entry`)) FROM '.$Group['TablePrefix'].' WHERE `VersionEnd` = '.$BuildNumber_max.' AND (`Language` = 0)'));
 $NumberAJ = $ID[0];
 
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM log WHERE Type = 1 AND date >= CURRENT_DATE - INTERVAL '.$Days.' DAY
- AND text LIKE "%'.$Group['Name'].'%"'));
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `log` WHERE `Type` = 1 AND `date` >= CURRENT_DATE - INTERVAL '.$Days.' DAY
+ AND `text` LIKE "%'.$Group['Name'].'%"'));
 $NumberPerDay = $ID[0]; //date ("Y-m-d H:i:s")
 
-if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; else $Percent = 0;
+if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; 
+  else $Percent = 0;
 $Percent = substr($Percent, 0, 5);
 
@@ -51 +56 @@
 imagefilledrectangle($Image, 0, 0, $PercentBar, 59, $Color2);
 $FontSize = 10;
-if (($NumberPerDay > 0) and ($team == '') and ($language == '') and ($user_sql == '') and ($NotTran>0)) {
-        $TimeToTranslate = ($NotTran  / $NumberPerDay)* $Days;
-        ImageTTFText($Image, $FontSize, 0, 5, 13, $Color3, $FontFile, 'Čas do dokončení');
-        ImageTTFText($Image, $FontSize, 0, 5, 29, $Color3, $FontFile, getmonthyears($TimeToTranslate) );
+if(($NumberPerDay > 0) and ($team == '') and ($language == '') and ($user_sql == '') and ($NotTran > 0)) 
+{
+  $TimeToTranslate = ($NotTran  / $NumberPerDay) * $Days;
+  ImageTTFText($Image, $FontSize, 0, 5, 13, $Color3, $FontFile, 'Čas do dokončení');
+  ImageTTFText($Image, $FontSize, 0, 5, 29, $Color3, $FontFile, getmonthyears($TimeToTranslate));
 }
-if ($user_sql <> '') {
-        ImageTTFText($Image, $FontSize, 0, 5, 13, $Color3, $FontFile, 'Statistika výběru');
-        ImageTTFText($Image, $FontSize, 0, 5, 29, $Color3, $FontFile, 'uživatele: '.$User['user'] );
+if($user_sql <> '') 
+{
+  ImageTTFText($Image, $FontSize, 0, 5, 13, $Color3, $FontFile, 'Statistika výběru');
+  ImageTTFText($Image, $FontSize, 0, 5, 29, $Color3, $FontFile, 'uživatele: '.$User['user'] );
 }
 ImageTTFText($Image, $FontSize, 0, 140, 13, $Color3, $FontFile, $NumberTranslate.'/'.$NumberAJ);
@@ -64 +71 @@
 ImageTTFText($Image, $FontSize, 0, 140, 29, $Color3, $FontFile, $Percent.'%');
 $FontSize = 6;
-ImageTTFText($Image, $FontSize, 0, 240, 28, $Color3, $FontFile, 'Aktualizace: '.date("m.d.y  H:i"));
+ImageTTFText($Image, $FontSize, 0, 240, 28, $Color3, $FontFile, 'Aktualizace: '.date('m.d.y  H:i'));
 
-Header("Content-type: image/png"); 
+Header('Content-type: image/png'); 
 ImagePNG($Image); 
 ImageDestroy($Image); 

trunk/includes/global.php

@@ -183 +183 @@
 function ShowPage()
 {
-  global $Config, $Database, $RSSChannels;  
+  global $Config, $Database, $RSSChannels, $PageFooterRequested;  
   
   echo('<?xml version="1.0" encoding="'.$Config['Web']['Charset'].'"?>
@@ -208 +208 @@
 </table>');
 
-if(!array_key_exists('UserID', $_SESSION)) $_SESSION['UserID'] = '';
-if(!array_key_exists('User', $_SESSION)) $_SESSION['User'] = 'NotRegistred';
-if(!array_key_exists('Pass', $_SESSION)) $_SESSION['Pass'] = '';
-
-
-//odhlášení
-if(array_key_exists('Logout', $_GET))
-{
-  WriteLog('Odhlášení', 3);
-  if(is_numeric($_SESSION['UserID']))
-    $Database->SQLCommand('UPDATE user SET LastLogout = NOW() WHERE ID = '.$_SESSION['UserID']);
-  $_SESSION['User'] = '';
-  $_SESSION['Pass'] = '';
-  $_SESSION['UserID'] = '';
-}
-
-// Přihlášení
-if(array_key_exists('LoginUser', $_POST))
-{
-  $_SESSION['User'] = $_POST['LoginUser'];
-  $_SESSION['Pass'] = $_POST['LoginPass'];
-
-  $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM user WHERE LOWER(user) = LOWER("'.$_SESSION['User'].'") AND pass = sha1("'.$_SESSION['Pass'].'")'));
-  if(!$Line)
-  {
-     echo('<script> alert("Jméno nebo heslo bylo zadáno špatně!"); </script>');
-     $_SESSION['UserID'] = ''; 
-     $_SESSION['User'] = '';
-     $_SESSION['Pass'] = '';
-  } else
-  {
-    $_SESSION['UserID'] = $Line['ID']; 
-    $_SESSION['User'] = $Line['user'];
-    WriteLog('Login: '.$_SESSION['User'], 3);
-  }
-}
+  if(!array_key_exists('UserID', $_SESSION)) $_SESSION['UserID'] = '';
+  if(!array_key_exists('User', $_SESSION)) $_SESSION['User'] = 'NotRegistred';
+  if(!array_key_exists('Pass', $_SESSION)) $_SESSION['Pass'] = '';
+
+
+  // Odhlášení
+  if(array_key_exists('Logout', $_GET))
+  {
+    WriteLog('Odhlášení', 3);
+    if(is_numeric($_SESSION['UserID']))
+      $Database->SQLCommand('UPDATE user SET LastLogout = NOW() WHERE ID = '.$_SESSION['UserID']);
+    $_SESSION['User'] = '';
+    $_SESSION['Pass'] = '';
+    $_SESSION['UserID'] = '';
+  }
+
+  // Přihlášení
+  if(array_key_exists('LoginUser', $_POST))
+  {
+    $_SESSION['User'] = $_POST['LoginUser'];
+    $_SESSION['Pass'] = $_POST['LoginPass'];
+
+    $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM user WHERE LOWER(user) = LOWER("'.$_SESSION['User'].'") AND pass = sha1("'.$_SESSION['Pass'].'")'));
+    if(!$Line)
+    {
+       echo('<script> alert("Jméno nebo heslo bylo zadáno špatně!"); </script>');
+       $_SESSION['UserID'] = ''; 
+       $_SESSION['User'] = '';
+       $_SESSION['Pass'] = '';
+    } else
+    {
+      $_SESSION['UserID'] = $Line['ID']; 
+      $_SESSION['User'] = $Line['user'];
+      WriteLog('Login: '.$_SESSION['User'], 3);
+    }
+  }
 
   //záznam o aktivitě
@@ -258 +258 @@
   ShowSearchBox();
   echo('</td><td id="border-left"></td><td class="content">');
+  $PageFooterRequested = true;
 }
 
@@ -277 +278 @@
 function ShowFooter()
 {
-  global $Database, $Config, $ScriptStartTime;
-
-  $ScriptGenerateDuration = round(GetMicrotime() - $ScriptStartTime, 2);
-
-  echo('</td>');
-  echo('<td class="menu2">');
-  ShowTranslatedMenu();
-  echo('<br />');
-  ShowShoutBox();
-  echo('</td>'.
+  global $Database, $Config, $ScriptStartTime, $PageFooterRequested;
+
+  if(isset($PageFooterRequested)) 
+  {
+    $ScriptGenerateDuration = round(GetMicrotime() - $ScriptStartTime, 2);
+
+    echo('</td>');
+    echo('<td class="menu2">');
+    ShowTranslatedMenu();
+    echo('<br />');
+    ShowShoutBox();
+    echo('</td>'.
   '</tr><tr>'.
   '<td colspan="4" class="page-bottom">Autoři: maron, chronos &nbsp; <a href="http://wowpreklad.zdechov.net/trac/wowpreklad/browser/trunk">Zdrojové soubory</a> &nbsp; '.
@@ -297 +300 @@
     </script>');
 
-  echo('</td></tr>');
-  if($Config['Web']['ShowRuntimeInfo'] == true) echo('<tr><td colspan="3" style="text-align: center;">Doba generování: '.$ScriptGenerateDuration.' s / '.ini_get('max_execution_time').' s &nbsp;&nbsp; Použitá paměť: '.HumanSize(memory_get_peak_usage(FALSE)).' / '.ini_get('memory_limit').'B</td></tr>');
-  echo('</table>'.
-    '</body>'.
-    '</html>');
-  $Database->Disconnect();
+    echo('</td></tr>');
+    if($Config['Web']['ShowRuntimeInfo'] == true) echo('<tr><td colspan="3" style="text-align: center;">Doba generování: '.$ScriptGenerateDuration.' s / '.ini_get('max_execution_time').' s &nbsp;&nbsp; Použitá paměť: '.HumanSize(memory_get_peak_usage(FALSE)).' / '.ini_get('memory_limit').'B</td></tr>');
+    echo('</table>'.
+      '</body>'.
+      '</html>');
+    $Database->Disconnect();
+  } 
 }
 
@@ -313 +317 @@
     if($Part != '')
     {
+      if(!strpos($Part, '=')) $Part .= '=';
       $Item = explode('=', $Part);
       $Result[$Item[0]] = $Item[1];

trunk/includes/global_function.php

@@ -36 +36 @@
   $Around = round($Config['Web']['VisiblePagingItems'] / 2);
   $Result = '';
-  $PageCount = ceil($TotalCount / $ItemPerPage);
+  $PageCount = floor($TotalCount / $ItemPerPage) + 1;
   
   if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 0;
@@ -43 +43 @@
   if($_SESSION['Page'] >= $PageCount) $_SESSION['Page'] = $PageCount - 1;
   $CurrentPage = $_SESSION['Page'];
+  
         
   $Result .= 'Počet položek: <strong>'.$TotalCount.'</strong> &nbsp; Stránky: ';
@@ -184 +185 @@
   
   $Result = array();
-  $DbResult = $Database->SQLCommand('SELECT * FROM `language`');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `language` WHERE `Enabled` = 1');
   while($DbRow = mysql_fetch_assoc($DbResult))
     $Result[$DbRow['Id']] = $DbRow;
@@ -278 +279 @@
     if($Prev) echo('<a href="form.php?group='.$GroupId.'&amp;ID='.$Next['ID'].'">Předcházející '.$Next['ID'].'</a> ');
     else echo('<a href="form.php?group='.$GroupId.'&amp;ID='.$Next['ID'].'">Následující '.$Next['ID'].'</a> ');
-       return 'form.php?group='.$GroupId.'&amp;ID='.$Next['ID'];
-  }
-}
-
+      return 'form.php?group='.$GroupId.'&amp;ID='.$Next['ID'];
+  }
+}
 
 function HaveSameText($Group, $DbRow2, $Value)
@@ -334 +334 @@
 function GetBuildNumber($Version)
 {
-  global $Database,$BuildNumbers;
-  
-  if (isset($BuildNumbers[$Version]) == false) 
-  {
-    $sql = 'SELECT BuildNumber FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+  global $Database, $BuildNumbers;
+  
+  if(isset($BuildNumbers[$Version]) == false) 
+  {
+    $sql = 'SELECT `BuildNumber` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $BuildNumbers[$Version] = $DbRow['BuildNumber'];
@@ -347 +347 @@
 function GetVersionWOW($BuildNumber)
 {
-  global $Database,$VersionsWOW;
-  if (isset($VersionsWOW[$BuildNumber]) == false) 
-  {
-    $sql = 'SELECT Version FROM `wow_client_version` WHERE BuildNumber = "'.$BuildNumber.'"';
+  global $Database, $VersionsWOW;
+  
+  if(isset($VersionsWOW[$BuildNumber]) == false) 
+  {
+    $sql = 'SELECT `Version` FROM `wow_client_version` WHERE `BuildNumber` = "'.$BuildNumber.'"';
     $Version = mysql_fetch_assoc($Database->SQLCommand($sql));
     $VersionsWOW[$BuildNumber] = $Version['Version'];
   }
-    return($VersionsWOW[$BuildNumber]);
-}
-
-function GetDBCColumns($Version,$DBCFileName)
-{
-  global $Database,$DBCColumns;
-  if (isset($DBCColumns[$Version][$DBCFileName]) == false) 
-  {
-    $sql = 'SELECT DBCColumns_'.$DBCFileName.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+  return($VersionsWOW[$BuildNumber]);
+}
+
+function GetDBCColumns($Version, $DBCFileName)
+{
+  global $Database, $DBCColumns;
+  
+  if(isset($DBCColumns[$Version][$DBCFileName]) == false) 
+  {
+    $sql = 'SELECT `DBCColumns_'.$DBCFileName.'` AS `DBCColumns` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $DBCColumns[$Version][$DBCFileName] = $DbRow['DBCColumns'];
   }
-    return($DBCColumns[$Version][$DBCFileName]);
-}
-
-function GetDBCColumnIndex($Version,$DBCFileName,$Column)
-{
-  global $Database,$DBCColumnIndex;
-  if (isset($DBCColumnIndex[$Version][$DBCFileName][$Column]) == false) 
-  {
-    $sql = 'SELECT '.$DBCFileName.'_'.$Column.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+  return($DBCColumns[$Version][$DBCFileName]);
+}
+
+function GetDBCColumnIndex($Version, $DBCFileName, $Column)
+{
+  global $Database, $DBCColumnIndex;
+  
+  if(isset($DBCColumnIndex[$Version][$DBCFileName][$Column]) == false) 
+  {
+    $sql = 'SELECT `'.$DBCFileName.'_'.$Column.'` AS `DBCColumns` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $DBCColumnIndex[$Version][$DBCFileName][$Column] = $DbRow['DBCColumns'];
   }
-    return($DBCColumnIndex[$Version][$DBCFileName][$Column]);
+  return($DBCColumnIndex[$Version][$DBCFileName][$Column]);
+}
+
+function LoadGroupIdParameter()
+{
+  global $TranslationTree;
+  
+  if(array_key_exists('group', $_GET)) $GroupId = $_GET['group'] * 1; 
+    else $GroupId = 1;
+  
+  if(isset($TranslationTree[$GroupId]) == false)
+  {
+    echo('Překladová skupina dle zadaného Id neexistuje.');
+    ShowFooter();
+    die();
+  }
+  return($GroupId);
+}
+
+function LoadLanguageIdParameter()
+{
+  global $LanguageList;
+  
+  if(array_key_exists('language', $_GET)) $LanguageId = $_GET['language'] * 1; 
+    else $LanguageId = 1;
+  
+  if(isset($LanguageList[$LanguageId]) == false)
+  {
+    echo('Jazyk dle zadaného Id neexistuje.');
+    ShowFooter();
+    die();
+  }
+  return($LanguageId);
 }
 

trunk/save.php

@@ -8 +8 @@
 //if(Licence(LICENCE_USER) == false) die('Nemáte přístup do této sekce! Je nutné se přihásit.');
 
-if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
-if(isset($TranslationTree[$GroupId]) == false)
-{
-  echo('Neexistující id překladové skupiny.');
-  ShowFooter();
-  die();
-}
+$GroupId = LoadGroupIdParameter();
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
 if(array_key_exists('entry', $_POST) and Licence(LICENCE_USER)) 

trunk/statistic.php

@@ -5 +5 @@
 ShowPage();
 
-if (array_key_exists('language', $_GET)) 
-{
-        $language = '&language='.$_GET['language'];
-} else $language = '';
-if (array_key_exists('user', $_GET)) 
-{
-        $user_stat = '&user='.$_SESSION['UserID'];
-} else $user_stat = '';
-
+$LanguageId = LoadLanguageIdParameter();
+if($LanguageId > 0) $language = '&language='.$LanguageId;
+  else $language = '';
+if(array_key_exists('user', $_GET))  $user_stat = '&user='.$_SESSION['UserID'];
+  else $user_stat = '';
 
 echo('<strong>Statistika:</strong> <a href="statistic.php">Všechny</a>');
@@ -27 +23 @@
 foreach($TranslationTree as $Group)
   if($Group['TablePrefix'] != '') 
-        echo('<div class="state-image">
-        <img alt="'.$Group['TablePrefix'].'" src="img_statistic.php?group='.$Group['Id'].$language.$user_stat.'" title="statistika překladů '.$Group['Name'].'"/></div>');
+  echo('<div class="state-image">
+  <img alt="'.$Group['TablePrefix'].'" src="img_statistic.php?group='.$Group['Id'].$language.$user_stat.'" title="statistika překladů '.$Group['Name'].'"/></div>');
 
 echo('<p><strong>Celková statistika v závislosti na čase: </strong><a href="http://stat.zdechov.net/game/?Measure=18">Počet přeložených textů</a></p>

trunk/style/style.css

@@ -339 +339 @@
   width: 50%;
 }
+
+.UserList
+{
+  width: 100%; 
+  text-align: center;
+}