Changeset 543

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ů.

Location:

trunk

Files:

• TranslationList.php (modified) (2 diffs)
• admin/UpdateTrace.php (modified) (2 diffs)
• img_level.php (modified) (2 diffs)
• includes/Version.php (modified) (1 diff)

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

trunk/admin/UpdateTrace.php

@@ -2562 +2562 @@
 }
 
+function UpdateTo543($Manager)
+{ 
+  $Manager->Execute('ALTER TABLE `Group` ADD INDEX ( `Name` )');
+}
+
 $Updates = array(
         498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
@@ -2568 +2573 @@
         524 => array('Revision' => 537, 'Function' => 'UpdateTo537'),
         537 => array('Revision' => 539, 'Function' => 'UpdateTo539'),
+        539 => array('Revision' => 543, 'Function' => 'UpdateTo543'),
 );
 

trunk/img_level.php

@@ -116 +116 @@
       if($Group['TablePrefix'] != '')
       {
-        $Count = '(SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`Language` <> '.$Config['OriginalLanguage'].') AND (`User`='.$LineUser['ID'].'))';
+        $Count = '(SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`Language` <> '.
+          $Config['OriginalLanguage'].') AND (`User`='.$LineUser['ID'].'))';
         $TranslatedCount .= 'COALESCE('.$Count.', 0) + ';
       }
@@ -128 +129 @@
 
   // Main code for translation teams
-  $DbResult = $System->Database->query('SELECT `ID`, `Name`, (SELECT AVG(`XP`) FROM `User` WHERE `Team` = `Team`.`Id`) AS `Average` FROM `Team` WHERE `ID` IN (SELECT `Team` FROM `User` WHERE `NeedUpdate` = 1)');
+  $DbResult = $System->Database->query('SELECT `ID`, `Name`, (SELECT AVG(`XP`) FROM `User` WHERE `Team` = `Team`.`Id`) AS `Average` '.
+    'FROM `Team` WHERE `ID` IN (SELECT `Team` FROM `User` WHERE `NeedUpdate` = 1)');
   while($LineTeam = $DbResult->fetch_array()) 
   {

trunk/includes/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 542; // Subversion revision
-$DatabaseRevision = 539; // Database structure revision 
+$Revision = 543; // Subversion revision
+$DatabaseRevision = 543; // Database structure revision 
 $ReleaseTime = '2013-06-17';