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

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

Thanks Paul M ...

Installed

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

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 ;)

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).

ok Paul thx ;)

obvioulsy updated!

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

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?

Ha;py New Year!

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!

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.

You appear to have no usergroups specified in the Top Posters > Included User Groups setting (vbulletin options).

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!

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

Please see post #132.

Installed thanks!

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.

Updated - thanks

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

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.

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!

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

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.

Thanks Paul (Updated)

It won't work with CMPS unless you manually edit the plugin - replacing misc.php with /forum/misc.php

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?

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

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. :)

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 ??

No, that is not possible with this.

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

Just updated!

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

Just disable the option.

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????

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

yep I certainly did use a custom style.

Ok, will do

thanks

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

Nope, not much chance of that.

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

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.