root/branches/user_agent/stats.php

<?php

if (!defined('FORUM_ROOT'))
        define('FORUM_ROOT', '../../');
require FORUM_ROOT.'include/common.php';

if (!defined('EXT_ROOT'))
        define('EXT_ROOT', './');
require EXT_ROOT.'functions.php';


define('FORUM_PAGE', 'useragent-stats');
require FORUM_ROOT.'header.php';

$user_agent_cache = array();

// START SUBST - <!-- forum_main -->
ob_start();

?>
<style type="text/css">

.ua-stats div.ua-box {
        clear: both;
}

.ua-stats div img {
        float: left;
        margin-right: 5px;
}

.ua-stats span.ua-left {
        width: 5%;
        float: left;
}

.ua-stats span.ua-right {
        display: block;
        padding-top: 3px;
}

</style>
<?php

$useragent_stats = array();

if (file_exists(FORUM_CACHE_DIR.'cache_useragent_stats.php'))
        require FORUM_CACHE_DIR.'cache_useragent_stats.php';

// generate cache if it is older than 3 hours
if (!isset($useragent_stats['timestamp']) || isset($useragent_stats['timestamp']) && time() - $useragent_stats['timestamp'] > 3600 * 3) 
{       
        // Fetch some info about the topic
        $query = array(
                'SELECT'        => 'p.user_agent',
                'FROM'          => 'posts AS p',
                'WHERE'         => 'p.user_agent IS NOT NULL',
                'ORDER BY'      => 'p.user_agent ASC',
        );

        ($hook = get_hook('vt_qr_get_topic_info')) ? eval($hook) : null;
        $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);

        while ($cur_post = $forum_db->fetch_assoc($result))
        {
                $agent = $cur_post['user_agent'];
                if (!$agent)
                        continue;
                
                $system = $browser = '';
                
                // Load from cache
                if (isset($user_agent_cache[$agent]))
                {
                        $agent_names = $user_agent_cache[$agent];
                }
                else
                {
                        $agent_names = get_useragent_names($agent);
                        $user_agent_cache[$agent] = $agent_names;
                }
                
                if ($agent_names['system'])
                {
                        if (isset($system_count[$agent_names['system']]))
                                $system_count[$agent_names['system']]++;
                        else
                                $system_count[$agent_names['system']] = 1;
                                
                        $system_count_all++;
                }

                if ($agent_names['browser_img'])
                {
                        if (isset($browser_count[$agent_names['browser_name']]))
                                $browser_count[$agent_names['browser_name']]++;
                        else
                                $browser_count[$agent_names['browser_name']] = 1;
                }
        }

        arsort($system_count);
        arsort($browser_count);
        
        $useragent_stats = array(
                'system'                => $system_count,
                'browser'               => $browser_count,
                'timestamp'             => time(),
        );

        // Output config as PHP code
        $fh = @fopen(FORUM_CACHE_DIR.'cache_useragent_stats.php', 'wb');
        if (!$fh)
                error('Unable to write configuration cache file to cache directory. Please make sure PHP has write access to the directory \'cache\'.', __FILE__, __LINE__);

        fwrite($fh, '<?php'."\n\n".'$useragent_stats = '.var_export($useragent_stats, true).';'."\n\n".'?>');

        fclose($fh);
}

$system_count = array_sum($useragent_stats['system']);
$browser_count = array_sum($useragent_stats['browser']);

$i = 0;
foreach ($useragent_stats['system'] as $system => $count)
{
        if ($i > 20)
                break;
        
        $forum_page['system_list'][] = '<span class="ua-left">'.$count.'</span>'.ua_chart($count, $system_count).'<img src="'.ua_get_filename($system, 'system').'" /><span class="ua-right">'.$system.'</span>';
        
        $i++;
}

$i = 0;

foreach ($useragent_stats['browser'] as $browser => $count)
{
        if ($i > 30)
                break;
        
        if (ua_str_contains($browser, 'Internet Explorer'))
        {
                $browser_name = $browser;
                $ie_version = substr($browser, strlen($browser) - 3);
                $ie_version = substr($ie_version, 0, 1);
                if (intval($ie_version) > 6)
                        $browser_name = 'Internet Explorer 7';
                else
                        $browser_name = 'Internet Explorer';
        }
        else
                $browser_name = substr($browser, 0, strrpos($browser, ' '));


        $forum_page['browser_list'][] = '<span class="ua-left">'.$count.'</span>'.ua_chart($count, $browser_count).'<img src="'.ua_get_filename($browser_name, 'browser').'" /><span class="ua-right">'.$browser.'</span>';
        
        $i++;
}


?>
        <div class="main-head">
                <h2 class="hn"><span>Stats</span></h2>
        </div>

        <div class="main-content main-frm ua-stats">

<?php


?>              
                        <div class="ct-box">
                                <h2 class="hn">Systems</h2>
                                <div class="ua-box"><?php echo implode('</div><div class="ua-box">', $forum_page['system_list']) ?></div>
                        </div>

                        <div class="ct-box">
                                <h2 class="hn">Browsers</h2>
                                <div class="ua-box"><?php echo implode('</div><div class="ua-box">', $forum_page['browser_list']) ?></div>
                        </div>
<?php


?>
        </div>
<?php


$tpl_temp = forum_trim(ob_get_contents());
$tpl_main = str_replace('<!-- forum_main -->', $tpl_temp, $tpl_main);
ob_end_clean();
// END SUBST - <!-- forum_main -->

require FORUM_ROOT.'footer.php';