rss

<?php require_once("_inc.php");
$site_url = $config->site->url;
$site_title = $config->site->name;

echo '<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
                <channel>
                <atom:link href="'.$site_url.'feed/" rel="self" type="application/rss+xml" />

                    <title>'.$site_title .'</title>
                    <link>'.$site_url.'</link>
                    <description>'.$site_title.'</description>
                    <language>en</language>';

$string = '';
$sql = dbquery("SELECT id,title,description FROM videos WHERE views > 1 ORDER BY id DESC LIMIT 0,24 ");

                     while($row = mysql_fetch_array($sql)){
    $new_id = $row["id"];
    $new_title = $row["title"];
    $new_description = $row["description"];
    $new_seo_url = $site_url.'video/'.$new_id.'/'.seo_clean_url($new_title) .'/';
  $string .='<item>
                <title>'. htmlspecialchars($new_title) .'</title>
                <link>'.$new_seo_url.'</link>
                <guid>'.$new_seo_url.'</guid>
                <description><![CDATA[Watch '. htmlspecialchars($new_description) .']]></description>
                </item>';
                }
        $string .='</channel>
        </rss>';

echo $string;

MK_MySQL::disconnect();
?>