<?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 archivesid, year, refnumber, volume, issue, part, file FROM archives WHERE (year = 2024 AND status = 'enabled' AND specialissue = 'N')") or die("An error occurred. Please try after some time.");
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($archivesid, $year, $refnumber, $volume, $issue, $part, $file);
while ($stmt->fetch()) {
echo "<url>" . PHP_EOL;
echo "<loc>{$baseurl}archives/{$year}.v{$volume}.i{$issue}.{$part}</loc>" . PHP_EOL;
echo "<lastmod>" . date('Y-m-d') . "</lastmod>" . PHP_EOL;
echo "<changefreq>monthly</changefreq>" . PHP_EOL;
echo "<priority>0.8</priority>" . PHP_EOL;
echo "</url>" . PHP_EOL;

echo "<url>" . PHP_EOL;
echo "<loc>{$baseurl}archives/{$year}.v{$volume}.i{$issue}.{$part}.{$archivesid}</loc>" . PHP_EOL;
echo "<lastmod>" . date('Y-m-d') . "</lastmod>" . PHP_EOL;
echo "<changefreq>monthly</changefreq>" . PHP_EOL;
echo "<priority>0.8</priority>" . PHP_EOL;
echo "</url>" . PHP_EOL;

echo "<url>" . PHP_EOL;
echo "<loc>{$baseurl}article/{$archivesid}/{$file}</loc>" . PHP_EOL;
echo "<lastmod>" . date('Y-m-d') . "</lastmod>" . PHP_EOL;
echo "<changefreq>monthly</changefreq>" . PHP_EOL;
echo "<priority>0.8</priority>" . PHP_EOL;
echo "</url>" . PHP_EOL;
}
$stmt->close();

echo '</urlset>' . PHP_EOL;