Mod Name / Version - Group Moderators v1.0<br /><br />Description - Allows administrator to set permissions for selected moderators to add and optionally remove users from selected groups. Adds links to new pages for admin and mods in admin menu.<br /><br />Example - None.<br /><br />Pre-requisites - none<br /><br />Author - Aglavalin, aka Steve Stout<br /><br />Files Altered - admin/menu.php<br /><br />Database Altered - Only a new table is created, thus, very removable.<br /><br />New Files - admin/pickuser.php, admin/editusergroup.php, admin/doeditusergroup.php, admin/editgroupmod.php and admin/doeditgroupmod.php<br /><br />Credits: I have seen this asked for several times on the threadsdev.com boards.<br /><br />Notes: This is a simple hack. Group Moderators need to be in the UBBT moderator group to access the pages via admin menu, but they do not need to be a board moderator. The ability to remove a user from each group a moderator can add users to is optional. i.e A moderator can add a user to a group, but not remove anyone from that group if the admin desires. Works fine on 6.1<br /><br /><br />This seems to be working fine so far, so I'm gonna release it. It is beta, and will probably evolve some before being finished. I have added in as many security checks as I can think of, but if anyone can find any loopholes please let me know!

OH MY!!! Ok, let me get this straight.<br /><br />Here is my situation. My site is just a massive general regional site. And within my site there are many official "clubs", and they have been bugging me to host their message boards within my current board system, and obviously make them private to only group members.<br /><br />So, that is great, but I had to wait for a PM from the club owner with a list of names to add to that usergroup. So, are you saying I make the private forums, and setup the mod for those forums only. I can then grant them privilages to add anyone to only THEIR usergroup? <br /><br />If that is how I understand it, that is an incredible and essential mod for me, as I do not have time/energy to do this for them.

Yes, you can make a group just for one forum, or category, and assign as many people as you like to add and/or delete users from that group. I have this issue on my boards, where I have at least 5 groups that I get PMs on to add people almost every day, so I got tired of it and now I have assigned one person from each group to just do it themself! I also use these groups to allow access to sections of the website, so now the new users can gain access faster since I don't have to be in the loop anymore <img src="/forum/images/icons/smile.gif" alt="" />

That is awesome. Best mod ever as far as I'm concerned, lol.<br /><br />I will apply it later today. YOu just made my life a whole lot easier!

Very nice mod indeed, this will certainly make it easier for the admin when there are many sub-boards that new users have to be added to on a regular basis. I've had a few of these myself, but the only one that is active at the moment aren't adding any new members anymore. But if any of the boards gets active and wants to have more members I will definitely install this.

I just had a bad thought about this. I need to add the ability for it to prevent someone from editing the groups of admins and moderators. I'll come up with a new version which has a couple more options for the admin to check off groups which will prevent their members from having ANY of their groups modified. This should take care of this issue. This would only be some page replacements, and would only matter in rare cases. This hack is still safe as long as you don't give the authority to boneheads or someone who is in a foul mood. LOL

Here is an updated zip with a fix to block all admins and moderators from having any of their groups edited. Only editusergroups.php was changed.

Anyway we could get the add a user to a group to be like the search system built into UBBT??

Hmm.. I got an error when running this query:<br /><pre><font class="small">code:</font><hr>CREATE TABLE w3t_Groupmods (<br /> GM_Username varchar(30) NOT NULL,<br /> GM_AddGroup tinyint(3) DEFAULT '3' NOT NULL,<br /> GM_RemoveGroup carchar(1) NOT NULL,<br /> KEY GM_Username (GM_Username)<br />);</pre><hr><br /><br />I know in the instructions it says it will give an error but the table will be created correctly. But.. I checked, the table was not created. It gave this as a response:<br /><br />[]You have an error in your SQL syntax near 'carchar(1) NOT NULL,<br /> KEY GM_Username (GM_Username)<br />)' at line 4<br />[/]

Looks like another one of my typos there. That code should be<br /><br /><pre><font class="small">code:</font><hr><br />CREATE TABLE w3t_Groupmods (<br /> GM_Username varchar(30) NOT NULL,<br /> GM_AddGroup tinyint(3) DEFAULT '3' NOT NULL,<br /> GM_RemoveGroup varchar(1) NOT NULL,<br /> KEY GM_Username (GM_Username)<br />);<br /></pre><hr><br /><br />Attached are correctied directions.

Thanks, that worked <img src="/forum/images/graemlins/smile.gif" alt="" />

Hmm, just got around to actually putting this hack into action, and encountering a problem when trying to add someone:<br /><br />[]SQL ERROR: Database error only visible to forum administrators<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/www/michiganjeepers/forums/mysql.inc.php on line 121<br />[/]<br /><br />Every other feature works, except that one. And also.. why do the group mods have ability to ban users? That may not be too safe if it is a public ban, or is it just a ban from their forum?

Ok... problem!<br /><br />Not sure if this was the intended use or not, but moderators, whether or not they are group mods have access to the "admin" link, and they can edit the forum they are a mod in!! I don't want that feature.. could be potentially very dangerous <img src="/forum/images/graemlins/frown.gif" alt="" />

The mods have had that ability for a while, there is a hack for it around here. One that you can turn off some of their abilities, like editing the forum!

Really? I have just recently started adding mods, but I had no idea they had these abilities! I just don't like the idea of a mod getting ticked off and purging all of the threads in their forum, or banning people for no reason, etc. I mean I trust them as mods, but not with some admin functions.<br /><br />I will have to look to see if I can find that hack you are talking about.<br /><br />Also, I am still getting that error when trying to add someone to a group, so if you have time and could look at that, that would be great <img src="/forum/images/graemlins/smile.gif" alt="" /> Thanks.

Restrict Moderators may be the hack you're looking for.

Thanks Dave, yes that is what I was looking for. Any idea if it works under 6.1?

I'm using it under 6.1. When I upgrade UBB.threads, though, I use Beyond Compare, rather than re-installing hacks individually.<br /><br />I think the only change needed is to use {$config['tbprefix']}Users instead of w3t_Users, in the changes to admin/showstats.php. And that really only matters if you're using, or may be using in the future, a custom table prefix other than "w3t_".<br />

Thanks, got it working great. Now.. if I could just get the SQL permissions error figured out, I'll be good to go <img src="/forum/images/graemlins/smile.gif" alt="" />

Aglavalin, any idea on what might be causing the SQL permissions errors? I'm sure its something simple, but I have retraced my steps and can't see an obvious problem <img src="/forum/images/graemlins/frown.gif" alt="" />