Add Usergroup as Moderator

Add Usergroup as Moderator
Description
This Hack allows you to add a whole Usergroup as Moderators.
(Of course you can not only add but also remove it, change Permissions, etc. )

Details
1 Product XML with 1 Plugin, 16 Phrases and 2 Queries
1 ACP Navigation XML
1 ACP Applet
1 Datamanager Class

History
1.0.0
Initial Version

1.0.1
Fixed a slight Bug regarding Table Prefixes

1.0.2
Removed Multi-Table DELETEs to improve mySQL compatibility

1.0.3
Fixed a missing s that caused Moderator Permissions not being removed when a User is being removed from the Moderator Usergroup

1.0.4
Fixed a Bug regarding Table Prefixes

1.0.5
Code optimization
Usergroup is now being shown instead of individual Moderators on Forumhome/Forumdisplay

1.0.6
Fixed a Problem with conflicting column Names

1.0.7
Added a few checks to prevent Moderators of Moderator Usergroups from being modified/deleted individually

1.0.8
Added Support for moderated public Usergroups as Moderator Usergroup

1.0.9
Fixed a Bug which caused Moderator Usergroups not being displayed properly in subforums.

1.0.10
Fixed a a slight problem that could cause mySQL errors

Please only click Install if you actually have installed/are using this Hack, and click Uninstall whan you don't use it any longer!

[moonclamp]

Would there be anyway to have secret moderator group that doesn't show up in the list?

There have been so many accusations of favouritism on my forum that I don't really want my members to know who the moderators are.

[Abe1]

Originally Posted by jluerken

Uploaded the files, imported the Produkt, made the 2 Template Changes.
I cannot see what I should have done wrong



I have internal clan forums where the clans can organize themself but I don't want to show them on the forum leader page cause they are no forum leaders.
They can manage their forum but they're not belonging to my official staff.
Therefore I turned off the option to show those groups on the forum leader page.
Members who want to know who can moderate the board can still see this if they have access.

I had the same problem. I total removed the hack and moderators from the groups. I then installed the updated hack and it works now.

[BlackxRam]

So is this pretty Stable now with 3.5 Gold?

[thalamus]

Works perfectly for me Thanks for this, saves a lot of time *installs*

[Stephen3]

will effect when upgrade to 3.5.2 or higher?

[edbri871]

I was looking for hack to allow a usergroup to be able to delete and merge thier own posts only within a certain section. The delete part was simple but not the merge. An alternative to have forum moderators so that they have the ability to mod only a paticular forum although the prior would be preffered.

I was linked to this thread and Im not sure if its what Im looking for though I could be mistaken. If this can do what I need maybe someone could let me know and if not could anyone figure how I can do what Im looking for...

Thanks.

[edbri871]

The above post can be ignored since Ive figured how to do what I wanted now...

[SmEdD]

Under "Show All Moderators" if I have them in a usergroup which is a group for Moderating a forum and I click " [Remove this Moderator from All Forums]" it prompts me to download moderator.php . . .

[redlabour]

Updated to 1.0.9 today - my Group "Moderators" is still not shown. Of course i tryed to deinstall and reinstall.

Frist thing i see - it is still in german but it have taken this english Version here now. What?s going wrong there ? :ermm:

Admin and Supermoderators works fine in the same Category.

Fixed a Bug which caused Moderator Usergroups not being displayed properly in subforums.

So this is not working in my Eyes .... and of course i have uploaded the new Files and edited the Templates.

Update : After the Update my Moderators where "registered Users" after a manually Change for each one to Moderators again it works.

[exegete]

Am experiencing errors.

They occur when I attempt to use the "Remove this Moderator from All Forums" function (ACP -> Forums & Mods -> Show All Mods), and the moderator I am attempting to de-mod is a member of one or more moderator usergroups added with this extension.

The action appears to be performed successfully, so everything continues to operate correctly, but the errors appear on the redirection page nonetheless.

MySQL 4.0.25
vB 3.5.3

Warning: mysql_query(): 5 is not a valid MySQL-Link resource in /includes/class_core.php on line 404

Warning: mysql_error(): 5 is not a valid MySQL-Link resource in /includes/class_core.php on line 846

Warning: mysql_errno(): 5 is not a valid MySQL-Link resource in /includes/class_core.php on line 864

...

Database error in vBulletin 3.5.3:

Invalid SQL:

				INSERT INTO moderator (userid, forumid, permissions, moderatorusergroupid, modusergroupid)
				SELECT 4288 AS userid, moderatorusergroup.forumid, moderatorusergroup.permissions, moderatorusergroup.moderatorusergroupid, moderatorusergroup.usergroupid
				FROM moderatorusergroup AS moderatorusergroup
				LEFT JOIN moderator AS moderator ON (moderator.userid = 4288 AND moderator.forumid=moderatorusergroup.forumid AND moderator.moderatorusergroupid=moderatorusergroup.moderatorusergroupid)
				WHERE moderatorusergroup.usergroupid IN (5)
					AND ISNULL(moderator.moderatorid);

MySQL Error  : 
Error Number : 
Date         : Friday, January 13th 2006 @ 01:21:45 AM
Script       : http://community.boredofstudies.org/admincp/moderator.php
Referrer     : http://community.boredofstudies.org/admincp/moderator.php?do=removeall&u=4288
IP Address   : 203.214.152.105
Username     : Lazarus
Classname    : vb_database

It is otherwise a very nice extension. Thank you.