Changeset 321 for trunk/TranslationList.php

Timestamp:

Feb 14, 2010, 1:00:53 PM (15 years ago)

Author:

george

Message:

• Opraveno: Zobrazování seznamu nepřeložených textů. Zobrazí se všechny anglické originály, které nemají překlad ve stejné verzi.

File:

• trunk/TranslationList.php (modified) (4 diffs)

trunk/TranslationList.php

@@ -45 +45 @@
 function Nontranslated()
 {
-  global $GroupId, $Table, $BuildNumber_max;
-  
-  echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
-        <a title="Zde můžete začít překládat" href="?group='.$GroupId.'&amp;action=selection">Nepřeložené texty</a> - > 
-        <strong>Vypsání nepřeložených textů s limitem na stránku</strong><br /><br />');
-
-  WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0) AND
-    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'")');
+  global $GroupId, $Table;
+  
+  echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> -> '.
+  '<a title="Zde můžete začít překládat" href="?group='.$GroupId.'&amp;action=selection">Nepřeložené texty</a> - > '.
+  '<strong>Vypsání nepřeložených textů s limitem na stránku</strong><br /><br />');
+
+  WriteQuests('SELECT * FROM `'.$Table.'` AS `items` WHERE (`items`.`Language` = 0) AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `sub` WHERE (`sub`.`Language` <> 0) AND (`sub`.`entry` = `items`.`entry`)  )');
 }
 
@@ -62 +61 @@
 
  //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1)
-  $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT Name FROM connexion WHERE `Id` = '.$_SESSION['connexion_id']));
+  $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT `Name` FROM `connexion` WHERE `Id` = '.$_SESSION['connexion_id']));
     echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
         <a title="Zde je seznam souvislostí" href="?group='.$GroupId.'&amp;action=connexion">Souvislosti</a> - > 
         <strong>Vypsání souvislostí ze skupiny '.$Line['Name'].'</strong><br /><br />');
 
-   WriteQuests('SELECT *, (SELECT sub.User FROM '.$Table.' as sub WHERE sub.entry  = '.$Table.'.entry AND Language <> 0 LIMIT 1) as UserID, (SELECT user.user FROM user WHERE user.id = UserID) AS UserName FROM '.$Table.' WHERE Language = 0 AND entry IN(SELECT entry FROM connexion_item WHERE connexion = '.$_SESSION['connexion_id'].') AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'"');
+   WriteQuests('SELECT *, (SELECT `sub`.`User` FROM `'.$Table.'` AS `sub` WHERE (`sub`.`entry` = `'.$Table.'`.`entry`) AND (`Language` <> 0) LIMIT 1) AS `UserID`, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `UserID`) AS `UserName` FROM `'.$Table.'` WHERE (`Language` = 0) AND (`entry` IN(SELECT `entry` FROM `connexion_item` WHERE `connexion` = '.$_SESSION['connexion_id'].') AND `VersionEnd` = "'.$BuildNumber_max.'" AND `VersionEnd` = "'.$BuildNumber_max.'"');
 }
 
@@ -80 +79 @@
   echo('<table class="BaseTable"><tr><th>Pořadové číslo</th><th>Název</th>');
   echo('</tr>');
-  $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE  `Group` = '.$GroupId);        
+  $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE `Group` = '.$GroupId);        
   while($Line = mysql_fetch_assoc($ID)) 
   {
@@ -342 +341 @@
 if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';
 
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT max(VersionEnd) FROM '.$TranslationTree[$GroupId]['TablePrefix']));
+$DbResult = $Database->SQLCommand('SELECT MAX(`VersionEnd`) FROM `'.$TranslationTree[$GroupId]['TablePrefix'].'`');
+$ID = mysql_fetch_row($DbResult);
 $BuildNumber_max = $ID[0];