<?php
session_start();
include 'opendb.php';
$countrySession = $_COOKIE["cntry"];
if($countrySession != ''){ 
	$quary1sQ = "SELECT * FROM `yp_countries` WHERE `alpha_2` = '$countrySession'";
	$result1sQ = mysqli_query($condb,$quary1sQ) or die('Error, query failed1 ' . mysqli_error($condb));
	$rowsQ = mysqli_fetch_array($result1sQ);
	$countrySessionId = $rowsQ['id'];
	$currency = $rowsQ['currency'];
}
$logged_user = $_COOKIE['zv_log_user'];
$qry_counta = mysqli_query($condb,"SELECT `member_id` FROM `zv_members` WHERE `member_username` = '$logged_user'");
$ru = mysqli_fetch_array($qry_counta);
$member_id = $ru['member_id'];
$qry_countm = mysqli_query($condb,"SELECT * FROM `zv_members` WHERE `member_id` = '$member_id'");
$usrDetails = mysqli_fetch_object($qry_countm);
$userEmail = $usrDetails->member_email;
$mail_disable = 'readonly';
$reg_user_mail = $userEmail;


$us = $_GET['usr'];
$qry_countmss = mysqli_query($condb,"SELECT * FROM `zv_members` WHERE `member_id` = '$us'");
$usrDetailsss = mysqli_fetch_object($qry_countmss);
$userEmailss = $usrDetailsss->member_email;
$usr = $userEmailss;

//---------------------------------------------------------------------------------------------------------------
if($countrySession == ''){
	$wonerEmail 		= $usrDetailsss->member_email;
	$target_country 	= $usrDetailsss->target_country;
	if($member_country == ''){ $cntry = $target_country; }else{ $cntry = $member_country; }
	if($cntry != ''){
		$quary1sQ = "SELECT * FROM `yp_countries` WHERE `alpha_2` = '$cntry'";
		$result1sQ = mysqli_query($condb,$quary1sQ) or die('Error, query failed1 ' . mysqli_error($condb));
		$rowsQ = mysqli_fetch_array($result1sQ);
		$countrySessionId = $rowsQ['id'];
		$currency = $rowsQ['currency'];
		$countrySession = $rowsQ['alpha_2'];
		$expire = (time()+60*60*24*90);
		setcookie("cntry", $countrySession, $expire, "/", "zumvu.com");
	}
}
//---------------------------------------------------------------------------------------------------------------

//=============================================================================  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)";
}elseif($at == '2'){
$adt = "AND `ad_type` IN ($value_two)";
}else{
$adt = "";
}


//=====================================================================  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 `ad_owner_email` = '$usr' AND `status` = '1' $adt";
$page_ulr = "https://zumvu.com/marketplace/user-u$us"."p";
$sql_count = "SELECT * FROM `yp_ad_details` WHERE $srt ";
$result_count = mysqli_query($condb,$sql_count) or die('Error, query failed category ' . mysqli_error($condb));
$count = mysqli_num_rows($result_count);

/*
if($count == '0'){
header("HTTP/1.1 301 Moved Permanently"); 
header("Location: /"); 
}else{*/
include 'class_main.php';
//============================================ 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 '; }
if ($weeks >= 1) { $str.= $weeks.' weeks '; }
if ($days >= 1) { $str.=$days.' days '; }
if ($hrs >= 1) { $str.=$hrs.' hours '; }
if ($mins >= 1) { $str.=$mins.' minutes '; }
*/
//---------------------------------------------------
if($days < 1){
if ($hrs >= 1) { $str.=$hrs.' hours '; }
if ($mins >= 1) { $str.=$mins.' minutes '; }
}else{ $str = '2'; }
return $str;
}


?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"https://www.w3.org/TR/html4/loose.dtd">
<HTML>
<HEAD>
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<TITLE>All Ads by User - Free Classified Ads, Real Estate, Matrimonial, Jobs Ads in India<?=$tit;?></TITLE>
<META NAME="DESCRIPTION" CONTENT="Free Local Classifieds Ads in India. Post free classified ads and Search online classifieds advertisement for Real Estate, Jobs, Matrimonial, Buy & Sell, Services and others in India<?=$tit;?>.">
<META NAME="KEYWORDS" CONTENT="india, classifieds, classified, ads, free, online, post, search, advertisement, jobs, real estate, rentals, buy sell, india">
<meta name="author" content="webmaster@dialindia.com" />
<meta name="robots" content="index, follow" />
<link href="/marketplace/css/classified-main.css?v=1.1.58" rel="stylesheet" rev="stylesheet" type="text/css">
<link href="/marketplace/css/style.css" rel="stylesheet" rev="stylesheet" type="text/css">
<link href="/marketplace/css/listing-details.css?v=1.2.10" rel="stylesheet" rev="stylesheet" type="text/css">
<link href="/marketplace/css/marketplace.css?v=7.10.1011" rel="stylesheet" type="text/css">
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Open+Sans:wght@400;500;600;700&display=swap" rel="stylesheet">
</HEAD>
<BODY>
<?php 
include 'include/top-listingdetail.html';
?>

