= $datecutoff"; $query = mysql_db_query($database, $sql) or die(geterrdesc($sql)); $count = mysql_num_rows($query); $pages = $count / $searchperpage; $pages = ceil($pages); if (1 < $pagenumber) { if (1 > ($pagenumber - $pageincr)) { $back = $pagenumber + (1 - $pagenumber); } else { $back = $pagenumber - $pageincr; } } else { $back = $pagenumber; } if ($pages >= $pagenumber) { if ($pages < ($pagenumber + $pageincr)) { $forward = $pagenumber + ($pages - $pagenumber); } else { $forward = $pagenumber + $pageincr; } } else { $forward = $pagenumber; } if ($pages >= $pagenumber) { for ($i = $back; $i <= $forward; $i++) { if ($i == $pagenumber) { $fwd_back .= " $i "; } else { $fwd_back .= " $i "; } } if ($pages != $pagenumber) { $fwd_back = $fwd_back . " > Last Page "; } } $pages = "Pages: $fwd_back"; $searchstart =($pagenumber-1)*$searchperpage; // Start of the main listings $navigation = "Index > Active Threads"; $newline = template("header.html"); eval("echo stripslashes(\"$newline\");"); echo "

"; $sql = "SELECT * FROM thread WHERE lastpost >= $datecutoff ORDER BY lastpost DESC LIMIT $searchstart, $searchperpage"; $query = mysql_db_query($database, $sql) or die(geterrdesc($sql)); while ($search_results = mysql_fetch_array($query)) { $sql = "SELECT title,private,FID FROM forum WHERE FID='$search_results[FID]'"; $query_title = mysql_db_query($database, $sql) or die(geterrdesc($sql)); $forum = mysql_fetch_array($query_title); if ($forum[private]==0 || $status=="Administrator") { $lastreplydate = date("F d, Y",$search_results[lastpost]+($timeoffset*3600)); $lastreplytime = date("h:i A",$search_results[lastpost]+($timeoffset*3600)); $newline = template("search_result_threads.html"); eval("echo stripslashes(\"$newline\");"); } } echo " Thread Author Last Posted Forum All times are ET (US). $pages

"; $newline = template("footer.html"); eval("echo stripslashes(\"$newline\");"); } elseif ($action == "search") { $query = "SELECT * FROM thread WHERE TID=TID "; if ($FID) { $query .= "AND FID=$FID "; } if ($date) { $date = time()-($date * 86400); $query .= "AND dateline >= $date "; } if ($UserName) { $query .= "AND postusername='$UserName' "; } if ($q) { // Adds the boolean SQL structure statement $query .= "AND " . b_parse($q, "threadindex"); $query .= " or "; $query .= b_parse($q, "subjectindex"); } $sql = $query; $query_search = mysql_db_query($database, $sql) or die(geterrdesc($sql)); $count = mysql_num_rows($query_search); $pages = $count / $searchperpage; $pages = ceil($pages); if (1 < $pagenumber) { if (1 > ($pagenumber - $pageincr)) { $back = $pagenumber + (1 - $pagenumber); } else { $back = $pagenumber - $pageincr; } } else { $back = $pagenumber; } if ($pages >= $pagenumber) { if ($pages < ($pagenumber + $pageincr)) { $forward = $pagenumber + ($pages - $pagenumber); } else { $forward = $pagenumber + $pageincr; } } else { $forward = $pagenumber; } if ($pages >= $pagenumber) { for ($i = $back; $i <= $forward; $i++) { if ($i == $pagenumber) { $fwd_back .= " $i "; } else { $fwd_back .= " $i "; } } if ($pages != $pagenumber) { $fwd_back = $fwd_back . " > Last Page "; } } $pages = "Pages: $fwd_back"; $searchstart =($pagenumber-1)*$searchperpage; // Start of the main listings $sql = $query . " ORDER BY lastpost DESC LIMIT $searchstart, $searchperpage"; $query = mysql_db_query($database, $sql) or die(geterrdesc($sql)); $newline = template("header.html"); eval("echo stripslashes(\"$newline\");"); echo "

"; while ($search_results = mysql_fetch_array($query)) { $sql = "SELECT title,private,FID FROM forum WHERE FID='$search_results[FID]'"; $query_forum = mysql_db_query($database, $sql) or die(geterrdesc($sql)); $forum = mysql_fetch_array($query_forum); if ($forum[private]==0 || $status=="Administrator") { $lastreplydate = date("F d, Y",$search_results[lastpost]+($timeoffset*3600)); $lastreplytime = date("h:i A",$search_results[lastpost]+($timeoffset*3600)); $newline = template("search_result_threads.html"); eval("echo stripslashes(\"$newline\");"); } } echo " Thread Author Last Posted Forum All times are ET (US). $pages

"; $newline = template("footer.html"); eval("echo stripslashes(\"$newline\");"); } else { $sql = "SELECT CID, category, displayorder FROM category ORDER BY displayorder"; $query_cat = mysql_db_query($database, $sql) or die(geterrdesc($sql)); $jump = " Select All Forums "; while ($category = mysql_fetch_array($query_cat)) { $jump .= ""; $jump .= "Category: $category[category]\n"; $jump .= "--------------------\n"; $sql = "SELECT * FROM forum WHERE category=$category[CID] AND active=1 ORDER BY displayorder"; $query_forum = mysql_db_query($database, $sql) or die(geterrdesc($sql)); while ($forum = mysql_fetch_array($query_forum) ) { $jump .= "$forum[title]\n"; } } $jump .= ""; $navigation = "Index > Search Form"; $newline = template("header.html"); eval("echo stripslashes(\"$newline\");"); $newline = template("search_form.html"); eval("echo stripslashes(\"$newline\");"); $newline = template("footer.html"); eval("echo stripslashes(\"$newline\");"); } exit; ?>