Changeset 664 for trunk/Modules/IS/IS.php

Timestamp:

Jun 13, 2014, 8:02:40 PM (11 years ago)

Author:

chronos

Message:

• Změněno: Zjednodušen obecný SQL dotaz pro zobrazení tabulek v modulu IS.

File:

• trunk/Modules/IS/IS.php (modified) (2 diffs)

trunk/Modules/IS/IS.php

@@ -386 +386 @@
     if($Filter != '')
     {
-      $Query = 'SELECT COUNT(*) FROM (SELECT '.$Columns.' FROM '.$SourceTable.') AS `TS` '.$Filter;
+      $Query = 'SELECT COUNT(*) FROM '.$SourceTable.' '.$Filter;
       $DbResult = $this->Database->query($Query);
       $DbRow = $DbResult->fetch_row();
@@ -423 +423 @@
 
     // Load and show items
-    $Query = 'SELECT * FROM (SELECT '.$Columns.' FROM '.$SourceTable.') AS `TS` '.
+    $Query = 'SELECT '.$Columns.' FROM '.$SourceTable.' '.
       $Filter.' '.$Order['SQL'].$PageList['SQLLimit'];
     $VisibleItemCount = 0;