Top XX Posters this week... (anyone?)

[Cloughie]

yahoooo!

Firefly whiped up some code for this one..

<?php

error_reporting(7);

require("./global.php");

// how many users would like to display?
$usernum="10";

// path to your vBulletin? (no trailing slash please)
$pathtovb="http://www.wannabebigforums.com";

// timeframe? (in days)
$days="7";

$userlist="";

$datecut=time()-($days*24*60*60);
$allusers=$DB_site->query("SELECT userid,username,COUNT(postid) AS count FROM post WHERE dateline>='$datecut' AND userid<>'0' GROUP BY userid ORDER BY count DESC LIMIT $usernum");
while ($user=$DB_site->fetch_array($allusers)) {
  $userlist.="<tr>\n	<td align=\"center\" bgcolor=\"#ffffff\" style=\"color: #000000; font-family: Verdana,Helvetica,sans-serif; font-size: 8pt\"><a href=\"/member.php?&action=getinfo&userid=$user[userid]\" style=\"color: #336699\">$user[username]</a></td>\n	<td align=\"center\" bgcolor=\"#ffffff\" style=\"color: #000000; font-family: Verdana,Helvetica,sans-serif; font-size: 8pt\">$user[count]</td>\n</tr>\n";
}

echo "<table>";
echo "$userlist";
echo "</table>";

?>

Thanks Firefly!!!!!!!!