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 ''; // header ("Location: /"); exit(); }*/ for($i=0;$i1) { $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 /* ?>

Buscar