Changeset 108 for trunk/addon/make.php

Timestamp:

Feb 18, 2009, 8:33:41 PM (16 years ago)

Author:

george

Message:

• Upraveno: Zobrazovat v ladících běhových informacích také povolené maximální hodnoty paměti a doby běhu.

File:

• trunk/addon/make.php (modified) (3 diffs)

trunk/addon/make.php

@@ -90 +90 @@
   $SelectedUsers = substr($SelectedUsers, 1);
 
-  if($SelectedUsers == '') $WhereUsers = 1; 
-    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
+  if($SelectedUsers == '')
+  {
+        $WhereUsers = 1;
+        $OrderByUserList = '';
+  } else
+  {
+        $WhereUsers = '(User IN ('.$SelectedUsers.'))';
+        $OrderByUserList = ' ORDER BY FIELD(User, '.$SelectedUsers.')';
+  }
         
   foreach($TranslationTree as $Group) 
@@ -110 +117 @@
 
       $Buffer = 'CZWOW_'.$Column['AddonFileName'].
-            '_count='.$FileIndex.'; CZWOW_'.$Column['AddonFileName'].'_'.$FileIndex.'={';         
+            '_count='.$FileIndex.'; CZWOW_'.$Column['AddonFileName'].'_'.$FileIndex.'={';
     
-      $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
+      $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.$OrderByUserList.') AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
       $DbResult = $Database->SQLCommand($Query);
       while($Line = mysql_fetch_array($DbResult)) 
@@ -156 +163 @@
   $SelectedUsers = substr($SelectedUsers, 1);
 
-  if($SelectedUsers == '') $WhereUsers = 1; 
-    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
+  if($SelectedUsers == '')
+  {
+        $WhereUsers = 1;
+        $OrderByUserList = '';
+  } else
+  {
+        $WhereUsers = '(User IN ('.$SelectedUsers.'))';
+        $OrderByUserList = ' ORDER BY FIELD(User, '.$SelectedUsers.')';
+  }
         
   $Buffer = "local f=function(name, en, cz) CzWoW_interface[name]=cz; CzWoW_interface_entoname[en]=name; end; CzWoW_interface={ };CzWoW_interface_entoname={ };\n";
   $Group = $TranslationTree[9]; // client table
   $Column['Column'] = 'Text';
-  $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original, T3.id_text FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
+  $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original, T3.id_text FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.$OrderByUserList.') AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
   $DbResult = $Database->SQLCommand($Query);
   while($Line = mysql_fetch_array($DbResult))