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
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['nationality']) && !empty($_GET['nationality'])){
//Nationality
$get_nationality = $_GET['nationality'];
$decoded=false;
$decode_nationality_qry = mysqli_query($connection,"SELECT id, $nationality_column AS nationality FROM nationalities GROUP BY $nationality_column");
while($decode_row=mysqli_fetch_assoc($decode_nationality_qry)){
if(friendly_seo_string($decode_row['nationality']) == $_GET['nationality']){
$_GET['nationality'] = $decode_row['nationality'];
$_GET['nationality_id'] = $decode_row['id'];
$decoded=true;
break;
}
}
//Nationality
$decoded=false;
$decode_nationality_qry = mysqli_query($connection,"SELECT DISTINCT $world_region_column AS world_region FROM nationalities GROUP BY $world_region_column");
while($decode_row=mysqli_fetch_assoc($decode_nationality_qry)){
if(friendly_seo_string($decode_row['world_region']) == $_GET['nationality']){
$_GET['nationality'] = $decode_row['world_region'];
$decoded=true;
break;
}
}
//HTML
$nationality_html_title = ucwords($_GET['nationality']);
$category_html_title = ucwords(preg_replace('/[^\p{L}\p{Nd}]+/u', ' ', $_GET['category']));
$h1_title = '';
$h1_description = '';
$h2_title_1 = '';
$h2_description_1 = '';
$h2_title_2 = '';
$h2_description_2 = '';
$h2_title_3 = '';
$h2_description_3 = '';
//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 = '';
$nationality_anchor = '';
$nationality_outgoing_link = '';
$key_query = "SELECT * FROM seo_nationalities WHERE language='$language' AND nationality='".$_GET['nationality']."' 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 --> Title & Description
$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'];
//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'];
//Anchor & Outgoing Link
$nationality_anchor = $key_result['nationality_anchor'];
$nationality_outgoing_link = $key_result['nationality_outgoing_link'];
}
if($meta_keyword == ''){
$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);
$meta_keyword = $key_result['meta_keyword'];
}
}
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);
$meta_keyword_title = $key_result['meta_keyword'];
}
if($meta_keyword_title == ''){
$title = $nationality_html_title.' '.$category_html_title.' - Find '.$nationality_html_title.' '.$category_html_title.' in Sweden | Escort46';
}else{
$title = $nationality_html_title.' '.$category_html_title.' - Find '.$nationality_html_title.' '.$meta_keyword_title.' in Sweden | Escort46';
}
}
if($description == ''){
$description='Here you will find '.$nationality_html_title.' '.$category_html_title.' girls. You can find '.$nationality_html_title.' '.$category_html_title.' by searching here. All '.$nationality_html_title.' '.$category_html_title.' girls are here.';
}
$key_query = "SELECT * FROM seo_nationalities WHERE language='$language' AND nationality='".$_GET['nationality']."'";
$key_rslt = mysqli_query($connection,$key_query);
if(mysqli_num_rows($key_rslt) != 0){
$key_result = mysqli_fetch_array($key_rslt);
$nationality_anchor = $key_result['nationality_anchor'];
$nationality_outgoing_link = $key_result['nationality_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']) == 'massage-clinics'){
$_GET['categories'] = 2;
$get_category = 'massage-clinics';
$active_2 = 'active';
}elseif(strtolower($_GET['category']) == 'escort-agencies'){
$_GET['categories'] = 3;
$get_category = 'escort-agencies';
$active_3 = 'active';
}elseif(strtolower($_GET['category']) == 'thai-massage'){
$_GET['categories'] = 4;
$get_category = 'thai-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("%%nationality%%",$_GET['nationality'],$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"> We have <b id="total_profiles"><?= $total_records ?></b> <?= $_GET['nationality'] ?> <?= $category_html_title ?> ads 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($nationality_anchor != '' && $nationality_outgoing_link != ''){
?>
<li><a href="<?= $nationality_outgoing_link ?>"><?= $nationality_anchor ?></a></li>
<?php
}else{
?>
<li><a href="<?= SUB_URL.'/'.friendly_seo_string($nationality_html_title).'-'.$get_category ?>"><?= $nationality_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 } ?>
<div class="section <?= $section_container ?>">
<?php include_once "section_seo_nationality.php"; ?>
</div>
<?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>