Changeset 376

Timestamp:

Mar 11, 2010, 8:40:32 AM (15 years ago)

Author:

george

Message:

• Upraveno: Informace o přihlášeném uživateli nově pročištěny a sjednoceny do třídy User. SQL pro kontrolu a generovány hesel dostupné přímo přes metodu CryptPasswordSQL. Přístup k Id přihlášeného uživatele přes globální proměnnou $User a vlastnost Id ($User->Id). Podobně přístup k dalším vlastnostem uživatele.
• Opraveno: Některé chyby z předchozích předělávek.

Location:

trunk

Files:

• Options.php (modified) (6 diffs)
• TranslationList.php (modified) (4 diffs)
• action.php (modified) (10 diffs)
• admin.php (modified) (4 diffs)
• dictionary.php (modified) (8 diffs)
• download.php (modified) (1 diff)
• export/create_addon.php (modified) (1 diff)
• export/export.php (modified) (11 diffs)
• export/index.php (modified) (20 diffs)
• form.php (modified) (4 diffs)
• includes/config.sample.php (modified) (2 diffs)
• includes/global.php (modified) (14 diffs)
• includes/global_function.php (modified) (4 diffs)
• includes/user.php (added)
• log.php (modified) (1 diff)
• registrace.php (modified) (2 diffs)
• save.php (modified) (8 diffs)
• sql/structure.sql (modified) (4 diffs)
• sql/text_table_init_structure.sql (modified) (1 diff)
• sql/updates/376.sql (added)
• team.php (modified) (12 diffs)
• user.php (modified) (2 diffs)
• userlist.php (modified) (1 diff)

trunk/Options.php

@@ -4 +4 @@
 ShowPage();
 
