Top Posters

[Paul M]

This modification is no longer available or supported.

Top Posters mod for vb 3.6.

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 (24 hours), 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. Excluded is only available from v3.29 onwards.

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

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


History:

v3.20 - First 3.6 release - auto adds link to quick links.
v3.21 : Dependancies updated for 3.6.0 Gold.
v3.22 : Updated for Version Checking.
v3.23 : Dependancies updated, URL's updated (not released).
v3.24 : SQL changed to use slave.
v3.25 : SQL Changes to use slave.
v3.26 : Added autolink options.
v3.27 : Fixed table index creation.
v3.28 : Added automatic version in template (not released).
v3.29 : Added option to include or exclude usergroups.
v3.30 : Internal version, not released.
v3.31 : Internal version, not released.
v3.32 : Internal version, not released.
v3.33 : Internal code changes, no funcionality change.
v3.34 : Defaults on first install updated.
v3.35 : Option for link path prefix added.

[Craigex]

Thanks for this. :) I just installed it.

[FleaBag]

Yeah I really like it too. I will use it to link from my CMPS top posters module. Thanks. :)

[Atakan KOC]

Thanks Paul M

[BoYagoob]

Installed ..
Thanks Paul .. :)

[utw-Mephisto]

thx :)

[Snake]

Thank you Paul! :)

[kremer4]

Imported the product but it's not working for me.

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

Please help.

[Maxman1544]

Imported the product but it's not working for me.

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

Please help.

I installed this but the initial results seem incorrect as well.

[Paul M]

Imported the product but it's not working for me.

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

Please help.Looks fine to me.

I installed this but the initial results seem incorrect as well.Again, looks fine to me, so I don't know what you mean.

[Maxman1544]

Looks fine to me.

Again, looks fine to me, so I don't know what you mean.

The overall column isn't pulling in the actual top 10. If you go to the member list and sort on posts you can see there are people missing.

Same goes for each column. On my forum it isn't pulling in the actual top 10 for that time period. Not sure if it is related to multiple user groups or what!

[Paul M]

Did you read the notes ?

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 in the count, so members in banned groups etc are not shownThe default is 2,5,6,7 I believe (and also primary usergroup only).

[jacki]

:cool:


SS

http://img110.imageshack.us/img110/4240/adszma8.jpg

[kremer4]

It's working now, I upgraded to 3.6 Gold last night and magically it started working :)

[Ohiosweetheart]

fantastic!

[slayer666vb]

:) Installed

[Ohiosweetheart]

I love this hack.

One thing I do wish it had... the option to pull the top Posters for the past 12 hours, rather than just 24 hours. This would be very useful for sites that have posting contests aka Post-a-thons ;)

[Paul M]

If you set one of the columns to 0.5 days then you will get 12 hours.

[Maxman1544]

Did you read the notes ?

The default is 2,5,6,7 I believe (and also primary usergroup only).


Thank You! Great hack!!!

[TamCaVBoy3]

i see it in quick links, but don't see it in the forumhome...weird...could it be because i installed Welcome Headers mod ?

[Paul M]

No sure what you mean, there is nothing specific to the forumhome in this.

[TamCaVBoy3]

like on the main page, will the top users suppose to show on top of the forums...

[Paul M]

If you mean on the navbar, no this will not do that, you would have to manually add a link. This is designed to (try and) add it to your Quick Links only.

[ra7al]

<font color="Red">Many thanx >>> installed </font>

[Ben Wilkins]

Hey, how can i get 1 hour? is it 0.1?

[Ben Wilkins]

I think it might be:
0.083333333333333333333333333333333

[bongwater]

thanks, *clicked install*

[bongwater]

I installed it, and I'm using 3.6 gold. When I change the original 3 column defaults of 1 day, 7 days, and 28 to different numbers, it recalculates everything correctly, but the headers still say "24 hours", "7 days" "28 days".

how can this be fixed? thanks

[Varsh]

Did you read the notes ?

The default is 2,5,6,7 I believe (and also primary usergroup only).
Sorry to be so blunt here but where do you set this? Or have I completely missed something?

[netwiz]

Installed it on 3.6 Gold installation.. but does not seem to work. It misses few users.

[Paul M]

Sorry to be so blunt here but where do you set this? Or have I completely missed something?The Top Posters section in vbulletin options.

[Paul M]

Installed it on 3.6 Gold installation.. but does not seem to work. It misses few users.It works fine. Please read the notes or post #12 of this thread.

[wolfyman]

I have added additional usergroups to the settings, but they don't show yet. Do I need to do anything else?

Aso, when I check version, I get this error:

Version check failed. No version number was found at this location. The URL for the version check may be incorrect, or the server may be experiencing problems. Please try again later.

[Paul M]

What version do you have installed ?

[wolfyman]

3.21, but I just noticed you're on 3.22, so I'll upgrade now.

[wolfyman]

ok, now check version works.

However, my usergroups looks like this: 2,5,6,7,34,35,36,37,19,26,29,32,30,28

But group 36 is still not showing up on the toplist. There may be others, but it just so happens that group 36 is my most active usergroup so they let me know first :P

[Get Shorty]

Installed and working perfectly...

[Paul M]

ok, now check version works.

However, my usergroups looks like this: 2,5,6,7,34,35,36,37,19,26,29,32,30,28

But group 36 is still not showing up on the toplist. There may be others, but it just so happens that group 36 is my most active usergroup so they let me know first :PIs 36 their primary group ?

