Changeset 221 for trunk/TranslationList.php

Timestamp:

Jul 1, 2009, 10:16:41 PM (15 years ago)

Author:

maron

Message:

Oprava zobrazování statistiky v obrázku, Oprava seznamu nepřeložených textů

File:

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

trunk/TranslationList.php

@@ -128 +128 @@
 
   WritePages('?group='.$GroupId.'&action=notran', '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 = "'.GetBuildNumber($Config['Web']['GameVersion']).'"');
+    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'")  AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'"');
 
   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 = "'.GetBuildNumber($Config['Web']['GameVersion']).'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'notran');
+    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry)  AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'") AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'notran');
 } else
 if($Action == 'nocomplete') 
@@ -140 +140 @@
 
   WritePages('?group='.$GroupId.'&amp;action=notran', '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 (sub.Complete = 1)) AND
-    EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry  AND (sub.Complete = 0)) AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'"');
+    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry)  AND (sub.Complete = 1) AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'") AND
+    EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry  AND (sub.Complete = 0) AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'") AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'"');
 
   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 (sub.Complete = 1)) AND
-   EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry)  AND (sub.Complete = 0)) AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'nocomplete');
+    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry)  AND (sub.Complete = 1) AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'") AND
+   EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry)  AND (sub.Complete = 0) AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'") AND VersionEnd = "'.GetBuildNumber($Config['Web']['GameVersion']).'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'nocomplete');
 } else
 if($Action == 'Translate')