<div class="listingbbkgr">


		<div class="container">
            <div class="breadcrumbarea">
                <div class="breadlocation" itemprop="breadcrumb" itemscope itemtype="https://schema.org/Breadcrumb">
                    <a href="/marketplace/">Home</a> > All Ads by User<?=$cth;?> <?=$cat_name;?>
                </div>    
                <div class="clear"></div>
             </div>   
        </div>


<!--Wrap Start-->

<div class="container">
<!--Middle..............-->
<div id="listingleftcol">

<?php
//========================================================================
$qry_owner = mysqli_query($condb,"SELECT * FROM `zv_members` WHERE `member_id` = '$us'");
$ownerDetails = mysqli_fetch_object($qry_owner);
$owner_emailCheck = $ownerDetails->member_email;
$owner_about_me = $ownerDetails->member_about_me;
$owner_name = $ownerDetails->member_name;
$owner_profile = $ownerDetails->member_profile;
$owner_picture = $ownerDetails->member_picture;
$owner_memId = $ownerDetails->member_id;
$profile_verified = $ownerDetails->profile_verified;
if($owner_picture == "noimage.jpg"){ $owner_picture = "https://c.cdnxp.com/gtheme/images/profileimage.png"; }
if($profile_verified == '1'){ $vrfy = '<a title="Verified" class="vtooltip"><img src="/imgs/verification-icon.png" alt=""/></a>'; }
elseif($profile_verified == '2'){ $vrfy = '<a title="Trusted Member" class="vtooltip"><img src="/imgs/trusted-icon.png" alt=""/></a>'; }else{ $vrfy = ''; }
if($owner_picture == "noimage.jpg"){ $owner_picture = "https://c.cdnxp.com/gtheme/images/profileimage.png"; }
//========================================================================
?>


<div class="resultcount allmbfiftten"><span class="resultsgray">All Ads By</span><span class="resultsblack"><?=$owner_name;?></span> [<?=$count;?>]</div>


<!--Box-->
<?php
$sql = "SELECT * FROM `yp_ad_details` WHERE $srt ORDER BY `plan` DESC, `activated_on` DESC, `title` ASC LIMIT $st,$pr";
//echo $sql;
$result = mysqli_query($condb,$sql) or die('Error, query failed category ' . mysqli_error($condb));
while($rows = mysqli_fetch_array($result))
{
$plan = $rows['plan'];
$ad_id = $rows['ad_id'];
$title = $rows['title'];
$title = remove_any_tags($title);
$title_url = $rows['title_url'];
$description = $rows['description'];
$wordChunks = explode("<br>", $description);
$description = ''; for($i = 0; $i < count($wordChunks); $i++){ $description .= "$wordChunks[$i] "; }
$wordChunks = explode("<br />", $description);
$description = ''; for($i = 0; $i < count($wordChunks); $i++){ $description .= "$wordChunks[$i] "; }
$description = remove_any_tags($description);
$description = substr($description, 0, 140);
$listCountry = $rows['country_id'];
$ad_details = $sanformation->ad_details($ad_id);
$views = $ad_details['views'];

//-------------------------------------------------------------------------------------
	$quary1sQq = "SELECT * FROM `yp_countries` WHERE `id` = '$listCountry'";
	$result1sQq = mysqli_query($condb,$quary1sQq) or die('Error, query failed1 ' . mysqli_error($condb));
	$rowsQq = mysqli_fetch_array($result1sQq);
	$currencyq = $rowsQq['currency'];
//----------------------------------------------------------------------------------------------------------


$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'] != ''){
	if($count_array == '0'){
	$img = $rows['photo'];
	}else{
	$img = $image_array[0];
	}
}else{
$img = "/marketplace/images/noimage.gif";
}
$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 = '<span class="boxd2span">'.$locations_array[0].'</span>'; }else{ $loc = ''; }

$you_are = $rows['you_are'];
$yr = substr($you_are, 1, 50);
$yr = substr($yr, 0, -1);
if($yr != ''){ $you = '<span class="boxd2span">'.$yr.'</span>'; }else{ $you = ''; }

$price = $rows['price'];
if($price > '0'){ 
$pric = '<span class="boxd2span">'.$currencyq.' '.number_format($price).'</span>'; 
}else{ $pric = ''; }
$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" class="dirclnk" data-name="'.$ad_id.'"'; }else{ $lrl = ''; }

