Changeset 425 for branches/CombinedTextTables/statistic.php

Timestamp:

Apr 8, 2010, 7:58:16 AM (15 years ago)

Author:

george

Message:

• Upraveno: Doplněny upravené soubory do vývojové větve CombinedTextTables.
• Nastavení ignorování obsahu složek s ikonami u AoWoW.

File:

• branches/CombinedTextTables/statistic.php (modified) (1 diff)

branches/CombinedTextTables/statistic.php

@@ -16 +16 @@
   {
     $Query .= 'SELECT (SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
-    ' SELECT `T`.* FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
-    ' WHERE (`Complete` = 1) AND (`Language`='.$LanguageId.') AND (`VersionStart` <= '.$BuildNumber.') AND (`VersionEnd` >= '.$BuildNumber.')'.
+    ' SELECT `T`.* FROM `Translation` AS `T`'.
+    ' WHERE (`Group` = '.$DbRow['Id'].') AND (`Complete` = 1) AND (`Language`='.$LanguageId.') AND (`VersionStart` <= '.$BuildNumber.') AND (`VersionEnd` >= '.$BuildNumber.')'.
     ') AS `C1`) AS `Translated`, '.
     '(SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
-    ' SELECT `T`.* FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
-    ' WHERE (`Language` = 0) AND (`VersionStart` <= '.$BuildNumber.') AND (`VersionEnd` >= '.$BuildNumber.')'.
+    ' SELECT `T`.* FROM `Translation` AS `T`'.
+    ' WHERE (`Group` = '.$DbRow['Id'].') AND (`Language` = 0) AND (`VersionStart` <= '.$BuildNumber.') AND (`VersionEnd` >= '.$BuildNumber.')'.
     ') AS `C2`) AS `Total`, "'.$DbRow['Name'].'" AS `Name` UNION ';
   }