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_refresh.php

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

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

$current_user_id = $_SESSION['user_id'] ?? null;
$chat_id = $_GET['chat_id'] ?? null;
$chat_type = $_GET['chat_type'] ?? null;
$last_message_id = $_GET['last_message_id'] ?? 0;

if (!$current_user_id || !$chat_id || !$chat_type) {
    echo json_encode(['error' => 'Invalid request']);
    exit;
}

$new_messages = [];

if ($chat_type === 'user') {
    $query = "SELECT m.*, u.name AS sender_name 
              FROM messages m
              JOIN users u ON m.sender_id = u.id
              WHERE ((m.sender_id = ? AND m.receiver_id = ?) OR 
                     (m.sender_id = ? AND m.receiver_id = ?))
                AND m.is_deleted = 0
                AND m.id > ?
              ORDER BY m.created_at ASC";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("iiiii", 
        $current_user_id, $chat_id, 
        $chat_id, $current_user_id,
        $last_message_id);
} 
elseif ($chat_type === 'group') {
    $query = "SELECT m.*, u.name AS sender_name 
              FROM messages m
              JOIN users u ON m.sender_id = u.id
              WHERE m.group_id = ? AND m.is_deleted = 0
                AND m.id > ?
              ORDER BY m.created_at ASC";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("ii", $chat_id, $last_message_id);
}

$stmt->execute();
$result = $stmt->get_result();

while ($row = $result->fetch_assoc()) {
    $new_messages[] = $row;
}

echo json_encode(['new_messages' => $new_messages]);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: chat_refresh.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation