Anunturi »
Anunturi ".$detalii_categorie[0]["nume"];
}
elseif(isset($_REQUEST['id_categorie']) && isset($_REQUEST['id_subcategorie']) && !isset($_REQUEST['id_subsubcategorie'])){
$id_categorie = sql_sanitize($_REQUEST['id_categorie']);
$id_subcategorie = sql_sanitize($_REQUEST['id_subcategorie']);
$id_categorie = str_replace("anunturi/","", $id_categorie);
$link_sus = $webPath . "anunturi/".$id_categorie ."/". $id_subcategorie."/";
$query="SELECT a.*,b.id as id_cat, b.nume as nume_categorie
from subcategorii a
left join categorii b on a.id_categorie = b.id
WHERE lower(replace(a.nume,' ' ,'-'))='$id_subcategorie' and lower(replace(b.nume,' ' ,'-'))='$id_categorie'
limit 1";
$detalii_subcategorie = query2array($query, $conn);
$id_cat = $detalii_subcategorie[0]["id_cat"];
$id_subcat = $detalii_subcategorie[0]["id"];
$query="SELECT a.*,b.nume as nume_categorie
from subcategorii a
left join categorii b on a.id_categorie = b.id
WHERE a.id_categorie='".$detalii_subcategorie[0]["id_cat"]."'
ORDER BY a.nume ASC";
$meniuSubcategorii = query2array($query, $conn);
$query="SELECT a.*, b.nume as nume_categorie, c.nume as nume_subcategorie
from subsubcategorii a
left join categorii b on a.id_categorie = b.id
left join subcategorii c on a.id_subcategorie = c.id
WHERE a.id_subcategorie='".$detalii_subcategorie[0]["id"]."'
ORDER BY a.nume ASC";
$meniuSubsubcategorii = query2array($query, $conn);
if(count($meniuSubsubcategorii)>0){$exista_subsubcategorie = TRUE;}
$conditie_query = "WHERE categ = '".$detalii_subcategorie[0]["id_categorie"]."' and subcateg = '".$detalii_subcategorie[0]["id"]."'";
$nume_categorie = $detalii_subcategorie[0]["denumire_lung"];
$title = "Anunturi ".$detalii_subcategorie[0]["nume_categorie"]." ".$detalii_subcategorie[0]["nume"];
$keywords = "anunturi ".strtolower($detalii_subcategorie[0]["nume_categorie"]).", ".strtolower($detalii_subcategorie[0]["nume"]);
$description = "Anunturi ".$detalii_subcategorie[0]["nume_categorie"]." ".$detalii_subcategorie[0]["nume"];
$detalii_subcategorie[0]["link_categorie"] = str_replace(" ","-", strtolower($detalii_subcategorie[0]["nume_categorie"]));
$breadcrumbs = "Anunturi »
".$detalii_subcategorie[0]["nume_categorie"]." »
".$detalii_subcategorie[0]["nume"];
}
elseif(isset($_REQUEST['id_categorie']) && isset($_REQUEST['id_subcategorie']) && isset($_REQUEST['id_subsubcategorie'])){
$id_categorie = $_REQUEST['id_categorie'];
$id_subcategorie = $_REQUEST['id_subcategorie'];
$id_subsubcategorie = $_REQUEST['id_subsubcategorie'];
$id_categorie = str_replace("anunturi/","", $id_categorie);
$link_sus = $webPath . "anunturi/".$id_categorie ."/". $id_subcategorie."/". $id_subsubcategorie."/";
$query="SELECT a.*, b.id as id_cat, c.id as id_subcat, b.nume as nume_categorie, c.nume as nume_subcategorie
from subsubcategorii a
left join categorii b on a.id_categorie = b.id
left join subcategorii c on a.id_subcategorie = c.id
WHERE lower(replace(a.nume,' ' ,'-'))='$id_subsubcategorie' and lower(replace(b.nume,' ' ,'-'))='$id_categorie' and lower(replace(c.nume,' ' ,'-'))='$id_subcategorie'
limit 1";
$detalii_subsubcategorie = query2array($query, $conn);
$id_cat = $detalii_subsubcategorie[0]["id_cat"];
$id_subcat = $detalii_subsubcategorie[0]["id_subcat"];
$id_subsubcat = $detalii_subsubcategorie[0]["id"];
$query="SELECT a.*,b.nume as nume_categorie
from subcategorii a
left join categorii b on a.id_categorie = b.id
WHERE a.id_categorie='".$detalii_subsubcategorie[0]["id_cat"]."'
ORDER BY a.nume ASC";
$meniuSubcategorii = query2array($query, $conn);
$query="SELECT a.*, b.nume as nume_categorie, c.nume as nume_subcategorie
from subsubcategorii a
left join categorii b on a.id_categorie = b.id
left join subcategorii c on a.id_subcategorie = c.id
WHERE a.id_subcategorie='".$detalii_subsubcategorie[0]["id_subcat"]."'
ORDER BY a.nume ASC";
$meniuSubsubcategorii = query2array($query, $conn);
if(count($meniuSubsubcategorii)>0){ $exista_subsubcategorie = TRUE;}
$conditie_query = "WHERE categ = '".$detalii_subsubcategorie[0]["id_cat"]."' and subcateg = '".$detalii_subsubcategorie[0]["id_subcat"]."' and subcateg2 = '".$detalii_subsubcategorie[0]["id"]."'";
$nume_categorie = $detalii_subsubcategorie[0]["denumire_lung"];
$title = "Anunturi ".$detalii_subsubcategorie[0]["nume_categorie"]." ".$detalii_subsubcategorie[0]["nume_subcategorie"]." ".$detalii_subsubcategorie[0]["nume"];
$keywords = "anunturi ".strtolower($detalii_subsubcategorie[0]["nume_categorie"]).", ".strtolower($detalii_subsubcategorie[0]["nume_subcategorie"]).", ".strtolower($detalii_subsubcategorie[0]["nume"]);
$description = "Anunturi ".$detalii_subsubcategorie[0]["nume_categorie"]." ".$detalii_subsubcategorie[0]["nume_subcategorie"]." ".$detalii_subsubcategorie[0]["nume"];
$detalii_subsubcategorie[0]["link_categorie"] = str_replace(" ","-", strtolower($detalii_subsubcategorie[0]["nume_categorie"]));
$detalii_subsubcategorie[0]["link_subcategorie"] = str_replace(" ","-", strtolower($detalii_subsubcategorie[0]["nume_subcategorie"]));
$breadcrumbs = "Anunturi »
".$detalii_subsubcategorie[0]["nume_categorie"]." »
".$detalii_subsubcategorie[0]["nume_subcategorie"]." »
".$detalii_subsubcategorie[0]["nume"];
}
$tpl->assign("id_cat",$id_cat);
$page = $_REQUEST["page"];
if (!isset($page)) { $page = 1;}
$adjacents = 3;
$query = "select count(*) as count from anunt_post $conditie_query and vizibil='1'";
$res = query2array($query, $conn);
$total_pages = $res[0]["count"];
$limit = 10;
$i_max = $limit;
$i_min = ($page - 1) * $limit;
if($page > 1){
$i_limit = "offset $i_min limit $i_max";
}else{
$i_limit = "limit $i_max";
}
$query = "SELECT a.id, data, titlu,anunt,pret,denumire_oras,platit,
den_moneda,telefon,short_judet,vizibil,categ,subcateg,subcateg2,c.nume as nume_categorie,d.nume as nume_subcategorie,e.nume as nume_subsubcategorie
FROM anunt_post a
LEFT JOIN anunt_pers b ON a.id_pers=b.id
LEFT JOIN categorii c ON a.categ=c.id
LEFT JOIN subcategorii d ON a.subcateg=d.id
LEFT JOIN subsubcategorii e ON a.subcateg2=e.id
LEFT JOIN anunt_moneda f ON a.moneda=f.id_moneda
LEFT JOIN anunt_judet g ON a.id_judet=g.id
LEFT JOIN anunt_oras h ON a.localitate2=h.id
$conditie_query and a.vizibil='1'
ORDER BY platit DESC, id DESC $i_limit";
$anunturi = query2array($query, $conn);
//echo $query;
//print_r($anunturi);
for($i=0;$i0){
if(!is_null($imagine_id[0]["id"])){
$id_imagine = $imagine_id[0]["id"];
$query = "SELECT * from imagini where id='$id_imagine' limit 1";
$imagine_anunt = query2array($query, $conn);
$fileParts[0]["data"] = pathinfo($imagine_anunt[0]["nume_fisier"]);
list($width, $height, $type, $attr) = getimagesize($fileSave.$fileSaveThumb.$imagine_anunt[0]["nume"]);
$anunturi[$i]["imagine_dimensiuni"] = $attr;
$anunturi[$i]["extensie_imagine"] = $fileParts[0]["data"]["extension"];
$anunturi[$i]["id_imagine"] = $id_imagine;
}
}
$anunturi[$i]["titlu_rescris"] = replace(strtolower($anunturi[$i]["titlu"]));
$position=100;
$limit_anunt=substr($anunturi[$i]["anunt"], 0, $position);
$search = array("•", "€","“","”","„","—","–","‘","’","â","ã","î","ê","²","ș","ț");
$replace= array("•","€","“","”","„","—","–","‘","’","â","ã","î","ê","²","ș","ț");
$anunturi[$i]["categorie"] = str_replace(" ","-", strtolower($anunturi[$i]["nume_categorie"]));
$anunturi[$i]["subcategorie"] = str_replace(" ","-", strtolower($anunturi[$i]["nume_subcategorie"]));
$anunturi[$i]["subsubcategorie"] = str_replace(" ","-", strtolower($anunturi[$i]["nume_subsubcategorie"]));
$anunturi[$i]["anunt_mic"] = str_replace($search, $replace, $limit_anunt);
}
if(count($anunturi)>0){$sunt_anunturi = TRUE;}
for($i=0;$i 0){
$lastpage = ceil($total_pages/$limit);
}
$lpm1 = $lastpage - 1;
$pagination = "";
if($lastpage > 1)
{
$pagination .= "\n";
}
if($page == 1){
$nr_pagina = "";
}else{
$nr_pagina = " - Pagina ".$page;
}
$pagina = "categorii";
$tpl->assign("pagination",$pagination);
$tpl->assign("meniu_subcategorii",$meniuSubcategorii);
$tpl->assign("meniu_subsubcategorii",$meniuSubsubcategorii);
$tpl->assign("webPath",$webPath);
$tpl->assign("anunturi",$anunturi);
$tpl->assign("nume_categorie",$nume_categorie);
$tpl->assign("sunt_anunturi",$sunt_anunturi);
$tpl->assign("id_cat",$id_cat);
$tpl->assign("id_subcat",$id_subcat);
$tpl->assign("id_subsubcat",$id_subsubcat);
$tpl->assign("exista_subsubcategorie",$exista_subsubcategorie);
$tpl->assign("breadcrumbs",$breadcrumbs);
$tpl->assign("pagina",$pagina);
$tpl->assign("title",$title.$nr_pagina);
$tpl->assign("keywords",$keywords);
$tpl->assign("description",$description.$nr_pagina);
$tpl->display("categorie.tpl");
?>