-/* Copyright 2006, 2007, 2008, 2009, 2010 Arun Persaud <arun@nubati.net>
+/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013 Arun Persaud <arun@nubati.net>
global $WIKI,$INDEX, $HOST;
/* output last creation date */
global $WIKI,$INDEX, $HOST;
/* output last creation date */
$result = DB_query("SELECT Hand.hash,Hand.game_id,Game.player from Hand".
" LEFT JOIN Game On Hand.game_id=Game.id".
$result = DB_query("SELECT Hand.hash,Hand.game_id,Game.player from Hand".
" LEFT JOIN Game On Hand.game_id=Game.id".
- " WHERE Hand.user_id='$id'".
- " AND ( Game.player='$id' OR ISNULL(Game.player) )".
+ " WHERE Hand.user_id=".DB_quote_smart($id).
+ " AND ( Game.player=".DB_quote_smart($id)." OR ISNULL(Game.player) )".
" AND ( Game.status='pre' OR Game.status='play' )".
" ORDER BY Game.session" );
while( $r = DB_fetch_array($result))
{
echo "<entry>\n";
" AND ( Game.status='pre' OR Game.status='play' )".
" ORDER BY Game.session" );
while( $r = DB_fetch_array($result))
{
echo "<entry>\n";
$url=$INDEX."?action=game&me=".$r[0];
echo "<link href=\"".$HOST.$url."\" />\n";
$date = DB_get_game_timestamp($r[1]);
$url=$INDEX."?action=game&me=".$r[0];
echo "<link href=\"".$HOST.$url."\" />\n";
$date = DB_get_game_timestamp($r[1]);
$date = date("Y-m-d",$timestamp);
echo "<id>tag:doko.nubati.net,$date:$url</id>\n";
echo "<updated>".date(DATE_ATOM,$timestamp)."</updated>\n";
$date = date("Y-m-d",$timestamp);
echo "<id>tag:doko.nubati.net,$date:$url</id>\n";
echo "<updated>".date(DATE_ATOM,$timestamp)."</updated>\n";