Top Posters List

[Paul M]

This modification is no longer available or supported.

This displays a page with the Top Forum Posters for a given set of periods. Two periods are fixed ('This Month' & 'Overall') but can be turned off in the options. The other three periods are user definable (in days) - the default values are 1 day, 7 days & 28 days. These three columns cannot be turned off.

The number of posters to be shown can also be set, the default is the top 10 posters. You can also select which usergroups are included (or excluded) in the count, so members in banned groups etc are not shown.

If enabled, this will also attempt to add a link to your Quick Links or Navbar. There is also an option to prefix the link path if you use something like CMPS.

To install just unzip the xml file and import it using the Product Manager


History:

v3.7.001 - First 3.7 release.
v3.7.002 - Fix counting of guest posts in certain circumstances.

[gwerzal]

How about a screenshot or demo please

[jacki]

post : 1,840,519
top poster ınstall
db error :

Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:

SELECT post.postid, post.visible, post.userid
FROM post AS post

WHERE post.threadid = 252928
AND post.visible IN (1
,2
,0
)

ORDER BY post.dateline;

MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Date : Monday, January

[MR.BOSS]

thanks

[asj]

Installation wonderful

[Stubbed]

post : 1,840,519
top poster ınstall
db error :

Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:

SELECT post.postid, post.visible, post.userid
FROM post AS post

WHERE post.threadid = 252928
AND post.visible IN (1
,2
,0
)

ORDER BY post.dateline;

MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Date : Monday, January


I think you'll find that's an error with your MySQL, not with this mod.. :)

[gwerzal]

Just installed and does exactly what it sais on the tin.

If anyones looking for a demo they can check out http://www.dogging-contacts.co.uk (adult site)

Thank you

[Paul M]

[QUOTE=jacki;1430352]post : 1,840,519
top poster ınstall
db error :

Thats an error with your database.

MySQL Error : Table 'post' is marked as crashed

[SuperTaz]

Screenshot or demo?

[Paul M]

Nope, not at the moment. You could always look in the 3.6/3.5 threads, they may have one.

[KURTZ]

Kurtz clicks INSTALL :)

[projectego]

/me clicks install

[Big Boss]

Thanks for the upgrade! I'm gonna install this once I'm finally running on 3.7. :)

[KoC]

My database crashed because of this product. Dont install this on a large forum.

[joopss]

Tenks..........

[Paul M]

My database crashed because of this product. Dont install this on a large forum.

Dont make meaningless statements either. This cannot "crash" a database.

BTW, I run this on a forum much larger then the one listed in your profile .....

[OrionsMom]

Installed and works perfect :) Thank you

[teenhut]

Thanks a tonnnnnnnnnnn :D

[joseduddy]

Great job on this product. Installed looks great.


http://www.dollchatter.com

[synisterk]

Great Hack!!!

Running perfectly

[KURTZ]

like all Paul's hacks ... :)

[rolandogomez]

Installed. This would be cool if there were links to the posters profile page. Thanks regardless, works fine on VB3.7 B5 rg.

[Paul M]

I have thought about that in the past. You can do it yourself by editing the template.

[Guest210212002]

Dont make meaningless statements either. This cannot "crash" a database.

BTW, I run this on a forum much larger then the one listed in your profile .....

If the query hangs up (like mine did, and I installed it during a very low usage time) you're likely to be SOL and restoring from a backup (like I am as I type this). Any mod can crash a database. That's why every install should start with "back up first". ;)

Note: Paul's mod is fine, db crashes happen.

[GoodKarmaKid]

I really like this mod. I have it running here:

http://www.pokerstrategyforums.com/misc.php?do=topposters

My only complaint/suggestion would be that I prefer the members names not bolded. Presumably I can change this somewhere in the file or xml? I'm not much of a hacker but I'm good at following directions if someone would be kind enough to point me in the right direction.

Thanks again for this mod.

Jason

[Paul M]

Edit the Top_Posters_bit template.

[Leica.Robbiani]

While installing this mod I get in the APC the following error:

[:]
Checking for Index
Adding Index

Fatal error: Maximum execution time of 60 seconds exceeded in I:\XXXXX\htdocs\forum\includes\class_core.php on line 413
My database is ok, but the Mod doesn't work.

[Paul M]

The index creation is taking a long while and so the php has timed out - mysql should still complete the index build and once its done, the install routine shouldnt try to add it again. Just try installing it again.

[navjotjsingh]

