set_title('CheesyMovieNight.com Movies');
$rss->set_link(BaseDir::get().'movies/');
$rss->set_category('Movies');
$rss->set_description('The latest movies from CheesyMovieNight.com');
$rss->set_image_title('CheesyMovieNight.com RSS Movies');
$rss->set_image_link(BaseDir::get().'movies/');
$rss->set_image_url(BaseDir::get().'rss/images/cmn_rss_movies.jpg');
//Generate Individual Items
$sqlQ = "
SELECT
a.movie_id
, a.movie_slug
, a.title
, a.year
, a.copyright
, a.synopsis
, a.date_created
, a.overall_avg_rating
, a.overall_reviews
FROM
(".MysqlViews::movie_listing().") a
ORDER BY
a.date_created 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();
$title = $row['title'];
$link_title = $row['movie_slug'];
$rating = ($row['overall_avg_rating']!='' && $row['overall_avg_rating']>=0?$row['overall_avg_rating'].' out of 10 (Based on '.$row['overall_reviews'].' reviews)':'(Not Yet Reviewed)');
$rss->items[$rss_count]->set_title(htmlentities(strip_tags($title)));
$rss->items[$rss_count]->set_link(BaseDir::get().'movie/'.$link_title.'/'.$row['year'].'/');
$rss->items[$rss_count]->set_publish_date($row['date_created']);
$rss->items[$rss_count]->set_description($row['synopsis']."
\n".$rating);
$rss->items[$rss_count]->set_permalink(true);
}
$db->disconnect();
echo $rss->build_xml();
?>