[Release] Top Thread Starter/Top Poster

Author: Converted to phpinclude by Anime-loo, Based off Lesanes hack for 2.0.3
Description: This modification will add two new stats to index.php. It will show the top poster/thread starter, link to their profile, show their amount of posts/threads.
Demo: N/A
Screenshot: In next post.
Warning: This will add 2 queries to index.php (the most bust page on your forum). Not recomended for large boards to install this.

[assassingod]

Cool - thanks for the mod.

[imported_gutterfox]

and if i want show top-posters wich aren't admin&mod?
for top posters, i make this mod.

$topposters=$DB_site->query_first("SELECT username,posts,userid FROM user WHERE usergroupid<5 ORDER BY posts desc LIMIT 1");

and for top-thread starter????

[Vladdy]

I keep getting parse errors when I use it with the one querie edit that ffdcsite posted above, and when I code it as the way it was written the mods are not shown on my forumhome

[Vladdy]

Ok I finally got this working, but now I have another problem.

My top thread starter is someone who we banned & deleted. How can I make it so that person isn't shown as the top thread starter, other than by deleting those threads? Can that be done?

[bigdaddy04]

nice mod, what i am looking for is actually a separate file to show top10 poster statistics, that file should connect to the database and run the query, could someone please help me out with this, i dont want to clutter the index.

thanks.