Was wondering how would i get this peice of code into a block
PHP Code:
// Champion games in profile
$profilegq = $db->query_read("SELECT u.userid AS userid, g.gameid AS gameid, g.title AS title, g.miniimage AS image FROM " . TABLE_PREFIX . "arcade_games AS g LEFT JOIN " . TABLE_PREFIX . "user AS u ON u.userid = g.highscorerid WHERE u.userid = $userinfo[userid] ORDER BY g.title ASC");
while ($profileg = $db->fetch_array($profilegq)){
$pgrow .= "<a href=\"arcade.php?do=play&gameid=$profileg[gameid]\"><img src=\"./images/arcade/$profileg[image]\" alt=\"\" title=\"Play $profileg[title]!\" border=\"0\" /></a> ";
}
$acount = $db->num_rows($profilegq);