Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory :  /home/u107206879/domains/escort46.de/public_html/en/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
	$main_img = $multi_user_img = '';
	$boostAdqry = "SELECT i.ad_id, i.photo, ad.profile_tile, ad.boost, ad.category_id, i.is_profile FROM advertise as ad INNER JOIN images as i ON i.ad_id=ad.id WHERE i.is_profile=1 AND ad.adstatus=1 AND ad.boost=1 AND ad.isApproved=1 ORDER BY RAND() LIMIT 3";
	$boostAdResult = mysqli_query($connection,$boostAdqry);
	$cntBoostResult = mysqli_num_rows($boostAdResult);
	
	while($boostAdRow = mysqli_fetch_array($boostAdResult)){
		$similarAdRows[] = $boostAdRow;
	}
	
	$resultLimit = 5 - $cntBoostResult;
	$similarAdQry = "SELECT i.ad_id, i.photo, ad.profile_tile, ad.boost, ad.category_id, i.is_profile FROM advertise as ad INNER JOIN images as i ON i.ad_id=ad.id WHERE i.is_profile=1 AND ad.adstatus=1 AND ad.isApproved=1 ORDER BY RAND() LIMIT $resultLimit";
	$similarAdResult = mysqli_query($connection,$similarAdQry);
	while($img_row=mysqli_fetch_array($similarAdResult)){
		$similarAdRows[] = $img_row;
	}
	
	foreach($similarAdRows as $similarAdRow){
		$thumb_src = MAIN_URL.'/thumbnails/178_'.$similarAdRow['photo'];
		#profile link code start
		$row_page_ads_links =array();
		$sql_page_ads_links="select * from page_ads_links where type='Profile' and ad_id='".$similarAdRow['ad_id']."'";
		$result_page_ads_links=mysqli_query($connection,$sql_page_ads_links);
		if(mysqli_num_rows($result_page_ads_links)==0){
		}else{
			$row_page_ads_links = mysqli_fetch_assoc($result_page_ads_links);
		}		
		#profile link code ends 
?>
		<div class="row similar_ad_rows">
			<?php if(!empty($row_page_ads_links['message_outgoing_link']) && $row_page_ads_links['message_link_active'] == 1 && $similarAdRow['boost'] == 1){ ?>
			<a rel="nofollow" href="<?= $row_page_ads_links['message_outgoing_link'] ?>" target="_blank" title="<?= $similarAdRow["profile_tile"] ?>" alt="<?= $similarAdRow["profile_tile"] ?>">
			<?php }else{ ?>			
			<a href="<?php echo SUB_URL; ?>/<?php if($similarAdRow["category_id"] ==5){?>events<?php }else{ ?>user_detail<?php } ?>/<?php echo $similarAdRow["ad_id"]."/".friendly_seo_string($similarAdRow["profile_tile"]);?>">
			<?php }?>
				<div class="similar_ad_image">
				  	<img class="similar_an_images" src="<?= $thumb_src ?>" title="<?= $similarAdRow["profile_tile"] ?>" alt="<?= $similarAdRow["profile_tile"] ?>">
			  	</div>
			  	<div class="detail_similar_ad_title">
				  	<span><?= $similarAdRow["profile_tile"] ?></span>
			  	</div>
			</a>
		</div>
<?php
	}
?>