<?PHP
/**
Schnittstelle zur Auktionssuchmaschine Asearch.de
erstellt von Stefan Zimara, Asearch GdbR
Copyrigth Asearch.de Bei Fragen mailto:Stefan@asearch.de
**/
	require('./includes/config_inc.php');
	header("Content-Type: text/plain");	
	$domain = $HTTP_HOST;
	$url = $SITE_URL;
	$ci = 0;
	$q_array = split("( |%20)",$q); 
	while (list($key, $unit) = each($q_array)) {
		if ($ci == 0) {
			$qu = "'%".$unit."%'";		
		} else {
			$qu = $qu." and title like '%".$unit."%'";		
		}
		$ci++;
		
	} 
	
	/* get auction data */
	$query = "select * from ".$dbfix."_auctions where ends >= now() + 0 and title like $qu";
	$result = mysql_query($query);
	if ( !$result )
{
		echo mysql_errno(). ": ".mysql_error(). "\n"; 
	exit;
}
	for($im=0; $im<mysql_num_rows($result);  $im++) { 
	$title = mysql_result ( $result, $im, "title" );
	$id = mysql_result ( $result, $im, "id" ); 
	$date = mysql_result ( $result, $im, "date" );
	$category = mysql_result ( $result, $im, "category" );
	$minimum_bid = mysql_result ( $result, $im, "minimum_bid" );
//	$reserve_price = mysql_result ( $result, $im, "reserve_price" );
//	$auction_type = mysql_result ( $result, $im, "auction_type" );
	$ends = mysql_result ( $result, $im, "ends" );
	$current_bid = mysql_result ( $result, $im, "current_bid" );
//	$description = mysql_result ( $result, $im, "description" );
	if ($current_bid == 0) { $current_bid = $minimum_bid; }
	/* Get number of bids */
	$query = "select * from ".$dbfix."_bids where auction=\"$id\"";
	$result_numbids = mysql_query ( $query );
	if (!$result_numbids)
	{
		echo mysql_errno(). ": ".mysql_error(). "\n"; 
	} else 	{
		$num_bids = mysql_num_rows ( $result_numbids );
	}
//	mysql_free_result($result_numbids);			
	
	/* Get Catagory Title */	
/*	$c_name[] = array(); 
	$c_id[] = array();
	$cat = "";
	$query = "select cat_id,parent_id,cat_name from categories where cat_id='$category'";
	$result_kat = mysql_query($query);
	if (!$result_kat)
	{
		echo mysql_errno(). ": ".mysql_error(). "\n"; 
	}
	$result_cat	= mysql_fetch_array ($result_kat);
	$parent_id = $result_cat[parent_id];
	$cat_id = $categories;
	$j = $category;
	$i = 0;
	$cat = $result_cat[cat_name];
	mysql_free_result($result_kat);			
	
	do {
			$query = "select cat_id,parent_id,cat_name from categories where cat_id='$j'";
			$result_kat = mysql_query($query);
			if ( $result_kat )
{
				$result_cat = mysql_fetch_array ( $result_kat );
					$parent_id = $result_cat[parent_id];
					$c_name[$i] = $result_cat[cat_name];
					$c_id[$i] = $result_cat[cat_id];
					$i++;
					$j = $parent_id;
				mysql_free_result($result_kat);			
			}
	} while ( $parent_id != 0 );
	for ($j=$i-1; $j>=0; $j--)
	{
			if ( $j == 0) {
				$cat .= $c_name[$j];
	} else {
				$cat .= $c_name[$j]." / ";
			}
}
*/
$fp = fopen("./listing/asearch.txt", "w+");
fputs($fp, "$ends|$url/artikel.php?id=$id|$domain|$current_bid|$title|$num_bids|$cat\n");
//	print ("$ends|$url/artikel.php?id=$id|$domain|$current_bid|$title|$num_bids|$cat\n");
fclose($fp);
}	// For $im
?>