require_once MYBB_ROOT."inc/class_games.php";
$games_core = new games;
$games_core->run_settings();
//Theme setting
if($mybb->user['uid'] != 0 && $mybb->user['games_theme'] != "0")
{
$theme_games_tid = $mybb->user['games_theme'];
}
else
{
$theme_games_tid = $games_core->settings['theme'];
}
//Game Section Theme
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."games_themes WHERE tid='".$theme_games_tid."' AND active='1'");
$theme_games = $db->fetch_array($query);
$theme_games_test = $db->num_rows($query);
if($theme_games_test == 0)
{
//The user selected theme doesn't exist, load the default theme
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."games_themes WHERE tid='".$games_core->settings['theme']."' AND active='1'");
$theme_games = $db->fetch_array($query);
$theme_games_test2 = $db->num_rows($query);
}
else
{
$theme_games_test2 = 1;
}
if($theme_games_test2 == 0)
{
//The standard theme doesn't exist, load the default Game Section theme
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."games_themes WHERE tid='1'");
$theme_games = $db->fetch_array($query);
$theme_games_test3 = $db->num_rows($query);
}
else
{
$theme_games_test3 = 1;
}
//No theme available
if($theme_games_test3 == 0)
{
die("The users selected theme, the default theme and the Game Section Default theme doesn't exist.");
}
//Load bestplayers
$query = $db->query("SELECT u.uid, u.username, u.avatar, COUNT(c.gid) AS champs
FROM ".TABLE_PREFIX."games_champions c
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=c.uid)
LEFT JOIN ".TABLE_PREFIX."games g ON (c.gid=g.gid)
WHERE g.active='1'
GROUP BY u.uid
ORDER BY champs DESC, c.dateline ASC
LIMIT 0,3");
$rank = 0;
while($bestplayers = $db->fetch_array($query))
{
$rank++;
$bestplayers_place = "bestplayers_place_".$rank;
$bestplayers_place = $lang->$bestplayers_place;
$bestplayers_sen = $lang->sprintf($lang->bestplayers_sen, $bestplayers['username'], $bestplayers['champs']);
if(!empty($bestplayers['avatar']))
{
$bestplayers_avatar = "<img src=\"".$bestplayers['avatar']."\" alt\"\" />";
}
else
{
$bestplayers_avatar = "";
}
//Plugin
$plugins->run_hooks("games_stats_bestplayers");
eval("\$bestplayers_bit .= \"".$games_core->template("games_stats_bestplayers_bit")."\";");
}
eval("\$stats_bestplayers = \"".$games_core->template("games_stats_bestplayers")."\";");
