Вход Регистрация
Файл: IPBMafia.ru_IPB_3.4.6_Final_Rus _Nulled/board/upload/admin/applications/forums/modules_admin/statistics/stats.php
Строк: 502
<?php
/**
 * <pre>
 * Invision Power Services
 * IP.Board v3.4.6
 * Forum Statistics
 * Last Updated: $Date: 2013-04-19 19:48:56 -0400 (Fri, 19 Apr 2013) $
 * </pre>
 *
 * @author         $Author: bfarber $
 * @copyright    (c) 2001 - 2009 Invision Power Services, Inc.
 * @license        http://www.invisionpower.com/company/standards.php#license
 * @package        IP.Board
 * @subpackage    Forums
 * @link        http://www.invisionpower.com
 * @version        $Rev: 12191 $
 */


if ( ! defined'IN_ACP' ) )
{
    print 
"<h1>Incorrect access</h1>You cannot access this file directly. If you have recently upgraded, make sure you upgraded 'admin.php'.";
    exit();
}

class 
admin_forums_statistics_stats extends ipsCommand
{
    
/**
    * Array of Month Names
    *
    * @var        array
    */        
    
protected $month_names;
    
    
/**
    * Skin object
    *
    * @var        object            Skin templates
    */    
    
protected $html;    
    
    
/**
    * Main class entry point
    *
    * @param    object        ipsRegistry reference
    * @return    @e void        [Outputs to screen]
    */
    
public function doExecuteipsRegistry $registry )
    {
        
/* Load HTML and Lang */
        
$this->html $this->registry->output->loadTemplate'cp_skin_stats' );
        
$this->registry->class_localization->loadLanguageFile( array( 'admin_stats' ) );

        
/* URLs */
        
$this->form_code    $this->html->form_code    'module=statistics&amp;section=stats';
        
$this->form_code_js    $this->html->form_code_js    'module=statistics&section=stats';        
        
        
/* Setup the month name array */
        
$this->month_names = array( 1    => $this->lang->words['stats_jan'], 
                                    
2    => $this->lang->words['stats_feb'], 
                                    
3    => $this->lang->words['stats_mar'], 
                                    
4    => $this->lang->words['stats_apr'],
                                    
5    => $this->lang->words['stats_may'], 
                                    
6    => $this->lang->words['stats_jun'], 
                                    
7    => $this->lang->words['stats_jul'], 
                                    
8    => $this->lang->words['stats_aug'], 
                                    
9    => $this->lang->words['stats_sep'], 
                                    
10    => $this->lang->words['stats_oct'], 
                                    
11    => $this->lang->words['stats_nov'], 
                                    
12    => $this->lang->words['stats_dec']
                                  );
        
        
/* Fix up navigation bar */
        
$this->registry->output->core_nav        = array();
        
$this->registry->output->ignoreCoreNav    true;
        
$this->registry->output->core_nav[]        = array( $this->settings['base_url'] . 'module=statistics'$this->lang->words['stats_title'] );
        
        
/* Silly timezones */
        
$tz floor$this->memberData['time_offset'] );
        
$this->DB->setTimeZone$tz );
        if ( 
$tz ==  )
        {
            
date_default_timezone_set'GMT' );
        }
        elseif ( 
$tz )
        {                
            
date_default_timezone_set'Etc/GMT-' $tz );
        }
        elseif ( 
$tz )
        {                
            
date_default_timezone_set'Etc/GMT+' abs$tz ) );
        }
        
        
/* What to do */
        
switch( $this->request['do'] )
        {
            case 
'spam':
                
$this->statsMainScreen'spam' );
            break;
            
            case 
'show_spam':
                
$this->spamServiceResultScreen();
            break;
            
            case 
'spamGraph':
                
$this->spamServiceGraph();
            break;
            
            case 
'show_reg':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_registration' );
                
$this->result_screen'reg' );
            break;
                
            case 
'show_topic':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_topics' );
                
$this->result_screen'topic' );
            break;
            
            case 
'topic':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_topics' );
                
$this->statsMainScreen'topic' );
            break;
            
            
