Mods edit access masks including child forums

There was another version around on the board but it had problems with moderators who had access to moderate a forum through inheritance, ie they were moderator of a category. This code is in no way based on the other version, but no doubt will be similar as there isn't really much of a difference you can make.

This is just really an alternative to letting mods ban people from the whole forum, they can simply ban from a single forum.

Once you have done what it says in the instructions when you add a moderator you will have permission to say if they can edit forum access masks for that particular forum. Remember if they are mod of a category and the edit acccess masks option is enabled then all the forums in this category moderated by the user through inheritance have the ability.

Supermods and Admins can edit all access masks via the mod control panel.

This has been tested on
vb 2.0.1, 2.0.2 and 2.0.3 they all work
also tested on
vb 2.2.0 and 2.2.1 these also work.

I had a small error in the permissions checking for the updateaccess which i just noticed and corrected, so if you have installed this before November 21st it may be advisable to update the /mod/user.php part which involves the updateaccess part.
Not that your mods would want to change access masks for forums they don't mod

[Bitmap]

Originally posted by ladyfyre
will this hack also allow mods of private forums to GRANT access through access masks for their forum????

yes ... i think so

[Snake~eyes]

[QUOTE]Originally posted by ladyfyre
will this hack also allow mods of private forums to GRANT access through access masks for their forum????

[Wayne2k1.com]

Great hack, man!

Exactly what I was looking for.

Thanx.

[Snake~eyes]

I'm havin some problems and getting a dumb error,

help please...

Database error in vBulletin Mod Control Panel 2.2.1:

Invalid SQL: SELECT * FROM moderator WHERE userid=
info[userid] AND (canbanusers=1 OR canviewprofile=1 OR caneditaccess=1)
mysql error: You have an error in your SQL syntax near '[userid] AND (canbanusers=1 OR canviewprofile=1 OR caneditaccess=1)' at line 2

mysql error number: 1064


^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I'm not trying to do anything and I guess this is from adding the moderator hack - that allows mods to edit access masks
i get that error in the email. It's when moderators try to add access


Why am i getting this erro all of a sudden?

Help is appreciated,

thx

[Scott MacVicar]

i have a feeling that

info[userid] should be $bbuserinfo[userid]

don't know where the $bbuser went

[Martz]

Great hack PPN - I'd love to see a usergroup version of this!

[Scott MacVicar]

i'll see what i can do for you, I don't think it should be too much bother though.

[Martz]

Well, instead of having a list of forums which they can grant access on, instead a list of usergroups that they can move the user into. (excluding moderators, admins, or even using a system that checks if the usergroup has a setting such as allowmodchange group checked.


1 optional thing for me would be not to let the user be moved into a different usergroup unless they are in the registered usergroup already. This would mean a moderator (with permission) has to release them from their current group back into registered.

Just a thought, I don't expect anyone to do any of this! The access list one is pretty smart, but usergroups are easier to keep track of imho.

[Snake~eyes]

ya lost me

Could ya give me some idiot proof instructions?

[Scott MacVicar]

open up mod/user.php look for

PHP Code:

SELECT * FROM moderator WHERE userid=info[userid] AND (canbanusers=1 OR canviewprofile=1 OR caneditaccess=1) 


change to

PHP Code:

SELECT * FROM moderator WHERE userid=$bbuserinfo[userid] AND (canbanusers=1 OR canviewprofile=1 OR caneditaccess=1) 


you've copied some of the text wrongly and missed out parts of the query.