Miscellaneous Hacks - Top Posters

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.

[Paul M]

Originally Posted by 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

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]

Originally Posted by wolfyman

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]

Originally Posted by wolfyman

show me some love paul, pleeeeeeease

Huh ?