//-----------------------------------------
            
            
case 'show_post':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_posts' );
                
$this->result_screen'post' );
            break;
                    
            case 
'post':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_posts' );
                
$this->statsMainScreen'post' );
            break;
            
            
//-----------------------------------------
            
            
case 'show_msg':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_msg' );
                
$this->result_screen'msg' );
            break;
                    
            case 
'msg':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_msg' );
                
$this->statsMainScreen'msg' );
            break;
                
            
//-----------------------------------------
            
            
case 'statsShowTopicViews':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_views' );
                
$this->statsShowTopicViews();
            break;
                    
            case 
'views':
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_views' );
                
$this->statsMainScreen'views' );
            break;
            
            
//-----------------------------------------
            
            
default:
                
$this->registry->getClass('class_permissions')->checkPermissionAutoMsg'stats_registration' );
                
$this->statsMainScreen'reg' );
            break;
        }
        
        
/* Output */
        
$this->registry->output->html_main .= $this->registry->output->global_template->global_frame_wrapper();
        
$this->registry->output->sendOutput();
    }
    
    
/**
     * Print a 1x1 transparent gif and safely exist
     *
     * @return    @e void
     */
    
protected function _safeExit()
    {
        
$content    base64_decode"R0lGODlhAQABAID/AMDAwAAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw==" );
        
header"Content-type: image/gif" );
        
header"Connection: Close" );
        
header"Cache-Control:  public, max-age=86400" );
        
header"Expires: " gmdate"D, d M Y, H:i:s"time() + 86400 ) . " GMT" );
        print 
$content;
        
flush();
        exit;
    }
    
    
/**
     * Display a graph of spam service stats
     *
     * @return    @e void
     */
    
public function spamServiceGraph()
    {
        
/* Check the to fields */
        
if ( ! checkdate$this->request['to_month'], $this->request['to_day'], $this->request['to_year'] ) )
        {
            
$this->_safeExit();
        }
        
        
/* Check the from fields */
        
if ( ! checkdate$this->request['from_month'] ,$this->request['from_day'] ,$this->request['from_year'] ) )
        {
            
$this->_safeExit();
        }
        
        
/* Create time stamps */
        
$to_time   mktime(12 ,,,$this->request['to_month']   ,$this->request['to_day']   ,$this->request['to_year']  );
        
$from_time mktime(12 ,,,$this->request['from_month'] ,$this->request['from_day'] ,$this->request['from_year']);
        
        
/* Get Human Dates */
        
$human_to_date   getdate$to_time );
        
$human_from_date getdate$from_time );

        
/* Setup Timescale */
          
switch( $this->request['timescale'] )
          {
              case 
'daily':
                  
$php_date "F jS - Y";
                  break;
                  
              case 
'monthly':
                  
$php_date "F Y";
                  break;
                  
              default:
                  
$php_date "W [F Y]";
                  break;
        }
        
        
$order $this->request['sortby'] == 'desc' 'desc' 'asc';
        
        
/* Query Spam Logs */
        
$this->DB->build( array( 
                                
'select'    => 'log_code, log_date'
                                
'from'        => 'spam_service_log'
                                
'where'        => 'log_date > ' $from_time ' AND log_date < ' $to_time,
                                
'order'        => 'log_date ' $order
                        
)    );
        
$this->DB->execute();
        
        
/* Make sure we have logs */
        
if( ! $this->DB->getTotalRows() )
        {
            
$this->_safeExit();
        }
        
        
/* Loop through and build data for two graph lines */
        
$notSpamData    = array();
        
$isSpamData        = array();
        
