Changeset 101 for trunk/userlist.php

Timestamp:

Feb 18, 2009, 7:32:52 AM (16 years ago)

Author:

george

Message:

• Upraveno: Zrychleno velmi pomalé načítání seznamu uživatelů z databáze.

File:

• trunk/userlist.php (modified) (1 diff)

trunk/userlist.php

@@ -33 +33 @@
   <th><a href="?Order=LastLogin&amp;Desc='.$desc.'">Poslední připojení</a></th></tr>');
 
-$Query = 'SELECT ID,user, LastLogin, GM, (';
+$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 NumberTranslate FROM `user` ORDER BY '.$order.' '.$desc.' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];
+  {
+        $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 ID, user.user, LastLogin, GM, ('.substr($Columns, 0, -3).') as NumberTranslate FROM `user`'.$Joins.' ORDER BY '.$order.' '.$desc.' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];
+
 $ID = $Database->SQLCommand($Query);
-while($Line = mysql_fetch_array($ID)) 
+while($Line = mysql_fetch_assoc($ID)) 
 {
   if(Licence(LICENCE_MODERATOR))