<?
	require_once('../lib/main-class.php');
	require_once(WEB_DIRECTORY.'admin/lib/rss-class.php');
	require_once(WEB_DIRECTORY.'admin/lib/xml-class.php');
	
	// UTF-8
	require_once(WEB_DIRECTORY.'admin/plugins/utf-8/utf8.php');
	require_once(UTF8.'/utils/ascii.php');
	require_once(UTF8.'/utils/validation.php');
	require_once(UTF8.'/utils/bad.php');

	function rss_pubDate($timestamp)
	{
		$ret = '';
		
		$datatime = explode(" ", $timestamp);
		if(sizeof($datatime) == 2)
		{
			$date = explode("-",$datatime[0]);
			$time = explode(":",$datatime[1]);
			if(sizeof($date) == 3)
			{
				$pubdate = gmdate('D, d M Y H:i:s T', mktime($time[0], $time[1], $time[2], $date[1], $date[2], $date[0]));
				
				return $pubdate;
			};
		};
		
		return $ret;
	}

	function rss_all()
	{
		global $db;

		$sql = 'SELECT 
				'.DB_PREFIX.'clanek.id_clanek, 
				'.DB_PREFIX.'clanek.nazev, 
				'.DB_PREFIX.'clanek.url, 
				'.DB_PREFIX.'clanek.nahled, 
				'.DB_PREFIX.'clanek.zobrazovat_od, 
				CASE 
					WHEN '.DB_PREFIX.'clanek.rubrika_id != 0 
					THEN '.DB_PREFIX.'rubrika.nazev 
					ELSE '.DB_PREFIX.'box.nazev 
				END AS kategorie 
			FROM '.DB_PREFIX.'clanek JOIN '.DB_PREFIX.'box 
			ON '.DB_PREFIX.'clanek.box_id = '.DB_PREFIX.'box.id_box 
			LEFT JOIN '.DB_PREFIX.'rubrika 
			ON '.DB_PREFIX.'clanek.rubrika_id = '.DB_PREFIX.'rubrika.id_rubrika 
			WHERE '.DB_PREFIX.'clanek.active_state IN (1,2) 
			AND '.DB_PREFIX.'clanek.zobrazovat_od <= NOW() 
			AND '.DB_PREFIX.'clanek.zobrazovat_do >= NOW() 
			ORDER BY '.DB_PREFIX.'clanek.priorita DESC, '.DB_PREFIX.'clanek.zobrazovat_od DESC 
			LIMIT 30';
		if($res = $db->get_results($sql))
		{
			header('Content-type: text/xml; charset=utf-8');
			
			$rss = new rss_generator;
			
			$rss->add_channel(WEB_NAME, array(
				'title' => WEB_NAME, 
				'link' => WEB_URL, 
				'description' => 'RSS export článků z portálu '.WEB_NAME.'', 
				'language' => 'cs',
				'copyright' => 'Copyright '.date("Y").', redakce '.WEB_NAME.'' 
			));
			
			foreach($res as $clanek)
			{
				$nahled = $clanek->nahled;
				$nahled = html_entity_decode($nahled, ENT_COMPAT, "UTF-8");
				$nahled = strip_tags($nahled);
				$nahled = utf8_strip_ascii_ctrl($nahled);
	
				$rss->add_item(WEB_NAME, array(
					'title' => $clanek->nazev, 
					'link' => WEB_URL.substr($clanek->url, 1), 
					'description' => $nahled, 
					'category' => $clanek->kategorie, 
					'pubDate' => rss_pubDate($clanek->zobrazovat_od)
				));
			};
			
			echo $rss->create_rss();
			exit();
		};
	};

	function rss_box($box)
	{
		global $db;

		$sql = 'SELECT 
				'.DB_PREFIX.'clanek.id_clanek, 
				'.DB_PREFIX.'clanek.nazev, 
				'.DB_PREFIX.'clanek.url, 
				'.DB_PREFIX.'clanek.nahled, 
				'.DB_PREFIX.'clanek.zobrazovat_od 
			FROM '.DB_PREFIX.'clanek 
			WHERE '.DB_PREFIX.'clanek.box_id = '.$box->id_box.'
			AND '.DB_PREFIX.'clanek.active_state IN (1,2) 
			AND '.DB_PREFIX.'clanek.zobrazovat_od <= NOW() 
			AND '.DB_PREFIX.'clanek.zobrazovat_od >= (NOW() - INTERVAL \''.$box->rss.' DAY\')
			AND '.DB_PREFIX.'clanek.zobrazovat_do >= NOW() 
			ORDER BY '.DB_PREFIX.'clanek.priorita DESC, '.DB_PREFIX.'clanek.zobrazovat_od DESC 
			LIMIT 30';
		if($res = $db->get_results($sql))
		{
			header('Content-type: text/xml; charset=utf-8');
			
			$rss = new rss_generator;
			
			$rss->add_channel(WEB_NAME, array(
				'title' => WEB_NAME, 
				'link' => WEB_URL, 
				'description' => 'RSS export článků z portálu '.WEB_NAME.'', 
				'language' => 'cs',
				'copyright' => 'Copyright '.date("Y").', redakce '.WEB_NAME.'' 
			));
			
			foreach($res as $clanek)
			{
				$nahled = $clanek->nahled;
				$nahled = html_entity_decode($nahled, ENT_COMPAT, "UTF-8");
				$nahled = strip_tags($nahled);
				$nahled = utf8_strip_ascii_ctrl($nahled);
	
				$rss->add_item(WEB_NAME, array(
					'title' => $clanek->nazev, 
					'link' => WEB_URL.substr($clanek->url, 1), 
					'description' => $nahled, 
					'category' => $box->nazev, 
					'pubDate' => rss_pubDate($clanek->zobrazovat_od)
				));
			};
			
			echo $rss->create_rss();
			exit();
		};
	};

	function rss_rubrika($rubrika)
	{
		global $db;
		
		$sql = 'SELECT 
				'.DB_PREFIX.'clanek.id_clanek, 
				'.DB_PREFIX.'clanek.nazev, 
				'.DB_PREFIX.'clanek.url, 
				'.DB_PREFIX.'clanek.nahled, 
				'.DB_PREFIX.'clanek.zobrazovat_od, 
				'.DB_PREFIX.'rubrika.nazev AS kategorie 
			FROM '.DB_PREFIX.'clanek JOIN '.DB_PREFIX.'rubrika 
			ON '.DB_PREFIX.'clanek.rubrika_id = '.DB_PREFIX.'rubrika.id_rubrika 
			WHERE
			(
				'.DB_PREFIX.'clanek.hiearchie[4] = '.$rubrika->id_rubrika.' 
				OR '.DB_PREFIX.'clanek.hiearchie[3] = '.$rubrika->id_rubrika.' 
				OR '.DB_PREFIX.'clanek.hiearchie[2] = '.$rubrika->id_rubrika.' 
			)
			AND '.DB_PREFIX.'clanek.active_state IN (1,2) 
			AND '.DB_PREFIX.'clanek.zobrazovat_od <= NOW() 
			AND '.DB_PREFIX.'clanek.zobrazovat_od >= (NOW() - INTERVAL \''.$rubrika->rss.' DAY\') 
			AND '.DB_PREFIX.'clanek.zobrazovat_do >= NOW() 
			ORDER BY '.DB_PREFIX.'clanek.priorita DESC, '.DB_PREFIX.'clanek.zobrazovat_od DESC 
			LIMIT 30';
		if($res = $db->get_results($sql))
		{			
			header('Content-type: text/xml; charset=utf-8');
			
			$rss = new rss_generator;
			
			$rss->add_channel(WEB_NAME, array(
				'title' => WEB_NAME, 
				'link' => WEB_URL, 
				'description' => 'RSS export článků z portálu '.WEB_NAME.'', 
				'language' => 'cs',
				'copyright' => 'Copyright '.date("Y").', redakce '.WEB_NAME.'' 
			));
			
			foreach($res as $clanek)
			{
				$nahled = $clanek->nahled;
				$nahled = html_entity_decode($nahled,ENT_COMPAT,"UTF-8");
				$nahled = strip_tags($nahled);
				$nahled = utf8_strip_ascii_ctrl($nahled);
	
				$rss->add_item(WEB_NAME, array(
					'title' => $clanek->nazev, 
					'link' => WEB_URL.substr($clanek->url, 1), 
					'description' => $nahled, 
					'category' => $clanek->kategorie, 
					'pubDate' => rss_pubDate($clanek->zobrazovat_od)
				));
			};
			
			echo $rss->create_rss();
			exit();
		};
	};

	// rss kanal pro box
	if(isset($_REQUEST['box_id']))
	{
		$sql = 'SELECT 
				'.DB_PREFIX.'box.id_box, 
				'.DB_PREFIX.'box.nazev, 
				'.DB_PREFIX.'box.rss 
			FROM '.DB_PREFIX.'box 
			WHERE '.DB_PREFIX.'box.id_box = '.intval($_REQUEST['box_id']).' 
			AND '.DB_PREFIX.'box.active_state = 1 
			AND '.DB_PREFIX.'box.rss != 0 
			LIMIT 1';
		if($box = $db->get_row($sql))
		{
			rss_box($box);
		};
	};

	// rss kanal pro rubriku
	if(isset($_REQUEST['rubrika_id']))
	{
		$sql = 'SELECT 
				'.DB_PREFIX.'rubrika.id_rubrika, 
				'.DB_PREFIX.'rubrika.nazev, 
				'.DB_PREFIX.'rubrika.rss 
			FROM '.DB_PREFIX.'rubrika 
			WHERE '.DB_PREFIX.'rubrika.id_rubrika = '.intval($_REQUEST['rubrika_id']).' 
			AND '.DB_PREFIX.'rubrika.active_state = 1 
			AND '.DB_PREFIX.'rubrika.rss != 0 
			LIMIT 1';
		if($rubrika = $db->get_row($sql))
		{
			rss_rubrika($rubrika);
		};
	};
	
	// rss kanal vse
	if(isset($_REQUEST['all']))
	{
		rss_all();
	}
	
	// prazdny rss kanal
	$rss = new rss_generator;
	
	$rss->add_channel(WEB_NAME, array(
		'title' => WEB_NAME, 
		'link' => WEB_URL, 
		'description' => 'Požadovaný RSS zdroj portálu '.WEB_NAME.' neobsahuje žádnou položku.', 
		'language' => 'cs',
		'copyright' => 'Copyright '.date("Y").', redakce '.WEB_NAME.'' 
	));

	echo $rss->create_rss();
	exit();
?>