Al-HUWAITI Shell
Al-huwaiti


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/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/u107206879/domains/escort46.de/public_html/cities.php
<?php
	include_once "db_connection.php";
	include_once "functions.php";
	require_once 'Mobile_Detect.php';
	$detect = new Mobile_Detect;
	
	#Scroll Ads Code
	$_SESSION["count_scroll_ads"] =1;
	if($detect->isMobile() && !$detect->isTablet()){
		$device ="mobile";
	}elseif($detect->isTablet()){
		$device ="tablet";		
	}else{
		$device ="desktop";
	}
	
	$scroll_ads_query="SELECT * from scroll_ads WHERE ad_device='".$device."' and active='1' order by rand() limit 1";
	$scroll_ads_result=mysqli_query($connection,$scroll_ads_query);
	$scroll_ads_count = mysqli_num_rows($scroll_ads_result);
	$scroll_all_ads =array();
	if(mysqli_num_rows($scroll_ads_result)){
		$scroll_ads =array();
		$scroll_ads = mysqli_fetch_assoc($scroll_ads_result);
		#fetch all the ads related to that
		$scroll_all_ads_query="SELECT * from scroll_ads WHERE ad_device='".$device."' and rowset ='".$scroll_ads["rowset"]."' order by id asc";
		$scroll_all_ads_result=mysqli_query($connection,$scroll_all_ads_query);
		$count_scroll_all_ads = mysqli_num_rows($scroll_all_ads_result); 
		if(mysqli_num_rows($scroll_all_ads_result)){
			while($row_scroll_all_ads = mysqli_fetch_assoc($scroll_all_ads_result)){
				$scroll_all_ads[] = $row_scroll_all_ads;
			}		
		}					
	}
		
	#Scroll Ads Code
	
	if(isset($_GET['category']) && !empty($_GET['category']) && isset($_GET['city']) && !empty($_GET['city'])){		
		//City
		$decoded=false;
		$decode_city_qry = mysqli_query($connection,"SELECT DISTINCT district from advertise GROUP BY district");
		while($decode_row=mysqli_fetch_assoc($decode_city_qry)){
			if(friendly_seo_string($decode_row['district']) == $_GET['city']){
				$_GET['omrade1'] = $decode_row['district'];
				$decoded=true;
				break;
			}
		}
		if(!$decoded){
			$decode_region_qry = mysqli_query($connection,"SELECT DISTINCT region from advertise GROUP BY region");
			while($decode_row=mysqli_fetch_assoc($decode_region_qry)){
				if(friendly_seo_string($decode_row['region']) == $_GET['city']){
					$_GET['omrade1'] = $decode_row['region'];
					$decoded=true;
					break;
				}
			}
		}
		if(!$decoded){
			$decode_ward_qry = mysqli_query($connection,"SELECT DISTINCT sub_country from advertise GROUP BY sub_country");
			while($decode_row=mysqli_fetch_assoc($decode_ward_qry)){
				if(friendly_seo_string($decode_row['sub_country']) == $_GET['city']){
					$_GET['omrade1'] = $decode_row['sub_country'];
					$decoded=true;
					break;
				}
			}
		}
		if(!$decoded){
			$decode_ward_qry = mysqli_query($connection,"SELECT DISTINCT ward from advertise GROUP BY ward");
			while($decode_row=mysqli_fetch_assoc($decode_ward_qry)){
				if(friendly_seo_string($decode_row['ward']) == $_GET['city']){
					$_GET['omrade1'] = $decode_row['ward'];
					$decoded=true;
					break;
				}
			}
		}
		
		//HTML
		$city_html_title = $_GET['omrade1'];
		$category_html_title = ucwords(preg_replace('/[^\p{L}\p{Nd}]+/u', ' ', $_GET['category']));
		
		//h1 & h2 --> Title & Description
		$h1_title = '';
		$h1_description = '';
		
		$h2_title_1 = '';
		$h2_description_1 = '';
		$h2_title_2 = '';
		$h2_description_2 = '';
		$h2_title_3 = '';
		$h2_description_3 = '';
		$h2_title_4 = '';
		$h2_description_4 = '';
		
		//Bottom
		$bottom_title = '';
		$bottom_description = '';
		
		$bottom_title_1 = '';
		$bottom_description_1 = '';
		$bottom_title_2 = '';
		$bottom_description_2 = '';
		$bottom_title_3 = '';
		$bottom_description_3 = '';
		
		//SEO
		$title = '';
		$description = '';
		$meta_keyword = '';
		
		$key_query = "SELECT * FROM seo_city WHERE language='$language' AND city='".strtolower($_GET['city'])."' AND keyword='".strtolower($_GET['category'])."'";
		$key_rslt = mysqli_query($connection,$key_query);
		if(mysqli_num_rows($key_rslt) != 0){
			$key_result = mysqli_fetch_array($key_rslt);
			
			//Meta
			$meta_keyword = $key_result['meta_keyword'];
			$title = $key_result['meta_title'];
			$description = $key_result['meta_description'];
			
			//H1 & H2
			$h1_title = $key_result['h1_title'];
			$h1_description = $key_result['h1_description'];
			$h2_title_1 = $key_result['h2_title_1'];
			$h2_description_1 = $key_result['h2_description_1'];
			$h2_title_2 = $key_result['h2_title_2'];
			$h2_description_2 = $key_result['h2_description_2'];
			$h2_title_3 = $key_result['h2_title_3'];
			$h2_description_3 = $key_result['h2_description_3'];
			$h2_title_4 = $key_result['h2_title_4'];
			$h2_description_4 = $key_result['h2_description_4'];
			
			//Bottom
			$bottom_title = $key_result['bottom_title'];
			$bottom_description = $key_result['bottom_description'];
			$bottom_title_1 = $key_result['bottom_title_1'];
			$bottom_description_1 = $key_result['bottom_description_1'];
			$bottom_title_2 = $key_result['bottom_title_2'];
			$bottom_description_2 = $key_result['bottom_description_2'];
			$bottom_title_3 = $key_result['bottom_title_3'];
			$bottom_description_3 = $key_result['bottom_description_3'];
			
			$city_anchor = $key_result['city_anchor'];
			$city_outgoing_link = $key_result['city_outgoing_link'];
		}
		
		if($title == ''){
			$key_query = "SELECT * FROM seo_keywords WHERE language='$language' AND keyword = '".strtolower($_GET['category'])."'";
			$key_rslt = mysqli_query($connection,$key_query);
			
			if(mysqli_num_rows($key_rslt) != 0){
				$key_result = mysqli_fetch_array($key_rslt);
				$keywords = $key_result['meta_keyword'];
			}
			
			if($keywords == ''){
				$title = $category_html_title.' '.$city_html_title.' - '.$category_html_title.' service '.$city_html_title.' | Escort46';
			}else{
				$title = $category_html_title.' '.$city_html_title.' - '.$meta_keyword.' service '.$city_html_title.' | Escort46';
			}
		}
		
		if($description == ''){
			$description='Hier finden Sie '.$category_html_title.' Mädchen in '.$city_html_title.' du kannst finden '.$category_html_title.' im '.$city_html_title.' indem Sie hier suchen. Alles '.$city_html_title.' '.$category_html_title.' und '.$category_html_title.' Mädchen in '.$city_html_title.' sind hier.';
		}
		
		//City Anchor & Outgoing Link
		$city_anchor = '';
		$key_query = "SELECT * FROM seo_city WHERE language='$language' AND city='".strtolower($_GET['city'])."'";
		$key_rslt = mysqli_query($connection,$key_query);
		if(mysqli_num_rows($key_rslt) != 0){
			$key_result = mysqli_fetch_array($key_rslt);
			$city_anchor = $key_result['city_anchor'];
			$city_outgoing_link = $key_result['city_outgoing_link'];
		}
		
		//Keyword Anchor & Outgoing Link
		$keyword_anchor = '';
		$key_query = "SELECT * FROM seo_keywords WHERE language='$language' AND keyword = '".strtolower($_GET['category'])."'";
		$key_rslt = mysqli_query($connection,$key_query);
		
		if(mysqli_num_rows($key_rslt) != 0){
			$key_result = mysqli_fetch_array($key_rslt);
			$keyword_anchor = $key_result['keyword_anchor'];
			$keyword_outgoing_link = $key_result['keyword_outgoing_link'];
		}
		
		//Category
		$active_1 = $active_2 = $active_3 = $active_4 = $active_5 = '';
		if(strtolower($_GET['category']) == 'escort'){
			$_GET['categories'] = 1;
			$get_category = 'escort';
			$active_1 = 'active';
		}elseif(strtolower($_GET['category']) == 'massagekliniken'){
			$_GET['categories'] = 2;
			$get_category = 'massagekliniken';
			$active_2 = 'active';
		}elseif(strtolower($_GET['category']) == 'escort-agenturen'){
			$_GET['categories'] = 3;
			$get_category = 'escort-agenturen';
			$active_3 = 'active';
		}elseif(strtolower($_GET['category']) == 'thailandische-massage'){
			$_GET['categories'] = 4;
			$get_category = 'thailandische-massage';
			$active_4 = 'active';
		}elseif(strtolower($_GET['category']) == 'events'){
			$_GET['categories'] = 5;
			$get_category = 'events';
			$active_5 = 'active';
		}else{
			$_GET['category'] = 'escort';
			$_GET['categories'] = 1;
			$get_category = 'escort';
		}
	}
	$ucw_category = ucwords(preg_replace('/[^\p{L}\p{Nd}]+/u', ' ', $get_category));
