Top Posters per Forum (shown in forumdisplay)

What does this hack do?

This hack shows the top poster in each forum, in the forumdisplay template (so when viewing the forum, you can see the top poster for that forum).

The line that displays the top poster for the forum is in the template, so you can move it anywhere you want it to show up!

Modifications

• show highest posters from last 24 hours
• link member usernames to their profiles

Change Log

version 1.1

• enables you to specify how many top posters you want to have displayed per forum
• adds commas in between usernames in the top posters list

Screenshots
forumdisplay v1.1
forumdisplay v1.0

Enjoy!

[karmanis]

Thank you very much Gary! (karmanis clicks Install )

However, to make this hack a must, I would suggest you make 2 modifications...


1) Make visible the 10 most active members instead of only the first. (Such a thing will be in coherence with the title of the hack, "top posterS")

This would extend the functionality of the hack, and make it act as a whole information block instead of a simple line. Furthermore, it is more tempting if 10 users could see their name, rather than have just one been satisfied.



2) Modify the query to get the posters from not only the current forum but from the forum and its childforums .


The last one is going to solve the problem stated by TonTon, which also happens to me and is caused because if you are currently at a category and not at a forum, the query does not find any posts in the category so it can not find any posters to show.

Making the query to get the posts from all the childforums, the hack will be able to show the top posters like a charm.



Thanks again,
this is going to be a hack in great demand here at vb.org !

[Gary King]

v1.1 coming right up!

[Ryan Ashbrook]

Very nice hack, however, I have had members change their names from what they originally registered with, and your hack shows their very first name.

How can I fix this?

[Gary King]

Well, my hack pulls the usernames from the user table, so unless you've changed things so that your users' usernames aren't from that table anymore, then you'll have to modify the hack accordingly.

[Gary King]

Top Posters per Forum v1.1 is now out!

New features include:

• enables you to specify how many top posters you want to have displayed per forum
• adds commas in between usernames in the top posters list

Stay tooned for other updates and announcements!

[Dean C]

Would this work faster with an index on the post table

[karmanis]

...Where is the attachment for version 1.1 ?
Does this retrieve the posters counting also the posts inside subforums ???

thanx

[LadyBeth]

Can this be modified so that the Administrator is not included?
THanks!
Beth

[Gary King]

Today at 09:24 AM karmanis said this in Post #17
...Where is the attachment for version 1.1 ?
Does this retrieve the posters counting also the posts inside subforums ???

thanx

In the first post of this thread. If you don't get it, then try clearing your cache

[Gary King]

Today at 09:45 AM LadyBeth said this in Post #18
Can this be modified so that the Administrator is not included?
THanks!
Beth

Replace the

PHP Code:

// Top Posters Per Forum hack v1.0 by Gary W.
$topposter=$DB_site->query("SELECT COUNT(post.postid) AS posts,userid,username FROM post
    LEFT JOIN thread ON post.threadid = thread.threadid
    LEFT JOIN forum ON forum.forumid = thread.forumid
    WHERE forum.forumid=$forumid
    GROUP BY userid ORDER BY posts DESC LIMIT 0,$topposterno"); 


with

PHP Code:

// Top Posters Per Forum hack v1.0 by Gary W.
$topposter=$DB_site->query("SELECT COUNT(post.postid) AS posts,post.userid,post.username FROM post
    LEFT JOIN thread ON post.threadid = thread.threadid
    LEFT JOIN forum ON forum.forumid = thread.forumid
    LEFT JOIN user ON user.userid = post.userid
    WHERE forum.forumid=$forumid AND user.usergroupid != 6
    GROUP BY userid ORDER BY posts DESC LIMIT 0,$topposterno");