Changeset 102 for trunk

Timestamp:

Feb 18, 2009, 7:47:12 AM (16 years ago)

Author:

george

Message:

• Upraveno: Optimalizace načítání seznamu překladatelů na stránce Stahování.

File:

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

trunk/download.php

@@ -3 +3 @@
 session_start();
 
-if(!array_key_exists('ExportSetting', $_SESSION)) 
-  $_SESSION['ExportSetting'] = $_COOKIE['ExportSetting'];
+if(!array_key_exists('ExportSetting', $_SESSION))
+  if(array_key_exists('ExportSetting', $_COOKIE)) 
+    $_SESSION['ExportSetting'] = $_COOKIE['ExportSetting'];
+        else $_SESSION['ExportSetting'] = array();
   
 setcookie('ExportSetting', $_SESSION['ExportSetting']);
@@ -266 +268 @@
 </script>');
     echo('<form name="ListUser" action="?action=parameters" method="post">');
-    $Query = 'SELECT T.user, T.ID, T.TranslatedCount FROM (SELECT user, ID, (';
+
+    $Columns = '';
+    $Joins = '';
     foreach($TranslationTree as $Group)
       if($Group['TablePrefix'] != '')
-        $Query .= '(SELECT COUNT(*) FROM '.$Group['TablePrefix'].' WHERE (user = user.ID) AND (Complete = 1) AND (Language <> 0)) + ';
-    $Query .= ' 0) AS TranslatedCount FROM `user` ORDER BY user) AS T WHERE T.TranslatedCount > 0 ORDER BY T.TranslatedCount DESC';
-    //echo($Query);
-        $ID = $Database->SQLCommand($Query);
-        
+      {
+            $Columns .= 'COALESCE(T'.$Group['Id'].'.Count, 0) + ';
+        $Joins .= ' LEFT JOIN (SELECT User, COUNT(User) as Count FROM `'.$Group['TablePrefix'].'` WHERE (Complete = 1) AND (Language <> 0) GROUP BY User) as T'.$Group['Id'].' ON user.ID=T'.$Group['Id'].'.User';
+      }
+
+    $Query = 'SELECT T.ID, T.TranslatedCount, T.user FROM (SELECT user.ID, user.user, ('.substr($Columns, 0, -3).') as TranslatedCount FROM `user`'.$Joins.') AS T WHERE T.TranslatedCount > 0 ORDER BY T.TranslatedCount DESC';
+    $ID = $Database->SQLCommand($Query);
+
         // Rebuild user order list
         $Users = array();
-        while($Line = mysql_fetch_array($ID)) $Users[$Line['ID']] = $Line;
+        while($Line = mysql_fetch_assoc($ID)) $Users[$Line['ID']] = $Line;
         $UsersOrder = explode(',', $ExportSetting['users-order']);
         foreach($Users as $User)