casey

<?phpimport_request_variables('gPc');if(!@include('dbconn.inc.php')){	die();}else{	//SET TABLES TO BE SEARCHED	$tables = array(0 => "ABSURD_NEWS", 1=> "ABSURD_ANNCOUNCE");		if(isset($_GET['search_query']))	{		$search_query     = prepare_query($search_query);		$search_results_k = search_keywords($tables, $search_query);		//$search_results_b = search_body($tables, $search_query);				$formatted_results_k = format_results_k($search_results_k,$search_query);//MATCH IN KEYWORDS		//$formatted_results_b = format_results_b($search_results_b,$search_query);//MATCH IN BODY	}	else	{		echo('you must search for something');		die();	}}//USER DEFINED FUNCTINOSfunction prepare_query($search_query){	$search_query = trim($search_query);	$search_query = explode(' ',$search_query);	//var_dump($search_query);		return $search_query;}function search_keywords($tables, $search_query){	$j=0;	foreach($tables as $table_key => $table_element)	{		foreach($search_query as $search_key => $search_element)		{			$query = "SELECT * FROM $table_element WHERE KEYWORDS LIKE \"%$search_element%\";";			if(@mysql_num_rows(@mysql_query($query)))			{				$result_k[$j] = $query;			}						$j++;		}	}	//var_dump($result_k);	return $result_k;}function search_body($tables, $search_query){	$j=0;	foreach($tables as $table_key => $table_element)	{							foreach($search_query as $search_key => $search_element)		{			$query = "SELECT * FROM $table_element WHERE BODY LIKE \"%$search_element%\";";			if(@mysql_num_rows(@mysql_query($query)))			{				$result_b[$j] = $query;			}			else			{				$result_b[$j] = '@NOT FOUND ' . $search_element . '@';			}						$j++;		}	}	//var_dump($result_b);	return $result_b;}function format_results_k($search_results_k,$search_query){	$j = -1;	foreach($search_results_k as $keywords_key => $keywords_element)	{		if(substr($keywords_element,0,4) != '@NOT')		{				$query  = $keywords_element;			$result = mysql_query($query);			$num    = mysql_num_rows($result);								for($i=0;$i<$num;$i++)			{				$j++;					//GET TABLE NAME -- VERY IMPORTANT				$table_name = explode(" ",$query);				$table_name = $table_name[3];								$search_term = explode("%",$query);				$search_term = $search_term[1];												$ID       = mysql_result($result,$i,"ID");				$KEYWORDS = mysql_result($result,$i,"KEYWORDS");				$KEYWORDS = explode(' ',$KEYWORDS);				//var_dump($KEYWORDS);												$count = 0;								foreach($search_query as $search_key => $search_element)				{					foreach($KEYWORDS as $KEYWORDS_key => $KEYWORDS_element)					{						if(strtolower($KEYWORDS_element) == strtolower($search_element))						{							$count++;						}					}					if($j == $i)					{							$formatted_results_k[$i] = $table_name . '-' . $ID . '-' . $search_term . '-' . $count;					}					else					{						$formatted_results_k[$j] = $table_name . '-' . $ID . '-' . $search_term . '-' . $count;					}				}																		}		}	}	//var_dump($formatted_results_k);	return $formatted_results_k;}function format_results_b($search_results_b, $search_query){	return $formatted_results_b;}?>