$topposters = $DB_site->query("
SELECT username, userid, posts
FROM user
ORDER BY posts DESC
LIMIT 10
");
$topposter=$DB_site->fetch_array($topposters))
{
eval('$var .= "' . fetch_template('template_name') . '";');
}
Replace $var and template_name with the variable used in FORUMHOME and template_name is your template which repeats for each user found. Customize the HTML in that template however you want it... Key phrases are:
$topposter[userid]
$topposter[username]
$topposter[posts]
oh and the " . TABLE_PREFIX . " was implied.....okay? meanies