Allow X Usergroup to view banned members/Users Awaiting email in members list

[D3m0n h311ra153]

First of all, I am not a coder, so be gentle

Is their a way to show only a particular usergroup (i.e. Admins #6), banned members and users awaiting email, in the members list?

I obviously select yes in "Usergroup Manager/Banned/Usergroup Options/Viewable on the Memberlist" and "Usergroup Manager/Users Awaiting Email Confirmation/Usergroup Options/Viewable on the Memberlist", to show the usergroup's, but what extra code is needed to NOT show these particular usergroup's other than to the Admins usergroup?

I have already made some modifications to the memberslist.php file and memberslist style, to allow me to only show Admins a UserID column with sort, but for it to be any use to me, I require ALL members to be shown to the Admins Usergroup and not have certain usergroups filtered out.

[Dave]

Create 2 hooks for this:

memberlist_fetch and memberlist_query_userscount with contents http://pastebin.com/raw.php?i=tQA4wJDv

Had to create a pastebin link with the code since vBulletin.org its firewall decides to block my post request.
You can easily modify the numbers in it to satisfy your needs.

[D3m0n h311ra153]

Thanks Dave

Works a treat, although I did have to reset the banned and email confirmation usergroups back to "not shown on members list"

Quick question, If I change this line "user.usergroupid IN (3,8)" to "user.usergroupid >= (2)" will that select all usergroups equal to and above usergroup 2?

I have tried it, and it appears to work, but I would prefer to know that I have done this correct .

[Dave]

Yes, you don't have to wrap it between parentheses though.

[D3m0n h311ra153]

Thanks again Dave

Perfect for my needs

EDIT: Just found a problem, The hook doesn't allow for sorting the usernames via the letters A, B, C etc. Any chance of a re-work to fix that?

[Dave]

Try to add $condition variable after the OR, so it looks something like this:
http://pastebin.com/raw.php?i=cQb8Ys4N

[D3m0n h311ra153]

Trying that I get this invalid SQL error on loading the members list.

MySQL Error : Unknown column '$condition' in 'where clause'

[Dave]

Try to change the single quotes (') to double quotes (") of the variable in the 2 hooks.

[D3m0n h311ra153]

Tried it and no errors, but we're back to the same problem in my edit in post #5

EDIT: Sorry my mistake, I entered an extra OR instead of an AND.

Thanks Dave, it's all working as it should :up: