"0")
$categories = catree($row['cat']);
$categories .= "$fwasel".$row['name']."";
}
mysqli_free_result($query);
return $categories;
}
function catree2($id){
global $connect;
$categories = "";
$query = mysqli_query($connect,"SELECT id,cat,name FROM cat where cat=$id ");
while($row = mysqli_fetch_array($query)){
$categories .= catree2($row['id'])." or act like '%|".$row['id']."|%'";
}
mysqli_free_result($query);
return $categories;
}
if ($id == "" and $en == ""){
// header("Location: $urlsite");
}else{
if($en != ""){
if($fen != ""){
$qucat = "where en = '$fen' and cat != '0'";
$querycf = mysqli_query($connect,"SELECT id FROM cat $qucat");
if(mysqli_num_rows($querycf) > "1"){
$querycf2 = mysqli_query($connect,"SELECT id FROM cat where en = '$en' and cat = '0'");
while($rowcf = mysqli_fetch_array($querycf2))
$qucat = "where en = '$fen' and cat = '".$rowcf['id']."'";
mysqli_free_result($querycf2);
}
mysqli_free_result($querycf);
}else
$qucat = "where en = '$en' and cat = '0'";
}else{
$qucat = "where id = '$id'";
}
$querys = mysqli_query($connect,"SELECT * FROM cat $qucat");
$numcatt = mysqli_num_rows($querys);
if($numcatt == "1"){
$noleftmenu = "1";
mysqli_query($connect,"UPDATE cat set views=views+1 $qucat");
while($rows = mysqli_fetch_array($querys)){
$id = $rows['id'];
$idc = $rows['id'];
$namec = $rows['name'];
$name2c = $rows['name2'];
$enc = $rows['en'];
$aboutc = $rows['about'];
$msgcatc = $rows['msgcat'];
$picc = ic($rows['pic']);
$viewsc = $rows['views'];
$typec = $rows['t'];
$datec = td($rows['time']);
$queryn = mysqli_query($connect,"SELECT id,name,en FROM cat where id = '".$rows['cat']."'");
$numn = mysqli_num_rows($queryn);
$urlr = $urlsite;
$maincatna = $fwasel.$namesite;
$catsfr = "";
if($numn != "0"){
$catsfr = "and (";
$queryn2 = mysqli_query($connect,"SELECT id FROM cat where cat = '".$rows['cat']."' and id != '$id'");
while($rown2 = mysqli_fetch_array($queryn2))
$catsfr .= "act like '%|".$rown2['id']."|%' or ";
mysqli_free_result($queryn2);
$catsfr .= "act like '%|$id|%'";
while($rown = mysqli_fetch_array($queryn)){
$namemaincat = $rown['name'];
$maincatna = $fwasel.$rown['name'].$fwasel.$namesite;
$urlr = $urlsite.$rown['en']."/";
}
$catsfr .= ")";
}
mysqli_free_result($queryn);
}
mysqli_free_result($querys);
$catsforname = "";
$catsfornp = catree($id);
$ex = explode($fwasel,$catsfornp);
for($i=(count($ex)-1);$i>=1;$i--)
$catsforname .= "$ex[$i]$fwasel";
//////////// الاعلانات ///////////////
$queryhads = mysqli_query($connect,"SELECT ad FROM ads where type = '1' and cat = '$id' order by id ASC");
while($rowhads = mysqli_fetch_array($queryhads))
$headerads .= $rowhads[ad];
mysqli_free_result($queryhads);
$queryrids = mysqli_query($connect,"SELECT ad FROM ads where type = '2' and cat = '$id' order by id ASC");
while($rowrids = mysqli_fetch_array($queryrids))
$rightmenuads .= $rowrids[ad];
mysqli_free_result($queryrids);
$queryleds = mysqli_query($connect,"SELECT ad FROM ads where type = '3' and cat = '$id' order by id ASC");
while($rowleds = mysqli_fetch_array($queryleds))
$leftmenuads .= $rowleds[ad];
mysqli_free_result($queryleds);
$queryfads = mysqli_query($connect,"SELECT ad FROM ads where type = '4' and cat = '$id' order by id ASC");
while($rowfads = mysqli_fetch_array($queryfads))
$footerads .= $rowfads[ad];
mysqli_free_result($queryfads);
//////////// نهاية الاعلانات ///////////////
if($msgcatc != "")
$msgcat = $msgcatc;
$acts = "";
$acts2 = "";
$query2 = mysqli_query($connect,"SELECT * FROM cat where cat = '$id' and h = 0 order by `order` ASC");
while($row2 = mysqli_fetch_array($query2)){
$icats[] = array("id"=>$row2['id'],"name"=>$row2['name'],"about"=>$row2['about'],"link"=>$urlsite.$enc."/".$row2['en']."/","pic"=>ic($row2['pic']),"views"=>$row2['views'],"date"=>td($row2['time']));
$acts .= " or act like '%|".$row2['id']."|%'";
$acts2 .= " or cat = '".$row2['id']."'";
}
mysqli_free_result($query2);
/*
$querylath = mysqli_query($connect,"SELECT id,title,about FROM thing where ok = 1 $catsfr order by time DESC limit $numlastthingsall");
if(mysqli_num_rows($querylath) != "0"){
$lastthings = array();
while($rowlath = mysqli_fetch_array($querylath)){
$lastthings[] = array("id"=>$rowlath[id],"title"=>$rowlath[title],"about"=>strip_tags($rowlath[about]));
}
}else{
$namemaincat = "";
}
mysqli_free_result($querylath);
*/
if ($_GET["npage"] == "" or $_GET["npage"] == "0"){
$npage = 1;
}else{
$npage = $_GET["npage"];
}
if($getajax != "" and $nextpage != "")
$npage = $nextpage;
//$amrsql = "act like '%|$id|%'$acts";
$amrsql = "act like '%|$id|%'".catree2($id);
$frommaxinpage=($thingsinpage*$npage)-$thingsinpage;
$querytoshowsites = mysqli_query($connect,"SELECT * FROM thing where ($amrsql) and ok = '1' order by time DESC limit ".$frommaxinpage.",".$thingsinpage);
$numthisth = 0;
while($row3 = mysqli_fetch_array($querytoshowsites)){
$numthisth ++;
$things[] = array("id"=>$row3['id'],"title"=>$row3['title'],"pic"=>spic($row3['pic']),"date"=>td($row3['rtime'],1,$limittimeshow),"price"=>$row3['branch']);
}
mysqli_free_result($querytoshowsites);
if($numthisth == $thingsinpage)
$morepage = "الصفحة التالية ";
if($npage != 1 or $morepage != ""){
$morepages = 1;
if($npage != 1)
$ppage = "الصفحة السابقة ";
}
}else{
// header("Location: $urlsite");
}
}
$np = "$ornamesite".$catsfornp;
$namesite = strip_tags($catsforname.$ornamesite);
$description = $namec." ".$aboutc;
$keywords = str_replace(array("
"," "),array(" ",","),$namec." ".$aboutc);
if($name2c != "")
$namesite = $name2c;
if($npage != "" and $npage != "1" and $npage != "0")
$namesite = $namesite." - صفحة $npage";
if($getajax != ""){
echo $tpl->display($ftemplets,"cat.html");
}else{
echo $tpl->display($ftemplets,"header.html");
echo $tpl->display($ftemplets,"menur.html");
echo $tpl->display($ftemplets,"cat.html");
echo $tpl->display($ftemplets,"menul.html");
echo $tpl->display($ftemplets,"footer.html");
}
mysqli_close ($connect);
?>