Changeset 664

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.

Location:

trunk

Files:

• Application/Version.php (modified) (1 diff)
• Modules/IS/IS.php (modified) (2 diffs)

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 663; // Subversion revision
+$Revision = 664; // Subversion revision
 $DatabaseRevision = 662; // SQL structure revision
-$ReleaseTime = strtotime('2014-06-03');
+$ReleaseTime = strtotime('2014-06-13');

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;