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 ?