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!

[Andreas]

Not at all, this is a vBulletin 3.5 Hack and not compatible with vBulletin 3.0.

[diretur]

Originally Posted by KirbyDE

Not at all, this is a vBulletin 3.5 Hack and not compatible with vBulletin 3.0.

thank you for the quick reply. I will wait for vb 3.5 :disappointed:

[Andreas]

You can just download it: http://www.vbulletin.com/members

[Boofo]

How come you never send update notices when you update your hacks, sir?

[Andreas]

I only send Updates when critical Bugs have been fixed.
Most of my Hacks are Beta and thus are being updated frequently so I think it's not necessary to always send eMail - just seems messy.

[Boofo]

But with so many hacks from you, it's hard to keep up on updates. Maybe an update notice every other update or something?

[WNxWakko]

I had a member remove all the names listed in a forum I used this mod to add. The front of the forum just shows the usergroup as the mod, but when viewing in the admincp you see all the members who have mod over it.

My question is, if someone removes a name manually by mistake, is something going to autoadd them back? or am I going to have to delete the add usergroup in your panel and readd every single time?

[Andreas]

If you manually delete a Moderator, you must edit the User and change his Usergroup twice - then he will be in again.
Hmm, maybe I could add some Code to prevent changing individual Moderators (that are Mderatros because they are in a Moderator Usergroup).

[WNxWakko]

Originally Posted by KirbyDE

Hmm, maybe I could add some Code to prevent changing individual Moderators (that are Mderatros because they are in a Moderator Usergroup).

Oh please do. I have a very very large forum. Over a million posts, I Have 21 Administrators and its very likely for people to make this mistake.

[diretur]

I installed this hack yesterday evening. Now I get sometimes this database error email:

Database error in vBulletin 3.5.0:

Invalid SQL:

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

MySQL Error : INSERT TABLE 'vb3_moderator' isn't allowed in FROM table list
Error Number : 1093

It happens when somebody tries to register. Now I uninstalled the mod and the registration works again.

any ideas?

thanks