search.php

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

	case "type":
		if($sort_dir == "a") { $sort_text = "ORDER BY ad_type ASC"; }
			else { $sort_text = "ORDER BY ad_type DESC"; }
		break;
	}

$sortTable =<<<ENDPRINT
<div id="info">
<table width="{$SystemOptions['page_width']}" border="0" cellspacing="1" cellpadding="3">
<tr>
  <td colspan="{$SystemOptions['list_columns']}" align="right">
   {$Languages['index']['sortby']}
   {$Languages['index']['name']}<a href="{$insUrl}search.php?{$sortLink}&sort=name&sort_dir=a"><img src="{$insUrl}images/up.gif" border="0"></a><a href="{$insUrl}search.php?{$sortLink}&sort=name&sort_dir=d"><img src="{$insUrl}images/down.gif" border="0"></a> |
   {$Languages['index']['added']}<a href="{$insUrl}search.php?{$sortLink}&sort=date&sort_dir=a"><img src="{$insUrl}images/up.gif" border="0"></a><a href="{$insUrl}search.php?{$sortLink}&sort=date&sort_dir=d"><img src="{$insUrl}images/down.gif" border="0"></a> |
   {$Languages['index']['expires']}<a href="{$insUrl}search.php?{$sortLink}&sort=expires&sort_dir=a"><img src="{$insUrl}images/up.gif" border="0"></a><a href="{$insUrl}search.php?{$sortLink}&sort=expires&sort_dir=d"><img src="{$insUrl}images/down.gif" border="0"></a> |
   {$Languages['index']['type']}<a href="{$insUrl}search.php?{$sortLink}&sort=type&sort_dir=a"><img src="{$insUrl}images/up.gif" border="0"></a><a href="{$insUrl}search.php?{$sortLink}&sort=type&sort_dir=d"><img src="{$insUrl}images/down.gif" border="0"></a>
  </td>
 </tr>
</table>
</div>
ENDPRINT;






