Changeset 34012 for trunk/ippMonitor/def/autocode.php

Timestamp:

Jun 14, 2012, 10:41:55 AM (14 years ago)

Author:

Serge CHASTEL

Message:

Query restriction is now used after the count query

File:

• trunk/ippMonitor/def/autocode.php (modified) (2 diffs)

trunk/ippMonitor/def/autocode.php

@@ -28 +28 @@
 // ** TABLE RESTRICTIONS **
 
-if ($restricted == 0) {
-  if ("$UNRESTRICTED" != "none") {
-    $WHERE = "$WHERE $UNRESTRICTED";
-  }
-}
+// Note: the restriction is now moved AFTER the count query
 
 // Add GROUP BY statements if any
@@ -56 +52 @@
   menu_end();
 }
+
+// Restrict the query if it is necessary
+if ($restricted == 0) {
+  if ("$UNRESTRICTED" != "none") {
+    $WHERE = "$WHERE $UNRESTRICTED";
+  }
+}
+
 // set up the row counter variables
 if ($ID['from']) {