UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Number of posters last x days

/* PHP CODE HERE */
$top10 = $db->query ("
SELECT Count( * ) AS UserPosts, POST_POSTER_NAME
FROM ubbt_POSTS
WHERE POST_POSTED_TIME > UNIX_TIMESTAMP( CURRENT_DATE ) -86400 *30
GROUP BY POST_POSTER_NAME
ORDER BY UserPosts DESC
LIMIT 10
");
/* BODY HERE */
$body = <<<EOF
$top10
EOF;