<?php
header("Content-Type: text/xml; charset=utf-8");

$db = mysqli_connect("localhost","ChitICR","sI56_Kse-fpI(zznvR","ChitICR") or die('Error');

$sql = "SELECT dd.UTCAdded , d.Host FROM DomainDetail dd INNER JOIN Domain d ON d.ID = dd.DomainID INNER JOIN ( SELECT Host FROM ( SELECT Host FROM `VToAssessView` UNION SELECT Host FROM `VToAssessPopulate` ) AS combined ORDER BY RAND() LIMIT 250 ) AS random_hosts ON d.Host = random_hosts.Host";

$r = $db->query($sql);

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

if($r) {
    while($row = $r->fetch_assoc()){
        $ts = strtotime($row['UTCAdded'] ?? '');
        $lastmod = ($ts > 0) ? date('Y-m-d', $ts) : date('Y-m-d');
        
        echo '<url>';
        echo '<loc>https://icr.chit.eu/request/' . htmlspecialchars($row['Host']) . '</loc>';
        echo '<lastmod>' . $lastmod . '</lastmod>';
        echo '<changefreq>weekly</changefreq>';
        echo '<priority>0.2</priority>';
        echo '</url>';
    }
}

echo '</urlset>';
$db->close();
?>
