Changeset 543 for trunk/img_level.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/img_level.php (modified) (2 diffs)

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()) 
   {