Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/rutzotech.com/public_html/ems/employee/developer

Free Space:

10.17 TB

🔧 Quick Actions

✏️ Editing: chat_unread.php

<?php
session_start();
include 'db.php';

header('Content-Type: application/json');

$current_user_id = $_SESSION['user_id'] ?? null;

if (!$current_user_id) {
    echo json_encode(['error' => 'Not authenticated']);
    exit;
}

// Get unread counts for user chats
$user_chats = [];
$query = "SELECT u.id, 
          (SELECT COUNT(*) FROM messages 
           WHERE ((sender_id = ? AND receiver_id = u.id) OR (sender_id = u.id AND receiver_id = ?))
           AND status = 'unread' AND receiver_id = ?) as unread_count
          FROM users u
          WHERE u.id != ? AND u.status = 'active'";
$stmt = $conn->prepare($query);
$stmt->bind_param("iiii", 
    $current_user_id, $current_user_id, $current_user_id,
    $current_user_id);
$stmt->execute();
$result = $stmt->get_result();

while ($row = $result->fetch_assoc()) {
    if ($row['unread_count'] > 0) {
        $user_chats[] = $row;
    }
}

// Get unread counts for group chats
$group_chats = [];
$query = "SELECT g.id, 
          (SELECT COUNT(*) FROM messages 
           WHERE group_id = g.id AND status = 'unread' AND sender_id != ?) as unread_count
          FROM chat_groups g
          JOIN group_members gm ON g.id = gm.group_id
          WHERE gm.user_id = ? AND g.is_active = 1";
$stmt = $conn->prepare($query);
$stmt->bind_param("ii", $current_user_id, $current_user_id);
$stmt->execute();
$result = $stmt->get_result();

while ($row = $result->fetch_assoc()) {
    if ($row['unread_count'] > 0) {
        $group_chats[] = $row;
    }
}

echo json_encode([
    'user_chats' => $user_chats,
    'group_chats' => $group_chats
]);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: chat_unread.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation