<?
include("feedcreator.class.php");

$rss = new UniversalFeedCreator();
$rss->useCached();
$rss->title = "MTB-News Biketest";
$rss->description = "Gebrauchte Biketeile kaufen";
$rss->link = "http://www.mtb-news.de/biketest/";
$rss->syndicationURL = "http://www.mtb-news.de/biketest/".$PHP_SELF;

$image = new FeedImage();
$image->title = "MTB-News.de logo";
$image->url = "http://www.mtb-news.de/forum/images/ibc/ibclogo_ececec.gif";
$image->link = "http://www.mtb-news.de/";
$image->description = "Feed von MTB-News.de";
$rss->image = $image;
include "includes/funktionen.php";
// get your news items from somewhere, e.g. your database:
include ("DB.php");
define ('DSN', 'mysql://mtbn_vb:KYZAdhEGMpULYrCX@dbsrv1/censura');
$db = DB::connect (DSN);
$res = mysql_query("SELECT r . * , r.date_added AS date_review_added, c.name AS cname, i . * , v . *
FROM rating AS r, items AS i, vendors AS v, categories AS c
WHERE i.active =1
AND r.item_id = i.item_id
AND v.vendor_id = i.vendor_id
AND c.category_id = i.category_id
GROUP BY rating_id
ORDER BY r.date_added DESC
LIMIT 25 ");

if ($res) {
    while ($data = mysql_fetch_object($res)) {
        $item = new FeedItem();
        $item->title = $data->vendor_name ." " . $data->item_name .": ". $data->headline;
        $item->link = BASEURL . "/".macheArtikelUrl($data->item_id, $data->item_name, $data->vendor_name, $data->cname);
        $item->description = $data->comments;
        $item->date = $data->date_review_added;
        $item->source = "http://www.mtb-news.de";
        $item->author = $data->username;

        $rss->addItem($item);
    }
}

$rss->saveFeed("RSS1.0", "feed.xml");
?>