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!

[Gary King]

Today at 07:07 AM Mist said this in Post #16
Would this work faster with an index on the post table

For the post.username column? Yes, I added that to the instructions as an optional step, for people with larger boards

[Arabs Emperor]

it not worked it come for me error

[Gary King]

Today at 08:27 PM Arabs Emperor said this in Post #22
it not worked it come for me error

What error do you get?

[Heffe2000]

I've tried this on my main forums, and my test forums. Both give me the same result:

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=2
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: Saturday 09th of August 2003 01:56:17 AM
Script: http://forums.galaxies-online.com/fo....php?forumid=2
Referer: http://forums.galaxies-online.com/forum/index.php?s=

[Gary King]

You didn't run the SQL query at the end of the instructions.

[lifesourcerec]

I ran it and got the same error. And did run both queries.

[Gary King]

Today at 08:28 PM lifesourcerec said this in Post #26
I ran it and got the same error. And did run both queries.

Try going to vBulletin Options and hitting submit

[Heffe2000]

Actually I did run the last query, on both systems. I'll try it again on my test system and see if I possibly missed a step, but I ran through it twice already.

[Gary King]

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

[psico]

I ran this query:

ALTER TABLE post ADD INDEX (username);

But it still hanging up my server...
My POST table has 400mb almost a million of posts, it is impossible to run a COUNT() query without hanging up everything...