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/ |
<?php
$error = "";
$message = "";
include "db_connection.php";
include "sessioncheck.php";
?>
<!-- Header Start-->
<?php include("header.php"); ?>
<nav class=" navbar navbar-expand navbar-white navbar-light">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#">
<i class="fa fa-bars" style="color:white;"></i>
</a>
</li>
</ul>
<div>
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item ">Seo</li>
<li class="breadcrumb-item">Search</li>
</ol>
</div>
</nav>
<?php if ($detect->isMobile() && !$detect->isTablet()) { ?>
<style>
div.dataTables_wrapper div.dataTables_paginate {
padding-top: 1em !IMPORTANT;
text-align: center !IMPORTANT;
}
div.dataTables_wrapper div.dataTables_paginate ul.pagination {
text-align: center !IMPORTANT;
}
</style>
<?php } else { ?>
<style>
.dataTables_length {
float: left;
}
.dataTables_filter {
float: right;
}
div.dataTables_wrapper div.dataTables_info {
padding-top: 1.5em;
!IMPORTANT;
float: left;
}
div.dataTables_wrapper div.dataTables_paginate {
padding-top: 1em;
!IMPORTANT;
float: right;
}
</style>
<?php } ?>
<link rel="stylesheet" href="https://cdn.datatables.net/2.1.2/css/dataTables.dataTables.css" />
<script src="https://cdn.datatables.net/2.1.2/js/dataTables.js"></script>
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/select2.min.js"></script>
<script>
$(document).ready(function() {
var table = $('#search_table').DataTable({
responsive: true,
dom: 'lBfrtip',
"iDisplayLength": 100,
/*"aLengthMenu": [[ 100, 500, 1000, 2500, 5000, -1], [100, 500, 1000, 2500, 5000, "All"]],*/
"bsort": false,
"oLanguage": {
"oPaginate": {
"sPrevious": "Back"
},
"sSearch": '',
sLengthMenu: "<select class='custom-select custom-select-sm form-control form-control-sm'>" +
"<option value='100'>Show 100</option>" +
"<option value='500'>Show 500</option>" +
"<option value='1000'>Show 1000</option>" +
"<option value='2500'>Show 2500</option>" +
"<option value='5000'>Show 5000</option>" +
"</select>",
},
"scrollX": true,
'processing': false,
'serverSide': true,
'serverMethod': 'post',
"order": [
[6, "desc"]
],
'ajax': {
'url': 'service/load_data_seo_search'
},
'columns': [
/*{ data: 'search_id' },*/
{
data: 'action',
orderable: false
},
{
data: 'title'
},
//{ data: 'language' },
{
data: 'count'
},
{
data: 'link_count'
},
{
data: 'is_result'
},
{
data: 'search_outgoing_link'
},
{
data: 'meta_title'
},
{
data: 'meta_description'
},
{
data: 'h1_title'
},
{
data: 'h1_description'
},
]
});
$('.dataTables_filter input').attr("placeholder", "Search");
$("#search_table_length").append('<button type="button" class="btn ml-2 mr-2 btn-info delete_search_tag">Delete Multiple</button><button type="button" data-page="search" class="btn mr-2 btn-info add_genric_info">Generic Data</button>');
$("#search_table_filter").append('<button id="reload_count" type="button" class="btn btn-info" style="margin-left:5px;"><i class="fa fa-refresh"></i></button><button id="link_count" type="button" class="btn btn-info" style="margin-left:5px;">Link Count</button>');
$("#reload_count").click(function() {
$.ajax({
url: 'service/get_seo_search_reload_count',
type: 'post',
data: {
trans: "load_data"
},
success: function(data) {
alert(data);
window.location.reload();
}
});
});
$("#link_count").click(function() {
$.ajax({
url: 'service/get_seo_search_link_count',
type: 'post',
data: {
trans: "load_data"
},
success: function(data) {
alert(data);
window.location.reload();
}
});
});
$(".dataTables_scrollBody").height($(document).height() - 260);
//table.fnDraw();
});
// $('#my_table').DataTable({
// responsive: true,
// "iDisplayLength": 100
// });
$(document).ready( function () {
$('#my_table').DataTable({
responsive: true,
"iDisplayLength": 100,
"ordering": false
});
} );
// Listen for click on toggle checkbox
// $('#select-all').change(function(event) {
// console.log('working');
// if(this.checked) {
// // Iterate each checkbox
// $(':checkbox').each(function() {
// this.checked = true;
// });
// } else {
// $(':checkbox').each(function() {
// this.checked = false;
// });
// }
// });
function onClickHandler(s){
if(s.checked) {
// Iterate each checkbox
$(':checkbox').each(function() {
this.checked = true;
});
} else {
$(':checkbox').each(function() {
this.checked = false;
});
}
//use this value
}
$(document).ready(function() {
$('.js-example-basic-single').select2();
});
</script>
<!-- Header Ends-->
<!-- Content Start-->
<section class="content">
<div class="container-fluid">
<div class="card">
<!--<div class="card-header">
<h3 class="card-title"><button type="button" class="btn btn-info" onClick="window.location.href='<?php echo MAIN_URL ?>/admin/order_add'">Add Order</button> </h3>
</div>-->
<!-- /.card-header -->
<div class="card-body">
<?php include_once 'notification.php'; ?>
<div class=" ">
<div class="">
<table id="my_table" class="table table-bordered table-striped text-nowrap" width="100%">
<!-- table start-->
<thead>
<tr>
<th> <input onclick="onClickHandler(this)" type="checkbox" name="" id="select-all"> </th>
<th>S.No</th>
<th> ID</th>
<th> CATEGORY_ID</th>
<th> SERVICES</th>
<th> INCALL</th>
<th> OUTCALL</th>
<th> RADIUS</th>
<th> WARD</th>
<th> DISTRICT</th>
<th> REGION</th>
<th> ALDER</th>
<th> KON</th>
<th> BRYST</th>
<th> WEIGHT</th>
<th> HEIGHT</th>
<th> STREET</th>
<th> POST_CODE</th>
<th> CITY</th>
<th> NATIONALITY</th>
<th> COUNTRY_CODE</th>
<th> TELEPHONE_NO</th>
<th> WEBSITE</th>
<th> PROFILE_TILE</th>
<th> PROFILE_BESKRIVELSE</th>
<th> CREATEDAT</th>
<th> BOOST</th>
</tr>
</thead>
<tbody id="stbody">
<?php $sql = "SELECT `id`, `em_id`, `category_id`, `category_anchor`, `category_outgoing_link`, `business_name`, `services`, `incall`, `outcall`, `radius`, `ward`, `ward_anchor`, `ward_outgoing_link`, `district`, `district_anchor`, `district_outgoing_link`, `sub_country`, `sub_country_anchor`, `sub_country_outgoing_link`, `region`, `region_anchor`, `region_outgoing_link`, `alder`, `kon`, `bryst`, `weight`, `height`, `street`, `post_code`, `city`, `nationality`, `country_code`, `telephone_no`, `website`, `profile_tile`, `profile_beskrivelse`, `createdat`, `boost`, `boost_start_date`, `boost_end_date`, `main_profile`, `plan_id`, `start_date`, `end_date`, `update_date`, `adstatus`, `isApproved`, `event_date`, `event_time_from`, `event_time_to`, `event_place`, `event_price`, `event_register_type`, `event_reg_email`, `updated_at`, `insert_from` FROM `advertise` WHERE insert_from = '1' and em_id = '0'";
$result = mysqli_query($connection, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
$i=0;
while($row = mysqli_fetch_assoc($result)) {
$i++;
$id = $row["id"];
$em_id = $row["em_id"];
$category_id = $row["category_id"];
$category_anchor = $row["category_anchor"];
$category_outgoing_link = $row["category_outgoing_link"];
$business_name = $row["business_name"];
$services = $row["services"];
$incall = $row["incall"];
$outcall = $row["outcall"];
$radius = $row["radius"];
$ward = $row["ward"];
$ward_anchor = $row["ward_anchor"];
$ward_outgoing_link = $row["ward_outgoing_link"];
$district = $row["district"];
$district_anchor = $row["district_anchor"];
$district_outgoing_link = $row["district_outgoing_link"];
$sub_country = $row["sub_country"];
$sub_country_anchor = $row["sub_country_anchor"];
$sub_country_outgoing_link = $row["sub_country_outgoing_link"];
$region = $row["region"];
$region_anchor = $row["region_anchor"];
$region_outgoing_link = $row["region_outgoing_link"];
$alder = $row["alder"];
$kon = $row["kon"];
$bryst = $row["bryst"];
$weight = $row["weight"];
$height = $row["height"];
$street = $row["street"];
$post_code = $row["post_code"];
$city = $row["city"];
$nationality = $row["nationality"];
$country_code = $row["country_code"];
$telephone_no = $row["telephone_no"];
$website = $row["website"];
$profile_tile = $row["profile_tile"];
$profile_beskrivelse = $row["profile_beskrivelse"];
$createdat = $row["createdat"];
$boost = $row["boost"];
$boost_start_date = $row["boost_start_date"];
$boost_end_date = $row["boost_end_date"];
$main_profile = $row["main_profile"];
$plan_id = $row["plan_id"];
$start_date = $row["start_date"];
$end_date = $row["end_date"];
$update_date = $row["update_date"];
$adstatus = $row["adstatus"];
$isApproved = $row["isApproved"];
$event_date = $row["event_date"];
$event_time_from = $row["event_time_from"];
$event_time_to = $row["event_time_to"];
$event_place = $row["event_place"];
$event_price = $row["event_price"];
$event_register_type = $row["event_register_type"];
$event_reg_email = $row["event_reg_email"];
$updated_at = $row["updated_at"];
$insert_from = $row["insert_from"];
?> <tr >
<td> <input name="checkbx" class="checkbox" id="check<?php echo $i; ?>" type='checkbox' /> </td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"><?php echo $i; ?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $id ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $category_id ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $services ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $incall ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $outcall ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $radius ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $ward ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $district ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $region ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $alder ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $kon ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $bryst ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $weight ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $height ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $street ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $post_code ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $city ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $nationality ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $country_code ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $telephone_no ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $website ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $profile_tile ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $profile_beskrivelse ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $createdat ;?></td>
<td onclick="document.getElementById('check<?php echo $i; ?>').click();"> <?php echo $boost ;?></td>
</tr>
<?php }
} else { ?>
<tr> <td colspan="100">No Result Found</td> </tr>
<?php }?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
</section>
<!-- Content Ends-->
<script>
//**************************
//**************************
// Add Generic Data Start Here
//**************************
//**************************
//**************************
//**************************
// Add Generic Data End Here
//**************************
//**************************
</script>
<!-- Footer Start-->
<footer class="main-footer">
<div class="row">
<div class="col-md-3 col-sm-6 col-6">
<select class="form-control select1 js-example-basic-single" id="select-state1" placeholder="Pick a state...">
<option value="">Select a user To assign...</option>
<?php
$sql = "SELECT `id`, `usrname`, `email`, `new_email_request`, `password`, `country`, `pref_lang`, `create_date`, `activationcode`, `last_mail_sent`, `status`, `block_user`, `ip_address`, `last_login` FROM `user` WHERE 1";
$result = mysqli_query($connection, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
$q=0;
while($row = mysqli_fetch_assoc($result)) {
$id = $row["id"];
$usrname = $row["usrname"];
$email = $row["email"];
$new_email_request = $row["new_email_request"];
$password = $row["password"];
$country = $row["country"];
$pref_lang = $row["pref_lang"];
$create_date = $row["create_date"];
$activationcode = $row["activationcode"];
$last_mail_sent = $row["last_mail_sent"];
$status = $row["status"];
$block_user = $row["block_user"];
$ip_address = $row["ip_address"];
$last_login = $row["last_login"];
$q++;
?>
<option value="<?= $id ?>"><?php echo "$id - $usrname - $email"; ?></option>
<?php
}
}
?>
</select>
</div>
<div class="col-md-3 col-sm-6 col-6">
<button class="btn btn-primary btn-block" type="submit" name="submit">Assign Now</button>
</div>
</div>
</footer>
<?php include("footer.php"); ?>
<style>
/* //////////////////common start////////////// */
.content-wrapper .content {
height: calc(100vh - 112px) !important;
overflow-y: auto;
margin-top: 56px;
}
.content-wrapper .navbar {
height: 56px;
}
.main-footer {
padding: 7px 8px;
border-top: 2px solid #0002;
height: 56px;
}
::-webkit-scrollbar {
height: 6px;
width: 6px;
}
::-webkit-scrollbar-track {
background-color: white;
}
::-webkit-scrollbar-thumb {
background-color: #aaa;
border-radius: 20px;
}
::-webkit-scrollbar-thumb:hover {
background-color: #aaa;
}
.card {
border-radius: 0px;
}
@media (min-width: 768px) {
.main-footer {
transition: margin-left 0.3s ease-in-out;
margin-left: 0px!important;
}
}
/*---------------------------------switsh=====*/
.switch {
float: right;
position: relative;
display: inline-block;
vertical-align: top;
width: 56px;
height: 20px;
padding: 3px;
background-color: white;
border-radius: 18px;
box-shadow: inset 0 -1px white, inset 0 1px 1px rgba(0, 0, 0, 0.05);
cursor: pointer;
background-image: -webkit-linear-gradient(top, #eeeeee, white 25px);
background-image: -moz-linear-gradient(top, #eeeeee, white 25px);
background-image: -o-linear-gradient(top, #eeeeee, white 25px);
background-image: linear-gradient(to bottom, #eeeeee, white 25px);
}
.switch-input {
position: absolute;
top: 0;
left: 0;
opacity: 0;
}
.switch-label {
position: relative;
display: block;
height: inherit;
font-size: 10px;
text-transform: uppercase;
background: #eceeef;
border-radius: inherit;
box-shadow: inset 0 1px 2px rgba(0, 0, 0, 0.12), inset 0 0 2px rgba(0, 0, 0, 0.15);
-webkit-transition: 0.15s ease-out;
-moz-transition: 0.15s ease-out;
-o-transition: 0.15s ease-out;
transition: 0.15s ease-out;
-webkit-transition-property: opacity background;
-moz-transition-property: opacity background;
-o-transition-property: opacity background;
transition-property: opacity background;
}
.switch-label:before, .switch-label:after {
position: absolute;
top: 50%;
margin-top: -.5em;
line-height: 1;
-webkit-transition: inherit;
-moz-transition: inherit;
-o-transition: inherit;
transition: inherit;
}
.switch-label:before {
content: attr(data-off);
right: 11px;
color: #aaa;
text-shadow: 0 1px rgba(255, 255, 255, 0.5);
}
.switch-label:after {
content: attr(data-on);
left: 11px;
color: white;
text-shadow: 0 1px rgba(0, 0, 0, 0.2);
opacity: 0;
}
.switch-input:checked ~ .switch-label {
background: #47a8d8;
box-shadow: inset 0 1px 2px rgba(0, 0, 0, 0.15), inset 0 0 3px rgba(0, 0, 0, 0.2);
}
.switch-input:checked ~ .switch-label:before {
opacity: 0;
}
.switch-input:checked ~ .switch-label:after {
opacity: 1;
}
.switch-handle {
position: absolute;
top: 4px;
left: 4px;
width: 18px;
height: 18px;
background: white;
border-radius: 10px;
box-shadow: 1px 1px 5px rgba(0, 0, 0, 0.2);
background-image: -webkit-linear-gradient(top, white 40%, #f0f0f0);
background-image: -moz-linear-gradient(top, white 40%, #f0f0f0);
background-image: -o-linear-gradient(top, white 40%, #f0f0f0);
background-image: linear-gradient(to bottom, white 40%, #f0f0f0);
-webkit-transition: left 0.15s ease-out;
-moz-transition: left 0.15s ease-out;
-o-transition: left 0.15s ease-out;
transition: left 0.15s ease-out;
}
.switch-handle:before {
content: '';
position: absolute;
top: 50%;
left: 50%;
margin: -6px 0 0 -6px;
width: 12px;
height: 12px;
background: #f9f9f9;
border-radius: 6px;
box-shadow: inset 0 1px rgba(0, 0, 0, 0.02);
background-image: -webkit-linear-gradient(top, #eeeeee, white);
background-image: -moz-linear-gradient(top, #eeeeee, white);
background-image: -o-linear-gradient(top, #eeeeee, white);
background-image: linear-gradient(to bottom, #eeeeee, white);
}
.switch-input:checked ~ .switch-handle {
left: 40px;
box-shadow: -1px 1px 5px rgba(0, 0, 0, 0.2);
}
.switch-green > .switch-input:checked ~ .switch-label {
background: #4fb845;
}
/* //////////////////common end////////////// */
/*/////////////////for page//////////////////*/
.dataTables_length {
right: 150px;
}
.sidebar-collapse div.dataTables_wrapper div.dataTables_paginate {
left: calc(254px + 4.6rem);
}
div.dataTables_wrapper div.dataTables_paginate {
left: calc(254px + 250px);
}
}
div.dataTables_wrapper div.dataTables_info {
padding-left: 6px;
}
@media only screen and (max-width: 776px) {
/* .main-footer {
height: 86px;
}
.dataTables_length {
bottom: 65px;
}
div.dataTables_wrapper div.dataTables_filter {
bottom: 26px;
right: unset;
}
div.dataTables_wrapper div.dataTables_info {
font-size: 12px;
}
div.dataTables_paginate {
left: unset;
}
.page-link {
padding: 1px 12px;
}*/
}
/*/////////////////for page end//////////////////*/
</style>
<script type="text/javascript">
// var widthfilter = window.getComputedStyle(document.getElementById('search_table_filter')).width;;
// console.log('widthfilter',widthfilter);
</script>