Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons

Reply
 
Thread Tools
Add Usergroup as Moderator Details »»
Add Usergroup as Moderator
Version: 1.0.10, by Andreas Andreas is offline
Developer Last Online: Jan 2023 Show Printable Version Email this Page

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.

Comments
  #122  
Old 01-16-2006, 05:34 AM
stefaandk stefaandk is offline
 
Join Date: Aug 2005
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Also having troubles on vB 3.5.3
MySQL 4.1.16

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.
Reply With Quote
  #123  
Old 02-06-2006, 07:07 PM
Submerge Submerge is offline
 
Join Date: Jan 2006
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Seems to be an error in 3.5.3. Darn, was looking forward to this.
Reply With Quote
  #124  
Old 03-15-2006, 12:52 AM
007's Avatar
007 007 is offline
 
Join Date: Jan 2003
Location: United States
Posts: 872
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Also getting an error.

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;

MySQL Error : Not unique table/alias: 'moderator'
Reply With Quote
  #125  
Old 03-17-2006, 03:11 AM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This query executes just fine for me.
Which mySQL version do you use?
Reply With Quote
  #126  
Old 03-28-2006, 04:16 AM
cOuNtErFiET cOuNtErFiET is offline
 
Join Date: Feb 2006
Posts: 127
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #127  
Old 03-28-2006, 07:53 PM
Raw Sugar Raw Sugar is offline
 
Join Date: Apr 2005
Location: Texas
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #128  
Old 04-11-2006, 07:57 PM
EasyTarget EasyTarget is offline
 
Join Date: Nov 2004
Posts: 660
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cOuNtErFiET
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)
Reply With Quote
  #129  
Old 04-16-2006, 02:05 AM
cOuNtErFiET cOuNtErFiET is offline
 
Join Date: Feb 2006
Posts: 127
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #130  
Old 06-08-2006, 03:49 PM
redlabour's Avatar
redlabour redlabour is offline
 
Join Date: Mar 2004
Location: Wuppertal, NRW, Germany
Posts: 1,541
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Will it work in the Future with vBulletin 3.6 ?
Reply With Quote
  #131  
Old 07-28-2006, 07:33 AM
held held is offline
 
Join Date: Jan 2006
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I was just starting to create this mod, because I feel it should be default in vBulletin.

But since you created it allready, I will install it

Thanks
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:03 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07578 seconds
  • Memory Usage 2,304KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete