Changeset 221

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ů

Location:

trunk

Files:

• TranslationList.php (modified) (2 diffs)
• img_statistic.php (modified) (1 diff)

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') 

trunk/img_statistic.php

@@ -24 +24 @@
 } else $user_sql = '';
 
-$where = ' (Language <> 0) AND (Complete = 1) '.$team.$language.$user_sql;
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT max(VersionEnd) FROM '.$Group['TablePrefix']));
+$BuildNumber_max = $ID[0];
+
+$where = 'VersionEnd = '.$BuildNumber_max.' AND (Language <> 0) AND (Complete = 1) '.$team.$language.$user_sql;
 $ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE '.$where));
 $NumberTranslate = $ID[0];
   
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Group['TablePrefix'].' WHERE (Language = 0)'));
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE VersionEnd = '.$BuildNumber_max.' AND (Language = 0)'));
 $NumberAJ = $ID[0];