prepare('SELECT isAdmin FROM users WHERE UserId = :userId LIMIT 1'); $stmt->execute([':userId' => $userId]); $row = $stmt->fetch(PDO::FETCH_ASSOC); $isAdmin = isset($row['isAdmin']) ? (int)$row['isAdmin'] : 0; } } if ($isAdmin === 0 && stripos($currentPage, 'home') === false) { header('Location: /home'); exit(); } include_once $_SERVER['DOCUMENT_ROOT'] . '/Admi/SideBar.php'; if ($adminLevel < AdminLevel::MODERATOR) { echo <<
HTML; exit; } $reportId = isset($_GET['id']) ? (int)$_GET['id'] : 0; if ($reportId <= 0) { die('Invalid report id'); } $sql = "SELECT r.*, u.Username AS ReporterUsername FROM reports r LEFT JOIN users u ON u.UserId = r.UserId WHERE r.id = :rid LIMIT 1"; $stmt = $pdo->prepare($sql); $stmt->execute(['rid' => $reportId]); $report = $stmt->fetch(PDO::FETCH_ASSOC); if (!$report) { die('Report not found'); } $abuserId = null; $reportType = ''; $commentText = ''; if (!empty($report['Comment'])) { $parts = explode(';', $report['Comment']); if (!empty($parts[0]) && str_starts_with($parts[0], 'AbuserID:')) { $abuserId = (int)str_replace('AbuserID:', '', $parts[0]); } $reportType = $parts[1] ?? ''; $commentText = $parts[2] ?? ''; } $abuserUsername = null; if ($abuserId) { $a = $pdo->prepare("SELECT Username FROM users WHERE UserId = ?"); $a->execute([$abuserId]); $abuserUsername = $a->fetchColumn(); } $chatLogsRaw = $report['Messages'] ?? ''; $chatLogsArray = json_decode($chatLogsRaw, true); $chatLogsIsJson = is_array($chatLogsArray); $xmlContent = $report['RawXML'] ?? ''; ?>

This is not finished and not finalized, expect some updates!

Report Information
Chat Logs
XML Content

Overview

Status:

Reporter:

Abuser: —

Report Type:

Comment:

Place ID:

Game Job ID:

Created:

Chat Logs

$m): ?>

#	User ID	Message

No chat logs stored for this report.

Raw XML Content

No XML content available.

You do not have permission to use this.

Overview

Chat Logs

Raw XML Content