<?
if (file_exists('settings/config.php'))
	{
		require_once('settings/config.php');
	}
else 
	{
		require_once('../settings/config.php');
	}

if(!is_numeric($_GET['id'])) exit();

header ("content-type: text/xml; charset=UTF-8");

$result = mysql_query("SELECT BDR_naam, SRV_1stecategorie, SRV_2ecategorie, SRV_3ecategorie  FROM services, bedrijven WHERE services.SRV_id = '".$_GET['id']."' AND services.BDR_id = bedrijven.BDR_id");
$bdrdata = mysql_fetch_array($result,MYSQL_ASSOC);

$cat = $bdrdata['SRV_1stecategorie']." > ".$bdrdata['SRV_2ecategorie'];

if($bdrdata['SRV_3ecategorie'] != "[geen]") $cat." > ".$bdrdata['SRV_3ecategorie'];

$xml = new ArrayToXML("1.0","UTF-8","2.0");

$array = array
	(
		"title" => "Dagtotaal - Recensies over ".$bdrdata['BDR_naam']." in de categorie ".$cat,
		"link" => "http://www.dagtotaal.nl/",
		"description" => "Resenties over '".$bdrdata['BDR_naam']."' in de categorie ".$cat." op Dagtotaal",
		"ttl" => "60",
		"copyright" => "Copyright 2006 - ".date("Y")." - Dagtotaal.nl",
		"language" => "nl-nl",
		"managingEditor" => "mail@dagtotaal.nl (Dagtotaal Support)",
		"webMaster" => "mail@dagtotaal.nl (Dagtotaal Webmaster)",
		"generator" => "Dagtotaal Frontend RSS generator",
		"image" => array
		(
				"link" => "http://www.dagtotaal.nl/",
				"url" => "http://www.dagtotaal.nl/images/logo.jpg",
				"title" => "Dagtotaal - Recensies over ".$bdrdata['BDR_naam']." in de categorie ".$cat
		)
	);
	
$xml->parseArray($array);

$query = "SELECT reviews.*, services.SRV_1stecategorie, services.SRV_2ecategorie, services.SRV_3ecategorie, bedrijven.RGO_id, bedrijven.BDR_id FROM bedrijven, reviews, services WHERE services.BDR_id = bedrijven.BDR_id AND reviews.SRV_id = services.SRV_id AND reviews.SRV_id = '".$_GET['id']."' ORDER BY datum DESC";
$result = mysql_query($query);

while($data = mysql_fetch_array($result,MYSQL_ASSOC))
{
$array = array("item" => array
		(
				"guid" => "http://www.dagtotaal.nl/home.php?regio=".$data['RGO_id']."&amp;locatie=&amp;load=reviews&amp;hoofdcat=".$data['SRV_1stecategorie']."&amp;subcat=".$data['SRV_2ecategorie']."&amp;deepsubcat=".$data['SRV_3ecategorie']."&amp;bedrijf=".$data['BDR_id']."&amp;service=".$data['SRV_id'],
				"title" => "BEOORDELING: ".$data['beoordeling'],
				"link" => "http://www.dagtotaal.nl/home.php?regio=".$data['RGO_id']."&amp;locatie=&amp;load=reviews&amp;hoofdcat=".$data['SRV_1stecategorie']."&amp;subcat=".$data['SRV_2ecategorie']."&amp;deepsubcat=".$data['SRV_3ecategorie']."&amp;bedrijf=".$data['BDR_id']."&amp;service=".$data['SRV_id'],
				"description" => $data['commentaar'],
				"pubDate" => date("D, d M Y H:i:s",strtotime($data['datum']))." +0200",
				"author" => $data['email']."(".$data['naam'].")",
				//"comments" => "http://www.pintip.nl/test.htm"
		));
$xml->parseArray($array);

}

echo $xml->output();

?>