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]

Hmm, this Query works just fine for me.
Which mySQL Version do you use?

[diretur]

3.23.58-log

[diretur]

wait, maybe I have it!
Table 'db32351_14.vb3_moderatorusergroup' doesn't exist

I did't create any table because I haven't seen it in the readme file!

[diretur]

sorry for the chaos: now I uninstalled the mod, so the table should have been deleted from the database. right?

[Andreas]

I think that 3.23 is too old.
The table should have been automatically created by the product install code.

[trilljester]

Kirby: Can you limit this usergroup's moderator functions, meaning, they can have the same limitations as moderators as a single user moderator, right? Like if I don't want them deleting posts or what not, I can restrict that, correct?

[JohnBee]

Okay I installed this mod and the first thing I noticed is when I try to edit any of the usergroups i get an SQL dB error. I tried to deactivate the hack and make the changes but it still does the same so I guess there have been changes made to the tables that cause the error.

I will try and uninstall then try to edit the usergroups to see if the same problem occurs. One thing for sure is once the hack is installed, it almost certainly leads us to edit or refine the usergroups to better fit the group system in forum home so the SQL error will almost definately take place.

Okay I uninstalled the hack and the error still occurs so I guess the MOD is noit cleaning up the tables after uninstallation.

Here is the error

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Site moderator',
	`description` = '',
	`usertitle` = '',
	`opentag` = '<span style=\"color: #6A0000;\">',
	`closetag` = '</span>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`forumpermissions` = '1048575',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '1',
	`pmsendmax` = '5',
	`calendarpermissions` = '63',
	`wolpermissions` = '15',
	`adminpermissions` = '0',
	`genericpermissions` = '204193695',
	`genericoptions` = '23',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '120',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '100',
	`avatarmaxheight` = '120',
	`avatarmaxsize` = '50000',
	`imghost` = '0'
WHERE usergroupid=7;

MySQL Error  : Unknown column 'imghost' in 'field list'
Error Number : 1054
Date         : Thursday, October 6th 2005 @ 03:57:34 PM
Script       : http://www.mysite.com/www/forum/admincp/usergroup.php
Referrer     : http://www.mysite.com/www/forum/admincp/usergroup.php?do=edit&usergroupid=7
IP Address   : ***.***.**.**
Username     : Xxxxxx
Classname    : vb_database

Looking forward to a fix.

[Mephisteus]

Its messing up at the imghost field. Its neither a defeault field nor is it part of this hack, Id be looking at another hack... (though I do not know which one, Im guessing one that hosts images on a usergroup basis or something )

@trilljester, yes it does

[Andreas]

@trilljester
The permissions are the same as for normal moderators.

@JohnBee
Field imghost definitely has nothing to do with this Hack, so this error is caused by another Hack.
=> Remove all Bitfield XMLs from Hacks you don't use (any longer) and rebuilt the bitfield cache.

[trilljester]

Awesome. Thanks for this, Kirby! I really wish this was a feature in VBulletin, I'm surprised it's not. It's actually a feature in most forum softwares.