Changeset 49

Timestamp:

Jan 30, 2009, 10:33:08 PM (16 years ago)

Author:

george

Message:

• Upraveno: Přepracován systém pro více skupin překladů. Původně přes samostatné php soubory, nyní dynamicky dle tabulek group a group_item.
• Přidáno: Doplněna podpora skupin překladů item, creature, gameobject, mangos_string, mangos_command.
• Opraveno: Export dat nyní bez výběru konkrétních sloupců s plným výběrem exportu překladových skupin. Přepracované extporotvané příkazy a forma dat.
• Upraveno: Styl stránek částečně oddělen do souboru style.css. Podobně javascripty přesouvat do global.js.

Location:

trunk

Files:

• . (modified) (1 prop)
• ListQuests.php (deleted)
• Options.php (modified) (2 diffs)
• SqlTranslate.zip (deleted)
• TranslationList.php (modified) (8 diffs)
• action.php (modified) (1 diff)
• client_action.php (deleted)
• client_form.php (deleted)
• client_list.php (deleted)
• client_save.php (deleted)
• dictionary.php (modified) (4 diffs)
• download.php (modified) (3 diffs)
• export.php (added)
• fill_database.php (modified) (1 diff)
• form.php (modified) (2 diffs)
• img_statistic.php (modified) (2 diffs)
• includes/config.sample.php (modified) (2 diffs)
• includes/databaseconection.php (modified) (1 diff)
• includes/global.php (modified) (5 diffs)
• includes/global_function.php (modified) (3 diffs)
• index.php (modified) (2 diffs)
• log.php (modified) (1 diff)
• npc_action.php (deleted)
• npc_form.php (deleted)
• npc_list.php (deleted)
• npc_save.php (deleted)
• page_action.php (deleted)
• page_form.php (deleted)
• page_list.php (deleted)
• page_save.php (deleted)
• priorite.php (deleted)
• registrace.php (modified) (3 diffs)
• save.php (modified) (1 diff)
• sql/text_table_init_structure.sql (added)
• sql/updates/48.sql (added)
• statistic.php (modified) (1 diff)
• user.php (modified) (2 diffs)

trunk/Options.php

@@ -2 +2 @@
 include('includes/global.php');
 
