<?php

//later: geo ip und spracheinstellungen
//error_reporting(E_ALL);
//ini_set('display_errors', '0');

//error_reporting(E_ALL);
require_once("library/rss/RSS2Writer.php");  
require_once("library/Functions.inc.php");
require_once("library/Connection.inc.php");
require_once("/home/www/wwwbuzzerstar/p/spass/library/Security.inc.php"); 

$sec 				= new Security();
$config 			= new Config();
$conn 				= new Connection();
$func	 			= new Functions();
$pdo				= $conn->prepareQuery();
$table 				= $config->sql_tablename_publish_de();

header("Content-Type: text/xml; charset=UTF-8");
header("Expires: on, 01 Jan 1970 00:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header('X-UA-Compatible: IE=edge,chrome=1');
header("Pragma: no-cache");

$rss = new RSS2Writer(
		'Interessante, lustige, freche und humorvolle Neuigkeiten aus aller Welt - lies und schreib einen Artikel!', 	//Feed Title
		'Dinge die Dich bewegen. Teile Sie mit Deiner Welt!', //Feed Description
		'https://www.buzzerstar.com/rss.php', //Feed Link
		6, //indent
		false //Use CDATA
		);
		
$rss->addCategory("RSS Feed");
$rss->channelImage("BuzzerStar News Publishing Community", "https://www.buzzerstar.com/", "https://www.buzzerstar.com/images/logo_header.png", 144, 106);
	
$stmt 				= $pdo->prepare("SELECT * FROM $table WHERE id>0 AND p_isonline=1 ORDER BY p_timestamp DESC LIMIT 10000"); // AND p_online=1
$stmt->execute();

while($rows = $stmt->fetch(PDO::FETCH_ASSOC)) {
	$shortcode			= $rows["p_shortcode"];
	$headline			= $rows["p_headlineraw"];
	$pic_desc			= $rows["p_description"];
	
	$linkingcode		= "https://www.buzzerstar.com/p/spass/".$func->makeArticleLink($shortcode);
	$rss->addItem("$headline", $pic_desc, $linkingcode);
}

echo $rss->getXML();		

$stmt 	= null; // doing this is mandatory for connection to get closed
$pdo   	= null;
		
exit(0);
?>