function ArcadeStats()
{
global $txt, $context;
$context['sub_template'] = 'arcade_statistics';
$context['page_title'] = $txt['arcade_stats_title'];
// Load data using functions
$context['arcade']['statistics']['play'] = ArcadeStats_MostPlayed();
$context['arcade']['statistics']['active'] = ArcadeStats_MostActive();
$context['arcade']['statistics']['rating'] = ArcadeStats_Rating();
$context['arcade']['statistics']['champions'] = ArcadeStats_BestPlayers();
$context['arcade']['statistics']['longest'] = ArcadeStats_LongestChampions();
$context['arcade']['statistics']['total'] = ArcadeStats_total_plays();
}
function ArcadeStatistics()
{
global $txt, $context, $scripturl;
// Load data using functions
$context['arcade']['statistics']['play'] = ArcadeStats_MostPlayed();
$context['arcade']['statistics']['active'] = ArcadeStats_MostActive();
$context['arcade']['statistics']['rating'] = ArcadeStats_Rating();
$context['arcade']['statistics']['champions'] = ArcadeStats_BestPlayers();
$context['arcade']['statistics']['longest'] = ArcadeStats_LongestChampions();
// Layout
loadTemplate('ArcadeStats');
$context['sub_template'] = 'arcade_statistics';
$context['page_title'] = $txt['arcade_stats_title'];
// Linktree
$context['linktree'][] = array('url' => $scripturl . '?action=arcade;sa=stats', 'name' => $txt['arcade_stats']);
}
function sp_arcade($parameters, $id, $return_parameters = false)
{
global $smcFunc, $sourcedir, $scripturl, $settings, $txt, $color_profile;
static $mod;
$block_parameters = array('limit' => 'int', 'type' => 'select');
if ($return_parameters) {
return $block_parameters;
}
$limit = !empty($parameters['limit']) ? (int) $parameters['limit'] : 5;
$type = !empty($parameters['type']) ? (int) $parameters['type'] : 0;
if (!isset($mod)) {
if (file_exists($sourcedir . '/Arcade.php')) {
$mod = 'smf_arcade';
} else {
$mod = '';
}
}
if (empty($mod)) {
echo '
', $txt['error_sp_no_arcade_found'];
return;
} elseif ($mod == 'smf_arcade') {
require_once $sourcedir . '/ArcadeStats.php';
require_once $sourcedir . '/Subs-Arcade.php';
loadLanguage('Arcade');
if (empty($type)) {
$stats = ArcadeStats_MostPlayed($limit);
} elseif ($type == 1) {
$stats = ArcadeStats_BestPlayers($limit);
} elseif ($type == 2) {
$stats = ArcadeStats_LongestChampions($limit);
}
if (empty($stats)) {
echo '
', $txt['error_sp_no_stats_found'];
return;
} else {
$stats[count($stats) - 1]['last'] = true;
}
echo '
<ul class="sp_list">';
if (empty($type)) {
foreach ($stats as $stat) {
echo '
<li class="sp_list_top">', sp_embed_image('game'), ' ', $stat['link'], '</li>
<li class="', empty($stat['last']) ? 'sp_list_bottom ' : '', 'sp_list_indent smalltext">', $txt['sp-game_plays'], ': ', $stat['plays'], ' | ', $txt['sp-game_rating'], ': ', $stat['rating'], '</li>';
}
} elseif ($type == 1) {
$types = array(1 => 'gold', 'silver', 'bronze');
$current = 0;
foreach ($stats as $stat) {
echo '
<li class="sp_list_top">', sp_embed_image(isset($types[++$current]) ? $types[$current] : 'user'), ' ', $stat['link'], '</li>
<li class="', empty($stat['last']) ? 'sp_list_bottom ' : '', 'sp_list_indent smalltext"><img src="', $settings['images_url'], '/bar.gif" width="', $stat['precent'], '" height="8" alt="" /> ', $stat['champions'], ' ', $txt['sp-games'], '</li>';
}
} elseif ($type == 2) {
$types = array(1 => 'gold', 'silver', 'bronze');
$current = 0;
foreach ($stats as $stat) {
echo '
<li class="sp_list_top">', sp_embed_image(isset($types[++$current]) ? $types[$current] : 'user'), ' ', $stat['member_link'], '</li>
<li class="', empty($stat['last']) ? 'sp_list_bottom ' : '', 'sp_list_indent smalltext">', $stat['game_link'], '<br />', $stat['duration'], '</li>';
}
}
echo '
</ul>';
}
}
function ArcadeList()
{
global $scripturl, $txt, $db_prefix, $modSettings, $context, $user_info, $smcFunc, $sourcedir;
// Sorting methods
$sort_methods = array('age' => 'game.id_game', 'name' => 'game.game_name', 'plays' => 'game.num_plays', 'champion' => 'mem.member_name', 'myscore' => 'IFNULL(pb.score, 0)', 'category' => 'category.cat_name', 'favorite' => 'IF(favorite.id_favorite = null, 0, 1)');
// How user wants to sort games?
if (!isset($_REQUEST['sort']) || !isset($sort_methods[$_REQUEST['sort']])) {
$context['sort_by'] = 'name';
$_REQUEST['sort'] = 'game.game_name';
} else {
$context['sort_by'] = $_REQUEST['sort'];
$_REQUEST['sort'] = $sort_methods[$_REQUEST['sort']];
}
$ascending = !isset($_REQUEST['desc']);
$context['sort_direction'] = $ascending ? 'up' : 'down';
$select_rows = '';
$select_tables = '';
$where = '';
// Build query this will make litle clearer code than if every part where on query itself ;)
if (!$user_info['is_guest']) {
$select_rows = ',
IFNULL(pb.id_score, 0) AS id_pb, IFNULL(pb.score, 0) AS personal_best, IFNULL(favorite.id_favorite, 0) AS is_favorite';
$select_tables = (isset($_REQUEST['favorites']) ? 'INNER JOIN' : 'LEFT JOIN') . ' {db_prefix}arcade_favorite AS favorite ON (favorite.id_game = game.id_game
AND favorite.id_member = {int:member})
LEFT JOIN {db_prefix}arcade_scores AS pb ON (pb.id_game = game.id_game
AND pb.id_member = {int:member} AND pb.personal_best = 1)';
}
$baseurl = $scripturl . '?action=arcade';
$context['arcade_search'] = array();
if (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'search') {
$baseurl .= ';sa=search';
if (!empty($_REQUEST['name'])) {
$baseurl .= ';name=' . urlencode($_REQUEST['name']);
$context['arcade_search']['name'] = $_REQUEST['name'];
$where .= '
AND game.game_name LIKE {string:name}';
}
}
if (isset($_REQUEST['category'])) {
$where .= '
AND game.id_cat = {int:category}';
}
if (isset($_REQUEST['sort'])) {
$baseurl .= ';sort=' . $context['sort_by'];
}
if (isset($_REQUEST['desc'])) {
$baseurl .= ';desc';
}
if (isset($_REQUEST['favorites'])) {
$baseurl .= ';favorites';
$context['arcade_search']['favorites'] = true;
}
if (isset($_REQUEST['category'])) {
$baseurl .= ';category=' . $_REQUEST['category'];
}
$result = $smcFunc['db_query']('', '
SELECT COUNT(*)
FROM {db_prefix}arcade_games AS game
LEFT JOIN {db_prefix}arcade_categories AS category ON (category.id_cat = game.id_cat)' . (isset($_REQUEST['favorites']) ? '
INNER JOIN {db_prefix}arcade_favorite AS favorite ON (favorite.id_game = game.id_game
AND favorite.id_member = {int:member})' : '') . '
WHERE {query_see_game}' . $where, array('name' => isset($_REQUEST['name']) ? '%' . $_REQUEST['name'] . '%' : '', 'member' => $user_info['id'], 'category' => isset($_REQUEST['category']) ? (int) $_REQUEST['category'] : 0));
list($gameCount) = $smcFunc['db_fetch_row']($result);
$smcFunc['db_free_result']($result);
$context['page_index'] = constructPageIndex($baseurl, $_REQUEST['start'], $gameCount, $context['games_per_page'], false);
$request = $smcFunc['db_query']('', '
SELECT
game.id_game, game.game_name, game.description, game.game_rating, game.num_plays,
game.score_type, game.thumbnail, game.thumbnail_small, game.help,
IFNULL(mem.id_member, 0) AS id_member, IFNULL(score.id_score, 0) AS id_score,
IFNULL(score.score, 0) AS champ_score, IFNULL(mem.real_name, score.player_name) AS real_name,
IFNULL(score.end_time, 0) AS champion_time, IFNULL(category.id_cat, 0) AS id_cat,
IFNULL(category.cat_name, {string:empty_string}) AS cat_name' . $select_rows . '
FROM {db_prefix}arcade_games AS game
LEFT JOIN {db_prefix}arcade_scores AS score ON (score.id_score = game.id_champion_score)
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = game.id_champion)
LEFT JOIN {db_prefix}arcade_categories AS category ON (category.id_cat = game.id_cat)' . $select_tables . '
WHERE {query_see_game}' . $where . '
ORDER BY {raw:sort}
LIMIT {int:limit}, {int:games_per_page}', array('empty_string' => '', 'name' => isset($_REQUEST['name']) ? '%' . $_REQUEST['name'] . '%' : '', 'sort' => $_REQUEST['sort'] . ($ascending ? '' : ' DESC'), 'limit' => $_REQUEST['start'], 'games_per_page' => $context['games_per_page'], 'member' => $user_info['id'], 'category' => isset($_REQUEST['category']) ? (int) $_REQUEST['category'] : 0));
$context['arcade']['games'] = array();
while ($row = $smcFunc['db_fetch_assoc']($request)) {
if (empty($row['real_name'])) {
$row['real_name'] = $txt['guest'];
}
// Is game installed in subdirectory
if (!empty($row['game_directory'])) {
$gameurl = $modSettings['gamesUrl'] . '/' . $row['game_directory'] . '/';
} else {
$gameurl = $modSettings['gamesUrl'] . '/';
}
$context['arcade']['games'][] = array('id' => $row['id_game'], 'url' => array('play' => $scripturl . '?action=arcade;sa=play;game=' . $row['id_game'], 'highscore' => $scripturl . '?action=arcade;sa=highscore;game=' . $row['id_game'], 'edit' => $scripturl . '?action=managegames;sa=edit;game=' . $row['id_game'], 'favorite' => $context['arcade']['can_favorite'] ? $row['is_favorite'] == 0 ? $scripturl . '?action=arcade;sa=favorite;game=' . $row['id_game'] : $scripturl . '?action=arcade;sa=favorite;remove;game=' . $row['id_game'] : '#'), 'category' => array('id' => $row['id_cat'], 'name' => $row['cat_name'], 'link' => $scripturl . '?action=arcade;category=' . $row['id_cat']), 'name' => $row['game_name'], 'description' => parse_bbc($row['description']), 'plays' => $row['num_plays'], 'is_champion' => $row['id_score'] > 0, 'champion' => array('member_id' => $row['id_member'], 'score_id' => $row['id_score'], 'member_link' => !empty($row['id_member']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>' : $row['real_name'], 'score' => comma_format($row['champ_score']), 'time' => $row['champion_time']), 'is_personal_best' => !$user_info['is_guest'] && $row['id_pb'] > 0, 'personal_best' => !$user_info['is_guest'] ? comma_format($row['personal_best']) : 0, 'personal_best_score' => !$user_info['is_guest'] ? $row['personal_best'] : 0, 'highscore_support' => $row['score_type'] != 2, 'is_favorite' => $context['arcade']['can_favorite'] ? $row['is_favorite'] > 0 : false, 'rating' => $row['game_rating'], 'rating2' => round($row['game_rating']), 'thumbnail' => !empty($row['thumbnail']) ? $gameurl . $row['thumbnail'] : '', 'thumbnail_small' => !empty($row['thumbnail_small']) ? $gameurl . $row['thumbnail_small'] : '');
}
$smcFunc['db_free_result']($request);
if (!empty($modSettings['arcadeShowInfoCenter'])) {
if (($context['arcade']['stats'] = cache_get_data('arcade-stats', 180)) == null) {
$context['arcade']['stats'] = array();
// How many games?
$result = $smcFunc['db_query']('', '
SELECT COUNT(*) AS games
FROM {db_prefix}arcade_games
WHERE enabled = 1', array());
$context['arcade']['stats'] += $smcFunc['db_fetch_assoc']($result);
$smcFunc['db_free_result']($result);
require_once $sourcedir . '/ArcadeStats.php';
$context['arcade']['stats']['best_player'] = ArcadeStats_BestPlayers(1);
$context['arcade']['stats']['longest_champion'] = ArcadeStats_LongestChampions(1, null, 'current');
$context['arcade']['stats']['most_played'] = ArcadeStats_MostPlayed(1);
cache_put_data('arcade-stats', $context['arcade']['stats'], 180);
}
$context['arcade']['latest_scores'] = ArcadeLatestScores(5, 0);
$context['arcade_viewing'] = array();
$context['arcade_num_viewing'] = array('member' => 0, 'guest' => 0, 'hidden' => 0);
// Search for members in arcade
$request = $smcFunc['db_query']('', '
SELECT
lo.id_member, lo.log_time, lo.url, mem.real_name, mem.member_name, mem.show_online,
mg.online_color, mg.id_group, mg.group_name
FROM {db_prefix}log_online AS lo
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = lo.id_member)
LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = 0 THEN mem.id_post_group ELSE mem.id_group END)
WHERE INSTR(lo.url, {string:url}) OR lo.session = {string:session}', array('url' => 's:6:"action";s:6:"arcade"', 'session' => $user_info['is_guest'] ? 'ip' . $user_info['ip'] : session_id()));
while ($row = $smcFunc['db_fetch_assoc']($request)) {
if (empty($row['id_member'])) {
$context['arcade_num_viewing']['guest']++;
continue;
}
if (!empty($row['online_color'])) {
$link = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '" style="color: ' . $row['online_color'] . ';">' . $row['real_name'] . '</a>';
} else {
$link = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>';
}
$is_buddy = in_array($row['id_member'], $user_info['buddies']);
if ($is_buddy) {
$link = '<b>' . $link . '</b>';
}
// Add them both to the list and to the more detailed list.
if (!empty($row['show_online']) || allowedTo('moderate_forum')) {
$context['arcade_num_viewing']['member']++;
$context['arcade_viewing'][$row['log_time'] . $row['member_name']] = empty($row['show_online']) ? '<i>' . $link . '</i>' : $link;
}
if (empty($row['show_online'])) {
$context['arcade_num_viewing']['hidden']++;
}
}
$smcFunc['db_free_result']($request);
krsort($context['arcade_viewing']);
}
// Layout
loadTemplate('ArcadeList');
$context['sub_template'] = 'arcade_list';
$context['page_title'] = $txt['arcade_game_list'];
}
function ArcadeInfoLongestChamps($no)
{
global $scripturl, $txt, $arcSettings;
$mostgame = ArcadeStats_LongestChampions($no);
$content = '<div align="center"><table width="100%" border="0" cellpadding="3"><tr><td colspan="3"><div align="center"><i><b>' . $no . ' ' . $txt['arcade_g_i_b_11'] . '</b></i></div></td></tr>';
if (is_array($mostgame)) {
foreach ($mostgame as $popgame) {
$popgameico = !$popgame['game_directory'] ? $arcSettings['gamesUrl'] . $popgame['thumbnail'] : $arcSettings['gamesUrl'] . $popgame['game_directory'] . "/" . $popgame['thumbnail'];
$content .= '<tr><td width="25"><a href="' . $scripturl . '?action=arcade;sa=play;game=' . $popgame['id'] . '"><img border="0" src="' . $popgameico . '" alt="ico" width="25" height="25" title="' . $txt['arcade_champions_play'] . ' ' . $popgame['game_name'] . '"/></a></td><td class="middletext"><div align="left">' . $popgame['member_link'] . ' ' . $txt['arcade_g_i_b_9'] . ' ' . $popgame['game_name'] . ' ' . $txt['arcade_g_i_b_5'] . ' ' . $popgame['duration'] . '</div></td></tr>';
}
}
$content .= '</table></div>';
return $content;
}