Paul - you should notify users about this 3.7 version on mod's 3.6 and 3.5 pages. It took me a lot of time to reach this page.

[BigDog56]

Installed, Thank you so very much! You are the Mod King!
http://i54.photobucket.com/albums/g83/yenda65/bd/kingofhill.gif

[noRom]

Sorry to sound like such a noob, but after I did the import via product manager (vb 3.7)...whats next? No errors during this process, I can see its installed, but how to i edit and view it?

Thx

[Paul M]

Via the link in quicklinks or on the navbar (depending on the settings you have used).

[Doc Blizzy]

great mod ... now how can I add this to my quick links and remove it from my main link bar?

[Paul M]

Change the setting in the options.

[beansbaxter]

I have a large forum running 3.7 and this did NOT work!!!

[jw00dy]

Still a great mod! Thanks Paul, and I love your new version numbers. That makes it soo much easier to keep track of what version of vB the mod is made for.

As always, nice work.

[Paul M]

I have a large forum running 3.7 and this did NOT work!!!

It works on any size forum.

[Amm0]

Great mod.

Edit: Hmm, when I view the list, one or two people come up as just a number, and the link sends me to profileid 0

What's going on there? :P

[Paul M]

Interesting, I would call that a bug - which no one has ever reported before - its counting guest posts in certain circumstances.

You can eliminate them by excluding usergroup 1 in the mod options. I will also fix and update it anyway.

[Michael2]

Installed, works great! I'm not sure I would use it but it would be nice to have the option of putting this information in the forumhome template so that it shows on the main page.

[sockwater]

Paul, it looks like the index that is added on installation is not removed when uninstalling.

[Paul M]

Correct. There is no need to remove it, and its possible it may be used by other mods.

[sockwater]

Correct. There is no need to remove it, and its possible it may be used by other mods.

Every additional index that must be maintained makes inserting and deleting on that table more server-intensive.

IMO, if a product creates something, it should remove it upon uninstallation. However, if the user has another mod installed that also uses the index, it would be detrimental to remove it.

Perhaps there should be a way to track which mods create/use which indexes, so that they can be removed when the last mod that was using them is removed. Here's a brainstorm: Have a way to specify (in a product XML file) the non-vB-default indexes that a mod needs, containing the table, columns and index type. Then upon installation of a mod, vB would automatically create any indexes that don't exist and that the mod needs. When uninstalling, vB would check if the indexes that that mod used are not being used by any other mod, and uninstall them.

Indexes could be treated that way, as opposed to adding tables/columns, since the index is a shared item, and a new table/column for a mod is not a shared item.

[lazytown]

Paul,

Another great mod converts to 3.7 -- thank you! However, I'm having a problem with the column headings.

I'm now running 3.7 gold and I previously had installed topposters for 365 (which was working). I installed the 3.7.002 version of topposters and it auto-uninstalled the previous version. Index was created fine. However, the display of topposters is somewhat messed up now. The column headings are wrong. Attached is a screenshot. I did try to reinstall it, but the problem remains.

FYI: I have it set to display topposters for the last 1, 7, 30, and 'all time' days.

Thanks
-vissa

[lazytown]

I found the problem. I had to revert the 'topposters' template. Even when I completely uninstalled and re-installed, the old template remained.

-vissa

[Paul M]

It must have been a very old template, pre "product" days i would guess so didnt get zapped when you uninstalled the product.

[beansbaxter]

When I was running this on 3.6, I had no problems. It wont work on 3.7 - crashes.

[karrerax]

Perfect Installed

[Paul M]

When I was running this on 3.6, I had no problems. It wont work on 3.7 - crashes.

Crashes ??

[|Jordan|]

YOU ARE A GOD!

I was looking for something that did this.

<3 <3 <3 Paul

Is it possible to make it only display users that have a specific custom field in their username on (in this case a radio button)?

[Paul M]

If you want to rewrite it slightly you could do that.

[|Jordan|]

I'm not too familiar with coding, i can edit but complete rewrite's are harder for me. Could i pay you?

[EvilJohn]

Installed! Works wonderfully. Thank you sir.

[Joey805]

I was running this on 3.6 and it worked fine. I just upgraded to vb 3.7 and also updated Top Posters to the latest version.

Now my column headings are missing.

I have attached a screen shot.

How do I fix this?

[Paul M]

Try installing it again, looks like missing phrases to me.

[Alfa1]

What is the difference between this mod and Cyb's mod?

[Paul M]