-if (Licence(0)) {
+if(Licence(LICENCE_USER)) 
+{
+  $User = @$_SESSION['User'];
 
-    $User = @$_SESSION['User'];
-
-  if (array_key_exists('Email', $_POST)) {
+  if(array_key_exists('Email', $_POST)) 
+  {
     $Email = $_POST['Email'];
     $OldPass = $_POST['OldPass'];
@@ -14 +15 @@
 
     $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE ID = ".$_SESSION['UserID']));
-    if (($Line['pass'] == $OldPass) and ($NewPass == $NewPass2)) {
+    if(($Line['pass'] == $OldPass) and ($NewPass == $NewPass2)) 
+        {
       $Database->SQLCommand("UPDATE user SET pass = '$NewPass' WHERE ID = ".$_SESSION['UserID']);
-      echo 'Heslo změněno!<br />';
-    } else echo '<br />Hesla se neshodují!<br />';
+      echo('Heslo změněno!<br />');
+    } else echo('<br />Hesla se neshodují!<br />)');
     $Database->SQLCommand("UPDATE user SET Email = '$Email', Language = '$Language' WHERE ID = ".$_SESSION['UserID']);
-      echo 'Úprava nastavení proběhla v pořádku, Email: <b>'.$Email.'</b> Uživatel: <b>'.$User.'</b><br />';
+      echo('Úprava nastavení proběhla v pořádku, Email: <b>'.$Email.'</b> Uživatel: <b>'.$User.'</b><br />');
       WriteLog('Úprava nastavení!', 3);
-  } else {
+  } else 
+  {
     $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE ID = ".$_SESSION['UserID']));    
-?>
-  <form action="Options.php" method="post">
+    echo('<form action="Options.php" method="post">
   <table>
     <tr>
       <td>Email: </td>
-      <td><input type="text" name="Email" value="<?php echo $Line['Email']; ?>"></td>
+      <td><input type="text" name="Email" value="'.$Line['Email'].'" /></td>
     </tr>
     <tr>
       <td>Původní heslo: </td>
-      <td><input type="password" name="OldPass"></td>
+      <td><input type="password" name="OldPass" /></td>
     </tr>
     <tr>
       <td>Nové heslo: </td>
-      <td><input type="password" name="NewPass"></td>
+      <td><input type="password" name="NewPass" /></td>
     </tr>
     <tr>
       <td>Nové heslo pro potvrzení: </td>
-      <td><input type="password" name="NewPass2"></td>
+      <td><input type="password" name="NewPass2" /></td>
     </tr>
     <tr>
       <td>Normálně budu překládat do: </td>
-      <td><?php WriteLanguages($Line['Language']); ?></td>
+      <td>');
+          WriteLanguages($Line['Language']);
+          echo('</td>
     </tr>
     <tr>
-      <th><input type="submit" value="Uložit"></th>
+      <th><input type="submit" value="Uložit" /></th>
     </tr>
   </table>
-</form>
-    
-    
-<?php
+</form>');
   }
 } else echo 'Nejste přihlášený!'; 

trunk/TranslationList.php

@@ -4 +4 @@
 
 $TranslationItemPerPage = 200;
-
 
 if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
@@ -66 +65 @@
 function WriteQuests($sql, $limit, $address)
 {
-  global $Database, $order, $desc;
-    
+  global $Database, $order, $desc, $TranslationTree, $GroupId, $Table;
+ 
   if($limit <> '') $limit = 'LIMIT '.$limit;
 
@@ -81 +80 @@
         
   echo('<table border="1" cellpadding="2" cellspacing="0"><tr>
-    <th><a href="group='.$GroupId.'&amp;?'.$address.'&amp;order=ID&amp;desc='.$desc.'">Pořadové číslo</a></th>
-    <th><a href="group='.$GroupId.'&amp;?'.$address.'&amp;order=entry&amp;desc='.$desc.'">Identifikační číslo</a></th>
-    <th><a href="?group='.$GroupId.'&amp;'.$address.'&amp;order=Title&amp;desc='.$desc.'">Název</a></th>');
-  if ($address == 'selection') echo('<th><a href="?group='.$GroupId.'&amp;'.$address.'&amp;order=CountQuests&amp;desc='.$desc.'">Výskyt</a></th>'); 
-  else if($address <> 'notran') echo('<th><a href="?group='.$GroupId.'&amp;'.$address.'&amp;order=user&amp;desc='.$desc.'">Uživatel</a></th>
-    <th><a href="?group='.$GroupId.'&amp;'.$address.'&amp;order=vote&amp;desc='.$desc.'">Známka</a></th>
-    <th><a href="?group='.$GroupId.'&amp;'.$address.'&amp;order=CountVote&amp;desc='.$desc.'">Počet hlasování</a></th>');
+    <th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=ID&amp;desc='.$desc.'">Pořadové číslo</a></th>
+    <th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=entry&amp;desc='.$desc.'">Identifikační číslo</a></th>
+    <th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=Title&amp;desc='.$desc.'">Název</a></th>');
+  if ($address == 'selection') echo('<th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=CountQuests&amp;desc='.$desc.'">Výskyt</a></th>'); 
+  else if($address <> 'notran') echo('<th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=user&amp;desc='.$desc.'">Uživatel</a></th>
+    <th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=vote&amp;desc='.$desc.'">Známka</a></th>
+    <th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=CountVote&amp;desc='.$desc.'">Počet hlasování</a></th>');
   echo('</tr>');
-              
-  $ID = $Database->SQLCommand("$sql $order $desc $limit");
-  while($Line = mysql_fetch_array($ID)) 
-  {
-    echo('<tr><td><a href="form.php?ID='.$Line['ID'].'">'.$Line['ID'].'</a></td>
+   
+  //print_r($TranslationTree[$GroupId]['Items']);
+  $ID = $Database->SQLCommand($sql.' '.$order.' '.$desc.' '.$limit);
+  while($Line = mysql_fetch_assoc($ID)) 
+  {
+    //print_r($Line);
+        echo('<tr><td><a href="form.php?group='.$GroupId.'&amp;ID='.$Line['ID'].'">'.$Line['ID'].'</a></td>
       <td>'.$Line['entry'].'</td>
-      <td>'.htmlspecialchars($Line['Title']).'</td>');
+      <td>'.htmlspecialchars($Line[$TranslationTree[$GroupId]['Items'][0]['Column']]).'</td>');
     if($address == 'selection') echo('<td>'.$Line['CountQuest'].'</td>'); 
-        else if($address <> 'notran') echo('<td>'.@$Line['User'].'</td>
+        else if($address <> 'notran') echo('<td>'.$Line['User'].'</td>
       <td>'.substr($Line['Vote'], 0, 4).'</td>
       <td>'.$Line['CountVote'].'</td>');
@@ -105 +106 @@
 }
 
-if($Action == 'selection') 
-{               
-  echo('<a title="Zobrazit překlady podle vlasního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr překladů</a> ->
-     <a title="Zde můžete začít překládat" href="?group='.$GroupId.'&amp;action=selection">Nepřeložené texty</a><br /><br />');
-                
-  echo('<table border="1" cellspacing="0" cellpadding="10"><tr><td>
-    <br /><b>Prioritně byste měli překládat tyto texty:</b><br /><br />');
-                
-  WriteQuests('SELECT '.$Table.'.ID, entry, Title, CountQuest FROM '.$Table.', '.$Table.'_status 
-    WHERE '.$Table.'.language = 0 AND '.$Table.'.entry = '.$Table.'_status.questentry ORDER BY '.$Table.'_status.CountQuest DESC', 18, 'selection');
-          
-  echo('</td></tr><tr><td>
-    <a href="?group='.$GroupId.'&amp;action=notran">Ostatní nepřeložené texty</a>');
-          
-  echo('</td></tr></table>');
-}
-
-
 if($Action == 'notran') 
 {
@@ -176 +159 @@
     <a title="Zatím nezkontrolované questy" href="?group='.$GroupId.'&amp;action=admin_nocheck">Nezkontrolované texty</a><br /><br />');
 
-  WritePages('ListQuests.php?nocheck', ' WHERE Language <> 0 AND '.$Table.'.Complete = 1 AND admin_check <> 1');
+  WritePages('?group='.$GroupId.'&amp;action=nocheck', ' WHERE Language <> 0 AND '.$Table.'.Complete = 1 AND admin_check <> 1');
 
   WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User
@@ -254 +237 @@
   $Search = $_GET['search'];
   
-  $sql = "SELECT * FROM $Table.'` WHERE `ID` LIKE '%$Search%'
-    OR `entry` LIKE '%$Search%'
-    OR `Title` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `Details` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `Objectives` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `OfferRewardText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `RequestItemsText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `EndText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `ObjectiveText1` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `ObjectiveText2` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `ObjectiveText3` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `ObjectiveText4` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
-    OR `Language` LIKE '%$Search%'
-    OR `Vote` LIKE '%$Search%'
-    OR `User` LIKE '%$Search%'
-    OR `complete` LIKE '%$Search%'";
+  $sql = 'SELECT * FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
+    OR `entry` LIKE "%'.$Search.'%"
+    OR `Language` LIKE "%'.$Search.'%"
+    OR `Vote` LIKE "%'.$Search.'%"
+    OR `User` LIKE "%'.$Search.'%"
+    OR `complete` LIKE "%'.$Search.'%"';
+  foreach($TranslationTree[$GroupId]['Items'] as $Item)
+  {
+        if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"';
+  }
     
   WriteQuests($sql, '', 'search='.$Search);
@@ -276 +253 @@
 if($Action == 'searchentry') 
 {
-  $Search = $_GET['searchentry'];
+  $Search = $_GET['ID'];
  
-  $sql = 'SELECT * FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"';
+  $sql = 'SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"';
     
   WriteQuests($sql, '', 'searchentry='.$Search);
@@ -308 +285 @@
     &nbsp;<select name="users[]" size="10" multiple>');
         
-  $ID = $Database->SQLCommand('SELECT user,ID FROM `user` WHERE
+  $ID = $Database->SQLCommand('SELECT user, ID FROM `user` WHERE
     EXISTS(SELECT 1 FROM '.$Table.' WHERE user = user.ID) ORDER BY user');
-  while($Line = mysql_fetch_array($ID))
+  if($ID)
+  while($Line = mysql_fetch_assoc($ID))
     echo('<option value="'.$Line['ID'].'">'.$Line['user'].'</option>');
   

trunk/action.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');
+include('includes/global.php');
 
-  if (array_key_exists('delete', $_GET) and Licence(1)) 
+if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
+$Table = $TranslationTree[$GroupId]['TablePrefix'];
+if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';
+
+if(($Action == 'delete') and Licence(LICENCE_MODERATOR)) 
+{
+  $TextID = $_GET['ID'];       
+  $Database->SQLCommand('DELETE FROM '.$Table.' WHERE ID = '.$TextID.' AND Language <> 0');
+  echo('Překlad byl smazán!');   
+  WriteLog('Překlad byl smazán! <a href="form.php?group='.$GroupID.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 4);
+}
+
+if((@$_POST['Action'] == 'type_translation') and Licence(LICENCE_MODERATOR)) 
+{
+  if(array_key_exists('1', $_POST)) $check = 1; else $check = 0;
+  $ID_translation = $_POST['ID_translation'];       
+  $type_translation = $_POST['type_translation'];       
+  $Database->SQLCommand("DELETE FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND ID_translation = $ID_translation AND type_translation = $type_translation");
+  $Database->SQLCommand("INSERT INTO `tag` ( `type_translation` , `ID_translation` , `ID_user` , `tag` )
+    VALUES ('$type_translation', '$ID_translation', '".$_SESSION['UserID']."', '$check')");
+  echo('Překlad označen!');   
+  WriteLog('Překlad označen: '.$check.' <a href="form.php?group='.$GroupId.'&amp;ID='.$ID_translation.'">'.$ID_translation.'</a>', 5); 
+}
+
+if(($Action == 'admin_check') and Licence(LICENCE_ADMIN)) 
+{
+  $ID = $_GET['ID'];       
+  $admin_check = $_GET['admin_check'];       
+  $entry = mysql_fetch_array($Database->SQLCommand('SELECT entry FROM '.$Table.' Where ID = '.$ID));
+  $Database->SQLCommand('UPDATE '.$Table.' SET admin_check = 0 WHERE entry = '.$entry['entry'].' AND Language <> 0');
+  $Database->SQLCommand('UPDATE '.$Table.' SET admin_check = '.$admin_check.' WHERE ID = '.$ID.' AND Language <> 0');
+  if($admin_check == 1) 
   {
-    $QuestID = $_GET['ID'];       
-    $Database->SQLCommand("DELETE FROM quests WHERE ID = '$QuestID' AND Language <> '0'");
-    echo 'Překlad byl smazán!';   
-      WriteLog('Překlad byl smazán! <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 4);
+    echo('Překlad byl zkontrolován!');   
+    WriteLog('Překlad byl zkontrolován! <a href="form.php?group='.$GroupId.'&amp;ID='.$ID.'">'.$ID.'</a>', 4);
+  } else 
+  {
+        echo('U překladu bylo zrušeno zkontrolování!');   
+    WriteLog('U překladu bylo zrušeno zkontrolování! <a href="form.php?group='.$GroupId.'&amp;ID='.$ID.'">'.$ID.'</a>', 4);
   }
+}
 
-  if (array_key_exists('type_translation', $_POST) and Licence(1)) 
+if(($Action == 'NotComplete') and Licence(LICENCE_MODERATOR)) 
+{
+  $TextID = $_GET['ID'];
+  $Database->SQLCommand('UPDATE '.$Table.' SET Complete = 0 WHERE ID = '.$TextID);
+  echo('Překlad byl vrácen k opravě!');   
+  WriteLog('Překlad byl vrácen k opravě˝ <a href="form.php?group='.$GroupID.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 4);
+}
+
+if($Action == 'shoutbox') 
+{
+  $shoutbox = $_GET['shoutbox'];
+  if($shoutbox == '') 
   {
-    if (array_key_exists('1', $_POST)) 
-      $check = 1;     
-    else $check = 0;
-    $ID_translation = $_POST['ID_translation'];       
-    $type_translation = $_POST['type_translation'];       
-    $Database->SQLCommand("DELETE FROM tag WHERE  ID_user = ".$_SESSION['UserID']." AND ID_translation = $ID_translation AND type_translation = $type_translation");
-    $Database->SQLCommand("INSERT INTO `tag` ( `type_translation` , `ID_translation` , `ID_user` , `tag` )
-      VALUES ('$type_translation', '$ID_translation', '".$_SESSION['UserID']."', '$check')");
-    echo 'Překlad označen!';   
-    if ($type_translation == 1)
-      WriteLog('Překlad označen: '.$check.' <a href="form.php?ID='.$ID_translation.'">'.$ID_translation.'</a>', 5);
-    if ($type_translation == 2)
-      WriteLog('Překlad označen: '.$check.' <a href="npc_form.php?ID='.$ID_translation.'">'.$ID_translation.'</a>', 5);
-    if ($type_translation == 3)
-      WriteLog('Překlad označen: '.$check.' <a href="page_form.php?ID='.$ID_translation.'">'.$ID_translation.'</a>', 5);
-  }
-
-  if (array_key_exists('admin_check', $_GET) and Licence(2)) {
-    $ID = $_GET['ID'];       
-    $admin_check = $_GET['admin_check'];       
-    $entry = mysql_fetch_array($Database->SQLCommand("SELECT entry FROM quests Where ID = $ID"));
-    $Database->SQLCommand("UPDATE quests SET admin_check = '0' WHERE entry = '".$entry['entry']."' AND Language <> '0'");
-    $Database->SQLCommand("UPDATE quests SET admin_check = '$admin_check' WHERE ID = '$ID' AND Language <> '0'");
-    if ($admin_check == 1) {
-      echo 'Překlad byl zkontrolován!';   
-      WriteLog('Překlad byl zkontrolován! <a href="form.php?ID='.$ID.'">'.$ID.'</a>', 4);
-    } else {
-      echo 'U překladu bylo zrušeno zkontrolování!';   
-      WriteLog('U překladu bylo zrušeno zkontrolování! <a href="form.php?ID='.$ID.'">'.$ID.'</a>', 4);
-    }
-  }
-
-  if (array_key_exists('NotComplete', $_GET) and Licence(1)) {
-    $QuestID = $_GET['ID'];
-    $Database->SQLCommand("UPDATE quests SET Complete = '0' WHERE ID = '$QuestID'");
-    echo 'Překlad byl vrácen k opravě!';   
-      WriteLog('Překlad byl vrácen k opravě˝ <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 4);
-  }
-
-  if (array_key_exists('shoutbox', $_GET)) {
-    $shoutbox = $_GET['shoutbox'];
-    if ($shoutbox == '') {
-      echo '<form action="action.php?shoutbox=1" method="post">
-      Uživatel: ';
-      if (Licence(0)) echo '<b>'.$_SESSION['User'].'</b><br />'; else  echo '<input type="text" name="user"><br />';
-            echo 'Text zprávy: <br>
-            <textarea name="text" cols="40"></textarea> <br>
-            <input type="submit" value="Uložit"><br />
-            </form>';
-    } else {
-      if (Licence(0)) $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('
+    echo('<form action="action.php?action=shoutbox&amp;shoutbox=1" method="post">
+      Uživatel: ');
+    if(Licence(LICENCE_USER)) echo('<b>'.$_SESSION['User'].'</b><br />'); 
+        else echo('<input type="text" name="user" /><br />');
+    echo('Text zprávy: <br>
+      <textarea name="text" cols="40"></textarea> <br />
+      <input type="submit" value="Uložit" /><br />
+      </form>');
+  } 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('
         <script type="text/javascript" language="JavaScript" charset="utf-8">
             setTimeout("parent.location.href=\'index.php\'",1000)
         </script>');
 
-    }
   }
+}
 
-  if (array_key_exists('vote', $_GET)) {
-    $questID = $_GET['ID'];
-    $vote = $_GET['vote'];
-    $IDuser = $_SESSION['UserID'];
+if($Action == 'vote') 
+{
+  $TextID = $_GET['ID'];
+  $vote = $_GET['vote'];
+  $IDuser = $_SESSION['UserID'];
     
-    if (($vote > 5) OR ($vote < 1)) die ('špatná známka');
+  if(($vote > 5) OR ($vote < 1)) die('špatná známka');
     
+  $Line = mysql_fetch_row($Database->SQLCommand('SELECT * FROM '.$Table.'_vote WHERE IDuser = '.$IDuser.' AND TextId = '.$TextID));
+  if((!$Line) and (Licence(LICENCE_USER))) 
+  {  
+    $Line = mysql_fetch_array($Database->SQLCommand('SELECT Vote,CountVote FROM '.$Table.' WHERE ID='.$TextID));
+    $CountVote = $Line['CountVote'] + 1;
+    $OldVote = $Line['Vote'] * $Line['CountVote'];
+    $NewVote = ($OldVote + $vote) / $CountVote;
+      
+    $Database->SQLCommand('UPDATE '.$Table.' SET Vote = '.$NewVote.', CountVote = '.$CountVote.' WHERE ID = '.$TextID);
+    
+    $Database->SQLCommand('INSERT INTO `'.$Table.'_vote` ( `TextId` , `IDuser` , `vote` ) VALUES ( '.$TextID.', '.$IDuser.', '.$vote.')');
+    echo('Hlas byl uložen! Hlasoval jste: '.$vote.'<br /> Nyní je známka překladu '.$NewVote);   
+    
+    WriteLog('Uživatel hlasoval: '.$vote.'! Nyní je známka překladu (<a href="form.php?group='.$GroupID.'&amp;ID='.$TextID.'">'.$TextID.'</a>): '.$NewVote, 5);
+  } else echo('Již jste hlasoval nebo nemůžete hlasovat!');
+}
 
-    $Line = mysql_fetch_row($Database->SQLCommand("SELECT * FROM quests_vote WHERE IDuser = '$IDuser' AND IDquest = '$questID'"));
-    if ((!$Line) and (Licence(0))) 
-    {  
-      $Line = mysql_fetch_array($Database->SQLCommand("SELECT Vote,CountVote FROM quests WHERE ID = '$questID'"));
-      $CountVote = $Line['CountVote'] + 1;
-      $OldVote = $Line['Vote'] * $Line['CountVote'];
-      $NewVote = ($OldVote + $vote) / $CountVote;
-      
-      $Database->SQLCommand("UPDATE quests SET Vote = '$NewVote', CountVote = '$CountVote' WHERE ID = '$questID'");
-    
-      $Database->SQLCommand("INSERT INTO `quests_vote` ( `IDquest` , `IDuser` , `vote` ) VALUES ( '$questID', '$IDuser', '$vote');");
-      echo 'Hlas byl uložen! Hlasoval jste: '.$vote.'<br /> Nyní je známka překladu '.$NewVote;   
-    
-      WriteLog('Uživatel hlasoval: '.$vote.'! Nyní je známka překladu (<a href="form.php?ID='.$questID.'">'.$questID.'</a>): '.$NewVote, 5);
-    } else echo 'Již jste hlasoval nebo nemůžete hlasovat!';
-  }
+ShowFooter();      
 
-  ShowFooter();      
 ?>
 

trunk/dictionary.php

@@ -2 +2 @@
 
 session_start();
+
+// SQL injection hack protection
+foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($_POST[$Index]);
+foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($_GET[$Index]);
+
 include('includes/config.php');
 include('includes/databaseconection.php');
@@ -10 +15 @@
 $Database->SelectDatabase($Config['Database']['Database']);    
 
-
-  function Licence($Licence)
-  { // BEGIN function Licence
-    global $Database;
-    if (isset($_SESSION['User']) and $_SESSION['User'] <> '') {
-      $User = $_SESSION['User'];
-      $Pass = $_SESSION['Pass'];
+function Licence($Licence)
+{
+  global $Database;
+ 
+  if (isset($_SESSION['User']) and $_SESSION['User'] <> '') 
+  {
+    $User = $_SESSION['User'];
+    $Pass = $_SESSION['Pass'];
     
     $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE LOWER(user) = LOWER('$User')"));
-    if (!$Line) {
+    if (!$Line) 
+        {
        return false;
     } else {
@@ -41 +48 @@
       //  die('Nemáte zde přístup, přihla‘te se: <a href="'.$Config['Web']['BaseURL'].'">zde</a>');
     }
-        
-  } // END function Licence
+} 
 
-
-
-
-echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+echo('<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <HTML>
 <HEAD>
@@ -56 +59 @@
   <TITLE>Projekt překládání textů do WoW</TITLE>
 </HEAD>  
-  <body>
+  <body>');
   
-  ';
-  
-  if (array_key_exists('insert', $_GET)) {
-    echo '<form action="dictionary.php" method="post">
+if(array_key_exists('insert', $_GET)) 
+{
+  echo('<form action="dictionary.php" method="post">
           <input type="text" name="AJWord"> Anglické slovo<br>
           <input type="text" name="CZWord"> České slovo<br>
           <input type="text" name="description">  Popis<br>
           <input type="submit" value="Uložit">
-          </form>
-          ';    
-    $WinWidth = 230;
-  } else  {
-    $WinWidth = 345;
-    if (array_key_exists('AJWord', $_POST)) {
-      $AJWord = $_POST['AJWord'];
-      $CZWord = $_POST['CZWord'];
-      $description = $_POST['description'];
-      $user = @$_SESSION['UserID'];
-      $Database->SQLCommand("INSERT INTO `dictionary` ( `AJWord` , `CZWord` , `description` , `user` )
-                              VALUES ('$AJWord', '$CZWord', '$description', '$user');");
-      echo 'Záznam byl uložen!';
-      $WinWidth = 325;
-    }    
-  }
+          </form>');    
+  $WinWidth = 230;
+} else  
+{
+  $WinWidth = 345;
+  if (array_key_exists('AJWord', $_POST)) 
+  {
+    $AJWord = $_POST['AJWord'];
+    $CZWord = $_POST['CZWord'];
+    $description = $_POST['description'];
+    $user = @$_SESSION['UserID'];
+    $Database->SQLCommand("INSERT INTO `dictionary` ( `AJWord` , `CZWord` , `description` , `user` ) VALUES ('$AJWord', '$CZWord', '$description', '$user');");
+    echo('Záznam byl uložen!');
+    $WinWidth = 325;
+  }    
+}
 
+echo('<table border="1" width="100%">');
+ 
+if(array_key_exists('search', $_GET)) 
+{
+  $Search = $_GET['search'];
+} else 
+{
+  $Search = '';
+}
+       
+echo('<tr><td><form action="dictionary.php" method="get">
+  <input type="text" value="'.$Search.'" name="search" size="30">
+  <input type="submit" value="Vyhledat">');
+if(Licence(0))
+  echo(' <a href="dictionary.php?insert">Vložit slovo</a>');
+           
+echo('</form></td></tr>'); 
+echo('<tr><td>
+<p style="  overflow: auto;  width: 100%; height: '.$WinWidth.'px;">');
+//todo select    
+if($Search <> '') 
+{
+  $sql = "SELECT * FROM `dictionary` WHERE LOWER(AJWord) LIKE LOWER('%$Search%') OR LOWER(CZWord) LIKE LOWER('%$Search%') OR LOWER(description) LIKE LOWER('%$Search%')";
+} else 
+{
+  $sql = "SELECT * FROM `dictionary`";
+}
+echo('<table border="1" cellpadding="2" cellspacing="0" width="100%">
+  <tr><th>Eng</th>
+  <th>Cze</th>
+  <th>  Popis</th></tr>');
+$ID = $Database->SQLCommand($sql);
+while ($Line = mysql_fetch_array($ID)) 
+{
+  echo('<tr>
+  <td>'.$Line['AJWord'].'</td>
+  <th>'.$Line['CZWord'].'</th>
+  <td>'.$Line['description'].'</td></tr>');
+}
+echo('</table>');  
 
-  echo '<table border="1" width="100%">';
- 
-  if (array_key_exists('search', $_GET)) {
-    $Search = $_GET['search'];
-  } else {
-    $Search = '';
-  }
-  
-          
-    echo '<tr><td><form action="dictionary.php" method="get">
-          <input type="text" value="'.$Search.'" name="search" size="30">
-          <input type="submit" value="Vyhledat">';
-    if (Licence(0))
-     echo ' <a href="dictionary.php?insert">Vložit slovo</a>';
-           
-    echo '</form></td></tr>'; 
-    echo '<tr><td>
-    <p style="  overflow: auto;  width: 100%; height: '.$WinWidth.'px;">';
-    //todo select    
-    if ($Search <> '') {
-      $sql = "SELECT * FROM `dictionary` WHERE LOWER(AJWord) LIKE LOWER('%$Search%') OR LOWER(CZWord) LIKE LOWER('%$Search%') OR LOWER(description) LIKE LOWER('%$Search%')";
-    } else {
-      $sql = "SELECT * FROM `dictionary`";
-    }
-        echo '<table border="1" cellpadding="2" cellspacing="0" width="100%">
-          <tr><th>Eng</th>
-          <th>Cze</th>
-          <th>  Popis</th></tr>';
-        $ID = $Database->SQLCommand($sql);
-          while ($Line = mysql_fetch_array($ID)) {
-            echo '<tr>
-            <td>'.$Line['AJWord'].'</td>
-            <th>'.$Line['CZWord'].'</th>
-            <td>'.$Line['description'].'</td></tr>';
-          }
-        echo '</table>';  
+echo('</td></tr>'); 
 
-    echo '</td></tr>'; 
-   
-  echo '</table>
-  </body>';
+echo('</table></body>');
+
 ?>

trunk/download.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');
+include('includes/global.php');
 
-  if (array_key_exists('Type', $_POST)) {
-    include 'includes/zip.lib.php';
-    include 'export.php';    
-  } else {
-?>
-<div style="    border: 2px dotted black;       padding: 0px 5px 5px 5px;">
-  <big><b><i>Pro klinta:</i></b></big><br>
+if(array_key_exists('Type', $_POST)) 
+{
+  include('includes/zip.lib.php');
+  include('export.php');    
+} else 
+{
+  echo('<div style="border: 1px dotted black;   padding: 0px 5px 5px 5px;">
+  <big><b><i>Pro klinta:</i></b></big><br />
   <b><a href="download-addon.php">CZWoW</a></b> - <a href="download-addon.php">Stáhnout češtinu pro clienta</a><br />
-   - Změny ve verzích můžete sledovat v: <a href="client_files/_czwow/CzWoW/CzWoW.html">ChangeLog</a><br>
+   - Změny ve verzích můžete sledovat v: <a href="client_files/_czwow/CzWoW/CzWoW.html">ChangeLog</a><br />
    - Čeština pro clienta obsahuje:<br />
    - Přeložené texty z projektu wowpřeklad<br />
@@ -23 +24 @@
    - zvukové soubory převzaté z české verze Warcraftu III <a href="http://www.wowresource.eu/index.php?showtopic=4260&amp;hl=hl%C3%A1%C5%A1ky" title="http://www.wowresource.eu/index.php?showtopic=4260&amp;hl=hl%C3%A1%C5%A1ky">České hlášky z Warcraftu III</a>
 </div> 
-<br>
-<div style="    border: 2px dotted black;       padding: 0px 5px 5px 5px;">
+<br />
+<div style="border: 1px dotted black;   padding: 0px 5px 5px 5px;">
   <big><b><i>Pro server:</i></b></big><br>
   <b>Export překladu:</b><br />
@@ -31 +32 @@
       <tr><th>Sql</th><th>Filtr</th><th>Jazyk</th><th>Texty</th></tr>
       <tr><td>
-        <input type="radio" name="Export" value="Zip" checked="true"> Exportovat do zip<br>
-        <input type="radio" name="Export" value="Display"> Export zobrazit<br>
-<?php
-      if (Licence(2)) {
-          echo '<input type="radio" name="Export" value="Mangos"> Import na server (Admin only)<br>';
-      }
-?>
+        <input type="radio" name="Export" value="Zip" checked="true"> Exportovat do zip<br />
+        <input type="radio" name="Export" value="Display"> Export zobrazit<br />');
+  if(Licence(LICENCE_ADMIN)) 
+  {
+    echo('<input type="radio" name="Export" value="Mangos" /> Import na server (pouze admin)<br />');
+  }
+  echo('<br />
+        <input type="radio" name="Type" value="Insert" /> Insert (zatím nefunguje)<br />
+        <input type="radio" name="Type" value="Update" checked="true" /> Update <br />
         <br />
-        <input type="radio" name="Type" value="Insert"> Insert (zatím nefunguje)<br>
-        <input type="radio" name="Type" value="Update" checked="true"> Update <br>
-        <br />
-        <input type="checkbox" name="Use" checked="true"> Přidat Use mangos <br> 
-        <br /> 
-        <input type="checkbox" name="Quests" checked="true"> Questy <br> 
-        <input type="checkbox" name="NPC_texts" checked="true"> NPC_texts <br> 
-        <input type="checkbox" name="page_texts" checked="true"> page_texts <br> 
-      </td><td>
-        &nbsp; <input type="text" name="NumberVote" value="3" size="1"> Počet nutných hlasů <br>                                                               
-        &nbsp; <input type="text" name="Vote" value="4" size="1"> Známka lepší nebo stejná jak  <br>                                                             
+        <input type="checkbox" name="Use" checked="true"> Přidat Use mangos <br /> 
+        <br />');
+  echo('</td><td>
+        &nbsp; <input type="text" name="NumberVote" value="3" size="1" /> Počet nutných hlasů <br />                                                               
+        &nbsp; <input type="text" name="Vote" value="4" size="1" /> Známka lepší nebo stejná jak  <br />                                                             
             <br />
-        &nbsp; <select name="users[]" size="10" multiple>
-         
-<?php
-// multiple="multiple"
-    $ID = $Database->SQLCommand("SELECT user,ID FROM `user` WHERE
-          EXISTS(SELECT 1 FROM quests WHERE user = user.ID) OR 
-          EXISTS(SELECT 1 FROM npc_text WHERE user = user.ID) ORDER BY user");
-      while ($Line = mysql_fetch_array($ID))
-        echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
-   
-?>          
-          
-        </select><br> &nbsp; Exportovat pouze od těchto uživatalů<br>
-        &nbsp; Vybrat více uživatelů můžete pomocí CTRL+click
-        
+        &nbsp; <select name="users[]" size="10" multiple>');
+
+  // multiple="multiple"
+  $Query = 'SELECT user,ID FROM `user` WHERE ';
+  foreach($TranslationTree as $Group)
+    if($Group['TablePrefix'] != '')
+      $Query .= 'EXISTS(SELECT 1 FROM '.$Group['TablePrefix'].' WHERE user = user.ID) OR ';
+  $Query .= ' 0 ORDER BY user';
+  $ID = $Database->SQLCommand($Query);
+  while ($Line = mysql_fetch_array($ID))
+    echo('<option value="'.$Line['ID'].'">'.$Line['user'].'</option>');
+
+  echo('</select><br /> &nbsp; Exportovat pouze od těchto uživatalů<br />
+        &nbsp; Vybrat více uživatelů můžete pomocí CTRL+click        
 
       </td><td>
-        <input type="checkbox" name="Diacritical" checked="true"> Včetně diakritiky <br>  
+        <input type="checkbox" name="Diacritical" checked="true" /> Včetně diakritiky <br>  
         <br />                                                               
-        <input type="checkbox" name="CZ" checked="true"> Český překlad <br>                                                                 
-        <input type="checkbox" name="SK" checked="true"> Slovenský překlad <br>                                                                 
-        <input type="checkbox" name="OtherLanguage"> Jiné jazyky <br>
-      </td><td>
-        <b>Title questu:</b><br>
-        <input type="radio" name="AddTitle" value="Translate" checked="true"> Přeložený název <br>
-        <input type="radio" name="AddTitle" value="EN"> Původní název <br>
-        <input type="radio" name="AddTitle" value="Both"> Přeložený název (Anglický název) <br>
-    <br>                                                                 
-<?php    
-  foreach($Texts as $Index => $TextItem)
-    echo '<input type="checkbox" name="Add'.$TextItem[0].'" checked="true"> '.$TextItem[0].'<br>';
-?>
-      </td></tr>
+        <input type="checkbox" name="CZ" checked="true" /> Český překlad <br />
+        <input type="checkbox" name="SK" checked="true" /> Slovenský překlad <br />                                                                 
+        <input type="checkbox" name="OtherLanguage" /> Jiné jazyky <br />
+      </td><td>');
+  foreach($TranslationTree as $Group)
+    if($Group['TablePrefix'] != '')
+      echo('<input type="checkbox" name="'.$Group['TablePrefix'].'" checked="true" /> '.$Group['Name'].'<br />');
+
+  echo('</td></tr>
     </table>
-    <br><input type="submit" value="Generovat SQL soubor překladu (Stažení)"> 
-  </form>  
+    <br /><input type="submit" value="Generovat SQL soubor překladu (Stažení)" /> 
+  </form><br />  
   <b>Český překlad MaNGOS Minimanageru:</b><br />
-  - Stránky projektu: <a href="http://sourceforge.net/projects/mmfpm/">http://sourceforge.net/projects/mmfpm/</a><br>
-  - Překlad: <a href="http://wow.zdechov.net/minimanager/lang/csCZ.zip">Čeština do minimanageru</a><br>
+  - Stránky projektu: <a href="http://sourceforge.net/projects/mmfpm/">http://sourceforge.net/projects/mmfpm/</a><br />
+  - Překlad: <a href="http://wow.zdechov.net/minimanager/lang/csCZ.zip">Čeština do minimanageru</a><br />
   - Diskusní forum pro případné připomínky k překladu: <a href="http://wow.zdechov.net/forum/viewtopic.php?p=5533">Forum</a>
 
-</div>
-<br>
-<?php
+  </div>
+  <br />');
 }
-  
-          
-  ShowFooter();      
+        
+ShowFooter();      
 ?>

trunk/fill_database.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');
+include('includes/global.php');
   
-  echo 'Načítání questů z databáze: ';
+echo('Načítání textů z databáze MaNGOSu: ');
+echo('<div style="font-size: xx-small;">');
   
-  $sql = "SELECT * FROM mangos.quest_template as mangos_quests
-   WHERE NOT EXISTS (SELECT * FROM quests.quests WHERE quests.quests.entry=mangos_quests.entry)";
+foreach($TranslationTree as $Group)
+{
+  if(($Group['MangosTable'] != '') and ($Group['TablePrefix'] != ''))
+  {
+        echo('<br />'.$Group['Name'].'<br />');
+        $Columns = '`'.$Config['Database']['DatabaseMangos'].'`.`'.$Group['MangosTable'].'`.`'.$Group['MangosTableIndex'].'`';
+        foreach($Group['Items'] as $GroupItem)
+          $Columns .= ', `'.$Config['Database']['DatabaseMangos'].'`.`'.$Group['MangosTable'].'`.`'.$GroupItem['MangosColumn'].'` AS `'.$GroupItem['Column'].'`';
+        $Query = 'SELECT '.$Columns.' FROM `'.$Config['Database']['DatabaseMangos'].'`.`'.$Group['MangosTable'].'`'; 
+        echo($Query.'<br />');  
+        $Count = 0;
+        $NewCount = 0;
+        $DbResult = $Database->SQLCommand($Query);
+        while($DbRow = mysql_fetch_assoc($DbResult))
+        {
+          //echo('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$DbRow[$Group['MangosTableIndex']].' AND Language=0'."<br>");
+          $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$DbRow[$Group['MangosTableIndex']].' AND Language=0');
+          if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
+          {
+                $DbRow2 = mysql_fetch_assoc($DbResult2);
+                //echo($DbRow2['ID']);
+                $ColumnsValues = '';
+            foreach($Group['Items'] as $GroupItem)
+                {
+              $ColumnsValues .= ', `'.$GroupItem['Column'].'`="'.addslashes($DbRow[$GroupItem['MangosColumn']]).'"';
+                }
+                $ColumnsValues = substr($ColumnsValues, 2);
+                echo('. '); //'UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']."<br>");
+                //print_r($DbRow2);
+                $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']);
+          } else 
+          {
+                $Columns = 'entry, language';
+                $Values = $DbRow[$Group['MangosTableIndex']].', 0';
+            foreach($Group['Items'] as $GroupItem)
+                {
+              $Columns .= ', `'.$GroupItem['Column'].'`';
+                  $Values .= ', "'.addslashes($DbRow[$GroupItem['MangosColumn']]).'"';
+                }
+                //$Columns = substr($Columns, 2);
+                //$Values = substr($Values, 2);
+                $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
+                echo('# ');
+                //echo('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'."<br>");
+            $NewCount++;
+          }
+          $Count++;
+        }
+        echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
+  }
+}
+echo('Dokončeno.</div>');
   
-  $ID = $Database->SQLCommand($sql);
-  while ($Line = mysql_fetch_array($ID)) {
+WriteLog('Plnění databáze', 4);
   
-    $sql = "
-     INSERT INTO `quests` ( `ID` , `entry` , `Title` , `Details` , `Objectives` ,
-      `OfferRewardText` , `RequestItemsText` , `EndText` , `ObjectiveText1` , `ObjectiveText2` ,
-       `ObjectiveText3` , `ObjectiveText4` , `Language`)
-      VALUES (NULL , '".mysql_escape_string($Line['entry'])."', '".mysql_escape_string($Line['Title'])."', '".mysql_escape_string($Line['Details'])."',
-       '".mysql_escape_string($Line['Objectives'])."', '".mysql_escape_string($Line['OfferRewardText'])."', '".mysql_escape_string($Line['RequestItemsText'])."', '".mysql_escape_string($Line['EndText'])."',
-        '".mysql_escape_string($Line['ObjectiveText1'])."', '".mysql_escape_string($Line['ObjectiveText2'])."', '".mysql_escape_string($Line['ObjectiveText3'])."', '".mysql_escape_string($Line['ObjectiveText4'])."', '0')";
-  //  echo $sql;
-    $Database->SQLCommand($sql);
-  }
-  echo 'HOTOVO';
-  
-      WriteLog('Plnění databáze', 4);
-  
-          
-  ShowFooter();      
+ShowFooter();      
+
 ?>

trunk/form.php

@@ -1 +1 @@
 <?php
+
 include('includes/global.php');    
 
-  if (array_key_exists('ID', $_GET)) {
-    $QuestID = mysql_escape_string($_GET['ID']);  
+if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
+$Table = $TranslationTree[$GroupId]['TablePrefix'];
+if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';
 
-    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests Where ID = $QuestID"));
-     
-    $LineAJ = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests Where Language = '0' 
-    AND entry = '".$Line['entry']."'"));
- 
-    $User = @$_SESSION['User'];
-    $IDUser = $Database->SQLCommand("SELECT * FROM user Where id = '".$Line['User']."'");
-    $LineUser = mysql_fetch_array($IDUser);
+if(array_key_exists('ID', $_GET)) 
+{
+  $TextID = $_GET['ID'];  
+
+  $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.' Where ID = '.$TextID));
+  if(!$Line) die('Překlad nenalezen.');
+    
+  $LineAJ = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.' WHERE Language = 0  AND entry = '.$Line['entry']));
+  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);
   
       
-      if ($Line['Language'] <> '0' and $LineUser['user'] <> '') echo 'Přeložil: <b>'.$LineUser['user'].'</b> <br />';
-      if ($Line['Take'] <> '0' and $Line['Take'] <> $Line['ID']) {
-        $Language = mysql_fetch_array($Database->SQLCommand("SELECT Language FROM quests Where ID = '".$Line['Take']."'"));
-       // echo $Language['Language'].'  '.$Line['Take'];
-        if ($Language['Language'] <> 0)
-          echo 'Převzato z: <a href="form.php?ID='.$Line['Take'].'">'.$Line['Take'].'</a> <br />';
-      }
-    echo 'Quest: ';
-    if ($Line['Language'] <> '0') {
-      if ($Line['complete'] == 1) echo ' <b>Hotov</b><br />';
-      else echo ' <b> Uložen v rozepsaných</b><br />';
-    } else {
-      echo ' <b>Anglická, původní verze</b><br />';
-    }
+  if(($Line['Language'] <> 0) and ($LineUser['user'] <> '')) echo('Přeložil: <strong>'.$LineUser['user'].'</strong> <br />');
+  if(($Line['Take'] <> 0) and ($Line['Take'] <> $Line['ID'])) 
+  {
+    $Language = mysql_fetch_array($Database->SQLCommand('SELECT Language FROM '.$Table.' Where ID = '.$Line['Take']));
+    // echo $Language['Language'].'  '.$Line['Take'];
+    if($Language['Language'] <> 0)
+      echo('Převzato z: <a href="form.php?group='.$GroupId.'&amp;ID='.$Line['Take'].'">'.$Line['Take'].'</a> <br />');
+  }
+  echo('Text: ');
+  if($Line['Language'] <> 0) 
+  {
+    if($Line['complete'] == 1) echo(' <b>Hotov</b><br />');
+      else echo(' <b> Uložen v rozepsaných</b><br />');
+  } else 
+  {
+    echo(' <b>Anglická, původní verze</b><br />');
+  }
     
-    if ($Line['Language'] <> '0') {
-      echo 'Známka Questu: <b>'.$Line['Vote'].'</b><br />';
-    }
+  if($Line['Language'] <> 0) 
+  {
+    echo('Známka překladu: <b>'.$Line['Vote'].'</b><br />');
+  }    
     
-    
-  if (Licence(0) and ($LineUser['ID'] <> $_SESSION['UserID']) and ($Line['Language'] <> 0)) {
-    $LineVote = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests_vote WHERE 
-    IDuser = ".$_SESSION['UserID']." AND IDquest = $QuestID"));
-    if (!$LineVote) {
-      echo ' Hodnotit Quest: ';
-        for ($i=1; $i<6; ++$i)   
-          echo '<a href="action.php?vote='.$i.'&amp;ID='.$QuestID.'">'.$i.'</a> ';
-      echo ' bodů (5 nejlepší)';
-    } else { echo ' Již jsi hlasoval: '.$LineVote['vote']; }  
-  echo '<br>
-
-';
-  
-  
-  
+  if(Licence(LICENCE_USER) and ($LineUser['ID'] <> $_SESSION['UserID']) and ($Line['Language'] <> 0)) 
+  {
+    $LineVote = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.'_vote WHERE IDuser = '.$_SESSION['UserID'].' AND TextId = '.$TextID));
+    if(!$LineVote) 
+        {
+      echo(' Hodnotit text: ');
+      for($i = 1; $i < 6; ++$i)   
+        echo('<a href="action.php?group='.$GroupId.'&amp;vote='.$i.'&amp;ID='.$TextID.'">'.$i.'</a> ');
+      echo(' bodů (5 nejlepší)');
+    } else 
+        { 
+          echo(' Již jsi hlasoval: '.$LineVote['vote']); 
+        }  
+    echo('<br />');
   }
   
-//kontrolování textů  
-  $ID_translation = $QuestID;
+  // kontrolování textů  
+  $ID_translation = $TextID;
   $type_translation = 1;
-  $check = mysql_fetch_array($Database->SQLCommand("SELECT * FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND ID_translation = $ID_translation AND type_translation = $type_translation"));
-  echo '<form action="action.php" method="post" name="check">';
-  if ($check['tag'] == 1)
-    echo '<input name="0" type="submit" value="Odebrat z vlastního výběru">';
+  $check = mysql_fetch_array($Database->SQLCommand('SELECT * FROM tag WHERE ID_user = '.$_SESSION['UserID'].' AND ID_translation = '.$ID_translation.' AND type_translation = '.$type_translation));
+  echo('<form action="action.php?group='.$GroupId.'" method="post" name="check">');
+  if($check['tag'] == 1)
+    echo('<input name="0" type="submit" value="Odebrat z vlastního výběru" />');
   else 
-    echo '<input name="1" type="submit" value="Přidat do vlastního výběru">';
-  echo '  <input type="hidden" name="ID_translation" value="'.$ID_translation.'">
-  <input type="hidden" name="type_translation" value="'.$type_translation.'">
-          
-</form>';
-    if ($Line['admin_check'] <> '0') {
-      echo '<b>Quest byl zkontrolován adminem</b><br />';
-    }
-    if (Licence(2)) {
-      $admin_check = mysql_fetch_array($Database->SQLCommand("SELECT ID FROM quests Where entry = ".$Line['entry']." AND admin_check = 1 AND ID <> $QuestID"));
-      if (isset($admin_check['ID']))
-        echo 'Již byla zkontrolována adminem jiná verze questu: <a href="form.php?ID='.$admin_check['ID'].'">'.$admin_check['ID'].'</a><br />'; 
-    }
-      $number_version = mysql_fetch_array($Database->SQLCommand("SELECT count(*) FROM quests Where entry = ".$Line['entry']." AND Language <> 0"));
-      echo 'Počet verzí: <b>'.$number_version['count(*)'].'</b> '; 
-    echo '<a href="ListQuests.php?searchentry='.$Line['entry'].'">Zobrazit všechny verze tohoto questu</a>';
+    echo('<input name="1" type="submit" value="Přidat do vlastního výběru" />');
+  echo('  <input type="hidden" name="ID_translation" value="'.$ID_translation.'" />
+  <input type="hidden" name="type_translation" value="'.$type_translation.'" />          
+</form>');
+  if($Line['admin_check'] <> 0) 
+  {
+    echo('<b>Překlad byl zkontrolován adminem</b><br />');
+  }
+  if(Licence(LICENCE_ADMIN)) 
+  {
+    $admin_check = mysql_fetch_array($Database->SQLCommand('SELECT ID FROM '.$Table.' Where entry = '.$Line['entry'].' AND admin_check = 1 AND ID <> '.$TextID));
+    if(isset($admin_check['ID']))
+      echo('Již byla zkontrolována adminem jiná verze překladu: <a href="form.php?group='.$GroupId.'&amp;ID='.$admin_check['ID'].'">'.$admin_check['ID'].'</a><br />'); 
+  }
+  $number_version = mysql_fetch_array($Database->SQLCommand('SELECT count(*) FROM '.$Table.' Where entry = '.$Line['entry'].' AND Language <> 0'));
+  echo('Počet verzí: <b>'.$number_version['count(*)'].'</b> '); 
+  echo('<a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['entry'].'">Zobrazit všechny verze tohoto překladu</a>');
     
 //    Speciální znaky: $B - Odřádkování, $N - Jméno, $C - povolání
-?>    
-  <form action="save.php" method="post">
-<?php
-  if (Licence(0)) {
-    echo '<input type="submit" value="Uložit do rozepsaných" name="save" Title="Klikněte na uložit pro pozdější dokončení Q">
-    <input type="submit" value="Dokončeno" name="End" Title="Klikněte na Dokončeno jesli jsou všechny texty hotové a chcete již publikovat">';
-
+  echo('<form action="save.php?group='.$GroupId.'" method="post">');
+  if(Licence(LICENCE_USER)) 
+  {
+    echo('<input type="submit" value="Uložit do rozepsaných" name="save" Title="Klikněte na uložit pro pozdější dokončení překladu" />
+    <input type="submit" value="Dokončeno" name="End" Title="Klikněte na Dokončeno jesli jsou všechny texty hotové a chcete již publikovat" />');
   }
 
-
-  if (Licence(1) and $Line['Language'] <> 0) {
-    echo '<input type="submit" value="Opravit" name="Repair" Title="Opravit po uživateli chyby (Moderator only)">';  
+  if (Licence(LICENCE_MODERATOR) and ($Line['Language'] <> 0)) 
+  {
+    echo('<input type="submit" value="Opravit" name="Repair" Title="Opravit po uživateli chyby (pouze moderátor)" />');  
   }
-      if (Licence(1) and ($Line['Language'] <> 0)) {
+  if(Licence(LICENCE_MODERATOR) and ($Line['Language'] <> 0)) 
+  {
       //  echo '<input type="submit" value="Opravit Q" name="Repair"> Klikněte Jestli si přejete opravit chyby v Questu<br>';
         
-        echo ' <input type="hidden" name="UserRepair" value="'.$Line['User'].'">';
-        echo ' <a style="color: Red" title="smazat (Moderator only)" href="action.php?delete=1&amp;ID='.$QuestID.'">x</a>  
-        <a style="color: Red" title="Není hotovo (Moderator only)" href="action.php?NotComplete=1&amp;ID='.$QuestID.'"><-</a> 
-        
-        ';  
-        if (Licence(2)) {
-          if ($Line['admin_check'] <> '1') {
-            echo ' <a style="color: Green" title="Zkontrolováno (Admin only)" href="action.php?admin_check=1&amp;ID='.$QuestID.'"><b>+</b></a>';
-          } else {
-            echo ' <a style="color: Green" title="Zrušit zkontrolování (Admin only)" href="action.php?admin_check=0&amp;ID='.$QuestID.'"><b>-</b></a>';
-          } 
-        }
-      }
-?>
-    <input type="hidden" name="entry" value="<?php echo $LineAJ['entry']?>">
-    <input type="hidden" name="user" value="<?php echo $User ?>">
-    <input type="hidden" name="ID" value="<?php echo $QuestID ?>">
+    echo(' <input type="hidden" name="UserRepair" value="'.$Line['User'].'" />');
+    echo(' <a style="color: Red" title="smazat (pouze moderátor)" href="action.php?group='.$GroupId.'&amp;action=delete&amp;delete=1&amp;ID='.$TextID.'">x</a>  
+        <a style="color: Red" title="Není hotovo (pouze moderátor)" href="action.php?group='.$GroupId.'&amp;action=NotComplete&amp;NotComplete=1&amp;ID='.$TextID.'"><-</a>');  
+    if(Licence(LICENCE_ADMIN)) 
+        {
+      if($Line['admin_check'] <> '1') 
+          {
+        echo(' <a style="color: Green" title="Zkontrolováno (pouze admin)" href="action.php?group='.$GroupId.'&amp;action=admin_check&amp;admin_check=1&amp;ID='.$TextID.'"><b>+</b></a>');
+      } else 
+          {
+        echo(' <a style="color: Green" title="Zrušit zkontrolování (pouze admin)" href="action.php?group='.$GroupId.'&amp;action=admin_check&amp;admin_check=0&amp;ID='.$TextID.'"><b>-</b></a>');
+      } 
+    }
+  }
+
+  echo('<input type="hidden" name="entry" value="'.$LineAJ['entry'].'" />
+    <input type="hidden" name="user" value="'.$User.'" />
+    <input type="hidden" name="ID" value="'.$TextID.'" />
     <table border="1" cellpadding="1" cellspacing="0">
       <tr>
-        <th>Číslo Q.: <?php echo '<a Title="Zobrazit quest na wowhead.com" href="http://www.wowhead.com/?quest='.$LineAJ['entry'].'">'.$LineAJ['entry'].'</a>'; ?></th>
+        <th>Číslo textu: <a Title="Zobrazit text na wowhead.com" href="http://www.wowhead.com/?quest='.$LineAJ['entry'].'">'.$LineAJ['entry'].'</a></th>
         <th>Nepřeložené</th>
         <th>Přeložené</th>
@@ -121 +131 @@
         <td width="300">Anglický</td>
         <td>
-          Přeloženo do: <?php 
-          if ($Line['Language'] <> 0) 
-              $Language = $Line['Language']; 
-          else {
-            $IDUser = $Database->SQLCommand("SELECT * FROM user Where id = '".@$_SESSION['UserID']."'");
-            $LineUser = mysql_fetch_array($IDUser);
-            $Language = $LineUser['Language'];  //jiný user vyčítám
-          }
-              WriteLanguages($Language);
-              ?>
-        </td>
-      </tr>
-      <tr>
-        <th>Title</th>
-        <td width="300"><?php echo htmlspecialchars($LineAJ['Title'])?></td>
-        <td><input type="text" size="45" name="Title" value="<?php echo htmlspecialchars($Line['Title']) ?>"></td>
-      </tr>
-      
-<?php  foreach($Texts as $Index => $TextItem)
-          {          
-          if (($LineAJ[$TextItem[0]] <> '') or ($Line[$TextItem[0]] <> ''))  
-            echo '
-      <tr>
-        <th>'.$TextItem[0].'</th>
-        <td width="300">'.htmlspecialchars($LineAJ[$TextItem[0]]).'</td>
-        <td><textarea rows="8" style="width: 300px; height=100%;" name="'.$TextItem[0].'">'.htmlspecialchars($Line[$TextItem[0]]).'</textarea></td>
-      </tr>
-      ';
-      
-      }
-          
-?>
-   
-    </table>            
-  </form>
-<?php    
+          Přeloženo do:'); 
+  if($Line['Language'] <> 0) $Language = $Line['Language']; 
+  else 
+  {
+    $IDUser = $Database->SQLCommand('SELECT * FROM user Where id = '.@$_SESSION['UserID']);
+    $LineUser = mysql_fetch_array($IDUser);
+    $Language = $LineUser['Language'];  //jiný user vyčítám
+  }
+  WriteLanguages($Language);
+  echo('</td></tr><tr>');
+  foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
+  {          
+    if(($LineAJ[$TextItem['Column']] <> '') or ($Line[$TextItem['Column']] <> ''))  
+    echo('<tr>
+      <th>'.$TextItem['Name'].'</th>
+      <td width="300">'.htmlspecialchars($LineAJ[$TextItem['Column']]).'</td>
+      <td><textarea rows="8" style="width: 300px; height=100%;" name="'.$TextItem['Column'].'">'.htmlspecialchars($Line[$TextItem['Column']]).'</textarea></td></tr>');
+  }
+  echo('</table>            
+  </form>');
+} else 
+{
+  // include 'ListQuests.php';   
+  echo('Nebylo zadáno ID <a href="index.php">zpět</a>');
+}
 
-  } else {
-   // include 'ListQuests.php';   
-    
-    echo 'Nebylo zadáno ID <a href="index.php">zpět</a>';
-    
-  }
+ShowFooter();
 
-
-  
-   ShowFooter();
 ?>   
 

trunk/img_statistic.php

@@ -3 +3 @@
 include('includes/config.php');
 include('includes/databaseconection.php');
+
+// SQL injection hack protection
+foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($_POST[$Index]);
+foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($_GET[$Index]);
 
 //připojení do databáze
@@ -12 +16 @@
 
 //  echo  "SELECT count(distinct(entry)) FROM $TypeTexts WHERE Language <> '0' AND Complete = '1'";
-  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(distinct(entry)) FROM $TypeTexts WHERE Language <> '0' AND Complete = '1'"));
+  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(distinct(entry)) FROM ".$TypeTexts." WHERE Language <> '0' AND Complete = '1'"));
   $NumberTranslate = $ID[0];
   
-  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM $TypeTexts WHERE Language = '0'"));
+  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM ".$TypeTexts." WHERE Language = '0'"));
   $NumberAJ = $ID[0];
 
-  $Percent = ($NumberTranslate/$NumberAJ)*100;
+  $Percent = ($NumberTranslate / $NumberAJ) * 100;
   $Percent = substr($Percent, 0, 5);
 
-  $PercentBar = $Percent*4;
-  $obrazek = imagecreatetruecolor(400,60);
-  $Color1 = imagecolorallocate($obrazek,225,246,247);
-  $Color2 = imagecolorallocate($obrazek,77,225,251);
-  $Color3 = imagecolorallocate($obrazek,2,59,199);
-  imagefilledrectangle($obrazek,0,0,400,59,$Color1);
-  imagefilledrectangle($obrazek,0,0,$PercentBar,59,$Color2);
-  imagestring($obrazek, 10, 120, 15, $NumberTranslate.'/'.$NumberAJ, $Color3);
-  imagestring($obrazek, 3, 300, 15, $TypeTexts, $Color3);
-  imagestring($obrazek, 10, 120, 30, $Percent.' %', $Color3);
-  imagestring($obrazek, 1, 240, 50, 'Aktualizováno: '.date("m.d.y  H:i"), $Color3);
- 
+  $PercentBar = $Percent * 4;
+  $obrazek = imagecreatetruecolor(400, 40);
+  $Color1 = imagecolorallocate($obrazek, 225, 246, 247);
+  $Color2 = imagecolorallocate($obrazek, 77, 225, 251);
+  $Color3 = imagecolorallocate($obrazek, 2, 9, 199);
+  imagefilledrectangle($obrazek, 0, 0, 400, 39, $Color1);
+  imagefilledrectangle($obrazek, 0, 0, $PercentBar, 59, $Color2);
+  imagestring($obrazek, 10, 120, 5, $NumberTranslate.'/'.$NumberAJ, $Color3);
+  imagestring($obrazek, 3, 300, 5, $TypeTexts, $Color3);
+  imagestring($obrazek, 10, 120, 20, $Percent.' %', $Color3);
+  imagestring($obrazek, 1, 240, 30, 'Aktualizace: '.date("m.d.y  H:i"), $Color3);
  
   header('Content-Type: image/png');

trunk/includes/config.sample.php

@@ -6 +6 @@
     'User' => 'root',
     'Password' => '',
-    'Database' => 'quests',
+    'Database' => 'wowpreklad',
     'DatabaseCharacters' => 'characters',
     'DatabaseMangos' => 'mangos',
@@ -16 +16 @@
     'Charset' => 'utf-8',
     'BaseURL' => 'http://localhost/',
+        'AdminEmail' => 'admin@localhost',
   ),
 );

trunk/includes/databaseconection.php

@@ -22 +22 @@
   {
     $ReturnCommand = mysql_query($Command, $this->id_connection);
-    return $ReturnCommand;
+        if(mysql_error() != '') echo('<div>'.mysql_error().'<br>'.$Command.'</div>');
+    return($ReturnCommand);
   }
    

trunk/includes/global.php

@@ -4 +4 @@
 
 // SQL injection hack protection
-foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($_POST[$Index]);
+foreach($_POST as $Index => $Item)
+{
+  if(is_array($_POST[$Index])) 
+    foreach($_POST[$Index] as $Index2 => $Item2) $_POST[$Index][$Index2] = addslashes($Item2);
+  else $_POST[$Index] = addslashes($_POST[$Index]);
+}
 foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($_GET[$Index]);
 
@@ -70 +75 @@
     'index.php?Logout' => array(LICENCE_USER, 'Odhlášení ze systému', 'Odhlásit'),
         'log.php' => array(LICENCE_MODERATOR, 'Log dění (Pouze moderátor)', 'Záznamy'),
-        'priorite.php' => array(LICENCE_ADMIN, 'Načtení priority questů (pouze admin)', 'Priorita'),
-        'fill_database.php' => array(LICENCE_ADMIN, 'Načtení questů do database (pouze admin)', 'Plnění databáse'), 
+        'fill_database.php' => array(LICENCE_ADMIN, 'Načtení questů do database (pouze admin)', 'Import textů z MaNGOSu'), 
         //'client_files/generate_SQL.php' => array(LICENCE_ADMIN, 'Generování clientských souborů (pouze admin)', 'Generování C.S.'),
     'https://wow.zdechov.net/mysql/' => array(LICENCE_ADMIN, 'phpMyAdmin(pouze admin)', 'Správa databáze'),
@@ -86 +90 @@
   echo('<br />');
   
+  echo('<strong>Překladové skupiny:</strong><br />');
   foreach($TranslationTree as $Group)
   {
@@ -91 +96 @@
       <a href="TranslationList.php?group='.$Group['Id'].'&amp;action=filter">'.$Group['Name'].'</a></div>       
       <div id="group'.$Group['Id'].'" class="hidden-menu-item" onmousemove="show(\'group'.$Group['Id'].'\')" onmouseout="hide(\'group'.$Group['Id'].'\')">');
-    echo('&nbsp;<a title="Zde můžete začít překládat" href="TranslationList.php?group='.$Group['Id'].'&amp;action=selection">Nepřeložené</a><br />
+    echo('&nbsp;<a title="Zde můžete začít překládat" href="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="TranslationList.php?group='.$Group['Id'].'&amp;action=Translate">Přeložené</a><br />');
     if(Licence(LICENCE_USER)) 
@@ -104 +109 @@
       echo('&nbsp;<a title="Zkontrolované překlady" href="TranslationList.php?group='.$Group['Id'].'&amp;action=check">Zkontrolované</a><br />');
     }
-    echo('&nbsp;<a title="Sestavit speciální fitr" href="TranslationList.php?group='.$Group['Id'].'&amp;action=filter">Filtr</a><br />');
+    echo('&nbsp;<a title="Sestavit speciální filtr" href="TranslationList.php?group='.$Group['Id'].'&amp;action=filter">Filtr</a><br />');
     echo('</div>');
   }

trunk/includes/global_function.php

@@ -87 +87 @@
   while($DbRow = mysql_fetch_assoc($DbResult))
   {
-        $Result[$DbRow['Group']]['Items'][$DbRow['Id']] = $DbRow;
+        $Result[$DbRow['Group']]['Items'][] = $DbRow;
   }
   return($Result);
 }
-
-$Texts = array
-(
-  //array('Title'),
-  array('Details'),
-  array('Objectives'),
-  array('OfferRewardText'),
-  array('RequestItemsText'),
-  array('EndText'),
-  array('ObjectiveText1'),
-  array('ObjectiveText2'),
-  array('ObjectiveText3'),
-  array('ObjectiveText4'),
-);
 
 $LogTypes = array
@@ -128 +114 @@
   $user = @$_SESSION['UserID'];
   $Database->SelectDatabase($Config['Database']['Database']);    
-  $Database->SQLCommand('INSERT INTO `log` ( `user` , `type` , `text` , `date` , `IP` )
-   VALUES ( "'.$user.'", "'.$Type.'", "'.$Text.'", NOW(), "'.$_SERVER['REMOTE_ADDR'].'")');
+  $Query = 'INSERT INTO `log` ( `user` , `type` , `text` , `date` , `IP` )
+   VALUES ('.$user.', '.$Type.', "'.addslashes($Text).'", NOW(), "'.addslashes($_SERVER['REMOTE_ADDR']).'")';
+  $Database->SQLCommand($Query);
 }
 
-$npc_text = array
-(
-  '0' => 'text0_0',
-  '1' => 'text0_1',
-  '2' => 'text1_0',
-  '3' => 'text1_1',
-  '4' => 'text2_0',
-  '5' => 'text2_1',
-  '6' => 'text3_0',
-  '7' => 'text3_1',
-  '8' => 'text4_0',
-  '9' => 'text4_1',
-  '10' => 'text5_0',
-  '11' => 'text5_1',
-  '12' => 'text6_0',
-  '13' => 'text6_1',
-  '14' => 'text7_0',
-  '15' => 'text7_1',
-);
-
-$page_text = array
-(
-  '0' => 'text',
-);
 
 $client_files = array
@@ -168 +131 @@
 );
 
-$client_text = array
-(
-  '0' => 'text',
-);
-
 ?>

trunk/index.php

@@ -41 +41 @@
   - Pro překládání nestačí vložit text do PC Translatoru a nechat ho zpracovat. Je nutné provést ruční kontrolu a překlad.<br />
   - Doporučujeme používat prohlížeč Mozilla Firefox a stáhnout si něj rozšiření pro kontrolu pravopisu: 
-  <a href="https://addons.mozilla.org/cs/firefox/browse/type:3">Rozšíření do mozily</a><br />
+  <a href="https://addons.mozilla.org/cs/firefox/browse/type:3">Rozšíření do Firefoxu</a><br />
   <br />
   
 <?php
 //  Některé texty najdete <a href="http://wow-cz.wz.cz/index.php">zde</a>
-  if (Licence(0)) 
+  if(Licence(LICENCE_USER)) 
   {
-
+/*
     $UserID = $_SESSION['UserID'];
     $ID = $Database->SQLCommand("SELECT COUNT(*) FROM quests WHERE User='$UserID' AND complete = 0");
@@ -59 +59 @@
     if($ID['Email'] == '')    
       echo('<span style="color: red"><b>Nemáte nastavený e-mail, <a href="Options.php">nastavit</a></b></span>');
-
+*/
   }
           

trunk/log.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');  
+include('includes/global.php');  
   
-  echo '<b>Filtr: </b>';
-    Echo '<a href="log.php" Title="Bez filtrování"><span style="color:black">Všechny</span></a> ';
+echo('<b>Filtr: </b>');
+echo('<a href="log.php" title="Bez filtrování"><span style="color:black">Všechny</span></a> ');
+foreach($LogTypes as $Index => $LogItem)
+{
+  echo('<a href="log.php?type='.$LogItem[0].'" title="'.$LogItem[3].'"><span style="color:'.$LogItem[2].'">'.$LogItem[1].'</span></a> ');
+}
+
+// echo ' Formát: datum: text zprávy (uživatel, IP)<br /><br />';
+echo('<br /><br />');
+
+if(array_key_exists('type', $_GET)) 
+{
+  $sql = "SELECT *,(SELECT user.user FROM user WHERE user.id = log.user) as user
+    FROM log WHERE type = '".$_GET['type']."' ORDER BY date DESC LIMIT 100";
+    //  if ($_GET['type'] == $LogItem[0]) { }
+} else $sql = "SELECT *,(SELECT user.user FROM user WHERE user.id = log.user) as user FROM log ORDER BY date DESC LIMIT 100";
+       
+$ID = $Database->SQLCommand($sql);
+while($Line = mysql_fetch_array($ID)) 
+{
   foreach($LogTypes as $Index => $LogItem)
   {
-    Echo '<a href="log.php?type='.$LogItem[0].'" Title="'.$LogItem[3].'"><span style="color:'.$LogItem[2].'">'.$LogItem[1].'</span></a> ';
+    if($Line['type'] == $LogItem[0]) $color = $LogItem[2]; 
   }
+  echo($Line['date'].': <span style="color:'.$color.'">'.$Line['text'].'</span> ('.$Line['user'].', '.$Line['IP'].')<br />');
+}            
+          
+ShowFooter();      
 
-
-     // echo ' Formát: datum: text zprávy (uživatel, IP)<br /><br />';
-     echo '<br /><br />';
-
-  if (array_key_exists('type', $_GET)) {
-      $sql = "SELECT *,(SELECT user.user FROM user WHERE user.id = log.user) as user
-       FROM log WHERE type = '".$_GET['type']."' ORDER BY date DESC LIMIT 100";
-    //  if ($_GET['type'] == $LogItem[0]) { }
-  } else $sql = "SELECT *,(SELECT user.user FROM user WHERE user.id = log.user) as user
-       FROM log ORDER BY date DESC LIMIT 100";
-       
-       
-      $ID = $Database->SQLCommand($sql);
-      while ($Line = mysql_fetch_array($ID)) {
-        foreach($LogTypes as $Index => $LogItem)
-        {
-          if ($Line['type'] == $LogItem[0]) { $color = $LogItem[2]; }
-        }
-        echo $Line['date'].': <span style="color:'.$color.'">'.$Line['text'].'</span> ('.$Line['user'].', '.$Line['IP'].')<br />';
-      }      
-          
-  ShowFooter();      
 ?>

trunk/registrace.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');
+include('includes/global.php');
   
-  if (array_key_exists('user', $_POST)) {
-
+if(array_key_exists('user', $_POST)) 
+{
   $User = $_POST['user'];
   $Pass = $_POST['pass'];
@@ -11 +11 @@
   $Language = $_POST['Language'];
 
-  if ($Pass == $Pass2) {
-    
+  if($Pass == $Pass2) 
+  {
     $Line = mysql_fetch_row($Database->SQLCommand("SELECT * FROM user WHERE user = '$User'"));
-    if (!$Line) {
+    if(!$Line) 
+        {
       $Addres = $_SERVER['REMOTE_ADDR'];
       $Database->SQLCommand("INSERT INTO `user` (`user` , `pass` , `LastIP` , `LastLogin` , `Email` , `Language` )
       VALUES ('$User','$Pass','$Addres',now(),'$Email','$Language')");
    //   $Database->SQLCommand("INSERT INTO user () VALUES('$User','$Pass','0','$Addres',now(),'0','$Email')");
-      echo 'Registrace proběhla úspěšně<br />';
+      echo('Registrace proběhla úspěšně<br />)');
       WriteLog('Uživatel se zaregistroval: '.$User, 3);
       
@@ -29 +30 @@
       
  // echo $Database->id_connection;
-    } else {
-      echo 'Uživatel s touto přezdívkou již existuje
-     <A href="registrace.php">zpět</a>';
+    } else 
+        {
+      echo('Uživatel s touto přezdívkou již existuje. <a href="registrace.php">Zpět</a>');
     }
-  } else { 
-    echo 'Hesla se neshodují
-     <A href="registrace.php">zpět</a>';
-  }
-    
-} else {
-
-?>
-  <form action="registrace.php" method="post">
+  } else 
+  {
+        echo('Hesla se neshodují. <a href="registrace.php">Zpět</a>');
+  }    
+} else 
+{
+  echo('<form action="registrace.php" method="post">
   <table>
     <tr>
       <td>Jméno:</td>
-      <td><input type="text" name="user"></td>
+      <td><input type="text" name="user" /></td>
     </tr>
     <tr>
       <td>Heslo:</td>
-      <td><input type="password" name="pass"></td>
+      <td><input type="password" name="pass" /></td>
     </tr>
     <tr>
       <td>Potvrzení Hesla: </td>
-      <td><input type="password" name="pass2"></td>
+      <td><input type="password" name="pass2" /></td>
     </tr>
     <tr>
       <td>Email: </td>
-      <td><input type="text" name="Email"></td>
+      <td><input type="text" name="Email" /></td>
     </tr>
     <tr>
       <td>Normálně budu překládat do: </td>
-      <td><?php WriteLanguages($Line['Language']); ?></td>
+      <td>'); WriteLanguages(1); echo('</td>
     </tr>
+    <tr>
+      <th><input type="submit" value="Registrovat" /></th>
+    </tr>
+  </table></form>');
+}
+ 
+ShowFooter();      
 
-
-    <tr>
-      <th><input type="submit" value="Registrovat"></th>
-    </tr>
-  </table>
-</form>
-
-<?php  
-
-}
-        
-  ShowFooter();      
 ?>

trunk/save.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');
+include('includes/global.php');
 
-  // SQL injection hack protection
-  foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($Item);
-  foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($Item);
 
-  //ochrana proti neoprávněnému přístupu
-  if (Licence(0) == false) { die('Nemáte přístup do této sekce! Přihlašte se...'); }
+// 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 (array_key_exists('entry', $_POST)) {
+if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
+$Table = $TranslationTree[$GroupId]['TablePrefix'];
+
+if(array_key_exists('entry', $_POST)) 
+{
+  $entry = $_POST['entry'];  
+  $UserID = $_SESSION['UserID'];
+  $TextID = $_POST['ID'];
+  $Language = $_POST['Language'];
+  if(array_key_exists('End', $_POST)) $complete = 1;
+    else $complete = 0;
+          
+  if(array_key_exists('Repair', $_POST) and Licence(1)) 
+  {
+    $Line = mysql_fetch_array($Database->SQLCommand('SELECT user FROM '.$Table.' Where ID = '.$TextID));
+    $UserID = $Line['user'];    
+    $complete = 1;
+    WriteLog($TranslationTree[$GroupId]['Name'].' '.$entry.' Opraven moderátorem! <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 4);
+  }
+      
+  //if(( == '') AND ($complete == 1)) die('Musite zadat název textu');
     
-    $entry = $_POST['entry'];  
-    $Title = $_POST['Title'];  
-    $Details = @$_POST['Details'];
-    $Objectives = @$_POST['Objectives'];
-    $OfferRewardText = @$_POST['OfferRewardText'];
-    $RequestItemsText = @$_POST['RequestItemsText'];
-    $EndText = @$_POST['EndText'];
-    $ObjectiveText1 = @$_POST['ObjectiveText1'];
-    $ObjectiveText2 = @$_POST['ObjectiveText2'];
-    $ObjectiveText3 = @$_POST['ObjectiveText3'];
-    $ObjectiveText4 = @$_POST['ObjectiveText4'];
-
-    $UserID = $_SESSION['UserID'];
-    $QuestID = $_POST['ID'];
-    $Language = $_POST['Language'];
-    if (array_key_exists('End', $_POST))
-      $complete = 1;
-    else 
-      $complete = 0;
+  $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.' WHERE user='.$UserID.' AND entry = '.$entry));
+  if(!$Line) 
+  {
+        $Columns = '`entry`, `Language` , `User` , `complete` , `Take` , `Vote` , `CountVote`';
+        $Values = $entry.','.$Language.','.$UserID.','.$complete.','.$TextID.', 3 ,1';
+        foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
+        {
+          $Columns .= ', `'.$GroupItem['Column'].'`';
+          $Values .= ', "'.@$_POST[$GroupItem['Column']].'"';
+        }  
+        //echo('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
+    $Database->SQLCommand('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
+        $LastID = mysql_insert_id();
+    echo('Překlad <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> uložen!<br />');
+    WriteLog($TranslationTree[$GroupId]['Name'].' <a href="form.php?group='.$GroupId.'&amp;ID='.$LastID.'">'.$LastID.'</a> uložen! Převzat z: <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 1);
+  } else 
+  {
+    $sql = 'UPDATE '.$Table.' SET `complete` = '.$complete;
+        foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
+          $sql .= ', `'.$GroupItem['Column'].'`="'.@$_POST[$GroupItem['Column']].'"';
+        $sql .= ', `Language` = '.$Language.', `Vote` = 3, `CountVote` = 1, admin_check = 0 
+        WHERE ID = '.$TextID.' AND Language <> 0';
+        //echo($sql);
+    $Database->SQLCommand($sql);
+    //  echo $sql.'<br />';      
+    echo('Změny v překladu: <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> uloženy!<br />');
+    WriteLog('Změny v překladu: '.$entry.' uloženy! <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 1);
+    $Database->SQLCommand('DELETE FROM `'.$Table.'_vote` WHERE `TextId` = '.$TextID);
+    $type_translation = 1;
+    $ID_translation = $TextID;
+    $Database->SQLCommand("DELETE FROM tag WHERE ID_translation = $ID_translation AND type_translation = $type_translation");
+  }
+    
+  echo('Překládat: <a href="TranslationList.php?group='.$GroupId.'&amp;action=notran">Nepřeložené</a>');
+}
           
-    if ($complete == 1) $Database->SQLCommand("DELETE FROM `quests`.`quests_status` WHERE QuestEntry = '$entry'");
-
-    if (array_key_exists('Repair', $_POST) and Licence(1)) {
-      $Line = mysql_fetch_array($Database->SQLCommand("SELECT user FROM quests Where ID = '$QuestID'"));
-      $UserID = $Line['user'];    
-      $complete = 1;
-      WriteLog('Quest: '.$entry.' Opraven moderátorem! <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 4);
-    }
-      
-    if (($Title == '') AND ($complete == 1)) die('Musite zadat název Q');
-    
-    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests WHERE user='$UserID' AND entry = '$entry'"));
-    if (!$Line) {
-    
-      $Database->SQLCommand("INSERT INTO `quests` (`entry` , `Title` , `Details` , `Objectives` , `OfferRewardText` , `RequestItemsText` ,
-      `EndText` , `ObjectiveText1` , `ObjectiveText2` , `ObjectiveText3` , `ObjectiveText4` , `Language` , `User` , `complete` , `Take` , `Vote` , `CountVote` )
-      VALUES('$entry','$Title','$Details','$Objectives','$OfferRewardText','$RequestItemsText','$EndText','$ObjectiveText1',
-      '$ObjectiveText2','$ObjectiveText3','$ObjectiveText4','$Language','$UserID','$complete','$QuestID','3','1')");
-      echo 'Quest: '.$entry.' uložen!<br />';
-      WriteLog('Quest: '.$entry.' uložen! Přvzat z: <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 1);
-    } else {
-      $sql = "UPDATE quests SET complete = '$complete', Title = '$Title',
-       Details = '$Details', Objectives = '$Objectives',
-       OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText',
-       EndText = '$EndText', ObjectiveText1 = '$ObjectiveText1', ObjectiveText2 = '$ObjectiveText2',
-       ObjectiveText3 = '$ObjectiveText3', ObjectiveText4 = '$ObjectiveText4', Language = '$Language',
-       Vote = '3', CountVote = '1', admin_check = '0'
-        WHERE ID = ".$QuestID." AND Language <> 0";
-      $Database->SQLCommand($sql);
-    //  echo $sql.'<br />';      
-      echo 'Změny v Questu: <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a> uloženy!<br />';
-      WriteLog('Změny v Questu: '.$entry.' uloženy! <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 1);
-      $Database->SQLCommand("DELETE FROM `quests_vote` WHERE `quests_vote`.`IDquest` = ".$QuestID);
-      $type_translation = 1;
-      $ID_translation = $QuestID;
-      $Database->SQLCommand("DELETE FROM tag WHERE ID_translation = $ID_translation AND type_translation = $type_translation");
-    }
-    
-    echo 'Překládat: <a href="ListQuests.php?selection">Nepřeložené</a> ';
-      
-  }
-          
-  ShowFooter();      
+ShowFooter();      
 ?>

trunk/statistic.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');
+include('includes/global.php');
+
+echo('<strong>Statistika:</strong><br />');
+foreach($TranslationTree as $Group)
+  if($Group['TablePrefix'] != '') echo('<img alt="'.$Group['TablePrefix'].'" src="img_statistic.php?TypeText='.$Group['TablePrefix'].'" title="statistika překladů '.$Group['Name'].'" style="margin: 2px 0px 0px 0px;" /><br />');
+
+echo('<br />
+<b>Statistika v závislosti na čase: </b><a href="http://stat.zdechov.net/game/?Measure=18">Počet přeložených textů</a><br />
+<br />
+Počet stáhnutí přeložených textů v SQL souboru: <b>');
+       
+$ID = $Database->SQLCommand("SELECT count(distinct(IP)) FROM log WHERE type = 2");
+$Line = mysql_fetch_row($ID);
+echo($Line[0]);
+
+echo('</b><br />
+Počet stáhnutí CZWoW pro clienta: <b>');
+      
+$ID = $Database->SQLCommand("SELECT count(distinct(IP)) FROM log WHERE type = 0");
+$Line = mysql_fetch_row($ID);
+echo($Line[0]);
+
+echo('</b><br /><br />
+<b>Seznam uživatelů: </b>
+<table border="1" cellpadding="2" cellspacing="0">');
+
+if(array_key_exists('order', $_GET)) 
+{
+  $order = $_GET['order'];
+  $desc = $_GET['desc'];
+} else 
+{
+  $order = 'NumberTranslate';
+  $desc = '';
+}
+
+if($desc == '') $desc = 'desc'; else $desc = '';
+
+echo('<tr><th><a href="?order=user&amp;desc='.$desc.'">Jméno</a></th>
+  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" title="Počet přeložených textů">Přeložených</a></th>
+  <th><a href="statistic.php?order=Vote&amp;desc='.$desc.'" title="Průměrná známka textů">Průměrná známka</a></th>
+  <th><a href="statistic.php?order=GM&amp;desc='.$desc.'">Oprávnění</a></th>
+  <th><a href="statistic.php?order=LastLogin&amp;desc='.$desc.'">Poslední připojení</a></th></tr>');
+
+$Query = 'SELECT ID,user, LastLogin, GM, (';
+foreach($TranslationTree as $Group);
+  if($Group['TablePrefix'] != '')
+    $Query .= '(SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE User = user.ID AND Complete = 1 AND Language <> 0) + ';
+$Query .= '0) as NumberTranslate, (';
+foreach($TranslationTree as $Group)
+  if($Group['TablePrefix'] != '')
+    $Query .= 'IFNULL((SELECT sum(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE User = user.ID AND Complete =1 AND Language <> 0), 0) + ';
+$Query .= '0) / (';
+foreach($TranslationTree as $Group)
+  if($Group['TablePrefix'] != '')
+    $Query .= '(SELECT count(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE User = user.ID AND Complete =1 AND Language <> 0) + ';
+$Query .= '0) AS Vote FROM `user` ORDER BY '.$order.' '.$desc;
+$ID = $Database->SQLCommand($Query);
+while($Line = mysql_fetch_array($ID)) 
+{
+  if(Licence(LICENCE_MODERATOR)) 
+    $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['user'].'</a>';
+    else $Name = $Line['user'];
+        
+    echo('<tr><td>'.$Name.'</td>
+      <td>'.$Line['NumberTranslate'].'</td>
+      <td>'.substr($Line['Vote'], 0, 4).'</td>
+      <td>'.$Moderators[$Line['GM']].'</td>
+      <td>'.$Line['LastLogin'].'</td></tr>');
+}
+echo('</table>');
+          
+ShowFooter();      
 
 ?>
-
-<b>Statistika:</b><br>
- <img alt="quests" src="img_statistic.php?TypeText=quests" title="statistika překladu úkolů" style="margin: 2px 0px 0px 0px;"><br />
- <img alt="npc_text" src="img_statistic.php?TypeText=npc_text" title="statistika překladu NPC_textů" style="margin: 2px 0px 0px 0px;"><br />
- <img alt="page_text" src="img_statistic.php?TypeText=page_text" title="statistika překladu page_textů" style="margin: 2px 0px 0px 0px;"><br />
-<?php // <img alt="page_text" src="img_statistic.php?TypeText=client_text" title="statistika překladu client_textů" style="margin: 2px 0px 0px 0px;"><br />
-?>
-
-<br>
-<b>Statistika v závislosti na čase: </b><a href="http://stat.zdechov.net/game/?Measure=18">Počet přeložených textů</a><br>
-<br />
-Počet stáhnutí přeložených textů v SQL souboru: <b>
-<?php
-       
-      $ID = $Database->SQLCommand("SELECT count(distinct(IP)) FROM log WHERE type = 2");
-      $Line = mysql_fetch_row($ID);
-      echo $Line[0];
-?>
-</b><br />
-Počet stáhnutí CZWoW pro clienta: <b>
-<?php
-       
-      $ID = $Database->SQLCommand("SELECT count(distinct(IP)) FROM log WHERE type = 0");
-      $Line = mysql_fetch_row($ID);
-      echo $Line[0];
-?>
-</b><br /><br />
-<b>Seznam uživatelů: </b>
-<table border="1" cellpadding="2" cellspacing="0">
-<?php  
-
-  if(array_key_exists('order', $_GET)) {
-    $order = $_GET['order'];
-    $desc = $_GET['desc'];
-  } else {
-    $order = 'NumberTranslate';
-    $desc = '';
-  }
-
-  if ($desc == '') $desc = 'desc'; else $desc = '';
-
-  echo '<tr><th><a href="statistic.php?order=user&amp;desc='.$desc.'">Jméno</a></th>
-  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Počet přeložených textů">Přeložených</a></th>
-  <th><a href="statistic.php?order=Vote&amp;desc='.$desc.'" Title="Průměrná známka textů">Průměrná známka</a></th>
-  <th><a href="statistic.php?order=GM&amp;desc='.$desc.'">Oprávnění</a></th>
-  <th><a href="statistic.php?order=LastLogin&amp;desc='.$desc.'">Poslední připojení</a></th></tr>';
-
-/*
-SELECT user, LastLogin, GM, (
-     (SELECT count(*) FROM `quests` WHERE User = user.ID AND User <> 0 AND Complete = 1) + 
-     (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND User <> 0 AND Complete = 1) +
-     (SELECT count(*) FROM `page_text` WHERE User = user.ID AND User <> 0 AND Complete = 1)
-   ) as NumberTranslate, (
-     SELECT IFNULL((SELECT AVG(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1),0)
-     + IFNULL((SELECT AVG(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1),0)
-     + IFNULL((SELECT AVG(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1),0)
-     ) /3 AS Vote
-   FROM `user`
-   
-   */
-
-  $ID = $Database->SQLCommand("
-  SELECT ID,user, LastLogin, GM, (
-     (SELECT count(*) FROM `quests` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
-    + (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
-    + (SELECT count(*) FROM `page_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
-    + (SELECT count(*) FROM `client_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
-   ) as NumberTranslate, (
-       IFNULL((SELECT sum(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
-     + IFNULL((SELECT sum(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
-     + IFNULL((SELECT sum(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
-     + IFNULL((SELECT sum(Vote) AS Vote FROM `client_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
-     ) / (
-       (SELECT count(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1 AND Language <> 0)
-     + (SELECT count(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
-     + (SELECT count(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
-     + (SELECT count(Vote) AS Vote FROM `client_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
-     ) AS Vote
-   FROM `user` ORDER BY $order $desc");
-   
-      while ($Line = mysql_fetch_array($ID)) {
-              
-        if (Licence(1)) 
-          $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['user'].'</a>';
-        else 
-          $Name = $Line['user'];
-        
-        echo '<tr><td>'.$Name.'</td>
-        <td>'.$Line['NumberTranslate'].'</td>
-        <td>'.substr($Line['Vote'], 0, 4).'</td>
-        <td>'.$Moderators[$Line['GM']].'</td>
-        <td>'.$Line['LastLogin'].'</td></tr>';
-          
-      }
-          
-  echo '</table>';
-          
-  ShowFooter();      
-?>

trunk/user.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');
+include('includes/global.php');
 
-  // SQL injection hack protection
-  foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($Item);
-  foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($Item);
-
-
-  if (array_key_exists('text', $_POST) and Licence(2)) {
-    $text = $_POST['text'];
-    $email = $_POST['email'];
-    $subject = $_POST['subject'];
-    echo 'email: <b>'.$email.'</b><br />';
-    echo 'předmět: <b>'.$subject.'</b><br />';
-    echo 'text: <b>'.$text.'</b><br />';
+if(array_key_exists('text', $_POST) and Licence(LICENCE_ADMIN)) 
+{
+  $text = $_POST['text'];
+  $email = $_POST['email'];
+  $subject = $_POST['subject'];
+  echo('email: <b>'.$email.'</b><br />');
+  echo('předmět: <b>'.$subject.'</b><br />');
+  echo('text: <b>'.$text.'</b><br />');
     
-    if(@mail($email, $subject, $text, "From: maron2@centrum.cz\nReply-To: maron2@centrum.cz\nX-Mailer: PHP/")){
-    echo 'Zpráva byla odeslána.<br /><br />';
-      }
-    else{ echo "Nepodařilo se odesat E-mail.<br /><br />"; };
-    
+  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 />'); 
+  }
+}
   
-  if (array_key_exists('user', $_GET) and Licence(1)) {
-
-  $LineUser = mysql_fetch_array($Database->SQLCommand("
-  SELECT *, (
-     (SELECT count(*) FROM `quests` WHERE User = ".$_GET['user']." AND User <> 0 AND Complete = 1) + 
-     (SELECT count(*) FROM `npc_text` WHERE User = ".$_GET['user']." AND User <> 0 AND Complete = 1) +
-     (SELECT count(*) FROM `page_text` WHERE User = ".$_GET['user']." AND User <> 0 AND Complete = 1)
-   ) as NumberTranslate, (
-       IFNULL((SELECT sum(Vote) AS Vote FROM `quests` WHERE User = ".$_GET['user']." AND Complete =1),0)
-     + IFNULL((SELECT sum(Vote) AS Vote FROM `page_text` WHERE User = ".$_GET['user']." AND Complete =1),0)
-     + IFNULL((SELECT sum(Vote) AS Vote FROM `npc_text` WHERE User = ".$_GET['user']." AND Complete =1),0)
-     ) / (
-       (SELECT count(Vote) AS Vote FROM `quests` WHERE User = ".$_GET['user']." AND Complete =1)
-     + (SELECT count(Vote) AS Vote FROM `page_text` WHERE User = ".$_GET['user']." AND Complete =1)
-     + (SELECT count(Vote) AS Vote FROM `npc_text` WHERE User = ".$_GET['user']." AND Complete =1)
-     ) AS Vote
-   FROM `user` WHERE ID = ".$_GET['user']));
+if(array_key_exists('user', $_GET) and Licence(LICENCE_MODERATOR)) 
+{
+  
+  $Query = 'SELECT *, (';
+  foreach($TranslationTree as $Group)
+    if($Group['TablePrefix'] != '')
+          $Query .= '(SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE User = '.$_GET['user'].' AND User <> 0 AND Complete = 1) + ';
+  $Query .= '0) as NumberTranslate, (';
+  foreach($TranslationTree as $Group)
+    if($Group['TablePrefix'] != '')
+      $Query .= 'IFNULL((SELECT sum(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE User = '.$_GET['user'].' AND Complete = 1), 0) + ';
+  $Query .= '0) / (';
+  foreach($TranslationTree as $Group)
+    if($Group['TablePrefix'] != '')
+          $Query .= '(SELECT count(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE User = '.$_GET['user'].' AND Complete = 1) +';
+  $Query .= '0) AS Vote FROM `user` WHERE ID = '.$_GET['user'];
+  $LineUser = mysql_fetch_array($Database->SQLCommand($Query));
    
-    echo 'ID: <b>'.$_GET['user'].'</b><br />';
-    echo 'Jméno: <b>'.$LineUser['user'].'</b><br />';
-    echo 'Implicitní jazyk: <b>'.$LineUser['Language'].'</b><br />';
-    echo 'Posledí připojení: <b>'.$LineUser['LastLogin'].'</b><br />';
-    echo 'Posledí IP: <b>'.$LineUser['LastIP'].'</b><br />';
-    echo 'Počet přeložených: <b>'.$LineUser['NumberTranslate'].'</b><br />';
-    echo 'Průměrná známka: <b>'.$LineUser['Vote'].'</b><br />';
-    echo 'Email: <b>'.$LineUser['Email'].'</b><br />';
-    echo '<br>
+  echo('ID: <b>'.$_GET['user'].'</b><br />');
+  echo('Jméno: <b>'.$LineUser['user'].'</b><br />');
+  echo('Výchozí jazyk: <b>'.$LineUser['Language'].'</b><br />');
+  echo('Poslední připojení: <b>'.$LineUser['LastLogin'].'</b><br />');
+  echo('Poslední IP: <b>'.$LineUser['LastIP'].'</b><br />');
+  echo('Počet přeložených: <b>'.$LineUser['NumberTranslate'].'</b><br />');
+  echo('Průměrná známka: <b>'.$LineUser['Vote'].'</b><br />');
+  echo('Email: <b>'.$LineUser['Email'].'</b><br />');
+  echo('<br />
 
 <form action="user.php" method="post">
 Napsat E-mail: 
-<input type="text" name="email" value="'.$LineUser['Email'].'">
+<input type="text" name="email" value="'.$LineUser['Email'].'" />
 Předmět: 
-<input type="text" name="subject" value="Projekt překládání textů WoW">
-<input type="submit" value="Odeslat">
+<input type="text" name="subject" value="Projekt překládání textů WoW" />
+<input type="submit" value="Odeslat" />
 <br>
 <textarea name="text" rows="20" cols="62">
-
-
-
 
 S pozdravem '.$_SESSION['User'].'
@@ -67 +63 @@
 Projekt překládání textů WoW '.$Config['Web']['BaseURL'].'
 </textarea>
-</form>    
-    ';
-    
-  }
+</form>');
+}
 
-  ShowFooter();      
+ShowFooter();      
+
 ?>