<?php
require_once('inc/config.php');

header("Content-Type: application/xml; charset=utf-8");

echo '<?xml version="1.0" encoding="UTF-8"?>' . PHP_EOL;
echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">' . PHP_EOL;

$today       = date('Y-m-d');
$currentDir  = basename(__DIR__);
$special     = [$currentDir, 'archives'];

// Generate sitemap entries from the `pages` table
$stmt = $mysqli->prepare("SELECT name FROM pages WHERE name NOT IN ('search', 'login', 'signup', 'account', 'payment')");
$stmt->execute();
$stmt->bind_result($name);

while ($stmt->fetch()) {
	// Determine URL
	$loc       = ($name === $currentDir) ? $baseurl : "{$baseurl}{$name}";

	// Determine changefreq and priority
	$isSpecial = in_array($name, $special, true);
	$freq      = $isSpecial ? 'daily' : 'monthly';
	$priority  = $isSpecial ? '1.0' : '0.8';

	// Output sitemap URL block
	echo "<url>\n";
	echo "  <loc>{$loc}</loc>\n";
	echo "  <lastmod>{$today}</lastmod>\n";
	echo "  <changefreq>{$freq}</changefreq>\n";
	echo "  <priority>{$priority}</priority>\n";
	echo "</url>\n";
}

$stmt->close();

echo '</urlset>' . PHP_EOL;