root/admin/admin_statistics.php

<?php

if( !empty($setmodules) ) {</span>
<span class="code-keyword">        $filename = basename(__FILE__);
        $module['statistic']['statistic'] = $filename;
        return;
}

define('IN_PHPBB', 1);

$root_path = './../';</span>
<span class="code-lang">require($root_path . 'extension.inc');
require('./pagestart.' . $phpEx);

$template->assign_vars(array(</span>
<span class="code-lang">        'S_STATISTICS_ACTION' => append_sid("admin_statistics.$phpEx"),
        'IMG_BAR_LEFT' => $images['bar_left'],
        'IMG_BAR' => $images['bar'],
        'IMG_BAR_RIGHT' => $images['bar_right'] )
);

$mode = request_var('mode', '');
$modes_ary = array(</span>
<span class="code-lang">    'reg' => $lang['reg_statistics'],
    'new' => $lang['news_statistics'],
    'post' => $lang['posts_statistics'],
    'msg' => $lang['pms_statistics'],
    'torr' => $lang['tor_statistics'],
    'bans' => $lang['bans_statistics'],
    'comm' => $lang['comm_statistics'],
    'poll' => $lang['poll_statistics'],
    'rqst' => $lang['req_statistics'],
    'offers' => $lang['off_statistics'],
);

if ( !$mode ) {
    $count = $modes_ary;
    $split_row = 3;

    $s_colspan = 0;
    $row = 0;
    $col = 0;

    foreach ( $modes_ary AS $mode_name => $lang_value ) {
        if (!$col)
        {
            $template->assign_block_vars('row', array());
        }

        $template->assign_block_vars('row.col', array(
            'U_MODE' => append_sid($admin_path . 'admin_statistics.php?code=' . $mode_name),
            'LANG_VALUE' => $lang_value
        ));

        $s_colspan = max($s_colspan, $col + 1);

        if ($col == $split_row)
        {
            $col = 0;
            $row++;
        }
        else
        {
            $col++;
        }
    }

    $template->set_filenames(array(
        'body' => '../admin/admin_statistics_body.html'
    ));
}


function form_dropdown($name, $list=array(), $default_val="") {
    $html = '<select name="' . $name . '">';
    foreach ($list as $k => $v) {
        $selected = "";
        if ( ($default_val != "") and ($v[0] == $default_val) ) {
            $selected = ' selected="selected"';
        }
        $html .= '<option value="' . $v[0] . '"' . $selected . '>' . $v[1] . '</option>';
    }
    $html .= '</select>';
    return $html;
}

//-----------------------------------------</span>
<span class="code-comment">//| Results screen
//-----------------------------------------

