<?
ini_set('max_execution_time', 86400);
ini_set('memory_limit', '1G');
include('../../admin/db.php');

header('Content-type: text/xml; charset=UTF-8');

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

$max = 2000;
$from = is_numeric($_GET['offset']) ? (int) $_GET['offset'] : 0;

$result = dbQuery("SELECT `performers`.username, performers.site, paysites.slug AS siteSlug, paysites.name as siteName FROM `performers` RIGHT JOIN `paysites` ON `performers`.`site` = `paysites`.`record_num` WHERE `performers`.`deleted` = 0 AND `performers`.`enabled` = 1 LIMIT $from, $max");
foreach ($result as $row) {
    $link = generateUrl('webcams', strtolower($row['username']), strtolower($row['siteSlug']));
    ?>
    <url>
        <loc><? echo $link; ?></loc>
        <priority>0.8</priority>
        <changefreq>daily</changefreq>
        <lastmod><? echo date('c'); ?></lastmod>
    </url>
<? } ?>
</urlset>