10th July 2013, 14:59
|
Senior Member
|
|
Join Date: Oct 2012
Posts: 39
|
|
Quote:
Originally Posted by TrinitY-RG
Go to staff tools and the tool
Maybe Cheaters
Those users maybe are cheaters
Call it maybecheaters Add to dir root
Code:
<?
ob_start("ob_gzhandler");
require "include/bittorrent.php";
dbconn(false);
loggedinorreturn();
if (get_user_class() < UC_MODERATOR)
stderr("Sorry", "Access denied.");
function usertable($res, $frame_caption)
{
global $CURUSER;
begin_frame($frame_caption, true);
begin_table();
?>
<p>A list of users with a ratio above 100. (VIP class and under)<br>
Sorted by join date (oldest first).</p>
<tr>
<td class=colhead align=left>User</td>
<td class=colhead>Uploaded</td>
<td class=colhead>Downloaded</td>
<td class=colhead align=right>Ratio</td>
<td class=colhead align=left>Joined</td>
</tr>
<?
$num = 0;
while ($a = mysql_fetch_assoc($res))
{
++$num;
$highlight = $CURUSER["id"] == $a["userid"] ? " bgcolor=#BBAF9B" : "";
if ($a["downloaded"])
{
$ratio = $a["uploaded"] / $a["downloaded"];
$color = get_ratio_color($ratio);
$ratio = number_format($ratio, 2);
if ($color)
$ratio = "<font color=$color>$ratio</font>";
}
else
$ratio = "Inf.";
print("<tr$highlight><td align=left$highlight><a href=userdetails.php?id=" .
$a["userid"] . "><b>" . $a["username"] . "</b>" .
"</td><td align=right$highlight>" . mksize($a["uploaded"]) .
"</td><td align=right$highlight>" . mksize($a["downloaded"]) .
"</td><td align=right$highlight>" . $ratio .
"</td><td align=left>" . gmdate("Y-m-d",strtotime($a["added"])) . " (" .
get_elapsed_time(sql_timestamp_to_unix_timestamp($a["added"])) . " ago)</td></tr>");
}
end_table();
end_frame();
}
stdhead("Ratio is 100 of above");
$mainquery = "SELECT id as userid, username, added, uploaded, downloaded, uploaded / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(added)) AS upspeed, downloaded / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(added)) AS downspeed FROM users WHERE enabled = 'yes'";
$limit = 250;
$order = "added ASC";
//$order = "uploaded / downloaded ASC, downloaded DESC";
$extrawhere = " AND uploaded / downloaded > 100 and class <= 2";
$r = mysql_query($mainquery . $extrawhere . " ORDER BY $order " . " LIMIT $limit") or sqlerr();
usertable($r, "Ratio Above 100");
stdfoot();
?>
|
Ok, it's ingenious.
But there is no way else to know if someone is cheating? just this way?
|