[wolfyman]

The one case I was looking at that is not on the list

Primary: 36
Additional: 30, 26, 7, 37

Another that is not showing up:

Primary: 36
Additional: 30, 26, 2

[wolfyman]

It occurs to me that it might be easier to let people specify which usergroup to block from the toplist, rather than which group to add to the toplist.

[Paul M]

The one case I was looking at that is not on the list

Primary: 36
Additional: 30, 26, 7, 37

Another that is not showing up:

Primary: 36
Additional: 30, 26, 2
Then I have no idea, and don't really see how it's possible, mysql should return what you ask it for.

[wolfyman]

The older version of the hack worked just fine for me, on 3.5.4. Does that help at all?

And now that I look at it - no users in that usergroup are showing on the toplist.

[Paul M]

The older version of the hack worked just fine for me, on 3.5.4. Does that help at all?The actual code is identical to the 3.5 version.

[LordDB]

I'm using vB3.6, and after I installed, clicked on the link, and now get Database Error.

Any advice here, plz?

Br.

[Paul M]

No one can tell you anything unless you post the actual error.

[wolfyman]

hey Paul, could you send me the older version? I would like to give it a shot, I think I've pushed every button possible in my admincp with no results.

I just don't get it...

I just took a user from primary 36 and put them as additional 36/primary 2, and they show up just fine on the top posters list....

[LordDB]

Here you go, Paul:

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid, user.username
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE dateline > 1156955856 AND user.usergroupid IN (2,5,6,7,9,11,)
GROUP BY userid ORDER BY postcount DESC LIMIT 5;

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 ')
GROUP BY userid ORDER BY postcount DESC LIMIT 5' at line 4
Error Number : 1064
Date : Thursday, August 31st 2006 @ 05:37:28 PM
Script : http://www.norfolkmanagementrentals.co.uk/forum/
Referrer :
IP Address :
Username : Mega Admin
Classname : vb_database

Cheers! :)

[Paul M]

Remove the comma after the 11 in the usergroup settings.

[wolfyman]

show me some love paul, pleeeeeeease :)

[Paul M]

show me some love paul, pleeeeeeease :)Huh ?

[psalzmann]

Great hack. It has been installed on our site for at least a month and I just noticed a huge flaw (well, maybe not) but check this:

So we have a Top Posters Competition where each month a top poster wins $20 for having the most posts in that given month. Fine, no problem.

A new month is finally here (Aug 1st) and the top posters system HAS NOT RESET back to 0. Is this something we're going to code in ourselves to reset these stats?

Anyways, obvisouly the script doesn't support stat resetting, so I ask .. is there an easy method to reset all stats on a given month maybe via CRON or my manuallly typing something in or by running a script to reset?

Please advise what tables I need to clean out to reset each month?

Thanks in advance guys.

[wolfyman]

Huh ?

"Huh" what? I asked you for support, I asked you for an older version, and you ignored me.


I just got this email from a programmer I use:

The problem is with this topposters module, you know this, right?
https://vborg.vbsupport.ru/showthread.php?t=121918

Here is what I found in topposters.php:
// List usergroups to be included //
$groups = '2,5,6,7,12,20,21';
These groups were just hardcoded in module code, so settings in vBulletin options were useless!

It should work now.



And guess what? It DOES work now. Thanks, buddy.

[Paul M]

Maybe your programmer should have looked a bit more carefully ;)

This mod doesn't use topposters.php - nor does the 3.5 version, that file is only found in the original vb3.0 version.

[wolfyman]

Why should my programmer have looked more carefully? He got it working, that's all I care about. If you weren't so busy defending your "code" you would have realized you weren't helping solve the problem. Like I said in my last post - thanks, buddy. :D

[Paul M]

Why should my programmer have looked more carefully? Perhaps to save himself/herself the trouble of fixing something that wasn't actually broken. :cool:

If you weren't so busy defending your "code" you would have realized you weren't helping solve the problem.I responded to you at least three times (posts 38, 41 & 43). :) I'm not quite sure how I'm supposed to realise you are trying to use a file that doesn't even exist in this version, or the current 3.5 version. As for "defending my code" - yes, I will, and make no apologies for it - if you choose to post an e-mail from a "programmer" saying that something is "useless" then you can be sure you will get a respose pointing out thier mistake.

If you have something that is working then great :) - but JFYI - what you have is not this mod, it guess it must be a very early 3.5 conversion (released while 3.5 was still in the beta stage) and you could [I think] uninstall this mod completely and that file would continue to work.

[davelacey]

Sweet.
Thankyou :)

[gingery]

Is there any way to exclude a specific forum from counting towards the posts totals (while still allowing "Count Posts Made in this Forum Towards User Post Counts" to be yes in the vb adminCP)?

[Paul M]

No, there is no such facility.

[zafrir]

Installed - working!

can't change the 28 days column to somthing else.
how can I delete a column?

[Paul M]

You can change the 28 days to whatever value you want.

The other three periods are user definable (in days) - the default values are 1 day (24 hours), 7 days & 28 days. These three columns cannot be turned off.

[aky]

anyway to have a colum that an admin can reset... say if i want to have a top poster of the month contest starting in the middle of a month, i would like to reset a column to 0 posts and let to run until i click reset again

any chance of having this?

[Paul M]

Sorry, but no - you cannot do that, and I have no plans to add such a feature.

[xman_79]

Very nice .
Thank you.

[Alfa1]

