<?
$in_list=1;
//if($_GET['debug']==1) print_r($_REQUEST);
//print_r($_GET);exit;

include ("functions.php");

$data_conf = general_include($_SERVER['SERVER_NAME']);
$userid= $data_conf['id'];
if($_GET['template']>1) $data_conf['template'] = $_GET['template'];

if(file_exists('templates/'.$data_conf['template'] .'/lang/'.$data_conf['lang'] .'.php'))
   include ('templates/'.$data_conf['template'] .'/lang/'.$data_conf['lang'] .'.php');

if($_GET['lang']=='') $_GET['lang']=$_REQUEST['lang']='mk';
$allow_param =array('cat','type','category','title','city','userid','municipality','measurement_from','measurement_to','rooms','price_from','price_to','price','measurement','equip','status','bathrooms','garage','basement','elevator','floor_from','floor_to','heating','parking','north','south','east','west','debug','book',"ajax","template");

if(sizeof(@explode(",", $_REQUEST['price']))>1)
	list($_REQUEST['price_from'], $_REQUEST['price_to']) = explode(",", $_REQUEST['price']);
if(sizeof(@explode("-", $_REQUEST['price']))>1)
	list($_REQUEST['price_from'], $_REQUEST['price_to']) = explode("-", $_REQUEST['price']);

if(sizeof(@explode(",", $_REQUEST['measurement']))>1)
	list($_REQUEST['measurement_from'], $_REQUEST['measurement_to']) = explode(",", $_REQUEST['measurement']);
if(sizeof(@explode("-", $_REQUEST['measurement']))>1)
	list($_REQUEST['measurement_from'], $_REQUEST['measurement_to']) = explode("-", $_REQUEST['measurement']);

	$keywords_request_data=[];
	$keywords_request_data_original=[];
if($_GET['keyword']!='')
{ 
   $_REQUEST['keyword']=$_GET['keyword']=strtolower($_GET['keyword']);
	$keywords = $qry->querySelectSingle("SELECT * FROM `keywords` WHERE url='".mysql_real_escape_string($_GET['keyword'])."'");
	//print_r($keywords);exit;

	if($keywords['url']!='')
		$_GET=$_REQUEST = array_merge($_GET,$keywords_request_data_original=$keywords_request_data=  json_decode($keywords['request_data'],true));
	else $_GET=$_REQUEST = array_merge($_GET,array('title'=> str_replace("-"," ", $_GET['keyword'])));
	//echo json_encode(Array ( "cat" => "stanovi", "city" => "Охрид","keyword"=>$keyword));
//print_r($keywords_request_data_original);
}

if($_REQUEST['cat']=="\\'nedviznosti\\'"){  $_REQUEST['cat']=$_GET['cat']='nedviznosti'; }
if($_REQUEST['cat']=='nedviznosti' or $_REQUEST['cat']=='real-estate') $_REQUEST['cat'] = $_GET['cat'] = '';

if($_REQUEST['id']>0) { header('Location: /description.php?id='.@mysql_result(@mysql_query("SELECT id FROM ads WHERE original_id = '".mysql_real_escape_string($_REQUEST['id'])."' AND ads.userid ='$userid'"),0));exit; }
if($_REQUEST['title']>0) { header('Location: /description.php?id='.@mysql_result(@mysql_query("SELECT id FROM ads WHERE original_id = '".mysql_real_escape_string($_REQUEST['title'])."' AND ads.userid ='$userid'"),0));exit; }
if($_GET['debug']==2) echo getListUrl($_REQUEST,array());
if($_REQUEST['cat']=='станови') {
	$_REQUEST['cat']='stanovi';
	if($keywords_request_data['cat']!='') $keywords_request_data['cat']='stanovi';
}

if($_REQUEST['city']=='Скопје') {
	$_REQUEST['city']='Skopje';
	if($keywords_request_data['city']!='') $keywords_request_data['city']='Skopje';
}
if($_GET['debug']==3) echo 'a'. print_r($keywords_request_data);//echo getListUrl($_REQUEST,array());
//print_r(array_diff($_REQUEST,$keywords_request_data));print_r($keywords_request_data);
 $seo_url = getListUrl(array_diff($_REQUEST,$keywords_request_data),array());

if($keywords['url']=='' && (urldecode($seo_url) != urldecode($_SERVER['REQUEST_URI']) or strpos($_SERVER['REQUEST_URI'],"%20")!==FALSE) && !isset($_GET['template']))
{
	//print_r($_REQUEST);
	//if($_GET['debug']==2) 
	//echo urldecode($seo_url) .'!=.'. urldecode($_SERVER['REQUEST_URI']);
	header("HTTP/1.1 301 Moved Permanently");
	header('Location: '.$seo_url);
	exit;
}
if($_REQUEST['keyword']!=''){
	$rkkk = str_ireplace("-"," ", $_REQUEST['keyword']);
	$rkkk2= explode(" ",$rkkk);
	
	//print_r($rkkk2); 
	//echo count($rkkk2) .'=='. count(array_unique($rkkk2));
	//echo $_REQUEST['keyword'];
	$special_seo_keywords = array('pazar-3', 'reklama-5', 'pazar3', 'reklama5', 'stanovi-skopje','agencii-za-nedviznosti','реклама-5');
	foreach($special_seo_keywords as $ssk )
	{
		if(strpos($_REQUEST['keyword'], $ssk) !== FALSE) 
		{
			$force_keyword= $ssk."-"; break;
		}
	}
	$dasabled_keywords = array('mkmk','mken','enmk','enen','select','concat','extractvalue','orderby','plugins','chr113' );
	foreach ($dasabled_keywords as $dk)
	{
		if(strpos($_REQUEST['keyword'], $dk) !== FALSE) 
		{
			exit;
		}
	}

	
	if(count($rkkk2) == count(array_unique($rkkk2)) and strpos($_REQUEST['keyword'], 'pazar-3') === FALSE and strpos($_REQUEST['keyword'], 'reklama-5') === FALSE 
	and strpos($_REQUEST['keyword'], 'pazar3') === FALSE and strpos($_REQUEST['keyword'], 'reklama5') === FALSE and strpos($_REQUEST['keyword'], 'stanovi-skopje') === FALSE 
	and strpos($_REQUEST['keyword'],'agencii-za-nedviznosti') === FALSE and strpos($_REQUEST['keyword'],'реклама-5') === FALSE 
	)
	{
		mysql_query("INSERT INTO `auto_keywords`(`title`, `url`) VALUES ('". mysql_real_escape_string( str_replace("-"," ",$_REQUEST['keyword']))."','".mysql_real_escape_string(substr(current(explode("?",$seo_url)),1,-4))."')" );
	}

}
//if (urldecode($seo_url) != urldecode($_SERVER['REQUEST_URI']) or strpos($_SERVER['REQUEST_URI'],"%20")!==FALSE) 
$canonical = $seo_url;
/*if(($pcan = strpos($canonical,'?'))>1) {
	$canonical = substr($canonical,0,$pcan);
	$meta_robots='noindex,follow';
}*/


//if($_GET['debug']==1) print_r($_GET);
if($_REQUEST['cat']=='stanovi') {
	$_GET['cat']=$_REQUEST['cat']='станови';
	if($keywords_request_data_original['cat']!='') $keywords_request_data_original['cat']='станови';
}

if($_REQUEST['city']=='Skopje') {
	$_GET['city']=$_REQUEST['city']='Скопје';
	if($keywords_request_data_original['city']!='') $keywords_request_data_original['city']='Скопје';
}
//if($_REQUEST['debug']==1) print_r($_REQUEST);

$url = '';
foreach($allow_param as $p)
if($_GET[$p]!='') $url.=($url == ''?'':'&').$p.'='.$_GET[$p];

$url = ($_GET['lang']!='mk'?'/'.$_GET['lang']:'').'/list.php?'.$url;


//cat='.$_GET['cat'].'&type='.$_GET['type'].'&category='.$_GET['category'].'&title='.$_GET['title'].'&city='.$_GET['city'].'&userid='.$_GET['userid'];
$cms=$qry->querySelectSingle("SELECT id,title,description,meta_title,meta_description,meta_keywords,blog,image FROM texts WHERE ".($userid==1?"":"userid='".$userid."' AND")." url='".mysql_real_escape_string($_REQUEST['cat'])."'");


