//
// ------------------------------------------------------------------------- //
// Original Author: The Xoops Project
// Author Website : http://www.xoops.org
// License Type : GPL: See /manual/LICENSES/GPL.txt
// ------------------------------------------------------------------------- //
include_once("../../mainfile.php");
include_once(XOOPS_ROOT_PATH."/class/xoopscomments.php");
include_once(XOOPS_ROOT_PATH."/header.php");
global $db;
function _uname_link($uid) {
global $bcoosConfig,$xoopsUser;
$link = '';
if ($uid == 0) { $link .= $bcoosConfig['anonymous'];
} else {
$uname = XoopsUser::getUnameFromId($uid);
$link .= "$uname";
}
return $link;
}
$gid = intval($_GET['item_id']);
$sql = "SELECT gtitle FROM ".$db->prefix('arcade_games')." WHERE gid=$gid";
$res = $db->query($sql);
list($gtitle) = $db->fetchArray($res);
$sql = "SELECT * FROM ".$db->prefix('arcade_scores')." WHERE gid=$gid ORDER BY score DESC";
$res = $db->query($sql, 10);
$iRow = 1;
echo "
";
echo "";
echo "| ".$gtitle." "._MD_LEADERBOARD." | ";
echo " | "._MD_SCORE." | "._USER." | "._DATE." | ";
while($row = $db->fetch_object($res))
{ echo "| $iRow | ".$row->score." | "._uname_link($row->uid)." | ".formatTimestamp($row->score_date, 'm')." | ";
$iRow ++;
}
echo " ";
echo " |
";
echo "";
$pid = 0;
OpenTable();
$subject = $gtitle;
include_once(XOOPS_ROOT_PATH."/include/commentform.inc.php");
CloseTable();
include_once(XOOPS_ROOT_PATH."/footer.php");
?>