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!

[engquist]

I am running Vbulletin 2.3.0 and had the exact same issue as Heffe2000 described above....however, after I went to VBulletin options and click submit as suggested, it got rid of the database error. You may want to somehow update the directions for this problem. Thanks for the solution though!

One small problem, it lists most of the top posters correctly, but it leaves some names completely out.

For example:

This forum's top 5 posters are: meru+rikku=anoying with 24 posts , Star F. Apacolypse with 18 posts , Phantom Warheart with 14 posts , Firebrand Delacroix with 9 posts , and with 8 posts!

but notice it doesn't say who did the 8 posts!

here's another of my forums:

This forum's top 5 posters are: Dark Firebrand with 20 posts , with 17 posts , with 9 posts , Epyon with 7 posts , and Star F. Apacolypse with 4 posts!

I think that the user named "Warrior of Light" has the 17 posts, and another named Sun2mid has the 9 here.....but I can't figure out why those usernames aren't showing up...

[Gary King]

I am running Vbulletin 2.3.0 and had the exact same issue as Heffe2000 described above....however, after I went to VBulletin options and click submit as suggested, it got rid of the database error. You may want to somehow update the directions for this problem.

Yep, I just added it now

[Arabs Emperor]

i get error
this
+_+++++++++++++++++++++
Database error in vBulletin 2.3.0:

Invalid SQL: 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=14
GROUP BY userid ORDER BY posts DESC LIMIT 0,
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5

mysql error number: 1064

Date: Tuesday 26th of August 2003 05:26:09 PM
Script: http://www.arabse.net/forums/forums/...php?forumid=14
Referer:

++++++++++++++++++++++
i do every thing

[Arabs Emperor]

it work good when i submet VB option
thanks

[Gary King]

Please click on the install button as well, thanks

[Silver740]

08-10-03 at 08:23 PM Gary W said this in Post #27
Try going to vBulletin Options and hitting submit

What do you mean by "Go to VBulletin Options and Hit Submit"?

What does this do? Where is this button? I only see a "Save Changes" button and a "Reset" button on the bottom

[Gary King]

Today at 04:56 PM Silver740 said this in Post #36
What do you mean by "Go to VBulletin Options and Hit Submit"?

What does this do? Where is this button? I only see a "Save Changes" button and a "Reset" button on the bottom

Then hit the Save Changes button

[Red Blaze]

Originally Posted by Gary W

Then hit the Save Changes button

LMAO, that was too obviouse.

Anywho, this is kinda what I want, BUT, is there a way to show the user's Avatar?

[Gary King]

Originally Posted by Sonikku

LMAO, that was too obviouse.

Anywho, this is kinda what I want, BUT, is there a way to show the user's Avatar?

Well, it wouldn't be a problem, but why would you want to show their avatars? It would take up a lot of space, in most cases anyways.

[Red Blaze]

Well I just wanted it as a little add on for my forum. I wouldn't mind at all.