[MOD] RSS last 20 games

[robb9]

I realized this simple mod for RSS last 20 games:

Create a filename .php example: last20games.php



<?

$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&amp;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>";


?>




that's all.

enjoy.

[Stifmeister2]

What exactly is this? Demo please. ;)

[robb9]

What exactly is this? Demo please. ;)

ceck here:
http://en.wikipedia.org/wiki/Rss