window.location="'.$domain.$appname.'/";'; }; filtercat(getdirectory($HTTP_SERVER_VARS["REQUEST_URI"])); //START PROGRAM include($domain.'/inc/header.php'); echo "

---

".$cleandirpath."
"; dbdirectory(); echo "

---

"; dblisting(); echo "

---

"; location(); include($domain.'/inc/footer.php'); //////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////// //fetch url function getdirectory($url) { global $domain,$cat,$expl; $n = count(explode("/",$domain)); $expl = explode("/",urldecode($url)); $dir = ""; for ($i=1;$i<=count($expl)-$n+1;$i++) { if($i>=1 && $expl[$n+($i-2)]<>""){ $cat[$i-1]=$expl[$n+($i-2)]; $dir .= "||".$cat[$i-1]; }; }; return $dir; }; //filter url (country/city/directory) function filtercat($dir){ global $cleandir,$html,$cleandirpath,$cleandirurl,$domain,$appname; $html = ""; $expl = explode("||",urldecode($dir)); $a = 0; for ($i=1;$i"m." && substr($expl[$i],0,2)<>"c." && substr($expl[$i],0,2)<>"r." && substr($expl[$i],0,2)<>"y." && substr($expl[$i],strlen($expl[$i])-5,5)<>".html") { $a++; $cleandir[$a]=$expl[$i];}; }; $cleandirurl=""; $cleandirpath="".$appname.""; for ($i=1;$i<=count($cleandir);$i++) { $cleandirurl .= "/".$cleandir[$i]; $cleandirpath .= " || ".$cleandir[$i].""; }; }; //db id of parent(last expl) function dbdirectory(){ global $idcategory,$conn,$database_conn,$domain,$appname,$cleandir,$html,$dbprefix,$dirname; if(count($cleandir)>0){ $catsearch = "WHERE ( "; for ($i=1;$i<=count($cleandir);$i++) { if($cleandir[$i]){$catsearch .= "`category` = '".$cleandir[$i]."'";}; if(@$cleandir[$i+1]){$catsearch .= " OR ";}; }; $catsearch .= ") "; $query_rs_idcategory = "SELECT `".$dbprefix."category`.`id` FROM `".$dbprefix."category` ".$catsearch; if( count($cleandir) >= 2) { $query_rs_idcategory .= " AND `parent` IN ( SELECT `".$dbprefix."category`.`id` FROM `".$dbprefix."category` ".$catsearch.")"; }; $query_rs_idcategory .= " ORDER BY `id` DESC LIMIT 1"; $rs_idcategory = mysql_query($query_rs_idcategory, $conn) or die(mysql_error()); $row_rs_idcategory = mysql_fetch_assoc($rs_idcategory); if($row_rs_idcategory['id']>0){$idcategory = $row_rs_idcategory['id'];} ; }; $query_rs_child = "SELECT * FROM `".$dbprefix."category` WHERE (`".$dbprefix."category`.`parent` = ".$idcategory.") ORDER BY `".$dbprefix."category`.`category`"; $rs_child = mysql_query($query_rs_child, $conn) or die(mysql_error()); $row_rs_child = mysql_fetch_assoc($rs_child); do{ $url = $row_rs_child['category']."/".$row_rs_child['category'].".html"; echo "".$row_rs_child['category']."
"; } while ($row_rs_child = mysql_fetch_assoc($rs_child)); }; function urlfilter($addurl){ global $HTTP_SERVER_VARS,$domain,$appname,$mapreference,$region,$city,$region,$country; $url = $HTTP_SERVER_VARS["REQUEST_URI"].$addurl; $url = str_replace("///","/",$url); $url = str_replace("//","/",$url); $expl = explode("/",urldecode($url)); $a = 0; for ($i=1;$i"m." && substr($expl[$i],0,2)<>"c." && substr($expl[$i],0,2)<>"r." && substr($expl[$i],0,2)<>"y." && substr($expl[$i],strlen($expl[$i])-5,5)<>".html") { $a++; $cleandir[$a]=$expl[$i];}; }; @$cleandirurl = $domain.$appname; if($mapreference<>""){$cleandirurl .= "/m.".$mapreference;}; if($country<>""){$cleandirurl .= "/c.".$country;}; if($region<>""){$cleandirurl .= "/r.".$region;}; if($city<>""){$cleandirurl .= "/y.".$city;}; for ($i=3;$i<=count($cleandir);$i++) { $cleandirurl .= "/".$cleandir[$i]; }; @$cleandirurl.="/".$html; return $cleandirurl; }; //location function location(){ global $conn,$database_conn,$dbprefix,$numlocation; $countrypath = "Location || "; if(getlocation('m')<>""){$countrypath .= "".getlocation('m')." || ";}; if(getlocation('m')<>"" && getlocation('c')<>""){$countrypath .= "".getlocation('c')." || ";}; if(getlocation('m')<>"" && getlocation('c')<>"" && getlocation('r')<>""){$countrypath .= "".getlocation('r')."";}; if(getlocation('m')<>"" && getlocation('c')<>"" && getlocation('r')<>"" && getlocation('y')<>""){$countrypath .= "|| ".getlocation('y')."";echo $countrypath."
";}; $countrypath .= "
"; $lockey = ""; if(getlocation('m')==""){ $query_rs_loc = "SELECT DISTINCT `".$dbprefix."countries`.`MapReference` FROM `".$dbprefix."countries` ORDER by `MapReference`"; if($numlocation==1){$query_rs_loc = "SELECT `MapReference`,COUNT(`Country`) as `cnt` FROM ( SELECT DISTINCT `".$dbprefix."countries`.`MapReference`, `".$dbprefix."countries1`.`Country` FROM `".$dbprefix."countries` INNER JOIN `".$dbprefix."countries` `".$dbprefix."countries1` ON (`".$dbprefix."countries`.`MapReference` = `".$dbprefix."countries1`.`MapReference`) ORDER BY `".$dbprefix."countries`.`MapReference`, `".$dbprefix."countries1`.`Country` ) as `1` GROUP by MapReference";}; $lockey = "MapReference"; }elseif(getlocation('m')<>"" && getlocation('c')==""){ $query_rs_loc = "SELECT `".$dbprefix."countries`.`Country` FROM `".$dbprefix."countries` WHERE (`".$dbprefix."countries`.`MapReference` = '".getlocation('m')."') ORDER BY `".$dbprefix."countries`.`Country`"; if($numlocation==1){$query_rs_loc = "SELECT `".$dbprefix."countries`.`Country`, COUNT(`".$dbprefix."regions`.`RegionID`) AS `cnt` FROM `".$dbprefix."countries` INNER JOIN `".$dbprefix."regions` ON (`".$dbprefix."countries`.`CountryId` = `".$dbprefix."regions`.`CountryID`) WHERE (`".$dbprefix."countries`.`MapReference` = '".getlocation('m')."') GROUP BY `".$dbprefix."countries`.`Country` ";}; $lockey = "Country"; }elseif(getlocation('m')<>"" && getlocation('c')<>"" && getlocation('r')==""){ $query_rs_loc = "SELECT `".$dbprefix."regions`.`Region` FROM `".$dbprefix."regions` WHERE (`".$dbprefix."regions`.`CountryID` = ".getidcountry().") ORDER BY `".$dbprefix."regions`.`Region` "; if($numlocation==1){$query_rs_loc = "SELECT `".$dbprefix."regions`.`Region`, COUNT(`".$dbprefix."cities`.`CityId`) AS `cnt` FROM `".$dbprefix."regions` LEFT OUTER JOIN `".$dbprefix."cities` ON (`".$dbprefix."regions`.`RegionID` = `".$dbprefix."cities`.`RegionID`) WHERE (`".$dbprefix."regions`.`CountryID` = ".getidcountry().") GROUP BY `".$dbprefix."regions`.`Region` ";}; $lockey = "Region"; }elseif(getlocation('m')<>"" && getlocation('c')<>"" && getlocation('r')<>"" && getlocation('y')==""){ $query_rs_loc = "SELECT `".$dbprefix."cities`.`City` FROM `".$dbprefix."cities` WHERE (`".$dbprefix."cities`.`RegionID` = ".getidregion().") ORDER BY `".$dbprefix."cities`.`City` "; if($numlocation==1){$query_rs_loc = "SELECT `".$dbprefix."cities`.`City` FROM `".$dbprefix."cities` WHERE (`".$dbprefix."cities`.`CountryID` = ".getidcountry().") AND (`".$dbprefix."cities`.`RegionID` = ".getidregion().")";}; $lockey = "City"; }; if($lockey<>""){ $rs_loc = mysql_query($query_rs_loc, $conn) or die(mysql_error()); $row_rs_loc = mysql_fetch_assoc($rs_loc); do { if($lockey=='MapReference'){$locurl = urlfilter('/m.'.$row_rs_loc[$lockey]);}; if($lockey=='Country'){$locurl = urlfilter('/m.'.getlocation('m').'/c.'.$row_rs_loc[$lockey]);}; if($lockey=='Region'){$locurl = urlfilter('/m.'.getlocation('m').'/c.'.getlocation('c').'/r.'.$row_rs_loc[$lockey]);}; if($lockey=='City'){$locurl = urlfilter('/m.'.getlocation('m').'/c.'.getlocation('c').'/r.'.getlocation('r').'/y.'.$row_rs_loc[$lockey]);}; if($lockey<>'City'){$locnum = @$row_rs_loc['cnt'];}else{$locnum=0;}; $locname = @$row_rs_loc[$lockey]; $countrypath .= "".$locname.""; if($locnum>0){$countrypath .= "(".$locnum.")";}; $countrypath .= " | "; } while ($row_rs_loc = mysql_fetch_assoc($rs_loc)); echo $countrypath; }; }; function getlocation($loc){ global $HTTP_SERVER_VARS; $url = $HTTP_SERVER_VARS["REQUEST_URI"]; $expl = explode("/",urldecode($url)); $a = 0; for ($i=1;$i

