prepare("SELECT * FROM forum_topics WHERE slug = ? OR id = ?"); $stmt->execute([$topic_slug, intval($topic_slug)]); $topic = $stmt->fetch(PDO::FETCH_ASSOC); if (!$topic) { header('HTTP/1.0 404 Not Found'); $page_title = "Topic Not Found"; include __DIR__ . '/../includes/header.php'; echo '

Topic Not Found

This topic may have been removed or does not exist.

Back to Forum
'; include __DIR__ . '/../includes/footer.php'; exit; } // Increment view count $db->exec("UPDATE forum_topics SET view_count = view_count + 1 WHERE id = {$topic['id']}"); // Get topic author $stmt = $db->prepare("SELECT * FROM users WHERE id = ?"); $stmt->execute([$topic['user_id']]); $author = $stmt->fetch(PDO::FETCH_ASSOC); // Get replies with pagination $page = max(1, intval($_GET['page'] ?? 1)); $per_page = 20; $offset = ($page - 1) * $per_page; $total_replies = $db->query("SELECT COUNT(*) FROM forum_replies WHERE topic_id = {$topic['id']} AND status = 'active'")->fetchColumn(); $total_pages = ceil($total_replies / $per_page); $replies = $db->query(" SELECT r.*, u.name as author_name, u.avatar as author_avatar, u.rank_level, u.badges, u.points, (SELECT COUNT(*) FROM forum_replies WHERE user_id = u.id) as author_posts FROM forum_replies r LEFT JOIN users u ON r.user_id = u.id WHERE r.topic_id = {$topic['id']} AND r.status = 'active' ORDER BY r.created_at ASC LIMIT $per_page OFFSET $offset ")->fetchAll(PDO::FETCH_ASSOC); // Handle new reply $error = ''; $success = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST' && isLoggedIn()) { if (!verifyCSRF($_POST['csrf'] ?? '')) { $error = 'Invalid form submission'; } elseif ($topic['is_locked']) { $error = 'This topic is locked'; } else { $content = trim($_POST['content'] ?? ''); if (strlen($content) < 10) { $error = 'Reply must be at least 10 characters'; } else { $current_user = getCurrentUser(); $stmt = $db->prepare("INSERT INTO forum_replies (topic_id, user_id, content) VALUES (?, ?, ?)"); $stmt->execute([$topic['id'], $current_user['id'], $content]); // Update topic $db->exec("UPDATE forum_topics SET reply_count = reply_count + 1, last_reply_at = datetime('now'), last_reply_by = {$current_user['id']} WHERE id = {$topic['id']}"); // Award points addPoints($current_user['id'], 5, 'forum_reply', "Reply to: {$topic['title']}"); $success = 'Reply posted successfully!'; header("Location: /forum/topic/{$topic['slug']}/?page=" . ceil(($total_replies + 1) / $per_page) . "#reply-" . $db->lastInsertId()); exit; } } } global $FORUM_CATEGORIES, $USER_RANKS; $category = $FORUM_CATEGORIES[$topic['category']] ?? ['name' => 'General', 'icon' => '💬']; $page_title = $topic['title'] . " - Forum"; include __DIR__ . '/../includes/header.php'; ?>
Forum › › ...

📌 Pinned 🔒 Locked

👁️ views 💬 replies 📅
points • Member since
0): ?>

💬 Replies

posts
✅ Solution
👍 Helpful () 🔗 Share ✅ Mark as Solution
1): ?>

💬 Post a Reply