Changeset 214 for trunk/TranslationList.php

Timestamp:

Jun 22, 2009, 9:22:20 PM (15 years ago)

Author:

maron

Message:

Podpora více verzí textů, zobrazení verze ve formuláři překládání, úprava ukládání aby se dala uložit u jednoho uživatele více verzí, aby se ukládaly čísla verzí podle předlohy, úprava seznamu nepřeložených aby se zobrazovali pouze nejnovější nepřeložené texty, oprava generování souboru addonu pagebook_1, oprava logu a přidání položky pro import

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)');
+    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry) 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)) ', $_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']).'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'notran');
 } else
 if($Action == 'nocomplete') 
@@ -141 +141 @@
   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))');
+    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']).'"');
 
   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))', $_SESSION['limitx'].','.$_SESSION['limity'], 'nocomplete');
+   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');
 } else
 if($Action == 'Translate')