member_email; $mail_disable = 'readonly'; $reg_user_mail = $userEmail; $cat_url = $_GET['cat']; $cat_id = $_GET['cat_id']; $at = $_GET['at']; $city = $_GET['city']; $wn = $_REQUEST['page']; if($city != ''){ $canonical = "https://zumvu.com/$city/$cat_url/c".$cat_id."a".$at."p".$wn."/"; }else{ $canonical = "https://zumvu.com/marketplace/$cat_url/c".$cat_id."a".$at."p".$wn."/"; } $cat_row = $sanformation->category_details($cat_id); $cat_name = $cat_row['category_name']; $fields = $cat_row['fields']; $brands = $cat_row['brands']; $country_id = $cat_row['country_id']; //=================================================================================== $qryCountryInc = "SELECT * FROM `yp_countries` WHERE `id` = '$country_id'"; $resCountryInc = mysqli_query($condb,$qryCountryInc) or die('Error, query failed1 ' . mysqli_error($condb)); $rCountryInc = mysqli_fetch_array($resCountryInc); $countrySessionId = $rCountryInc['id']; $currency = $rCountryInc['currency']; $countrySession = $rCountryInc['alpha_2']; $lang = $rCountryInc['lang']; $expire = (time()+60*60*24*90); setcookie("cntry", $countrySession, $expire, "/", "zumvu.com"); //=================================================================================== $category_parents = $cat_row['category_parents']; $own_url = "/$cat_url-c$cat_id"."a".$at."p1.html"; $cat_url_sub = $cat_url; $ind_row = $sanformation->category_details($category_parents); $cat_url_parents = $ind_row['category_url']; $cat_name_parents = $ind_row['category_name']; $cat_id_parents = $ind_row['c_id']; $cat_url_child = $cat_url; $city_url = $_GET['city']; if($city_url != ''){ $cts = $sanformation->city_ip_check($city_url); if($cts != '0'){ $city_url_new = $sanformation->city_ip_name($city_url); if($city_url_new != $city_url){ $city_url = $city_url_new; $ne_url = "https://zumvu.com/marketplace/$city_url".$own_url; $indus_url = "https://zumvu.com/marketplace/$city_url/$cat_url_parents/s$cat_id_parents"."a0p1/"; header("Location: $ne_url"); } }else{ $city_url = ''; $ne_url = "https://zumvu.com$own_url"; $indus_url = "https://zumvu.com/marketplace/$cat_url_parents/s$cat_id_parents"."a0p1/"; header("Location: $ne_url"); } }else{ $city_url = ''; $indus_url = "https://zumvu.com/marketplace/$cat_url_parents/s$cat_id_parents"."a0p1/"; } //echo "c : $city_url"; if($city_url != ''){ $ct = "`city_url` = '$city_url' AND "; $crl = "$city_url/"; $ct_aj = $city_url; $city_name = $sanformation->city_name($city_url); $cth = ' >'; }else{ $ct = "`city_url` = '$countrySession' AND "; $crl = ''; $cth = ''; } //============================================ duration calculator ================================ $dt = $date->format( 'd M Y H:i' ); $time_now = strtotime("$dt"); function Duration($s, $e){ $timestamp = $e - $s; $years=floor($timestamp/(60*60*24*365)); $timestamp%=60*60*24*365; $weeks=floor($timestamp/(60*60*24*7)); $timestamp%=60*60*24*7; $days=floor($timestamp/(60*60*24)); $timestamp%=60*60*24; $hrs=floor($timestamp/(60*60)); $timestamp%=60*60; $mins=floor($timestamp/60); $secs=$timestamp%60; if ($years >= 1) { $str.= $years.' years '; } else if ($weeks >= 1) { $str.= $weeks.' weeks '; } else if ($days >= 1) { $str.=$days.' days '; } else if ($hrs >= 1) { $str.=$hrs.' hours '; } else if ($mins >= 1) { $str.=$mins.' minutes '; } else{ $str = '2'; } //--------------------------------------------------- /* if($days < 1){ if ($hrs >= 1) { $str.=$hrs.' hours '; } if ($mins >= 1) { $str.=$mins.' minutes '; } }else{ $str = '2'; }*/ return $str; } //============================================================================= AD TYPE ================================================= $quary1 = "SELECT * FROM `yp_asso_field_value` WHERE `asso_with` = '1'"; $result1 = mysqli_query($condb,$quary1) or die('Error, query failed ' . mysqli_error($condb)); while($row = mysqli_fetch_array($result1)){ $val = $row['radio_set_1']; $vals = $row['radio_set_2']; $value_one .= "',$val,', "; $value_two .= "',$vals,', "; } $value_one .= substr($value_one, 0, -2); $value_two .= substr($value_two, 0, -2); if($at == '1'){ $adt = "AND `ad_type` IN ($value_one)"; $typ_txt = " - Offering Ads "; }elseif($at == '2'){ $adt = "AND `ad_type` IN ($value_two)"; $typ_txt = " - Wanted Ads "; }elseif($at == '3'){ $adt = "AND `sales_price` > '0'"; $typ_txt = " - Deals "; }else{ $adt = ""; $typ_txt = " - All Ads "; } //===================================================================== page navigation ==================================== $pr = $_REQUEST['pr']; if(!$pr) $pr = 20; $wn = $_REQUEST['page']; $w = (($wn*$pr)-$pr); $st = $w; if((!$st || ($st < 0))) $st = 0; $slr = round($st/$pr, 0)+2; $next = $st+$pr; if($st <= $pr) { $back = 0; }else{ $back = $st-$pr; } $pct = ($st/20)+1; if(!isset($_REQUEST['page'])){ $tit = ""; }else{ $tit = "- page ".$pct; } //===================================================================== page navigation end ==================================== $srt = "$ct `category_id` = '$cat_id' AND `status` = '1' $adt"; $page_ulr = "https://zumvu.com/marketplace/$crl"."$cat_url/c$cat_id"."a".$at."p1/"; $indus_url = "https://zumvu.com/marketplace/$crl"."$cat_url_parents/s$cat_id_parents"."a0p1/"; $sql_count = "SELECT * FROM `yp_ad_details` WHERE $srt AND `country_id` = '$countrySessionId'"; $result_count = mysqli_query($condb,$sql_count) or die('Error, query failed category ' . mysqli_error($condb)); $count = mysqli_num_rows($result_count); $cat_parent_name = $cat_name_parents; if($city_name == ''){ $city_name = 'india'; } //======================================================================================================================================= $ord = $_GET['order']; if($ord == '1'){ $ord_str = ""; $ord_page_url = ""; }elseif($ord == '2'){ $ord_str = "`activated_on` DESC, "; $ord_page_url = "?order=2"; $ord_txt = " - order by newly added ads "; }elseif($ord == '3'){ $ord_str = "`activated_on` ASC, "; $ord_page_url = "?order=3"; $ord_txt = " - order by earlier added ads "; }elseif($ord == '4'){ $ord_str = "`price` ASC, "; $ord_page_url = "?order=4"; $ord_txt = " - order by lowest price "; }elseif($ord == '5'){ $ord_str = "`price` DESC, "; $ord_page_url = "?order=5"; $ord_txt = " - order by highest price "; }elseif($ord == '6'){ $ord_str = "`views` DESC, "; $ord_page_url = "?order=6"; $ord_txt = " - order by highest visits "; } $page_ulr_order = "https://zumvu.com/marketplace/$crl"."$cat_url/c$cat_id"."a".$at."p$wn/?order="; $clear_all_url = "https://zumvu.com/marketplace/$crl"."$cat_url/c$cat_id"."a".$at."p$wn/"; $srt_all = "$ct `category_id` = '$cat_id' AND `status` = '1'"; $srt_offered = "$ct `category_id` = '$cat_id' AND `status` = '1' AND `ad_type` IN ($value_one)"; $srt_wanted = "$ct `category_id` = '$cat_id' AND `status` = '1' AND `ad_type` IN ($value_two)"; $srt_deals = "$ct `category_id` = '$cat_id' AND `status` = '1' AND `sales_price` > '0'"; $sql_all = "SELECT * FROM `yp_ad_details` WHERE $srt_all AND `country_id` = '$countrySessionId'"; //echo $sql_all; $result_all = mysqli_query($condb,$sql_all) or die('Error, query failed category ' . mysqli_error($condb)); $count_all = mysqli_num_rows($result_all); $all_url = "https://zumvu.com/marketplace/$crl"."$cat_url/c$cat_id"."a0p1/$ord_page_url"; $sql_offered = "SELECT * FROM `yp_ad_details` WHERE $srt_offered AND `country_id` = '$countrySessionId'"; $result_offered = mysqli_query($condb,$sql_offered) or die('Error, query failed category ' . mysqli_error($condb)); $count_offered = mysqli_num_rows($result_offered); $offered_url = "https://zumvu.com/marketplace/$crl"."$cat_url/c$cat_id"."a1p1/$ord_page_url"; $sql_wanted = "SELECT * FROM `yp_ad_details` WHERE $srt_wanted AND `country_id` = '$countrySessionId'"; $result_wanted = mysqli_query($condb,$sql_wanted) or die('Error, query failed category ' . mysqli_error($condb)); $count_wanted = mysqli_num_rows($result_wanted); $wanted_url = "https://zumvu.com/marketplace/$crl"."$cat_url/c$cat_id"."a2p1/$ord_page_url"; $sql_deals = "SELECT * FROM `yp_ad_details` WHERE $srt_deals "; $result_deals = mysqli_query($condb,$sql_deals) or die('Error, query failed category ' . mysqli_error($condb)); $count_deals = mysqli_num_rows($result_deals); $deals_url = "https://zumvu.com/marketplace/$crl"."$cat_url/c$cat_id"."a3p1/$ord_page_url"; ?> <?=$cat_parent_name;?> - <?=$cat_name;?> in <?=ucwords($city_name);?> <?=$ord_txt;?><?=$typ_txt;?> <?=$tit;?>
- in Category Image Post and search free online classified ads for - in .
> >
Results for [ ]
", $description); $description = ''; for($i = 0; $i < count($wordChunks); $i++){ $description .= "$wordChunks[$i] "; } $wordChunks = explode("
", $description); $description = ''; for($i = 0; $i < count($wordChunks); $i++){ $description .= "$wordChunks[$i] "; } $description = remove_any_tags($description); $description = substr($description, 0, 140); $more_description = $rows['more_description']; if($more_description != ''){ $description = $more_description; } $ad_details = $sanformation->ad_details($ad_id); $views = $ad_details['views']; $city_url_l = $rows['city_url']; $listing_approve_date = $rows['activated_on']; $listing_approve_date_disp = date("F j, Y, g:i a", $listing_approve_date); $images = $rows['photo']; $image_array = explode(",",$images); $count_array = count($image_array); if($count_array == '1' AND $images == ''){ $cnt = '0'; }else{ $cnt = $count_array; } if($rows['photo'] == 'none'){ $img = "/images/noimage.gif"; $img_cd = ''; }elseif($rows['photo'] != ''){ if($count_array == '0'){ $img = $rows['photo']; }else{ $img = $image_array[0]; } $img_cd = ''; }else{ $img = "/marketplace/images/noimage.gif"; $img_cd = ''; } $duration = Duration($listing_approve_date, $time_now); if($duration != '2'){ $duro = $duration.' ago'; }else{ $duro = $listing_approve_date_disp; } $locations = $rows['locations']; $locations_array = explode(",",$locations); if($locations != ''){ $loc = ''.$locations_array[0].''; }else{ $loc = ''; } $you_are = $rows['you_are']; $yr = substr($you_are, 1, 50); $yr = substr($yr, 0, -2); if($yr != ''){ $you = ''.$yr.''; }else{ $you = ''; } //$price = $rows['price']; //if($price > '0'){ $pric = ''.$currency.' '.number_format($price).''; }else{ $pric = ''; } $price = $rows['price']; $sales_price = $rows['sales_price']; if($sales_price > '0'){ $persent = round((($price-$sales_price)*100)/$price); }else{ $persent = ''; } if($price > '0'){ $pric = ''.$currency.' '.number_format($price).''; }else{ $pric = ''; } if($sales_price > '0'){ $pric = ''.$currency.' '.number_format($sales_price).' '.number_format($price).'
(save '.$persent.'%)
'; $dealClass = '
'; }else{ $dealClass = ''; } $add_url = "https://zumvu.com/marketplace/$city_url_l/v$ad_id/$title_url/"; $calltoaction = $rows['calltoaction']; $calltoaction_link = $rows['calltoaction_link']; //if($calltoaction == "Direct Link"){ $add_url = $calltoaction_link; $lrl = ' target="_blank"'; }else{ $lrl = ''; } if($calltoaction == "Direct Link"){ $add_url = $calltoaction_link; $lrl = ' target="_blank" class="dirclnk" data-name="'.$ad_id.'"'; } else if($calltoaction == "Visit Site"){ $add_url = $calltoaction_link; $lrl = ' target="_blank" class="dirclnk" data-name="'.$ad_id.'"'; } else if($calltoaction == "Visit Store"){ $add_url = $calltoaction_link; $lrl = ' target="_blank" class="dirclnk" data-name="'.$ad_id.'"'; } else if($calltoaction == "Visit Blog"){ $add_url = $calltoaction_link; $lrl = ' target="_blank" class="dirclnk" data-name="'.$ad_id.'"'; } else{ $lrl = ''; } //if($plan == '1'){ $class = "whitebox"; }elseif($plan == '2'){ $class = 'yellowbox'; } $class = $sanformation->plan_class($plan); $btnLabel = $rows['calltoaction']; $btnValue = $rows['calltoaction_link']; $extVal = ''; $callToActionBtn = $sanformation->callToActionBtn($btnLabel,$btnValue,$extVal,$plan); if($btnLabel !=''){ $callToActionBtn_extend = $callToActionBtn; $exclass_name = 'desclassspan'; }else{ $callToActionBtn_extend =''; $exclass_name =''; } $display = '
'.$dealClass.'
'.$img_cd.'
'.$views.' views | '.$duro.'
'.$title.'
'.$description.'...
'.$callToActionBtn_extend.'
'.$views.' views | '.$duro.'
'.$pric.$you.$loc.'
'.$callToActionBtn_extend.'
'; echo $display; $queryImp = "UPDATE `yp_ad_details` SET `impression` = `impression`+1 WHERE `ad_id` = '$ad_id'"; $resultImp = mysqli_query($condb,$queryImp) or die('Error, query failed_cont ' . mysqli_error($condb)); } $new_st = $w+1; if($cc >= $pr){ echo ''; } else { echo ''; } ?>