<?

$embassy = $global_vars['request'][2];

if(!is_numeric($embassy))
	die('Not today!');

$result = query("SELECT * FROM `news_sources` WHERE `id`='".$embassy."';");

if(mysqli_num_rows($result)!=1)
	die('Embassy does not exists!');
else {
	$embassy = mysqli_fetch_array($result);
}

$result = query("SELECT * FROM `news_rss` WHERE `source_id`='".$embassy['id']."' ORDER BY id DESC LIMIT 1;");

header("Content-Type: text/xml;charset=utf-8");

echo "<?xml version='1.0' encoding='UTF-8' ?>" . PHP_EOL;
echo "<rss version='2.0'>".PHP_EOL;
echo "<channel>".PHP_EOL;
echo "<title>Новости ".$embassy['name_where']."</title>".PHP_EOL;
echo "<link>https://www.povoleni.ru</link>".PHP_EOL;
echo "<description>Отслеживание новостей.</description>".PHP_EOL;
echo "<language>ru-ru</language>".PHP_EOL;

if(mysqli_num_rows($result)>0)
	while($data = mysqli_fetch_array($result)) { print 
		$publish_Date = date(DATE_RSS, strtotime($data["datetime"]));
		/*$image_size_array = get_headers($base_url . "images/".$row["post_image"], 1);
		$image_size = $image_size_array["Content-Length"];
		$image_mime_array = getimagesize($base_url . "images/".$row["post_image"]);
		$image_mime = $image_mime_array["mime"];*/
 
		echo "<item>".PHP_EOL;
		echo "<title>".$data['title']."</title>".PHP_EOL;
		echo "<link>".$data['url']."</link>".PHP_EOL;
		echo "<guid isPermaLink='true'>".$data['url']."?".md5($data['id'])."</guid>".PHP_EOL;
		echo "<pubDate>".$publish_Date."</pubDate>".PHP_EOL;
		//echo "<dc:creator>Povoleni</dc:creator>".PHP_EOL;
		echo "<description><![CDATA[".$data["text"]."]]></description>".PHP_EOL;
		//echo "<enclosure url='images/".$row["post_image"]."' length='".$image_size."' type='".$image_mime."' />".PHP_EOL;
		//echo "<category>PHP tutorial</category>".PHP_EOL;
		echo "</item>".PHP_EOL;
}

echo '</channel>'.PHP_EOL;
echo '</rss>'.PHP_EOL;

?>