?>
<!DOCTYPE html>
<html lang="<?= $language ?>">
<head>
	<?php include_once "new_head.php"; ?>
</head>
<body id="myPage">
  <?php if ($website_h1_position == 'top_head_position') { ?><h1 class="htag-top"> <?php include "Section_content_h1.php"; ?></h1><?php } ?>
    <div id="mobile-indicator"></div>
    <div id="page-wrapper">
    	<?php include_once "header.php"; ?>
	    <section id="content" class="<?= $container.' '.$cont_fluid_bg_class ?> container-fluid">
			<div class="col-sm-12 col-md-12 col-xs-12 col-lg-12 no-padding">
			<?php
				if($page_ad_active == 1 || $page_top_ad_active == 1 || $page_left_ad_active == 1 || $page_right_ad_active == 1 || WEBSITE_PAGE_LAYOUT=="small"){
			?>
				    <div class="col-sm-12 col-md-1 col-xs-12 col-lg-1"></div>
			<?php } ?>
	    <div class="<?= $page_ad_bs_class ?>">
            <div class="search-box-wrapper mt-100">
                <div class="search-box <?= $section_container ?>">
                    <section class="title-section">
						<div class="keel-container">
	  						<?php if ($website_h1_position == 'default') { ?><h1 class=""> <?php include "Section_content_h1.php"; ?></h1><?php } ?>
	  							<?php
			                		if($h1_description == ''){
									if(@H1_DISCRIPTION && @H1_DISCRIPTION != 'H1_DISCRIPTION'){ 
										$value1 = H1_DISCRIPTION;
										$value1 = repss("%%category%%",$category_html_title,$value1);
										$value1 = repss("%%city%%",$_GET['omrade1'],$value1);
										$value1 = repss("%%total%%",'<b id="total_profiles">'.$total_records.'</b>',$value1);
										?>
									<p id="read1 more1" class="key_description"><?php echo $value1; ?></p>
									<?php }else{
									?>
									<p id="read1 more1" class="key_description">	Im <?= $_GET['omrade1'] ?> wir haben <b id="total_profiles"><?= $total_records ?></b> <?= $category_html_title ?> Anzeigen online.</p>
									<?php
									} ?>
										
									<?php
										}else{
											echo '<p id="read_more1" class="key_description">'.$h1_description.'</p>';
										}
			                		?>	
						</div>
					</section>
                    
                    <div class="row pl-15 mb-10">
				        <ul class="breadcrumbs">
				            <li><a href="<?= SUB_URL ?>"><i class="glyphicon glyphicon-home"></i></a></li>
				    <?php
						if($keyword_anchor != '' && $keyword_outgoing_link != ''){
					?>
				            <li><a href="<?= $keyword_outgoing_link ?>"><?= $keyword_anchor ?></a></li>
				    <?php
						}else{
					?>
							<li><a href="<?= SUB_URL.'/'.$get_category ?>"><?= $ucw_category ?></a></li>
					<?php
						}
					
						if($city_anchor != '' && $city_outgoing_link != ''){
					?>
				        	<li><a href="<?= $city_outgoing_link ?>"><?= $city_anchor ?></a></li>
				    <?php
						}else{
					?>
							<li><a href="<?= SUB_URL.'/'.$get_category.'/'.friendly_seo_string($city_html_title) ?>"><?= $city_html_title ?></a></li>
					<?php
						}
					?>
				        </ul>
					</div>
					
                    <div class="search-tab-content">
                        <?php include_once "section_search.php"; ?>
                    </div>
                </div>
            </div>
            
            <div class="global-map-area section parallax pt-0" data-stellar-background-ratio="0.5">
                <div class="<?= $section_container ?>">
                    <div class="image-carousel style3 flex-slider">
                        <?php include_once "section_flex_slider.php"; ?>
                    </div>
                </div>
            </div>
            
            <?php include_once "section_boost.php"; ?>
            
            <div class="<?= $section_container ?> section pt-0">
                <div class="row image-box style10 list-padding list-group allProfiles" id="products">
        			<?php include_once "section_profiles.php"; ?>
                </div>
				<script async type="application/javascript" src="https://a.magsrv.com/ad-provider.js"></script> <ins class="eas6a97888e20" data-zoneid="5094950"></ins> <script>(AdProvider = window.AdProvider || []).push({"serve": {}});</script>
                <div class="col-xs-12 col-md-12 col-lg-12 col-sm-12 show_more_gif" id="show_more_gif"></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="show_more"></button></div>
            </div>
            <?php if(!empty(WEBSITE_SECTION_KEYWORD) && trim(WEBSITE_SECTION_KEYWORD)=="Active"){ ?>
	    		<?php include_once "section_content_keyword.php"; ?>
	    	<?php } ?>
          
            <?php include_once "section_content_city.php"; ?>
            <?php include_once "section_content_region.php"; ?>
            <?php include "section_content.php"; ?>
            <?php include "section_content_buttom.php"; ?>
            	</div>
		<?php
			if($page_ad_active == 1 || $page_top_ad_active == 1 || $page_left_ad_active == 1 || $page_right_ad_active == 1 || WEBSITE_PAGE_LAYOUT=="small"){
		?>
			    <!-- <div class="col-sm-12 col-md-1 col-xs-12 col-lg-1"></div> -->
		<?php
			}
		?>
            </div>
        </section>
        
        <footer id="footer">
            <div class="footer-wrapper">
                <?php include_once 'footer.php';  ?>
            </div>
        </footer>
    </div>

	<?php include_once 'js_zone.php'; ?>
	<?php include_once 'load_data_js.php'; ?>

</body>
</html>

Al-HUWAITI Shell