<?php
function _uname_linkblock($uid)
{
global $xoopsConfig;

$link = '';
if ($uid == 0)
{
$link .= $xoopsConfig['anonymous'];
}
else
{
$uname = XoopsUser::getUnameFromId($uid);
$link .= "<a href='".XOOPS_URL."/user.php?uid=$uid'>$uname</a>";
}

return $link;
}
/**************************************************************/
function _get_game_highscoreblock($gid)
{
global $db;

$highscore['score'] = 0;
$highscore['uname'] = '???';

$sql = "SELECT uid, score from ".$db->prefix('arcade_scores')." where gid=$gid ORDER BY score DESC";
$res = $db->query($sql);
if($res &amp;&amp; $db->num_rows($res) > 0)
{
$row = $db->fetch_array($res);
$highscore['uname'] = _uname_linkblock($row[0]);
$highscore['score'] = $row[1];
}

return $highscore;
}
/**************************************************************/

function b_highscores_show()
{
global $db, $myts;

$block = array();
$block['title'] = _MDB_TITLE;
$block['content'] = '<table width="100%">';
$block['content'] .= "<tr>";
$block['content'] .= "<td></td>";
$block['content'] .= "<td><b>"._MDB_SCORE."</b></td>";
$block['content'] .= "<td><b>"._MDB_USER."</b></td>";
$block['content'] .= "</tr>";

$sql = "select * from ".$db->prefix('arcade_games')." ORDER BY RAND(NOW())";
$res = $db->query($sql, 5);

while ($row = $db->fetch_object($res))
{
$highscore = _get_game_highscoreblock($row->gid);

$block['content'] .= "<tr>";
$block['content'] .= "<td><img src='".XOOPS_URL."/modules/arcade/cache/images/".$row->gname."2.gif' title='".$row->gtitle."'></td>";
$block['content'] .= "<td>".$highscore['score']."</td>";
$block['content'] .= "<td>".$highscore['uname']."</td>";
$block['content'] .= "</tr>";
}

$block['content'] .= '</table>';
return $block;
}


?>