//if($plan == '1'){ $class = "whiteboxhome"; }elseif($plan == '2'){ $class = 'yellowbox'; }
$class = $sanformation->plan_class($plan);


    $btnLabel 		= $rows['calltoaction'];
    $btnValue 		= $rows['calltoaction_link'];
    $extVal 		= '';
    $callToActionBtn = $sanformation->callToActionBtnNew($btnLabel,$btnValue,$extVal,$plan,$ad_id);
    if($btnLabel !=''){
        $callToActionBtn_extend = $callToActionBtn;	
        $exclass_name = 'desclassspan';
    }else{
        $callToActionBtn_extend ='';
        $exclass_name ='';
    }


$display = '<div class="middlewrapwork">
<div class="'.$class.'">
<div class="box2 mrten"><a '.$lrl.' href="'.$add_url.'"><div class="noimage"><img src="'.$img.'" onError="this.onerror=null;this.src=\'https://u.cdnxp.com/product-no-image.jpg\';" alt="" border="0"></div></a></div>
<div class="mobileh5 mobiledesc"><h5><a '.$lrl.' href="'.$add_url.'">'.$title.'</a></h5><div class="box1workd1">'.$views.' views | '.$duro.'</div></div>
<div class="box1 pt0">
<div class="box1work desktph5"><h5><a '.$lrl.' href="'.$add_url.'">'.$title.'</a></h5></div>
<div class="box1work deswcfntsz displaynone"><div class="'.$exclass_name.'">'.$description.'...</div><div class="tesktp-btn">'.$callToActionBtn_extend.'</div><div class="clear"></div></div>
<div class="box1work">
<div class="box1workd1 displaynone">'.$views.' views | '.$duro.'</div>

<div class="box1workd2">'.$pric.$you.$loc.'</div>

<div class="clear"></div>
</div>
</div>
<div class="mobile-btn">'.$callToActionBtn_extend.'</div>	
</div>
<div class="clear"></div>
</div>';

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));
}
?>
<!--Box End-->


<!--Box-->

<?php
$pws = (($wn-1)*$pr)+1;
$pwt = $pr*$wn;
if($pwt < $count){ $pwt = $pwt; }else{ $pwt = $count; }
?>

<div class="middlewrapworkhom">
<div class="bar_bot">
<div class="bar_lt"></div>
<div class="bar_con">
<?php
if($count != '0'){
?>
<span>Showing Results: <strong><?=$pws;?>-<?=$pwt;?></strong> of <strong><?=$count;?></strong></span>
<?php
}else{
echo '<span><strong>No ads found.</strong></span>';
}
?>


<?php
$res = $count;
$xx = $res/$pr;
$y = 0;
if($res > $pr)
{
if($back == '0'){
$back = 1;
}	
while($y < $xx){
$y = $y+1;
if($y == $wn){
$slrsx[] = "<b>$y</b>";
}else{
$slrsx[] = "<a href=\"".$page_ulr.$y."/\">$y</a>";
}}
echo 
$slrsx[$slr-5].$slrsx[$slr-4].$slrsx[$slr-3].$slrsx[$slr-2].$slrsx[$slr-1].$slrsx[$slr].$slrsx[$slr+1].$slrsx[$slr+2].$slrsx[$slr+3].$slrsx[$slr+4].$slrsx[$slr+5];
$next = $wn+1;
if($next > $y){
$next = $y;
}elseif($wn == '0' || $wn == ''){
$next = 2;
}
}
?>

</div>
</div>
</div>
<!--Box End-->


</div>
<!--Middle..............End-->
<?php 
 //include 'include/right300.html';
?>
<div id="listingrightcol">

<div class="author-section">
    <div class="authorbx">
       <div class="author-img">
            <?php if($owner_profile != ''){ ?>
				<a href="https://zumvu.com/<?=$owner_profile;?>"><img src="<?=$owner_picture;?>"></a>
			<?php }else{ ?>
				<a href="/marketplace/user-u<?=$owner_memId;?>p1/"><img src="<?=$owner_picture;?>"></a>
			<?php } ?>
        </div>
        <div class="author-bio">   
            <?php if($owner_profile != ''){ ?>
				<strong><a href="https://zumvu.com/<?=$owner_profile;?>"><?=$owner_name;?></a></strong> <?=$vrfy;?>
            <?php }else{ ?>
				<strong><a href="/marketplace/user-u<?=$owner_memId;?>p1/"><?=$owner_name;?></a></strong>
			<?php } ?> 
            <p><?=$owner_about_me;?></p>
        </div>
        <?php if($owner_profile != ''){ ?><div class="addbtn"><a href="https://zumvu.com/<?=$owner_profile;?>/about/">Vew Profile</a></div><?php } ?>
        
    </div>
</div>

</div>
<!--Right Home End-->


<div class="clear"></div>

</div>
</div>
<!--Wrap End-->
<?php 
include 'include/bottom-details.html';
?>
</BODY>
</HTML>
<?php
//}
?>