No idea, I dont keep track of other mods unless I actually use them.

[Joey805]

Try installing it again, looks like missing phrases to me.

Just uninstalled it and reinstalled.

Still the same problem. What should I try next?

[Paul M]

Sorry, without admin access to your forum there is nothing more I could even guess at.

[Promoking]

I have thought about that in the past. You can do it yourself by editing the template.

Edit the Top_Posters_bit template.

Where are the templates found?

Also, is there a way to mod your code to show "last month" data just like and along with "this month" data? This would be soooo useful for forum posting contests and rewards which is why I am using it. Where can I go to make those kind of edits?

By the way = THANK YOU for making this. I was trying to total the info up by hand for our forum posting contests and it was terrible.

THANKS AGAIN !!!!

[Paul M]

The template is found in the style manager, same as all other templates. The one you want is "Top_Posters_bit".

To do last month would require code changes, and possible a change to the sql.

[Promoking]

Thanks Paul - I really appreciate it.

To do last month would require code changes, and possible a change to the sql.

So... um... I guess doing that kinda coding is way beyond my skillz. Any hope you can add it?

Cheers

-Brian

PS. Idea for another mod = a page where you can run a search query specified by a date range that returns individual users/posters and the number of posts each user made within the specified date range. What do you think? Useful? Doable?

Thanks

[Paul M]

So... um... I guess doing that kinda coding is way beyond my skillz. Any hope you can add it?

PS. Idea for another mod = a page where you can run a search query specified by a date range that returns individual users/posters and the number of posts each user made within the specified date range. What do you think? Useful? Doable?


Sorry, no changes are planned to this mod.

[MorrisMcD]

Just times out for me when installing the product... I dont even see the product listed under products installed..

Any clue? Worked great on 3.6 for me.. No database crashing here though... :)

[Paul M]

Sorry, there is no reason for this to time out other than some odd issue with your board. Have you tried again ?

[MorrisMcD]

Sorry, there is no reason for this to time out other than some odd issue with your board. Have you tried again ?
Yes I tried it three times.. Without overwrite on.. Each time, it did the same thing. In fact, just tried it again...

Importing Product, Please Wait...

[:]
Checking for Index
Adding Index

Never goes back to the products page.. Just sits there like so for about a min to two min and then the bottom of the page reads as done

[Paul M]

Your server is obviously taking a long time to add the index, or failing to add it for some reason. Maybe you will have to do that manually.

[MorrisMcD]

Your server is obviously taking a long time to add the index, or failing to add it for some reason. Maybe you will have to do that manually.

How do I go about doing so? Can I try changing timeout values somewhere possibly?

[Paul M]

How do I go about doing so?
Just run the sql manually ;

ALTER TABLE post ADD INDEX (dateline)

[MorrisMcD]

Just run the sql manually ;

ALTER TABLE post ADD INDEX (dateline)
Your SQL-query has been executed successfully (Query took 62.6895 sec)
SQL-query:
ALTER TABLE post ADD INDEX ( dateline )


Did it manually.. Imported the product... same thing

I verified the dateline exists in the post table. So when installing, when it checks for the index, why does it still attempt to add it?

[Paul M]

No idea. If it sees the index it wont try and add it.

[MorrisMcD]

No idea. If it sees the index it wont try and add it.
Welp.. If you give up, so do I... Nice feature.. Not worth the headache

And it doesn't seem I am the only one with a similar problem. Nor do I have a problem with any other products

[Paul M]

Welp.. If you give up, so do I... Nice feature.. Not worth the headache
Since I have neither access to your server or forum, there is nothing I can do. I cant just produce magic answers out of thin air. :)

And it doesn't seem I am the only one with a similar problem. Nor do I have a problem with any other products
I dont see anyone else having an issue creating the index.

How many of those "other products" create an index on (or alter) the post table, Im guessing none, since they obviously would have the same problem (the issue is mysql creating the index, not the product).

[MorrisMcD]

Since I have neither access to your server or forum, there is nothing I can do. I cant just produce magic answers out of thin air. :)
I understand that.. And I will continue to enjoy the majority of your addons and appreciate your effort in making them.. Unfortunately this one just isn't working out.


I dont see anyone else having an issue creating the index.

