<?php session_start();
require_once('system/configdb.php'); // Call Database
require_once('system/functions.php'); // Call Functions
include('system/catmap.php'); // Call Category Mapper
include('classes/paginator.class.2.php');

$targetcity	= $_SESSION['targcity'];
$targetstate = $_SESSION['targstate'];
$zip = $_SESSION['zip'];
$dis = $_SESSION['dis'];
$citycenter = $_SESSION['citycenter'];
$citylist = $_SESSION['citylist'];
$citystate = $_SESSION['citystate'];

$lat = $_SESSION['lat'];
$long = $_SESSION['long'];

$latmin = $_SESSION['latmin'];
$latmax = $_SESSION['latmax'];
$longmin = $_SESSION['longmin'];
$longmax = $_SESSION['longmax'];

$backtime = strtotime("last week");

if(!$_COOKIE["ztgrid"]){setcookie("ztgrid",$_REQUEST['grid'], time()+3600*24*90,"/"); $setgrid=$_REQUEST['grid'];} elseif($_REQUEST['grid']!=''){setcookie("ztgrid",$_REQUEST['grid'], time()+3600*24*90,"/"); $setgrid=$_REQUEST['grid'];} else {$setgrid=$_COOKIE['ztgrid'];}

/* if (isset($_SERVER['HTTP_REFERER']))
{
      $array = parse_url($_SERVER['HTTP_REFERER']);
      $chkhost = $array['host'];
}
if($chkhost != "www.zippytrader.com"){
$cty = str_replace("-"," ",scrub($_REQUEST['cty'],"T"));
mysql_select_db($dbname,$dbc) or die(mysql_error());
$bmquerycz = "SELECT zipcode FROM zipcodes WHERE city = '".scrub($cty,"S")."' AND state = '".scrub($_REQUEST['st'],"S")."' LIMIT 1";
$resultcz=mysql_query($bmquerycz) or die('CZ '.mysql_error());
$row = mysql_fetch_assoc($resultcz);
$cty2zip = $row['zipcode'];
setcookie("ztzip",$cty2zip, time()+3600*24*90,"/");
$dis = 30; $_SESSION['dis'] = $dis; include('system/getcities.php');}
// if($zip == 'ERROR'){$zip='';}
*/

if(isset($_GET['cty'])){if($_GET['cty'] != strtolower(str_replace(" ","-",$targetcity))){
$cty = str_replace("-"," ",scrub($_REQUEST['cty'],"T"));
mysql_select_db($dbname,$dbc) or die(mysql_error());
$bmquerycz = "SELECT zipcode FROM zipcodes WHERE city = '".scrub($cty,"S")."' AND state = '".scrub($_REQUEST['st'],"S")."' LIMIT 1";
$resultcz=mysql_query($bmquerycz);
$row = mysql_fetch_assoc($resultcz);
$zip = $row['zipcode'];
setcookie("ztzip",$zip, time()+3600*24*90,"/");
include('system/getcities.php');
}
}


$selecat = scrub($_GET['cid'],"T");

mysql_select_db($dbname,$dbc) or die(mysql_error());
$bmquerycm = "SELECT t1.category_id as catID, t1.categoryname as catNAME, t1.parent_id as parID, t1.oodle, t2.categoryname as parNAME, t1.duration, t1.restricted, t1.tabname, t1.pagetitle FROM categories as t1
LEFT JOIN categories as t2 on t1.parent_id = t2.category_id
WHERE t1.category_id = '".scrub($catmap[$selecat],"S")."' ";

$resultcm=mysql_query($bmquerycm) or die('CAT '.mysql_error()); 

$row = mysql_fetch_assoc($resultcm);

$catID = $row['catID'];
$catNAME = $row['catNAME'];
$specparent = $row['parID'];
$parNAME = $row['parNAME'];
$ctable = $row['tabname'];
$titleadd = $row['pagetitle'];
$oodlecat = $row['oodle'];

$bancat = $catID;

mysql_select_db($dbname,$dbc) or die(mysql_error());
$query = "SELECT COUNT(*) FROM listings 
WHERE (latitude BETWEEN ".scrub($latmin,"S")." AND ".scrub($latmax,"S").") AND (longitude BETWEEN ".scrub($longmin,"S")." AND ".scrub($longmax,"S").") AND categoryID='".scrub($catID,"S")."' AND verified=1 AND approved=1 AND suspend=0 AND (stopdate >= CURDATE())"; 

$result = mysql_query($query) or die('COUNT '.mysql_error());
$num_rows = mysql_fetch_row($result);


