Changeset 525 for trunk/action.php

Timestamp:

Feb 20, 2013, 11:30:49 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Zobrazení porovnání překladů.
• Opraveno: Zobrazení stavu dokončení pro všechny překlady.
• Přidáno: V seznamu překladů přidán sloupec Jazyk.
• Opraveno: Místa, kde s pevným indexem anglického originálu upravena na nastavitelný.

File:

• trunk/action.php (modified) (7 diffs)

trunk/action.php

@@ -5 +5 @@
 function Search()
 {
-  global $System, $TranslationTree;
+  global $System, $TranslationTree, $Config;
   
   if(array_key_exists('search', $_GET)) $Search = $_GET['search'];
@@ -40 +40 @@
   $Output .= '<tr><td><a href="aowow/?search='.$Search.'">Vyhledávací databáze AoWoW</a></td></tr>';
   
-  $DbResult = $System->Database->query('SELECT count(*) FROM `Dictionary` WHERE (`Text` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%") AND `Language` = 0');
+  $DbResult = $System->Database->query('SELECT count(*) FROM `Dictionary` WHERE (`Text` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%") AND `Language` = '.$Config['OriginalLanguage']);
   $Line = $DbResult->fetch_row();
   $Output .= '<tr><td><a href="dictionary.php?search='.$Search.'">Slovníček</a></td><td>'.$Line[0].'</td></tr>';
@@ -50 +50 @@
 function DatabaseKit()
 {
-  global $System, $TranslationTree, $User;
+  global $System, $TranslationTree, $User, $Config;
   
   if($User->Licence(LICENCE_ADMIN)) 
@@ -86 +86 @@
         $Output .= $Table.' ';
     
-        $sql = 'SELECT * FROM '.$Table.' WHERE (`Language` <> 0) AND (';
+        $sql = 'SELECT * FROM '.$Table.' WHERE (`Language` <> '.$Config['OriginalLanguage'].') AND (';
         foreach($Group['Items'] as $Item) 
         {
@@ -128 +128 @@
         $Output .= $Table.' ';
     
-        $sql = 'SELECT `ID`, `Entry` AS EntryTran, `Take`,
-     (SELECT `ID` FROM `'.$Table.'` WHERE `Language = 0 AND `Entry` = `EntryTran` LIMIT 1) AS `IDOrig`
-      FROM `'.$Table.'` AS `Tran` WHERE (`Language` <> 0) AND ((`Take` = 0) OR (`ID` = `Take`) OR NOT EXISTS(SELECT 1 FROM `'.$Table.'` WHERE `ID` = `Tran`.`Take`))';
+        $sql = 'SELECT `ID`, `Entry` AS EntryTran, `Take`, '.
+       '(SELECT `ID` FROM `'.$Table.'` WHERE (`Language = '.$Config['OriginalLanguage'].') AND (`Entry` = `EntryTran`) LIMIT 1) AS `IDOrig` '.
+       'FROM `'.$Table.'` AS `Tran` WHERE (`Language` <> '.$Config['OriginalLanguage'].') AND ((`Take` IS NULL) OR '.
+       '(`ID` = `Take`) OR NOT EXISTS(SELECT 1 FROM `'.$Table.'` WHERE `ID` = `Tran`.`Take`))';
       
         $DbResult = $System->Database->query($sql);
@@ -158 +159 @@
       {      
         $Output .= $Table.' ';
-        $sql = 'SELECT `gs_orig`.`ID`, `gs_tran`.`Entry`, `gs_tran`.`ShortCut` AS `ShortCut_tran`, `gs_orig`.`ShortCut`  AS `ShortCut_orig` FROM `'.$Table.'` AS `gs_tran` JOIN `'.$Table.'` AS `gs_orig` ON `gs_orig`.`Entry` = `gs_tran`.`Entry` WHERE `gs_tran`.`Language` <> 0 AND `gs_tran`.`ShortCut` <> `gs_orig`.`ShortCut`';     
+        $sql = 'SELECT `gs_orig`.`ID`, `gs_tran`.`Entry`, `gs_tran`.`ShortCut` AS `ShortCut_tran`, '.
+          '`gs_orig`.`ShortCut`  AS `ShortCut_orig` FROM `'.$Table.'` AS `gs_tran` '.
+          'JOIN `'.$Table.'` AS `gs_orig` ON `gs_orig`.`Entry` = `gs_tran`.`Entry` WHERE '.
+          '`gs_tran`.`Language` <> '.$Config['OriginalLanguage'].' AND `gs_tran`.`ShortCut` <> `gs_orig`.`ShortCut`';     
         $DbResult = $System->Database->query($sql);
         while ($Line = $DbResult->fetch_assoc()) 
@@ -181 +185 @@
 function Delete()
 {
-  global $System, $User;
+  global $System, $User, $Config;
   
   if($User->Licence(LICENCE_MODERATOR)) 
   {
     $TextID = $_GET['ID'];       
-    $System->Database->query('DELETE FROM `'.$Table.'` WHERE `ID` = '.$TextID.' AND `Language` <> 0');
+    $System->Database->query('DELETE FROM `'.$Table.'` WHERE `ID` = '.$TextID.' AND `Language` <> '.$Config['OriginalLanguage']);
     $Output = ShowMessage('Překlad byl smazán.');   
     WriteLog('Překlad byl smazán! <a href="form.php?group='.$GroupID.'&amp;ID='.$TextID.'">'.$TextID.'</a>', LOG_TYPE_MODERATOR);