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/admin/service/ |
<?php
include "../db_connection.php";
include "../sessioncheck.php";
$lang = $_GET['slang'];
$city = $_GET['city'];
$get_keyword = $_GET['keyword'];
$lang = $_GET['slang'];
///////////////start //////////////////////////////
if(!empty($_GET['id']) && !empty($_GET['slang'])){
$id = $_GET['id'];
$lang = $_GET['slang'];
#fetch the record of this Id
$sql=mysqli_query($connection,"SELECT * FROM seo_city WHERE id=$id");
$row = mysqli_fetch_assoc($sql);
$data = array();
//$row['language'] ="da";
// echo "<pre>";print_r($row);
//if(trim($row["language"])=="" || (trim($row["language"])==$lang_site_main_lang){
if(trim($lang)==$lang_site_main_lang){
#main lang
if(trim($row['language'])=="" || trim($row['language'])==$lang_site_main_lang){
$data =$row;
}else{
#convert this adservices into other lang
$csql = "select * from cities where ".$row['language']."_city ='".$row['city']."' ";
$sql_city=mysqli_query($connection,$csql);
$row_city = mysqli_fetch_assoc($sql_city);
$tmp = $lang."_city";
$decoded_city = $row_city[$tmp];
$sql_seo_city=mysqli_query($connection, "SELECT * FROM seo_city WHERE city='".$decoded_city."' and language='".$lang."'");
$row_seo_city = mysqli_fetch_assoc($sql_seo_city);
if(!empty($row_seo_city['id'])){
$data =$row_seo_city;
}else{ //if(!empty($row_seo_city['id']))
$data = array("adservice"=>$decoded_city);
}
}
}else{
#sub domain
if(trim($row['language'])==$lang){
$data =$row;
}elseif(trim($row['language'])=="" || trim($row['language'])==$lang_site_main_lang){
#convert this adservices into other lang
$ss = "select * from cities where ".$row['language']."_city ='".$row['city']."' ";
$sql_city=mysqli_query($connection,$ss);
$row_city = mysqli_fetch_assoc($sql_city);
$tmp = $lang."_city";
$decoded_city = $row_city[$tmp];
$sql_seo_city=mysqli_query($connection, "SELECT * FROM seo_city WHERE city='".$decoded_city."' and language='".$lang."'");
$row_seo_city = mysqli_fetch_assoc($sql_seo_city);
if(!empty($row_seo_city['id'])){
$data =$row_seo_city;
}else{ //if(!empty($row_seo_city['id']))
$data = array("adservice"=>$decoded_city);
}
}
}
}
$lang_site_main_lang = $lang = $_GET['slang'];
$changed_city = $data['adservice'];
if(!$changed_city){
$changed_city = $data['city'];
}
/////////////// end //////////////////////////////
$query = "SELECT * from seo_city WHERE `language` = '$lang' and `city` = '$changed_city'";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
$tmp_array = json_decode($row["meta_values"], true);
?>
<div class="card">
<div class="card-body">
<input type="hidden" name="id" id="id" value="<?= $row["id"] ?>" />
<div class="form-group">
<label for="city">cities</label>
<input type="text" name="city" id="city" class="form-control input-sm" title="city" placeholder="city" value="<?= $changed_city ?>" required />
</div>
<div class="form-group">
<label for="keyword">Keyword</label>
<input type="text" name="keyword" id="keyword" class="form-control input-sm" title="Keyword" placeholder="Keyword" value="<?= $get_keyword ?>" required />
</div>
<div class="form-group">
<label for="meta_keyword">Meta Keyword</label>
<input type="text" name="meta_keyword" id="meta_keyword" class="form-control input-sm" title="Meta Keyword" placeholder="Meta Keyword" value="<?= $row["meta_keyword"] ?>" />
</div>
<div class="form-group">
<label for="meta_title">Meta Title</label>
<input type="text" name="meta_title" id="meta_title" class="form-control input-sm" title="Meta Title" placeholder="Meta Title" value="<?= $row["meta_title"] ?>" />
</div>
<div class="form-group">
<label for="meta_description">Meta Description</label>
<input type="text" name="meta_description" id="meta_description" class="form-control input-sm" title="Meta Description" placeholder="Meta Description" value="<?= $row["meta_description"] ?>" />
</div>
<!-- <div class="form-group">
<label for="h1_title">H1 Title</label>
<input type="text" name="h1_title" id="h1_title" class="form-control input-sm" title="H1 Title" placeholder="H1 Title" value="<?= $row["h1_title"] ?>" />
</div>
<div class="form-group">
<label for="h1_description">H1 Description</label>
<textarea class="form-control input_border_radius input-sm" id="h1_description" rows="7" name="h1_description" title="H1 Description" placeholder="H1 Description"><?php echo $row['h1_description']; ?></textarea>
</div> -->
<div class="form-group">
<label for="city_anchor">city Anchor</label>
<input type="text" name="city_anchor" id="city_anchor" class="form-control input-sm" title="city Anchor" placeholder="city Anchor" value="<?= $row["city_anchor"] ?>" />
</div>
<div class="form-group">
<label for="city_outgoing_link">city Outgoing Link</label>
<input type="text" name="city_outgoing_link" id="city_outgoing_link" class="form-control input-sm" title="city Outgoing Link" placeholder="city Outgoing Link" value="<?= $row["city_outgoing_link"] ?>" />
</div>
<button type="submit" id="submit" class="btn btn-primary d-none">Edit</button>
<input type="hidden" name="Process" id="Process" value="EditNow" />
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
<!-- /.card -->
<div class="card">
<div class="card-header">
<h3 class="card-title"> H1</h3>
<div class="float-right">
<label class="switch">
<input type="checkbox" class="switch-input" value="1" name="h1_status" <?php if($tmp_array["h1_status"]){
echo "checked";
} ?>>
<span class="switch-label" data-on="On" data-off="Off"></span>
<span class="switch-handle"></span>
</label>
</div>
</div>
<div class="card-body">
<div class="form-group">
<label for="meta_keyword">H1 Title</label>
<input type="text" class="form-control" id="meta_keyword" name="h1_title" placeholder="Title" value="<?= rtxt($row["h1_title"]) ?>">
</div>
<div class="form-group">
<label for="country">H1 Description</label>
<textarea class="form-control input_border_radius input-sm" id="footer_description" rows="2" name="h1_description" title="Meta Description" placeholder=" Description" ><?php echo rtxt($row['h1_description']); ?></textarea>
</div>
</div>
</div>
<div class="card">
<div class="card-header">
<h3 class="card-title"> Above Footer (section 1)</h3>
<div class="float-right">
<label class="switch">
<input type="checkbox" class="switch-input" value="1" name="above_footer_status_section_1" <?php if($tmp_array["above_footer_status_section_1"]){
echo "checked";
} ?>>
<span class="switch-label" data-on="On" data-off="Off"></span>
<span class="switch-handle"></span>
</label>
</div>
</div>
<div class="card-body">
<div class="TextBoxContainer" id="TextBoxContainer">
<?php
$u=0;
$sql = "SELECT `id`, `language`, `page`, `key`, `value`, `value1` FROM `seo_detail` WHERE `language` = '" .$lang_site_main_lang. "' and `page` = 'city' and `key` = 'footer_section_1' and `city` = '$changed_city'";
$result = mysqli_query($connection, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
$h=0;
while($row = mysqli_fetch_assoc($result)) {
$id = $row["id"];
$language = $row["language"];
$page = $row["page"];
$key = $row["key"];
$value = $row["value"];
$value1 = $row["value1"];
$h++;
if($h != 1){
continue;
}
?>
<div class="form-group label">
<!-- <label for="meta_keyword" style="width:100%">Title H
<button type="button" id="delete_user_1" type="button" class="remove btn text-danger float-right" value="remove" style="padding:0px"><i class="fa fa-trash fa-lg"></i></button>
</label>
<input type="text" class="form-control" id="meta_keyword" name="footer_title_section_1[]" placeholder="Title" value="<?PHP ECHO $value ; ?>"> -->
<!-- <label for="country">Description</label> -->
<?php $six_digit_random_number = random_int(100000, 999999); ?>
<textarea class="form-control input_border_radius input-sm discription_main" id="p<?php echo $six_digit_random_number; ?>" rows="5" name="meta_description_section_1[]" title="Meta Description" placeholder="Meta Description" ><?php echo $value1 ?></textarea>
</div>
<script type="text/javascript">
setTimeout(() => {
var textarea = document.getElementById("p<?php echo $six_digit_random_number; ?>");
// CKEditor.replace(textarea);
CKEDITOR.replace(textarea,{
versionCheck: false
});
}, 1000);
</script>
<?php
}
} else {
?>
<div class="form-group label">
<label for="meta_keyword" style="width:100%">Title H
<button type="button" id="delete_user_1" type="button" class="remove btn text-danger float-right" value="remove" style="padding:0px"><i class="fa fa-trash fa-lg"></i></button>
</label>
<input type="text" class="form-control" id="meta_keyword" name="footer_title_section_1[]" placeholder="Title" value="<?PHP ECHO $value ; ?>">
<label for="country">Description</label>
<?php $six_digit_random_number = random_int(100000, 999999); ?>
<textarea class="form-control input_border_radius input-sm discription_main" id="p<?php echo $six_digit_random_number; ?>" rows="5" name="meta_description_section_1[]" title="Meta Description" placeholder="Meta Description" ><?php echo $value1 ?></textarea>
</div>
<script type="text/javascript">
setTimeout(() => {
var textarea = document.getElementById("p<?php echo $six_digit_random_number; ?>");
// CKEditor.replace(textarea);
CKEDITOR.replace(textarea,{
versionCheck: false
});
}, 1000);
</script>
<?php
}
?>
</div>
<!-- <button id="btnAdd" type="button" value="Add" class="btn btn-info btn btn-block" /><i class="fa fa-plus fa-md" style="color: ;"></i> Add</button> -->
</div>
</div>
<div class="card">
<div class="card-header">
<h3 class="card-title">Above Footer (section 2)</h3>
<div class="float-right">
<label class="switch">
<input type="checkbox" class="switch-input" value="1" name="above_footer_status" <?php if($tmp_array["above_footer_status"]){
echo "checked";
} ?>>
<span class="switch-label" data-on="On" data-off="Off"></span>
<span class="switch-handle"></span>
</label>
</div>
</div>
<div class="card-body">
<div class="form-group">
<label for="meta_keyword">Title</label>
<input type="text" class="form-control" id="meta_keyword_main" name="footer_title" placeholder="Title" value="<?php echo @$tmp_array["footer_title"]; ?>">
</div>
<div class="form-group">
<label for="country">Description</label>
<textarea class="form-control input_border_radius input-sm" id="footer_description" rows="2" name="footer_description" title="Meta Description" placeholder=" Description" ><?php echo @$tmp_array["footer_description"]; ?></textarea>
</div>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label for="meta_keyword">Title 1</label>
<input type="text" class="form-control" id="meta_keyword" name="footer_title_1" placeholder="Title 1" value="<?php echo @$tmp_array["footer_title_1"]; ?>">
</div>
<div class="form-group">
<label for="country">Description 1 </label>
<textarea class="form-control input_border_radius input-sm" id="footer_description_1" rows="4" name="footer_description_1" title="Meta Description" placeholder=" Description 1" ><?php echo @$tmp_array["footer_description_1"]; ?></textarea>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="meta_keyword">Title 2</label>
<input type="text" class="form-control" id="meta_keyword" name="footer_title_2" placeholder="Title 2" value="<?php echo @$tmp_array["footer_title_2"]; ?>">
</div>
<div class="form-group">
<label for="country">Description 2 </label>
<textarea class="form-control input_border_radius input-sm" id="meta_description" rows="4" name="footer_description_2" title="Meta Description" placeholder="Meta Description" ><?php echo @$tmp_array["footer_description_2"]; ?></textarea>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="meta_keyword">Title 3</label>
<input type="text" class="form-control" id="meta_keyword" name="footer_title_3" placeholder="Title 3" value="<?php echo @$tmp_array["footer_title_3"]; ?>">
</div>
<div class="form-group">
<label for="country">Description 3 </label>
<textarea class="form-control input_border_radius input-sm" id="meta_description" rows="4" name="footer_description_3" title="Description 3" placeholder="Meta Description" ><?php echo @$tmp_array["footer_description_3"]; ?></textarea>
</div>
</div>
</div>
<input type="hidden" value="<?php echo $lang_site_main_lang; ?>" id="language" name="language">
</div>
</div>