['bg' => 'rgba(46, 204, 113, 0.15)', 'border' => 'rgba(46, 204, 113, 0.4)', 'text' => '#2ecc71', 'hover' => 'rgba(46, 204, 113, 0.25)', 'badge' => '#2ecc71'], 'event' => ['bg' => 'rgba(52, 152, 219, 0.15)', 'border' => 'rgba(52, 152, 219, 0.4)', 'text' => '#3498db', 'hover' => 'rgba(52, 152, 219, 0.25)', 'badge' => '#3498db'], 'maintenance' => ['bg' => 'rgba(231, 76, 60, 0.15)', 'border' => 'rgba(231, 76, 60, 0.4)', 'text' => '#e74c3c', 'hover' => 'rgba(231, 76, 60, 0.25)', 'badge' => '#e74c3c'], 'other' => ['bg' => 'rgba(155, 89, 182, 0.15)', 'border' => 'rgba(155, 89, 182, 0.4)', 'text' => '#9b59b6', 'hover' => 'rgba(155, 89, 182, 0.25)', 'badge' => '#9b59b6'], ]; if ($is_single) { $query = "SELECT id, title, slug, content, posted_by, post_date, image_url, is_important, category FROM server_news WHERE slug = ?"; $article_stmt = $site_db->prepare($query); $article_stmt->bind_param('s', $slug); $article_stmt->execute(); $article_result = $article_stmt->get_result(); $news = $article_result->fetch_assoc(); // Row fully consumed; free the result set before closing its statement $article_result->free(); $article_stmt->close(); if (!$news) { // Nonexistent article: send a real 404 and keep the page out of // indexes. The message itself is rendered after includes/header.php // below so the document structure stays intact (existing behavior). http_response_code(404); $is_404 = true; } } else { // Validate the page parameter: must be a positive integer (it is bound // to the LIMIT/OFFSET prepared statement below as an integer anyway) $page_input = isset($_GET['page']) ? $_GET['page'] : null; $current_page = 1; if ($page_input !== null && $page_input !== '' && filter_var($page_input, FILTER_VALIDATE_INT) !== false) { $current_page = max(1, (int)$page_input); } $offset = ($current_page - 1) * $items_per_page; // Build query with category filter $where_clause = ''; $params = []; $types = ''; if (!empty($category_filter)) { $where_clause = "WHERE category = ?"; $params[] = $category_filter; $types .= 's'; } $total_query = "SELECT COUNT(*) as total FROM server_news " . $where_clause; $total_stmt = $site_db->prepare($total_query); if (!empty($params)) { $total_stmt->bind_param($types, ...$params); } $total_stmt->execute(); $total_result = $total_stmt->get_result(); $total_rows = $total_result->fetch_assoc()['total']; // Row fully consumed; free the result set before closing its statement $total_result->free(); $total_stmt->close(); // Fix: Handle case when there are no news items $total_pages = max(1, ceil($total_rows / $items_per_page)); $current_page = min($current_page, $total_pages); $offset = ($current_page - 1) * $items_per_page; // Only execute the main query if there are news items if ($total_rows > 0) { $query = "SELECT id, title, slug, content as excerpt, posted_by, post_date, image_url, is_important, category FROM server_news " . $where_clause . " ORDER BY is_important DESC, post_date DESC LIMIT ?, ?"; $news_stmt = $site_db->prepare($query); $params[] = $offset; $params[] = $items_per_page; $types .= 'ii'; $news_stmt->bind_param($types, ...$params); $news_stmt->execute(); $news_result = $news_stmt->get_result(); } else { // Create an empty result set $news_result = $site_db->query("SELECT id, title, slug, '' as excerpt, posted_by, post_date, image_url, is_important, category FROM server_news WHERE 1=0"); } // Get all categories for the filter tabs (list pages only, so single // article requests skip this query as well as the COUNT query above) $category_query = "SELECT DISTINCT category FROM server_news ORDER BY category"; $category_result = $site_db->query($category_query); $categories = []; while ($row = $category_result->fetch_assoc()) { $categories[] = $row['category']; } // Fully consumed; free it (no prepared statement to close here) $category_result->free(); } // --------------------------------------------------------------------- // Page metadata, prepared BEFORE including includes/header.php (which // owns the global document structure: DOCTYPE, , , // and the shared Tailwind / FontAwesome / Google Fonts assets). // Values are printed raw here and escaped by header.php when output. // --------------------------------------------------------------------- if ($is_single) { if ($is_404) { $page_title = translate('error_404_title', '404 - News Not Found'); $page_meta_description = translate('error_404_message', 'The news article you are looking for does not exist.'); $page_meta_robots = 'noindex, nofollow'; } else { // Single article: use the article title as-is (header.php escapes it) $page_title = $news['title']; // Generate the description from the article content: strip HTML, // truncate UTF-8-safe (header.php escapes it into the attribute) $description_source = trim(strip_tags($news['content'])); // Collapse internal whitespace/newlines into single spaces so the // description is one clean line $description_source = preg_replace('/\s+/u', ' ', $description_source); if (mb_strlen($description_source, 'UTF-8') > 150) { $page_meta_description = mb_substr($description_source, 0, 150, 'UTF-8') . '...'; } else { $page_meta_description = $description_source; } $page_meta_robots = 'index'; $page_head = ''; } } else { $page_title = $site_title_name . ' ' . translate('page_title_list', 'News'); $page_meta_description = translate('meta_description_list', 'Latest news and updates for our World of Warcraft server.'); $page_meta_robots = 'index'; $page_head = ''; } // Capture page-specific styles into $page_head, which header.php prints // at the end of the . ob_start(); ?> , , // ) and already loads Tailwind, FontAwesome and Google Fonts. include $project_root . 'includes/header.php'; // Nonexistent article: HTTP 404 was already sent; render the message inside // the document (existing behavior) and stop. if ($is_single && $is_404) { echo '

' . translate('error_404_title', '404 - News Not Found') . '

'; echo '

' . translate('error_404_message', 'The news article you are looking for does not exist.') . '

'; include $project_root . 'includes/footer.php'; exit; } ?>
<?php echo htmlspecialchars($news['title']); ?> <?php echo htmlspecialchars($news['title']); ?>

Important

'#ffffff']; $badgeColor = $colors['badge']; ?>

num_rows === 0): ?>
fetch_assoc()): ?> 180) { $excerpt = mb_substr($excerpt, 0, 180, 'UTF-8') . '...'; } ?> <?php echo htmlspecialchars($news['title']); ?> <?php echo htmlspecialchars($news['title']); ?>

Important

1): ?>
1): ?>
free(); } if (!$is_single && isset($news_stmt)) { $news_stmt->close(); } if (isset($site_db)) { $site_db->close(); } include $project_root . 'includes/footer.php';