Okay.
For my forums I'm using a small template mode for me Top poster.
// Top Poster (Template Mod Style)
// Original: Lesane
// vB3 Re-Make: assassingod (ffdcsite)
Step one:
Open up the 'phpinclude_start' template and at the bottom, add:
if (THIS_SCRIPT == "index")
{
$topposter = $DB_site->query_first("
SELECT username,posts,userid
FROM " . TABLE_PREFIX . "user
ORDER BY posts DESC
LIMIT 1
");
}
Step 2:
Now in the FORUMHOME template, add anywhere you want:
<br />
<b>Top Poster:</b> <a href="member.php?$session[sessionurl]u=$topposter[userid]">$topposter[username]</a> (With $topposter[posts] posts!)
To exclude groupid 6 (admins) replace with this code:
$topposter = $DB_site->query_first("
SELECT username,posts,userid
FROM " . TABLE_PREFIX . "user
WHERE usergroupid <> 6
ORDER BY posts DESC
LIMIT 1
");
6 is the id you want to exclude.
For the vBadvance top poster stats I applied the same approach but
this time the modification was done in the forum/modules/stats.php
file.
Find:
$topposter = $DB_site->query_first('SELECT username, posts, userid FROM ' . TABLE_PREFIX . 'user ORDER BY posts DESC LIMIT 1');
and replace with:
$topposter = $DB_site->query_first('SELECT username, posts, userid FROM ' . TABLE_PREFIX . 'user WHERE usergroupid <> 6 ORDER BY posts DESC LIMIT 1');
Once again 6 is the group you want to exclude.
and thats it! now Admins are now excluded from the top stats on the forum
and any vBa page.