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/annoncelights.dk/public_html/admin/service/ |
<?php
include "../db_connection.php";
include "../sessioncheck.php";
require_once '../../Mobile_Detect.php';
$detect = new Mobile_Detect;
## Read value
$draw = $_POST['draw'];
$start = $_POST['start'];
$rowperpage = $_POST['length']; // Rows display per page
$columnIndex = $_POST['order'][0]['column']; // Column index
$columnName = $_POST['columns'][$columnIndex]['data']; // Column name
$columnSortOrder = $_POST['order'][0]['dir']; // asc or desc
$searchValue = $_POST['search']['value']; // Search value
$searchArray = array();
## Search
$searchQuery = "";
if($searchValue != ''){
$searchQuery = " AND ( `ad_id` like '%".$searchValue."%' or `message_outgoing_link` like '%".$searchValue."%' or `message_link_active` like '%".$searchValue."%' or `type` like '%".$searchValue."%') ";
}
## Total number of records without filtering
$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM page_ads_links ");
$records = mysqli_fetch_assoc($sql);
$totalRecords = $records['allcount'];
## Total number of records with filtering
$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM page_ads_links WHERE 1 ".$searchQuery);
$records = mysqli_fetch_assoc($sql);
$totalRecordwithFilter = $records['allcount'];
## Fetch records
//$query = "SELECT count(ad.id) as user_ad, u.* FROM user u LEFT JOIN advertise ad ON u.id=ad.em_id WHERE u.status!=2 ".$searchQuery." GROUP BY u.id order by ".$columnName." ".$columnSortOrder." limit ".$start.",".$rowperpage;
$query = "SELECT * FROM page_ads_links WHERE 1 ".$searchQuery." group by ad_id order by ".$columnName." ".$columnSortOrder." limit ".$start.",".$rowperpage;
$sql=mysqli_query($connection,$query);
$data = array();
while($record=mysqli_fetch_assoc($sql)){
$advrow = "SELECT * from advertise WHERE id=".$record['ad_id']." limit 1";
$advrow = mysqli_query($connection,$advrow);
$advrow=mysqli_fetch_array(@$advrow);
$status ="";
$class_status ="";
if($record['message_link_active'] == 1){
$status = 'Active';
$class_status = 'badge-success';
}else {
$status = 'Inactive';
$class_status = 'badge-danger';
}
$link = "";
if(!empty($record['message_outgoing_link'])){ $link ='<a class="search_link" href='.$record['message_outgoing_link'].' target="_blank" title="'.$record['message_outgoing_link'].'" alt="'.$record['message_outgoing_link'].'">'.substr($record['message_outgoing_link'], 0,60).'...</a>';}
$block ="";
$class_block ="";
$enc = md5("dfdHJKLHS*&)234242(*34lk3423");
$delete_text = "Do you really want to delete these Record? ";
if($detect->isMobile()){
$delete_text .="<br />";
}
$delete_text .= "This process cannot be undone!";
$ad_device_text ="";
if($record['ad_device']=="all"){
$ad_device_text ="All";
}else{
$ad_device_text ="Multi";
}
$data[] = array(
"id"=>$record['id'],
"ad_id"=>'<a href="'.MAIN_URL.'/user_detail/'.@$advrow["id"].'/'.friendly_seo_string(@$advrow["profile_tile"]).'" class="search_link" data-placement="top" data-toggle="tooltip" data-original-title="view" target="_blank" title="View Advert">'.$record['ad_id'].'</a>',
"type"=>$record['type'],
"ad_device"=>$ad_device_text,
"base"=>$record['base'],
"message_outgoing_link"=>$link,
"status"=>"<span class='lead'><span id='status_change_".$record['ad_id']."' class='status_change label_status badge ".$class_status."' data-id='".$record['ad_id']."' data-status-id='".$record['message_link_active']."' >".$status."</span></span>",
"action"=>"<a href='page_ads_links_add.php?ad_id=".$record['ad_id']."' id='edit_ad_page_link_".$record['id']."' class='edit_ad_page-link btn menu-icon vd_bg-yellow' data-id='".$record['ad_id']."' data-placement='top' data-toggle='tooltip' data-original-title='Edit Ad page Link' title='Edit Ad Page Link'><i class='fa fa-edit fa-lg'></i></a><button id='delete_ad_page_link_".$record['ad_id']."' type='button' class='btn menu-icon vd_bg-red delete_ad_page_link' data-id='".$record['ad_id']."' data-placement='top' data-toggle='modal' data-original-title='delete' title='Delete Ad Page Link' data-target='#confirmModal_".$record['ad_id']."'><i class='fa fa-trash fa-lg'></i></button>
<div class='modal fade delete_ad_page_link_model' id='confirmModal_".$record['ad_id']."'>
<div class='modal-dialog'>
<div class='modal-content delete_modal'>
<div class='modal-header'><div class='icon-box'><i class='fa fa-times' aria-hidden='true'></i></div></div>
<div class='modal-header'><h4 class='col-12 modal-title text-center'>Are you sure?</h4></div>
<div class='modal-body'>
<p>".$delete_text."</p>
</div>
<div class='modal-footer modal_footer'>
<div class='modal_foot modal_foot_confirm'>
<button type='button' class='btn btn-default btn_modal btn-confirm-delete btn-primary'>Confirm</button>
</div>
<div class='modal_foot modal_foot_close'>
<button type='button' class='btn btn-default btn_modal btn-confirm-close btn-primary' data-dismiss='modal'>Close</button>
</div>
</div>
</div>
</div>
</div>",
);
}
## Response
$response = array(
"draw" => intval($draw),
"iTotalRecords" => $totalRecords,
"iTotalDisplayRecords" => $totalRecordwithFilter,
"aaData" => $data
);
echo json_encode($response);