$labels            = array();
        
        while( 
$r $this->DB->fetch() )
        {
            
/* Ignore errors */
            
if( $r['log_code'] == )
            {
                continue;
            }
            
            
/* Date */
            
$logDate date$php_date$r['log_date'] );
            
            if( ! 
in_array$logDate$labels ) )
            {
                
$labels[] = $logDate;
            }
            
            if( ! isset( 
$notSpamData$logDate ] ) )
            {
                
$notSpamData$logDate ] = 0;
            }
            
            if( ! isset( 
$isSpamData$logDate ] ) )
            {
                
$isSpamData$logDate ] = 0;
            }
            
            if( 
$r['log_code'] == )
            {
                
$notSpamData$logDate ]++;
            }
            else if( 
in_array$r['log_code'], array( 23) ) )
            {
                
$isSpamData$logDate ]++;
            }
        }
        
        if( !
count($notSpamData) AND !count($isSpamData) )
        {
            
$this->_safeExit();
        }

        
/* Table Title */
        
$title $this->lang->words'timescale_' $this->request['timescale'] ] .{$this->lang->words['stats_spam']} ({$human_from_date['mday']} {$this->month_names[$human_from_date['mon']]} {$human_from_date['year']} {$this->lang->words['stats_to']} {$human_to_date['mday']} {$this->month_names[$human_to_date['mon']]} {$human_to_date['year']})";

        
/* Get the Graph Class */
        
require_once( IPS_KERNEL_PATH 'classGraph.php' );/*noLibHook*/
        
        /* Graph Ooptions */
        
$graph = new classGraphfalse );
        
$graph->options['title']            = $title;
        
$graph->options['width']            = 800;
        
$graph->options['height']            = 480;
        
$graph->options['style3D']            = 0;
        
$graph->options['charttype']        = 'Line';
        
$graph->options['font']                = IPS_PUBLIC_PATH 'style_captcha/captcha_fonts/DejaVuSans.ttf';

        
/* Build Graph */
        
$graph->addLabels$labels );
        
$graph->addSeries$this->lang->words['statisnotspam'], array_values$notSpamData ) );
        
$graph->addSeries$this->lang->words['statisspam'], array_values$isSpamData ) );

        
$graph->display();

        exit();
    }
    
    
/**
     * Display spam service stats
     *
     * @return    @e void
     */
    
public function spamServiceResultScreen()
    {
        
/* Check the to fields */
        
if ( ! checkdate$this->request['to_month'], $this->request['to_day'], $this->request['to_year'] ) )
        {
            
$this->registry->output->showError$this->lang->words['stats_toincorrect'], 11352 );
        }
        
        
/* Check the from fields */
        
if ( ! checkdate$this->request['from_month'] ,$this->request['from_day'] ,$this->request['from_year'] ) )
        {
            
$this->registry->output->showError$this->lang->words['stats_fromincorrect'], 11353 );
        }
        
        
/* Create time stamps */
        
$to_time   mktime(12 ,,,$this->request['to_month']   ,$this->request['to_day']   ,$this->request['to_year']  );
        
$from_time mktime(12 ,,,$this->request['from_month'] ,$this->request['from_day'] ,$this->request['from_year']);
        
        
/* Get Human Dates */
        
$human_to_date   getdate$to_time );
        
$human_from_date getdate$from_time );
        
        
/* Setup Timescale */
          
switch( $this->request['timescale'] )
          {
              case 
'daily':
                  
$php_date "F jS - Y";
                  break;
                  
              case 
'monthly':
                  
$php_date "F Y";
                  break;
                  
              default:
                  
$php_date "W [F Y]";
                  break;
        }
        
        
$order $this->request['sortby'] == 'desc' 'desc' 'asc';
        
        
/* Query Spam Logs */
        
$this->DB->build( array( 
                                
'select'    => 'log_code, log_date'
                                
'from'        => 'spam_service_log'
                                
'where'        => 'log_date > ' $from_time ' AND log_date < ' $to_time,
                                
'order'        => 'log_date ' $order
                        
)    );
        
$this->DB->execute();
        
        
$results    = array();
        
$total        0;
        
        while( 
$r $this->DB->fetch() )
        {
            
/* Skip errors */
            
if( $r['log_code'] == )
            {
                continue;
            }
            
            
/* Key */
            
if( $r['log_code'] == )
            {
                
$arrayKey 'notspam';
            }
            else if( 
in_array$r['log_code'], array( 23) ) )
            {
                
$arrayKey 'spam';
            }

            
$resultsdate$php_date$r['log_date'] ) ][ $arrayKey ]++;
            
$total++;
        }
        
        
/* Figure out max result */
        
$max_result 0;
        
        foreach( 
$results as $k => $v )
        {
            
$_max = ( $v['spam'] > $v['notspam'] ) ? $v['spam'] : $v['notspam'];

            if( 
$_max $max_result )
            {
                
$max_result $_max;
            }
        }

        
/* Build the output rows */
        
$rows = array();
            
        foreach( 
$results as $dateVal => $stats )
        {
            
/* INIT */
            
$newStats = array();
            
            
/* Width of the bars */
            
$newStats['spam']['_width']        = intval( ( $stats['spam'] / $max_result ) * 100 );
            
$newStats['notspam']['_width']    = intval( ( $stats['notspam'] / $max_result ) * 100 );
            
            
$newStats['spam']['_width']     = $newStats['spam']['_width'] < $newStats['spam']['_width'];
            
$newStats['notspam']['_width']     = $newStats['notspam']['_width'] < $newStats['notspam']['_width'];
            
            
            
/* Save Count */
            
$newStats['spam']['count']        = $stats['spam'] ? $stats['spam'] : 0;
            
$newStats['notspam']['count']    = $stats['notspam'] ? $stats['notspam'] : 0;
            
            
$rows[$dateVal] = $newStats;
        }

        
/* Table Title */
        
$title $this->lang->words'timescale_' $this->request['timescale'] ] .{$this->lang->words['stats_spam']} ({$human_from_date['mday']} {$this->month_names[$human_from_date['mon']]} {$human_from_date['year']} {$this->lang->words['stats_to']} {$human_to_date['mday']} {$this->month_names[$human_to_date['mon']]} {$human_to_date['year']})";
        
        
/* Navigation */
        
$this->registry->output->extra_nav[]     = array( ''$this->lang->words['stats_spam'] );
        return 
$this->registry->output->html .= $this->html->spamServiceStats$title$rows$total );
    }
    
    
/**
     * Display statistics for the selected mode
     *
     * @param    string    Type of stat screen reg, topic, post, msg     
     * @return    @e void
     */
    
public function result_screen($mode='reg')
    {
        
/* Check the to fields */
        
if ( ! checkdate$this->request['to_month'], $this->request['to_day'], $this->request['to_year'] ) )
        {
            
$this->registry->output->showError$this->lang->words['stats_toincorrect'], 11352 );
        }
        
        
/* Check the from fields */
        
if ( ! checkdate$this->request['from_month'] ,$this->request['from_day'] ,$this->request['from_year'] ) )
        {
            
$this->registry->output->showError$this->lang->words['stats_fromincorrect'], 11353 );
        }
        
        
/* Create time stamps */
        
$to_time   mktime(12 ,,,$this->request['to_month']   ,$this->request['to_day']   ,$this->request['to_year']  );
        
$from_time mktime(12 ,,,$this->request['from_month'] ,$this->request['from_day'] ,$this->request['from_year']);
        
        
/* Get Human Dates */
        
$human_to_date   getdate$to_time );
        
$human_from_date getdate$from_time );
        
        
/* Setup based on mode */
        
switch( $mode )
        {
            case 
'reg':
                
$table     $this->lang->words['stats_reg'];
                
                
$sql_table 'members';
                
$sql_field 'joined';
                
                
$this->registry->output->extra_nav[] = array( $this->settings['base_url'] . 'module=statistics&amp;section=stats&amp;do=reg'$table );
                
$this->registry->output->extra_nav[] = array( ''$this->lang->words['stats_reg_nav'] );            
            break;
            
            case 
'topic':
                
$table     $this->lang->words['stats_topic'];
                
                
$sql_table 'topics';
                
$sql_field 'start_date';
                
                
$this->registry->output->extra_nav[] = array( $this->settings['base_url'] . 'module=statistics&amp;section=stats&amp;do=topic'$table );
                
$this->registry->output->extra_nav[] = array( ''$this->lang->words['stats_topic_nav'] );            
            break;
            
            case 
'post':
                
$table     $this->lang->words['stats_post'];
                
                
$sql_table 'posts';
                
$sql_field 'post_date';
                
                
$this->registry->output->extra_nav[] = array( $this->settings['base_url'] . 'module=statistics&amp;section=stats&amp;do=post'$table );
                
$this->registry->output->extra_nav[] = array( ''$this->lang->words['stats_post_nav'] );            
            break;
            
            case 
'msg':
                
$table     $this->lang->words['stats_msg'];
                
                
$sql_table 'message_topics';
                
$sql_field 'mt_date';
                
                
$this->registry->output->extra_nav[] = array( $this->settings['base_url'] . 'module=statistics&amp;section=stats&amp;do=msg'$table );
                
$this->registry->output->extra_nav[] = array( ''$this->lang->words['stats_msg_nav'] );            
            break;
        }

        
