Changeset 2090 in ExiteCMS for trunk/includes/search/search.forumposts.php

Timestamp:

12/04/08 14:28:48 (3 years ago)

Author:

WanWizard

Message:

rewritten part of the search module logic. Now a session variable is used to store the search parameters, so they don't have to be exposed in the URL anymore
fixed some syntax errors in queries when using MySQL5.x
fixed some layout and locale issues in the search module output

File:

• trunk/includes/search/search.forumposts.php (modified) (3 diffs)

trunk/includes/search/search.forumposts.php

@@ -61 +61 @@
     } else {
 
-        // get the required variables (could be POST or GET vars!)
-        if (isset($stext)) {
-            $stext = stripinput($stext);
+        // make sure the sub search ID is defined
+        if (!isset($sub_search_id)) $sub_search_id = 0;
+
+        // retrieve the search criteria
+        if (isset($_SESSION['search'])) {
+            // from the session store (used when paging through the results)
+            $stext = $_SESSION['search']['stext'];
+            $qtype = $_SESSION['search']['qtype'];
+            $datelimit = $_SESSION['search']['datelimit'];
+            $boolean = $_SESSION['search']['boolean'];
+            $sortby = $_SESSION['search']['sortby'];
+            $order = $_SESSION['search']['order'];
+            $limit = $_SESSION['search']['limit'];
+            $contentfilter_forums = $_SESSION['search']['contentfilter_forums'];
+            $contentfilter_users = $_SESSION['search']['contentfilter_users'];
         } else {
+            // from the search form
             $stext = isset($_POST['stext']) ? stripinput($_POST['stext']) : "";
-        }
-        $stext = str_replace(',', ' ', $stext);
+            $stext = str_replace(',', ' ', $stext);
+            $boolean = isset($_POST['boolean']) ? 0 : 1;
+            $qtype = isset($_POST['qtype']) ? stripinput($_POST['qtype']) : "AND";
+            if ($qtype != "OR" && $qtype != "AND") {
+                $qtype = "AND";
+            }
+            $sortby = isset($_POST['sortby']) ? stripinput($_POST['sortby']) : "score";
+            if (!in_array($sortby, $select_filters)) {
+                $sortby = $select_filters[0];
+            }
+            $order = isset($_POST['order']) && isNum($_POST['order']) ? $_POST['order'] : 1;
+            $limit = isset($_POST['limit']) && isNum($_POST['limit']) ? $_POST['limit'] : 0;
+            $datelimit = isset($_POST['datelimit']) && isNum($_POST['datelimit']) ? $_POST['datelimit'] : 0;
+            // add a forum filter if requested
+            if (isset($_POST['contentfilter_forums']) && isNum($_POST['contentfilter_forums']) && $_POST['contentfilter_forums'] > 0 ) {
+                $contentfilter_forums =  stripinput($_POST['contentfilter_forums']);
+            }
+            // add an author if requested
+            if (isset($_POST['contentfilter_users']) && isNum($_POST['contentfilter_users']) && $_POST['contentfilter_users'] > 0 ) {
+                $contentfilter_users = stripinput($_POST['contentfilter_users']);
+            }
+        }
         $variables['stext'] = $stext;
 
-        // note: qtype not used because of a fulltext query
-        if (!isset($qtype)) {
-            $qtype = isset($_POST['qtype']) ? $_POST['qtype'] : "AND";
-        }
-        if ($qtype != "OR" && $qtype != "AND") {
-            $qtype = "AND";
-        }
-        if (!isset($datelimit)) {
-            $datelimit = isset($_POST['datelimit']) ? $_POST['datelimit'] : 0;
-        }
-        if (!isNum($datelimit)) {
-            $datelimit = 0;
-        }
-        if (!isset($sortby)) {
-            $sortby = isset($_POST['sortby']) ? $_POST['sortby'] : "score";
-        }
-        if (!in_array($sortby, $select_filters)) {
-            $sortby = $select_filters[0];
-        }
-        if (!isset($order)) {
-            $order = isset($_POST['order']) ? $_POST['order'] : 1;
-        }
-        if (!isNum($order)) {
-            $order = 1;
-        }
-        if (!isset($limit)) {
-            $limit = isset($_POST['limit']) ? $_POST['limit'] : 0;
-        }
-        if (!isNum($limit)) {
-            $limit = 0;
-        }
-        if (!isset($boolean)) {
-            $boolean = isset($_POST['boolean']) ? 0 : 1;
-        }
-
-        if (!isset($sub_search_id)) $sub_search_id = 0;
-
-        // construct the page navigator URL to allow paging
-        $variables['pagenav_url'] = FUSION_SELF."?action=search&search_id=".$search_id."&";
-        $variables['pagenav_url'] .= "stext=".$stext."&";
-        $variables['pagenav_url'] .= "boolean=".$boolean."&";
-        $variables['pagenav_url'] .= "datelimit=".$datelimit."&";
-        $variables['pagenav_url'] .= "sortby=".$sortby."&";
-        $variables['pagenav_url'] .= "order=".$order."&";
-        $variables['pagenav_url'] .= "limit=".$limit."&";
+        // store the search parameters in the session record
+        $_SESSION['search'] = array('stext' => $stext,
+                                    'qtype' => $qtype,
+                                    'datelimit' => $datelimit,
+                                    'boolean' => $boolean,
+                                    'sortby' => $sortby,
+                                    'order' => $order,
+                                    'limit' => $limit,
+                                    'contentfilter_forums' => $contentfilter_forums,
+                                    'contentfilter_users' => $contentfilter_users
+                                );
 
         // basis of the query for this search
@@ -172 +171 @@
 
         // add a forum filter if requested
-        if (isset($_POST['contentfilter_forums']) && isNum($_POST['contentfilter_forums']) && $_POST['contentfilter_forums'] > 0 ) {
-            $sql .= " AND tp.forum_id = '".$_POST['contentfilter_forums']."'";
-        }
+        if (!empty($contentfilter_forums)) {
+            $sql .= " AND tp.forum_id = '".$contentfilter_forums."'";
+        }
+
         // add an author if requested
-        if (isset($_POST['contentfilter_users']) && isNum($_POST['contentfilter_users']) && $_POST['contentfilter_users'] > 0 ) {
-            $sql .= " AND (tp.post_author = '".$_POST['contentfilter_users']."'"." OR tp.post_edituser = '".$_POST['contentfilter_users']."')";
+        if (!empty($contentfilter_users)) {
+            $sql .= " AND (tp.post_author = '".$contentfilter_users."'"." OR tp.post_edituser = '".$contentfilter_users."')";
         }
 
@@ -201 +201 @@
         // check if we have a rowstart value
         if (!isset($rowstart)) $rowstart = 0;
-    
+
         // check how many rows this would output
         $rptresult = mysql_query($sql.($limit?" LIMIT $limit":""));