[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.

[Brad]

Screenshot.

[Tony G]

Very popular hack, will do well in template forum. Nice job!

[Cypher720]

nice job..i really like this

I'll install this with version 3

[Rufus69]

-_- now mine is obsolete..

[filburt1]

This is two queries, so beware. I think it can be combined into one, though, investigating...

[otacon]

very cool

[Brad]

Originally posted by filburt1
This is two queries, so beware. I think it can be combined into one, though, investigating...

yea, i ran it on a board about 8 months ago and it seemed fine as the queries its running are small, but im adding a warning to the frist post.

[assassingod]

I like it
If I wanted to add just top posters, I would add this to the phpinc code?

if (strpos($_SERVER['PHP_SELF'], 'index.php') != false)
{
$topposters=$DB_site->query_first("SELECT username,posts,userid FROM user ORDER BY posts desc LIMIT 1");
}

then add this to forumhome

<b>Top Poster:</b> <a href="member.php?&action=getinfo&userid=$topposter s[userid]"><b>$topposters[username]</b></a>(with $topposters[posts] posts)


Right?

[Brad]

correct.