How many of those "other products" create an index on (or alter) the post table, Im guessing none, since they obviously would have the same problem (the issue is mysql creating the index, not the product).
I noticed you said something about the problem of the index being created slow and timing out in post # 28... Which is similar to my issue I guess (or at least I thought).. Weird thing is, that the index is created.. I verified it's there. Perhaps it is something on mysql, but I can't imagine what since I am having no other issues with anything whatsoever. Not really meaning to point fingers as you may have taken it that way. Just lost for a solution as I have no other symptoms to go off of

[Paul M]

If you are absolutely sure the index has been created, you can simply comment out the line in the product xml that tries to create it, it will then install (line 76 I believe). Be aware that if the index isnt created ok, you may find the top posters page slow to generate and load.

[MorrisMcD]

If you are absolutely sure the index has been created, you can simply comment out the line in the product xml that tries to create it, it will then install (line 76 I believe). Be aware that if the index isnt created ok, you may find the top posters page slow to generate and load.
I appreciate the fact you still do want to help Paul.. I really do.. I more wanted to give up because I don't want to burden you. But since you posted again.. :)

As far as I can tell, it is created. But my knowledge in this stuff is quite limited. I actually started combing over the product to find where it instructs to create the index. I wasn't sure so I decided to lay off. In any case, before I try the commenting out.. Take a looksy at these screen shots and tell me if it appears that it is created and created successfully. Thanks again for taking the time to respond. I really don't want to be a pain.. Just check these out and tell me if you see any issue with the index... I think its ok.. But I would feel comfortable knowing someone who knows a lot more thinks its ok before I take a suggestion that starts with 'If you are absolutely sure the index has been created'.. lol Sorry that this is going out of the scope of what you would normally support. I understand if you decline to continue

[Paul M]

Neither of those screenshots shows the indexes, they are listed in phpmyadmin under the structure listing (see screenshot). You can also run the following command to list them ;

SHOW INDEX FROM post

[MorrisMcD]

Neither of those screenshots shows the indexes, they are listed in phpmyadmin under the structure listing (see screenshot). You can also run the following command to list them ;

SHOW INDEX FROM post
Eeek... Problem found

My guess would be to start by deleting all the dateline indexes and then the dateline field? Then attempt reimporting again? Might end up with the same results

Hope I said that right...

I also noticed some tables named postindex_temp*****-*** that may or may not have been there before and may or may not have anything to do with this. I get by with people's help on here or other forums.. Sorry for my noobishness

[Paul M]

My guess would be to start by deleting all the dateline indexes and then the dateline field? Then attempt reimporting again? Might end up with the same results
You can delete all the indexes listed except these four : PRIMARY, userid, threadid, dateline.


Do not delete the dateline field in your database, you will break your forum, bigtime.

[Guest210212002]

This kills my DB as well, btw. Just tried installing it on a fresh DB, it creates the index then corrupts my post table.

The hack should have some kind of note/warning for users with big forums, as it creates an index on one of the biggest tables in the DB (post).

Edited for clarity: Folks may need to set their mysql timeouts higher for this to run on big tables.

[Paul M]

If the simple creation of an Index causes you problems then I suggest you have a mysql issue. I cannot help that.

[petersweb]

Thanks Paul - just installed without issue.

[petersweb]

Quick question...what code could I add to the "Top_posters_bit" template to show the Username HTML Markup?

[GraNdMaStEr-B]

I installed this, but can not located it on my forums! What do I need to do. I did upload the XML file, but like i said no luck locating it on the main forum or even the navbar and cmbs

[Paul M]

Have you set it to create a link on the navbar or quick links ?

[GraNdMaStEr-B]

NO!

Would you mind explaining how i would do this. I am new to this! Thanks a bunch

[Paul M]

Its an option in the mods settings.

ACP > vBulletin Options > Top Posters > Automatic Link Creation

[Makc666]

Paul M, is it OK that these two phrases are the same?

<phrase name="top_col2" date="1152000000" username="Paul M" version="3.22"><![CDATA[Last {1} Days]]></phrase>
<phrase name="top_col3" date="1152000000" username="Paul M" version="3.22"><![CDATA[Last {1} Days]]></phrase>

I see it is OK :)
P.S. Tired of the upgrade, from 3.6.10 to 3.7.2 :D

[AmandaB]

I'm not sure what happened with my install. It only shows a bullet dot and ().

[Paul M]

Try installing it again.

[lostguy]

How do i remove those numbers LINK to posts ? Because i have many sections and different usergroup get to view different part the forum .

If it show the POST and abit the content mean there rest able to view it even Admin section . Just go to top Poster and u click their numbers links .

i wanna know can i remove the link direct to their POSTS or it will auto disable the VIEW ?

