<?php
header("Content-Type: application/xml; charset=ISO-8859-1"); 

include "settings.php"; 

if(isset($_GET["id"])){
	$cSQL = mysql_query("SELECT cName FROM categories WHERE cID = '".$_GET["id"]."'") or exit(mysql_error());
	$cr = mysql_fetch_object($cSQL);
	$cate = preg_replace('/\&\s/iuS', '', $cr->cName);
	
	$qSQL = mysql_query("SELECT questions.*, users.* FROM questions INNER JOIN users ON questions.uID = users.uID WHERE questions.cID = '".$_GET["id"]."' ORDER BY questions.qID DESC LIMIT 20") or exit(mysql_error());
}else{
	$qSQL = mysql_query("SELECT questions.*, users.* FROM questions INNER JOIN users ON questions.uID = users.uID ORDER BY questions.qID DESC LIMIT 20") or exit(mysql_error());
}

echo '<?xml version="1.0" encoding="utf-8"?>\n';
?>
<rss version="2.0">
<channel>
	<title>Answer.se RSS Flöde<?php if($cate){ ?> för <?php echo $cate; }?></title>
	<link>https://www.answer.se</link>
	<description>Flöde för Answer.se</description>
	<generator>http://www.answer.se/rss</generator>
	<language>sv</language>
	
	<?php while($q = mysql_fetch_array($qSQL)): ?>
	<item>
		<title><?=$q["qTitle"]?></title>
		<guid isPermaLink="true">https://www.answer.se/fraga/<?=removeSpecialChars($q["qTitle"]).",".$q["qID"]; ?>.html</guid>
		<link>https://www.answer.se/fraga/<?=removeSpecialChars($q["qTitle"]).",".$q["qID"]; ?>.html</link>
		<description><![CDATA[<?=$q["qText"]?>]]></description>
	</item>
	<?php endwhile; ?>
</channel>