Hey Paul. Yet another handy hack from you. Is there any chance of expanding this to top posters per forum? That would make my day.

[VitroX]

thanks for your hack, however where is supouse to be the link to the Top Posters?, I cant find it, I installed it and didnt report problems, I'm using vb 3.6.1

[Paul M]

If it manages to create it, it will be in Quick Links. If not, you will need to manually add one, linking to misc.php?do=topposters

[exilera]

Is there any way to add a list of top posters within the "left side column" hack also found on vBulletin.org?

Thanks!

[Skedoozy]

You can change the 28 days to whatever value you want.

I think he means that whatever you change the days or hours to it still says 24 hours, 7 days, 28 days, in the column headers.

I fixed this by editing the original XML to say what I put the settings on and then uploading it again checking yes on Allow Override when I did. That worked. :)

[Paul M]

or you could do it the proper way and just edit the phrase in the ACP, like you would any other phrase. :)

[AngieZ]

Is there a way I can edit the title to include my forum name on the list instead of it displaying "Top Posters List" by default?

[Paul M]

Not exactly - it uses a phrase, but that phrase is used in more than one place.

[Dasme]

Great mod Paul M.

Is there any way or a simple modification so that this would show the previous month's Top Posters as well? I'm planning on using this for a contest, and would love it if the previous months stats stayed for the month.

Thanks for putting out such a useful mod.

[Captain Kirk76]

Hi, Great Mod!
Unfortunatly it didnt add it to my navbar, as its full. Is there anyway of making it a little link on the Whose Online part?

Thanks! (forum is www.forumchunkies.co.uk , as you can see, my navbar is full already, it has 2 extra when logged in)

