rss.php

<?php
// Use our own DATE format constant because the PHP one seems to be bugged in some PHP versions
define('DATE_RFC822_FIXED', 'D, d M Y H:i:s O');

include('core/class.config.php');
include('core/class.database.php');
$Config= new Config;
$DB = new Database(
	$Config->getDbInfo('db_host'), 
	$Config->getDbInfo('db_port'), 
	$Config->getDbInfo('db_username'), 
	$Config->getDbInfo('db_password'), 
	$Config->getDbInfo('db_name')
	);

// Get the last time someone added a post (used to determine wheter we should write a new xml or not)
$last_posted_time = $DB->selectCell("SELECT `post_time` FROM `mw_news` ORDER BY post_time DESC LIMIT 0,1");

// Switch for wanted xml document.

$xml_path = "core/cache/rss/news.xml";
$write_new_file = (!file_exists($xml_path)) || ($last_posted_time > filemtime($xml_path)) || (filesize($xml_path)==0);

// IF we need to write a new xml, compose a new one
if($write_new_file)
{
	$news_posts = $DB->select("SELECT * FROM `mw_news`");

	$write_file = array();
	$write_file[] = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";
	$write_file[] = "<rss version=\"2.0\">";
	$write_file[] = "    <channel>";
	$write_file[] = "        <title>".$Config->get('site_title')." RSS News Feed</title>";
	$write_file[] = "        <link>http://".(str_replace('rss.php','index.php',($_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'])))."</link>";
	$write_file[] = "        <lastBuildDate>".date(DATE_RFC822_FIXED)."</lastBuildDate>";
	$write_file[] = "        <language>en-us</language>";

	foreach($news_posts as $topic)
	{

		$write_file[] = "        <item>";
		$write_file[] = "            <title>".htmlspecialchars($topic['title'])."</title>";
		$write_file[] = "            <pubDate>".(date(DATE_RFC822_FIXED, $topic['post_time']))."</pubDate>";
		$write_file[] = "            <description>Posted by ".htmlspecialchars($topic['posted_by']).": \n".htmlspecialchars($topic['message'])."</description>";
		$write_file[] = "        </item>";
	}
	$write_file[] = "    </channel>";
	$write_file[] = "</rss>";
	
	$output = implode("\n", $write_file);
    if (!$handle = fopen($xml_path, 'w'))
	{
        echo "Cannot open file ($xml_path)";
        exit;
    }
    fwrite($handle, $output);
    fclose($handle);
}
else
{
    $output = file_get_contents($xml_path);
}

// Make this document XML and send it to the browser
header("Content-Type: text/xml");
echo $output;
?>