How to exclude admin from top 10

[JohnBee]

Ah.

This one, its so small I though it came by default with vBulletin :lick:

// 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!)