-if(Licence(LICENCE_USER)) 
+if($User->Licence(LICENCE_USER)) 
 {
-  $User = @$_SESSION['User'];
-
   if(array_key_exists('Email', $_POST)) 
   {
@@ -15 +13 @@
     $NewPass2 = $_POST['NewPass2'];
     $Language = $_POST['Language'];
-    $redirecting = $_POST['redirecting'];
+    $Redirecting = $_POST['redirecting'];
 
-    if(($_SESSION['Pass'] == $OldPass) and ($NewPass == $NewPass2)) 
+    if($NewPass == $NewPass2) 
     {
-      // Update password
-      $Salt = GetPasswordSalt();
-      $Database->SQLCommand('UPDATE `User` SET `Pass` = sha1(CONCAT(sha1("'.$NewPass.'"), "'.$Salt.'")), `Salt`="'.$Salt.'" WHERE `ID` = '.$_SESSION['UserID']);
-      echo('Heslo změněno!<br />');
+      $DbResult = $Database->SQLCommand('SELECT `Pass`, '.$User->CryptPasswordSQL('"'.$OldPass.'"', '`Salt`').' AS `Hash` FROM `User` WHERE `ID`= '.$User->Id);
+      $DbRow = mysql_fetch_assoc($DbResult);
+      if($DbRow['Hash'] == $DbRow['Pass'])
+      {      
+        // Update password
+        $Salt = $User->GetPasswordSalt();
+        $Database->SQLCommand('UPDATE `User` SET `Pass` = '.$User->CryptPasswordSQL('"'.$NewPass.'"', '"'.$Salt.'"').', `Salt`="'.$Salt.'" WHERE `ID` = '.$User->Id);
+        echo('Heslo změněno!<br />');
+      } else echo('<br />Staré heslo neodpovídá!<br />');
     } else echo('<br />Hesla se neshodují!<br />');
     
-    $Database->SQLCommand('UPDATE `User` SET `Email` = "'.$Email.'", `Language` = "'.$Language.'", `Redirecting` = "'.$redirecting.'" WHERE `ID` = '.$_SESSION['UserID']);
-    echo('Úprava nastavení proběhla v pořádku, Email: <b>'.$Email.'</b> Uživatel: <b>'.$User.'</b><br />');
+    $Database->SQLCommand('UPDATE `User` SET `Email` = "'.$Email.'", `Language` = "'.$Language.'", `Redirecting` = "'.$Redirecting.'" WHERE `ID` = '.$User->Id);
+    echo('Úprava nastavení proběhla v pořádku, Email: <b>'.$Email.'</b> Uživatel: <b>'.$User->Name.'</b><br />');
     WriteLog('Úprava nastavení!', LOG_TYPE_USER);
   } else 
   {
-    $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$_SESSION['UserID']));    
     echo('<form action="Options.php" method="post">
   <fieldset><legend>Nastavení uživatele</legend>
@@ -36 +38 @@
     <tr>
       <td>Email: </td>
-      <td><input type="text" name="Email" value="'.$Line['Email'].'" /></td>
+      <td><input type="text" name="Email" value="'.$User->Email.'" /></td>
     </tr>
     <tr>
@@ -53 +55 @@
       <td>Normálně budu překládat do: </td>
       <td>');
-    WriteLanguages($Line['Language']);
+    WriteLanguages($User->Language);
     echo('</td>
     </tr>
@@ -62 +64 @@
    echo('<select name="redirecting">');
    echo('<option value="0">Nikam</option>');
-   echo('<option value="1"'); if ($Line['Redirecting'] == '1') echo(' selected="selected"'); echo('>Na nepřeložené</option>');
-   echo('<option value="2"'); if ($Line['Redirecting'] == '2') echo(' selected="selected"'); echo('>Na další překlad</option>');
-   echo('<option value="3"'); if ($Line['Redirecting'] == '3') echo(' selected="selected"'); echo('>Na předchozí překlad</option>');
+   echo('<option value="1"'); 
+   if($User->Redirecting == '1') echo(' selected="selected"'); 
+   echo('>Na nepřeložené</option>');
+   echo('<option value="2"'); 
+   if($User->Redirecting == '2') echo(' selected="selected"'); 
+   echo('>Na další překlad</option>');
+   echo('<option value="3"'); 
+   if($User->Redirecting == '3') echo(' selected="selected"'); 
+   echo('>Na předchozí překlad</option>');
    echo('</select>');   
     
-    echo('</td>
+   echo('</td>
     </tr>
     <tr>
@@ -85 +93 @@
     {
       echo('<option value="'.$LineTeam['Id'].'"'); 
-      if ($LineTeam['Id'] == $Line['Team']) echo(' selected="selected"');
+      if ($LineTeam['Id'] == $User->Team) echo(' selected="selected"');
         echo('>'.$LineTeam['Name'].'</option>');
     }    

trunk/TranslationList.php

@@ -111 +111 @@
 function UserTranslated()
 {
-  global $GroupId, $Table;
+  global $GroupId, $Table, $User;
   
   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 `'.$Table.'`.*, `User`.`Name` AS `UserName` FROM `'.$Table.'` JOIN `User` ON `User`.`id` = `'.$Table.'`.`User` WHERE `'.$Table.'`.`User` = '.$_SESSION['UserID']);
+  WriteQuests('SELECT `'.$Table.'`.*, `User`.`Name` AS `UserName` FROM `'.$Table.'` JOIN `User` ON `User`.`id` = `'.$Table.'`.`User` WHERE `'.$Table.'`.`User` = '.$User->Id);
 }
 
 function UserUnfinished()
 {
-  global $GroupId, $Table;
+  global $GroupId, $Table, $User;
 
   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`.`Name` FROM `User` WHERE `User`.`ID` = `'.$Table.'`.`User`) AS `UserName` FROM `'.$Table.'` WHERE `User` = '.$_SESSION['UserID'].' AND `Complete` = 0');
+  WriteQuests('SELECT *, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `'.$Table.'`.`User`) AS `UserName` FROM `'.$Table.'` WHERE `User` = '.$User->Id.' AND `Complete` = 0');
 }
 
@@ -281 +281 @@
 function TranslatedFilter()
 {
-  global $Table, $GroupId, $Database;
+  global $Table, $GroupId, $Database, $User;
   
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a><br /><br /><br />'.
@@ -294 +294 @@
     '<td>Texty označené jako rozpracované.</td></tr>');
 
-  if(Licence(LICENCE_USER)) 
+  if($User->Licence(LICENCE_USER)) 
   {
     echo('<tr><td><a title="Nedokončené texty" href="?group='.$GroupId.'&amp;action=mydevelop">Rozepsané texty</a></td>
@@ -350 +350 @@
 else if($Action == 'nocomplete') Noncomplete();
 else if($Action == 'Translate') Translate();
-else if(($Action == 'my') and Licence(LICENCE_USER)) UserTranslated();
-else if(($Action == 'mydevelop') and Licence(LICENCE_USER)) UserUnfinished();
+else if(($Action == 'my') and $User->Licence(LICENCE_USER)) UserTranslated();
+else if(($Action == 'mydevelop') and $User->Licence(LICENCE_USER)) UserUnfinished();
 else if($Action == 'users') UserSelected();
 else if($Action == 'userall') UserAll();

trunk/action.php

@@ -27 +27 @@
   }
   
-    $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `User` WHERE `User` LIKE "%'.$Search.'%"'));
+    $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `User` WHERE `Name` 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.'%"'));
@@ -42 +42 @@
 function DatabaseKit()
 {
-  global $Database, $TranslationTree;
-  
-  if(Licence(LICENCE_ADMIN)) 
+  global $Database, $TranslationTree, $User;
+  
+  if($User->Licence(LICENCE_ADMIN)) 
   {
     echo('<form action="?action=dbkit" method="post">');
@@ -172 +172 @@
 function Delete()
 {
-  global $Database;
-  
-  if(Licence(LICENCE_MODERATOR)) 
+  global $Database, $User;
+  
+  if($User->Licence(LICENCE_MODERATOR)) 
   {
     $TextID = $_GET['ID'];       
@@ -185 +185 @@
 function ShoutBox()
 {
-  global $Database;
+  global $Database, $User;
   
   if(array_key_exists('shoutbox', $_GET)) $shoutbox = $_GET['shoutbox'];
@@ -193 +193 @@
     echo('<form action="action.php?action=shoutbox&amp;shoutbox=1" method="post"><fieldset><legend>Nová zpráva kecátka</legend>
       Uživatel: ');
-    if(Licence(LICENCE_USER)) echo('<b>'.$_SESSION['User'].'</b><br />'); 
+    if($User->Licence(LICENCE_USER)) echo('<b>'.$User->Name.'</b><br />'); 
   else echo('<input type="text" name="user" /><br />');
     echo('Text zprávy: <br>
@@ -201 +201 @@
   } else 
   {
-    if(Licence(LICENCE_USER)) $user = $_SESSION['User']; 
-  else die('Pro vkládaní musíte byt registrováni!');
-    $text = $_POST['text'];
-    $Database->SQLCommand('INSERT INTO `ShoutBox` ( `User` , `Text` , `Date` , `IP` ) 
-    VALUES ("'.$user.'", "'.$text.'", NOW(), "'.$_SERVER['REMOTE_ADDR'].'")');
-    echo('Zpráva vložena!<br>Budete přesměrováni...');   
-    echo('
+    if($User->Licence(LICENCE_USER))
+    {
+      $Text = $_POST['text'];
+      $Database->SQLCommand('INSERT INTO `ShoutBox` ( `User` , `Text` , `Date` , `IP` ) '.
+      ' VALUES ("'.$User->Name.'", "'.$Text.'", NOW(), "'.$_SERVER['REMOTE_ADDR'].'")');
+      echo('Zpráva vložena!<br>Budete přesměrováni...');   
+      echo('
         <script type="text/javascript" language="JavaScript" charset="utf-8">
             setTimeout("parent.location.href=\'index.php\'",1000)
         </script>');
+    } else echo('Pro vkládaní musíte byt registrováni!');
   }
 }
@@ -216 +217 @@
 function ShoutBoxView()
 {
-  global $Database;
+  global $Database, $User;
   
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `ShoutBox`');
@@ -224 +225 @@
   echo('<h3>Kecátko</h3>');
   echo($PageList['Output']); 
-  if(Licence(LICENCE_USER)) echo(' <a href="action.php?action=shoutbox">Vložit</a>');
+  if($User->Licence(LICENCE_USER)) echo(' <a href="action.php?action=shoutbox">Vložit</a>');
   echo('<div class="shoutbox">');
   $ID = $Database->SQLCommand('SELECT * FROM `ShoutBox` ORDER BY `ID` DESC '.$PageList['SQLLimit']);
@@ -235 +236 @@
 function ShowNewsHistory()
 {
-  global $Database;
+  global $Database, $User;
   
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `News`');
@@ -243 +244 @@
   echo('<h3>Novinky</h3>');
   echo($PageList['Output']); 
-  if(Licence(LICENCE_USER)) echo(' <a href="admin.php?action=addnew">Vložit</a>');
+  if($User->Licence(LICENCE_USER)) echo(' <a href="admin.php?action=addnew">Vložit</a>');
   echo('<div class="shoutbox">');
   $ID = $Database->SQLCommand('SELECT `News`.`Time`, `News`.`Text`, `User`.`Name` AS `User` FROM `News` JOIN `User` ON `User`.`ID`=`News`.`User` ORDER BY `News`.`Time` DESC '.$PageList['SQLLimit']);

trunk/admin.php

@@ -30 +30 @@
 function ShowNewForm()
 {
-  //global $User;
+  global $User;
+  
   echo ('<form action="admin.php?action=addnew" method="POST">'.
-  'Uživatel: '.$_SESSION['User'].'('.$_SESSION['UserID'].')<br/> '.
+  'Uživatel: '.$User->Name.'('.$User->Id.')<br/> '.
   '<input type="submit" value="Uložit"/><br/>'.
   '<textarea rows="8" cols="40" onkeydown="ResizeTextArea(this)" class="textedit" id="Text" name="text"></textarea>'.
@@ -40 +41 @@
 function SaveNew()
 {
-  global $Database, $Config;
+  global $Database, $Config, $User;
   
   if(array_key_exists('text', $_POST)) 
   {
-    $querty = 'INSERT INTO `News` ( `Time` ,`User` ,`Text`) VALUES ( NOW( ) , '.$_SESSION['UserID'].', "'.$_POST['text'].'")';
+    $querty = 'INSERT INTO `News` ( `Time` ,`User` ,`Text`) VALUES ( NOW( ) , '.$User->Id.', "'.$_POST['text'].'")';
     $Database->SQLCommand($querty);
     echo('Aktualita uložena!');
@@ -64 +65 @@
     ' AND (NOT EXISTS (SELECT `ID` FROM `Dictionary` WHERE `User`.`ID` = `Dictionary`.`User`))'. // Without dictionary words
     ' AND (NOT EXISTS (SELECT `Id` FROM `News` WHERE `User`.`ID` = `News`.`User`))'. // Without news
-    ' AND (NOT EXISTS (SELECT `ID` FROM `ShoutBox` WHERE `User`.`User` = `ShoutBox`.`User`))'. // Without shoutbox messages
+    ' AND (NOT EXISTS (SELECT `ID` FROM `ShoutBox` WHERE `User`.`Name` = `ShoutBox`.`User`))'. // Without shoutbox messages
     '';
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `User`'.$Condition);
@@ -112 +113 @@
 }
 
-if(Licence(LICENCE_ADMIN))
+if($User->Licence(LICENCE_ADMIN))
 {
   if(array_key_exists('action', $_GET))

trunk/dictionary.php

@@ -91 +91 @@
 if(!isset($_SESSION['language'])) 
 {
-  if(Licence(LICENCE_USER)) 
-  {
-    $DbResult = $Database->SQLCommand('SELECT `Language` FROM `User` WHERE `ID`='.$_SESSION['UserID']);
-    $User = mysql_fetch_assoc($DbResult);
-    $_SESSION['language'] = $User['Language'];
+  if($User->Licence(LICENCE_USER)) 
+  {
+    $_SESSION['language'] = $User->Language;
   } else $_SESSION['language'] = 1;
 }
@@ -127 +125 @@
   if(array_key_exists('action', $_GET)) 
   {
-    if(($_GET['action'] == 'insert')  and Licence(LICENCE_USER))
+    if(($_GET['action'] == 'insert')  and $User->Licence(LICENCE_USER))
     {
       echo('<form action="dictionary.php?action=save" method="post">'.
@@ -140 +138 @@
       '</form>');    
     } else
-    if(($_GET['action'] == 'save') and Licence(LICENCE_USER))
+    if(($_GET['action'] == 'save') and $User->Licence(LICENCE_USER))
     {
       if(array_key_exists('Original', $_POST) and array_key_exists('Translated', $_POST) and array_key_exists('Description', $_POST))
@@ -157 +155 @@
         }
       
-        $DbResult = $Database->SQLCommand('SELECT `Id` FROM `Dictionary` WHERE `Entry` = '.$Entry.' AND `Language`='.$_SESSION['language'].' AND `User`='.$_SESSION['UserID']);
+        $DbResult = $Database->SQLCommand('SELECT `Id` FROM `Dictionary` WHERE `Entry` = '.$Entry.' AND `Language`='.$_SESSION['language'].' AND `User`='.$User->Id);
         if(mysql_num_rows($DbResult) > 0)
         {
@@ -163 +161 @@
           $Database->SQLCommand('UPDATE `Dictionary` SET `Text`="'.$_POST['Translated'].'", `Description` = "'.$_POST['Description'].'" WHERE Id='.$DbRow['Id']);
         } else      
-          $Database->SQLCommand('INSERT INTO `Dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Translated'].'", "'.$Entry.'", "'.$_POST['Description'].'", '.$_SESSION['UserID'].', '.$_SESSION['language'].')');
+          $Database->SQLCommand('INSERT INTO `Dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Translated'].'", "'.$Entry.'", "'.$_POST['Description'].'", '.$User->Id.', '.$_SESSION['language'].')');
         echo('Záznam byl uložen!');
       } else echo('Nebyly zaslány všechny položky formuláře.');
     } else
-    if(($_GET['action'] == 'remove') and Licence(LICENCE_USER))
-    {
-      $Database->SQLCommand('DELETE FROM `Dictionary` WHERE `User`='.$_SESSION['UserID'].' AND `Language`='.$_SESSION['language'].' AND `Entry`='.$_GET['entry']);
+    if(($_GET['action'] == 'remove') and $User->Licence(LICENCE_USER))
+    {
+      $Database->SQLCommand('DELETE FROM `Dictionary` WHERE `User`='.$User->Id.' AND `Language`='.$_SESSION['language'].' AND `Entry`='.$_GET['entry']);
     } else
-    if(($_GET['action'] == 'modify')  and Licence(LICENCE_USER))
-    {
-      $DbResult = $Database->SQLCommand('SELECT * FROM `Dictionary` WHERE `User`='.$_SESSION['UserID'].' AND `Entry`='.$_GET['entry'].' AND `Language`='.$_SESSION['language']);
+    if(($_GET['action'] == 'modify')  and $User->Licence(LICENCE_USER))
+    {
+      $DbResult = $Database->SQLCommand('SELECT * FROM `Dictionary` WHERE `User`='.$User->Id.' AND `Entry`='.$_GET['entry'].' AND `Language`='.$_SESSION['language']);
       $DbRow = mysql_fetch_assoc($DbResult);
       $DbResult = $Database->SQLCommand('SELECT * FROM `Dictionary` WHERE `User`=0 AND `Entry`='.$_GET['entry'].' AND `Language`=0');
@@ -199 +197 @@
     <input type="text" value="'.$Search.'" name="search" size="30" />
     <input type="submit" value="Vyhledat" />');
-  if(Licence(LICENCE_USER)) echo(' <a href="dictionary.php?action=insert">Vložit slovo</a>');
+  if($User->Licence(LICENCE_USER)) echo(' <a href="dictionary.php?action=insert">Vložit slovo</a>');
            
   echo('</td></tr>'); 
@@ -231 +229 @@
     array('Name' => 'UserName', 'Title' => 'Překladatel'), 
   );
-  if(Licence(LICENCE_USER)) $TableColumns[] = array('Name' => '', 'Title' => 'Akce');
+  if($User->Licence(LICENCE_USER)) $TableColumns[] = array('Name' => '', 'Title' => 'Akce');
   $Order = GetOrderTableHeader($TableColumns, 'Original');
   echo('<table width="98%" class="BaseTable">');
@@ -245 +243 @@
     <td>'.$Line['Description'].'</td>
     <td>'.$Line['UserName'].'</td>');
-    if(Licence(LICENCE_USER))
-    {
-      if($Line['UserID'] == $_SESSION['UserID']) 
+    if($User->Licence(LICENCE_USER))
+    {
+      if($Line['UserID'] == $User->Id) 
         echo('<td><a href="?action=remove&amp;entry='.$Line['Entry'].'">Smazat</a> <a href="?action=modify&amp;entry='.$Line['Entry'].'">Upravit</a></td>');
         else echo('<td></td>');

trunk/download.php

@@ -29 +29 @@
 
   /*
-   if (array_key_exists('createverse', $_GET) and Licence(LICENCE_ADMIN)) {
+   if (array_key_exists('createverse', $_GET) and $User->Licence(LICENCE_ADMIN)) {
     if (array_key_exists('verse', $_POST)) { //ukládání
         $Database->SQLCommand('INSERT INTO `CzWoWPackageVersion` (`Version` ,`Date` ,`Text` ,`User`)

trunk/export/create_addon.php

@@ -174 +174 @@
     $Group = $TranslationTree[14]; // client table
     $Column['Column'] = 'Text';
-    $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original, T3.ShortCut FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.$this->ClientVersion['BuildNumber'].' AND VersionEnd >= '.$this->ClientVersion['BuildNumber'].' AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
+    $Query = 'SELECT `T2`.`'.$Column['Column'].'` AS `Translation`, `T3`.`'.$Column['Column'].'` AS `Original`, `T3`.`ShortCut` FROM (SELECT `T1`.`Entry`, `T1`.`'.$Column['Column'].'` FROM (SELECT `Entry`,`'.$Column['Column'].'` FROM '.$Group['TablePrefix'].' WHERE (`Complete` = 1) AND (`VersionStart` <= '.$this->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$this->ClientVersion['BuildNumber'].') AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS `T1` GROUP BY `T1`.`Entry`) AS `T2` JOIN `'.$Group['TablePrefix'].'` AS `T3` ON (`T2`.`Entry` = `T3`.`Entry`) AND (`T3`.`Language` = 0)';
     $DbResult = $this->Database->query($Query);
     while($Line = $DbResult->fetch_array()) 

trunk/export/export.php

@@ -11 +11 @@
   var $SelectedUsers;
   var $UserNames;
-  var $User;
   var $ClientVersion;
   var $OrderByUserList;
@@ -38 +37 @@
     $this->UserNames = '';
     $DbResult = $this->Database->query('SELECT `ExportUser`.*, `User`.`Name`, `User`.`ID` FROM `ExportUser` LEFT JOIN `User` ON `User`.`ID`=`ExportUser`.`User` WHERE `ExportUser`.`Export`='.$this->Id.' ORDER BY `ExportUser`.`Sequence`');
-    while($User = $DbResult->fetch_assoc())
-    {
-      $this->SelectedUsers .= ','.$User['ID'];
-      $this->UserNames .= ','.$User['Name'];
+    while($UserLine = $DbResult->fetch_assoc())
+    {
+      $this->SelectedUsers .= ','.$UserLine['ID'];
+      $this->UserNames .= ','.$UserLine['Name'];
     }
     $this->SelectedUsers = substr($this->SelectedUsers, 1);
@@ -56 +55 @@
     }
     
-    // Load logged user
-    if(isset($_SESSION) and ($_SESSION['UserID'] != ''))
-    {
-      $DbResult = $this->Database->query('SELECT `Name` FROM `User` WHERE `ID`='.$_SESSION['UserID']);
-      $this->User = $DbResult->fetch_assoc();
-    } else $this->User = array('User' => 'Neznámý');
-
-
     $DbResult = $this->Database->query('SELECT * FROM `ClientVersion` WHERE `Id`='.$this->Export['ClientVersion']);
     $this->ClientVersion = $DbResult->fetch_assoc();    
@@ -70 +61 @@
   function ExportToMangosSQL()
   {
-    global $TranslationTree, $LanguageList;
+    global $TranslationTree, $LanguageList, $User, $Config;
   
     $this->LoadFilters();
@@ -82 +73 @@
       "-- Znaková sada: ".$this->Config['Database']['Charset']." / ".$this->Config['Web']['Charset']."\n".
       "-- Diakritika: ".$this->AnoNe[$this->Export['WithDiacritic']]."\n".
-      "-- Vygeneroval uživatel: ".$this->User['Name']."\n".
+      "-- Vygeneroval uživatel: ".$User->Name."\n".
       "-- Vzato od uživatelů: ".$this->UserNames."\n".
       "-- Generované tabulky: ";
@@ -89 +80 @@
     while($Group = $DbResult->fetch_assoc())
     {
-       $Buffer .= $Group['MangosTable'].', ';
+      $Buffer .= $Group['TablePrefix'].', ';
     }
     $Buffer .= "\n\n";  
@@ -146 +137 @@
       {
         $Ori_text = $Line['name'];
-        $DbResult2 = $Database2->query('SELECT `text` AS en,
-        (SELECT `text` FROM `'.$Config['Database']['Database'].'`.`global_strings` AS `tabletran`
-         WHERE `tableen`.`entry` = `tabletran`.`entry` AND (`Complete` = 1) AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.' LIMIT 1) AS `tran`
-         FROM `'.$Config['Database']['Database'].'`.`global_strings` AS `tableen` WHERE
-          `text` = "'.addslashes($Ori_text).'" LIMIT 1');
+        $DbResult2 = $Database2->query('SELECT `Text` AS `En`,
+        (SELECT `Text` FROM `'.$Config['Database']['Database'].'`.`TextGlobalString` AS `TableTran`
+         WHERE `TableEn`.`Entry` = `TableTran`.`Entry` AND (`Complete` = 1) AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.' LIMIT 1) AS `Tran`
+         FROM `'.$Config['Database']['Database'].'`.`TextGlobalString` AS `TableEn` WHERE
+          `Text` = "'.addslashes($Ori_text).'" LIMIT 1');
         $Tran = $DbResult2->fetch_assoc();
         //echo ($Line['name'].'='.$Tran['tran']);
-        if($Tran['tran'] == '') 
+        if($Tran['Tran'] == '') 
         {
-          $DbResult2 = $Database2->query('SELECT `OptionText` AS `en`,
-          (SELECT `OptionText` FROM `'.$this->Config['Database']['Database'].'`.`npc_option` AS `tabletran`
-           WHERE `tableen`.`entry` = `tabletran`.`entry` AND (`Complete` = 1) AND '.$this->WhereLang.'
-            AND '.$this->WhereUsers.$this->OrderByUserList.' LIMIT 1) AS `tran`
-          FROM `'.$this->Config['Database']['Database'].'`.`npc_option` AS `tableen` WHERE
+          $DbResult2 = $Database2->query('SELECT `OptionText` AS `En`,
+          (SELECT `OptionText` FROM `'.$this->Config['Database']['Database'].'`.`TextNPCOption` AS `TableTran`
+           WHERE `TableEn`.`Entry` = `TableTran`.`Entry` AND (`Complete` = 1) AND '.$this->WhereLang.'
+            AND '.$this->WhereUsers.$this->OrderByUserList.' LIMIT 1) AS `Tran`
+          FROM `'.$this->Config['Database']['Database'].'`.`TextNPCOption` AS `TableEn` WHERE
             `OptionText` = "'.addslashes($Ori_text).'" LIMIT 1');
           $Tran = $DbResult2->fetch_assoc();
         }
         
-        if($Tran['tran'] <> '')
-          $Buffer .= 'UPDATE `'.$AoWoWTable.'` SET `name` = "'.addslashes($Tran['tran']).'" WHERE '.$IndexColum.' = '.$Line[$IndexColum].' ;'."\n";
+        if($Tran['Tran'] <> '')
+          $Buffer .= 'UPDATE `'.$AoWoWTable.'` SET `name` = "'.addslashes($Tran['Tran']).'" WHERE '.$IndexColum.' = '.$Line[$IndexColum].' ;'."\n";
       }
       $Buffer .= "\n\n";  
@@ -176 +167 @@
   function ExportToXML()
   {
-    global $TranslationTree, $LanguageList;
+    global $TranslationTree, $LanguageList, $User;
   
     $this->LoadFilters($this->Id);
@@ -186 +177 @@
     "    <time>".date('r')."</time>\n".
     "    <diacritics mode=".'"'.$this->Export['WithDiacritic'].'"'." />\n".
-    "    <author>".$this->User['Name']."</author>\n".
+    "    <author>".$User->Name."</author>\n".
     "    <contributors>\n";
     foreach(explode(',', $this->UserNames) as $UserName)
@@ -209 +200 @@
       while($Line = $DbResult2->fetch_assoc()) 
       {
-        $Buffer .= '      <item id="'.$Line['entry'].'" user="'.$Line['UserName'].'">'."\n";
+        $Buffer .= '      <item id="'.$Line['Entry'].'" user="'.$Line['UserName'].'">'."\n";
         $Values = '';
         foreach($TranslationTree[$Group['Id']]['Items'] as $GroupItem)
@@ -242 +233 @@
          $columns = '';
          foreach($TranslationTree[$Group['Id']]['Items'] as $Column) {
-           $columns .= ' T.'.$Column['Column'].' as text'.$i.',';
+           $columns .= ' `T`.`'.$Column['Column'].'` AS `Text`'.$i.',';
            $i = $i+1;
          }
          
-         $querty = '"SELECT '.$columns.' T.Entry as entry FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$this->WhereLang.' AND '.$this->WhereUsers.' AND VersionStart <= '.$this->ClientVersion['BuildNumber'].' AND VersionEnd >= '.$this->ClientVersion['BuildNumber'].') AS T GROUP BY T.Entry"';
+         $querty = '"SELECT '.$columns.' `T`.`Entry` AS `Entry` FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (`Complete` = 1) AND '.$this->WhereLang.' AND '.$this->WhereUsers.' AND (`VersionStart` <= '.$this->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$this->ClientVersion['BuildNumber'].')) AS `T` GROUP BY `T`.`Entry`"';
       
        $params = '-u '.$Config['Database']['User'].' -p '.$Config['Database']['Password'].' -f ../source/'.$this->ClientVersion['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc -n '.$this->TempDir.'dbc/'.$Group['DBCFileName'].'.dbc -c '.GetDBCColumns($this->ClientVersion['Version'], $Group['DBCFileName']).' -q '.$querty;

trunk/export/index.php

@@ -6 +6 @@
 function ExportList()
 {
-  global $Database;
+  global $Database, $User;
   
   echo('<a href="?Action=ViewList">Všechny</a>');
-  if(Licence(LICENCE_USER))
+  if($User->Licence(LICENCE_USER))
   {
     echo(' <a href="?Action=ViewList&amp;Filter=Others">Ostatních</a>');
@@ -18 +18 @@
   if(array_key_exists('Filter', $_GET))
   {
-    if($_GET['Filter'] == 'My') $Filter = ' WHERE `Export`.`User` = '.$_SESSION['UserID'];
-    if($_GET['Filter'] == 'Others') $Filter = ' WHERE `Export`.`User` != '.$_SESSION['UserID'];
+    if($_GET['Filter'] == 'My') $Filter = ' WHERE `Export`.`User` = '.$User->Id;
+    if($_GET['Filter'] == 'Others') $Filter = ' WHERE `Export`.`User` != '.$User->Id;
   }
   
@@ -46 +46 @@
   {
     $Action = '<a href="?Action=View&amp;ExportId='.$Export['Id'].'">Zobrazit</a> <a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=6">Exportovat</a>';
-    if($Export['User'] == $_SESSION['UserID']) $Action .= ' <a href="?Action=Delete&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\'Opravdu smazat položku?\');">Smazat</a>';
+    if($Export['User'] == $User->Id) $Action .= ' <a href="?Action=Delete&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\'Opravdu smazat položku?\');">Smazat</a>';
     echo('<tr><td>'.HumanDate($Export['TimeCreate']).'</td><td>'.$Export['UserName'].'</td><td>'.$Export['Title'].'</td><td>'.$Export['UsedCount'].'</td><td>'.$Export['UserCount'].'</td><td>'.$Export['GroupCount'].'</td><td>'.$Action.'</td></tr>');
   }
@@ -52 +52 @@
   echo($PageList['Output']);
     
-  if(Licence(LICENCE_USER)) echo('<br/><div style="text-align: center;"><a href="?Action=Create">Vytvořit nový export</a></div>');
+  if($User->Licence(LICENCE_USER)) echo('<br/><div style="text-align: center;"><a href="?Action=Create">Vytvořit nový export</a></div>');
 }
 
 function ExportCreate()
 {
-  global $Database, $Config;
-  
-  if(Licence(LICENCE_USER))
+  global $Database, $Config, $User;
+  
+  if($User->Licence(LICENCE_USER))
   {   
-    $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM Export WHERE User='.$_SESSION['UserID']);
+    $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Export` WHERE `User`='.$User->Id);
     $DbRow = mysql_fetch_row($DbResult);
     if($DbRow[0] < $Config['MaxExportPerUser'])
@@ -77 +77 @@
 function ExportCreateFinish()
 {
-  global $Database, $Config;
-  
-  if(Licence(LICENCE_USER))
+  global $Database, $Config, $User;
+  
+  if($User->Licence(LICENCE_USER))
   {   
     if(array_key_exists('Title', $_POST) and array_key_exists('Description', $_POST))
     {
-      $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Export` WHERE `User`='.$_SESSION['UserID']);
+      $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Export` WHERE `User`='.$User->Id);
       $DbRow = mysql_fetch_row($DbResult);
       if($DbRow[0] < $Config['MaxExportPerUser'])
       {
-        $Database->SQLCommand('INSERT INTO `Export` (`Title`, `User`, `TimeCreate`, `WithDiacritic`, `Description`) VALUES ("'.$_POST['Title'].'", '.$_SESSION['UserID'].', NOW(), 1, "'.$_POST['Description'].'")');
+        $Database->SQLCommand('INSERT INTO `Export` (`Title`, `User`, `TimeCreate`, `WithDiacritic`, `Description`) VALUES ("'.$_POST['Title'].'", '.$User->Id.', NOW(), 1, "'.$_POST['Description'].'")');
         $ExportId = mysql_insert_id();
         echo('Nový export vytvořen.<br/>Přímý odkaz na tento export: <a href="?Action=View&amp;ExportId='.$ExportId.'">zde</a><br/><br/>');
@@ -100 +100 @@
 function ExportDelete()
 {
-  global $Database;
-  
-  if(Licence(LICENCE_USER))
+  global $Database, $User;
+  
+  if($User->Licence(LICENCE_USER))
   {   
     if(array_key_exists('ExportId', $_GET))
     {
-      $DbResult = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId'].' AND User='.$_SESSION['UserID']);
+      $DbResult = $Database->SQLCommand('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId'].' AND `User`='.$User->Id);
       if(mysql_num_rows($DbResult) > 0)
       {
-        $Database->SQLCommand('DELETE FROM Export WHERE Id='.$_GET['ExportId']);
+        $Database->SQLCommand('DELETE FROM `Export` WHERE `Id`='.$_GET['ExportId']);
         DeleteDirectory('../tmp/Export/'.$_GET['ExportId'].'/');
         echo('Export smazán.<br/><br/>');
@@ -122 +122 @@
 function ExportViewTranslators()
 {
-  global $Database, $TranslationTree, $Config;
+  global $Database, $TranslationTree, $Config, $User;
 
   $DisabledInput = array(false => ' disabled="disabled"', true => '');
@@ -131 +131 @@
     {    
       $Export = mysql_fetch_assoc($DbRows);
-      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+      if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true; 
         else $Editable = false;
         
@@ -204 +204 @@
   $Database->SQLCommand('SET @I = 0');
   $DbResult = $Database->SQLCommand($Query);
-  while($User = mysql_fetch_assoc($DbResult))
-  {
-    $Checked = $User['Sequence'] != '';
-    $Selection = CheckBox('sel'.$User['ID'], $Checked, '', 'CheckBox', !$Editable);
-    $Sequence = '<input type="text" name="seq'.$User['ID'].'" style="text-align: center; width: 40px;" value="'.$User['Sequence2'].'"'.$DisabledInput[$Editable].'/>';
+  while($UserLine = mysql_fetch_assoc($DbResult))
+  {
+    $Checked = $UserLine['Sequence'] != '';
+    $Selection = CheckBox('sel'.$UserLine['ID'], $Checked, '', 'CheckBox', !$Editable);
+    $Sequence = '<input type="text" name="seq'.$UserLine['ID'].'" style="text-align: center; width: 40px;" value="'.$UserLine['Sequence2'].'"'.$DisabledInput[$Editable].'/>';
     echo('<tr>
-    <td><a href="'.$Config['Web']['BaseURL'].'/TranslationList.php?user='.$User['ID'].'&amp;action=userall" title="Zobrazit všechny jeho přeložené texty">'.$User['Name'].'</a></td>
-    <td>'.$User['TranslatedCount'].'</td>
-      <td><img src="'.$Config['Web']['TempFolder'].'/user/'.$User['Name'].'/level.png" alt="Úroveň uživatele" /></td>
+    <td><a href="'.$Config['Web']['BaseURL'].'/TranslationList.php?user='.$UserLine['ID'].'&amp;action=userall" title="Zobrazit všechny jeho přeložené texty">'.$UserLine['Name'].'</a></td>
+    <td>'.$UserLine['TranslatedCount'].'</td>
+      <td><img src="'.$Config['Web']['TempFolder'].'/user/'.$UserLine['Name'].'/level.png" alt="Úroveň uživatele" /></td>
     <td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>');
   }
@@ -224 +224 @@
 function ExportViewGeneral()
 {
-  global $Database;
+  global $Database, $User;
   
   $DisabledInput = array(false => ' disabled="disabled"', true => '');
@@ -235 +235 @@
     {    
       $Export = mysql_fetch_assoc($DbRows);
-      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+      if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true; 
         else $Editable = false;
       if($Editable and array_key_exists('Title', $_POST) and array_key_exists('Description', $_POST))
@@ -264 +264 @@
 function ExportViewLanguages()
 {
-  global $Database, $TranslationTree, $Config;
+  global $Database, $TranslationTree, $Config, $User;
 
   $DisabledInput = array(false => ' disabled="disabled"', true => '');
@@ -273 +273 @@
     {    
       $Export = mysql_fetch_assoc($DbRows);
-      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+      if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true; 
         else $Editable = false;
         
@@ -357 +357 @@
 function ExportViewGroups()
 {
-  global $Database, $TranslationTree, $Config;
+  global $Database, $TranslationTree, $Config, $User;
 
   $DisabledInput = array(false => ' disabled="disabled"', true => '');
@@ -366 +366 @@
     {    
       $Export = mysql_fetch_assoc($DbRows);
-      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+      if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true; 
         else $Editable = false;
         
@@ -446 +446 @@
 function ExportViewOutputFormat()
 {
-  global $Database;
+  global $Database, $User;
   
   $DisabledInput = array(false => ' disabled="disabled"', true => '');
@@ -455 +455 @@
     {    
       $Export = mysql_fetch_assoc($DbRows);
-      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+      if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true; 
         else $Editable = false;
   
@@ -485 +485 @@
 function ExportViewVersion()
 {
-  global $Database, $Config;
+  global $Database, $Config, $User;
 
   $DisabledInput = array(false => ' disabled="disabled"', true => '');
@@ -494 +494 @@
     {    
       $Export = mysql_fetch_assoc($DbRows);
-      if(Licence(LICENCE_USER) and ($_SESSION['UserID'] == $Export['User'])) $Editable = true; 
+      if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true; 
         else $Editable = false;
         
@@ -572 +572 @@
   $Export = mysql_fetch_assoc($DbResult);
   $DbResult = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID`='.$Export['User']);
-  $User = mysql_fetch_assoc($DbResult);
-  echo('Export <strong><a href="?Action=View&amp;Tab=6&amp;ExportId='.$Export['Id'].'">'.$_GET['ExportId'].'</a></strong> překladatele <strong>'.$User['Name'].'</strong> s označením <strong>'.$Export['Title'].'</strong>');
+  $UserLine = mysql_fetch_assoc($DbResult);
+  echo('Export <strong><a href="?Action=View&amp;Tab=6&amp;ExportId='.$Export['Id'].'">'.$_GET['ExportId'].'</a></strong> překladatele <strong>'.$UserLine['Name'].'</strong> s označením <strong>'.$Export['Title'].'</strong>');
   ShowTabs(array('Obecné', 'Překladatelé', 'Překlady', 'Jazyky', 'Formát', 'Verze', 'Výstup'));
   echo('<div id="content">');

trunk/form.php

@@ -21 +21 @@
   if(!$Line) die('Anglický originál k překladu nenalezen.');
   
-  $User = @$_SESSION['User'];
   $IDUser = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$Line['User']);
   $LineUser = mysql_fetch_array($IDUser);
@@ -77 +76 @@
 //    Speciální znaky: $B - Odřádkování, $N - Jméno, $C - povolání
   echo('<form action="save.php?group='.$GroupId.'" method="post"><div>');
-  if(Licence(LICENCE_USER)) 
+  if($User->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>');
@@ -91 +90 @@
   
   echo('<input type="hidden" name="entry" value="'.$LineAJ['Entry'].'" />
-    <input type="hidden" name="user" value="'.$User.'" />
+    <input type="hidden" name="user" value="'.$User->Id.'" />
     <input type="hidden" name="ID" value="'.$TextID.'" />
     <table class="BaseTable">
@@ -105 +104 @@
           Přeloženo do:'); 
   if($Line['Language'] <> 0) $Language = $Line['Language']; 
-  else if($_SESSION['UserID'] != '')
+  else if($User->Id != 0)
   {
-    $IDUser = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$_SESSION['UserID']);
-    $LineUser = mysql_fetch_array($IDUser);
-    $Language = $LineUser['Language'];  // jiný user vyčítám
+    $Language = $User->Language;
   } else $Language = 0;
   WriteLanguages($Language);

trunk/includes/config.sample.php

@@ -14 +14 @@
   'Style' => 'maron',
   'Web' => array(
+    'Title' => 'Projekt překládání textů WoW',
     'Charset' => 'utf-8',
     'BaseURL' => 'http://localhost/',
@@ -23 +24 @@
     'ItemsPerPage' => 40,
     'TempFolder' => '../tmp/',
-    'GameVersion' => '3.0.3',
+    'GameVersion' => '3.3.2',
     'VisiblePagingItems' => 20,
   ),

trunk/includes/global.php

@@ -14 +14 @@
 foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($_GET[$Index]);
 
-include_once('config.php');
-include_once('error.php');
-include_once('databaseconection.php');
-include_once('global_function.php');
-include_once('rss.php');
-include_once('system.php');
+include_once(dirname(__FILE__).'/config.php');
+include_once(dirname(__FILE__).'/error.php');
+include_once(dirname(__FILE__).'/databaseconection.php');
+include_once(dirname(__FILE__).'/global_function.php');
+include_once(dirname(__FILE__).'/rss.php');
+include_once(dirname(__FILE__).'/system.php');
+include_once(dirname(__FILE__).'/user.php');
 
 $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
@@ -30 +31 @@
 $System = new System();
 $System->Init();
+$User = new User();
+$User->Restore();
 
 function GetMicrotime()
@@ -39 +42 @@
 function ShowShoutbox()
 {
-  global $Database, $Config;
+  global $Database, $Config, $User;
   
   echo('<strong><a href="'.$Config['Web']['BaseURL'].'action.php?action=ShoutBoxView">Kecátko:</a></strong>');
-  if(Licence(LICENCE_USER)) echo(' <a href="'.$Config['Web']['BaseURL'].'action.php?action=shoutbox">Vložit</a>');
+  if($User->Licence(LICENCE_USER)) 
+    echo(' <a href="'.$Config['Web']['BaseURL'].'action.php?action=shoutbox">Vložit</a>');
   echo('<div class="box"><table>');
   $ID = $Database->SQLCommand('SELECT * FROM `ShoutBox` ORDER BY `ID` DESC LIMIT 20');
@@ -52 +56 @@
 function ShowTopBar()
 {
-  global $Config, $Database;
+  global $Config, $Database, $User;
   
   echo('<div class="Menu">');
-    echo('<span class="MenuItem"></span>');
-  if(Licence(LICENCE_USER))
-  {
-    $DbResult = $Database->SQLCommand('SELECT `Team`, `Name` FROM `User` WHERE ID='.$_SESSION['UserID']);
-    $User = mysql_fetch_assoc($DbResult);
-    $DbResult = $Database->SQLCommand('SELECT `Id`, `Name` FROM `Team` WHERE Id='.$User['Team']);
+  echo('<span class="MenuItem"></span>');
+  if($User->Licence(LICENCE_USER))
+  {
+    $DbResult = $Database->SQLCommand('SELECT `Id`, `Name` FROM `Team` WHERE `Id`='.$User->Team);
     $Team = mysql_fetch_assoc($DbResult);
 
     //echo('<span class="MenuItem">Moje překlady: <a href="">Dokončené</a> <a href="">Rozpracované</a> <a href="">Exporty</a> Tým: <a href="">'.$Team['name'].'</a></span>');
-    echo('<span class="MenuItem2">'.$User['Name'].' <a href="'.$Config['Web']['BaseURL'].'?Logout">Odhlášení</a> <a href="'.$Config['Web']['BaseURL'].'Options.php">Nastavení</a></span>');
+    echo('<span class="MenuItem2">'.$User->Name.' <a href="'.$Config['Web']['BaseURL'].'?action=logout">Odhlášení</a> <a href="'.$Config['Web']['BaseURL'].'Options.php">Nastavení</a></span>');
   } else 
   {
-    echo('<span class="MenuItem2"><form action="?" method="post"> Jméno: <input type="text" name="LoginUser" size="8 " /> Heslo: <td><input type="password" name="LoginPass" size="8" /> <input type="submit" value="Přihlásit" /></form> &nbsp; <a href="'.$Config['Web']['BaseURL'].'registrace.php">Registrace</a></span>');
+    echo('<span class="MenuItem2"><form action="?action=login" method="post"> Jméno: <input type="text" name="LoginUser" size="8 " /> Heslo: <td><input type="password" name="LoginPass" size="8" /> <input type="submit" value="Přihlásit" /></form> &nbsp; <a href="'.$Config['Web']['BaseURL'].'registrace.php">Registrace</a></span>');
   }
   echo('</div>');
@@ -74 +76 @@
 function ShowLoginBox()
 {
-  if(Licence(LICENCE_USER)) 
-  {
-     // echo 'Jste přihlášen jako: <b>'.$_SESSION['User'].'</b> <a href="index.php?Logout">Odhlásit</a>';
+  global $User;
+  
+  if($User->Licence(LICENCE_USER)) 
+  {
+     // echo 'Jste přihlášen jako: <b>'.$User->Id.'</b> <a href="index.php?Logout">Odhlásit</a>';
   } else 
   {
@@ -116 +120 @@
 function ShowMainMenu()
 { 
-  global $TranslationTree, $Config;
+  global $TranslationTree, $Config, $User;
   
   $Menu = array
@@ -140 +144 @@
   
   echo('<strong>Hlavní menu:</strong>'.
-    '<div class="verticalmenu"><ul>');
-
+    '<div class="verticalmenu"><ul>'); 
   foreach($Menu as $MenuTarget => $MenuItem)
   {
-  if(isset($MenuItem[3])) $OnClick = ' onclick="'.$MenuItem[3].'"'; else $OnClick = '';
-  if(Licence($MenuItem[0])) echo('<li><a class="verticalmenua" title="'.$MenuItem[1].'" href="'.$MenuTarget.'"'.$OnClick.'>'.$MenuItem[2].'</a></li>');
+    if(isset($MenuItem[3])) $OnClick = ' onclick="'.$MenuItem[3].'"'; 
+      else $OnClick = '';
+    if($User->Licence($MenuItem[0])) echo('<li><a class="verticalmenua" title="'.$MenuItem[1].'" href="'.$MenuTarget.'"'.$OnClick.'>'.$MenuItem[2].'</a></li>');
   }    
   echo('</ul></div>');
@@ -152 +156 @@
 function ShowTranslatedMenu()
 {
-  global $TranslationTree, $Config, $Database;
+  global $TranslationTree, $Config, $Database, $User;
 
   echo('<strong>Překladové skupiny:</strong><br /><div id="TranslationMenu">');
-  if(Licence(LICENCE_USER)) 
-  {
-    echo ('<a title="Všechny překlady, které jste přeložil" href="'.$Config['Web']['BaseURL'].'TranslationList.php?user='.$_SESSION['UserID'].'&amp;action=userall">Všechny moje texty</a><br />');
-    echo ('<a title="Všechny překlady, které jste rozepsal a nedokončil" href="'.$Config['Web']['BaseURL'].'TranslationList.php?user='.$_SESSION['UserID'].'&amp;not&amp;action=userall">Rozpracované texty</a>');
+  if($User->Licence(LICENCE_USER)) 
+  {
+    echo('<a title="Všechny překlady, které jste přeložil" href="'.$Config['Web']['BaseURL'].'TranslationList.php?user='.$User->Id.'&amp;action=userall">Všechny moje texty</a><br />');
+    echo('<a title="Všechny překlady, které jste rozepsal a nedokončil" href="'.$Config['Web']['BaseURL'].'TranslationList.php?user='.$User->Id.'&amp;not&amp;action=userall">Rozpracované texty</a>');
     //TODO: počet nedokončených  
-    echo ('<br /><br />');
+    echo('<br /><br />');
   }
   foreach($TranslationTree as $Group)
@@ -169 +173 @@
     echo('&nbsp;<a title="Zde můžete začít překládat" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=notran">Nepřeložené</a><br />
       &nbsp;<a title="Přeložené texty, můžete zde hlasovat, nebo opravovat překlady" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=Translate">Přeložené</a><br />');
-  $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE `Group` = '.$Group['Id']);
+    $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE `Group` = '.$Group['Id']);
     if (mysql_num_rows($ID) > 0)  
     echo('&nbsp;<a title="Vypsání souvislostí" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=connexion_list">Souvislosti</a><br />');
  
-  if(Licence(LICENCE_USER)) 
+    if($User->Licence(LICENCE_USER)) 
     {
       echo('&nbsp;<a title="Nedokončené překlady" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=mydevelop">Rozepsané</a><br />
@@ -186 +190 @@
 function ShowOnlineUserList()
 {
-  global $Database, $Moderators;
+  global $Database, $Moderators, $User;
   
   echo('Online překladatelé:<br />');
   $ID = $Database->SQLCommand('SELECT `Name`, `GM`, `ID` FROM `User` WHERE `LastLogin` >= NOW() - 300 AND ((`LastLogout` < `LastLogin`) OR (ISNULL(`LastLogout`)))');
-  while($User = mysql_fetch_assoc($ID))
-  {
-    if(Licence(LICENCE_MODERATOR)) $Name = '<a href="user.php?user='.$User['ID'].'">'.$User['Name'].'</a>';
-    else $Name = $User['Name'];
+  while($DbUser = mysql_fetch_assoc($ID))
+  {
+    if($User->Licence(LICENCE_MODERATOR)) $Name = '<a href="user.php?user='.$DbUser['ID'].'">'.$DbUser['Name'].'</a>';
+    else $Name = $DbUser['Name'];
     $TextGM = '';
     echo('<strong>'.$Name.'</strong>'.$TextGM.'<br />');
@@ -199 +203 @@
 }
 
-function CheckLogin()
-{
-  global $Database;
-  
-  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'] = '';
-
-  // Přihlášení
-  if(array_key_exists('LoginUser', $_POST))
-  {
-    $_SESSION['User'] = $_POST['LoginUser'];
-    $_SESSION['Pass'] = $_POST['LoginPass'];
-
-    $DbResult = $Database->SQLCommand('SELECT * FROM `User` WHERE LOWER(`Name`) = LOWER("'.$_SESSION['User'].'") AND `Pass` = sha1(CONCAT(sha1("'.$_SESSION['Pass'].'"), `Salt`))');
-    if(mysql_num_rows($DbResult) == 0)
-    {
-       echo('<script> alert("Jméno nebo heslo bylo zadáno špatně!"); </script>');
-       $_SESSION['UserID'] = ''; 
-       $_SESSION['User'] = '';
-       $_SESSION['Pass'] = '';
-    } else
-    {
-      $User = mysql_fetch_assoc($DbResult);
-      $_SESSION['UserID'] = $User['ID']; 
-      $_SESSION['User'] = $User['Name'];
-      WriteLog('Login: '.$_SESSION['User'], LOG_TYPE_USER);
-    }
-  }
-
-  // Odhlášení
-  if(array_key_exists('Logout', $_GET) and ($_SESSION['User'] != ''))  
-  {
-    WriteLog('Odhlášení', LOG_TYPE_USER);
-    if(is_numeric($_SESSION['UserID']))
-      $Database->SQLCommand('UPDATE `User` SET `LastLogout` = NOW() WHERE `ID` = '.$_SESSION['UserID']);
-    $_SESSION['User'] = '';
-    $_SESSION['Pass'] = '';
-    $_SESSION['UserID'] = '';
-  }
-
-  // Záznam o aktivitě
-  if(Licence(LICENCE_USER) and array_key_exists('REMOTE_ADDR', $_SERVER)) 
-    $Database->SQLCommand('UPDATE `User` SET `LastIP` = "'.$_SERVER['REMOTE_ADDR'].'", `LastLogin` = NOW() WHERE `ID` = '.$_SESSION['UserID']);
-}
-
 function ShowPage()
 {
-  global $Config, $Database, $RSSChannels, $PageFooterRequested;  
+  global $User, $Config, $Database, $RSSChannels, $PageFooterRequested;  
   
   echo('<?xml version="1.0" encoding="'.$Config['Web']['Charset'].'"?>
@@ -263 +221 @@
   foreach($RSSChannels as $Channel)
     echo(' <link rel="alternate" title="'.$Channel['Title'].'" href="'.$Channel['URL'].'" type="application/rss+xml" />');
-  echo('<title>Projekt překládání textů WoW</title>
+  echo('<title>'.$Config['Web']['Title'].'</title>
 </head>
 <body>
 <table id="bannertable"><tr>
   <td id="banner1"></td>
-  <td id="banner"><div id="bannertitle">Projekt překládání textů WoW</div></td>
+  <td id="banner"><div id="bannertitle">'.$Config['Web']['Title'].'</div></td>
   <td id="banner2"></td></tr>
 </table>');
 
-  CheckLogin();
+  if(array_key_exists('action', $_GET))
+  {
+    if($_GET['action'] == 'login')
+    {
+      $User->Login($_POST['LoginUser'], $_POST['LoginPass']);
+      if($User->Role == LICENCE_ANONYMOUS) echo('<script> alert("Jméno nebo heslo bylo zadáno špatně!"); </script>');  
+    } else 
+    if($_GET['action'] == 'logout')
+    {
+      if($User->Role != LICENCE_ANONYMOUS)
+      {
+        $User->Logout();
+        WriteLog('Odhlášení', LOG_TYPE_USER);
+      }
+    }
+  }
   ShowTopBar();
 
   echo('<table class="page"><tr><td class="menu">');
   ShowMainMenu();
-      
-  // echo('<br />');    
-  //ShowLoginBox();
-  //echo('<br />');
   ShowOnlineUserList();
   echo('<br />');
@@ -305 +274 @@
 function ShowFooter()
 {
-  global $Database, $Config, $ScriptStartTime, $PageFooterRequested;
+  global $Database, $Config, $ScriptStartTime, $PageFooterRequested, $User;
 
   if(isset($PageFooterRequested)) 
@@ -333 +302 @@
       '</html>');
     $Database->Disconnect();
+    $User->Store();
   } 
 }

trunk/includes/global_function.php

@@ -1 +1 @@
 <?php
-
-// User licence levels
-define('LICENCE_ANONYMOUS', -1);
-define('LICENCE_USER', 0);
-define('LICENCE_MODERATOR', 1);
-define('LICENCE_ADMIN', 2);
 
 // Log types
@@ -213 +207 @@
 }
 
-function Licence($Licence)
-{
-  global $Database;
- 
-  if($Licence == -1) return(true);
-  else
-  if(isset($_SESSION['User']) and ($_SESSION['User'] <> '') and ($_SESSION['UserID'] != '')) 
-  {
-    // $User = $_SESSION['User'];
-    $Pass = $_SESSION['Pass'];
-    $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$_SESSION['UserID'].' AND `GM` >= '.$Licence.' AND `Pass` = sha1(CONCAT(sha1("'.$Pass.'"), `Salt`))'));
-    return($Line);
-  } else 
-  { 
-    return(!isset($_SERVER['REMOTE_ADDR']));    
-  }
-}
-
 function MysqlDateTimeToTime($Time)
 {
@@ -274 +250 @@
 function WriteLog($Text, $Type)
 {
-  global $Database, $Config;
+  global $Database, $Config, $User;
  
-  if(!isset($_SERVER['REMOTE_ADDR']))
-  {
-    $user = 0;
-    $ip = 'Konzole';
-  } else 
-  {
-    if(array_key_exists('UserID', $_SESSION)) $user = $_SESSION['UserID'];
-      else $user = 0;
-    $ip = addslashes($_SERVER['REMOTE_ADDR']);
-  }
+  if(!isset($_SERVER['REMOTE_ADDR'])) $IP = 'Konzole';
+    else $IP = addslashes($_SERVER['REMOTE_ADDR']);
 
   $Database->SelectDatabase($Config['Database']['Database']);    
   $Query = 'INSERT INTO `Log` ( `User` , `Type` , `Text` , `Date` , `IP` )
-   VALUES ('.$user.', '.$Type.', "'.addslashes($Text).'", NOW(), "'.$ip.'")';
+   VALUES ('.$User->Id.', '.$Type.', "'.addslashes($Text).'", NOW(), "'.$IP.'")';
   $Database->SQLCommand($Query);
 }
@@ -535 +503 @@
 }
 
-function GetPasswordSalt()
-{
-  return(substr(sha1(mt_rand()), 0, 8));
-}
-
 function ErrorMessage($Text)
 {

trunk/log.php

@@ -45 +45 @@
   ShowPage();
   
-  if(Licence(LICENCE_MODERATOR))
+  if($User->Licence(LICENCE_MODERATOR))
   {
     echo('<strong>Filtr: </strong>');

trunk/registrace.php

@@ -2 +2 @@
 
 include('includes/global.php');
-
-ShowPage();
-  
+ 
 if(array_key_exists('user', $_POST)) 
 {
@@ -14 +12 @@
   $Language = $_POST['Language'];
   
-  if($User == '') die('Nelze použít prázdné jméno');
-  if($User == 'Addon') die('To jméno uživatele nemůžete použít');
+  if($UserName != '')
+  {
+    if($UserName != 'Addon') 
+    {
 
   if($Pass == $Pass2) 
   {
-    $Line = mysql_fetch_row($Database->SQLCommand('SELECT * FROM `User` WHERE `User` = "'.$User.'"'));
+    $Line = mysql_fetch_row($Database->SQLCommand('SELECT * FROM `User` WHERE `Name` = "'.$UserName.'"'));
     if(!$Line) 
     {
-      $Address = $_SERVER['REMOTE_ADDR'];
-      $Salt = GetPasswordSalt();
+      $Salt = $User->GetPasswordSalt();
       $Database->SQLCommand('INSERT INTO `User` (`Name` , `Pass` , `Salt`, `LastIP` , `LastLogin` , `Email` , `Language` , `Team` , `NeedUpdate`, `RegistrationTime` )
-      VALUES ("'.$UserName.'", sha1(CONCAT(sha1("'.$Pass.'"), "'.$Salt.'")), "'.$Salt.'", "'.$Address.'", NOW(), "'.$Email.'", '.$Language.', '.$Team.', 1, NOW())');
-      echo('Registrace proběhla úspěšně.<br />');
-      
-      $_SESSION['User'] = $UserName;
-      $_SESSION['Pass'] = $Pass;
-    
-      $Line = mysql_fetch_array($Database->SQLCommand('SELECT `ID` FROM `User` WHERE `Name` = "'.$_SESSION['User'].'"'));
-      $_SESSION['UserID'] = $Line['ID']; 
-      WriteLog('Uživatel se zaregistroval: '.$User, LOG_TYPE_USER);
-      
- // echo $Database->id_connection;
-    } else echo('Uživatel s touto přezdívkou již existuje. <a href="?">Zpět</a>');
-  } else echo('Hesla se neshodují. <a href="?">Zpět</a>');
+      VALUES ("'.$UserName.'", '.$User->CryptPasswordSQL('"'.$Pass.'"', '"'.$Salt.'"').', "'.$Salt.'", "'.$_SERVER['REMOTE_ADDR'].'", NOW(), "'.$Email.'", '.$Language.', '.$Team.', 1, NOW())');
+      $Message = 'Registrace proběhla úspěšně.<br />';
+      $User->Login($UserName, $Pass);
+      WriteLog('Uživatel se zaregistroval: '.$UserName, LOG_TYPE_USER);      
+    } else $Message = 'Uživatel se zadanou přezdívkou již existuje. <a href="?">Zpět</a>';
+  } else $Message = 'Hesla se neshodují. <a href="?">Zpět</a>';
+    } else $Message = 'To jméno uživatele nemůžete použít';
+  } else $Message = 'Nelze použít prázdné jméno';
+  ShowPage();
+  echo($Message);
+  ShowFooter();      
 } else 
 {
+  ShowPage();
   echo('<form action="?" method="post">
   <fieldset><legend>Registrace nového uživatele</legend>

trunk/save.php

@@ -6 +6 @@
 
 // Ochrana proti neoprávněnému přístupu
-//if(Licence(LICENCE_USER) == false) die('Nemáte přístup do této sekce! Je nutné se přihásit.');
+// if($User->Licence(LICENCE_USER) == false) die('Nemáte přístup do této sekce! Je nutné se přihásit.');
 
 $GroupId = LoadGroupIdParameter();
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
-if(array_key_exists('entry', $_POST) and Licence(LICENCE_USER)) 
+if(array_key_exists('entry', $_POST) and $User->Licence(LICENCE_USER)) 
 {
-  $entry = $_POST['entry'] * 1; // Make numeric  
-  $UserID = $_SESSION['UserID'];
+  $Entry = $_POST['entry'] * 1; // Make numeric  
   $TextID = $_POST['ID'] * 1;
   $Language = $_POST['Language'] * 1;
-  if(array_key_exists('End', $_POST)) $complete = 1;
+  if(array_key_exists('End', $_POST)) $Complete = 1;
     else $complete = 0;
              
-  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE (`Language` = 0) AND (`Entry` = '.$entry.')');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE (`Language` = 0) AND (`Entry` = '.$Entry.')');
   if(mysql_num_rows($DbResult) == 0) ErrorMessage('Neznámé Id položky'); 
   $LineAJ = mysql_fetch_array($DbResult);
   $LineTake = mysql_fetch_array($Database->SQLCommand('SELECT `VersionEnd`, `VersionStart` FROM `'.$Table.'` WHERE `ID` = '.$TextID));
   if(mysql_num_rows($DbResult) == 0) ErrorMessage('Neznámé Id položky');
-  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE (`User`='.$UserID.') AND (`Entry` = '.$entry.') AND (`VersionStart` = '.$LineTake['VersionStart'].') AND (`VersionEnd` = '.$LineTake['VersionEnd'].')');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE (`User`='.$User->Id.') AND (`Entry` = '.$Entry.') AND (`VersionStart` = '.$LineTake['VersionStart'].') AND (`VersionEnd` = '.$LineTake['VersionEnd'].')');
   $Line = mysql_fetch_array($DbResult);
   if(!$Line) 
   {
     $Columns = '`Language` , `User` , `Complete` , `Take` , `VersionStart` , `VersionEnd`';
-    $Values = $Language.','.$UserID.','.$complete.','.$TextID.','.$LineTake['VersionStart'].','.$LineTake['VersionEnd'];
+    $Values = $Language.','.$User->Id.','.$Complete.','.$TextID.','.$LineTake['VersionStart'].','.$LineTake['VersionEnd'];
     foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
     {
@@ -42 +41 @@
     }  
     //echo('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
-    //  $Database->SQLCommand('INSERT INTO `'.$Table.'` (`entry`, '.$Columns.') VALUES ('.$entry.','.$Values.')');
+    //  $Database->SQLCommand('INSERT INTO `'.$Table.'` (`Entry`, '.$Columns.') VALUES ('.$Entry.','.$Values.')');
     //  $LastID = mysql_insert_id();
 
@@ -69 +68 @@
     while($SameTranLine = mysql_fetch_assoc($SameTranID))
     {
-      $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE (`User`='.$UserID.') AND (`Entry` = '.$SameTranLine['Entry'].') AND (`VersionStart` = '.$LineTake['VersionStart'].') AND (`VersionEnd` = '.$LineTake['VersionEnd'].')'));
+      $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE (`User`='.$User->Id.') AND (`Entry` = '.$SameTranLine['Entry'].') AND (`VersionStart` = '.$LineTake['VersionStart'].') AND (`VersionEnd` = '.$LineTake['VersionEnd'].')'));
       if(!$Line) 
       {
@@ -94 +93 @@
     // Konec kontrolování stejných textů    
         
-    echo('Překlad <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> ('.$entry.') uložen!<br />');
+    echo('Překlad <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> ('.$Entry.') uložen!<br />');
     foreach($LastIDs as $LastID)
     {
@@ -102 +101 @@
   } else
   {
-    $sql = 'UPDATE '.$Table.' SET `Complete` = '.$complete;
+    $sql = 'UPDATE '.$Table.' SET `Complete` = '.$Complete;
     foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
     if(array_key_exists($GroupItem['Column'], $_POST))
@@ -110 +109 @@
     $Database->SQLCommand($sql);
     //  echo $sql.'<br />';      
-    echo('Změny v překladu <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> ('.$entry.') uloženy!<br />');
-    WriteLog('Změny v překladu <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> ('.$entry.') uloženy!', LOG_TYPE_TRANSLATION);
+    echo('Změny v překladu <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> ('.$Entry.') uloženy!<br />');
+    WriteLog('Změny v překladu <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> ('.$Entry.') uloženy!', LOG_TYPE_TRANSLATION);
   }
   // Address and redirecting
@@ -119 +118 @@
   $next = FollowingTran($TextID, $Table, $GroupId);
   echo('<br /><br />');
-  $redirecting = mysql_fetch_assoc($Database->SQLCommand('SELECT `Redirecting` FROM `User` WHERE `ID`='.$UserID));
+  $redirecting = mysql_fetch_assoc($Database->SQLCommand('SELECT `Redirecting` FROM `User` WHERE `ID`='.$User->Id));
     
   switch($redirecting['Redirecting']) 
@@ -145 +144 @@
     
   // Aktualizace informace o nutnosti načíst XP
-  $Database->SQLCommand('UPDATE `User` SET `NeedUpdate` = 1 WHERE `ID` = '.$UserID); 
+  $Database->SQLCommand('UPDATE `User` SET `NeedUpdate` = 1 WHERE `ID` = '.$User->Id); 
 } else 
 {

trunk/sql/structure.sql

@@ -4 +4 @@
 --
 -- Počítač: localhost
--- Vygenerováno: Středa 03. března 2010, 12:56
+-- Vygenerováno: Čtvrtek 11. března 2010, 08:27
 -- Verze MySQL: 5.1.42
 -- Verze PHP: 5.3.1
@@ -17 +17 @@
 
 --
--- Struktura tabulky `achievement`
---
-
-CREATE TABLE IF NOT EXISTS `achievement` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `Name` text NOT NULL,
-  `Description` text NOT NULL,
-  `Reward` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2718 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `achievement_category`
---
-
-CREATE TABLE IF NOT EXISTS `achievement_category` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `Name` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=205 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `achievement_criteria`
---
-
-CREATE TABLE IF NOT EXISTS `achievement_criteria` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `Text` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10523 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `areatrigger_tavern`
---
-
-CREATE TABLE IF NOT EXISTS `areatrigger_tavern` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `Name` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=210 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `areatrigger_teleport`
---
-
-CREATE TABLE IF NOT EXISTS `areatrigger_teleport` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `Name` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=454 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `banner`
---
-
-CREATE TABLE IF NOT EXISTS `banner` (
+-- Struktura tabulky `Banner`
+--
+
+CREATE TABLE IF NOT EXISTS `Banner` (
   `DateFirst` datetime NOT NULL,
   `DateLast` datetime NOT NULL,
@@ -166 +34 @@
 
 --
--- Struktura tabulky `connexion`
---
-
-CREATE TABLE IF NOT EXISTS `connexion` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` text NOT NULL,
-  `Group` int(11) NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `Group` (`Group`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1502 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `connexion_item`
---
-
-CREATE TABLE IF NOT EXISTS `connexion_item` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `connexion` int(11) NOT NULL,
-  `entry` int(11) NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `connexion` (`connexion`,`entry`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7029 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `creature`
---
-
-CREATE TABLE IF NOT EXISTS `creature` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `name` text NOT NULL,
-  `subname` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=58460 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `dictionary`
---
-
-CREATE TABLE IF NOT EXISTS `dictionary` (
-  `ID` int(11) NOT NULL AUTO_INCREMENT,
-  `Entry` int(11) NOT NULL,
-  `Text` varchar(255) NOT NULL,
-  `Language` int(11) NOT NULL,
-  `Description` text NOT NULL,
-  `User` int(11) NOT NULL,
-  PRIMARY KEY (`ID`),
-  KEY `Language` (`Language`),
-  KEY `Entry` (`Entry`),
-  KEY `User` (`User`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `Export`
---
-
-CREATE TABLE IF NOT EXISTS `Export` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `User` int(11) NOT NULL,
-  `TimeCreate` datetime NOT NULL,
-  `Title` varchar(255) NOT NULL,
-  `WithDiacritic` tinyint(1) NOT NULL,
-  `UsedCount` int(11) NOT NULL,
-  `ClientVersion` int(11) NOT NULL,
-  `OutputType` int(11) NOT NULL,
-  `Description` text NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `User` (`User`),
-  KEY `TimeCreate` (`TimeCreate`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `ExportGroup`
---
-
-CREATE TABLE IF NOT EXISTS `ExportGroup` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Export` int(11) NOT NULL,
-  `Group` int(11) NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `Export` (`Export`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=527 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `ExportLanguage`
---
-
-CREATE TABLE IF NOT EXISTS `ExportLanguage` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Export` int(11) NOT NULL,
-  `Language` int(11) NOT NULL,
-  `Sequence` int(11) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `ExportOutputType`
---
-
-CREATE TABLE IF NOT EXISTS `ExportOutputType` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` varchar(255) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `ExportTask`
---
-
-CREATE TABLE IF NOT EXISTS `ExportTask` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `TimeStart` datetime NOT NULL,
-  `TimeFinish` datetime DEFAULT NULL,
-  `Export` int(11) NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `Export` (`Export`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `ExportUser`
---
-
-CREATE TABLE IF NOT EXISTS `ExportUser` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Export` int(11) NOT NULL,
-  `User` int(11) NOT NULL,
-  `Sequence` int(11) NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `Export` (`Export`),
-  KEY `User` (`User`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3926 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `ExportVersion`
---
-
-CREATE TABLE IF NOT EXISTS `ExportVersion` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `ExportType` int(11) NOT NULL,
-  `ClientVersion` int(11) NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `ExportType` (`ExportType`),
-  KEY `ClientVersion` (`ClientVersion`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `gameobject`
---
-
-CREATE TABLE IF NOT EXISTS `gameobject` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Name` text NOT NULL,
-  `castbarcaption` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=96122 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `gametips`
---
-
-CREATE TABLE IF NOT EXISTS `gametips` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Text` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=416 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `global_strings`
---
-
-CREATE TABLE IF NOT EXISTS `global_strings` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `ShortCut` varchar(255) NOT NULL,
-  `Text` text NOT NULL,
-  `Comment` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `ShortCut` (`ShortCut`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26671 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `glue_strings`
---
-
-CREATE TABLE IF NOT EXISTS `glue_strings` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `ShortCut` varchar(255) NOT NULL,
-  `Text` text NOT NULL,
-  `Comment` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `ShortCut` (`ShortCut`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2068 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `group`
---
-
-CREATE TABLE IF NOT EXISTS `group` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `TablePrefix` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `MangosDatabase` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `MangosTable` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `MangosTableIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `DBCFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `DBCColumns` text COLLATE utf8_czech_ci NOT NULL,
-  `WowheadName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `LuaFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `LuaMPQFolder` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `LastImport` datetime NOT NULL,
-  `LastVersion` int(11) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `group_item`
---
-
-CREATE TABLE IF NOT EXISTS `group_item` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Group` int(11) NOT NULL,
-  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `Column` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `Visible` tinyint(1) NOT NULL DEFAULT '1',
-  `MangosColumn` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `DBCColumnIndex` int(11) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`Id`),
-  KEY `Group` (`Group`),
-  KEY `Visible` (`Visible`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `item`
---
-
-CREATE TABLE IF NOT EXISTS `item` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Name` text NOT NULL,
-  `Description` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=70300 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `language`
---
-
-CREATE TABLE IF NOT EXISTS `language` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `Enabled` tinyint(1) NOT NULL DEFAULT '1',
-  PRIMARY KEY (`Id`),
-  KEY `Enabled` (`Enabled`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `log`
---
-
-CREATE TABLE IF NOT EXISTS `log` (
-  `ID` int(11) NOT NULL AUTO_INCREMENT,
-  `user` int(11) NOT NULL,
-  `type` int(11) NOT NULL,
-  `text` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `date` datetime NOT NULL,
-  `IP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  PRIMARY KEY (`ID`),
-  KEY `user` (`user`),
-  KEY `type` (`type`),
-  KEY `date` (`date`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=532628 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `mangos_command`
---
-
-CREATE TABLE IF NOT EXISTS `mangos_command` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `help` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `Name` varchar(255) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `Name` (`Name`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=853 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `mangos_string`
---
-
-CREATE TABLE IF NOT EXISTS `mangos_string` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `content_default` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2404 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `news`
---
-
-CREATE TABLE IF NOT EXISTS `news` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Time` datetime NOT NULL,
-  `User` int(11) NOT NULL,
-  `Text` text NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `Time` (`Time`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `npc`
---
-
-CREATE TABLE IF NOT EXISTS `npc` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Text0_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text0_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text1_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text1_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text2_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text2_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text3_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text3_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text4_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text4_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text5_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text5_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text6_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text6_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text7_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Text7_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16781037 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `npc_option`
---
-
-CREATE TABLE IF NOT EXISTS `npc_option` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `OptionText` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=129 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `page`
---
-
-CREATE TABLE IF NOT EXISTS `page` (
-  `ID` int(11) NOT NULL AUTO_INCREMENT,
-  `entry` int(11) unsigned NOT NULL DEFAULT '0',
-  `Text` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
-  `Language` int(11) NOT NULL,
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2469 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `quests`
---
-
-CREATE TABLE IF NOT EXISTS `quests` (
-  `ID` int(11) NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL DEFAULT '0',
-  `Title` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `Details` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `Objectives` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `OfferRewardText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `RequestItemsText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `EndText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `ObjectiveText1` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `ObjectiveText2` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `ObjectiveText3` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `ObjectiveText4` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '1',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL DEFAULT '1',
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14408 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `sd2_eventai_texts`
---
-
-CREATE TABLE IF NOT EXISTS `sd2_eventai_texts` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `content_default` text NOT NULL,
-  `comment` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=767 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `sd2_script_texts`
---
-
-CREATE TABLE IF NOT EXISTS `sd2_script_texts` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `content_default` text NOT NULL,
-  `comment` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Complete` (`Complete`),
-  KEY `Language` (`Language`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1969 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `shoutbox`
---
-
-CREATE TABLE IF NOT EXISTS `shoutbox` (
-  `ID` int(11) NOT NULL AUTO_INCREMENT,
-  `user` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `text` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `date` datetime NOT NULL,
-  `IP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  PRIMARY KEY (`ID`),
-  KEY `date` (`date`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1086 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `spell`
---
-
-CREATE TABLE IF NOT EXISTS `spell` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Name` text NOT NULL,
-  `Description` text NOT NULL,
-  `ToolTip` text NOT NULL,
-  `Rank` text NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67580 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `Team`
---
-
-CREATE TABLE IF NOT EXISTS `Team` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
-  `Description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
-  `URL` varchar(255) NOT NULL,
-  `TimeCreate` datetime NOT NULL,
-  `Leader` int(11) NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `Leader` (`Leader`),
-  KEY `TimeCreate` (`TimeCreate`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `transports`
---
-
-CREATE TABLE IF NOT EXISTS `transports` (
-  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `entry` int(11) NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '0',
-  `User` int(11) NOT NULL,
-  `Complete` int(11) NOT NULL,
-  `Take` int(11) NOT NULL,
-  `Name` text NOT NULL,
-  `VersionStart` int(11) NOT NULL DEFAULT '8606',
-  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
-  PRIMARY KEY (`ID`),
-  KEY `entry` (`entry`),
-  KEY `User` (`User`),
-  KEY `Take` (`Take`),
-  KEY `Language` (`Language`),
-  KEY `Complete` (`Complete`),
-  KEY `VersionStart` (`VersionStart`),
-  KEY `VersionEnd` (`VersionEnd`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `user`
---
-
-CREATE TABLE IF NOT EXISTS `user` (
-  `ID` int(11) NOT NULL AUTO_INCREMENT,
-  `user` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `Salt` varchar(255) COLLATE utf8_czech_ci NOT NULL,
-  `gm` int(11) NOT NULL DEFAULT '0',
-  `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
-  `LastLogout` datetime DEFAULT NULL,
-  `Email` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
-  `Language` int(11) NOT NULL DEFAULT '1',
-  `XP` int(11) NOT NULL,
-  `TranslatedCount` int(11) NOT NULL,
-  `NeedUpdate` int(11) NOT NULL,
-  `team` int(11) NOT NULL,
-  `redirecting` int(11) NOT NULL,
-  `RegistrationTime` datetime DEFAULT NULL,
-  PRIMARY KEY (`ID`),
-  KEY `team` (`team`),
-  KEY `user` (`user`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=881 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `verseclient`
---
-
-CREATE TABLE IF NOT EXISTS `verseclient` (
-  `ID` int(11) NOT NULL AUTO_INCREMENT,
-  `verse` text COLLATE utf8_czech_ci NOT NULL,
-  `date` datetime NOT NULL,
-  `text` text COLLATE utf8_czech_ci NOT NULL,
-  `user` int(11) NOT NULL,
-  PRIMARY KEY (`ID`),
-  KEY `user` (`user`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `wow_client_version`
---
-
-CREATE TABLE IF NOT EXISTS `wow_client_version` (
+-- Struktura tabulky `ClientVersion`
+--
+
+CREATE TABLE IF NOT EXISTS `ClientVersion` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,
   `Version` varchar(16) NOT NULL,
@@ -973 +63 @@
   KEY `ReleaseDate` (`ReleaseDate`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=81 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `connexion`
+--
+
+CREATE TABLE IF NOT EXISTS `connexion` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` text NOT NULL,
+  `Group` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Group` (`Group`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1502 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `connexion_item`
+--
+
+CREATE TABLE IF NOT EXISTS `connexion_item` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `connexion` int(11) NOT NULL,
+  `entry` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `connexion` (`connexion`,`entry`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7029 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `CzWoWPackageVersion`
+--
+
+CREATE TABLE IF NOT EXISTS `CzWoWPackageVersion` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `Version` text COLLATE utf8_czech_ci NOT NULL,
+  `Date` datetime NOT NULL,
+  `Text` text COLLATE utf8_czech_ci NOT NULL,
+  `User` int(11) NOT NULL,
+  PRIMARY KEY (`ID`),
+  KEY `user` (`User`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `Dictionary`
+--
+
+CREATE TABLE IF NOT EXISTS `Dictionary` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Text` varchar(255) NOT NULL,
+  `Language` int(11) NOT NULL,
+  `Description` text NOT NULL,
+  `User` int(11) NOT NULL,
+  PRIMARY KEY (`ID`),
+  KEY `Language` (`Language`),
+  KEY `Entry` (`Entry`),
+  KEY `User` (`User`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=413 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `Export`
+--
+
+CREATE TABLE IF NOT EXISTS `Export` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `User` int(11) NOT NULL,
+  `TimeCreate` datetime NOT NULL,
+  `Title` varchar(255) NOT NULL,
+  `WithDiacritic` tinyint(1) NOT NULL,
+  `UsedCount` int(11) NOT NULL,
+  `ClientVersion` int(11) NOT NULL,
+  `OutputType` int(11) NOT NULL,
+  `Description` text NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `User` (`User`),
+  KEY `TimeCreate` (`TimeCreate`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=58 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ExportGroup`
+--
+
+CREATE TABLE IF NOT EXISTS `ExportGroup` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Export` int(11) NOT NULL,
+  `Group` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Export` (`Export`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=580 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ExportLanguage`
+--
+
+CREATE TABLE IF NOT EXISTS `ExportLanguage` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Export` int(11) NOT NULL,
+  `Language` int(11) NOT NULL,
+  `Sequence` int(11) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ExportOutputType`
+--
+
+CREATE TABLE IF NOT EXISTS `ExportOutputType` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ExportTask`
+--
+
+CREATE TABLE IF NOT EXISTS `ExportTask` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `TimeStart` datetime NOT NULL,
+  `TimeFinish` datetime DEFAULT NULL,
+  `Export` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Export` (`Export`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ExportUser`
+--
+
+CREATE TABLE IF NOT EXISTS `ExportUser` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Export` int(11) NOT NULL,
+  `User` int(11) NOT NULL,
+  `Sequence` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Export` (`Export`),
+  KEY `User` (`User`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4280 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ExportVersion`
+--
+
+CREATE TABLE IF NOT EXISTS `ExportVersion` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `ExportType` int(11) NOT NULL,
+  `ClientVersion` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `ExportType` (`ExportType`),
+  KEY `ClientVersion` (`ClientVersion`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `Group`
+--
+
+CREATE TABLE IF NOT EXISTS `Group` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `TablePrefix` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `MangosDatabase` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `MangosTable` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `MangosTableIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `DBCFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `DBCColumns` text COLLATE utf8_czech_ci NOT NULL,
+  `WowheadName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `LuaFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `LuaMPQFolder` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `LastImport` datetime NOT NULL,
+  `LastVersion` int(11) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `GroupItem`
+--
+
+CREATE TABLE IF NOT EXISTS `GroupItem` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Group` int(11) NOT NULL,
+  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Column` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Visible` tinyint(1) NOT NULL DEFAULT '1',
+  `MangosColumn` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `DBCColumnIndex` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`Id`),
+  KEY `Group` (`Group`),
+  KEY `Visible` (`Visible`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `Language`
+--
+
+CREATE TABLE IF NOT EXISTS `Language` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Enabled` tinyint(1) NOT NULL DEFAULT '1',
+  PRIMARY KEY (`Id`),
+  KEY `Enabled` (`Enabled`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `Log`
+--
+
+CREATE TABLE IF NOT EXISTS `Log` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `User` int(11) NOT NULL,
+  `Type` int(11) NOT NULL,
+  `Text` text NOT NULL,
+  `Date` datetime NOT NULL,
+  `IP` text NOT NULL,
+  PRIMARY KEY (`ID`),
+  KEY `user` (`User`),
+  KEY `type` (`Type`),
+  KEY `date` (`Date`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=570788 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `LogType`
+--
+
+CREATE TABLE IF NOT EXISTS `LogType` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  `Color` varchar(255) NOT NULL,
+  `Description` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `News`
+--
+
+CREATE TABLE IF NOT EXISTS `News` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Time` datetime NOT NULL,
+  `User` int(11) NOT NULL,
+  `Text` text NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Time` (`Time`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ShoutBox`
+--
+
+CREATE TABLE IF NOT EXISTS `ShoutBox` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `User` text NOT NULL,
+  `Text` text NOT NULL,
+  `Date` datetime NOT NULL,
+  `IP` text NOT NULL,
+  PRIMARY KEY (`ID`),
+  KEY `date` (`Date`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1087 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `Team`
+--
+
+CREATE TABLE IF NOT EXISTS `Team` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
+  `Description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
+  `URL` varchar(255) NOT NULL,
+  `TimeCreate` datetime NOT NULL,
+  `Leader` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Leader` (`Leader`),
+  KEY `TimeCreate` (`TimeCreate`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextAchievement`
+--
+
+CREATE TABLE IF NOT EXISTS `TextAchievement` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `Name` text NOT NULL,
+  `Description` text NOT NULL,
+  `Reward` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2767 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextAchievementCategory`
+--
+
+CREATE TABLE IF NOT EXISTS `TextAchievementCategory` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `Name` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=205 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextAchievementCriteria`
+--
+
+CREATE TABLE IF NOT EXISTS `TextAchievementCriteria` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `Text` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10589 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextAreaTriggerTavern`
+--
+
+CREATE TABLE IF NOT EXISTS `TextAreaTriggerTavern` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `Name` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=210 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextAreaTriggerTeleport`
+--
+
+CREATE TABLE IF NOT EXISTS `TextAreaTriggerTeleport` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `Name` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=454 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextCreature`
+--
+
+CREATE TABLE IF NOT EXISTS `TextCreature` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `name` text NOT NULL,
+  `subname` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=58460 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextGameObject`
+--
+
+CREATE TABLE IF NOT EXISTS `TextGameObject` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Name` text NOT NULL,
+  `castbarcaption` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=99412 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextGameTip`
+--
+
+CREATE TABLE IF NOT EXISTS `TextGameTip` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Text` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=416 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextGlobalString`
+--
+
+CREATE TABLE IF NOT EXISTS `TextGlobalString` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `ShortCut` varchar(255) NOT NULL,
+  `Text` text NOT NULL,
+  `Comment` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `ShortCut` (`ShortCut`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26762 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextGlueString`
+--
+
+CREATE TABLE IF NOT EXISTS `TextGlueString` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `ShortCut` varchar(255) NOT NULL,
+  `Text` text NOT NULL,
+  `Comment` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `ShortCut` (`ShortCut`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2098 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextItem`
+--
+
+CREATE TABLE IF NOT EXISTS `TextItem` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Name` text NOT NULL,
+  `Description` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=70332 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextMangosCommand`
+--
+
+CREATE TABLE IF NOT EXISTS `TextMangosCommand` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `help` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `Name` varchar(255) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `Name` (`Name`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=853 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextMangosString`
+--
+
+CREATE TABLE IF NOT EXISTS `TextMangosString` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `content_default` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2404 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextNPC`
+--
+
+CREATE TABLE IF NOT EXISTS `TextNPC` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Text0_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text0_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text1_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text1_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text2_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text2_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text3_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text3_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text4_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text4_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text5_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text5_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text6_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text6_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text7_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Text7_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16781038 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextNPCOption`
+--
+
+CREATE TABLE IF NOT EXISTS `TextNPCOption` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `OptionText` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=129 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextPage`
+--
+
+CREATE TABLE IF NOT EXISTS `TextPage` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Text` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
+  `Language` int(11) NOT NULL,
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2469 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextQuest`
+--
+
+CREATE TABLE IF NOT EXISTS `TextQuest` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Title` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `Details` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `Objectives` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `OfferRewardText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `RequestItemsText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `EndText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `ObjectiveText1` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `ObjectiveText2` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `ObjectiveText3` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `ObjectiveText4` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '1',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL DEFAULT '1',
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14411 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextSD2EventAI`
+--
+
+CREATE TABLE IF NOT EXISTS `TextSD2EventAI` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `content_default` text NOT NULL,
+  `comment` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=767 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextSD2Script`
+--
+
+CREATE TABLE IF NOT EXISTS `TextSD2Script` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `content_default` text NOT NULL,
+  `comment` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1969 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextSpell`
+--
+
+CREATE TABLE IF NOT EXISTS `TextSpell` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Name` text NOT NULL,
+  `Description` text NOT NULL,
+  `ToolTip` text NOT NULL,
+  `Rank` text NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67832 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TextTransport`
+--
+
+CREATE TABLE IF NOT EXISTS `TextTransport` (
+  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `Name` text NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
+  PRIMARY KEY (`ID`),
+  KEY `entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `User`
+--
+
+CREATE TABLE IF NOT EXISTS `User` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `Pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `Salt` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `GM` int(11) NOT NULL DEFAULT '0',
+  `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `LastLogout` datetime DEFAULT NULL,
+  `Email` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT '1',
+  `XP` int(11) NOT NULL,
+  `TranslatedCount` int(11) NOT NULL,
+  `NeedUpdate` int(11) NOT NULL,
+  `Team` int(11) NOT NULL,
+  `Redirecting` int(11) NOT NULL,
+  `RegistrationTime` datetime DEFAULT NULL,
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `user` (`Name`),
+  KEY `team` (`Team`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=891 ;

trunk/sql/text_table_init_structure.sql

@@ -1 @@
-CREATE TABLE IF NOT EXISTS `text` (
+CREATE TABLE IF NOT EXISTS `Text` (
   `ID` int(11) unsigned NOT NULL auto_increment,
-  `entry` int(11) NOT NULL,
+  `Entry` int(11) NOT NULL,
   `Language` int(11) NOT NULL default '0',
   `User` int(11) NOT NULL,
   `Complete` int(11) NOT NULL,
   `Take` int(11) NOT NULL,
+  `VersionStart` int(11) NOT NULL DEFAULT '8606',
+  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
   PRIMARY KEY  (`ID`),
-  KEY `entry` (`entry`),
+  KEY `Entry` (`Entry`),
   KEY `User` (`User`),
   KEY `Take` (`Take`),
   KEY `Language` ( `Language` ),
   KEY `Complete` ( `Complete` )
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

trunk/team.php

@@ -8 +8 @@
 function ShowTeamList()
 {  
-  global $Config, $Database;
+  global $Config, $Database, $User;
   
   echo('<h3>Seznam překladatelských týmů</h3>');
@@ -26 +26 @@
     array('Name' => 'TimeCreate', 'Title' => 'Datum založení'), 
   );
-  if(Licence(LICENCE_USER)) $TableColumns[] = array('Name' => '', 'Title' => 'Uživatelské akce');
+  if($User->Licence(LICENCE_USER)) $TableColumns[] = array('Name' => '', 'Title' => 'Uživatelské akce');
 
   $Order = GetOrderTableHeader($TableColumns, 'NumberUser', 1);
   echo($Order['Output']);
 
-  if(array_key_exists('search', $_GET))  $_SESSION['search'] = ' WHERE `Name` LIKE "%'.$_GET['search'].'%" OR `Description` LIKE "%'.$_GET['search'].'%"'; 
+  if(array_key_exists('search', $_GET)) $_SESSION['search'] = ' WHERE `Name` LIKE "%'.$_GET['search'].'%" OR `Description` LIKE "%'.$_GET['search'].'%"'; 
     else if(!array_key_exists('search', $_SESSION)) $_SESSION['search'] = '';
     if (array_key_exists('search', $_GET) and ($_GET['search'] == '')) $_SESSION['search'] = '';
-    /*
-    if(array_key_exists('team', $_GET))
-    {
-      $_SESSION['team'] = $_GET['team']; 
-      if($_GET['team'] == '') $_SESSION['team'] = '';     
-    } else if(!array_key_exists('team', $_SESSION)) $_SESSION['team'] = '';
-    
-    if(is_numeric($_SESSION['team'])) $Where = ' WHERE '.$_SESSION['team'];
-      else $Where = '';
-
-    if(!is_numeric($_SESSION['team'])) echo(' <a href="?Where">Zrušit filtr týmů</a><br />');
-    */
-    $DbResult = $Database->SQLCommand('SELECT `Team` FROM `User` WHERE `ID`='.$_SESSION['UserID']);
-    $User = mysql_fetch_assoc($DbResult);   
 
     $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM `User` WHERE `User`.`Team` = `Team`.`Id`) AS `NumberUser`, (SELECT `Name` FROM `User` WHERE `User`.`ID`=`Team`.`Leader`) AS `LeaderName` FROM `Team` '.$_SESSION['search'].$Order['SQL'].$PageList['SQLLimit']);
@@ -58 +44 @@
         '<td><a href="userlist.php?team='.$Team['Id'].'" title="Zobrazit členy týmu">'.$Team['NumberUser'].'</a></td>'.
         '<td>'.HumanDate($Team['TimeCreate']).'</td>');
-      if(Licence(LICENCE_USER))
-      {
-        if($Team['Leader'] == $_SESSION['UserID']) $Action = ' <a href="?action=modify&amp;id='.$Team['Id'].'">Upravit</a>'; 
+      if($User->Licence(LICENCE_USER))
+      {
+        if($Team['Leader'] == $User->Id) $Action = ' <a href="?action=modify&amp;id='.$Team['Id'].'">Upravit</a>'; 
           else $Action = '';
-        if($Team['Id'] == $User['Team']) $Action = ' <a href="?action=leave">Opustit</a>'; 
+        if($Team['Id'] == $User->Team) $Action = ' <a href="?action=leave">Opustit</a>'; 
         echo('<td><a href="?action=gointeam&amp;id='.$Team['Id'].'">Vstoupit</a>'.$Action.'</td>');
       }
@@ -70 +56 @@
     echo($PageList['Output']);
     
-    if(Licence(LICENCE_USER)) echo('<br /><div style="text-align: center;"><a href="?action=create">Vytvořit překladatelský tým</a></div>');
+    if($User->Licence(LICENCE_USER)) echo('<br /><div style="text-align: center;"><a href="?action=create">Vytvořit překladatelský tým</a></div>');
 }          
 
 function TeamJoin()
 {
-  global $Database;
-  
-  if(Licence(LICENCE_USER))
+  global $Database, $User;
+  
+  if($User->Licence(LICENCE_USER))
   {   
     if(array_key_exists('id', $_GET))
     { 
-      $Database->SQLCommand('UPDATE `User` SET `Team` = '.$_GET['id'].' WHERE `ID` = '.$_SESSION['UserID']); 
+      $Database->SQLCommand('UPDATE `User` SET `Team` = '.$_GET['id'].' WHERE `ID` = '.$User->Id); 
       echo('<strong>Vstoupil jsi do týmu</strong><br /><br />');    
       WriteLog('Uživatel vstoupil do týmu '.$_GET['id'], LOG_TYPE_USER);
@@ -98 +84 @@
 function TeamCreateFinish()
 {
-  global $Database;
-  
-  if(Licence(LICENCE_USER))
+  global $Database, $User;
+  
+  if($User->Licence(LICENCE_USER))
   {   
     if(array_key_exists('Name', $_POST) and array_key_exists('Description', $_POST))
@@ -109 +95 @@
       if(($Count == 0) and ($_POST['Name'] != ''))
       {
-        $Database->SQLCommand('INSERT INTO `Team` (`Name` ,`Description`, `URL`, `TimeCreate`,`Leader`) VALUES ("'.trim($_POST['Name']).'", "'.trim($_POST['Description']).'", "'.$_POST['URL'].'", NOW(), '.$_SESSION['UserID'].')');  
-        $Database->SQLCommand('UPDATE `User` SET `Team` = '.mysql_insert_id().' WHERE `ID` = '.$_SESSION['UserID']); 
+        $Database->SQLCommand('INSERT INTO `Team` (`Name` ,`Description`, `URL`, `TimeCreate`,`Leader`) VALUES ("'.trim($_POST['Name']).'", "'.trim($_POST['Description']).'", "'.$_POST['URL'].'", NOW(), '.$User->Id.')');  
+        $Database->SQLCommand('UPDATE `User` SET `Team` = '.mysql_insert_id().' WHERE `ID` = '.$User->Id); 
         echo('<strong>Překladatelský tým vytvořen</strong><br /><br />');
         WriteLog('Překladatelský tým vytvořen '.$_POST['Name'], LOG_TYPE_USER);
@@ -124 +110 @@
 function TeamModify()
 {
-  global $Database;
-  
-  if(Licence(LICENCE_USER))
+  global $Database, $User;
+  
+  if($User->Licence(LICENCE_USER))
   {   
     if(array_key_exists('id', $_GET))
     {
-      $DbResult = $Database->SQLCommand('SELECT * FROM `Team` WHERE `Id`='.$_GET['id'].' AND `Leader`='.$_SESSION['UserID']);
+      $DbResult = $Database->SQLCommand('SELECT * FROM `Team` WHERE `Id`='.$_GET['id'].' AND `Leader`='.$User->Id);
       if(mysql_num_rows($DbResult) > 0)
       {
@@ -148 +134 @@
 function TeamModifyFinish()
 {
-  global $Database;
-  
-  if(Licence(LICENCE_USER))
+  global $Database, $User;
+  
+  if($User->Licence(LICENCE_USER))
   {   
     if(array_key_exists('id', $_GET) and array_key_exists('Name', $_POST) and array_key_exists('Description', $_POST) and array_key_exists('URL', $_POST))
     {
-      $DbResult = $Database->SQLCommand('SELECT * FROM `Team` WHERE `Id`='.$_GET['id'].' AND `Leader`='.$_SESSION['UserID']);
+      $DbResult = $Database->SQLCommand('SELECT * FROM `Team` WHERE `Id`='.$_GET['id'].' AND `Leader`='.$User->Id);
       if(mysql_num_rows($DbResult) > 0)
       {
@@ -175 +161 @@
 function TeamCreate()
 {
-  if(Licence(LICENCE_USER))
+  global $User;
+  
+  if($User->Licence(LICENCE_USER))
   {   
     echo('<form action="?action=finish_create" method="post">'.
@@ -189 +177 @@
 function TeamShow()
 {
-  global $Database, $TranslationTree;
+  global $Database, $TranslationTree, $User;
   
   if(array_key_exists('id', $_GET))
@@ -208 +196 @@
     $Team['Description'].'<br /><br />');
     //echo('<a href="export/?team='.$Team['Id'].'">Exportovat překlad týmu</a> ');
-    if(Licence(LICENCE_USER)) echo('<a href="?action=gointeam&amp;id='.$Team['Id'].'">Vstoupit do týmu</a><br /><br />');
+    if($User->Licence(LICENCE_USER)) echo('<a href="?action=gointeam&amp;id='.$Team['Id'].'">Vstoupit do týmu</a><br /><br />');
     echo('<fieldset><legend>Statistika</legend>'.
       'Počet členů týmu: <a href="userlist.php?team='.$Team['Id'].'" title="Zobrazit členy týmu">'.$Team['NumberUser'].'</a><br />'.
@@ -223 +211 @@
 function TeamLeave()
 {
-  global $Database;
-  
-  if(Licence(LICENCE_USER))
-  {   
-    $Database->SQLCommand('UPDATE `User` SET `Team` = 0 WHERE `ID` = '.$_SESSION['UserID']); 
+  global $Database, $User;
+  
+  if($User->Licence(LICENCE_USER))
+  {   
+    $Database->SQLCommand('UPDATE `User` SET `Team` = 0 WHERE `ID` = '.$User->Id); 
     echo('<strong>Nyní nejste členem žádného týmu</strong><br /><br />');    
     WriteLog('Uživatel vystoupil z týmu', LOG_TYPE_USER);

trunk/user.php

@@ -5 +5 @@
 ShowPage();
 
-if(array_key_exists('text', $_POST) and Licence(LICENCE_ADMIN)) 
+if(array_key_exists('text', $_POST) and $User->Licence(LICENCE_ADMIN)) 
 {
-  $text = $_POST['text'];
-  $email = $_POST['email'];
-  $subject = $_POST['subject'];
-  echo('Email: <strong>'.$email.'</strong><br />');
-  echo('Předmět: <strong>'.$subject.'</strong><br />');
-  echo('Text: <strong>'.$text.'</strong><br />');
+  $Text = $_POST['text'];
+  $Email = $_POST['email'];
+  $Subject = $_POST['subject'];
+  echo('Email: <strong>'.$Email.'</strong><br />');
+  echo('Předmět: <strong>'.$Subject.'</strong><br />');
+  echo('Text: <strong>'.$Text.'</strong><br />');
     
-  if(@mail($email, $subject, $text, 'From: '.$Config['Web']['AdminEmail'].'\nReply-To: '.$Config['Web']['AdminEmail'].'\nX-Mailer: PHP/'))
+  if(@mail($Email, $Subject, $Text, 'From: '.$Config['Web']['AdminEmail'].'\nReply-To: '.$Config['Web']['AdminEmail'].'\nX-Mailer: PHP/'))
   {
     echo('Zpráva byla odeslána.<br /><br />');
   }
-  else
-  {
-    echo('Nepodařilo se odesat E-mail.<br /><br />'); 
-  }
+  else echo('Nepodařilo se odesat E-mail.<br /><br />'); 
 }
   
-if(array_key_exists('user', $_GET) and Licence(LICENCE_MODERATOR)) 
+if(array_key_exists('user', $_GET) and $User->Licence(LICENCE_MODERATOR)) 
 {  
   $Query = 'SELECT * FROM `User` WHERE `ID` = '.$_GET['user'];
-  $User = mysql_fetch_array($Database->SQLCommand($Query));
+  $UserLine = mysql_fetch_array($Database->SQLCommand($Query));
    
-  echo('ID: <strong>'.$User['ID'].'</strong><br />');
-  echo('Jméno: <strong>'.$User['Name'].'</strong><br />');
-  echo('Výchozí jazyk: <strong>'.$LanguageList[$User['Language']]['Name'].'</strong><br />');
-  echo('Poslední připojení: <strong>'.$User['LastLogin'].'</strong><br />');
-  echo('Poslední IP: <strong>'.$User['LastIP'].'</strong><br />');
-  echo('Počet přeložených: <a href="TranslationList.php?user='.$User['ID'].'&amp;action=userall" title="Zobrazit Všechny jeho přeložené texty"><strong>'.$User['TranslatedCount'].'</strong></a><br />');
-  echo('Email: <strong>'.$User['Email'].'</strong><br />');
+  echo('ID: <strong>'.$UserLine['ID'].'</strong><br />');
+  echo('Jméno: <strong>'.$UserLine['Name'].'</strong><br />');
+  echo('Výchozí jazyk: <strong>'.$LanguageList[$UserLine['Language']]['Name'].'</strong><br />');
+  echo('Poslední připojení: <strong>'.$UserLine['LastLogin'].'</strong><br />');
+  echo('Poslední IP: <strong>'.$UserLine['LastIP'].'</strong><br />');
+  echo('Počet přeložených: <a href="TranslationList.php?user='.$UserLine['ID'].'&amp;action=userall" title="Zobrazit Všechny jeho přeložené texty"><strong>'.$UserLine['TranslatedCount'].'</strong></a><br />');
+  echo('Email: <strong>'.$UserLine['Email'].'</strong><br />');
   echo('<br />
 
 <form action="user.php" method="post"><div>
 Napsat E-mail: 
-<input type="text" name="email" value="'.$User['Email'].'" />
+<input type="text" name="email" value="'.$UserLine['Email'].'" />
 Předmět: 
 <input type="text" name="subject" value="Projekt překládání textů WoW" />
@@ -47 +44 @@
 <textarea name="text" rows="20" cols="62">
 
-S pozdravem '.$_SESSION['User'].'
+S pozdravem '.$User->Name.'
 --------------------------------------------------------
 Projekt překládání textů WoW '.$Config['Web']['BaseURL'].'

trunk/userlist.php

@@ -49 +49 @@
 while($Line = mysql_fetch_assoc($ID)) 
 {
-  if(Licence(LICENCE_MODERATOR)) 
+  if($User->Licence(LICENCE_MODERATOR)) 
     $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['Name'].'</a>';
     else $Name = $Line['Name'];