/* Setup Timescale */
          
switch( $this->request['timescale'] )
          {
              case 
'daily':
                  
$sql_date "%j %Y";
                  
$php_date "%B %e - %Y";
                  break;
                  
              case 
'monthly':
                  
$sql_date "%m %Y";
                  
$php_date "%B %Y";
                  break;
                  
              default:
                  
// weekly
                  
$sql_date "%U %Y";
                  
$php_date "%U [%B %Y]";
                  break;
        }

        
/* @link http://php.net/strftime */
        
if ( strtouppersubstrPHP_OS0) ) == 'WIN' )
        {
            
$php_date    preg_replace'#(?<!%)((?:%%)*)%e#''1%#d'$php_date );
        }
        
        
/* Table Title */
        
$title       $this->lang->words'timescale_' $this->request['timescale'] ] .{$table} ({$human_from_date['mday']} {$this->month_names[$human_from_date['mon']]} {$human_from_date['year']} {$this->lang->words['stats_to']} {$human_to_date['mday']} {$this->month_names[$human_to_date['mon']]} {$human_to_date['year']})";
        
        
/* Query the stats */
        
$this->DB->build( array(
                                        
'select' => "MAX( {$sql_field} ) as result_maxdate, COUNT(*) as result_count, {$this->DB->buildDateFormat$this->DB->buildFromUnixtime$sql_field ), $sql_date )} as result_time",
                                        
'from'     => $sql_table,
                                        
'where'     => $sql_field ' > ' $from_time ' AND ' $sql_field ' < ' $to_time,
                                        
'group'     => $this->DB->buildDateFormat$this->DB->buildFromUnixtime$sql_field ), $sql_date ),
                                        
//'order'     => $sql_field . ' ' . $this->request['sortby'],
                            
)        );
                            
                        
        
$this->DB->execute();
        
        
/* Loop through the results */
        
$running_total 0;
        
$max_result    0;
        
$results       = array();
    
        while( 
$row $this->DB->fetch() )
        {    
            if( 
$row['result_count'] >  $max_result )
            {
                
$max_result $row['result_count'];
            }
                
            
$running_total += $row['result_count'];
            
            
$results$row['result_maxdate'] ] = array(
                                                         
'result_maxdate'    => $row['result_maxdate'],
                                                        
'result_count'        => $row['result_count'],
                                                        
'result_time'        => $row['result_time'],
                                                        
'formatted_date'    => date$php_date$row['result_maxdate'] ),
                                                    );
                                  
        }
        
        if( 
strtolower($this->request['sortby']) == 'desc' )
        {
            
krsort$results );
        }
        else
        {
            
ksort$results );
        }
        
        
/* Build the output rows */
        
$rows = array();
            
        foreach( 
$results as $data )
        {
            
/* Width of the bar */
            
$data['_width'] = intval( ( $data['result_count'] / $max_result ) * 100 );
                
            if( 
$data['_width'] < )
            {
                
$data['_width'] = 1;
            }
                
            
$data['_width'] .= '%';
            
            
/* Format Date */
            
if( $this->request['timescale'] == 'weekly' )
            {
                
$data['_name'] = $this->lang->words['stats_weekno'] . strftime$php_date$data['result_maxdate'] );
            }
            else
            {
                
$data['_name'] = strftime$php_date$data['result_maxdate'] );
            }
            
            
