isMobile()) { header("Location: http://m.zippytrader.com/showadip.html?lid=".$lid.""); exit;} 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, 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(mysql_error()); $row = mysql_fetch_assoc($resultcm); $catID = $row['catID']; $catNAME = $row['catNAME']; $specparent = $row['parID']; $parNAME = $row['parNAME']; $ctable = $row['tabname']; $bancat = $catID; if($lid<1000){$selector = "oldID='".scrub($lid,"S")."' AND categoryID=$catID";} else {$selector = "listingID='".scrub($lid,"S")."'";} // mysql_select_db($dbname,$dbc) or die(mysql_error()); $bmqueryID = "SELECT listingID, parentID, oldID, categoryID, type, title, description, price, video, mapaddress, views, email, phone, city_state, date_format(startdate,'%M %D, %Y') as postdate FROM listings WHERE ".$selector." AND approved=1 AND suspend=0 AND verified=1 LIMIT 1"; $resultID=mysql_query($bmqueryID) or die(mysql_error()); $row=mysql_fetch_assoc($resultID); $listingID = $row['listingID']; $parentID = $row['parentID']; $oldID = $row['oldID']; $categoryID = $row['categoryID']; $type = $row['type']; $title = $row['title']; $description = $row['description']; $price = $row['price']; $video = $row['video']; $mapaddress = $row['mapaddress']; $views = $row['views']; $zipcode = $row['zipcode']; $remail = $row['email']; $phone = $row['phone']; $views = $row['views']; $city_state = $row['city_state']; $postdate = $row['postdate']; $upcatsql="UPDATE listings SET views='".++$views."' WHERE listingID='".$listingID."'"; $results=mysql_query($upcatsql)or die(mysql_error()); if($listingID!=''){ if($mapaddress!=''){$maplink = $mapaddress.", ";} $description = stripslashes(scrub($description,'T')); $description = str_replace('[WEBURL]','',$description); $description = str_replace('[/LINKTEXT]','',$description); $title = stripslashes(scrub($title,'T')); if(isset($_POST['submit'])){ $headers = ''; $semail = scrub($_REQUEST['semail'],"E"); $rmessage=stripslashes(filter_var($_REQUEST['message'], FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES)); if(strpos(strtolower($rmessage), strtolower("shipping agent")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("shipper")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("money order")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("cashiers check")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("western union")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("money gram")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("escrow")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("cashier's check")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("certified check")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} if(strpos(strtolower($rmessage), strtolower("cheque")) !== false) {$remail = "support@zippytrader.com"; $sflag = 1;} $rmessage .= " ************************************ SCAM REMINDER! Preventing fraud is really quite easy. Simply follow these two rules and you will never be scammed. 1. Deal local and face-to-face ONLY! 2. Accept CASH ONLY for your merchandise! This means: 1. NEVER, EVER accept money orders or checks of any kind! 2. DO NOT use any escrow service! 3. NEVER, EVER wire money to anyone, anywhere. IGNORE THE ABOVE WARNINGS AND YOU WILL LOSE YOUR MONEY!!! It is understandable that if the transaction amount is large the buyer may not want to carry that much cash. Simply meet them at their bank where they can give you the CASH. Then YOU can decide to convert the cash to a cashiers check or money order. "; $salert = ""; if($sflag == 1){$salert = "SCAM ALERT! ";} // SEND MESSAGE TO ADVERTISER $headers = ''; $headers .= "MIME-Version: 1.0\n"; $headers .= "Content-type: text/plain; charset=iso-8859-1\n"; $headers .= "From: ".$semail."\n"; $headers .= "Reply-To: ".$semail."\n"; $headers .= "X-Priority: 1\n"; $headers .= "X-MSMail-Priority: High"; mail($remail, $salert."Response to Your Ad on ZippyTrader: ".$title,$rmessage,$headers); $sent = 1; $_SESSION['replyinfo'] = ''; } if($oldID!=0){$photolid = $oldID;} else {$photolid = $listingID;} $_SESSION['replyinfo'] = $title."|".$adlocstate."/".$adloccity."/".scrub($_REQUEST['cid'],"T")."/".scrub($_REQUEST['title'],"T")."-L".$lid.".html"; $bmqueryph = "SELECT photoID, filename FROM photos WHERE parentID=".$parentID." AND listingID=".$photolid." ORDER BY photoID"; $resultph=mysql_query($bmqueryph) or die(mysql_error()); $topphoto=''; while($row=mysql_fetch_assoc($resultph)) { $topphoto[] = $row['filename']; $thumbrows .= "
"; } if($video !=''){$thumbrows .= "
";} } else {$deadad = "Sorry. This Ad Has Expired or Has Been Deleted";} $headeradds .= " "; $bancat = $parentID."-".$categoryID; $descriptadd2 = "Classified listing for ".$titleadd2; include('system/getcities.php'); $titleadd2 = $title." in ".$city_state." ".$zip; if($deadad!=''){$adtitle = $deadad;} else {$adtitle = $title." in ".$city_state;} include('system/getbanners.php'); // Call Banners include('template/header.php'); // Load Header if($specparent != 78){echo"
";include('system/featured.php'); echo"
";} ?>
HOME > ".$parNAME." > ".$catNAME.""; ?>

Your Message Has Been Sent

";} else { echo ""; } switch ($type) { case 1: $showprice = "Price: $".number_format($price,2); break; case 2: $showprice = "FREEBIE"; break; case 3: $showprice = "Trade/Barter"; break; case 4: $showprice = "WANTED"; break; case 5: $showprice = "Please Contact"; break; } ?>


Map It
Ad ID:
Posted:
Ad Views:

"; } else {echo"";} ?>