Its also missing certain members off the list too? :( how can i set it to accept ALL usergroups? (that part is here http://forumchunkies.co.uk/vb/forum/misc.php?do=topposters )

[Paul M]

Is there any way or a simple modification so that this would show the previous month's Top Posters as well? I'm planning on using this for a contest, and would love it if the previous months stats stayed for the month.
There is no way to do that, it would need a new section of code writing.

Hi, Great Mod!
Unfortunatly it didnt add it to my navbar, as its full. Is there anyway of making it a little link on the Whose Online part?It tries to attach a link in Quick Links, not the navbar - but that will only work if you don't have a customised style. Otherwise you need to manually add a link yourself.

Its also missing certain members off the list too? :( how can i set it to accept ALL usergroups? (that part is here http://forumchunkies.co.uk/vb/forum/misc.php?do=topposters )The usergroups included is part of the options, add all the groups you want to include (the default is 2,5,6,7).

[Captain Kirk76]

I understand the bit about adding the usergroup, but how do i know which number to add?

[Paul M]

Look it up in the usergroup manager.

[navjotjsingh]

Hey Even When I set 30 days instead of 28 days...It still shows the topic under Top posters as Last 28 days...is it just typo error or is it really showing posts from 28 days?

[Paul M]

If you set it to 30 days then it will display 30 days - the text is a phrase, you need to edit that as well if you change the days.

[Doglet]

Version 3.22 with vBulletin 3.6.2

There is definitely something wrong with the Last 28 days column. The totals in that are larger than the Overall column, which is correct. This must surely cast a doubt on other rolling totals?

Look at this site (http://www.carandimage.com/forums/index.php). The link is on navbar.

[Paul M]

There is nothing wrong with it, You just need to understand what it does.

All the columns except "overall" count the actual number of posts in the database by each user over the time period - this includes any hidden/moderated/deleted posts, and any in private forums or forums that don't normally count posts. It is exactly what it says, a count of ALL posts in the given timeframe.

The final "overall" column is simply read from the user table, it is the one shown in a users postbit, it's not a true count and is rarely accurate on older forums - the reason it's done this way is simply because counting all posts in the database would be a seriously slow query on any decent sized forum.

[Doglet]

Hmm, I have a hidden moderators forum with hundreds of posts that don't count to the moderator's post count. In your utility they are being counted. My moderators are hidden from view and moderate as a bord and we let anonymous usernames be used to do the necessary moderation. This utility virtually identifies them as moderators as they have hundreds more posts than show andmy forum is less than 28 days old, hence the problem.

[Paul M]

Well I'm afraid the way it works is not going to change - about the only thing you could do is not include the moderators usergroup in the count (that is an option) - however, that assumes they are in their own primary usergroup and members might then wonder why those users never appear. If that's no good then I this hack is not for you.

[jw00dy]

Nice mod, as usual.

Installed

[dendrob]

Will this work on VB3.5.4 or do I need older version? I tried to install it, but it crapped up on me with this error:

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO vb_plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Top Posters (1)', 'parse_templates', '$search_text = \'$vbphrase[open_buddy_list]</a></td></tr>\';\r\n$add_text = \'<tr><td class=\\\"vbmenu_option\\\"><a href=\\\"misc.php?$session[sessionurl]do=topposters\\\">$vbphrase[top_posters_list]</a></td></tr>\';\r\n$vbulletin->templatecache[\'navbar\'] = str_replace($search_text,$search_text.$add_text,$v bulletin->templatecache[\'navbar\']);', 'paulm_20051029');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Sunday, October 15th 2006 @ 11:31:17 AM
Script : http://www.orchidboard.com/community/admincp/plugin.php
Referrer : http://www.orchidboard.com/community/admincp/plugin.php?do=productadd
IP Address : 24.57.23.17
Username : Marty
Classname : vb_database
Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO vb_plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Top Posters (1)', 'parse_templates', '$search_text = \'$vbphrase[open_buddy_list]</a></td></tr>\';\r\n$add_text = \'<tr><td class=\\\"vbmenu_option\\\"><a href=\\\"misc.php?$session[sessionurl]do=topposters\\\">$vbphrase[top_posters_list]</a></td></tr>\';\r\n$vbulletin->templatecache[\'navbar\'] = str_replace($search_text,$search_text.$add_text,$v bulletin->templatecache[\'navbar\']);', 'paulm_20051029');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Sunday, October 15th 2006 @ 11:31:17 AM
Script : http://www.orchidboard.com/community/admincp/plugin.php
Referrer : http://www.orchidboard.com/community/admincp/plugin.php?do=productadd
IP Address : 24.57.23.17
Username : Marty
Classname : vb_database


The install entered into some type of a loop, making the [................] longer and longer and never quitting.

[Paul M]

You cannot install this version on 3.5 since it's for 3.6 - there is a seperate 3.5 version (https://vborg.vbsupport.ru/showthread.php?t=92177).

[dendrob]

Funny, you beat me to it...I just came here to tell you to ignore it as I found the 3.5 hack. Thanks a bunch.

[Paul M]

Hmm, my copyright message has gone walkies on your forum ........

[webgeek247]

Hi, Paul M!

I've installed this hack and the top posters link appears in quick links and all the info shows up ok on the page that loads up, but how do I get the custom info to appear at the bottom of my forums (home display)


eg like bradhaskins has done http://www.worldlawdirect.com/forum/index.php?

My forums are here

http://www.djpassion.co.uk/forums/misc.php?do=topposters

chris

[webgeek247]

Lol, my bad... its ok I’ve just realised that it's a different hack what Brad used for the bottom of his forums

Err, is there anyway of showing the top 10 posters in a box kinda section at the bottom of the forums though? Or does the top posters feature only in appear in the quick links

[Paul M]

Do you mean the 'Top 5 Stats' stuff ? - Yes, That is another hack that he has installed.

Not sure I understand your second question - you can manually add a link wherever you want.

[webgeek247]

Not sure I understand your second question - you can manually add a link wherever you want.

Ok, so we can manually add a link
is possible to show the top 5 posters at the bottom of the forum though

say where the section DJ Passion.co.uk Forums Statistics is at the bottom of the forum http://www.djpassion.co.uk/forums/index.php

__________________________________________________ ______

Threads: 1,351, Posts: 4,729, Members: 236, Active Members: 236
Welcome to our newest member, DJ Twista

__________________________________________________ _______

Can we not show on there say

__________________________________________________ _____________

Top Forum Posters

1. Matt: 487 - 2. Jason: 367 - 3. John: 356 - 4. Aaron: 353 - 5. Scott: 219

__________________________________________________ _____________

something like that ^ ???

cheers paul
chris

[Paul M]

You would need a seperate modification to do that.

[webgeek247]

You would need a seperate modification to do that.
I found it Paul

ill leave the other hack of yours on too

nice work man

cheers

[Kalina]

One of my members pointed out to me that column 3 should be 14 days instead of 28 since 1 month is already listed in the next column.

In the admin I switched column 3 to 14 days and it's not changing. It's still 28.

NVM, I see now I have to edit a phrase.

If you set it to 30 days then it will display 30 days - the text is a phrase, you need to edit that as well if you change the days.

[Paul M]

JFYI, The 'this month' and '28 days' columns are not the same thing (view them on Nov 1st ;)).

[Snake]

Paul is there a way to get rid of the '28 days' column because I find it very useless? I don't need it when I've got the monthly column, you know.

[Paul M]

You cannot.

See also the post above yours.

[ociosos]

cool thank you!!

:p

[friscogal]

thanks paul!

[Doglet]

This is a great utility, but it has started a fair amount of "post whoring" on my forums, while users try to break 200 posts a day and so on. Is there a way I could make this utility visible only to certain user groups - I am thinking of moderators and administrators? That way, we know what is going on, while normal users cannot see it.

[Doglet]

Where can I find the QuickLinks template to get rid of the Top Posters link? I have a link on the navbar already.

[Paul M]

Disable the plugin labelled "Top Posters (1)".

[iran.gs]

Installed Excelent thanks

[Apfelfrucht]

This is awesome but i need to upgrade my vB 3.6.2 first better ;)

Thanks A lot Paul !!

[tobybird]

Thanks Paul!

[dennisuello]

This is great, I've had installed for a while now. But I just noticed that the Quick Links link doesn't work from CMPS page that's outside of the forum directory. However, Quick Links link work from a PhotoPost Gallery page, that also installed outside of the forum directory. misc.php is listed in the Navbar Replacements. Any help?

[litfoo]

Installed and working very well thanks Paul!

Saw that it adds the link under 'Quick Links' and noticed in the previous posts that one has to manually add it into the 'Navbar' template in order for it to appear on the main page

I know it maybe a pain to a experienced Vbulletin guy like yourself, but I am sure that many other users (myself included) would greatly appreciate a simple step by step guide of how and what to insert in the navbar template for it to appear on the main page

yes, i know that many people are using different themes, but how about starting with the default vbulletin one

Hope you can help and thanks again for the great mod

litfoo

[Qatarinet]

Thank you Paul M

I have question, can I make that count only by threads not by posts?

[Paul M]

No, you would need to rewrite it to do that.

[alawee.blawee]

thx for that lovely hack but i had a problem with putting it in the navbar
coz it didn't work

any help?

[KURTZ]

thx Paul :)

