query("SELECT u.*, SUM(LENGTH(pt.`text`)) as waste, (SUM(LENGTH(pt.`text`)) / u.posts) AS average FROM `posts` p LEFT JOIN `users` u ON p.user = u.id LEFT JOIN `posts_text` pt on p.id = pt.pid WHERE (u.posts >= 5 OR u.posts < 0) GROUP BY p.user ORDER BY $sort DESC");
print "
$header
$tblstart
$tccellc colspan=7>Biggest posters, by post size
$tccellh width=30>#
$tccellh colspan=2>Username
$tccellh width=200>Registered on
$tccellh width=130>Posts
$tccellh width=130>Size
$tccellh width=130>Average
";
for($i=1; $user = $sql -> fetch($posters); $i++) {
if($i == 1) $max = $user['waste'];
if ($user['waste'] != $oldcnt) $rank = $i;
$oldcnt = $user['waste'];
$namecolor=getnamecolor($user['sex'],$user['powerlevel']);
$col = "";
if ($user['average'] >= 500) $col = "#88ff88";
if ($user['average'] >= 750) $col = "#8888ff";
if ($user['average'] <= 200) $col = "#ffff80";
if ($user['average'] <= 100) $col = "#ff8080";
if ($user['average'] <= 0) $col = "#888888";
$avgc = number_format(abs($user['average']), 1);
if ($col) $avgc = "$avgc";
print "
$tccell1>$rank
$tccell1 width=16>". ($user['minipic'] ? "![](\"".)
" : " ") ."
$tccell2l>". $user['name'] ."
$tccell1>".date($dateformat, $user['regdate'] + $tzoff) ."
$tccell1r>". $user['posts'] ."
$tccell1r>". number_format($user['waste']) ."
$tccell2r>". $avgc ."
";
}
print "
$tblend
$smallfont(Note: this doesn't take into account quotes, joke posts, or other things. It isn't a very good judge of actual post content, just post size.)
$footer";
printtimedif($startingtime);
?>