<?php
require_once '../includes/base_dir.php';
require_once '../includes/common_class.php';
require_once '../includes/mysql_class.php';
require_once 'rss_class.php';

$rss = new Rss();
$rss->set_title('CheesyMovieNight.com Latest Forum Posts');
$rss->set_link(BaseDir::get().'forums/');
$rss->set_category('Forums');
$rss->set_description('The latest posts from the CheesyMovieNight.com Forums');
$rss->set_image_title('CheesyMovieNight.com RSS Latest Forum Posts');
$rss->set_image_link(BaseDir::get().'forums/');
$rss->set_image_url(BaseDir::get().'rss/images/cmn_rss_forums.jpg');

//Generate Individual Items
$sqlQ = "
	SELECT
		a.post_id as post_id
		, a.post_time as date_of_post
		, a.forum_id
		, a.topic_id
		, b.post_subject as title
		, b.post_text as description
		, c.topic_title as alt_title
		, d.forum_name as category
	FROM
		phpbb_posts a
	LEFT OUTER JOIN
		phpbb_posts_text b
	ON
		a.post_id = b.post_id
	LEFT OUTER JOIN
		phpbb_topics c
	ON
		a.topic_id = c.topic_id
	LEFT OUTER JOIN
		phpbb_forums d
	ON
		a.forum_id = d.forum_id
	ORDER BY
		a.post_time DESC
	LIMIT 10;
";

$db->choose_db('northa5_phpbb1');
$result = $db->query($sqlQ);
for($i=0;$i<$db->get_num_rows($result);$i++) {
	$row = $db->get_row($result,$i);
	$rss_count = $rss->add_item();

	$rss->items[$rss_count]->set_title(htmlentities(strip_tags(($row['title']==''?'Re: '.$row['alt_title']:$row['title']))));
	$rss->items[$rss_count]->set_link(BaseDir::get().'forums/viewtopic.php?p='.$row['post_id'].'#'.$row['post_id']);
	$rss->items[$rss_count]->set_publish_date(Date('m/d/Y h:i:s',$row['date_of_post']));
	$rss->items[$rss_count]->set_description($row['description']);
	$rss->items[$rss_count]->set_permalink(true);
	$rss->items[$rss_count]->set_category(htmlentities(strip_tags($row['category'])));
}
$db->choose_db('northa5_horrormovie');
$db->disconnect();

echo $rss->build_xml();
?>