$rows[] = $data;
        }
        
        
/* Output */
        
$this->registry->output->html    .= $this->html->statResultsScreen$title$rows$running_total );
    }    
    
    
/**
     * Date Selection Screen
     *
     * @param    string    Type of stat screen reg, topic, post, msg, views
     * @return    @e void
     */
    
public function statsMainScreen$mode='reg' )
    {
        
/* Setup this mode */
        
switch( $mode )
        {
            case 
'spam':
                
$form_code    'show_spam';
                
$table        $this->lang->words['stats_spam'];
            break;
            
            case 
'reg':
                
$form_code 'show_reg';
                
$table     $this->lang->words['stats_reg'];
            break;
            
            case 
'topic':
                
$form_code 'show_topic';
                
$table     $this->lang->words['stats_topic'];
            break;
            
            case 
'post':
                
$form_code 'show_post';
                
$table     $this->lang->words['stats_post'];
            break;
            
            case 
'msg':
                
$form_code 'show_msg';
                
$table     $this->lang->words['stats_msg'];
            break;
            
            case 
'views':
            default:
                
$form_code 'statsShowTopicViews';
                
$table     $this->lang->words['stats_views'];
                
                
$this->registry->output->setMessage$this->lang->words['topic_view_warning'], );
            break;            
        }

        
/* Setup Dates */
        
$old_date getdatetime() - ( 3600 24 90 ) );
        
$new_date getdatetime() + ( 3600 24 ) );

        
/* Form Elements */
        
$form = array();

        
$form['from_month'] = $this->registry->output->formDropdown"from_month"$this->statsMakeMonth(), $old_date['mon']  );
        
$form['from_day']   = $this->registry->output->formDropdown"from_day"  $this->statsMakeDay()  , $old_date['mday'] );
        
$form['from_year']  = $this->registry->output->formDropdown"from_year" $this->statsMakeYear() , $old_date['year'] );
        
$form['to_month']   = $this->registry->output->formDropdown"to_month"  $this->statsMakeMonth(), $new_date['mon']  );
        
$form['to_day']     = $this->registry->output->formDropdown"to_day"    $this->statsMakeDay()  , $new_date['mday'] );
        
$form['to_year']    = $this->registry->output->formDropdown"to_year"   $this->statsMakeYear() , $new_date['year'] );
        
$form['timescale']  = $this->registry->output->formDropdown"timescale" , array( => array( 'daily'$this->lang->words['stats_daily']), => array( 'weekly'$this->lang->words['stats_weekly'] ), => array( 'monthly'$this->lang->words['stats_monthly'] ) ) );
        
$form['sortby']     = $this->registry->output->formDropdown"sortby"    , array( => array( 'asc'$this->lang->words['stats_asc']), => array( 'desc'$this->lang->words['stats_desc'] ) ), 'desc' );
                                                                                  
        
/* Output */
        
$this->registry->output->html           .= $this->html->statMainScreeen$form_code$table$form );
        
        
/* Navigation */
        
$this->registry->output->extra_nav[]     = array( ''$table );
    }    

    
/**
     * Show topic view stats
     *
     * @return    @e void
     */
    
public function statsShowTopicViews()
    {
        
/* Check the to fields */
        
if ( ! checkdate$this->request['to_month'], $this->request['to_day'], $this->request['to_year'] ) )
        {
            
$this->registry->output->showError$this->lang->words['stats_toincorrect'], 11354 );
        }
        
        
/* Check the from fields */
        
if ( ! checkdate$this->request['from_month'] ,$this->request['from_day'] ,$this->request['from_year'] ) )
        {
            
$this->registry->output->showError$this->lang->words['stats_fromincorrect'], 11355 );
        }
        
        
/* Create time stamps */
        
$to_time   mktime(,,,$this->request['to_month']   ,$this->request['to_day']   ,$this->request['to_year']  );
        
