Part of a hack I whipped up a few weeks ago...
Code:
<?
require("global.php");
print "Today's Most Active Posters:\n<ol>\n";
$posters = $DB_site->query("SELECT user.username, COUNT(post.postid) AS cnt FROM user, post WHERE post.userid = user.userid AND post.dateline > '".(time()-3600*24)."' GROUP BY user.userid ORDER BY cnt DESC LIMIT 10");
while ($poster = $DB_site->fetch_array($posters)) {
print "<li>$poster[0] w/$poster[1] posts</li>\n";
}
print "</ol>\n";
?>
Enjoy!