function result_screen($mode='reg') {</span>
<span class="code-keyword">
    global $db, $template, $lang, $theme, $images, $userdata;

    $to_month = request_var('to_month', 0);
    $to_day = request_var('to_day', 0);
    $to_year = request_var('to_year', 0);
    $from_month = request_var('from_month', 0);
    $from_day = request_var('from_day', 0);
    $from_year = request_var('from_year', 0);

    if ( ! checkdate($to_month   ,$to_day   ,$to_year) ) {
        trigger_error($lang['from_date'] . $lang['date_invalid']);
    }
        if ( ! checkdate($from_month ,$from_day ,$from_year) ) {
            trigger_error($lang['to_date'] . $lang['date_invalid']);
        }

        //-----------------------------------------

        $to_time   = mktime(12 ,0 ,0 ,$to_month   ,$to_day   ,$to_year  );
        $from_time = mktime(12 ,0 ,0 ,$from_month ,$from_day ,$from_year);

        //-----------------------------------------

        if ($mode == 'reg') {
                $table     = $lang['reg_statistics'];
                $sql_table = USERS_TABLE;
                $sql_field = 'added';
                $page_detail = $lang['reg_statistics_explain'];
        }
        else if ($mode == 'post') {
                $table     = $lang['posts_statistics'];
                $sql_table = POSTS_TABLE;
                $sql_field = 'post_created';
                $page_detail = $lang['posts_statistics_explain'];
        }
        else if ($mode == 'msg') {
                $table     = $lang['pms_statistics'];
                $sql_table = PRIVATE_MESSAGES_TABLE;
                $sql_field = 'added';
                $page_detail = $lang['pms_statistics_explain'];
        }
        else if ($mode == 'torr') {
                $table     = $lang['tor_statistics'];
                $sql_table = TORRENTS_TABLE;
                $sql_field = 'ctime';
                $page_detail = $lang['tor_statistics_explain'];
        }
        else if ($mode == 'bans') {
                $table     = $lang['bans_statistics'];
                $sql_table = BANLIST_TABLE;
                $sql_field = 'ban_added';
                $page_detail = $lang['bans_statistics_explain'];
        }
        else if ($mode == 'comm') {
                $table     = $lang['comm_statistics'];
                $sql_table = COMMENTS_TABLE;
                $sql_field = 'comment_added';
                $page_detail = $lang['comm_statistics_explain'];
        }
        else if ($mode == 'new') {
                $table     = $lang['news_statistics'];
                $sql_table = NEWS_TABLE;
                $sql_field = 'added';
                $page_detail = $lang['news_statistics_explain'];
        }
        else if ($mode == 'poll') {
                $table     = $lang['poll_statistics'];
                $sql_table = VOTE_DESC_TABLE;
                $sql_field = 'vote_start';
                $page_detail = $lang['poll_statistics_explain'];
        }
        else if ($mode == 'rqst') {
                $table     = $lang['req_statistics'];
                $sql_table = REQUESTS_TABLE;
                $sql_field = 'added';
                $page_detail = $lang['req_statistics_explain'];
        }

        else if ($mode == 'offers') {
                $table     = $lang['off_statistics'];
                $sql_table = OFFERS_TABLE;
                $sql_field = 'added';
                $page_detail = $lang['off_statistics_explain'];
        }

        switch ($_POST['timescale']) {
            case 'daily':
                    $sql_date = "%w %U %m %Y";
                        $php_date = "F jS - Y";
                break;

                case 'monthly':
                        $sql_date = "%m %Y";
                        $php_date = "F Y";
                break;

                default:

                        $sql_date = "%U %Y";
                        $php_date = " [F Y]";
                break;
        }

        $sortby = $_POST['sortby'] == 'asc' ? 'ASC' : 'DESC';
        $sql = "SELECT MAX($sql_field) as result_maxdate,
                COUNT(*) as result_count,
                DATE_FORMAT(FROM_UNIXTIME($sql_field),'$sql_date') AS result_time
                FROM $sql_table
                WHERE $sql_field > $from_time
                AND $sql_field < $to_time
                GROUP BY result_time
                ORDER BY $sql_field $sortby";
        $result = $db->sql_query($sql);

        $running_total = 0;
        $max_result    = 0;
        $results       = array();

        $template->assign_vars(array(
                'TABLE_NAME'=> $table,
                'PAGE_DETAILS' => $page_detail,
                'TIMESCALE' =>  ($_POST['timescale'] == 'daily' ? $lang['daily'] : ( $_POST['timescale'] == 'weekly' ? $lang['weekly'] : $lang['monthly'] ) ),
                'DATE_FROM' => create_date($from_time, 'Y M d'),
                'DATE_TO' => create_date($to_time, 'Y M d') )
        );

        if ( $row = $db->sql_fetchrow($result) ) {
            $total = 0;
            do {
                ++$total;
                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']
                );
            }
            while ($row = $db->sql_fetchrow($result) );
            $srednee = number_format ($running_total / $total ,0);
            $template->assign_vars(array(
                    'SREDNEE'=> $srednee,
                    'RUNNING_TOTAL' =>  $running_total)
            );
                $i = 0;
            foreach( $results as $pOOp => $data ) {
                ++$i;

                $img_width = intval( ($data['result_count'] / $max_result) * 100 - 20);
                if ($img_width < 1) {
                    $img_width = 1;
                }
                $img_width .= '%';
                if ($_POST['timescale'] == 'weekly') {
                    $date = $lang['week'] . ' #' . strftime("%W", $data['result_maxdate']) . ' ' . create_date($data['result_maxdate'], $php_date);
                }
                else {
                    $date = create_date($data['result_maxdate'], $php_date);
                }

                $template->assign_block_vars('results_row', array(
                        'DATE' => $date,
                        'IMG_WIDTH' => $img_width,
                        'RESULT_COUNT' => $data['result_count'],
                        'TD_CLASS' => ($i % 2 ? $theme['td_class1'] : $theme['td_class2'] ) )
                );
            }

        $template->set_filenames(array(
            'body' => '../admin/admin_statistics_results_body.html'
        ));
        }

        else {
            trigger_error($lang['no_results']);
        }
}

//-----------------------------------------</span>
<span class="code-comment">//| Date selection screen
//-----------------------------------------

