useCached(); $rss->title = "Latest Games on GameShed.com"; $rss->description = "Lates games added on GameShed.com"; $rss->link = "http://www.gameshed.com"; $rss->syndicationURL = "http://www.gameshed.com/".$PHP_SELF; mysql_connect("localhost",$cfg['sqluser'],$cfg['sqlpass']) or die("Could not connect: " . mysql_error()); mysql_select_db($cfg['sqldb']); $result = mysql_query("SELECT * FROM games WHERE (cat!='test') && (flags='new') ORDER BY time desc LIMIT 0, 16"); while ($row = mysql_fetch_array($result)) { $item = new FeedItem(); $item->title = $row['name']; $name = str_replace(" ", "-", $row['name']); $name = str_replace("'", "_", $name); $name = str_replace('"', "_", $name); $name = str_replace('/', "_", $name); $name = str_replace("\\", "_", $name); $name = rawurlencode($name); $item->link="http://www.gameshed.com/".$name."/"; $item->description ="".$row['desc'].""; $item->source = "http://www.gameshed.com"; $item->author = "GameShed.com"; $rss->addItem($item); } mysql_free_result($result); $rss->saveFeed("RSS2.0", "feed.xml"); ?>