root/cheaters.php

<?php</span>
<span class="code-lang">$root_path = './';
require ($root_path . 'include/config.php');
require ($root_path . 'languages/lang_' . $config['default_lang'] . '/lang_modcomment_log.php');

$userdata = session_pagestart($user_ip);
init_userprefs($userdata);
loggedinorreturn();</span>
<span class="code-lang">
if ($userdata['class'] < UC_SYSOP) {
        trigger_error($lang['access_denied']);
}

$mode = request_var('mode', '');
$show_banned = request_var('show_banned', 0);</span>
<span class="code-lang">
if ( isset($_POST['id']) ) {
    $ids = request_var('id', array(0=>0));
    $modcomment_ban = "\n" . sprintf($lang['modcomment_account_disabled'], 't' . time(), $userdata['name'], $lang['cheater']);

    meta_refresh(3, append_sid($root_path . 'cheaters.php' . ( $mode == 'stealth_downers' ? '?mode=stealth_downers' : '' ) . ( $show_banned ? '&amp;show_banned=1' : '' )));

    switch ( $mode ) {

        case 'stealth_downers':

            if ( isset($_POST['ban']) ) {

                $sql = 'SELECT name, uid, modcomment, ip FROM ' . USERS_TABLE . ' WHERE uid IN (' . implode(', ', $ids) . ')  AND enabled = 1';
                $result = $db->sql_query($sql);

                while ( $row = $db->sql_fetchrow($result) ) {
                    $modcomment = $row['modcomment'] . $modcomment_ban;

                    $sql = 'UPDATE ' . USERS_TABLE . ' SET enabled = 0, warneduntil = 0, modcomment = \'' . $db->sql_escape($modcomment) . '\' WHERE uid  = ' . $row['uid'];
                       $db->sql_query($sql);

                       session_reset_keys($row['uid'], $row['ip']);

                    write_log(sprintf($lang['log_account_disable'], 'userdetails_' . $row['uid'], $row['name'], $userdata['name'], $lang['cheater']), LOG_VIEW_ADMIN);
                    }
                trigger_error($lang['success_banned']);
                }
        break;

        default:
            if ( isset($_POST['ban']) ) {
                $sql = 'SELECT u.name, u.uid AS user_id, modcomment, ip FROM ' . USERS_TABLE . ' u, ' . CHEATERS_TABLE . ' c
                        WHERE u.uid = c.userid AND u.uid IN (' . implode(', ', $ids) . ') AND enabled = 1 GROUP BY u.uid';
                    $result = $db->sql_query($sql);

                  while ( $row = $db->sql_fetchrow($result) ) {
                      $modcomment = $row['modcomment'] . $modcomment_ban;

                      $sql = 'UPDATE ' . USERS_TABLE . ' SET enabled = 0, warneduntil = 0, modcomment = \'' . $db->sql_escape($modcomment) . '\' WHERE uid  = ' . $row['user_id'];
                       $db->sql_query($sql);

                    session_reset_keys($row['user_id'], $row['ip']);

                    write_log(sprintf($lang['log_account_disable'], 'userdetails_' . $row['user_id'], $row['name'], $userdata['name'], $lang['cheater']), LOG_VIEW_ADMIN);
                    }
                trigger_error($lang['success_banned']);
                }

            if ( isset($_POST['delete']) ) {
                $sql = 'DELETE FROM ' . CHEATERS_TABLE . ' WHERE userid IN (' . implode(', ', $ids) . ')';
                    $db->sql_query($sql);

                     trigger_error ($lang['success_delete']);
            }

        break;

    }
}
else {

    switch ( $mode ) {

        case 'stealth_downers';

            $template->assign_vars(array(
                     'S_FORM_ACTION' => append_sid('cheaters.php'. ( $show_banned ? '?show_banned=1' : '' )),
                     'U_SHOW_BANNED' => append_sid('cheaters.php?mode=stealth_downers' . ( !$show_banned ? '&amp;show_banned=1' : '' ) ),
                      'L_SHOW_ENABLED' => ( $show_banned ? $lang['hide_disabled'] : $lang['show_disabled'] )
            ));

            $sql = 'SELECT COUNT(s.torrentid) AS utc, u.uid, u.name, u.class, u.downloaded, u.uploaded, u.enabled, u.parked, u.warneduntil, u.donor, u.added AS reg_date, t.fid
                FROM ' . USERS_TABLE . ' u, ' . SNATCHED_TABLE . ' s, ' . TORRENTS_TABLE . ' t
                WHERE u.uid = s.userid AND s.torrentid = t.fid AND s.completedat = 0 AND t.owner != s.userid' . ( !$show_banned ? ' AND u.enabled = 1' : '' ) . ' AND s.uploaded = 0 AND t.ctime < ' . ( time() - 7 * 24 * 60 * 60 ) . '
                GROUP BY u.uid
                HAVING COUNT(s.torrentid) > 20
                ORDER BY utc DESC';

            $result = $db->sql_query($sql);
            $i = 0;
               $page = request_var('page', 0);

            while ( $row = $db->sql_fetchrow($result) ) {
                ++$i;

                $template->assign_block_vars('cheaters_row', array(
                    'NUM' => $i + ( $page * 100 ),
                    'U_USERDETAILS' => append_sid('userdetails.php?id=' . $row['uid']),
                    'USER_ID' => $row['uid'],
                    'USERNAME' => get_user_class_color($row['class'], $row['name']),
                    'USER_ICONS' => get_user_icons($row),
                    'UNCOMPLETED_TORRENTS_COUNT' => $row['utc'],
                    'REG_DATE' => create_date($row['reg_date'])
                ));
            }

            stdhead($lang['cheaters']);
            $template->set_filenames(array(
                'body' => 'cheaters_stealth_downers.html')
            );
            stdfoot();
        break;

        case 'show_data':

            require ($root_path . 'include/ajax.php');
            $JsHttpRequest = new JsHttpRequest();
            $db->sql_return_on_error(true);

            $uid = request_var('user_id', 0);

            if ( !$uid ) {
                return $_RESULT = array( 'data' => $bad_data );
            }

            else {
                $sql = 'SELECT t.name, s.uploaded, s.downloaded, s.last_action, t.size, p.uid
                    FROM ' . SNATCHED_TABLE . ' s LEFT JOIN ' . PEERS_TABLE . ' p ON ( s.torrentid = p.fid AND s.userid = p.uid ), ' . TORRENTS_TABLE . ' t
                    WHERE s.torrentid = t.fid AND s.completedat = 0 AND t.owner != s.userid AND s.userid = ' . $uid . '
                    ORDER BY s.last_action DESC';
                if ( !($result = $db->sql_query($sql)) ) {
                    $error = $db->sql_error($result);
                    return $_RESULT = array( 'data' => $error['message'] );
                }
                else {
                    $data = '';
                    $format_string = '<span style="color:green" title="' . $lang['active'] . '">%s</span>';
                    while ( $row = $db->sql_fetchrow($result) ) {
                        $data .= $lang['torrent'] .  ': ' . ( !empty($row['uid']) ? sprintf($format_string, $row['name']) : $row['name'] ) . '<br />';
                        $data .= $lang['size'] .  ': ' . mksize($row['size']) . '<br />';
                        $data .= $lang['uploaded'] .  ': ' . mksize($row['uploaded']) . '<br />';
                        $data .= $lang['downloaded'] .  ': ' . mksize($row['downloaded']) . '<br />';
                        $data .= $lang['last_action'] .  ': ' . create_date($row['last_action']) . '<br />';
                        $data .= '<hr />';
                    }

                    return $_RESULT = array( 'data' => $data );
                }
            }
        break;

        default:

            $template->assign_vars(array(
                      'S_FORM_ACTION' => append_sid('cheaters.php'),
                     'U_SHOW_BANNED' => append_sid('cheaters.php' . ( !$show_banned ? '?show_banned=1' : '' ) ),
                      'L_SHOW_ENABLED' => ( $show_banned ? $lang['hide_disabled'] : $lang['show_disabled'] )
            ));

            $sql = 'SELECT c.*, u.uid AS user_id, u.name, u.class, u.downloaded, u.uploaded, u.enabled, u.parked, u.warneduntil, u.donor, u.added AS reg_date, t.name AS torrent_name, t.fid AS torrent_id, t.size
                    FROM ' . CHEATERS_TABLE . ' c, ' . USERS_TABLE . ' u, ' . TORRENTS_TABLE . ' t
                    WHERE c.userid = u.uid AND c.torrentid = t.fid' . ( !$show_banned ? ' AND u.enabled = 1' : '' ) . '
                         ORDER BY added DESC    ';
            $result = $db->sql_query($sql);

            $page = request_var('page', 0);

            $i = 0;

            $users_ary = array();
            $i = 0;

            while ( $row = $db->sql_fetchrow($result) ) {

                $ratio = get_ratio($row['uploaded'], $row['downloaded']);
                $ratio_color = get_ratio_color($ratio);
                $uppd = mksize($row['upthis']);

                $username = get_user_class_color($row['class'], $row['name']);
                $reg_date = create_date($row['reg_date']);
                $user_icons = get_user_icons($row);

                $ary_key = $username . '|' . $row['user_id'] . '|' . $row['userip'] . '|' . $reg_date . '|' . $user_icons;

                $users_ary[$ary_key][$row['torrent_id'] . '|' . $row['torrent_name']][] = array(
                    'USERNAME' => get_user_class_color($row['class'], $row['name']),
                    'UPLOADED' => $uppd,
                    'SPEED' => mksize($row['rate']) . '/' . $lang['secs_short'],
                    'WITHIN' => $row['timediff'] . $lang['secs_short'],
                    'CLIENT' => getagent($row['che_useragent'], $row['che_peer_id']),
                    'IP' => $row['userip'],
                    'ID' => $row['id'],
                    'ADDED' => create_date($row['added']),
                    'TORRENT_ID' => $row['torrent_id'],
                    'TORRENT_SIZE' => mksize($row['size'])
                );
            }

            @ksort($users_ary);

            foreach ( $users_ary AS $user_id => $ary ) {

                ++$i;

                list($username, $user_id, $user_ip, $reg_date, $user_icons) = explode('|', $user_id);

                $template->assign_block_vars('cheat_users_row', array(
                    'USER_ID' => $user_id,
                    'USERNAME' => $username,
                    'USER_IP' => $user_ip,
                    'U_USERDETAILS' => append_sid('userdetails.php?id=' . $user_id),
                    'REG_DATE' => $reg_date,
                    'USER_ICONS' => $user_icons,
                    'NUMBER' => $i
                ));

                foreach ( $ary AS $torrent_id => $sub_ary ) {

                    list($torrent_id, $torrent_name) = explode('|', $torrent_id);

                    // www.phpBB-SEO.com SEO TOOLKIT BEGIN
                    $seo->set_url(censor_text($torrent_name), $torrent_id, $seo->seo_static['details']);
                    // www.phpBB-SEO.com SEO TOOLKIT END

                    $template->assign_block_vars('cheat_users_row.torrents_row', array(
                        'U_TORRENT' => append_sid($root_path . 'details.php?id=' . $torrent_id),
                        'TORRENT_NAME' => $torrent_name,
                    ));

                    foreach ( $sub_ary AS $_null => $sub_sub_ary ) { //lol

                        $template->assign_block_vars('cheat_users_row.torrents_row.torrents_data', array(
                            'UPLOADED' => $sub_sub_ary['UPLOADED'],
                            'SPEED' => $sub_sub_ary['SPEED'],
                            'WITHIN' => $sub_sub_ary['WITHIN'],
                            'CLIENT' => $sub_sub_ary['CLIENT'],
                            'IP' => $sub_sub_ary['IP'],
                            'ADDED' => $sub_sub_ary['ADDED'],
                            'TORRENT_SIZE' => $sub_sub_ary['TORRENT_SIZE'],
                        ));
                    }
                }
            }

            stdhead($lang['cheaters']);
            $template->set_filenames(array(
                'body' => 'cheaters_body.html')
            );
            stdfoot();
        break;
     }
}
?>