search.php

日程 BosDates v4.5 Copyright ?2004-2005 BosDev

<?php

//////////////////////////// COPYRIGHT NOTICE ////////////////////////////////////
// This script is part of BosClassifieds, a software application by BosDev, Inc //
// Use of any kind of part or all of this script or modification of this        //
// script requires a license from BosDev, Inc. Use or modification of           //
// this script without a license constitutes Software Piracy and will           //
// result in legal action from BosDev, Inc.  All rights reserved.               //
//            http://www.bosdev.com      [e-mail]                       //
//                                                                              //
//           BosClassifieds Copyright 2004, BosDev, Inc.                        //
//////////////////////////////////////////////////////////////////////////////////

//Connect to database & get functions loaded
include("connect.php");
include("functions.php");

//Set globals
global $SystemOptions,$cat_id;
$result = query("SELECT * FROM {$class_prefix}system",$class_link);
$SystemOptions = mysql_fetch_array($result);

//Set language
include("{$insPath}languages/{$SystemOptions['language']}.php");

//Include integration file
include("{$insPath}integration/{$SystemOptions['integration']}.php");

$from = "search";
$title_extra = "{$Languages['search']['fromtitle']} | ";
include("header.php");

//Add viewer to statistics
recordUser("s");

//Load ad types
$adTypes = array();
$result = query("SELECT type_id,type_title FROM {$class_prefix}ad_types",$class_link);
while(list($typeID,$typeTitle) = mysql_fetch_row($result)) {
	$typeTitle = stripslashes($typeTitle);
	$adTypes[$typeID] = $typeTitle;
	$adTypesBox .= "<option value=\"$typeID\">$typeTitle</option>";
	}

//Setup our search, depending upon what type
if(isset($criteria)) {
	//Standard search
	$criteria = protect($criteria);
	$queryCriteria = "(ad_title LIKE '%$criteria%' OR ad_description LIKE '%$criteria%' OR ad_optional_1 LIKE '%$criteria%' OR ad_optional_2 LIKE '%$criteria%' OR ad_optional_3 LIKE '%$criteria%' OR ad_optional_4 LIKE '%$criteria%' OR ad_optional_5 LIKE '%$criteria%' OR ad_type_optional1 LIKE '%$criteria%' OR ad_type_optional2 LIKE '%$criteria%' OR ad_type_optional3 LIKE '%$criteria%' OR ad_type_optional4 LIKE '%$criteria%' OR ad_type_optional5 LIKE '%$criteria%' OR ad_type_optional6 LIKE '%$criteria%' OR ad_type_optional7 LIKE '%$criteria%' OR ad_type_optional8 LIKE '%$criteria%' OR ad_type_optional9 LIKE '%$criteria%' OR ad_type_optional10 LIKE '%$criteria%')";
	$sortLink = "criteria=$criteria";
	}

if(isset($user)) {
	//Search by user
	$user = intval(protect($user));
	$queryCriteria = "ad_user_id=$user";
	$sortLink = "user=$user";
	}

if(isset($city)) {
	//Search by city
	$city = protect($city);
	$queryCriteria = "ad_city='$city'";
	$sortLink = "city=$city";
	}

if(isset($state)) {
	//Search by state
	$state = protect($state);
	$queryCriteria = "ad_state='$state'";
	$sortLink = "state=$state";
	}

if(isset($postal)) {
	//Search by postal
	$postal = protect($postal);
	$queryCriteria = "ad_postal='$postal'";
	$sortLink = "postal=$postal";
	}

if(isset($country)) {
	//Search by country
	$country = protect($country);
	$queryCriteria = "ad_country='$country'";
	$sortLink = "country=$country";
	}

