vb.org Archive
Page 1 of 21 1 2311 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Add Usergroup as Moderator (https://vborg.vbsupport.ru/showthread.php?t=93543)

Andreas 08-02-2005 10:00 PM
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!

Dean C 08-03-2005 06:52 PM
[high]* Dean C wishes this was a default vB features :)[/high]

Andreas 08-03-2005 06:54 PM
:)
I know it's not an ideal solution, but maybe better then nothing.

Mephisteus 08-03-2005 09:26 PM
*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.

Code:
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

jluerken 08-04-2005 08:51 AM
Looks like this hack doesn't support table prefixes :D

Andreas 08-04-2005 08:59 AM
It should support Table Prefixes.
But it needs an up-to-date mySQL Version

@DarkSSJ3
Which mySQL Version do you use?

Mephisteus 08-04-2005 09:09 AM
4.0.24-standard

I have to go out for a bit, when I get back Ill load it back up and go through it more extensivly

Andreas 08-04-2005 09:23 AM
Aargh, there was a Problem with Table Prefixes - 1 Space where it should not have been.
ZIP updated.
Just import the new Product XML to update.

But I still think this isn't the cause for your Problem, as you don't seem to use Table Prefixes?

Asterik 08-04-2005 09:48 AM
Code:
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 = 9
                        AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
                        AND NOT (moderatorusergroup.usergroupid IN (2));

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        : Thursday, August 4th 2005 @ 03:47:21 AM
Script      : admincp/user.php
Referrer    : admincp/user.php?do=edit&u=9
IP Address  : x.x.x.x
Username    : Union Jack
Classname    : vb_database
Yea, i have prefixes and ur newest update and still nothin :surprised:

* BTW * This was from me just editing a user. Nothing more. ;)

Andreas 08-04-2005 10:04 AM
Hmm. Works fine on my Testboard that has a Table Prefix :(
Which Prefix do you use?


All times are GMT. The time now is 08:10 PM.
Page 1 of 21 1 2311 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01229 seconds
  • Memory Usage 1,737KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete