Version: 1.0.10, by Andreas
Developer Last Online: Jan 2023
Version: 3.5.0
Rating:
Released: 08-02-2005
Last Update: 01-15-2006
Installs: 177
DB Changes Uses Plugins Template Edits
Additional Files Is in Beta Stage
No support by the author.
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!
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
All works OK functionality wise but when I try to remove the actual moderators group I get this error:
Quote:
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT moderatorusergroupid, 'Moderator_AA</i> from the forum <i>America's Army: The Weapons Cache (Private)' AS title
FROM TOGvB_moderatorusergroup
WHERE moderatorusergroupid = 1;
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 'Army: The Weapons Cache (Private)' AS title
FROM TOGvB_moderatorusergroup
' at line 1
Error Number : 1064
Date : Monday, January 16th 2006 @ 06:30:52 PM
Script : http://10.1.1.199/SITES/V6/forum/adm...rusergroup.php
Referrer : http://10.1.1.199/SITES/V6/forum/adm...rusergroupid=1
IP Address : 10.1.1.150
Username : Admin
Classname : vB_Database
Be a great addition, hopefully this can be resolved.
It happens when editing a custom mod group in 3.5.4:
Quote:
Invalid SQL:
INSERT INTO moderator (userid, forumid, permissions, moderatorusergroupid, modusergroupid)
SELECT user.userid, moderatorusergroup.forumid, moderatorusergroup.permissions, moderatorusergroup.moderatorusergroupid, moderatorusergroup.usergroupid
FROM moderatorusergroup AS moderatorusergroup
LEFT JOIN user AS user ON (user.usergroupid=moderatorusergroup.usergroupid OR FIND_IN_SET(moderatorusergroup.usergroupid, user.membergroupids))
LEFT JOIN moderator AS moderator ON (moderator.userid=user.userid AND moderator.moderatorusergroupid=moderatorusergroup. moderatorusergroupid)
WHERE ISNULL(moderator.userid) AND (NOT ISNULL(user.userid)) AND moderatorusergroup.moderatorusergroupid=3;
is there a way to get the groups so that the group in the moderator column is the same color as the members name (HTML Markup) fro the group? Like if a member is White the Usergroup Color would be white in the moderator column? im sure this is simple just don't know what to put
Is it possible to modify this so that Mods can also view the Style & Templates section and the Forum section? Or does anyone know of a way to change this?
is there a way to get the groups so that the group in the moderator column is the same color as the members name (HTML Markup) fro the group? Like if a member is White the Usergroup Color would be white in the moderator column? im sure this is simple just don't know what to put
yeah, I'd like this change too.
I also got a mysql error when I added a group of which several members were already moderators. It then listed them as moderators twice and when I removed one of the instances from the show all moderators page the error popped up. (although apparently it still removed them and the usergroup, so I just added the usergroup again)
ok i don't think anyone knows what to put to call the HTML markup color for a name...lol no one has answered another post that i have that has to do with this too...might have to ask on vb.com i guess?