query("SELECT role FROM users WHERE id = {$_SESSION['user_id']}")->fetch_assoc(); if (($check['role'] ?? '') !== 'admin') { die("Access Denied"); } $ticket_id = intval($_GET['id']); $ticket = $conn->query("SELECT * FROM tickets WHERE id = $ticket_id")->fetch_assoc(); // HANDLE ADMIN REPLY if (isset($_POST['admin_reply'])) { $message = $conn->real_escape_string($_POST['message']); $status = $_POST['status']; // Can set to 'answered' or 'closed' // 0 is Admin ID in replies table $stmt = $conn->prepare("INSERT INTO ticket_replies (ticket_id, user_id, message) VALUES (?, 0, ?)"); $stmt->bind_param("is", $ticket_id, $message); if($stmt->execute()) { $conn->query("UPDATE tickets SET status = '$status', updated_at = NOW() WHERE id = $ticket_id"); header("Location: ticket_reply.php?id=$ticket_id"); exit(); } } ?> Reply Ticket #<?php echo $ticket_id; ?>
← Back
Ticket #:
query("SELECT * FROM ticket_replies WHERE ticket_id = $ticket_id ORDER BY created_at ASC"); while($reply = $replies->fetch_assoc()): $is_admin = ($reply['user_id'] == 0); $bg_class = $is_admin ? "bg-primary text-white ms-auto" : "bg-white border me-auto"; $label = $is_admin ? "You (Support)" : "User"; ?>