<?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;

$stmt = $mysqli->prepare("SELECT name FROM pages WHERE (name != 'account' AND name != 'login' AND name != 'search' AND name != 'sitemap')") or die('An error occurred. Please try after some time.');
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($name);
while ($stmt->fetch()) {
	echo '<url>' . PHP_EOL;
	echo '<loc>' . ($name == basename(dirname(__FILE__)) ? $baseurl : $baseurl . $name) . '</loc>' . PHP_EOL;
	echo '<lastmod>' . date('Y-m-d') . '</lastmod>' . PHP_EOL;
	echo '<changefreq>' . (in_array($name, array(basename(dirname(__FILE__)), 'archives')) ? 'daily' : 'monthly') . '</changefreq>' . PHP_EOL;
	echo '<priority>' . (in_array($name, array(basename(dirname(__FILE__)), 'archives')) ? '1.0' : '0.8') . '</priority>' . PHP_EOL;
	echo '</url>' . PHP_EOL;
}
$stmt->close();

echo '</urlset>' . PHP_EOL;