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/ |
<?php if($section_city_status){ ?>
<div class="<?= $section_container ?> section">
<div class="description text-center">
<hr class="hr_lines">
<h2><?php $tv = $section_city_title?$section_city_title : $jsonarray[$language]['section_city_title'];
echo repss('%%category%%',$get_category, $tv);
?></h2>
<p><?php $tv = $section_city_sub_title?$section_city_sub_title : $jsonarray[$language]['section_city_sub_title'];
echo repss('%%category%%',$get_category, $tv);
?></p>
</div>
<div class="row image-box style10" id="cities">
<?php
$city_start = 0;
$city_num_record = 12;
$where = " WHERE adv.adstatus=1 AND adv.isApproved=1 ";
$order = " ORDER BY count DESC, place LIMIT $city_start,$city_num_record ";
if(isset($_GET['categories']) && !empty($_GET['categories'])){
$where .= (!empty($where) ? ' AND ' : '') . " adv.category_id='".$_GET['categories']."' ";
}
$city_count_query = "SELECT count(place) as num FROM (SELECT DISTINCT adv.sub_country as place FROM advertise adv $where AND adv.sub_country!='' GROUP BY adv.sub_country UNION SELECT DISTINCT adv.district as place FROM advertise adv $where AND adv.district!='' GROUP BY adv.district UNION SELECT DISTINCT adv.ward as place FROM advertise adv $where AND adv.ward!='' GROUP BY adv.ward ) x";
$city_total_records = mysqli_fetch_array(mysqli_query($connection,$city_count_query));
$city_total_records = $city_total_records['num'];
if($city_start == 0){
?>
<input type="hidden" name='city_total_records' id="city_total_records" value="<?= $city_total_records ?>" />
<?php
}
$union_qry = "SELECT DISTINCT adv.ward as place, count(adv.ward) as count, im.photo FROM advertise as adv LEFT JOIN images as im ON im.ad_id = adv.id $where AND adv.ward!='' AND im.is_profile=1 GROUP BY adv.ward UNION SELECT DISTINCT adv.district as place, count(adv.district) as count, im.photo FROM advertise as adv LEFT JOIN images as im ON im.ad_id = adv.id $where AND adv.district!='' AND im.is_profile=1 GROUP BY adv.district UNION SELECT DISTINCT adv.sub_country as place, count(adv.sub_country) as count, im.photo FROM advertise as adv LEFT JOIN images as im ON im.ad_id = adv.id $where AND adv.sub_country!='' AND im.is_profile=1 GROUP BY adv.sub_country $order";
$city_sql = mysqli_query($connection,$union_qry);
$city_row = mysqli_num_rows($city_sql);
if($city_row > 0){
while($city=mysqli_fetch_assoc($city_sql)){
if($city['photo']!=''){
$image = '178_'.$city['photo'];
if (!file_exists('./thumbnails/'.$image)) {
$city_img = MAIN_URL.'/user_images/'.$city['photo'];
}else{
$city_img = MAIN_URL.'/thumbnails/'.$image;
}
$city_alt = $city['photo'];
}else{
$city_img = MAIN_URL.'/src/images/270x160.png';
$city_alt = 'image';
}
?>
<div class="col-sms-4 col-xs-6 col-sm-3 col-md-2 city_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($city['place']) ?>">
<img src="<?= $city_img ?>" alt="<?= $get_category.' '.$city['place'] ?>" title="<?= $get_category.' '.$city['place'] ?>" width="270" height="140" class="img_region"/>
</a>
</figure>
<div class="details">
<h4 class="box-title"><?= $city['place'] ?><small> (<?= $city['count'] ?>)</small></h4>
</div>
</article>
</div>
<?php
}
}else{
echo '<label>Keine Anzeigen gefunden.</label>';
}
?>
</div>
<div class="col-xs-12 col-md-12 col-lg-12 col-sm-12 show_more"><button type="button" class="show_more_btn" id="load_more_city"></button></div>
</div>
<?php } ?>