useCached();
$rss->title = "Indiaaviation News";
$rss->description = "Indiaaviation.aero Top Stories";
$rss->link = "http://indiaaviation.aero";
$image = new FeedImage();
$image->title = "Indiaaviation News";
$image->url = "http://indiaaviation.aero/news/images/stories/thumb.gif";
$image->link = "http://indiaaviation.aero";
$image->description = "News Feed provided by indiaaviation.aero. Click to visit.";
$rss->image = $image;
// initialize configure vars
$host = "localhost";
$user = "peanuts_mambo";
$pass = "m1ll1ons";
$db = "peanuts_mambo";
mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($db);
$limit = " LIMIT 20";
$_WHERE = "";
$tableJoin = "";
$_WHERE = " AND cs.website_id = '2'";
$tableJoin = " LEFT JOIN mos_content_sites AS cs ON cs.content_id = A.id";
$sql = "select A.title,D.id,A.created,A.introtext,A.images from mos_content as A ".
"INNER JOIN mos_content_map as D ON A.id = D.content_id ".
$tableJoin .
" LEFT JOIN mos_sections as B ON D.sectionid = B.id ".
" LEFT JOIN mos_categories as C ON C.id = D.catid ".
" WHERE 1=1 ".
$_WHERE .
" GROUP BY A.title order by A.created DESC". $limit;
$rs = mysql_query($sql);
while ($data = mysql_fetch_object($rs)) {
// $url = "http://indiaaviation.aero/news/index.php?option=com_content&task=view&id=".$data->id."&Itemid=59";
$url = "http://indiaaviation.aero/news/airline/".$data->id."/59/";
$item = new FeedItem();
$item->title = $data->title . ' - ' . substr($data->created,0,10);
$item->link = $url . urlencode(str_replace('/', '-', $data->title));
$image1 = '
';
//$item->description = "".$image1 . '
' .$data->introtext."
| " . $image1 . " | " .$data->introtext." |
";
$item->date = strtotime($data->created);
$item->source = "http://indiaaviation.aero";
$rss->addItem($item);
}
$rss->saveFeed("RSS2.0", "news/feed.xml");
?>