just INSTALLED on 3.6.4

[Masiello]

Thank you Paul!
It's possible to add additional user group? I have some special user group on my forum like "User premium" ,"Special Users" ecc.. how can I add they?

[Paul M]

The settings are in vBulletin Options (Top Posters Section).

[Makc666]

As my ideology s "translate everything you can" it will be cool if you also add a translation string here:

<td class='thead' colspan='$cspan'><div class="smallfont">Version $version : ? Paul Marsden $copyrightyear</div></td>

I made it so :)
<td class='thead' colspan='$cspan'><div class="smallfont">$vbphrase[version] $version : ? Paul Marsden $copyrightyear</div></td>

+ Added this one:
<phrase name="version" date="1152000000" username="Paul M" version="3.24"><![CDATA[Version]]></phrase>

[Paul M]

LOL, I might update it locally (so it's part of any future version) but I'm not releasing an update just for that. :)

[mtlcore]

Is there a way to exclude posts that are made in a certain forum (ie: offtopic forum)? Thanks, great hack! Installed.

[Paul M]

Nope, that is not a feature.

[KURTZ]

updated

thx Paul :)

[adonfun]

Thanks!! Installed it and clicked installed.

Little bit strange question maybe, but where can I see the Top Poster link somewhere inside the forum to check the Top Posters?

[Paul M]

As it says ;

This will also attempt to add a link to the page in your Quick Links.

[Akronica]

Paul, thanks for a great Hack

Can you please tell me how to show it at the bottom of the forum. I am new to VB so some instructions would be really helpful

my site is http://www.qatardeals.com/forum/

Thanks

[Paul M]

This is not designed to be shown anywhere other than on a seperate page (as supplied).

[Mecho]

Thanks Paul M ...

Installed

is it possible that u can make this hack for Top reporter too ?? that would be great i think .

[Terminatoronly]

yeah thats a good idea mecho because this will let the members report more because admins and mods cant see every thing in the site its hard to do this we have many many threads so its hard i wish that paul can make it because he is my favourite coder all of his hacks are the best ;)

[Paul M]

A small update today adds an option for the auto-added link, this can now be in Quick Links, or the Navbar, or Disabled (meaning you will have to add a link in your forum manually).

[KURTZ]

ok Paul thx ;)

obvioulsy updated!

edit: only a Q: why i dont receive any mail for these updates?

[kdemonte]

Mine didn't automatically add to the nav or quicklinks like I enabled. How do I manually add the link in there? (yeah total newbie here, sorry)

[storpappa]

I actually have the same question - the auto add did not work, but going to the link http://gamegeekspeak.com/forums/misc.php?do=topposters
Shows the page.

If somoen can post it here, or a link to it in the site elsewehere - how do we manually add links to the QLinks or navbar?

Ha;py New Year!

[kdemonte]

Mine actually has an error too, now that I manually opened the page an found it:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid, user.username
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE dateline > 1167662990 AND user.usergroupid IN ()
GROUP BY userid ORDER BY postcount DESC LIMIT 10;

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 ')
GROUP BY userid ORDER BY postcount DESC LIMIT 10' at line 4
Error Number : 1064
Date : Tuesday, January 2nd 2007 @ 07:49:50 AM
Script : http://stupidworld.net/misc.php?do=topposters
Referrer :
IP Address : 7**********
Username : ****
Classname : vB_Database
Any ideas how I fix this? Thanks for your help!

[Paul M]

Mine didn't automatically add to the nav or quicklinks like I enabled. How do I manually add the link in there? (yeah total newbie here, sorry)

I actually have the same question - the auto add did not work, but going to the link http://gamegeekspeak.com/forums/misc.php?do=topposters
Shows the page.

If somoen can post it here, or a link to it in the site elsewehere - how do we manually add links to the QLinks or navbar?
You both have customised navbars, so the link add will fail. By the same reasoning I cannot tell you exactly how to edit your styles. You need to add a link to misc.php?do=topposters is all I can really tell you.

[Paul M]

Any ideas how I fix this? Thanks for your help!You appear to have no usergroups specified in the Top Posters > Included User Groups setting (vbulletin options).

[kdemonte]

Thank you.. I uninstalled, reinstalled, everything went fine. Just asking the temmplate designer how to manually add the link now, but it did go automatically into my default template..as you said it would LOL!

[Evil Dave]

I installed this, but I have a Custom Template. How do I get the top posters page to come up??

I am not seeing anything. How do I link it on a custom template?

Thanks for helping the newbie!!

Evil Dave

[Paul M]

I installed this, but I have a Custom Template. How do I get the top posters page to come up??

I am not seeing anything. How do I link it on a custom template?


Please see post #132.

[Tefra]

Installed thanks!

[Paul M]

v3.27 - fixed the table index creation - the index was not being created on install - on larger forums this will speed up the queries this runs.

[storpappa]

Updated - thanks

[KURTZ]

<font color="SeaGreen">UPDATED!</font>

[ncangler]

Thanks for this. I installed for the first time and it did create the quick link but nothing shows up at my sites address: http://www.ncangler.com/forums/misc.php?do=topposters
I'm not sure what I'm doing wrong. I do have a custom Navbar template, but it added the Quick Link and the address looks correct.

[ncangler]

Okay I got it. I need to revert the templates to make it work. :) One caviat though. The automatic script creates the link www.mysite.com/misc.php?do=topposters and my forum location is actually www.mysite.com/forums/misc.php?do=topposters
I know I can go in and manually add the /forums but was wondering if there was something I could do to allow the automatic script to handle it. Thanks for this mod!

[Mum]

Wow, my first install of a product and it's wonderful! Thanks :)

[ncangler]

The Navbar Quick Link works when in the forums page but from any CMPS page the menu link does not include the "/forums" path. I thought adding "misc.php" to the CMPS Navbar replacements would take care of it but it doesn't. Does anyone else have an idea how to make this work with the CMPS navigation in Quick Links? Thanks for any help.

[jw00dy]

Thanks Paul (Updated)

[Paul M]

The Navbar Quick Link works when in the forums page but from any CMPS page the menu link does not include the "/forums" path. I thought adding "misc.php" to the CMPS Navbar replacements would take care of it but it doesn't. Does anyone else have an idea how to make this work with the CMPS navigation in Quick Links? Thanks for any help.It won't work with CMPS unless you manually edit the plugin - replacing misc.php with /forum/misc.php

[ncangler]

Thank you for the reply Paul and for this mod. I hate to be so dense but which file do I need to edit to add the path to misc.php?

[ncangler]

Oh wait, it is the .xml file itself right? (Add "/forums/" to lines 100 and 105?) And then reinstall it?

[ncangler]

I also added it on line 235. I then reinstalled the plugin and it worked like a charm. Thank you! Sorry for all the posts. :)

[encryption]

apologies for I have not gone through the last 10 pages to see if the question was asked (and answered).

but is it possible to display who are the top posters and thread starters in a particular forum ??

[Paul M]

No, that is not possible with this.

[Paul M]

Version 3.29 has had the usergroups option enhanced - you can choose to include or exclude the list of usergroups (or include all usergroups).

[KURTZ]

UPDATED!

[Snake]

Just updated!

[Chadi]

How do I remove the link from the quick links menu where it was inserted automatically?

[Paul M]

Just disable the option.

[Thechipleaders]

ok it's installed

However, when I do the auto link for my navbar it does not work. I am also using CMPS and it does not show up there either. I read the earlier post about changing the code for it but I still have the problem with both navbars.

I'm using zoints on my site as well and using option to put "my blog" link in navbar. However, I clicked that option off and still no top posters link. Other then that I have not done any direct customization.

any suggestions????

[Paul M]

If you use a custom style then the chances are it will fail, you will have to add a link manually.

[Thechipleaders]

yep I certainly did use a custom style.

Ok, will do

thanks

[Exitilus]

Any chance of seeing a feature that will remove non-active users from the list ?

[Paul M]

Nope, not much chance of that.

You could always move your inactive users to a custom usergroup and exclude that group.

[TroyTrojansFan]

Well, I downloaded the zipfile, unzipped it, used the product manager to add the mod, but it is not working. Did I leave out a step? I installed it yesterday. Also, I'm very new to computers, so if I've skipped an obvious step, please advise. Thanks.

[Paul M]

What you did sounds correct. Since you have no links to your site, what do you mean by "not working" ?

[Gazer]

Just added this thanks paul :up:

Regards Gazer

[TroyTrojansFan]

What you did sounds correct. Since you have no links to your site, what do you mean by "not working" ?

Well, what I mean is nothing is showing up on the index.php page. Here is our forum:

http://www.raptureforums.com/forum/index.php

I see the mod in the products manager page and everything, it's just that I don't see anything on the stats area down on the bottom on the index page. Am I suppose to do something else in the admincp? I'm new to doing mods, so I'm not sure if I've missed something?

Thanks for the help. :)

[Paul M]

This does not add anything to the homepage (except a link in the Navbar if enabled) - the information is listed on a new page ;

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

You don't appear to have it installed atm as that link just defaults to the smilies.

[2meplie]

I installed it on my forum but it only installed it on 2 of my 5 styles. I realized that the 3 styles it did not work were those with the word Qlink instead of Quick Link. I can change the templates manualy but don't know which one to change and what to write. Can someone help?
Thanks.

[Paul M]

If you are adding a link manually, you need to point it at misc.php?do=topposters

[2meplie]

Sorry I am fearly new in this. What is exactly the text I need to enter and where, in which template I need to do it?

Thanks.

[tekstylez]

is there any way I can make this only display top thanks?? instead of posts?

[Paul M]

Top thanks ??

[2ndCz]

Great mod. Thanks.

Would either of the following be possible, and if so, how would I do this?

1. Left align the data in each column instead of it being centered.
2. Format the text, ie: smaller font size.

Edit: Thank you Paul, much appreciated. :)

[Paul M]

Edit the template (Top_Posters_bit) to suit.

[brookemegg]

I have installed a left nav bar for our site. (From this mod (https://vborg.vbsupport.ru/showthread.php?t=128702)) Is it possible to put a link to the Top Posters in there? If so, please tell me the code to use. Thanks!

[Paul M]

Sorry, I can't help you with custom set-ups. You would be best asking in the thread you have linked to.

[brookemegg]

Thanks :)

[tekstylez]

Top thanks ??

YES... in reference to the "post thank you" https://vborg.vbsupport.ru/showthread.php?t=122944

[Bonee70]

Where to edit the usergroups?

*never mind - its in the vB options*

[tekstylez]

server not found when visiting http://www.forum.tekstylez.org/misc.php?do=topposters

[Paul M]

That's because you've stuck a www. on the front of url.

[deezelpope]

Installed...thank you much! :up:

[Opus4]

Is there a way change it to also show the top average posts per day, or to at least add that info for the users listed in the Overall column?

[midlandi]

GR8...thanks

[Paul M]

Is there a way change it to also show the top average posts per day, or to at least add that info for the users listed in the Overall column?No.

[Naxon]

Installed :)

