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/ |
<?php
if(isset($_POST['user_session_id']) && !empty($_POST['user_session_id'])){
$user_session_id = $_POST['user_session_id'];
include "db_connection.php";
}else{
$user_session_id = $_SESSION['id'];
}
?>
<ul class="list-unstyled">
<?php
$supprt_ticket_tbl="SELECT st.*,ap.uname FROM support_tickets AS st INNER JOIN adminpanel ap ON st.admin_id = ap.id WHERE user_id=".$user_session_id." ORDER BY date_time DESC";
$supprt_ticket_result = mysqli_query($connection,$supprt_ticket_tbl);
while($tickets = mysqli_fetch_assoc($supprt_ticket_result)){
?>
<li class="left clearfix supportchat" data-active-id="<?= $tickets['is_active'] ?>" data-ticket-id="<?php echo $tickets['id']; ?>">
<span class="chat-img pull-left">
<img src="<?php echo MAIN_URL; ?>/images/default-person.png" alt="User" class="img-circle">
</span>
<div class="chat-body clearfix">
<div class="header_sec">
<strong class="primary-font">
<?php echo $tickets['uname']; ?>
</strong>
</div>
<div class="contact_sec">
<span class="badge pull-right">
<?php echo date("d-m-Y H:i",strtotime($tickets['date_time'])); ?>
</span>
<?php
$supprt_tbl="SELECT count(*) as unreadmsg FROM support WHERE user_id=".$tickets['admin_id']." AND user_type='Admin' AND is_read=0 AND ticket_id=".$tickets['id'];
$supprt_result = mysqli_query($connection,$supprt_tbl);
$unread = mysqli_fetch_assoc($supprt_result);
if($unread['unreadmsg']!=0){
?>
<span id="unread_badge_<?= $tickets['id'] ?>" class="badge pull-left">
<?php echo $unread['unreadmsg']; ?>
</span>
<?php
}
?>
</div>
</div>
</li>
<?php
}
?>
</ul>