<?php 
 //header("Content-Type: text/xml; charset=iso-8859-1");
 header('Content-Type: text/xml');
 echo '<?xml version="1.0" encoding="ISO-8859-1"?>';
?>


<rss version="2.0">
<channel>
<title>Gratiskungen.se</title>
<description>L�nkar till n�tets b�sta gratisprylar, erbjudanden och t�vlingar</description>
<link>http://www.gratiskungen.se</link>
<language>sv-se</language>
<?php
require('anslut_tips.php');

$dateTime = GetDateTime();

$q="SELECT id, foretag, rubrik, beskrivning, kategori, UNIX_TIMESTAMP(inlagd) as pubDate FROM $mysqlUser[tabell] WHERE ('$dateTime' BETWEEN inlagd AND slutar) ORDER BY inlagd DESC LIMIT 0,15";
$doGet=mysql_query($q);

$displayed = 0;
while($result = mysql_fetch_array($doGet))
{
	if($displayed == 0)
	{
?><lastBuildDate><?php echo strftime( "%a, %d %b %Y %T %z" , $result['pubDate']); ?></lastBuildDate>
<ttl>60</ttl>
<copyright>Copyright � 2006 Gratiskungen. Alla r�ttigheter reserverade.</copyright>
<?php
		$displayed = 1;
	}
?>
	
	<item>
		<title> <![CDATA[ <?php echo strip_tags("$result[foretag] - $result[rubrik]");?> ]]> </title>
		<description> <![CDATA[ <?php echo strip_tags($result['beskrivning'],'ENT_QUOTES');?> ]]> </description>        
		<link><?php echo "http://www.gratiskungen.se/$result[kategori]/".URLify($result['id'],"$result[foretag] - $result[rubrik]"); ?></link>
		<category><?php echo strip_tags(ConvertKategori($result['kategori']));?></category>
		<pubDate><?php echo strftime( "%a, %d %b %Y %T %z" , $result['pubDate']);?></pubDate>
		<guid isPermaLink="true"><?php echo "http://www.gratiskungen.se/$result[kategori]/".URLify($result['id'],"$result[foretag] - $result[rubrik]"); ?></guid>
	</item> 
<?php } ?>  
</channel>
</rss>

<?php
	function ConvertKategori($kategori)
	{
		switch ($kategori) {
		case "erbjudanden":
		    $kategori = 'Erbjudande';
		    break;
		case "gratis":
		    $kategori = 'Gratis';
		    break;
		case "tavlingar":
		    $kategori = 'T�vling';
		    break;
		}
		
		return $kategori;
	}
	
	function GetDateTime()
	{
		//$d = getdate();
		//$dateTime = "$d[year]-$d[mon]-$d[mday] $d[hours]:$d[minutes]:$d[seconds]";
		$dateTime = date("Y-m-d G:i:s");
		return $dateTime;
	}
	
	function URLify($id, $string)
	{
		$find = array(":","'",'"',"%","?","&",",", "/", "�", "�", "�", "�", "�", "�", " + ", "+", "  - ", " - ", " -  ", " ", ".com", ".se", ".nu", ".org", ".net", ".eu", ".");
		$replace = array("","","","procent","","-","", "-per-", "A", "A", "O", "a", "a", "o", "-", "-", "-", "-", "-", "-", "", "", "", "", "", "", "-");
		$URL = str_replace($find, $replace, $string);
		$URL = $URL."_$id.html";
		
		$URL = strtolower($URL);
		
		return $URL;
	}
?>