if ($_REQUEST['cat']=='contact')
{
	
	include "templates/".$data_conf['template']."/contact.php";
	exit;
}

if ($cms['id']>0)
{ //text page
if($meta_data['meta_title']=='') $data_conf['meta_title']=$cms['meta_title'];
if($meta_data['meta_keywords']=='') $data_conf['meta_keywords']=$cms['meta_keywords'];
if($meta_data['meta_description']=='') $data_conf['meta_description']=$cms['meta_description'];
include "templates/".$data_conf['template']."/text_page.php";
exit;
} 

 //category
$meta_data=$qry->querySelectSingle("SELECT * FROM `categories` WHERE url = '".translate_r(mysql_real_escape_string($_REQUEST['cat']),$lang['cat_url'])."' AND userid='".$userid."'");


$pages=0;

//items per page
if ($data_conf['theme']==3)
$num_onpage=15;
else 
$num_onpage=12;

if ($data_conf['theme']==1)$num_onpage=27;

//if ($_GET['cat2']=='send')
//{
//	include("templates/".$template."/send.php");
//	exit();
//} 


	$whereSearch2='';
	
	//if($_REQUEST['category']!="")    {  $whereSearch2 .= " AND ads.category='".$_REQUEST['category']."' "; }
	if($_REQUEST['cat']!="")    {  $whereSearch2 .= " AND categories.url='".translate_r(mysql_real_escape_string($_REQUEST['cat']),$lang['cat_url'])."' "; }
	if($_REQUEST['title']!="" and $_REQUEST['title']!="Барајте...")    { $whereSearch2 .= " AND ( MATCH (ads.title) AGAINST ('". str_replace(" "," ", mysql_real_escape_string($_REQUEST['title']))."' IN BOOLEAN MODE) OR categories.title LIKE '%". mysql_real_escape_string($_REQUEST['title'])."%' OR  ads.municipality LIKE '%". mysql_real_escape_string($_REQUEST['title'])."%')"; }
	if($_REQUEST['city']!="") { $whereSearch2 .= " AND ads.city = '".translate_r(mysql_real_escape_string($_REQUEST['city']),$lang['city'])."' "; }
	if($_REQUEST['municipality']!="") { $whereSearch2 .= " AND ads.municipality = '".translate_r(mysql_real_escape_string($_REQUEST['municipality']),$lang['municip'])."' "; }
	if($_REQUEST['measurement_from']>0) { $whereSearch2 .= " AND ads.measurement > '".mysql_real_escape_string($_REQUEST['measurement_from'])."' "; }
	if($_REQUEST['measurement_to']>0) { $whereSearch2 .= " AND ads.measurement < '".mysql_real_escape_string($_REQUEST['measurement_to'])."' "; }
	if($_REQUEST['rooms']>0) { $whereSearch2 .= " AND ads.rooms = '".mysql_real_escape_string($_REQUEST['rooms'])."' "; }
if($_REQUEST['bathrooms']>0) { $whereSearch2 .= " AND ads.bathrooms = '".mysql_real_escape_string($_REQUEST['bathrooms'])."' "; }
	if($_REQUEST['type']>0) { $whereSearch2 .= " AND ads.type_id = '".mysql_real_escape_string($_REQUEST['type'])."' "; }
if($_REQUEST['status']>0) { $whereSearch2 .= " AND ads.status = '".mysql_real_escape_string($_REQUEST['status'])."' "; }
if($_REQUEST['equip']>0) { $whereSearch2 .= " AND ads.equip = '".mysql_real_escape_string($_REQUEST['equip'])."' "; }
	if($_REQUEST['price_from']>0) { $whereSearch2 .= " AND ads.price>='".str_replace(".","",str_replace(",","", mysql_real_escape_string($_REQUEST['price_from'])))."' "; }
	if($_REQUEST['price_to']>0) { $whereSearch2 .= " AND ads.price<='".str_replace(".","",str_replace(",","", mysql_real_escape_string($_REQUEST['price_to'])))."' "; }

