<?
require('../xpl_inc/init.inc.php');

srand(make_seed());

$txt=trim($_REQUEST['q']);

if (eregi('http://',$txt))
{
	header("Location: /");
	exit();
}

$root_path=$GLOBALS['sysctl']['frontend.urls.site_path'];
$root_url=$GLOBALS['sysctl']['frontend.urls.site_url'];
$date_format=$GLOBALS['sysctl']['frontend.listing.date_format'];

$smarty->template_dir='../xpl_templates';
$smarty->compile_dir='../xpl_templates/compile';
$smarty->register_modifier('esch','esch');

$pager=new clsPAGER($db);

$pager->mySendThroughGET=true;
$pager->myReceiveThroughGET=true;
$pager->SetTemplatesPath('../xpl_templates','../xpl_templates/compile');
$pager->SetIPP($GLOBALS['sysctl']['frontend.ipp.search_common']);

$stats=array();

$stats['year']=date('Y');

if ($txt!='')
{
	$sql="SELECT i.id,i.rating_admin,ROUND(i.rating_user) AS rating_user,i.rating_user_votes,i.pos,
ndate,DATE_FORMAT(i.ndate,'{$date_format}') AS `date`,i.name AS title,i.url,i.spare1,i.spare2,i.thumbnail,i.description,
c.text_id AS category_text_id, c.name AS category_name, s.name AS section_name, t.name AS type_name,
t.description AS type_description, t.spare1 AS type_spare1, t.spare2 AS type_spare2, t.display AS type_display, MATCH (i.name,i.url,i.description) AGAINST ('".escm($txt)."') AS score
FROM ".DB_PREFIX."items i
INNER JOIN ".DB_PREFIX."categories c ON i.ref_id_categories=c.id
INNER JOIN ".DB_PREFIX."sections s ON c.ref_id_sections=s.id
INNER JOIN ".DB_PREFIX."link_types t ON i.ref_id_link_types=t.id
LEFT OUTER JOIN ".DB_PREFIX."submit submit ON i.id=submit.id
WHERE (submit.status IS NULL OR submit.status='approved') AND MATCH (i.name,i.url,i.description) AGAINST ('".escm($txt)."') > 0";
	$pager->SetSQL($sql);
	$pager->Prepare();
	if ($pager->myPager_num>0 && $_REQUEST['page']=='')
	{
		$db->Insert("INSERT INTO ".DB_PREFIX."searches_tmp (txt) VALUES ('".escm($txt)."')");
	}
	$items_common=$db->Select($sql." ORDER BY score DESC ".$pager->myPager_limit);
	$stats['page']=$pager->myPager_page;
	$stats['pages']=$pager->myPager_pages;
	$stats['links_local']=$pager->myPager_num;
	$stats['link_first']=$pager->myPager_first;
	$stats['link_last']=$pager->myPager_last;
}
else
{
	$items_common=array();
	$stats['page']=1;
	$stats['pages']=1;
	$stats['links_local']=0;
	$stats['link_first']=0;
	$stats['link_last']=0;
}

$categories=$db->Select("SELECT c.id,c.text_id,c.name,c.title_text,c.header_text,c.field1,c.field2,c.field3,s.id AS section_id,s.name AS section FROM ".DB_PREFIX."categories c INNER JOIN ".DB_PREFIX."sections s ON c.ref_id_sections=s.id ORDER BY s.pos,c.name");

for (reset($categories); list($idx,$category)=each($categories);)
{
	$categories[$idx]['url']=getCategoryURL($category['text_id'],false);
}

$sql_sponsored="SELECT i.id,i.rating_admin,ROUND(i.rating_user) AS rating_user,i.rating_user_votes,i.pos,
DATE_FORMAT(i.ndate,'{$date_format}') AS `date`,i.name AS title,i.url,i.spare1,i.spare2,i.thumbnail,i.description,
c.text_id AS category_text_id, c.name AS category_name, s.name AS section_name, t.name AS type_name,
t.description AS type_description, t.spare1 AS type_spare1, t.spare2 AS type_spare2, t.display AS type_display
FROM ".DB_PREFIX."items i
INNER JOIN ".DB_PREFIX."categories c ON i.ref_id_categories=c.id
INNER JOIN ".DB_PREFIX."sections s ON c.ref_id_sections=s.id
INNER JOIN ".DB_PREFIX."link_types t ON i.ref_id_link_types=t.id
WHERE sponsored_link='y'";

$sponsored_links=$db->Select($sql_sponsored);
$sponsored_count=count($sponsored_links);

if ($sponsored_count<=$GLOBALS['sysctl']['frontend.ipp.search_sponsored'])
{
	$items_sponsored=$sponsored_links;
	shuffle($items_sponsored);
}
else
{
	$items_sponsored=getSponsoredLinks($sponsored_links,$GLOBALS['sysctl']['frontend.ipp.search_sponsored']);
}

$num_searches=intval($GLOBALS['sysctl']['frontend.searches_to_display']);
if ($num_searches>0)
{
	$sql="SELECT txt,cnt FROM ".DB_PREFIX."searches ORDER BY cnt DESC LIMIT $num_searches";
}
else
{
	$sql="SELECT txt,cnt FROM ".DB_PREFIX."searches ORDER BY cnt DESC";
}

$searches=$db->Select($sql);

for(reset($searches);list($idx,$srch)=each($searches);)
{
	$searches[$idx]['txt_url']=rawurlencode($srch['txt']);
}

$l=$GLOBALS['sysctl']['frontend.max_news']>0?" LIMIT ".$GLOBALS['sysctl']['frontend.max_news']:'';
$news=$db->Select("SELECT id,ndate,descr,content FROM ".DB_PREFIX."news ORDER BY id DESC".$l);

addThumbs($items_common);
addThumbs($items_sponsored);

$smarty->clear_all_assign();
$smarty->assign('categories',$categories);	
$smarty->assign('news',$news);	
$smarty->assign('stats',$stats);
$smarty->assign('searches',$searches);
$smarty->assign('pager',$pager->PagerPrint());
$smarty->assign('items_common',$items_common);	
$smarty->assign('items_sponsored',$items_sponsored);
$smarty->assign('search_text',$txt);
$smarty->assign('search_text_html_quoted',esch($txt));
$smarty->assign('search_text_url_quoted',rawurlencode($txt));
$smarty->display('search2.tpl');

?>