Top Posters during XXXX

I did something like this only I calculate based on the past 24 hours.

PHP Code:

$numberHighPostPerPage = 10; //set for this paste of teh script
$curTime = localtime();
$uts = time() - ($curTime[2]*3600 + $curTime[1]*60 + $curTime[0]);
$lts = $uts - (86401);    // 3600 * 24 + 1 (to be completely honest about "yesterday")
unset($curTime);

$users = $DB_site->query("
         SELECT post.userid, user.username, COUNT(post.userid) AS count
                FROM post
                LEFT JOIN user ON post.userid=user.userid
                WHERE dateline >= $lts AND dateline <= $uts
                GROUP BY post.userid
                ORDER BY count DESC
                LIMIT $numberHighPostPerPage"
         );

while ($user = $DB_site->fetch_array( $users ) )
{
       eval( "\$highpostbits .= \"".gettemplate("highpostbit")."\";");
       $numhp++;
}
for ( ; $numhp < $numberHighPostPerPage; $numhp++ )
{
        $user[userid] = "-1"; $user[username] = "Unclaimed"; $user[count] = "0";
        eval( "\$highpostbits .= \"".gettemplate("highpostbit")."\";");
}
eval( "\$highpost = \"".gettemplate("highpost")."\";"); 


Change the line:
$lts = $uts - (86401);

to:
$its = $uts - (604800);


Then add the templats: highpost, and highpostbit. In the highpost bit you can use $user[userid] $user[username] and $user[count].

What this will also do, if there are less then $numberHighPostPerPage top posters it will fill the remaining slots with "Unclaimed".


This is a part of the site integration script I am writing for my site.