$from_time mktime(,,,$this->request['from_month'] ,$this->request['from_day'] ,$this->request['from_year']);
        
        
/* Get Human Dates */
        
$human_to_date   getdate$to_time );
        
$human_from_date getdate$from_time );
        
        
/* Title */
        
$title "{$this->lang->words['stats_views_nav']} ({$human_from_date['mday']} {$this->month_names[$human_from_date['mon']]} {$human_from_date['year']} {$this->lang->words['stats_to']} {$human_to_date['mday']} {$this->month_names[$human_to_date['mon']]} {$human_to_date['year']})";
        
        
/* Query the topic stats */
        
$this->DB->build( array( 
                                        
'select'    => 'SUM(t.views) as result_count, t.forum_id',
                                        
'from'        => array( 'topics' => 't' ),
                                        
'where'        => "t.start_date > {$from_time} AND t.start_date < {$to_time}",
                                        
'group'        => 't.forum_id',
                                        
'order'        => 'result_count ' $this->request['sortby'],
                                        
'add_join'    => array(
                                                            array( 
                                                                    
'select' => 'f.name as result_name',
                                                                    
'from'     => array( 'forums' => 'f' ),
                                                                    
'where'     => 'f.id=t.forum_id',
                                                                    
'type'     => 'left'
                                                                
)
                                                            )
                            )        );
        
$this->DB->execute();
        
        
/* Loop through the results */
        
$running_total    0;
        
$max_result        1;
        
$results        = array();
        
$running_total    0;
    
        while( 
$row $this->DB->fetch() )
        {    
            if( 
$row['result_count'] >  $max_result )
            {
                
$max_result $row['result_count'];
            }
            
            
$running_total    += $row['result_count'];
                        
            
$results[] = array(
                                 
'result_maxdate'  => $row['result_maxdate'],
                                 
'result_count'    => $row['result_count'],
                                 
'result_time'     => $row['result_time'],
                                 
'result_name'     => $row['result_name'],                                 
                              );
                                  
        }
        
        
/* Build the output rows */
        
$rows = array();
                
        foreach( 
$results as $data )
        {
            
$running_total += $row['result_count'];
        
            
/* Width of the bar */                
            
$data['_width'] = intval( ( $data['result_count'] / $max_result ) * 100 );
                
            if( 
$data['_width'] < )
            {
                
$data['_width'] = 1;
            }
                
            
$data['_width'] .= '%';
            
            
/* Title */
            
$data['_name'] = $data['result_name'];
            
            
$rows[] = $data;
        }
        
        
/* Output */
        
$this->registry->output->extra_nav[]      = array( $this->settings['base_url'] . 'module=statistics&amp;section=stats&amp;do=views'$this->lang->words['stats_views'] );
        
$this->registry->output->extra_nav[]     = array( ''$this->lang->words['stats_views_nav'] );
        
$this->registry->output->html           .= $this->html->statResultsScreen$title$rows$running_total );
    }
    
    
/**
     * Create the drop down options for the year select
     *
     * @return    array
     */
    
public function statsMakeYear()
    {
        
$time_now getdate();
        
        
$return = array();
        
        
$start_year 2002;
        
        
$latest_year intval($time_now['year'])+1;
        
        if (
$latest_year == $start_year)
        {
            
$start_year -= 1;
        }
        
        for ( 
$y $start_year$y <= $latest_year$y++ )
        {
            
$return[] = array( $y$y);
        }
        
        return 
$return;
    }
    
    
/**
     * Create the drop down options for the month select
     *
     * @return    array
     */
    
public function statsMakeMonth()
    {
        
$return = array();
        
        for ( 
$m $m <= 12$m++ )
        {
            
$return[] = array( $m$this->month_names[$m] );
        }
        
        return 
$return;
    }
    
    
/**
     * Create the drop down options for the day select
     *
     * @return    array
     */
    
public function statsMakeDay()
    {
        
$return = array();
        
        for ( 
$d $d <= 31$d++ )
        {
            
$return[] = array( $d$d );
        }
        
        return 
$return;
    }
    
    
        
}
Онлайн: 2
Реклама