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.

[Angel-Pie]

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

[njoker555]

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

PHP Code:

<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,menubar=no,toolbar=no,scrollbars=yes,resizable=yes,width=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..

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

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

Now I just get a blank page 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]

Originally Posted by Paul M

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