[Release] Top Thread Starter/Top Poster

[Brad]

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=$topposters[userid]"><b>$topposters[username]</b></a>(with $topposters[posts] posts)


Right? :)

[Brad]

correct.

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