prepare('SELECT * FROM users WHERE UserId = :uID'); $FindUser->bindParam("uID", $uid, PDO::PARAM_INT); $FindUser->execute(); $row = $FindUser->fetch(PDO::FETCH_ASSOC); if (!$row) { exit("user doesn't exist"); } $stmt = $pdo->prepare("SELECT membership FROM users WHERE userid = ?"); $stmt->execute([$uid]); $membership = $stmt->fetchColumn(); function renderUserStatus(?int $userId = null): string { global $pdo; if ($userId === null) { foreach ($_GET as $key => $value) { if (strcasecmp($key, 'id') === 0 && is_numeric($value)) { $userId = (int)$value; break; } } } if ($userId === null || $userId <= 0) { return offlineSpan(); } $stmt = $pdo->prepare('SELECT status FROM users WHERE UserId = :userId LIMIT 1'); $stmt->execute(['userId' => $userId]); $row = $stmt->fetch(PDO::FETCH_ASSOC); if (!$row || !is_numeric($row['status'])) { return offlineSpan(); } $map = [ 1 => ['[ Online: Website ]', 'red'], 2 => ['[ Online: In-Game ]', 'green'], 3 => ['[ Online: Studio ]', 'orange'], ]; $status = (int)$row['status']; if (!isset($map[$status])) { return offlineSpan(); } [$text, $color] = $map[$status]; return sprintf('%s', $color, htmlspecialchars($text, ENT_QUOTES, 'UTF-8')); } function offlineSpan(): string { return '[ Offline ]'; } $loggedIn = isset($_COOKIE['_ROBLOSECURITY']) && ($user = getuserinfo($_COOKIE['_ROBLOSECURITY'])); $from_id = $loggedIn ? (int)$user['UserId'] : 0; $to_id = 0; foreach (['id', 'ID', 'Id', 'iD'] as $key) { if (isset($_GET[$key])) { $to_id = (int)$_GET[$key]; break; } } ?>