if($_REQUEST['floor_from']>0) { $whereSearch2 .= " AND ads.floor > '".mysql_real_escape_string($_REQUEST['floor_from'])."' "; }
	if($_REQUEST['floor_to']>0) { $whereSearch2 .= " AND ads.floor < '".mysql_real_escape_string($_REQUEST['floor_to'])."' "; }

	if($_REQUEST['basement']>0) { $whereSearch2 .= " AND ads.basement = '".mysql_real_escape_string($_REQUEST['basement'])."' "; }
if($_REQUEST['garage']>0) { $whereSearch2 .= " AND ads.garage = '".mysql_real_escape_string($_REQUEST['garage'])."' "; }
if($_REQUEST['elevator']>0) { $whereSearch2 .= " AND ads.elevator = '".mysql_real_escape_string($_REQUEST['elevator'])."' "; }
if($_REQUEST['heating']>0) { $whereSearch2 .= " AND ads.heating = '".mysql_real_escape_string($_REQUEST['heating'])."' "; }
if($_REQUEST['parking']>0) { $whereSearch2 .= " AND ads.parking = '".mysql_real_escape_string($_REQUEST['parking'])."' "; }
if($_REQUEST['north']>0) { $whereSearch2 .= " AND ads.north = '".mysql_real_escape_string($_REQUEST['north'])."' "; }
if($_REQUEST['south']>0) { $whereSearch2 .= " AND ads.south = '".mysql_real_escape_string($_REQUEST['south'])."' "; }
if($_REQUEST['east']>0) { $whereSearch2 .= " AND ads.east = '".mysql_real_escape_string($_REQUEST['east'])."' "; }
if($_REQUEST['west']>0) { $whereSearch2 .= " AND ads.west = '".mysql_real_escape_string($_REQUEST['west'])."' "; }

	
$_SESSION['last_search']=$_GET;

if($_GET['search']==1)$search_block=" 1=2 AND ";

 $main_q = $q = "SELECT ads.*,categories.title AS category FROM ads  LEFT JOIN categories ON categories.id = ".($userid==1?"ads.main_cat":"ads.category")." AND categories.userid='$userid' LEFT JOIN users ON ads.userid= users.id WHERE $search_block disabled = 0 ".($data_conf['main_site']!=1?" AND ads.userid='$userid' ":" AND only_in_store=0 AND (users.language='".$data_conf['language']."' OR users.language IS NULL)  ")." $whereSearch2 ";//
if ($_GET['debug']==1) echo $q;	

	
	if ($_GET['page']<1)$_GET['page'] = 1;
	
	if(substr($_REQUEST['title'],0,7)=="pazar 3") $order_b = " (ads.userid = 0) DESC,";
	if(substr($_REQUEST['title'],0,9)=="reklama 5") $order_b = " (ads.userid = 0) DESC,";
	if(substr($_REQUEST['title'],0,22)=="agencii za nedviznosti") $order_b = " (ads.userid > 0) DESC,";
$user_ads=$qry->querySelect($q . " ORDER BY $order_b ".($_REQUEST['title']!=''?"( MATCH (ads.title) AGAINST ('". str_replace(" "," ", mysql_real_escape_string($_REQUEST['title']))."' IN BOOLEAN MODE) ) DESC,":"")."order_score, (image1!='') DESC,id DESC LIMIT ".((mysql_real_escape_string($_GET['page'])-1)*$num_onpage).','.$num_onpage);
$cities = $qry->querySelect("SELECT ads.city,categories.title AS category,categories.url,COUNT(*) AS c FROM ads  LEFT JOIN categories ON categories.id = ".($userid==1?"ads.main_cat":"ads.category")." AND categories.userid='$userid' WHERE 1=1 ".($userid==1?"":" AND ads.userid ='$userid'")." GROUP BY city,categories.id ORDER BY COUNT(*) DESC LIMIT 8"); 

$numrows=$qry->numRows($q);

$pages = ceil($numrows/ $num_onpage); 