if(isset($fromAdv)) {
	//Search with advanced options
	if($fromAdv != "1") {
		$fromAdv = unserialize(urldecode(stripslashes($fromAdv)));
		$titleCriteria = $fromAdv[0];
		$titleCriteriaCond = $fromAdv[1];
		$descCriteria = $fromAdv[2];
		$descCriteriaCond = $fromAdv[3];
		$miscCriteria = $fromAdv[4];
		$miscCriteriaCond = $fromAdv[5];
		$locCriteria = $fromAdv[6];
		$locCriteriaCond = $fromAdv[7];
		$adType = $fromAdv[8];
		$adDate = $fromAdv[9];
		$adCategory = $fromAdv[10];
		}

	$titleCriteria = protect(str_replace(" ","%",trim($titleCriteria)));
	if(strstr($titleCriteria,"%")) { $title_array = explode("%",$titleCriteria); }
		else { $title_array = array("$titleCriteria"); }

	$descCriteria = protect(str_replace(" ","%",trim($descCriteria)));
	if(strstr($descCriteria,"%")) { $desc_array = explode("%",$descCriteria); }
		else { $desc_array = array("$descCriteria"); }

	$miscCriteria = protect(str_replace(" ","%",trim($miscCriteria)));
	if(strstr($miscCriteria,"%")) { $misc_array = explode("%",$miscCriteria); }
		else { $misc_array = array("$miscCriteria"); }

	$locCriteria = protect(str_replace(" ","%",trim($locCriteria)));
	if(strstr($locCriteria,"%")) { $loc_array = explode("%",$locCriteria); }
		else { $loc_array = array("$locCriteria"); }

	$adType = intval(protect($adType));
	$adCategory = intval(protect($adCategory));
	$adDate = intval(protect($adDate));

	$adDate = date("Y-m-d",time()-(86400*$adDate));

	//Build Query Conditions
	if($title_array[0] != "") {
		while(list(,$val) = each($title_array)) {
			if($title_query != "") { $title_query .= " $titleCriteriaCond "; }
			$title_query .= "ad_title LIKE '%$val%'";
			}
		$title_query = " AND ($title_query)";
		}
	if($desc_array[0] != "") {
		while(list(,$val) = each($desc_array)) {
			if($desc_query != "") { $desc_query .= " $descCriteriaCond "; }
			$desc_query .= "ad_description LIKE '%$val%'";
			}
		$desc_query = " AND ($desc_query)";
		}
	if($misc_array[0] != "") {
		while(list(,$val) = each($misc_array)) {
			if($misc_query != "") { $misc_query .= " $miscCriteriaCond "; }
			$misc_query .= "(ad_optional_1 LIKE '%$val%' OR ad_optional_2 LIKE '%$val%' OR ad_optional_3 LIKE '%$val%' OR ad_optional_4 LIKE '%$val%' OR ad_optional_5 LIKE '%$val%' OR ad_type_optional1 LIKE '%$val%' OR ad_type_optional2 LIKE '%$val%' OR ad_type_optional3 LIKE '%$val%' OR ad_type_optional4 LIKE '%$val%' OR ad_type_optional5 LIKE '%$val%' OR ad_type_optional6 LIKE '%$val%' OR ad_type_optional7 LIKE '%$val%' OR ad_type_optional8 LIKE '%$val%' OR ad_type_optional9 LIKE '%$val%' OR ad_type_optional10 LIKE '%$val%')";
			}
		$misc_query = " AND ($misc_query)";
		}
	if($loc_array[0] != "") {
		while(list(,$val) = each($loc_array)) {
			if($loc_query != "") { $loc_query .= " $locCriteriaCond "; }
			$loc_query .= "(ad_city LIKE '%$val%' OR ad_state LIKE '%$val%' OR ad_postal LIKE '%$val%' OR ad_country LIKE '%$val%')";
			}
		$loc_query = " AND ($loc_query)";
		}

	if($adCategory != 0) {
		$cat_query = " AND (ad_category=$adCategory)";
		}

	$date_query = " AND (ad_date_begin > '$adDate')";

	if($adType != 0) { $type_query = " AND (ad_type=$adType)"; }

	$queryCriteria = substr("{$title_query}{$desc_query}{$misc_query}{$loc_query}{$cat_query}{$date_query}{$type_query}",5);

	$sortLink = "fromAdv=".rawurlencode(serialize(array("$titleCriteria","$titleCriteriaCond","$descCriteria","$descCriteriaCond","$miscCriteria","$miscCriteriaCond","$locCriteria","$locCriteriaCond","$adType","$adDate","$adCategory")));
	}

//Sort options
if($sort == "") { $sort = "name"; }
if($sort_dir == "") { $sort_dir = "a"; }
switch($sort) {
	case "name":
		if($sort_dir == "a") { $sort_text = "ORDER BY ad_title ASC"; }
			else { $sort_text = "ORDER BY ad_title DESC"; }
		break;
	case "date":
		if($sort_dir == "a") { $sort_text = "ORDER BY ad_date_begin ASC"; }
			else { $sort_text = "ORDER BY ad_date_begin DESC"; }
		break;
	case "expires":
		if($sort_dir == "a") { $sort_text = "ORDER BY ad_date_end ASC"; }
			else { $sort_text = "ORDER BY ad_date_end DESC"; }