Changeset 543 for trunk/TranslationList.php

Timestamp:

Jun 17, 2013, 11:19:05 AM (11 years ago)

Author:

chronos

Message:

• Opraveno: Přidán index u názvu uživatele.
• Upraveno: Optimalizace načítání sloupců verze klienta v seznamu překladů.

File:

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

trunk/TranslationList.php

@@ -199 +199 @@
     '(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 `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'];
   
@@ -226 +228 @@
     $Output .= '<tr><td><a href="form.php?group='.$Filter['Group'].'&amp;ID='.$Line['ID'].'">'.$Line['ID'].'</a></td><td>'.$Line['Entry'].'</td>'.
       '<td>'.htmlspecialchars($Line[$TranslationTree[$Filter['Group']]['Items'][0]['Column']]).'</td>'.
-      '<td>'.GetVersionWOW($Line['VersionStart']).'-'.GetVersionWOW($Line['VersionEnd']).'</td>'.
+      '<td>'.$Line['VersionStartText'].'-'.$Line['VersionEndText'].'</td>'.
       '<td>'.$Line['LanguageName'].'</td>'.
       '<td><a href="user.php?user='.$Line['UserId'].'">'.$Line['UserName'].'</a></td>';