root/admin/admin_upload_statistics.php

<?php

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

define('IN_PHPBB', 1);

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

$template->set_filenames(array(</span>
<span class="code-lang">        'body' => '../admin/admin_upload_statistics.tpl')
);

$uporder = request_var('uporder', '');
$catorder = request_var('catorder', '');</span>
<span class="code-lang">
switch($uporder) {
    case 'name':
            $orderby = 'u.name ASC';
    break;
    case 'ratio':
            $orderby = 'u.uploaded/u.downloaded DESC';
    break;
    case 'torrents':
            $orderby = 'num_torrents DESC';
    break;
    case 'peers':
            $orderby = 'num_peers DESC';
    break;
    case 'last_up':
            $orderby = 'torrent_added DESC';
    break;
    default:
            $orderby = 'u.uid';
    break;
}


$sql = 'SELECT u.uid, u.name AS username, u.added, u.uploaded, u.downloaded, u.donor, u.warneduntil, u.parked, u.class, u.enabled, MAX(t.ctime) AS torrent_added, COUNT(t.fid) AS num_torrents, SUM(t.leechers + t.seeders) AS num_peers</span>
<span class="code-lang">        FROM ' . USERS_TABLE . ' u LEFT JOIN ' . TORRENTS_TABLE . ' t ON u.uid = t.owner
        WHERE class >= ' . UC_UPLOADER . '
        GROUP BY u.uid ORDER BY ' . $orderby;
$result = $db->sql_query($sql);

$template->assign_vars(array(</span>
<span class="code-lang">        'U_UP_ST_USERNAME' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;uporder=name'),
        'U_UP_ST_RATIO' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;uporder=ratio'),
        'U_UP_ST_TORRENTS' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;uporder=torrents'),
        'U_UP_ST_PEERS' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;uporder=peers'),
        'U_UP_ST_LASTUP' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;uporder=last_up'),

        'U_CT_ST_CATEGORY' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;catorder=category'),
        'U_CT_ST_LASTUL' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;catorder=lastul'),
        'U_CT_ST_TORRENTS' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;catorder=torrents'),
        'U_CT_ST_PEERS' => append_sid($admin_path . 'admin_upload_statistics.php?act=upstats&amp;catorder=peers'),
));
$counter = 0;</span>
<span class="code-lang">while ($row = $db->sql_fetchrow($result)) {
    $ratio = get_ratio($row["uploaded"], $row["downloaded"]);
    $ratio_color = get_ratio_color($ratio);
    $counter++;

    $template->assign_block_vars('uploaders_row', array(
        'COUNTER' => $counter,
        'TD_COLOR' => ( $counter % 2 ? $theme['td_class1'] : $theme['td_class2'] ),
        'USERNAME' =>  get_user_class_color($row['class'], $row['username']),
        'UPLOADED' => mksize($row['uploaded']),
        'DOWNLOADED' => mksize($row['downloaded']),
        'USER_ICONS' => get_user_icons($row),
        'RATIO' => $ratio,
        'RATIO_COLOR' => $ratio_color,
        'NUM_TORRENTS' => ( $row['num_torrents'] ? $row['num_torrents'] : 0),
        'NUM_PEERS' => ( $row['num_peers'] ? $row['num_peers'] : 0 ),
        'LAST_ADDED' => ( $row['num_torrents'] ? get_elapsed_time($row['torrent_added']) . ' (' . create_date($row['torrent_added']) . ')' : '---' ),

        'U_USERDETAILS' => append_sid($root_path . 'userdetails.php?id=' . $row['uid']),
        'U_PM' => append_sid($root_path . 'message.php?action=send&amp;receiver=' . $row['uid']),
    ));
}

$template->assign_vars(array(</span>
<span class="code-lang">        'NUM' => $counter,
        'L_TOTAL_UPLOADERS' => sprintf($lang['total_uploaders'], $counter) )
);

switch($catorder) {
    case 'lastul':
            $orderby = 'last DESC, c.name';
    break;
    case 'torrents':
            $orderby = 'n_t DESC, c.name';
    break;
    case 'peers':
            $orderby = 'n_p DESC, name';
    break;
    default:
            $orderby = 'c.name';
    break;
}

$sql = 'SELECT c.name, MAX(t.ctime) AS last, COUNT(DISTINCT t.fid) AS n_t, COUNT(p.uid) AS n_p</span>
<span class="code-lang">        FROM ' . CATEGORIES_TABLE . ' c, ' . TORRENTS_TABLE . ' t LEFT JOIN ' . PEERS_TABLE . ' p ON t.fid = p.fid
        WHERE t.category = c.id GROUP BY c.id ORDER BY ' . $orderby;
$result = $db->sql_query($sql);

$cat1 = array();
$num_torrents = $i = $num_peers = 0;</span>
<span class="code-lang">while ($cat = $db->sql_fetchrow($result)) {
    $cat1[] = $cat;
    $num_torrents += $cat['n_t'];
    $num_peers += $cat['n_p'];
}

foreach ($cat1 as $cat) {
    $i++;
    $template->assign_block_vars('cats_row', array(
            'TD_COLOR' => ($i % 2 ? $theme['td_class1'] : $theme['td_class2'] ),
            'CAT_NAME' => $cat['name'],
            'LAST_UP' => ($cat['last'] ? create_date($cat['last']) . ' (' . get_elapsed_time($cat['last']) . ')' : '---'),
            'NUM_TORRENTS' => $cat['n_t'],
            'TORRENTS_PERCENT' => ( $cat['n_t'] ? number_format(100*$cat['n_t']/$num_torrents,1) .'%' : '---') ,
            'NUM_PEERS' => $cat['n_p'],
            'PEERS_PERCENT' => ( $cat['n_p'] ? number_format(100 * $cat['n_p']/$num_peers,1). '%' : '---' ) )
        );

}


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