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/ |
<?php if($section_region_status){ ?>
<div class="<?= $section_container ?> section">
<div class="description text-center">
<hr class="hr_lines">
<h2><?php $tv = $section_region_title?$section_region_title : $jsonarray[$language]['section_region_title'];
echo repss('%%category%%',$get_category, $tv);
?></h2>
<p><?php $tv = $section_region_sub_title?$section_region_sub_title : $jsonarray[$language]['section_region_sub_title'];
echo repss('%%category%%',$get_category, $tv);
?></p>
</div>
<div class="row image-box style10" id="region">
<?php
if(!isset($_GET['categories'])){
$_GET['categories'] = 1;
}
$sql = "SELECT DISTINCT adv.region, count(adv.region) as count, im.photo FROM advertise as adv LEFT JOIN images as im ON im.ad_id = adv.id WHERE region!='' AND adv.category_id='".$_GET['categories']."' AND adv.adstatus=1 AND adv.isApproved=1 AND im.is_profile=1 GROUP BY region ORDER BY count DESC";
$region_sql = mysqli_query($connection,$sql);
while($region=mysqli_fetch_assoc($region_sql)){
if($region['photo']!=''){
$image = '178_'.$region['photo'];
if (!file_exists('./thumbnails/'.$image)) {
$region_img = MAIN_URL.'/user_images/'.$region['photo'];
}else{
$region_img = MAIN_URL.'/thumbnails/'.$image;
}
$region_alt = $region['photo'];
}else{
$region_img = MAIN_URL.'/src/images/270x160.png';
$region_alt = 'image';
}
?>
<div class="col-sms-4 col-xs-6 col-sm-3 col-md-2 region_div">
<article class="box">
<figure class="animated" data-animation-type="fadeInDown" data-animation-duration="2">
<a href="<?php echo SUB_URL.'/'.$get_category.'/'.friendly_seo_string($region['region']) ?>">
<img src="<?= $region_img ?>" alt="<?= $get_category.' '.$region['region'] ?>" title="<?= $get_category.' '.$region['region'] ?>" width="270" height="140" class="img_region"/>
</a>
</figure>
<div class="details">
<h4 class="box-title"><?= $region['region'] ?><small> (<?= $region['count'] ?>)</small></h4>
</div>
</article>
</div>
<?php
}
?>
</div>
</div>
<?php } ?>