<?
ini_set('memory_limit', '2048M');
include('admin/db.php');
header("Content-Type: text/xml; charset=UTF-8");
?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
        xmlns:video="http://www.google.com/schemas/sitemap-video/1.1">
            <?
            $result = dbQuery("SELECT content.*, (SELECT content_views.views FROM content_views WHERE content_views.content = content.record_num) AS views, (SELECT users.username FROM users WHERE users.record_num = content.submitter) AS username FROM content WHERE content.approved = 2 AND content.enabled = 1 AND embed = '' AND plug_url = 0 AND photos = 0 AND orig_filename != '' ORDER BY encoded_date DESC");
            foreach ($result as $row) {
                unset($array);
                $link = generateUrl('video', $row['title'], $row['record_num']);
                $dirname = str_replace('.flv', '', urlencode($row['orig_filename']));
                $subdir = $row['filename'][0] . '/' . $row['filename'][1] . '/' . $row['filename'][2] . '/' . $row['filename'][3] . '/' . $row['filename'][4] . '/';
                $dirname = $subdir . $dirname;
                if ($row['hotlinked']) {
                    $contentLocation = $row['hotlinked'];
                } else {
                    if ($modsec_enabled) {
                        $contentLocation = getMediaLink($subdir . $row['filename']);
                    } else {
                        $outputFiles = getMediaURLs($row);
                        $contentLocation = $outputFiles['filename'];
                    }
                }
                $settingsFile = rawurlencode($basehttp . '/playerConfig.php?' . $fileurl);
                ?>
        <url> 
            <loc><? echo $link; ?></loc>
            <video:video>
                <video:thumbnail_loc><?php echo getThumbUrl($row['orig_filename'], $row['filename'], $row['main_thumb'], true); ?></video:thumbnail_loc>
                <video:content_loc><![CDATA[<? echo $contentLocation; ?>]]></video:content_loc>
                <video:title><![CDATA[<? echo htmlentities($row['title'], ENT_QUOTES, 'UTF-8'); ?>]]></video:title>  
                <video:description><![CDATA[<? echo htmlentities($row['description'], ENT_QUOTES, 'UTF-8'); ?>]]></video:description>
                <video:view_count><? echo $row['views']; ?></video:view_count>
                <? $array = explode(',', $row['keywords']); ?>
                <? foreach ($array as $i) { ?>
                    <video:tag><![CDATA[<? echo trim($i); ?>]]></video:tag>
                <? } ?>
                <video:category>Adult</video:category>
                <video:family_friendly>no</video:family_friendly>
                <video:duration><? echo $row['length']; ?></video:duration>
                <video:gallery_loc ><? echo $basehttp; ?>/search/<? echo clearString($row['title']); ?>/</video:gallery_loc>
                <video:price currency="USD">0.00</video:price>
                <video:requires_subscription>no</video:requires_subscription>
                <video:publication_date><? echo date('c', strtotime($row['encoded_date'])); ?></video:publication_date>
                <video:rating>5</video:rating> 
                <video:live>no</video:live>
                <video:uploader info="<? echo generateUrl('user', $row['username'], $row['submitter']); ?>"><? echo $row['username']; ?></video:uploader>
            </video:video>
        </url>
    <? } ?>
</urlset>