vb.org Archive

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)

ack 08-23-2005 12:38 PM

Bah. Okay. I figured. It's all right. This code alone makes my life so much easier. Thanks a bunch. ^_^

ack 08-24-2005 03:29 AM

Sorry. This isn't a big deal, but I just thought I'd let you know that I got this error.

Code:

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

                SELECT moderatorusergroupid FROM stbb_moderatorusergroup
                WHERE NOT (moderatorusergroup.usergroupid IN (18, 10,15));

MySQL Error  : Unknown table 'moderatorusergroup' in where clause
Error Number : 1109
Date        : Tuesday, August 23rd 2005 @ 09:27:14 PM
Script      : http://www.mb.surrealtwilight.com/admincp/user.php
Referrer    : http://www.mb.surrealtwilight.com/admincp/user.php?do=edit&u=978
IP Address  : 24.60.79.69
Username    : ack
Classname    : vB_Database

It happens when I change the usergroups of a specific user. I change them and then save the changes, and I get that message. However, when I go back to check to see if it actually went through, it does. So it's an error that's easy to ignore, because everything still works fine.

Andreas 08-24-2005 08:26 AM

I hate Table-Prefixes ...
It doesn't work properly, the Moderator Permissions won't get updated when you get this error.

Reimport Version 1.0.4 and check if it works then.

ack 08-24-2005 02:16 PM

Sweet, no error anymore. Thanks! And sorry I've been such a pain. T_T;

Yorixz 08-29-2005 02:14 PM

I can't wait till vB3.5 goes final, especially now I see this mod is there; I've been missing this since I switched from IPB to here ;)

Thanks a lot!

ForYou 08-29-2005 03:56 PM

Hello , realy it is very nice hack :)

my request now , I need when i Add New Moderator Usergroup to Forum the users that in the group will not shwoing on the main forum , I mean i don't need to let the members know how is Moderator of some forum , can i hide the names of Moderator when i allow it ,

I hope u understand me ,

Regards

Andreas 08-29-2005 04:09 PM

Yes I understood you. But it is not possible.

Andreas 08-29-2005 04:51 PM

Version 1.0.5 is now available
For changes, see frist Post.

To upgrade, overwrite the existing Files, import the Product XML (Overwrite=Yes!) and make the Template Edits.

ForYou 08-31-2005 10:28 PM

Hello sir ,

Is there a way to put the option let the admin if he need to swho them on the forumHome or not , please try to do that if it can

regards

Andreas 08-31-2005 10:29 PM

Once again in English please :)

ForYou 08-31-2005 10:36 PM

:) hello , sorry for my english lang , I know that is bad :( sorry ,

any way ,
I mean , when i add any group for Mod , I don't need to show that name on the ForumHome , just I need to give him permisions without put there names on ForumHome ,

I hope you understand me ,

Regards

Andreas 08-31-2005 10:38 PM

Disable Moderator Column in vBulletin Options, then the Moderators don't show up there.
But IMHO Users should know who is Moderator, so they can contact them when there are Problems.

ForYou 08-31-2005 11:16 PM

Hello ,

Look !!

when I need to remove Mod from the orginal list , what is the wrong



Invalid SQL:

SELECT user.userid, usergroupid, username, displaygroupid, moderatorid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
WHERE moderatorid = 114;

MySQL Error : Column 'usergroupid' in field list is ambiguous
Error Number : 1052
Date : Thursday, September 1st 2005 @ 12:14:59 AM
Script : http://www.XXXX.net/xx/admincp/moderator.php
Referrer : http://www.XXXX.net/xx/admincp/moderator.php
IP Address : 83.244.4.145
Username : XXXX
Classname : vb_database

Andreas 09-01-2005 12:28 AM

Fixed in 1.0.6

ForYou 09-01-2005 12:48 AM

Thank you :) evry thing is OK

Yorixz 09-03-2005 04:49 PM

Does this mod also allow you to add the usergroup to multiple forums at once (similar to the "Easy Add Moderator Hack" for vB3.0.x ) ? It would be great if that's also an option :)

Andreas 09-03-2005 05:19 PM

No, it does not.

ack 09-12-2005 01:49 PM

Thanks for adding the whole usergroup instead of usernames thing. It looks so much better now. ^_^ You're awesome, and I think I wish to marry you. :|!

Brinnie 09-12-2005 04:21 PM

Hello,

The instructions do not tell where to upload the php files. I am confused. :confused:

Abe1 09-15-2005 03:03 PM

KirbyDE, a mod set to be a moderator threw this system, can use the inline mod tools on the forumdisplay page but not on the showthread page. All that shows up is the top drop down asking what boxes you want to check or uncheck at once, and the actual check box. There is no drop down menu at the bottom and when you click a check box, you get an error on the page.

Andreas 09-15-2005 03:09 PM

I am almost sure that this can't be caused by this Hack.
Can you reproduce this effect with unmodified Files, unmodified Style and all Plugins/Products except this one disabled?
If so: Which error exactly do you get where, and how to reproduce?

Abe1 09-15-2005 04:25 PM

Quote:

Originally Posted by KirbyDE
I am almost sure that this can't be caused by this Hack.
Can you reproduce this effect with unmodified Files, unmodified Style and all Plugins/Products except this one disabled?
If so: Which error exactly do you get where, and how to reproduce?

