prepare('SELECT Membership, isAdmin FROM users WHERE UserId = :userId LIMIT 1'); $stmt->bindParam(':userId', $userId, PDO::PARAM_INT); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); $adminLevel = (int)($row['isAdmin'] ?? 0); $isAdmin = in_array($adminLevel, [2, 3, 4, 5]) ? 1 : 0; } else { $isAdmin = 0; } $stmt = $pdo->prepare(" SELECT UserId, Username, JoinData, isAdmin, Membership FROM users WHERE UserId = ? "); $stmt->execute([$userId]); $user = $stmt->fetch(PDO::FETCH_ASSOC); $viewCookie = 'viewed_' . $videoId; if (!isset($_COOKIE[$viewCookie])) { $stmt = $pdo->prepare("UPDATE videos SET views = COALESCE(views, 0) + 1 WHERE id = ?"); $stmt->execute([$videoId]); setcookie($viewCookie, '1', time() + 3600); } $stmt = $pdo->prepare(" SELECT v.*, u.UserId AS uploader_id, u.Username FROM videos v JOIN users u ON u.UserId = v.uploaderId WHERE v.id = ? "); $stmt->execute([$videoId]); $video = $stmt->fetch(PDO::FETCH_ASSOC); if (!$video) { echo "Video not found."; exit; } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['postComment'])) { $comment = trim($_POST['comment'] ?? ''); if (!$userId) { $commentError = "You must be logged in to comment."; } elseif (empty($comment)) { $commentError = "Comment cannot be empty."; } else { $stmt = $pdo->prepare("INSERT INTO videocomments (video_id, user_id, comment) VALUES (?, ?, ?)"); $stmt->execute([$videoId, $userId, $comment]); header("Location: watch.aspx?id=" . $videoId); exit; } } $stmt = $pdo->prepare(" SELECT c.*, u.Username FROM videocomments c JOIN users u ON c.user_id = u.UserId WHERE c.video_id = ? ORDER BY c.created_at DESC "); $stmt->execute([$videoId]); $comments = $stmt->fetchAll(PDO::FETCH_ASSOC); ob_end_flush(); ?> AFTERWORLD Videos - <?= htmlspecialchars($video['title']) ?>

Uploaded by | views | Uploaded on

No description found.

Comments

0): ?>
Avatar

No comments yet.