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

Screenshot.

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

nice job..i really like this;)

I'll install this with version 3

-_- now mine is obsolete..

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

very cool

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.

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? :)

correct.