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!

[Asterik]

Silly me, actually i have no prefix. :P. But it gives me the same error eventhough I did set a usergroup as moderator of a forum o_O.

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 = 11
			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 @ 04:13:59 AM
Script       : admincp/user.php
Referrer     : admincp/user.php?do=edit&u=11
IP Address   : x.x.x.x
Username     : Union Jack
Classname    : vb_database

[Andreas]

That's what I thought.
Seems like your mySQL Version does not support this Query Syntax.

Can you try the following Query in phpMyAdmin if it generates errors?

[sql]
DELETE moderator FROM moderator AS moderator, moderatorusergroup AS moderatorusergroup
WHERE moderator.userid = 11
AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
AND NOT (moderatorusergroup.usergroupid IN (2));
[/sql]

[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 = 11
			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

hmm..... Ran ur query but it went through, but i still get this

:: EDIT :: Actually it didn't delete anything :I

[Mephisteus]

I have the same as Asterik. When editing a user it gives me that error.

[Marco van Herwaarden]

Originally Posted by KirbyDE

That's what I thought.
Seems like your mySQL Version does not support this Query Syntax.

Can you try the following Query in phpMyAdmin if it generates errors?

[sql]
DELETE moderator FROM moderator AS moderator, moderatorusergroup AS moderatorusergroup
WHERE moderator.userid = 11
AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
AND NOT (moderatorusergroup.usergroupid IN (2));
[/sql]

That is a completly different query.

PS Not all MySQL versions support multi table deletes.

[Mephisteus]

The only place where I get that error is when editing a user. Also (the user already is a part of that group) the user doesnt have moderator rights.

[Asterik]

Originally Posted by DarkSSJ3

The only place where I get that error is when editing a user. Also (the user already is a part of that group) the user doesnt have moderator rights.

Exactlly the same .

[Andreas]

Hmpf. Ppl should use more up-to-date mySQL Versions
OK, doing it the old-fashined way then - without multi-table DELETEs.

[Mephisteus]

Woho! Pretty please let us know when its updated

[Andreas]

Will do.
Btw: If you add a Usergroup that already has Members (be it primary or secondary) as Moderator, do these members get Moderators?