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!

[Dean C]

[high]* Dean C wishes this was a default vB features [/high]

[Andreas]

I know it's not an ideal solution, but maybe better then nothing.

[Mephisteus]

*worship*

Thank you kind sir, I really really needed this and you have now saved me valuable time (which I dont have).

Once again, thanks

[edit]
Doesnt work, getting mysql errors all over the place (including when editing a user). When usergroup is added. members of the usergroup (additional) dont have moderator rights.

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

		DELETE FROM moderator AS moderator
		USING moderator AS moderator, moderatorusergroup AS moderatorusergroup
		WHERE moderator.userid = 8
			AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
			AND NOT (moderatorusergroup.usergroupid IN (17, 29,30,32,36));

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS moderator
		USING moderator AS moderator, moderatorusergroup Error Number : 1064
Date         : Wednesday, August 3rd 2005 @ 06:33:22 PM
Script       : forums/admincp/user.php
Referrer     : forums/admincp/user.php?do=edit&u=8
Classname    : vb_database

[jluerken]

Looks like this hack doesn't support table prefixes

[Andreas]

It should support Table Prefixes.
But it needs an up-to-date mySQL Version

@DarkSSJ3
Which mySQL Version do you use?

[Mephisteus]

4.0.24-standard

I have to go out for a bit, when I get back Ill load it back up and go through it more extensivly

[Andreas]

Aargh, there was a Problem with Table Prefixes - 1 Space where it should not have been.
ZIP updated.
Just import the new Product XML to update.

But I still think this isn't the cause for your Problem, as you don't seem to use Table Prefixes?

[Asterik]

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

		DELETE FROM moderator AS moderator
		USING moderator AS moderator, moderatorusergroup AS moderatorusergroup
		WHERE moderator.userid = 9
			AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
			AND NOT (moderatorusergroup.usergroupid IN (2));

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS moderator
		USING moderator AS moderator, moderatorusergroup
Error Number : 1064
Date         : Thursday, August 4th 2005 @ 03:47:21 AM
Script       : admincp/user.php
Referrer     : admincp/user.php?do=edit&u=9
IP Address   : x.x.x.x
Username     : Union Jack
Classname    : vb_database

Yea, i have prefixes and ur newest update and still nothin :surprised:

* BTW * This was from me just editing a user. Nothing more.

[Andreas]

Hmm. Works fine on my Testboard that has a Table Prefix
Which Prefix do you use?