$pages = new Paginator;
$pages->items_per_page = 25;
$pages->items_total = $num_rows[0];
$pages->mid_range = 5; // Number of pages to display. Must be odd and > 3
$pages->paginate();

if($num_rows[0] == 0){
$limit = ""; $nolist = 1;
}else{
$limit = $pages->limit;
}

$bmquerylist = "SELECT  t1.listingID, t1.title, t1.state, t1.city, t1.description, t1.categoryID, t1.parentID, t1.oldID, t1.city_state, t1.type, t1.price, date_format(t1.startdate,'%b %e') as addate, t1.latitude, t1.longitude, t2.photoID, t2.filename, t3.filename as oldfile FROM listings as t1
LEFT JOIN photos as t2 ON t1.parentID=t2.parentID AND t1.listingID=t2.listingID
LEFT JOIN photos as t3 ON t1.parentID=t3.parentID AND t1.oldID=t3.listingID
WHERE (((t1.latitude BETWEEN ".scrub($latmin,"S")." AND ".scrub($latmax,"S").") AND (t1.longitude BETWEEN ".scrub($longmin,"S")." AND ".scrub($longmax,"S").")) OR t1.zipcode='99999') AND t1.categoryID=".scrub($catID,"S")." AND t1.approved=1 AND t1.suspend=0 AND t1.verified=1 AND (t1.stopdate >= CURDATE()) GROUP BY t1.listingID ORDER BY t1.startdate DESC $limit"; 
$resultlist=mysql_query($bmquerylist) or die('LIST '.mysql_error());
while($row=mysql_fetch_assoc($resultlist)) {
$listingID = $row['listingID'];
$title = $row['title'];
$lstate = $row['state'];
$lcity = $row['city'];
$description = $row['description'];
$photoID = $row['photoID'];
$filename = $row['filename'];
$oldfile = $row['oldfile'];
$parentID = $row['parentID'];
$oldID = $row['oldID'];
$adcitystate = $row['city_state'];
$type = $row['type'];
$price = $row['price'];
$addate = $row['addate'];
$listlat = $row['latitude'];
$listlong = $row['longitude'];

$description = stripslashes(scrub($description,'T'));

$description = stripslashes(scrub($description,'T'));
$description = str_replace('[WEBURL]','',$description);
$description = preg_replace('[\[/WEBURL\](.*)\[/LINKTEXT\]]','',$description);

$title = stripslashes(scrub($title,'T'));

if($oldfile!=''){$filename=$oldfile;}

switch ($type)
{
case 1: $showprice = "$".number_format($price,2);
  break;
case 2: $showprice = "FREEBIE"; $taddon = "FREE! ";
  break;
case 3: $showprice = "Trade/Barter";
  break;
case 4: $showprice = "WANTED"; $taddon = "WANTED: ";
  break;
case 5: $showprice = "Please Contact";
  break;
}

$cdist = number_format(DistanceCalc($lat,$long,$listlat,$listlong,"M"),2);

$linkcity = txt2lnk($lcity);

$linkstate = txt2lnk($lstate);

$linktitle = ptxt2lnk($title);


if($setgrid==1){
if($filename!=''){$fill = "<img src='../photos/".$filename."' class='gridthumb'>";} else {$fill = "<div class='gridfill'>No<br />Photo<br/>Available</div>";}

$listings .= "<div class='griddiv' onClick=\"window.location='http://www.zippytrader.com/".$linkstate."/".$linkcity."/".$selecat."/".$linktitle."-L".$listingID.".html'\" style='cursor: pointer;'>
<div class='gridthumb'>".$fill."</div>
<div style='clear:both;'><p class='gridtitle'><a href='".$linkstate."/".$linkcity."/".$selecat."/".$linktitle."-L".$listingID.".html'>".$taddon.trunc($title,50)."</a></p></div>
<p class='gridprice'>".$showprice."</p><p class='gridloc'>".$adcitystate." - ".$cdist." miles&emsp;".$addate."</p>
</div>"; $taddon='';}

else {

if($filename!=''){$fill = "<img src='../thumbs/".$filename."' class='thumbs2'>";} else {$fill = "<div class='fill'>No<br />Photo</div>";}

$listings .= "<div class='listrow' onClick=\"window.location='http://www.zippytrader.com/".$linkstate."/".$linkcity."/".$selecat."/".$linktitle."-L".$listingID.".html'\" style='cursor: pointer;'>
<div class='listthumb'>".$fill."</div>
<div class='listcontent'><p class='listtitle'><a href='".$linkstate."/".$linkcity."/".$selecat."/".$linktitle."-L".$listingID.".html'>".$taddon.trunc($title,50)."</a></p><p class='listdesc'>".trunc(stripslashes($description),175)."</p></div>
<div class='listpricebox'>
<p class='listprice'>".$showprice."</p><p class='listloc'>".$adcitystate."<br />".$cdist." miles&emsp;".$addate."</p></div>
</div>"; $taddon='';}
} 

if($nolist == 1){ $listings = "<p style='text-align:justify;font-size:13px;color:#000000;margin:10px;' class='nolinks'><b>We currently have no ads for this zip code, however, we searched for similar ads on other sites and displayed any results below. We're still growing, so please try us again. Thanks!</b>&emsp;<span style='font-size:8px;'>Courtesy ad search powered by <a href=\"http://oodle.com\" target=\"_blank\">Oodle.com</a></span></p>";

$rurl = "http://api.oodle.com/api/v2/listings?key=CB8B990386B6&region=usa&location=".$zip."&radius=".$dis."&category=".$oodlecat."&num=15&num_images=1&image_sizes=s&sort=distance&ctime_low=".$backtime."&exclude_sources=everycarlisted-bronze,everycarlisted-gold,everycarlisted-silver&format=php_serial";

$ooresponse = file_get_contents($rurl);
$oodata = unserialize($ooresponse);
// echo $rurl;

// $rssin =  simplexml_load_file("http://api.oodle.com/api/v2/listings?key=CB8B990386B6&region=usa&location=".$zip."&radius=30&category=".$oodlecat."&num=9&num_images=1&image_sizes=s&sort=distance&ctime_low=".$backtime."&php_export");
// echo "http://api.oodle.com/api/v2/listings?key=CB8B990386B6&region=usa&location=".$zip."&radius=30&category=".$oodlecat."&num=25&num_images=1&image_sizes=s&sort=distance&ctime_low=".$backtime."&format=php_export";


// Here we'll put a loop to include each item's title and description
foreach ($oodata['listings'] as $listing) {

$linkcity = txt2lnk($listing['location']['name']);

$linkstate = txt2lnk($listing['location']['state']);

$linktitle = ptxt2lnk($listing['title']);

// $linkcity = preg_replace("[\((.*)\)]","",$linkcity);
$linkcity = preg_replace("[-\(([A-Za-z0-9-\?=;&_\/]+)\)]","",$linkcity);

if($listing['images'][0]['src']!=''){$fill = "<img src='".$listing['images'][0]['src']."' class='thumbs2'>";} else {$fill = "<div class='fill'>No<br />Photo</div>";}
$timestamp = $listing['ctime'];

$oolistings .= "<div class='listrow' onClick=\"window.location='http://www.zippytrader.com/".$linkstate."/".$linkcity."/".$selecat."/".$linktitle."-O".$listing['id'].".html'\" style='cursor: pointer;'>
<div class='listthumb'>".$fill."</div>
<div class='listcontent'><p class='listtitle'><a href='".$linkstate."/".$linkcity."/".$selecat."/".$linktitle."-O".$listing['id'].".html'>".trunc($listing['title'],50)."</a></p><p class='listdesc'>".trunc(stripslashes($listing['body']),175)." <span style='font-size:8px;font-style:italic;'>Found on ".$listing['source']['name']."</span></p></div>
<div class='listpricebox'>
<p class='listprice'>".$listing['attributes']['price_display']."</p><p class='listloc'>".$listing['location']['name'].",".$listing['location']['state']."<br />".date('M jS',$timestamp)."</p></div>
</div>";

}


}


$descriptadd1 = "Free classified listings featuring ".$titleadd;

include('system/getbanners.php'); // Call Banners

include('template/header.php'); // Call Header
if($specparent != 78){echo"<div style='float: left;width:728px;height:110px;border-bottom: 1px solid #CCCCCC; margin:0px;'>";include('system/featured.php'); echo"</div>";} 
echo $get_num_rows[0];
?>

<div style="clear:both;"></div>
<!-- google_ad_section_start -->
<?php
$griduri = str_replace('?grid=0','',$_SERVER['REQUEST_URI']);
$rowuri = str_replace('?grid=1','',$_SERVER['REQUEST_URI']);

echo "<div class='breadcrumb'><a href='../".$homestate."/".$homecity."/'>HOME</a> > ".$parNAME." > ".$catNAME."&emsp;&emsp;<a href='".$griduri."?grid=1'>Grid View</a>&emsp;<a href='".$rowuri."?grid=0'>Row View</a></div>";
echo $listings;
echo $oolistings;
echo "<div style='margin: 15px 0px;float:left;clear:both;'>".$pages->display_pages()."</div>"; ?>

<!-- google_ad_section_end -->
<!-- ME -->
<?php include('template/footer.php');  // Call Footer ?>