if(isset($queryCriteria)) {
	$ads_counter = 0;
	$imgs = array();
	$ads = array();
	$result = query("SELECT ad_id,ad_date_begin,ad_date_end,ad_type,ad_title,ad_description,ad_image1,ad_options,ad_price FROM {$class_prefix}ads WHERE ad_status=1 AND $queryCriteria $sort_text",$class_link);
	while(list($ad_id,$ad_date_begin,$ad_date_end,$ad_type,$ad_title,$ad_description,$ad_image1,$ad_options,$ad_price) = mysql_fetch_row($result)) {
		$ad_title = strip_tags(stripslashes($ad_title));
		$ad_description = strip_tags(stripslashes($ad_description));
		if(strlen($ad_description) >= 100) {
			$ad_description = substr($ad_description,0,100 + strpos(substr($ad_description,100)," "))."...";
			}

		if($ad_image1 != "") {
			$ad_image1 = getThumb($ad_image1);
			if($SystemOptions['spider'] == 1) { $imgs[$ads_counter] = "<a href=\"{$insUrl}classified.php/listing/$ad_id\"><img src=\"{$insUrl}images/listings/{$ad_image1}\" border=\"0\" class=\"ad_thumb\" align=\"left\"></a>"; }
				else { $imgs[$ads_counter] = "<a href=\"{$insUrl}classified.php?listing=$ad_id\"><img src=\"{$insUrl}images/listings/{$ad_image1}\" border=\"0\" class=\"ad_thumb\" align=\"left\"></a>"; }
			}

		$type = $adTypes[$ad_type];

		$date = formatDate($ad_date_begin);
		if($SystemOptions['spider'] == 1) { $ads[$ads_counter] = "{$type} <a href=\"{$insUrl}classified.php/listing/$ad_id\" class=\"ad_link\">$ad_title</a><br>$ad_description<br>{$ad_price}"; }
			else { $ads[$ads_counter] = "{$type}: <a href=\"{$insUrl}classified.php?listing=$ad_id\" class=\"ad_link\">$ad_title</a><br>$ad_description<br>{$ad_price}"; }

		if($ad_options >= 1) {
			$back = ""; $back_e = ""; $bold = ""; $italic = "";
			if(($ad_options & 8) != 0)  { $back = "<div class=\"background_1\">"; $back_e = "</div>"; }
			if(($ad_options & 16) != 0)  { $back = "<div class=\"background_2\">"; $back_e = "</div>"; }
			if(($ad_options & 32) != 0)  { $back = "<div class=\"background_3\">"; $back_e = "</div>"; }
			if(($ad_options & 64) != 0)  { $back = "<div class=\"background_4\">"; $back_e = "</div>"; }
			if(($ad_options & 2) != 0) {  $bold = "font-weight:bold;"; }
			if(($ad_options & 4) != 0) { $italic = "font-style:italic;"; }
			$ads[$ads_counter] = "{$back}<div style=\"$bold $italic\">{$imgs[$ads_counter]}{$ads[$ads_counter]}</div>{$back_e}";
			}
			else { $ads[$ads_counter] = "{$imgs[$ads_counter]}{$ads[$ads_counter]}"; }
		$ads_counter++;
		}

	if($pg == "") { $pg = 1; }
	if($ads_counter != 0) {
			echo<<<ENDPRINT
			<br>
			$sortTable
			<div id="menu">
			<table width="{$SystemOptions['page_width']}" border="0" cellspacing="1" cellpadding="3">
		 	<tr>
		  	<td>{$Languages['search']['results']}</td>
		 	</tr>
			</table>
			</div>
			<div id="listings">
			<table width="{$SystemOptions['page_width']}" border="0" cellspacing="1" cellpadding="3">
ENDPRINT;
			if(substr($SystemOptions['page_width'],-1) == "%") { $colWidth = floor($SystemOptions['page_width'] / $SystemOptions['list_columns']) . "%"; }
				else { $colWidth = floor($SystemOptions['page_width'] / $SystemOptions['list_columns']); }

			for($i=(($pg*10)-10); $i<=(($pg*10)-1); $i++) {
				if($ads[$i] == "") { continue; }
				echo "<tr>";
				for($ii=0; $ii<=$SystemOptions['list_columns']-1; $ii++) {
					$j = $i + $ii;
					echo "<td width=\"$colWidth\" valign=\"top\">$ads[$j]</td>";
					}
				echo "</tr>";
				$i = $i + $SystemOptions['list_columns'] - 1;
				}
			echo "</table></div>";

			if($ads_counter > 10) {
				echo "<div id=\"info\"><table width=\"{$SystemOptions['page_width']}\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">";
				echo "<tr><td align=\"right\">{$Languages['index']['gotopage']} ";
				$pages = ceil($ads_counter/10);
				for($i=1; $i<=$pages; $i++) {
					if($pg == $i) {	echo "{$i} "; }
						else {
							echo "<a href=\"{$insUrl}search.php?{$sortLink}&pg=$i&sort=$sort&sort_dir=$sort_dir\">{$i}</a> ";
							}
					}
				echo "</td></tr></table></div>";
				}
			}

	if($ads_counter == 0) {
		echo<<<ENDPRINT
		<br>
		<div id="menu">
		<table width="{$SystemOptions['page_width']}" border="0" cellspacing="1" cellpadding="3">
 	 	 <tr>
		  <td>{$Languages['search']['results']}</td>
		 </tr>
		</table>
		</div>
		<div id="listings">
		<table width="{$SystemOptions['page_width']}" border="0" cellspacing="1" cellpadding="3">
		 <tr>
		  <td align="center">{$Languages['search']['noresults']}</td>
		 </tr>
		</table>
		</div>
ENDPRINT;
		}
	}
	else {
		//Show advanced screen
		$cats = getCats();

		echo<<<ENDPRINT
		<br>
		<div id="generalBox">
		<table width="{$SystemOptions['page_width']}" border="0" cellspacing="1" cellpadding="3">
		<form method="post" action="search.php">
		<input type="hidden" name="fromAdv" value="1">
		 <tr>
		  <td class="headtd" colspan="2">{$Languages['search']['criteria']}</td>
		 </tr>
		 <tr>
		  <td width="50%" align="right">{$Languages['search']['title']}</td>
		  <td width="50%"><input type="text" name="titleCriteria"><select name="titleCriteriaCond"><option value="AND">AND</option><option value="OR">OR</option></select></td>
		 </tr>
		 <tr>
		  <td width="50%" align="right">{$Languages['search']['desc']}</td>
		  <td width="50%"><input type="text" name="descCriteria"><select name="descCriteriaCond"><option value="AND">AND</option><option value="OR">OR</option></select></td>
		 </tr>
		 <tr>
		  <td width="50%" align="right">{$Languages['search']['misc']}</td>
		  <td width="50%"><input type="text" name="miscCriteria"><select name="miscCriteriaCond"><option value="AND">AND</option><option value="OR">OR</option></select></td>
		 </tr>
		 <tr>
		  <td width="50%" align="right">{$Languages['search']['loc']}</td>
		  <td width="50%"><input type="text" name="locCriteria"><select name="locCriteriaCond"><option value="AND">AND</option><option value="OR">OR</option></select></td>
		 </tr>
		 <tr><td colspan="2" align="center"><hr></td></tr>
		 <tr>
		  <td width="50%" align="right">{$Languages['search']['type']}</td>
		  <td width="50%"><select name="adType"><option value="0">{$Languages['search']['all']}</option>$adTypesBox</select></td>
		 </tr>
		 <tr>
		  <td width="50%" align="right">{$Languages['search']['added']}</td>
		  <td width="50%"><select name="adDate"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="10">10</option><option value="20">20</option><option value="30">30</option><option value="40">40</option><option value="50">50</option><option value="60">60</option><option value="70">70</option><option value="80">80</option><option value="90" selected>90</option></select> {$Languages['search']['days']}</td>
		 </tr>
		 <tr>
		  <td colspan="2" align="center">{$Languages['search']['category']} <select name="adCategory"><option value="0">{$Languages['search']['all']}</option>$cats</select></td>
		 </tr>
		 <tr>
		  <td colspan="2" align="center"><input type="submit" value="{$Languages['search']['search']}"></td>
		 </tr>
		</form>
		</table>
		</div>
ENDPRINT;
		}

include("footer.php");

?>