Exemple #1
0
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();
}
Exemple #2
0
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>';
    }
}
Exemple #4
0
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'];
}
Exemple #5
0
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;
}