Skald не спорю скрипт ядерный, ~240 запросов вроде,
вот кусок, выводит пользователей с низким ратио
PHP код:
// ### TOP 10 Worst Shares ######################################
$sql = "
SELECT * FROM ". TABLE_PREFIX ." user
INNER JOIN (
SELECT sum(downspeed) as downspeed, sum(upspeed) as upspeed, uid FROM ". TABLE_PREFIX ."peers
WHERE `active` = 1
GROUP BY uid
) as p
ON p.uid = user.userid
WHERE downloaded > uploaded
ORDER BY downloaded / uploaded DESC
LIMIT 10
";
$yz = $db->query($sql);
$display7 .="
<center>
<table width=\"100%\" border=\"0\">
<tr>
<td width=\"20%\"align=\"center\" class=\"tcat\">$vbphrase[vbtt_member]</td>
<td width=\"15%\"align=\"center\" class=\"tcat\">$vbphrase[vbtt_uploaded]</td>
<td width=\"15%\" align=\"center\" class=\"tcat\">$vbphrase[vbtt_downloaded]</td>
<td width=\"20%\" align=\"center\" class=\"tcat\">$vbphrase[vbtt_ulspeed]</td>
<td width=\"20%\" align=\"center\" class=\"tcat\">$vbphrase[vbtt_dlspeed]</td>
<td width=\"10%\" align=\"center\" class=\"tcat\">$vbphrase[vbtt_ratio]</td>
</tr>";
$i=0;
while ($subrow1 = $db->fetch_array($yz)) {
$i++;
$subrow1["filename"] = str_replace('.torrent','',$subrow1["filename"]);
$temp = substr($subrow1["filename"],0,55);
if ($temp!=$subrow1["filename"]) $temp.='...';
$subrow1["filename"] = $temp;
if ($subrow1["seeders"]=='0') $subrow1["seeders"] ='<font color=red>'.$subrow1["seeders"].'</font>';
else $subrow1["seeders"] ='<font color=green>'.$subrow1["seeders"].'</font>';
$ulspeedtot = $subrow1['upspeed'];
$dlspeedtot = $subrow1['downspeed'];
if ($ulspeedtot =="0")
$ulspeed = "<font color=red>".mksize($ulspeedtot )."/s"."</font>";
else $ulspeed = "<font color=green>".mksize($ulspeedtot )."/s"."</font>";
if ($dlspeedtot =="0")
$dlspeed = "<font color=red>".mksize($dlspeedtot )."/s"."</font>";
else $dlspeed = "<font color=#4169E1>".mksize($dlspeedtot )."/s"."</font>";
$rat = @($subrow1["uploaded"] / $subrow1["downloaded"]);
$rat1 = number_format($rat, 2);
if ($subrow1["leechers"]=='0') $subrow1["leechers"] ='<font color=red>'.$subrow1["leechers"].'</font>';
else $subrow1["leechers"] ='<font color=#4169E1>'.$subrow1["leechers"].'</font>';
if ($i % 2 == 0 )
{
$display7.="<tr>
<!-- <td width=\"20%\" align=\"center\" class=\"alt1\">".$subrow1["username"]."</td> -->
<td width=\"15%\" align=\"center\" class=\"alt1\"><a href=\"member.php?u=".$subrow1["userid"]."\">".$subrow1["username"]."</a></td>
<td width=\"15%\" align=\"center\" class=\"alt1\">".mksize($subrow1["uploaded"])."</td>
<td width=\"15%\" align=\"center\" class=\"alt1\">". mksize($subrow1["downloaded"]) ."</td>
<td width=\"20%\" align=\"center\" class=\"alt1\">".$ulspeed."</td>
<td width=\"20%\" align=\"center\" class=\"alt1\">".$dlspeed."</td>
<td width=\"10%\" align=\"center\" class=\"alt1\">".$rat1."</td>
</tr>";
}
else
{
$display7.="<tr>
<!-- <td width=\"20%\" align=\"center\" class=\"alt1\">".$subrow1["username"]."</td> -->
<td width=\"15%\" align=\"center\" class=\"alt1\"><a href=\"member.php?u=".$subrow1["userid"]."\">".$subrow1["username"]."</a></td>
<td width=\"15%\" align=\"center\" class=\"alt1\">".mksize($subrow1["uploaded"])."</td>
<td width=\"15%\" align=\"center\" class=\"alt1\">". mksize($subrow1["downloaded"]) ."</td>
<td width=\"20%\" align=\"center\" class=\"alt1\">".$ulspeed."</td>
<td width=\"20%\" align=\"center\" class=\"alt1\">".$dlspeed."</td>
<td width=\"10%\" align=\"center\" class=\"alt1\">".$rat1."</td>
</tr>";
}
}
$display7.="</table>";