<?php

//later: geo ip und spracheinstellungen
//error_reporting(E_ALL);
//ini_set('display_errors', '0');

//error_reporting(E_ALL);
require_once("library/Functions.inc.php");
require_once("library/Connection.inc.php");

$config 			= new Config();
$conn 				= new Connection();
$func	 			= new Functions();
$pdo				= $conn->prepareQuery();
$table 				= $config->sql_tablename_publish_de();

header("Content-Type: text/plain; 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('X-UA-Compatible: IE=edge,chrome=1');
header("Pragma: cache");

/*
$random				= strtolower(trim($func->stripHtml($_REQUEST['r'])));
if ($random == "1"){
	$stmt = $pdo->prepare("SELECT * FROM $table WHERE id>0 AND p_isonline=1 ORDER BY RAND LIMIT 30");
} else {
	$stmt = $pdo->prepare("SELECT * FROM $table WHERE id>0 AND p_isonline=1 ORDER BY p_timestamp DESC LIMIT 300000");
}
*/
$stmt = $pdo->prepare("SELECT * FROM $table WHERE id>0 AND p_isonline=1 ORDER BY RAND() LIMIT 3");
$stmt->execute();

while($rows = $stmt->fetch(PDO::FETCH_ASSOC)) {
	$shortcode			= $rows["p_shortcode"];
	$headline			= $rows["p_headline"];
	$keywords			= $rows["p_tags"];
	$linkingcode		= "https://www.buzzerstar.com/".$func->makeArticleLink($shortcode);
	echo "$shortcode###$headline###$keywords###$linkingcode\n";
}

$stmt 	= null; // doing this is mandatory for connection to get closed
$pdo   	= null;
		
exit(0);
?>