<?PHP

// setup the main rss information
global $RSS_CONFIG;

$title = 'Gentoo-Portage.com Recent Package Comments';
$description = 'The latest package comments';
$file = 'recent_comments';

if(!is_file('../cache/rss/'.$file.'.xml') || filemtime('../cache/rss/'.$file.'.xml') < time() - 5*60){
    // make the feed
    $rss = new rss('utf-8');

    $rss->channel($title, 
                $RSS_CONFIG['website'], 
                $description);
    $rss->language($RSS_CONFIG['language']);
    $rss->copyright($RSS_CONFIG['copyright']);
    $rss->managingEditor($RSS_CONFIG['author']);
    $rss->category($RSS_CONFIG['category']);
    $rss->ttl($RSS_CONFIG['ttl']);
    $rss->pubDate(parse_date(false, 'r'));
    // $rss->image($url, $title, $link);
    $rss->startRSS('../cache/rss', $file);

    // add the data
    $sql = "SELECT package_title, category_title, package_comment.* FROM package_comment, package, category WHERE package_p = package_f AND category_p = category_f ORDER BY `package_comment`.`_added`DESC LIMIT 0,20";
    $results = mysql_query($sql) or die(mysql_error());

    while($row = mysql_fetch_assoc($results)){
        
        $rss->itemTitle($row['category_title'] . '/' . $row['package_title'] . ' (Comment '.$row['package_comment_p'].')');
        $rss->itemLink($RSS_CONFIG['website'].'/'.$row['category_title'] . '/' . $row['package_title']);
        $rss->itemDescription(htmlspecialchars(parse_comment($row['comment_text'])));
        $rss->itemGuid($RSS_CONFIG['website'].'/'.$row['category_title'] . '/' . $row['package_title'].'/'.$row['package_comment_p']);
        $rss->itemSource($title, $RSS_CONFIG['website'].'/RSS/Recent_Comments');
        $rss->itemPubDate(parse_date($row['_added'], 'r'));

        $rss->addItem();
    }

    $rss->RSSdone();
}


// write out the file created
header('Last-Modified: '. date('r', filemtime('../cache/rss/'.$file.'.xml')));
header('Cache-Control: s-maxage=1800, must-revalidate, max-age=0');
header("Content-Type: application/xml; charset=utf-8");
readfile('../cache/rss/'.$file.'.xml');
?>