I disabled plugins and found that there was still a problem. Now, if I moved a user normaly to moderator, there was no problem. So it seems like it has to do with this hack.

Here is a way to reproduce:
1) make a usergroup a moderator group
2) add a user to that group
3) go view a showthread page.

Andreas 09-15-2005 04:38 PM

OK, i've created a Moderator Usergroup, assigned this to a Forum.
Then I added a User to this Group (secondary Usergroup).
I logged in as this User, acessed a Thread in this Forum.
All moderation Elements were visible, I tested close/open and stick/unstick - worked just fine.

So what Problems should I face?

Abe1 09-15-2005 04:46 PM

Quote:

Originally Posted by KirbyDE
OK, i've created a Moderator Usergroup, assigned this to a Forum.
Then I added a User to this Group (secondary Usergroup).
I logged in as this User, acessed a Thread in this Forum.
All moderation Elements were visible, I tested close/open and stick/unstick - worked just fine.

So what Problems should I face?

It shound like to tested in forumdisplay. Go into a thread and check. When veiwing posts.

Andreas 09-15-2005 04:48 PM

Quote:

Originally Posted by KirbyDE
I logged in as this User, acessed a Thread in this Forum.

I was on showthread :)
So which errors do appear where exactly?

I need exact information on how to reproduce them.

Abe1 09-15-2005 04:51 PM

Quote:

Originally Posted by KirbyDE
I was on showthread :)
So which errors do appear where exactly?

I need exact information on how to reproduce them.

no error shows. You just cant see the drop down menu on the bottom that has options like merge posts.

Andreas 09-15-2005 04:57 PM

You mean the Inlinemod-Dropdown?
It's there for me.

Abe1 09-15-2005 04:59 PM

Quote:

Originally Posted by KirbyDE
You mean the Inlinemod-Dropdown?
It's there for me.

OK. I'm going to do some more tests.

Andreas 09-15-2005 05:01 PM

Frist thing to check would be the Permissions for the Group ;)

diretur 09-20-2005 09:30 AM

I am a newbie in vb3 so sorry for the stupid question.
You say:
Quote:

Import product-modusrgrp.xml
How should I import it? I am using vb 3.0.9

thank you

Andreas 09-20-2005 09:31 AM

Not at all, this is a vBulletin 3.5 Hack and not compatible with vBulletin 3.0.

diretur 09-20-2005 09:37 AM

Quote:

Originally Posted by KirbyDE
Not at all, this is a vBulletin 3.5 Hack and not compatible with vBulletin 3.0.

thank you for the quick reply. I will wait for vb 3.5 :disappointed:

Andreas 09-20-2005 09:46 AM

You can just download it: http://www.vbulletin.com/members

Boofo 09-20-2005 09:58 AM

How come you never send update notices when you update your hacks, sir? ;)

Andreas 09-20-2005 10:00 AM

I only send Updates when critical Bugs have been fixed.
Most of my Hacks are Beta and thus are being updated frequently so I think it's not necessary to always send eMail - just seems messy.

Boofo 09-20-2005 10:10 AM

But with so many hacks from you, it's hard to keep up on updates. Maybe an update notice every other update or something? ;)

WNxWakko 10-04-2005 02:54 AM

I had a member remove all the names listed in a forum I used this mod to add. The front of the forum just shows the usergroup as the mod, but when viewing in the admincp you see all the members who have mod over it.

My question is, if someone removes a name manually by mistake, is something going to autoadd them back? or am I going to have to delete the add usergroup in your panel and readd every single time?

Andreas 10-04-2005 09:16 AM

If you manually delete a Moderator, you must edit the User and change his Usergroup twice - then he will be in again.
Hmm, maybe I could add some Code to prevent changing individual Moderators (that are Mderatros because they are in a Moderator Usergroup).

WNxWakko 10-05-2005 09:22 PM

Quote:

Originally Posted by KirbyDE
Hmm, maybe I could add some Code to prevent changing individual Moderators (that are Mderatros because they are in a Moderator Usergroup).


Oh please do. I have a very very large forum. Over a million posts, I Have 21 Administrators and its very likely for people to make this mistake.

diretur 10-06-2005 06:46 AM

I installed this hack yesterday evening. Now I get sometimes this database error email:

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO vb3_moderator (userid, forumid, permissions, moderatorusergroupid, modusergroupid)
SELECT 3850 AS userid, moderatorusergroup.forumid, moderatorusergroup.permissions, moderatorusergroup.moderatorusergroupid, moderatorusergroup.usergroupid
FROM vb3_moderatorusergroup AS moderatorusergroup
LEFT JOIN vb3_moderator AS moderator ON (moderator.userid = 3850 AND moderator.forumid=moderatorusergroup.forumid AND moderator.moderatorusergroupid=moderatorusergroup. moderatorusergroupid)
WHERE moderatorusergroup.usergroupid IN (3)
AND ISNULL(moderator.moderatorid);

MySQL Error : INSERT TABLE 'vb3_moderator' isn't allowed in FROM table list
Error Number : 1093
It happens when somebody tries to register. Now I uninstalled the mod and the registration works again.

any ideas?

thanks


All times are GMT. The time now is 05:20 AM.

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.01426 seconds
  • Memory Usage 1,820KB
  • 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
  • (1)bbcode_code_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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