[kaptanblack]

Thanks Paul ;)

[coffee]

Installed thank you, Paul ..

Could you please add usergroup tags using fetch_musername() function?

[Lizbaby4]

Maybe I missed this somewhere, but how do you keep the info hidden from guests? Do you set that somewhere in the Admin CP?

I don't want guest to know who is posting or how much on my site.

[deezelpope]

I added it in my Quick Links drop-down.;)

[Paul M]

Maybe I missed this somewhere, but how do you keep the info hidden from guests? There is no facility to hide this from guests.

[z0diac]

navbar template :

search :


<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>

AFTER place this:

<tr><td class="vbmenu_option"><a href="http://www.mysite.com/misc.php?do=topposters">Top Posters</td></tr>


:cool:


SS


Where do I find that template to edit? (what's the filename and dir it's in?)

[deezelpope]

AdminCP>Styles and Templates>Style Manager>Edit Templates>Navigation/Breadcrumb Templates>Navbar

Hope this helps!

[dendrob]

I'm running a posting contest, so I reset all the post counts for all the users to 0, but the mod still shows figures for everyone, is it possible to have the stats reset to zero ? Then after the contest get it back to 'normal' ?

[Paul M]

No.

This counts the actual posts, the only way to get zero would be to delete the posts !

[dendrob]

Paul, would it be possible to have an option (ie. Count photopost comments yes/no) or an add-on to this mod that would count posts in photopost gallery also? I'm in the middle of a posting contest and the contest is being based on stats from your mod. However, the individual user counts increase every time they commend on a photo, but they remain unchanged under the top posters. Just curious - it would be really nice. I'll gladly chip in a donation if you can do this.

[itsblack]

Hey Paul, thank you.

I have a little suggestion: why not add the user info link to the user name? It will be convenient. I have added it myself. Maybe you can consider adding it in the future version?

[Paul M]

Paul, would it be possible to have an option (ie. Count photopost comments yes/no) or an add-on to this mod that would count posts in photopost gallery also? I'm in the middle of a posting contest and the contest is being based on stats from your mod. However, the individual user counts increase every time they commend on a photo, but they remain unchanged under the top posters. Just curious - it would be really nice. I'll gladly chip in a donation if you can do this.Sorry but i don't know anything about photopost, nor do I have access to it. I would not normally add options for specific modifications anyway.

[dendrob]

I know there's a lot of photopost users. Is this something you could do as a premium mod?

[coffee]

Installed thank you, Paul ..

Could you please add usergroup tags using fetch_musername() function?

Please add that Paul .. or at least tell me how to do so.

[coffee]

It would be a great thing if this mod could post a new thread or announcement under the name of forum founder and/or administrator, every end of month:

"Our Top Posters, April 2007"

What do you think?

[Paul M]

musername is deliberately not used as it makes the display look awful, esp on some forums.

There is no chance that ths will ever post a new thread, it was designed purely for real time display, nothing more.

[coffee]

Thank you I understand now ..

[YabbaDabba]

it was designed purely for real time display, nothing more.Thanks for your efforts on this.

Questions:

Are all the stats calculated on the fly everytime the topposters page is requested?
Or are stats just updated periodically, like once a day?
If only periodic updates, is there a cron job that runs and where is it defined?
Is there a server load encountered during install (as it calculates stats)?
Any known issues with php 4 vs. 5?
Any known issues with mysql 4 vs. 5?We have ~2.5 million posts and ~25K posts/week.

Thanks in advance.

[Paul M]

1. On the fly.
2. See 1.
3. See 1.
4. There are no calculations during install.
5. Nope.
6. Nope.

[YabbaDabba]

Thank you for the info

** clicks install**

[Majest]

Great mod, no problems discovered thus far, nice and simple to install and use too. ;)

[cash7c3]

How can I add this as a side bar on my home page? All I need to know is which vbphrase is being used to call the list from the overall top posters..

[Aimee1969]

I like this ;) thank you

[Paul M]

How can I add this as a side bar on my home page? All I need to know is which vbphrase is being used to call the list from the overall top posters..Sorry, I don't quite follow your question.

[cash7c3]

<a href="http://www.modmymoto.com" target="_blank">www.modmymoto.com</a>. On the left, under the Google ad, I have a small table set up with a link to the top posters page at the moment. I would like to have that table actually display the overall top posters for the site.

[Paul M]

You would need a seperate mod to do that.

[coffee]

Works great with vB 3.6.6 !

[FatalBreeze]

Hi! I really wanted to add another column of the rank of each user is the list, perhaps to put a small icon near the three top members in each category (in the three top rows, and have a number of the ranking in the other rows), but i couldn't add another column without messing up your hack completely. can you please upgrade it a bit? thanks.

[Paul M]

I don't really know what you mean by "upgrade it a bit", but I'm not planning any changes to this.

[FatalBreeze]

so can you give a hint on how to add another column (a sixth column) which shows the number of each row (=the rank of each row) please?

[upparoom]

