Legacy Rss Feed

[skol]

Would it be possible to create an rss feed for the latest added games. It's just something I personally would find useful and I don't recall any other arcade having the feature.Accept for someone trying to do it themselves years ago..

<? 

$host = "host"; 
$root = "root"; 
$password ="pass"; 
$DataBase = "database"; 


mysql_connect("$host" ,"$root" ,"$password") or die("problem with database"); 


mysql_select_db("$DataBase") or die("problem with database"); 
 

$strsql = "SELECT * FROM games_list WHERE active=1 ORDER BY gid desc limit 20 "; 
$query = mysql_query($strsql); 
header("Content-type: text/xml"); 
//xml into the browser
//write on documents


echo "<?xml version=\"1.0\"?>
<rss version=\"2.0\">
<channel>
<title>Your Title</title>
<link>Your site</link>
<description>Feed</description>
<language>language</language>";

//cicle on items
while($row=mysql_fetch_array($query)){ 

$gid = $row["gid"]; 
$title = $row["gtitle"]; 
$gcount = $row["gcount"];
$gname = $row["gname"]; 

echo "<item>
<title>$title</title>
<link>http://www.yourserver.com/forum/arcade.php?do=play&gameid=$gid</link>
<description>
<![CDATA[
<img src=\"http://http://www.yourserver.com/forum/arcade/images/".$gname."1.gif\" align=\"right\" border=\"0\" width=\"50\" height=\"50\" vspace=\"4\" hspace=\"4\" /><br /><br />
     ]]> 
</description>
<played>$gcount</played>
</item>";
}

echo "</channel></rss>";


?>

 

[Darkwaltz4]

I might bundle this with my upcoming forum block, but is there a standard format out there i can follow? still not 100% committed about the idea yet.

 

[skol]

Well looking at vb they follow the RSS 2.0 format.But the really annoying thing with vb is since 4.1.10 their rss feeds are now only guest viewable..Were as before that, as with your arcade autoposting highscores to forum thread, only registered members could grab the rss link.Now the only way to show an rss icon/link is to open the forums too guests..If it's not open to guests you don't get an rss feed..

 

[Darkwaltz4]

It looks like the page still gives off an rss feed, just not a physical image to click on. its not necessary really, just having an available url that a feed reader can detect.

 

[skol]

Yes but clicking on the link will take them to the forum available for guests.Which is why I ask about creating a standalone rss feed for the arcade as when they click the links,they'll have too register to play..