Then I have no idea, and don't really see how it's possible, mysql should return what you ask it for.

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.

The actual code is identical to the 3.5 version.

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

Any advice here, plz?

Br.

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

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

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

Remove the comma after the 11 in the usergroup settings.

show me some love paul, pleeeeeeease :)

Huh ?

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.

"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:


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

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.

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

Perhaps to save himself/herself the trouble of fixing something that wasn't actually broken. :cool:

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.

Sweet.
Thankyou :)

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

No, there is no such facility.

Installed - working!

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

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

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?

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

Very nice .
Thank you.

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.

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

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

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

Thanks!

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

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

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?

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

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.

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/...?do=topposters )

There is no way to do that, it would need a new section of code writing.

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.

The usergroups included is part of the options, add all the groups you want to include (the default is 2,5,6,7).

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

Look it up in the usergroup manager.

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?

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.

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. The link is on navbar.

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.