<?php

import_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 FUNCTINOS
function 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;
}

?>