<?php  ob_start(); 
require_once ("../globals/config.php");
require_once("../classes/class_database.php"); 
$db=new DataBase(DBHOST,DBNAME,DBUSER,DBPASS); 
$d1=new DataBase(DBHOST,DBNAME,DBUSER,DBPASS); 
// load the URL factory library
require_once 'rss_factory.inc.php';


$rss_feed = new RSSFactory('http://www.Stinkyjournalism.org',
                           date('D').', '.date('d M Y h:i:s'), 
                           'Exciting news Readings ,updated daily');

// create feed

//$sql="select *,date_format(news_date,'%a, %d %b %Y') as newdatenews from news where is_blocked=0 order by 	id desc "; 

//$sql="select * from(select date_format(news_date,'%m/%d/%Y') as dated,title,id,author,sdesc,news_image,concat('news','') as component  from news where is_blocked=0 order by news_date desc )  as t1  union select * from(select date_format(editorial_date,'%m/%d/%Y') as dated,title,id,author,sdesc,editorial_image,concat('editorial','') as component from editorial where is_blocked=0 order by editorial_date desc) as t2 ";
$sql="select * from 
(
select * from
(
select date_format(news_date,'%m/%d/%Y') as dated, date_format(news_date,'%y/%m/%d') as sortdated, title,id,author,sdesc,news_image,concat('news','') as component  from news where is_blocked=0 order by news_date desc 
)  as t1
 union
 select * from
(select date_format(editorial_date,'%m/%d/%Y') as dated, date_format(editorial_date,'%y/%m/%d') as sortdated,title,id,author,sdesc,editorial_image,concat('editorial','') as component from editorial where is_blocked=0 order by editorial_date desc) as t2 
) as t3 order by sortdated desc";
$res=$db->query($sql);
$count=mysql_num_rows($res);
if($count>0)
{
while($row=mysql_fetch_object($res))
{
	// add feed item
	
	$components=$row->component;
	if ($components=="news")
	{
		if ($row->news_image!="")
		$imageURL="http://www.stinkyjournalism.org/newsImages/".$row->news_image;	
		$description  =  $imageURL."####".$row->sdesc;
	}
	else
	{
		if ($row->news_image!="")
		$imageURL="http://www.stinkyjournalism.org/editorialImages/".$row->news_image;
		$description  =  $imageURL."####".$row->sdesc;
	}
	
	
	$rss_feed->addItem($row->title,$row->newdatenews,$row->id, $description,$components); 
}

}

// display feed
$data= $rss_feed->get('2.0'); 

$fp=fopen('rssNew.xml','w');
fwrite($fp,$data);
fclose($fp);
?>