Changeset 544 for trunk

Timestamp:

Jun 17, 2013, 10:43:16 PM (11 years ago)

Author:

chronos

Message:

• Optimalizace: SQL dotaz pro výpis tabulky překladů.

Location:

trunk

Files:

• TranslationList.php (modified) (1 diff)
• form.php (modified) (1 diff)

trunk/TranslationList.php

@@ -197 +197 @@
   $Query = 'SELECT `T`.`ID`, `T`.`Entry`, `T`.`VersionStart`, `T`.`VersionEnd`, '.
     '`T`.`'.$TranslationTree[$Filter['Group']]['Items'][0]['Column'].'`, '.
-    '(SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `T`.`User`) AS `UserName`, '.
-    '(SELECT `User`.`Id` FROM `User` WHERE `User`.`ID` = `T`.`User`) AS `UserId`, '.
-    '(SELECT `Language`.`Name` FROM `Language` WHERE `Language`.`ID` = `T`.`Language`) AS `LanguageName`, '.
-    '(SELECT `ClientVersion`.`Version` FROM `ClientVersion` WHERE `ClientVersion`.`BuildNumber` = `T`.`VersionStart`) AS `VersionStartText`, '.
-    '(SELECT `ClientVersion`.`Version` FROM `ClientVersion` WHERE `ClientVersion`.`BuildNumber` = `T`.`VersionEnd`) AS `VersionEndText` '.
-    'FROM `'.$Table.'` AS `T` WHERE 1 '.$Filter['SQL'];
+    '`User`.`Name` AS `UserName`, `User`.`ID` AS `UserId`, '.
+    '`Language`.`Name` AS `LanguageName`, `TS`.`Version` AS `VersionStartText`, `TE`.`Version` AS `VersionEndText` '.
+    'FROM `'.$Table.'` AS `T` '.
+    'LEFT JOIN `User` ON `User`.`ID` = `T`.`User` '.
+    'LEFT JOIN `Language` ON `Language`.`ID` = `T`.`Language` '.
+    'LEFT JOIN `ClientVersion` AS `TS` ON `TS`.`BuildNumber` = `T`.`VersionStart` '.
+    'LEFT JOIN `ClientVersion` AS `TE` ON `TE`.`BuildNumber` = `T`.`VersionEnd` '.
+    'WHERE 1 '.$Filter['SQL'];
   
   // Get total item count

trunk/form.php

@@ -78 +78 @@
 
   $Output .= '<br />'.
-    'Verze: <b>'.GetVersionWOW($Line['VersionStart']).' - '.GetVersionWOW($Line['VersionEnd'].'</b>').
+    'Verze: <b>'.GetVersionWOW($Line['VersionStart']).' - '.GetVersionWOW($Line['VersionEnd']).'</b>'.
     '<br />';