"; echo "CATEGORY: ".$idcategory." - ".strtoupper(getcatname($idcategory))." "; echo "MapReference: ".getlocation('m')." "; echo "Country: ".getlocation('c')." "; echo "Region: ".getlocation('r')." "; echo "City: ".getlocation('y')." "; echo " place your ads here"; ?>

0){$query_rs_dblisting.=" AND `mapreference` = '".getlocation('m')."'";}; if(strlen(getlocation('c'))>0){$query_rs_dblisting.=" AND `country` = '".getlocation('c')."'";}; if(strlen(getlocation('r'))>0){$query_rs_dblisting.=" AND `region` = '".getlocation('r')."'";}; if(strlen(getlocation('y'))>0){$query_rs_dblisting.=" AND `city` = '".getlocation('y')."'";}; $query_rs_dblisting.= " AND (`".$dbprefix."listing`.`idcategory` IN (".querydblisting().")) "; $rs_dblisting = mysql_query($query_rs_dblisting, $conn) or die(mysql_error()); $row_rs_dblisting = mysql_fetch_assoc($rs_dblisting); $totalRows_rs_dblisting = mysql_num_rows($rs_dblisting); echo $totalRows_rs_dblisting." found "; do { echo $row_rs_dblisting['id']." - ".$row_rs_dblisting['idcategory']." - ".$row_rs_dblisting['mapreference']." - ".$row_rs_dblisting['country']." - ".$row_rs_dblisting['region']." - ".$row_rs_dblisting['city']." "; } while ($row_rs_dblisting = mysql_fetch_assoc($rs_dblisting)); ?>