#!/usr/bin/php
<rss version="2.0">
<channel>
	<title>Mint's Blog</title>
	<link>http://mint.homelinux.org/blog.php</link>
	<language>en</language>
	<description>
		Mint Shows' Blog - http://mint.homelinux.org/
	</description>
	
	<?php
	     /***** Initialize the Database *****/
	     include("START_DATABASE.php");
	     /***** GET ALL BLOG ENTRIES *****/
	     $blog_query  = "SELECT * FROM `blog` ORDER BY `id` DESC";
	     $blog_entries=  mysql_query($blog_query);
	     $num_results =  mysql_numrows($blog_entries);
 
	     if ($num_results > 0){
			for($counter=0; $counter < $num_results; $counter++){
				$id 		= StripSlashes(mysql_result($blog_entries,$counter,'id'));
				$date 		= StripSlashes(mysql_result($blog_entries,$counter,'date'));
				$title 		= StripSlashes(mysql_result($blog_entries,$counter,'title'));
				$contents 	= StripSlashes(mysql_result($blog_entries,$counter,'contents'));
				$visible	= StripSlashes(mysql_result($blog_entries,$counter,'visible'));
				print "\n";
				print "<item>\n";
				print "<title>$title</title>\n";
				print "<guid>http://mint.homelinux.org/blog.php#$id</guid>\n";
				print "<link>http://mint.homelinux.org/blog.php#$id</link>\n";
				/***** Replace gt/lt signs with their html equivalents
				       to prevent the html tags being parsed by the xml *****/
				$TextToReplace	=array('<', '>');
				$ReplacementText=array('&lt;', '&gt;');
				$contents_new	=str_replace($TextToReplace, $ReplacementText,  $contents);
				/************************************************************/
				print "<description>\n$contents_new\n</description>\n";
				print "<pubDate>$date</pubDate>\n";
				print "</item>\n";
			}
		}
								   
	   ?>
	
</channel>
</rss>