Pulling in high scores from smfarcade into a block. Has anybody tried this?

[Broc Lee]

For those using SMF Arcade 2.0.14.....

Here is the code to make this work    :up:

Code Select Expand

require('./Settings.php');

$top = highscore();
//echo "<pre>".print_r($top,true)."</pre>";

foreach($top as $temp){

echo"<table align=\"center\" width=\"100%\"><tr><td align=\"center\" class=\"smalltext\"><b><a href=\"$boardurl/index.php?action=profile;u={$temp['ID_MEMBER']}\">{$temp['realName']}</a></b></td></tr>";
echo "<tr><td align=\"center\"><a href=\"$boardurl/index.php?action=arcade;sa=play;game={$temp['ID_GAME']}\"><img src=\"$boardurl/Games/{$temp['gameDirectory']}/{$temp['thumbnail']}\"></a></td></tr><tr><td align=\"center\" class=\"smalltext\"><a href=\"$boardurl/index.php?action=arcade;sa=play;game={$temp['ID_GAME']}\">{$temp['gameName']}</a> - {$temp['score']}</td></tr><tr><td width=\"100%\"><hr></td></tr></table>";
}
function highscore($count = 5, $game = "", $cutoff = 0)
{
global $link,$db_prefix,$boarddir,$boardurl;

if($game == "")
$query = "SELECT * FROM {$db_prefix}arcade_games,{$db_prefix}arcade_scores,{$db_prefix}members WHERE {$db_prefix}arcade_games.ID_GAME={$db_prefix}arcade_scores.ID_GAME AND {$db_prefix}arcade_scores.ID_MEMBER={$db_prefix}members.ID_MEMBER ORDER BY score DESC LIMIT 0,{$count}";
else
$query = "SELECT * FROM {$db_prefix}arcade_games,{$db_prefix}arcade_scores,{$db_prefix}members WHERE {$db_prefix}arcade_games.ID_GAME={$db_prefix}arcade_scores.ID_GAME AND {$db_prefix}arcade_scores.ID_MEMBER={$db_prefix}members.ID_MEMBER AND {$db_prefix}arcade_games.ID_GAME='{$game}' ORDER BY score DESC LIMIT 0,{$count}";
$res = mysql_query($query) or die(mysql_error());
$top = array();
while($x = mysql_fetch_array($res))
{
$x['score'] = (string)$x['score'];
$top[] = $x;

}
return $top;
}

I have also added a thumbnail of the game, a link to the game and a link to the members profile.

Take a look:  http://www.thrillcycle.com/forum/index.php - Left side, under the Search Box.

Enjoy!!!
~Broc

[sir_keg1]

That was what I was looking for, Broc. Thanks!