OR

Can i limit which usergroup i allow them to view the link to posts ?

Pls tell me how to remove link if not .

lg

[IvyKeepMommy]

Paul, I've had this installed for a number of months (both this version and the previous versions) and I love it.

I have recently discovered a problem though... my overall post counts are accurate, but on the 1 day, 7 day and 28 day columns, certain members (i.e., me specifically) have overly inflated totals.

For instance it is showing that I have 7300 posts in the last 28 days, when I only have 9500 posts over the entire last 11 months. Other users posts seem to be fine (I'm the only admin).

I am running a couple of tracking mods that post under my id in a private forum, but that forum is set to NOT include in the post totals.

Any idea?

[Paul M]

I am running a couple of tracking mods that post under my id in a private forum, but that forum is set to NOT include in the post totals.

There is no option to exclude forums from the count so how have you done that ?

[IvyKeepMommy]

There is no option to exclude forums from the count so how have you done that ?

:erm:By selecting this option in the AdminCP under edit forum

Count Posts Made in this Forum Towards User Post Counts
Yes No

It's in the Enable / Disable Features (the same area as the settings to allow HTML or BB code in the forum.

[Jdm Ej1 Coupe]

Installed working Great Thanks!!!

[Paul M]

:erm:By selecting this option in the AdminCP under edit forum



It's in the Enable / Disable Features (the same area as the settings to allow HTML or BB code in the forum.

That has no effect on this mod. :)

[IvyKeepMommy]

That has no effect on this mod. :)

That seems to be the problem... If there are a lot of posts in a forum that doesn't get counted towards a users post count you get wildly different results in the different columns. The results in the "overall" column are correct and do not include the posts but the other time periods do which gives some mighty strange results when a 28 day total can be larger than the overall total post count.

It does affect the mod, just in an unintended way.

[navjotjsingh]

There is a bug while uninstalling this plugin....it leaves a blank space in vbulletin options menu. It does not remove the entry...instead after uninstalling a blank space is left.

I found that blank space is due to this plugin as on viewing source, it shows as

<option value="topposters"></option>

[Paul M]

Installation (or uninstallation) of any product is standard vb functionality, it has nothing to do with the actual mod.

[michaelsilvia]

Installed and works great.

[goxy63]

Hi Paul
Iam bit new to all of this...
So
Regarding to all of your mods...I need to upgrade Vbulletin, before that I should disable or uninstall mods ?

Thanks

[Paul M]

You can upgrade vb without disabling any of my mods - however, some of them require file edits, and or extra files to be uploaded, which you must remember to re-do.

This mod does not require any action.

[goxy63]

I know tha you will say ask their support but .... Ive installed Vbadvanced and on my homepage (under vba) in navbar there is link to your mod, but when I click on it nothing hapends!?(through my forums link is ok)
In 'Navbar Replacements' under mentioned Vba i inputed: forums/misc.php, misc.php, ... but nothing helps, any idea !?
Maybe to reinstall your mod ?

Thanks

[Paul M]

Set the "Link Prefix Path" in the mods options.

[goxy63]

Lol
It was all there, me myself and Noob that Iam ....just didnt saw that
Thanks
Sorryz for dumb questions

[dt_truck11]

im looking for some help in adding just the overall column to a block of space on a menu on my forum home. could somebody tell me how to go about adding this?

[aciurczak]

On our forum some subforums are set to not have posts count in the overall post count. It looks like the "overall" column in Top Posters takes that into account, but the 1, 7, and 28 day columns do not. Certainly not a dealbreaker by any means, but perhaps a fix could be put in for the next revision.

I was able to work around it by removing some usergroups in the display.

[Paul M]

There will be no "fix", the overall column reads the postcount direct from the user table (same as the standard postbit display).

[aciurczak]

Fine by me, but the queries for the 1, 7, and 28 columns may provide different results (different usersets) than the Overall column, and it's not intuitive why they do that until one looks into it a little further. The naive user may assume that they are all the same query with only a different timescale, but that's not the case.

[NLP-er]

Hi! Great plugin :)

I would like to make some changes and need help. I want to put on my main page only one column of to posters results. How can I do that? And I will appreciate some details. I know that I will need to change my templates - I just don't know how to get data from chosen column and does those data are available on footer template. If not how to change it?

Thanks in advance :)

[kNeeLy]

worked with no probs!! Great mod!!!!

[GuaRRand]

does it work with 3.6.x? :(