cheaterbox.php

<?php
require "include/bittorrent.php";
dbconn();
require_once(get_langfile_path());
loggedinorreturn();
parked();
global $staffmem_class;

if (get_user_class() < $staffmem_class)
    permissiondenied();


if ($_POST['setdealt']) {
    $res = sql_query("SELECT id FROM cheaters WHERE dealtwith=0 AND id IN (" . implode(", ", $_POST['delcheater']) . ")");
    while ($arr = mysql_fetch_assoc($res))
        sql_query("UPDATE cheaters SET dealtwith=1, dealtby = $CURUSER[id] WHERE id = $arr[id]") or sqlerr();
    $Cache->delete_value('staff_new_cheater_count');
} elseif ($_POST['delete']) {
    $res = sql_query("SELECT id FROM cheaters WHERE id IN (" . implode(", ", $_POST['delcheater']) . ")");
    while ($arr = mysql_fetch_assoc($res))
        sql_query("DELETE from cheaters WHERE id = $arr[id]") or sqlerr();
    $Cache->delete_value('staff_new_cheater_count');
}

$count = get_row_count("cheaters");
if (!$count) {
    stderr($lang_cheaterbox['std_oho'], $lang_cheaterbox['std_no_suspect_detected']);
}
$perpage = 10;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, "cheaterbox.php?");
stdhead($lang_cheaterbox['head_cheaterbox']);
?>
<style type="text/css">
    table.cheaterbox td {
        text-align: center;
    }
</style>
<?php
begin_main_frame();
print("<h1 align=center>" . $lang_cheaterbox['text_cheaterbox'] . "</h1>");
print("<table class=cheaterbox border=1 cellspacing=0 cellpadding=5 align=center>\n");
print("<tr><td class=colhead><nobr>" . $lang_cheaterbox['col_added'] . "</nobr></td><td class=colhead>" . $lang_cheaterbox['col_suspect'] . "</td><td class=colhead><nobr>" . $lang_cheaterbox['col_hit'] . "</nobr></td><td class=colhead>" . $lang_cheaterbox['col_torrent'] . "</td><td class=colhead>" . $lang_cheaterbox['col_ul'] . "</td><td class=colhead>" . $lang_cheaterbox['col_dl'] . "</td><td class=colhead><nobr>" . $lang_cheaterbox['col_ann_time'] . "</nobr></td><td class=colhead><nobr>" . $lang_cheaterbox['col_seeders'] . "</nobr></td><td class=colhead><nobr>" . $lang_cheaterbox['col_leechers'] . "</nobr></td><td class=colhead>" . $lang_cheaterbox['col_comment'] . "</td><td class=colhead><nobr>" . $lang_cheaterbox['col_dealt_with'] . "</nobr></td><td class=colhead><nobr>" . $lang_cheaterbox['col_action'] . "</nobr></td></tr>");

print("<form method=post action=cheaterbox.php>");
$cheatersres = sql_query("SELECT * FROM cheaters ORDER BY dealtwith ASC, id DESC $limit");

while ($row = mysql_fetch_array($cheatersres)) {
    $upspeed = ($row['uploaded'] > 0 ? $row['uploaded'] / $row['anctime'] : 0);
    $lespeed = ($row['downloaded'] > 0 ? $row['downloaded'] / $row['anctime'] : 0);
    $torrentres = sql_query("SELECT name FROM torrents WHERE id=" . sqlesc($row['torrentid']));
    $torrentrow = mysql_fetch_array($torrentres);
    if ($torrentrow)
        $torrent = "<a href=details.php?id=" . $row['torrentid'] . ">" . htmlspecialchars($torrentrow['name']) . "</a>";
    else $torrent = $lang_cheaterbox['text_torrent_does_not_exist'];
    if ($row['dealtwith'])
        $dealtwith = "<font color=green>" . $lang_cheaterbox['text_yes'] . "</font> - " . get_username($row['dealtby']);
    else
        $dealtwith = "<font color=red>" . $lang_cheaterbox['text_no'] . "</font>";

    print("<tr><td class=rowfollow>" . gettime($row['added']) . "</td><td class=rowfollow>" . get_username($row['userid']) . "</td><td class=rowfollow>" . $row['hit'] . "</td><td class=rowfollow>" . $torrent . "</td><td class=rowfollow>" . mksize($row['uploaded']) . ($upspeed ? " @ " . mksize($upspeed) . "/s" : "") . "</td><td class=rowfollow>" . mksize($row['downloaded']) . ($lespeed ? " @ " . mksize($lespeed) . "/s" : "") . "</td><td class=rowfollow>" . $row['anctime'] . " sec" . "</td><td class=rowfollow>" . $row['seeders'] . "</td><td class=rowfollow>" . $row['leechers'] . "</td><td class=rowfollow>" . htmlspecialchars($row['comment']) . "</td><td class=rowfollow>" . $dealtwith . "</td><td class=rowfollow><input type=\"checkbox\" name=\"delcheater[]\" value=\"" . $row['id'] . "\" /></td></tr>\n");
}
?>
<tr>
    <td class="colhead" colspan="12" style="text-align: right">
        <input type="button" id="checkall" onclick="checkAll()" value="全选">
        <input type="submit" name="setdealt" value="<?php echo $lang_cheaterbox['submit_set_dealt'] ?>"/>
        <input type="submit" name="delete" value="<?php echo $lang_cheaterbox['submit_delete'] ?>"/></td>
</tr>
</form>
<script>
    function checkAll() {
        let delcheaters = document.getElementsByName('delcheater[]');
        for (let i = 0; i < delcheaters.length; i++) {
            delcheaters[i].checked = true;
        }
    }
</script>
<?php
print("</table>");
print($pagerbottom);
end_main_frame();
stdfoot();
?>