My Arcade - Druckversion

Code:
// Best Players

        if($mybb->settings['arcade_stats_bestplayers'] == 1)

        {

            $rank = 0;



            $query5 = $db->query("

                SELECT c.uid, c.username, u.avatar, u.avatardimensions, COUNT(c.gid) AS champs, u.usergroup, u.displaygroup

                FROM ".TABLE_PREFIX."arcadechampions c

                LEFT JOIN ".TABLE_PREFIX."arcadegames g ON (g.gid=c.gid)

                LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=c.uid)

                WHERE g.active ='1'{$cat_sql_game}

                GROUP BY c.uid, c.username

                ORDER BY champs DESC

                LIMIT 3

            ");

            while($champ = $db->fetch_array($query5))

            {

                $rank++;

                $bestplayer_rank_lang = "bestplayers_place_".$rank;

                $bestplayer_rank_lang = $lang->$bestplayer_rank_lang;



                if($mybb->settings['arcade_stats_avatar'] == 1)

                {

                    $useravatar = format_avatar(htmlspecialchars_uni($champ['avatar']), $champ['avatardimensions'], '100x100');

                    eval("\$best_player_avatar = \"".$templates->get("arcade_statistics_bestplayers_avatar")."\";");

                }



                $champ['username'] = format_name(htmlspecialchars_uni($champ['username']), $champ['usergroup'], $champ['displaygroup']);

                $with_wins = $lang->sprintf($lang->with_wins, $champ['champs']);



                if($mybb->usergroup['canviewgamestats'] == 1)

                {

                    $profilelink = "arcade.php?action=stats&uid={$champ['uid']}";

                }

                else

                {

                    $profilelink = get_profile_link($champ['uid']);

                }



                eval("\$bestplayers_bit .= \"".$templates->get("arcade_statistics_bestplayers_bit")."\";");

            }