Top 10 Posters Display

This modification is no longer available or supported.

This simple hack displays a page with the Top 10 Forum Posters for the last day, 7 days, 28 days and overall.

No vB files need to be edited. The instructions (txt file), the php file, and a screenshot are attached.

A vB Advanced module is also now available for this (thanks to dsboyce8624) - just d/l the zip file.

[Paul M]

Originally Posted by hollyboy

I noticed the page loads a bit slower compared to other forum pages.
It means lot of queries are running? It means lot of bandwith is used?

No to both. I suspect you have not added the recommended index to your post table (Step 4). Without this it could take 5+ seconds with a forum your size.

[hollyboy]

Originally Posted by Paul M

No to both. I suspect you have not added the recommended index to your post table (Step 4). Without this it could take 5+ seconds with a forum your size.

Step 4.

If you don't already have an index on the dateline field in the post table then you should add one ;

ALTER TABLE post ADD INDEX (dateline)

What is this?
What should I do?
Thanks

The other problem I have and I have allready told u is the hack show also the banned users. I did what u suggested to me: I put zero posts to the banned users, but the hack still show a banned member of the "last 28 days" column.
I think u should fix the code a little bit and avoid some "member group" to be displayed in your nice hack

[Paul M]

Originally Posted by hollyboy

I think u should fix the code a little bit and avoid some "member group" to be displayed in your nice hack

As I already told you - I'm not going to do this.

To add the index, run the SQL query either in your ACP, or in phpmyadmin.

[ThePimp]

I wonder if this could be processed via cron job? It seems to take a bit of time to load, maybe if it just ran once a day and just have it output the static page, it would load alot faster?

[dsboyce8624]

Originally Posted by ThePimp

I wonder if this could be processed via cron job? It seems to take a bit of time to load, maybe if it just ran once a day and just have it output the static page, it would load alot faster?

Did you run the SQL query?

ALTER TABLE post ADD INDEX (dateline)

[ThePimp]

Originally Posted by dsboyce8624

Did you run the SQL query?

ALTER TABLE post ADD INDEX (dateline)

Yes, I did.

[Paul M]

How many posts do you get per month ? - this is installed on a forum that does about 23,000 posts per month - and takes less than a second to run.

[Mosh]

Paul,

Thanks again for another great mod

jd

[lairnoc]

How can i make it less wide? for example only last 24 hours and total posts? 2 coloms?

thanx in advance

lairnoc

[yoyoyoyo]

thanks much! excellent work.