[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