function main_screen($mode='reg') {</span>
<span class="code-keyword">        global $template, $lang;

        $page_title = $lang['statistic_center'];
        $page_detail = $lang['statistic_center_explain'];
        if ($mode == 'reg') {
                $form_code = 'show_reg';
                $table     =  $lang['reg_statistics'];
        }
        else if ($mode == 'post') {
                $form_code = 'show_post';
                $table     = $lang['posts_statistics'];
        }
        else if ($mode == 'msg') {
                $form_code = 'show_msg';
                $table     = $lang['pms_statistics'];
        }
        else if ($mode == 'torr') {
                $form_code = 'show_torr';
                $table     = $lang['tor_statistics'];
        }
        else if ($mode == 'bans') {
                $form_code = 'show_bans';
                $table     = $lang['bans_statistics'];
        }
        else if ($mode == 'comm') {
                $form_code = 'show_comm';
                $table     = $lang['comm_statistics'];
        }
        else if ($mode == 'new') {
                $form_code = 'show_new';
                $table     = $lang['news_statistics'];
        }
        else if ($mode == 'poll') {
                $form_code = 'show_poll';
                $table     = $lang['poll_statistics'];
        }
        else if ($mode == 'rqst') {
                $form_code = 'show_rqst';
                $table     = $lang['req_statistics'];
        }
        else if ($mode == 'offers') {
                $form_code = 'show_offers';
                $table     = $lang['off_statistics'];
        }


        $old_date = getdate(time() - (3600 * 24 * 90));
        $new_date = getdate(time() + (3600 * 24));


        //-----------------------------------------

        $template->assign_vars(array(
        'TABLE_NAME'=> $table,
        'PAGE_TITLE' =>  $page_title,
        'PAGE_DETAILS' => $page_detail,
        'S_FORM_HIDDEN' => $form_code,
        'FROM_YEAR' => form_dropdown( "from_year"  , make_year(),  $old_date['year'] ),
        'FROM_MONTH' => form_dropdown( "from_month" , make_month(),  $old_date['mon'] ),
        'FROM_DAY' => form_dropdown( "from_day"   , make_day(),  $old_date['mday'] ),
        'TO_YEAR' => form_dropdown( "to_year"  , make_year(), $new_date['year'] ),
        'TO_MONTH' => form_dropdown( "to_month" , make_month(), $new_date['mon']  ),
        'TO_DAY' => form_dropdown( "to_day"   , make_day(), $new_date['mday'] ),
        'TIMESCALE' => form_dropdown( "timescale" , array( 0 => array( 'daily', $lang['daily']), 1 => array( 'weekly', $lang['weekly'] ), 2 => array( 'monthly', $lang['monthly'] ) ), 'daily' ),
        'SORT' => form_dropdown( "sortby" , array( 0 => array( 'asc', $lang['old_dates_begin']), 1 => array( 'desc', $lang['new_dates_begin'] ) ), 'desc' ) )
        );

        $template->set_filenames(array(
            'body' => '../admin/admin_statistics_select_body.html'
        ));

}

//-----------------------------------------

function make_year() {</span>
<span class="code-keyword">        $time_now = getdate();
        $return = array();
        $start_year = 2002;
        $latest_year = intval($time_now['year']);
        if ($latest_year == $start_year) {
            $start_year -= 1;
        }
        for ( $y = $start_year; $y <= $latest_year; $y++ ) {
            $return[] = array( $y, $y);
        }
        return $return;
}

//-----------------------------------------

function make_month() {</span>
<span class="code-keyword">    global $lang;

        $month_names = array(
        $lang['datetime']['January'],
        $lang['datetime']['February'],
        $lang['datetime']['March'],
        $lang['datetime']['April'],
        $lang['datetime']['May'],
        $lang['datetime']['June'],
        $lang['datetime']['July'],
        $lang['datetime']['August'],
        $lang['datetime']['September'],
        $lang['datetime']['October'],
        $lang['datetime']['November'],
        $lang['datetime']['December']
        );
        reset($month_names);
        $return = array();

        for ( $m = 1 ; $m <= 12; $m++ ) {
            $return[] = array( $m, $month_names[$m-1] );
        }
        return $return;
}

//-----------------------------------------

function make_day() {</span>
<span class="code-keyword">    $return = array();
        for ( $d = 1 ; $d <= 31; $d++ ) {
            $return[] = array( $d, $d );
        }
        return $return;
}






        $tmp_in = array_merge( $_GET, $_POST );
        foreach ( $tmp_in as $k => $v ) {
            unset($$k);
        }

        if(isset($tmp_in['code']) && $tmp_in['code'] != "") {
            switch($tmp_in['code']) {
                        case 'show_reg':
                                result_screen('reg');
                        break;

                        case 'show_rate':
                                result_screen('rate');
                        break;

                        case 'rate':
                                main_screen('rate');
                        break;

                        case 'show_post':
                                result_screen('post');
                        break;

                        case 'post':
                                main_screen('post');
                        break;

                        case 'show_msg':
                                result_screen('msg');
                        break;

                        case 'msg':
                                main_screen('msg');
                        break;

                        case 'show_torr':
                                result_screen('torr');
                        break;

                        case 'torr':
                                main_screen('torr');
                        break;

                        case 'show_bans':
                                result_screen('bans');
                        break;

                        case 'bans':
                                main_screen('bans');
                        break;

                        case 'show_comm':
                                result_screen('comm');
                        break;

                        case 'comm':
                                main_screen('comm');
                        break;

                        case 'show_new':
                                result_screen('new');
                        break;

                        case 'new':
                                main_screen('new');
                        break;

                        case 'show_poll':
                                result_screen('poll');
                        break;

                        case 'poll':
                                main_screen('poll');
                        break;

                        case 'show_rqst':
                                result_screen('rqst');
                        break;

                        case 'rqst':
                                main_screen('rqst');
                        break;

                        case 'show_offers':
                                result_screen('offers');
                        break;

                        case 'offers':
                                main_screen('offers');
                        break;

                        default:
                                main_screen('reg');
                        break;
        }
}


$template->display('body');</span>
<span class="code-lang">include('./page_footer_admin.'.$phpEx);
?>