if($numrows==0){
    $canonical = 'https://imoti247.com/stanovi-skopje.htm';
}
/*if(sizeof($user_ads)==0)
{
	// ako nema reklami
	echo '<script language="javascript">window.location="/";</script>';
	// header ("Location: /");
	 exit();
}*/
for($i=0;$i<sizeof($user_ads);$i++){
 
 
  if($user_ads[$i]['type_id']==1) $type = $lang[1].' ';//"Продава ";
	  if($user_ads[$i]['type_id']==2) $type = $lang[2].' ';//"Издава ";
 	  if($user_ads[$i]['title']=='') $user_ads[$i]['title']=$type.translate($user_ads[$i]['category'],$lang['cat']).' '.$lang[3].' '.($user_ads[$i]['municipality']!=''?' '.$lang[4].' '.translate($user_ads[$i]['municipality'],$lang['municip']):translate($user_ads[$i]['city'],$lang['city']));
$user_ads[$i]['currency']=str_ireplace("eur","&euro;",$user_ads[$i]['currency']);
 $user_ads[$i]['url']=getSEO_URL(trim($user_ads[$i]["title"]),$user_ads[$i]["id"]);
// $prices=format_price($user_ads[$i]);
// $user_ads[$i]['price2_form']=$prices['price2'];
// $user_ads[$i]['precio_form']=$prices['precio'];
 

  }
  
  
//meta-data
$meta_title = ($_GET['type']==1?$lang[1].' ':($_GET['type']==2?$lang[2].' ':'')).
($_GET['cat']!=''?$_GET['cat']. " ":((trim($_GET['keyword'])!='')? (" ".ucfirst($_GET['title'])." "):(' недвижности '))).
($_GET['municipality']!=''?$lang[3]." ".$_GET['municipality']:($_GET['city']!=''?$lang[3]." ".$_GET['city']:''));

$meta_description =  ($_GET['type']==1?$lang[1].' ':($_GET['type']==2?$lang[2].' ':'')). " ". $numrows. " ".
($_GET['cat']!=''?$_GET['cat']. " ":((trim($_GET['keyword'])!='')? " ".ucfirst($_GET['title'])." ":' недвижности ')).
($_GET['city']!=''?$lang[3]." ".($_GET['municipality']!=''?$_GET['municipality'].", ":'').$_GET['city']:'').', Македонија се пронајдени во огласите за недвижности на '. $data_conf['name'] ;

$title = $meta_title;


if($keywords['title']!='') $title = $keywords['title'];
if($keywords['meta_title']!='')  $meta_title = $keywords['meta_title'];
if($keywords['meta_description']!='') $meta_description =  $numrows. " ". $keywords['meta_description'];

if($_REQUEST['cat']=='станови') {
	$_REQUEST['cat']='stanovi';
	if($keywords_request_data['cat']!='') $keywords_request_data['cat']='stanovi';
}

if($_REQUEST['city']=='Скопје') {
	$_REQUEST['city']='Skopje';
	if($keywords_request_data['city']!='') $keywords_request_data['city']='Skopje';
}

if($_GET['page']>1) { $meta_title .= ' - '. $_GET['page']; $meta_description .= ' - страна '. $_GET['page'];}
  
if($_GET['debug']==1)
{
	include "templates/".$data_conf['template']."/list2.php";
	exit;
}
include "templates/".$data_conf['template']."/list.php";

exit;
//ova nadole e samo primer kako da se stavi na /templates/1/list.php
/*
?>


            <div class="leftContBox"><div class="leftContPanel">
            	<h2 class="boxTitleTxt">Buscar</h2>
                 <div class="page_navigation" style="font-size:16px">
                <? $url = '/list.php?cat2='.$_GET['cat2'].'&abuscar='.$_GET['abuscar'].'&userid='.$_GET['userid'].'&domain='.$_GET['domain'];?>
              <? if ($_GET['page']>1) {?>  <a href="&page=1" >Prva</a>
              <a href="&page=15" >prethodna</a><? };?>

                <span style="display: none;">...</span>
                <? for ($i=1;$i<=$pages;$i++) {?>
                <a href="&page=" class="page_link<? if ($i == $_GET['page']) {?> active_page<? };?>" ></a>
                <? }; ?>
                <span class="ellipse more" style="display: none;">...</span>
                 <? if ($_GET['page']<$pages) {?><a href="&page=17" class="next_link">Sledna</a>
                 <a href="&page=" class="last_link">Posledna</a></div><? };?>
                <div class="thumbsnailPanel">
                <? for ($i=0;$i<sizeof($user_ads);$i++){
?>
                    <div class="eachThumbs">
                    <a href="/"><img