Top 10 Posters Display
 

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.

its good and all..but its alittle confusin ....

So is your reply ???

Installed great. Can you make it work as a module with vBa?

Thanks for the work.

vBa ?

I assume that's one of the portals ? - I don't have any knowledge of them.

vBadvanced. Okay, I'll muck around with it, if it's alright with you.

If I get it working I'll pass you the code as an add on.

Fine. :)

Nice hack.

Shows up as an uncached template though.

Can this be fixed please? :)

Doh ! - I added it to the wrong array - fixed - just replace the php with the new one. :smoke:

EDIT: Now included in the first post.

Cool mod Paul, Installed! (tomorrow that is :) )

A small typo in the instructions has been fixed.

Hi Paul, this is what I was waiting for! :)

How do I display the top posters in the navbar just to the Forum Admins? I assume this can be done through conditions.. any advice on what to edit and how? Thank you!

nice hack and very easy to install :)
Got 2 questions:

1) can u remove the url from the template?
2) in the list are shown also the banned users, how to avoid this please?


Thanks :)

Put an if condtional around the link code ;

Sorry, please explain what you mean as I don't quite understand.

You cannot do this without making the sql queries more complicated. Since banned users cannot post they will soon fall out of the first three columns anyway. Set their post count to 0 via user admin to remove them from the overall list.

Thank you Paul, everything works great!

installed ;)

Glad to hear it. :)

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?

Thank You Paul :)

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.

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

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.

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?

Yes, I did.

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.

Paul,

Thanks again for another great mod :)

jd :)

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

thanx in advance

lairnoc

thanks much! excellent work.

You would have to seriously hack the code and template - more or less a new hack.

hmm i can't do that.. i am a super noob. anyone here?

hello Paul, in version 1,01 of vbadvanced is easy, truly easy to
install yours hack, but in version 2,0 of vbadvanced as I make to
install the module? that practically it is last part that I do not
succeed!!! it makes to know thanks me pir4

I haven't used 2.0 yet. Sorry.

Sorry, I know nothing about vbadvanced - the module was done by dsboyce8624 - and it looks like he cannot help you either.

O.K. I installed this and it's there. but it does nothing. All I need to know is where and how do I do step 4
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)
Can someone tell me where and how do I do this? Thanks for any and all helpful reply's!!!

You do exactly as you were told here ;

https://vborg.vbsupport.ru/showthread.php?p=669548

FYI: Step 4 is not a requirement to make it work, just make it faster. If it "does nothing" then you have done something wrong. That said, what exactly do you mean by "does nothing" - what are you doing to view it, and what do you see (and what is the url of your site as you haven't set it in your profile .....).

www.Blastology.net

I tried....as I was told in my admin. It said I do not have permission. Well, it's my site and I'm the only admin, so this is why I'm asking questions. Sorry if they're elementary to you. They are not to me.

See this for details on running queries in the ACP;

https://vborg.vbsupport.ru/showpost.php?p=626935


Looking at you site, you don't appear to have actually uploaded the topposters.php file.

http://www.blastology.net/topposters.php gives a 404 not found error.

I used the cmps version. That's why I gave my address, so people could see it. It's the first page you will go to and it's in the middle on the bottom,doing nothing :)

oh yeah I added the topposters.php too :) it's blank