prepare("SELECT id, sender_id FROM reports WHERE id = ? AND resolved_by IS NULL"); $stmt->execute([$id]); $row = $stmt->fetch(PDO::FETCH_ASSOC) ?: null; if (!$row) { generate_alert("/system/reports/", "Report ID $id not found", 404); exit(); } $db->prepare("UPDATE reports SET resolved_by = ?, response_message = ? WHERE id = ?") ->execute([$_SESSION['user_id'], str_safe($_POST['response'], null), $id]); $db->prepare("INSERT INTO inbox_messages(recipient_id, message_type, contents, link) VALUES (?, ?, ?, ?)") ->execute([$row["sender_id"], "2", "Your report has been reviewed!", "/report/?id=" . $row["id"]]); generate_alert("/system/reports", 'The report has been reviewed!', 200);