Changeset 353 for trunk/export/index.php

Timestamp:

Mar 3, 2010, 1:42:04 PM (14 years ago)

Author:

george

Message:

• Opraveno: U exportů v tabulce výpisu překladatelů také používat přímo sloupec počtu překladů TranslatedCount.
• Opraveno: Nemazat překladatele, kteří mají vytvořen nějaký export.

File:

• trunk/export/index.php (modified) (1 diff)

trunk/export/index.php

@@ -178 +178 @@
     else $InitialOrder = '';
 
-  $Columns = '';
-  $Joins = '';
-  foreach($TranslationTree as $Group)
-    if($Group['TablePrefix'] != '')
-    {
-      $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 (@I := @I + 1) AS Sequence2, TT.* FROM (SELECT ExportUser.Sequence, T.ID, T.TranslatedCount, T.user, T.XP FROM (SELECT user.ID, user.user, user.XP, ('.substr($Columns, 0, -3).') as TranslatedCount FROM `user`'.$Joins.') AS T';
+  $Query = 'SELECT (@I := @I + 1) AS Sequence2, TT.* FROM (SELECT ExportUser.Sequence, T.ID, T.TranslatedCount, T.user, T.XP FROM (SELECT user.ID, user.user, user.XP, TranslatedCount FROM `user`) AS T';
   $Query .=' LEFT JOIN ExportUser ON ExportUser.Export = '.$_GET['ExportId'].' AND ExportUser.User=T.ID';
   $Query .=' WHERE T.TranslatedCount > 0 ORDER BY COALESCE(ExportUser.Sequence, 100000000)'.$InitialOrder.') AS TT';