prepare("SELECT COUNT(*) FROM forum_posts p $where");
$total->execute($params);
$total_count = (int)$total->fetchColumn();
$total_pages = max(1, ceil($total_count / $per_page));
$stmt = $pdo->prepare("
SELECT p.*, u.email as user_email, u.nickname as user_nickname,
LEFT(p.content, 200) as excerpt
FROM forum_posts p
JOIN users u ON u.id = p.user_id
$where
ORDER BY p.is_pinned DESC, p.updated_at DESC
LIMIT $per_page OFFSET $offset
");
$stmt->execute($params);
$posts = $stmt->fetchAll();
require_once __DIR__ . '/includes/header.php';
?>