Top 10 Posters Display

[Paul M]

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.

[Pain86]

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

[Paul M]

its good and all..but its alittle confusin ....So is your reply ???

[dsboyce8624]

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

Thanks for the work.

[Paul M]

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

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

[dsboyce8624]

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.

[Paul M]

Fine. :)

[Gemma]

Nice hack.

Shows up as an uncached template though.

Can this be fixed please? :)

[Paul M]

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:

[dsboyce8624]

EDIT: Now included in the first post.

[ericgtr]

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

[Paul M]

A small typo in the instructions has been fixed.

[Ala21]

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!

[hollyboy]

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 :)

[Paul M]

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!Put an if condtional around the link code ;

<if condition="$bbuserinfo['usergroupid'] == 6">
Navbar Link Code
</if>

[Paul M]

1) can u remove the url from the templateSorry, please explain what you mean as I don't quite understand.

2) in the list are shown also the banned users, how to avoid this please?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.

[Ala21]

Thank you Paul, everything works great!

installed ;)

[Paul M]

Thank you Paul, everything works great!Glad to hear it. :)

[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?

[Gemma]

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

Thank You Paul :)

[Paul M]

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]

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]

I think u should fix the code a little bit and avoid some "member group" to be displayed in your nice :) hackAs 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]

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]

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.

[Paul M]

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

thanx in advance

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

[lairnoc]

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

[sambacb]

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

[dsboyce8624]

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.

[Paul M]

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 pir4Sorry, I know nothing about vbadvanced - the module was done by dsboyce8624 - and it looks like he cannot help you either.

[Nephalim]

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!!!

[Paul M]

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 4You 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 .....).

[Nephalim]

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.

[Paul M]

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.

[Nephalim]

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

[Nephalim]

Well. I'm a musician not a programmer. The total users that have visited hack actually worked for about twenty minutes. Now it does nothing. Anyone? Anywhere? Thanks for any and all helpful reply's.

[Paul M]

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 nothingThe code is not being run, make sure you set up all the options for the module, and uploaded the php file to your modules folder. other than that i cannot help you with vba, I don't have it.

oh yeah I added the topposters.php too :) it's blankIt won't, since you have used the vba version you won't have installed the standard template.

As for total users - wrong thread. :)

[Nephalim]

I give up man. The php file is in the modules folder and I followed the directions. Your hacks look good. I try to install them, even said I'd pay to have them installed and all I get is this back and forth post tag. I posted total users there too. E-mailed ya' three times. Would just like to have these working properly. Sorry for all the elementary questions

[Paul M]

I give up man. The php file is in the modules folder and I followed the directions. Your hacks look good. I try to install them, even said I'd pay to have them installed and all I get is this back and forth post tag. I posted total users there too. E-mailed ya' three times. Would just like to have these working properly. Sorry for all the elementary questionsSorry, but I don't think I can help you any further in this thread. Finding someone to install it for you seems the best option.

Do I understand from the rest of your post that you are also the same person as 'Kenny' who has been e-mailing me to ask if I can install these hacks - while at the same time still asking how to do it yourself in this topic ? If so then I have already replied to your e-mails.

[dsboyce8624]

I PMd him with an offer of help.

[MustangLisa]

Great hack, thanks. Super easy to install, too.

[paul41598]

This might be a little picky, but is there a way to put a ( , ) comma in the post count, when users get more than 1000? So instead of 1000 it shows 1,000

[Marco van Herwaarden]

There are standard functions to format numbers with respect to the number format set in AdminCP.

[paul41598]

There are standard functions to format numbers with respect to the number format set in AdminCP.
All there are in the admincp, is the ability to format date/timestamp, nothing about post count. Im assuming youd have to alter this hacks code to include some sort of function to put that comma in there

[Paul M]

This might be a little picky, but is there a way to put a ( , ) comma in the post count, when users get more than 1000? So instead of 1000 it shows 1,000v1.55 uploaded - added number formatting (as above) and also the ability to filter the usergroups that are included (so you can, for instance, exclude banned users etc).

[yoyoyoyo]

v1.55 uploaded - added number formatting (as above) and also the ability to filter the usergroups that are included (so you can, for instance, exclude banned users etc).what do we need to do to update?

[Paul M]

what do we need to do to update?If you want the extra facilities then replace your topposters.php with the new one. :)

[Extreme John]

installed it on our site http://www.thetanforum.com and looks awesome. great hack paul GJ :)

i got one issue tho... it doesnt seem to include post counts from users under custom user groups. any idea how to fix this? hope you guys could help me. thanks in advance

[Extreme John]

ooopps! never mind guys i found it. i guess i missed out that part of the php code hehehe. great hack :)

[1nf3rn0]

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

i had this same problem and its a real simple fix...when you added the new template called TOPPOSTERS did you use capital letters?.....i did not and received the same blank page...make sure you use caps...hope that helps!

[Paul M]

Please remember to click on the install link (looking at Paul41598, Extreme John & 1nf3rn0 here ;))

[Sleepyk]

i installed but it wont show on forum http://thebattledome.com i did everything said and dont know why it wont work...

[Paul M]

<a href="http://thebattledome.com/topposters.php" target="_blank">http://thebattledome.com/topposters.php</a> works for me.

[selwonk]

Hi Paul

Great hack - thanks very much! Any objections to me removing the link to your profile at the bottom:

Version 1.55 : ? Paul Marsden 2005

I have no objections to it staying, but unless my users are registered on cable forum they can't see your profile anyway! :ermm:

Cheers!

[Sleepyk]

http://thebattledome.com/topposters.php works for me.


how i get on my forum home template under last 10 threads?

[SlipNslide281]

Maybe in your instructions tell people to run this query:ALTER TABLE post ADD INDEX (dateline)

enstead of saying "If you don't already have an index on the dateline field in the user table then you should add one"

some people are new to this and don't understand what to do. Its kinda like saying if you don't already have this hack installed, install it. Thats what makes me so frustrated on these hacks is the coders automaticly thinks you know what your doing and get about 80% done and bam!!! instructions are not clearn. If we knew we would be making our own hacks. All we users ask is just put exactly what we should do in the instructions.

[selwonk]

Maybe in your instructions tell people to run this query:ALTER TABLE post ADD INDEX (dateline)

enstead of saying "If you don't already have an index on the dateline field in the user table then you should add one"

some people are new to this and don't understand what to do. Its kinda like saying if you don't already have this hack installed, install it. Thats what makes me so frustrated on these hacks is the coders automaticly thinks you know what your doing and get about 80% done and bam!!! instructions are not clearn. If we knew we would be making our own hacks. All we users ask is just put exactly what we should do in the instructions.The instructions read:

Step 5.

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

ALTER TABLE post ADD INDEX (dateline)

I'm probably opening myself up for a flame here, but hey...

I don't think it's too much to ask that if you feel confident enough to start hacking vBulletin, you should really be able to check if a field is indexed. It's just my humble opinion of course! :classic:

At the end of the day, this will not stop this particular hack working. If your site is so large that failing to index this field causes a huge delay in displaying the results, but you don't understand why the indexing change might be required (or how to deal with it), isn't time you learned a bit more about MySQL! :nervous:

Cheers!

[SlipNslide281]

I did my own site not even knowing how to register my domain. I started out as a complete noob and still am. Yes the confidence isn't there. But I have learned so much from detailed instructions. Here is my site, and its my first site. So detailed instructions can help people learn.

www.sonaf.com

[Gutspiller]

How do we know if we need to run Step 5?


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

ALTER TABLE post ADD INDEX (dateline)

If the topposters.php works, does that mean we don't need to do this?

[Sleepyk]

how i get on my forum home template under last 10 threads?
help?

[faast]

Does this work with vB 3.0.7?

[Paul M]

Hi Paul

Great hack - thanks very much! Any objections to me removing the link to your profile at the bottom:

Version 1.55 : ? Paul Marsden 2005

I have no objections to it staying, but unless my users are registered on cable forum they can't see your profile anyway! :ermm:

Cheers!You may remove the actual link to my CF profile - as long as the copyright message (text) remains. :)

[MillerLight]

Installed on VB Ver 3.0.8.

Left out Step 5 and works fine. Straight forward install, works great!

[michaelbenson]

Excellent idea and hack .. keep up the good work :)
Installed

[tuanluu]

How can I show top 10 poster on index page, and right below the navar board

[neuromancer]

How can I show that in forum's homepage ?

[neuromancer]

How can I show that in forum's homepage ?

Isn't anyone who answers it ??

[Paul M]

You can't without embedding the code in a vb file and template edits. More or less a new hack.

[neuromancer]

You can't without embedding the code in a vb file and template edits. More or less a new hack.

Which codes must I embed in vb forum index file and forumhome templates ? Can you help me ?

[Paul M]

Like I said, it would basically be a new hack, which I'm not prepared to spend time on atm.

[Curtis H.]

Nice, painless install. Works well. *clicks install* :nervous:

[pedrovazquez10]

very good thanks!!