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.

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

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

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

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.