0UT1S's

// Static Pages
$static_pages = [
    ['loc' => SITE_URL, 'priority' => '1.0', 'changefreq' => 'daily'],
    ['loc' => SITE_URL . '/pages/about', 'priority' => '0.8', 'changefreq' => 'weekly'],
    ['loc' => SITE_URL . '/pages/contact', 'priority' => '0.7', 'changefreq' => 'monthly'],
    ['loc' => SITE_URL . '/pages/terms', 'priority' => '0.6', 'changefreq' => 'yearly'],
    ['loc' => SITE_URL . '/pages/privacy', 'priority' => '0.6', 'changefreq' => 'yearly'],
    ['loc' => SITE_URL . '/pages/blog', 'priority' => '0.9', 'changefreq' => 'daily'],
    ['loc' => SITE_URL . '/pages/search', 'priority' => '0.9', 'changefreq' => 'daily']
];

foreach ($static_pages as $page) {
    echo '  <url>' . "\n";
    echo '    <loc>' . htmlspecialchars($page['loc']) . '</loc>' . "\n";
    echo '    <lastmod>' . date('Y-m-d') . '</lastmod>' . "\n";
    echo '    <changefreq>' . $page['changefreq'] . '</changefreq>' . "\n";
    echo '    <priority>' . $page['priority'] . '</priority>' . "\n";
    echo '  </url>' . "\n";
}

// Dynamic Blog Posts
$posts = $db->query("SELECT slug, updated_at FROM posts WHERE status = 'published'");
if ($posts) {
    while ($post = $posts->fetch_assoc()) {
        $url = SITE_URL . '/pages/post?slug=' . urlencode($post['slug']);
        $lastmod = date('Y-m-d', strtotime($post['updated_at'] ?? $post['created_at']));

echo '  <url>' . "\n";
        echo '    <loc>' . htmlspecialchars($url) . '</loc>' . "\n";
        echo '    <lastmod>' . $lastmod . '</lastmod>' . "\n";
        echo '    <changefreq>weekly</changefreq>' . "\n";
        echo '    <priority>0.8</priority>' . "\n";
        echo '  </url>' . "\n";
    }
}

echo '</urlset>';

// End output buffering and flush
ob_end_flush();