<?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 News');
$rss->set_link(BaseDir::get().'news/');
$rss->set_category('News');
$rss->set_description('The latest news from CheesyMovieNight.com');
$rss->set_image_title('CheesyMovieNight.com RSS News');
$rss->set_image_link(BaseDir::get().'news/');
$rss->set_image_url(BaseDir::get().'rss/images/cmn_rss_news.jpg');

//Generate Individual Items
$sqlQ = "
	SELECT
		title
		, link_title
		, news
		, date_of_news
	FROM
		tbl_news
	ORDER BY
		date_of_news DESC
	LIMIT 10;
";

//$db = new MysqlConnection();
$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();
	$link_title = Common::text_to_url($title);

	$rss->items[$rss_count]->set_title(htmlentities(strip_tags($row['title'])));
	$rss->items[$rss_count]->set_link(BaseDir::get().'news/'.Date('Y',strtotime($row['date_of_news'])).'/'.Date('m',strtotime($row['date_of_news'])).'/'.Date('d',strtotime($row['date_of_news'])).'/'.$row['link_title'].'/');
	$rss->items[$rss_count]->set_publish_date($row['date_of_news']);
	$rss->items[$rss_count]->set_description($row['news']);
	$rss->items[$rss_count]->set_permalink(true);
}

$db->disconnect();

echo $rss->build_xml();
?>