<?php

$result = $db->sql_query_limit($sql,PHPBB3_NEWS_LATEST_NUMBER);
while($news_item = $db->sql_fetchrow($result)) {
	$bbp = new BBParser($news_item['post_text'],$news_item['bbcode_uid']);

	// Parse the message and subject
	//Add specific retrieved attributes to a list of items which will be serialized to XML
	$item = array('_attr' => array('id'=> $news_item['topic_id'], 'timestamp' => date('r',$news_item['post_time'])));
	$item['name'] = $news_item['topic_title'];
	$item['category'] = array('_attr' => array('id' => $news_item['forum_id']),'name' => $news_item['forum_name'],'description' => $news_item['forum_desc']);
	$item['author'] = array('_attr' => array('id' => $news_item['topic_poster']),'name' => $news_item['topic_first_poster_name'],'colour' => $news_item['user_colour']);
	$item['content'] = array('_attr' => array('length' => strlen($news_item['post_text']),'bbcode_uid' => $news_item['bbcode_uid']),'_text' => nl2br(str_replace('{SMILIES_PATH}',PHPBB3_DIR_RELATIVE . $smilies_path,html_entity_decode($bbp->parse()))));
	$item['comments'] = array('_attr' => array('count' => $news_item['comment_count']));
	$items[] = $item;
}

$Serializer = &new XML_Serializer($serializer_options);
$status = $Serializer->serialize(array('_attr' => array('title' => 'Latest News'),'news' => $items));

if (PEAR::isError($status)) {
   die($status->getMessage());
}  else {
		header('Content-type: text/xml');

		echo $Serializer->getSerializedData();
		die();
}

?>