installed, but it only updated some skins.

can you link the code to update manually?

[HoGGeT]

I installed it but some user groups are not shown at top posters
how can I show that at there?

[Lizbaby4]

I know you have been asked this question a ton of times before, but when I went to add the link to the nav bar (I have a custom style) I could not find this:

<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>


Is there someplace else I should put the coding to add the link to the nav bar?

[CMGU]

thanks paul

[WarDoGG]

hey this is a great mod... just 1 thing though... i want it to display the no. of user threads, not the posts... can u plz tell me how this can be done ? editing plugin codeS ?

[joeychgo]

Hey Paul -

Is there a way to pull from this hack - the top posters in the last 28 days - and display just that data someplace else such as a forumhome column or a CMPS module?

[Paul M]

Not directly no.

[Angel-Pie]

installed awesome this will be good for a post a thon!!!!

[njoker555]

I know you have been asked this question a ton of times before, but when I went to add the link to the nav bar (I have a custom style) I could not find this:

<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>


Is there someplace else I should put the coding to add the link to the nav bar?

dont know if u found this already but follow this: go to your header file - not ur navbar file

search for:
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

under it add:

<tr><td class="vbmenu_option"><a href="http://www.yoursite.com/misc.php?do=topposters">Top Posters</td></tr>

i just added the mod, its great :) thanks for it

[Brembo]

I am interest this mod..Unfortunately i don't know how to install it..Can somebody help me please..:o

[deezelpope]

<i>Paul's mod's always come with very easy-to-understand instructions, usually in the first post and/or in the zip file.</i>

[swissbob]

I get a mysql error
http://www.democracyforum.co.uk/misc.php?do=topposters

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid, user.username
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE dateline > 1183988154 AND 1
GROUP BY userid ORDER BY postcount DESC LIMIT;

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
Error Number : 1064
Date : Monday, July 9th 2007 @ 09:35:54 AM
Script : http://www.democracyforum.co.uk/misc.php?do=topposters
Referrer :
IP Address : ***
Username : ****
Classname : vb_database

[Paul M]

You're missing a setting ;

In the vboptions page for this mod, make sure "Set the number of Top Post lines to be displayed" has a value set.

[swissbob]

You're missing a setting ;

In the vboptions page for this mod, make sure "Set the number of Top Post lines to be displayed" has a value set.

Now I just get a blank page :mad: I have tried altering all of the settings, but nothing seems to make a difference.

Thanks for you help, btw.

[Paul M]

I suggest you reinstall the product, sounds a bit like vb failed to import it properly.

[swissbob]

I suggest you reinstall the product, sounds a bit like vb failed to import it properly.
weirdly I had done that before.... but I tried it once more on your suggestion and now it works, thankyou. :)

[aakhan136]

thanks

[ncangler]

I had this working with the 3.27 version but when I upgraded to 3.29 via the XML file I now get this 404 error message:
404 Not Found

The requested URL /misc.php?do=topposters does not exist.
Any suggestions on how I can fix this? Thanks.

[Makc666]

I had this working with the 3.27 version but when I upgraded to 3.29 via the XML file I now get this 404 error message:

Any suggestions on how I can fix this? Thanks.
Uninstall - Install again...

[ncangler]

I uninstalled and installed again, then realized that the Quicklinks link works from forum pages but not from the vBadvanced CMPS home page. So I need to add the /forums/ to the path. But I'm not sure where to do this. Is this the line of code that the script adds to the Quicklinks:
$template_hook[navbar_quick_links_menu_pos2]
If so can I just change this to something like:
<tr><td class="vbmenu_option"><a href="/forums/misc.php?do=topposters">Top Posters</a></td></tr>
Uninstall - Install again...

[Paul M]

Yep, that should work.

[ncangler]

That did it. Thanks Paul!

[control1110]

how do I put this information on my forumhome instead of linking it to a different page

[Paul M]

You can't, it's designed to be a seperate page.

[Tygerwoody]

awesome mod. Thanks :)

[KURTZ]

updated

[ncangler]

I just updated and I'm having the same path problem for my vbA CMPS home page. If I try to add the URL to the NAVBAR code I end up with two Top Posters links in Quick Links and the one installed with the update does not work because it does not have /forums/ in the path.

Where could I edit the template hook to add the path statement or URL to make the new version work? Thanks for this great tool!

[Paul M]

You need to edit the plugin (Top Posters (1)) to change misc.php to /forums/misc.php

I'll probably edit this in a future version to make the path an option in the settings.

[ncangler]

Thank you Paul. That did it! :)

[plastourgos]

good job

[KURTZ]

updated!

(thx Paul)

[ncangler]

Thank you! It works perfectly. Thanks for the path option. :)

[TTG]

Clicking top posters after recent upgrade now takes me to my smilie page and this error :-

/home/f/o/forums/public_html/forums/misc.php(96) : eval()'d code on line 1313

[Paul M]

First, re-install it.

If that fails, uninstall and re-install it.

If that fails then you will need to disable all other modifications using the misc_start hook - if the error still occurs then post it, as it will show the correct line number that is causing the error.

[TTG]

Thanks Paul .. found the problem. It was created by this hack (https://vborg.vbsupport.ru/showthread.php?t=156444&page=6).
Top posters now works fine :up:

[Paul M]

Good to hear. :)

[DJ PİSAGOR]

Hi,

How can we list the people who TOP THREAD STARTER after a specific date ?

Thanks.
Best Regards.