PDA

View Full Version : Allow X Usergroup to view banned members/Users Awaiting email in members list


D3m0n h311ra153
11-18-2014, 09:18 AM
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
11-18-2014, 09:36 AM
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
11-18-2014, 10:57 AM
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
11-18-2014, 11:12 AM
Yes, you don't have to wrap it between parentheses though.

D3m0n h311ra153
11-18-2014, 11:17 AM
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
11-18-2014, 05:20 PM
Try to add $condition variable after the OR, so it looks something like this:
http://pastebin.com/raw.php?i=cQb8Ys4N

D3m0n h311ra153
11-18-2014, 05:55 PM
Trying that I get this invalid SQL error on loading the members list.

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

Dave
11-18-2014, 06:10 PM
Try to change the single quotes (') to double quotes (") of the variable in the 2 hooks.

D3m0n h311ra153
11-18-2014, 06:20 PM
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: