PDA

View Full Version : Add Usergroup as Moderator


Andreas
08-02-2005, 10:00 PM
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
* Dean C wishes this was a default vB features :)

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.

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
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?

Asterik
08-04-2005, 10:15 AM
Silly me, actually i have no prefix. :P. But it gives me the same error eventhough I did set a usergroup as moderator of a forum o_O.


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 = 11
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 @ 04:13:59 AM
Script : admincp/user.php
Referrer : admincp/user.php?do=edit&u=11
IP Address : x.x.x.x
Username : Union Jack
Classname : vb_database

Andreas
08-04-2005, 10:18 AM
That's what I thought.
Seems like your mySQL Version does not support this Query Syntax.

Can you try the following Query in phpMyAdmin if it generates errors?


DELETE moderator FROM moderator AS moderator, moderatorusergroup AS moderatorusergroup
WHERE moderator.userid = 11
AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
AND NOT (moderatorusergroup.usergroupid IN (2));

Asterik
08-04-2005, 10:33 AM
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 = 11
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


hmm..... Ran ur query but it went through, but i still get this :(

:: EDIT :: Actually it didn't delete anything :I

Mephisteus
08-04-2005, 10:57 AM
I have the same as Asterik. When editing a user it gives me that error.

Marco van Herwaarden
08-04-2005, 03:03 PM
That's what I thought.
Seems like your mySQL Version does not support this Query Syntax.

Can you try the following Query in phpMyAdmin if it generates errors?


DELETE moderator FROM moderator AS moderator, moderatorusergroup AS moderatorusergroup
WHERE moderator.userid = 11
AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
AND NOT (moderatorusergroup.usergroupid IN (2));
That is a completly different query.

PS Not all MySQL versions support multi table deletes.

Mephisteus
08-04-2005, 03:09 PM
The only place where I get that error is when editing a user. Also (the user already is a part of that group) the user doesnt have moderator rights.

Asterik
08-04-2005, 06:27 PM
The only place where I get that error is when editing a user. Also (the user already is a part of that group) the user doesnt have moderator rights.

Exactlly the same :).

Andreas
08-04-2005, 07:45 PM
Hmpf. Ppl should use more up-to-date mySQL Versions ;)
OK, doing it the old-fashined way then - without multi-table DELETEs.

Mephisteus
08-04-2005, 09:59 PM
Woho! Pretty please let us know when its updated :)

Andreas
08-04-2005, 10:04 PM
Will do.
Btw: If you add a Usergroup that already has Members (be it primary or secondary) as Moderator, do these members get Moderators?

Boofo
08-04-2005, 10:41 PM
That is a completly different query.

PS Not all MySQL versions support multi table deletes.

Which versions of MySQL support it?

Andreas
08-04-2005, 10:43 PM
4.0.2 up does ... if I understand the manual correctly.
But as there is one report from 4.0.24 where it is not working, maybe only 4.1.X does support this Syntax?

Bob, could you test if it's working for you?

Boofo
08-04-2005, 10:46 PM
I'm running 4.0.24-Standard, but I will install it and give it a shot. ;)

Andreas
08-04-2005, 10:48 PM
Thanks :)
I guess editing a User will not work, but I am interested if it does add Usergroup Members as Mods (when you add the Usergroup as Mod) on this Version

Boofo
08-04-2005, 10:55 PM
Ok, installed fine and I just added the administrators as the mod group to a forum. Is that what you needed to know or do you need me to check something else while I am playing? ;)

Boofo
08-04-2005, 10:57 PM
And when I check the forum it shows each admin in the mods drop down listing.

Andreas
08-04-2005, 10:57 PM
Great, so this part is working - only the multi-table delete causing Problem then :)

Boofo
08-04-2005, 10:59 PM
What do I need to do to test that part of it to make sure it just isn't a fluke on another system?

Andreas
08-04-2005, 11:00 PM
Just Edit a User

Boofo
08-04-2005, 11:04 PM
Sorry, got the same error on that one. :(

Andreas
08-05-2005, 12:23 PM
I have removed the multi-table DELETEs.
Hopefully this does work with older mySQL Versions now too.

Mephisteus
08-05-2005, 01:52 PM
everything seems like its working fine. Minus one thing, remove the user form the additional usergroup and the moderator access remains (yet disappears if the moderator usergroup is removed as such)

Andreas
08-05-2005, 02:06 PM
One missing s, aargh.
Should be fixed now, just import the new product XML.

Mephisteus
08-05-2005, 02:30 PM
Looks like its working now :) Thanks again :)

HuangA
08-09-2005, 06:04 AM
Kirby, can I make a translation of this and post on vbulletin chinese's hacks forum (crediting you of course)?

Andreas
08-09-2005, 01:48 PM
Feel free to post an XML with Translated Phrases/Installation instructions, but the Product XML should only be available for Download from here.
Thanks for your understanding :)

If you do, please send me a copy as well.

HuangA
08-09-2005, 05:22 PM
Hm... aren't the phrases part of the product xml? I wonder how I'm gonna translate just the phrases without putting up a different xml :p oh well, I'll go probe around and see what I can do :)

Andreas
08-09-2005, 05:54 PM
Take a look at the 3.5 Modification Tips&Tricks Forum, I posted a How-To for translating Hacks :)

ack
08-23-2005, 03:58 AM
Oh man, it works perfect! This is exactly what I needed!

I know this is stupid and I probably shouldn't ask, but would there be anyway to just have the name of the usergroup as the moderator, instead of all of the moderators showing up?

It's no biggy, it would just look nicer. *whistles*

Oh man, but this is awesome. Thanks like.. A MILLION. Really. *worships*

Andreas
08-23-2005, 08:43 AM
I know this is stupid and I probably shouldn't ask, but would there be anyway to just have the name of the usergroup as the moderator, instead of all of the moderators showing up?

Not possible (without major File Edits).

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.

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 (https://vborg.vbsupport.ru/showthread.php?t=92370)" 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
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
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
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
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
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: 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
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
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:

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

Andreas
10-06-2005, 08:31 AM
Hmm, this Query works just fine for me.
Which mySQL Version do you use?

diretur
10-06-2005, 08:32 AM
3.23.58-log

diretur
10-06-2005, 08:36 AM
wait, maybe I have it!
Table 'db32351_14.vb3_moderatorusergroup' doesn't exist

I did't create any table because I haven't seen it in the readme file!

diretur
10-06-2005, 08:40 AM
sorry for the chaos: now I uninstalled the mod, so the table should have been deleted from the database. right?

Andreas
10-06-2005, 08:40 AM
I think that 3.23 is too old.
The table should have been automatically created by the product install code.

trilljester
10-06-2005, 03:09 PM
Kirby: Can you limit this usergroup's moderator functions, meaning, they can have the same limitations as moderators as a single user moderator, right? Like if I don't want them deleting posts or what not, I can restrict that, correct?

JohnBee
10-06-2005, 06:55 PM
Okay I installed this mod and the first thing I noticed is when I try to edit any of the usergroups i get an SQL dB error. I tried to deactivate the hack and make the changes but it still does the same so I guess there have been changes made to the tables that cause the error.

I will try and uninstall then try to edit the usergroups to see if the same problem occurs. One thing for sure is once the hack is installed, it almost certainly leads us to edit or refine the usergroups to better fit the group system in forum home so the SQL error will almost definately take place.

Okay I uninstalled the hack and the error still occurs so I guess the MOD is noit cleaning up the tables after uninstallation.

Here is the error
Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Site moderator',
`description` = '',
`usertitle` = '',
`opentag` = '<span style=\"color: #6A0000;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '1',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '0',
`genericpermissions` = '204193695',
`genericoptions` = '23',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '120',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '120',
`avatarmaxsize` = '50000',
`imghost` = '0'
WHERE usergroupid=7;

MySQL Error : Unknown column 'imghost' in 'field list'
Error Number : 1054
Date : Thursday, October 6th 2005 @ 03:57:34 PM
Script : http://www.mysite.com/www/forum/admincp/usergroup.php
Referrer : http://www.mysite.com/www/forum/admincp/usergroup.php?do=edit&usergroupid=7
IP Address : ***.***.**.**
Username : Xxxxxx
Classname : vb_database

Looking forward to a fix.

Mephisteus
10-06-2005, 07:43 PM
Its messing up at the imghost field. Its neither a defeault field nor is it part of this hack, Id be looking at another hack... (though I do not know which one, Im guessing one that hosts images on a usergroup basis or something :p)

@trilljester, yes it does :)

Andreas
10-06-2005, 07:53 PM
@trilljester
The permissions are the same as for normal moderators.

@JohnBee
Field imghost definitely has nothing to do with this Hack, so this error is caused by another Hack.
=> Remove all Bitfield XMLs from Hacks you don't use (any longer) and rebuilt the bitfield cache.

trilljester
10-06-2005, 09:07 PM
Awesome. Thanks for this, Kirby! I really wish this was a feature in VBulletin, I'm surprised it's not. It's actually a feature in most forum softwares.

JohnBee
10-06-2005, 10:45 PM
@trilljester
The permissions are the same as for normal moderators.

@JohnBee
Field imghost definitely has nothing to do with this Hack, so this error is caused by another Hack.
=> Remove all Bitfield XMLs from Hacks you don't use (any longer) and rebuilt the bitfield cache.

Okay I know exacly what MOD is reponsable for this. I did uninstall it but it looks like it left some dirty code behind. Any idea how I can rebuild bitfield cache? I have a file called bitfield_rebuild.php but it won't run gives me an error. Is there another way?

Andreas
10-06-2005, 10:47 PM
I don't know where bitfield_rebuild.php comes from, but it is not a standard file.
admincp/index.php?do=buildbitfields is the way to go.

Andreas
10-12-2005, 11:49 PM
Hmm, maybe I could add some Code to prevent changing individual Moderators (that are Mderatros because they are in a Moderator Usergroup).
This is now implemented in Version 1.0.7

cynix2
10-13-2005, 02:07 AM
First love the hack its exactly what Im looking for.

Question though, I have my groups that moderate set to be a public usergroup with a leader so they can hire new staffers and such, When they join the usergroup it sets them in the group as an additional usergroup. If i set them manuially your mod allows them to moderate as allowed However when they join a public usergroup using the system they dont have any powers. Why are the users not allowed to moderate? Is it the hack, the forum, or what is happening so that users cannot mod when joining a public group?

Mephisteus
10-13-2005, 05:33 AM
First love the hack its exactly what Im looking for.

Question though, I have my groups that moderate set to be a public usergroup with a leader so they can hire new staffers and such, When they join the usergroup it sets them in the group as an additional usergroup. If i set them manuially your mod allows them to moderate as allowed However when they join a public usergroup using the system they dont have any powers. Why are the users not allowed to moderate? Is it the hack, the forum, or what is happening so that users cannot mod when joining a public group?

@ cynix2 the querys are done when the form is used that was given by kirby. I do agree however, that it would be a sweet thing considering I have 4 usergroups that would benefit from such a possibility :p

Andreas
10-13-2005, 09:27 AM
Public Usergroup Management doesn't run through the Datamanagers, so the current Code doesn't catch that.
Support will be available in Version 1.0.8

Andreas
10-13-2005, 12:17 PM
Support for moderated public Usergroups as Moderator Usergroups is now available in Version 1.0.8

akanevsky
10-13-2005, 01:11 PM
Nice hack, but this code is kind of creepy:

<if condition="$show[modgroup]">
<if condition="$show[doshowmodgroup]">
<a href="showgroups.php$session[sessionurl_q]">$moderator[usergrouptitle]</a>
</if>
<else />
<a href="member.php?$session[sessionurl]u=$moderator[userid]" rel="nofollow">$moderator[musername]</a>
</if>

Cause what if I want to add both groups and single users to a certain forum?
I believe <if> allows that... Somehow:

<if condition="$show[modgroup]">
<if condition="$show[doshowmodgroup]">
<a href="showgroups.php$session[sessionurl_q]">$moderator[usergrouptitle]</a>
</if>
<if condition="$show[doshowmodgroup] OR $show[doshowsinglemod]">, </if>
<if condition="$show[doshowsinglemod]">
<a href="member.php?$session[sessionurl]u=$moderator[userid]" rel="nofollow">$moderator[musername]</a>
</if>
</if>

Andreas
10-13-2005, 01:20 PM
My code is correct, yours isn't - you are opening 4 <if> but close only 3 :)

akanevsky
10-13-2005, 01:29 PM
It doesn't matter how many <if>'s I open and close, I am trying to get through the point that you could make it show both groups and users... Besides, I fxied it.

Mephisteus
10-13-2005, 01:48 PM
It doesn't matter how many <if>'s I open and close, I am trying to get through the point that you could make it show both groups and users... Besides, I fxied it.

I could swear it shows both already :p

:)

akanevsky
10-13-2005, 01:56 PM
I could swear it shows both already

Really? Well I didn't check. If it does then cool :)

Andreas
10-13-2005, 02:06 PM
It doesn't matter how many <if>'s I open and close
It does matter, cause you might/will get template compile errors otherwise ;)

akanevsky
10-13-2005, 02:11 PM
Jeez........... I know that... I'm just giving you an ESTIMATE of what the code should be. -.-

jluerken
10-17-2005, 07:28 AM
Perfect hack kirbyDE. This should be standard.

I found five small cosmetic problems and it would be nice to get an update for this.

1. If you add a group as moderator for a forum and its subforums then you will see in ADMINCP - Show all moderators only the top forum.
This list should contain also the subforums like if you add the mod to every single board.

2. Admincp - Manage forums. In the last column you can add single moderators. If you add a group as moderator to a forum you see there that the forum has 0 moderators.
There should be the moderatorgroup listed.

3. I wanted to add a group + a single user to a forum. I added the group and then the single user and on the forumhome I can see that the group is gone.
There should be group+user or?

4. If you click on the moderator group on the forumhome page the link points to the show forum leaders page.

5. Admincp - Moderator Usergroup Manager
I am using a group that is not displayed there.
In such cases it would be nice if all users are shown by hovering the moderator group link on the forumhome page

5. See point 1. All forums including the subforums should be listed there.

Kind regards
jluerken

Andreas
10-17-2005, 10:48 AM
1) This is standard vBulletin behaviour for Moderators and can't be changed without file edits

2) For me it shows all users of the usergroun then ...

3) For me it shows the single mod and the usergroup

4) This is intended behaviour. Where else should it link to?

5) I don't understand that

jluerken
10-17-2005, 12:56 PM
1) This is standard vBulletin behaviour for Moderators and can't be changed without file edits


Maybe you can tell how this will work as optional step? :D


2) For me it shows all users of the usergroun then ...


For me it shows 0 Moderators


3) For me it shows the single mod and the usergroup


Only the last that I entered. Mod OR Modgroup


4) This is intended behaviour. Where else should it link to?


Its currently linking to showgroups.php (Forum Leaders).
If the moderator group is not listed on the forum leaders page this link makes no sense.
Maybe hovering the link can show the mod names?


5) I don't understand that


You could not. I was typing much to fast and missed a part :D
I was talking about the moderator group page itself.
If you add a moderator group to a forum again only the top forum is displayed.
Like you told us in point 1 I think this could also be only fixed with file edit or?

Andreas
10-17-2005, 01:04 PM
Maybe you can tell how this will work as optional step? :)
I won't do that, sorry.

For me it shows 0 Moderators
Then you must have done smth. wrong.

Only the last that I entered. Mod OR Modgroup

Then you must have done smth. wrong.
http://kirbydemos.ath.cx/forum
http://kirbydemos.ath.cx/forum/forumdisplay.php?f=7



Its currently linking to showgroups.php (Forum Leaders).
If the moderator group is not listed on the forum leaders page this link makes no sense.
Maybe hovering the link can show the mod names?

Why should the group not be listed?
Doesn't make sense to me, as the users must know who are moderators.
Anyway, it is possible to make the usernames a title attribute, but that would require another query.

jluerken
10-17-2005, 01:11 PM
Then you must have done smth. wrong.
http://kirbydemos.ath.cx/forum
http://kirbydemos.ath.cx/forum/forumdisplay.php?f=7


Uploaded the files, imported the Produkt, made the 2 Template Changes.
I cannot see what I should have done wrong :D


Why should the group not be listed?
Doesn't make sense to me, as the users must know who are moderators.
Anyway, it is possible to make the usernames a title attribute, but that would require another query.

I have internal clan forums where the clans can organize themself but I don't want to show them on the forum leader page cause they are no forum leaders.
They can manage their forum but they're not belonging to my official staff.
Therefore I turned off the option to show those groups on the forum leader page.
Members who want to know who can moderate the board can still see this if they have access.

Andreas
10-17-2005, 01:14 PM
Uploaded the files, imported the Produkt, made the 2 Template Changes.
I cannot see what I should have done wrong :D

I don't know either :)
Only thing I can say is that it works just fine on my system.

moonclamp
10-23-2005, 12:52 PM
Would there be anyway to have secret moderator group that doesn't show up in the list?

There have been so many accusations of favouritism on my forum that I don't really want my members to know who the moderators are.

Abe1
10-23-2005, 03:09 PM
Uploaded the files, imported the Produkt, made the 2 Template Changes.
I cannot see what I should have done wrong :D



I have internal clan forums where the clans can organize themself but I don't want to show them on the forum leader page cause they are no forum leaders.
They can manage their forum but they're not belonging to my official staff.
Therefore I turned off the option to show those groups on the forum leader page.
Members who want to know who can moderate the board can still see this if they have access.

I had the same problem. I total removed the hack and moderators from the groups. I then installed the updated hack and it works now.

BlackxRam
10-27-2005, 12:24 PM
So is this pretty Stable now with 3.5 Gold?

thalamus
10-30-2005, 01:05 PM
Works perfectly for me :) Thanks for this, saves a lot of time ;) *installs*

Stephen3
12-07-2005, 07:14 PM
will effect when upgrade to 3.5.2 or higher?

edbri871
12-07-2005, 09:51 PM
I was looking for hack to allow a usergroup to be able to delete and merge thier own posts only within a certain section. The delete part was simple but not the merge. An alternative to have forum moderators so that they have the ability to mod only a paticular forum although the prior would be preffered.

I was linked to this thread and Im not sure if its what Im looking for though I could be mistaken. If this can do what I need maybe someone could let me know and if not could anyone figure how I can do what Im looking for...

Thanks.

edbri871
12-08-2005, 05:27 PM
The above post can be ignored since Ive figured how to do what I wanted now...

SmEdD
12-12-2005, 05:54 AM
Under "Show All Moderators" if I have them in a usergroup which is a group for Moderating a forum and I click " [Remove this Moderator from All Forums]" it prompts me to download moderator.php . . .

redlabour
12-15-2005, 04:09 PM
Updated to 1.0.9 today - my Group "Moderators" is still not shown. Of course i tryed to deinstall and reinstall.

Frist thing i see - it is still in german but it have taken this english Version here now. What?s going wrong there ? :ermm:

Admin and Supermoderators works fine in the same Category.

Fixed a Bug which caused Moderator Usergroups not being displayed properly in subforums.

So this is not working in my Eyes .... and of course i have uploaded the new Files and edited the Templates.

Update : After the Update my Moderators where "registered Users" after a manually Change for each one to Moderators again it works.

exegete
01-12-2006, 12:34 PM
Am experiencing errors.

They occur when I attempt to use the "Remove this Moderator from All Forums" function (ACP -> Forums & Mods -> Show All Mods), and the moderator I am attempting to de-mod is a member of one or more moderator usergroups added with this extension.

The action appears to be performed successfully, so everything continues to operate correctly, but the errors appear on the redirection page nonetheless.

MySQL 4.0.25
vB 3.5.3

Warning: mysql_query(): 5 is not a valid MySQL-Link resource in /includes/class_core.php on line 404

Warning: mysql_error(): 5 is not a valid MySQL-Link resource in /includes/class_core.php on line 846

Warning: mysql_errno(): 5 is not a valid MySQL-Link resource in /includes/class_core.php on line 864

...

Database error in vBulletin 3.5.3:

Invalid SQL:

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

MySQL Error :
Error Number :
Date : Friday, January 13th 2006 @ 01:21:45 AM
Script : http://community.boredofstudies.org/admincp/moderator.php
Referrer : http://community.boredofstudies.org/admincp/moderator.php?do=removeall&u=4288
IP Address : 203.214.152.105
Username : Lazarus
Classname : vb_databaseIt is otherwise a very nice extension. :) Thank you.

stefaandk
01-16-2006, 05:34 AM
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:



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/admincp/moderatorusergroup.php
Referrer : http://10.1.1.199/SITES/V6/forum/admincp/moderatorusergroup.php?do=edit&moderatorusergroupid=1
IP Address : 10.1.1.150
Username : Admin
Classname : vB_Database




Be a great addition, hopefully this can be resolved.

Submerge
02-06-2006, 07:07 PM
Seems to be an error in 3.5.3. Darn, was looking forward to this.

007
03-15-2006, 12:52 AM
Also getting an error.

It happens when editing a custom mod group in 3.5.4:

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'

Andreas
03-17-2006, 03:11 AM
This query executes just fine for me.
Which mySQL version do you use?

cOuNtErFiET
03-28-2006, 04:16 AM
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

Raw Sugar
03-28-2006, 07:53 PM
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?

EasyTarget
04-11-2006, 07:57 PM
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 putyeah, 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)

cOuNtErFiET
04-16-2006, 02:05 AM
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?

redlabour
06-08-2006, 03:49 PM
Will it work in the Future with vBulletin 3.6 (http://www.vbulletin.com/forum/showthread.php?t=187654) ?

held
07-28-2006, 07:33 AM
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

Jonathan Young
07-29-2006, 10:05 PM
Is this problem still within 3.54? Looking to install it, but i won't if people are having problems. I also hope this is updated for 3.6.

cynix2
08-09-2006, 09:29 PM
has anyone tested this out on 3.6?

redlabour
08-12-2006, 03:29 PM
has anyone tested this out on 3.6?

Works perfect - Thread can moved to 3.6 Section ! ;)

Slyfox1
08-14-2006, 07:26 AM
Works perfect - Thread can moved to 3.6 Section ! ;)

I installed this on 3.6 and it all seems to work fine, except I get "Usergroup Moderator" in normal link colour apposed to displaying the people within the group? orjust reading the group name and the colour assoaiated?

Ideas?

JohnBee
10-20-2006, 02:40 AM
Great hack.

I have a question, my forum home moderator column is not equal in width when different length of group names appear between forums. It's purely cosmetic but kinda of annoying because on a fluid layout the columns are all off between the forum sections.

I wish there was a way to lock down a width, based on the longest usergroup name that way the forum layout would be evenly distributed.

Any chance this could be implemented?

Makc666
10-31-2006, 10:00 PM
Great hack.

I have a question, my forum home moderator column is not equal in width when different length of group names appear between forums. It's purely cosmetic but kinda of annoying because on a fluid layout the columns are all off between the forum sections.

I wish there was a way to lock down a width, based on the longest usergroup name that way the forum layout would be evenly distributed.

Any chance this could be implemented?
Can you please post a screenshot about what you are speaking about.
thanks

JohnBee
11-01-2006, 09:48 AM
Is it possible to remove the , separator between the usergroups in the forumhome?

Been Told
11-17-2006, 08:37 PM
I can't believe this is not a standard feature of vB! A fantastic and hugely usefull mod. Works like a charm.
Thank you so very much!

Edit: I run a 3.6.3 board in case anyone wonders about compatibility with the newest version of vB.

Binoy
12-17-2006, 12:24 AM
any updates for this hack for 3.6.x???

CouchMonkey
12-27-2006, 06:45 PM
Yeah, I am using this for 3.6.4 with only one problem. The moderator section just runs off the page if you have several moderators.

Please see the attached Image.

Any help would be appreciated.

CouchMonkey
12-27-2006, 06:57 PM
Nevermind, I am an idiot. Please forget that last comment.

Great hack :)

Sres
01-25-2007, 08:13 AM
This is fantastic! Installed :)

taheri6
01-28-2007, 07:17 AM
Nevermind, I am an idiot. Please forget that last comment.

Great hack :)


I have this same problem after first install and adding two usergroups as moderators, the Administrators and a custom secondary usergroup.

How do I fix it?

they show up as


amin.taheriSmokey, MeowDumbAssDucky, TreeSyke o_OVery Very GoodLV8BallSiK WiT iTt0ggLeDashSKSShane$coobNoWeeWee


Sometimes the comma gets placed, and the majority of the time it doesnt.

Slyfox1
01-28-2007, 11:34 PM
It would be nice if the MOD would pick up the colour associated to the group being assigned and display it where applicable.

Sly

kellogs
08-25-2007, 06:19 AM
does it work with 3.6.8?

TigerWare
08-26-2007, 06:46 AM
does it work with 3.6.8?

Yes, I have it installed on 3.6.8 and it works fine. :up:

PinkDaisy
09-05-2007, 12:03 PM
This doesn't show up for me. All my settings in ACP are right and so forth, but not showing up in my moderator column.

Alfa1
09-05-2007, 01:18 PM
Can others confirm that this doesn't show up in the moderator column? That would be just what I need!

Edit: never mind I found it. You forgot to apply the template edits.

lostgirl815
09-08-2007, 09:17 PM
A great mod - thanks! I looked for this forever, so I'm bumping it.

majorxp
11-01-2007, 05:40 AM
Brilliant! Thanks!

SBlueman
12-15-2007, 06:07 PM
It would be nice if the MOD would pick up the colour associated to the group being assigned and display it where applicable.

Sly

Does anyone know how to do this? I'd like this to display like this:

Usergroup Name

instead of

Usergroup Name

on my site.

SBlueman
12-22-2007, 05:41 PM
Does anyone know how to do this? I'd like this to display like this:

Usergroup Name

instead of

Usergroup Name

on my site.

Anyone?

redlabour
01-29-2008, 04:57 PM
Does it still work in 3.7?

Andreas
01-29-2008, 05:01 PM
It should. Let me know if it does not and i'll take a look at what is needed to make it compatible.

Abe1
01-31-2008, 01:29 AM
Works for me.

jluerken
02-04-2008, 11:27 AM
Hi Andreas,

I have a small issue with this hack.
If you add more than one group to the list of moderators, only one is shown in the moderator column.

Can you please check this? (vBulletin 3.7 beta4)

Kind regards
jluerken

Mephisteus
02-04-2008, 11:39 AM
Andreas, whilst I respect that you don't re-release this for every vB version out there you might want to at least say it works in 3.6 and 3.7 in the first post ;) Plenty of hacks don't and it's a shame to just see this one lumped in with that category while it does work :p

Andreas
02-18-2008, 09:10 AM
@jluerken
I guess I never thought there could be several usergroups fo one forum ;)
This is a bug that needs to be fixed.
If a fixed version isn't available within 2 weeks from now, please remind me via PM on vBGo.

Spoiler
02-20-2008, 02:46 PM
Hi,

is it possible to make the moderatorgroup available for the calenders?
I have a group, that only have to moderate a calender so that would be very nice.

redlabour
04-23-2008, 11:24 AM
@jluerken
I guess I never thought there could be several usergroups fo one forum ;)
This is a bug that needs to be fixed.
If a fixed version isn't available within 2 weeks from now, please remind me via PM on vBGo.

Done :)

jeepinator
04-29-2008, 11:05 PM
Hey, uhh... I installed this quite a while ago and it did the trick. Thanks!
But I want to remove it, which is easy... but I'd like to undo whatever it is the hack allows before removing the hack.
Problem is... I can't remember what it was :o
So I removed the moderators individually, then added a new user (as a test) and the the test user is now a moderator of a forum, which is kinda what I expected.
I can't seem to find where in the heck I undo making a group be moderators for a forum.
I kinda want to laugh and cry at the same time. Please help :erm:

EDIT 1:
Perhaps, through an upgrade, I lost the code that creates the
"Moderator Usergroup Manager" link in the ACP?

EDIT 2:
Yay, back to laughing. Not sure how the nifty files were missing from the folders, but they were, so I put them there, edited the stuff back to default and uninstalled the hack.
The true hack is me, haha.

otto
04-30-2008, 05:29 PM
Hey,

i am from germany - sorry for my bad english ... ;)

I have installed it on vb 3.5.4 and it works ... but i have one problem with it:

The "can edit other posts" funktion is for my forum not realy the best way - i search a way, so a user can edit only its own posts at all time in forum xy and not all posts of all users in forum xy ...

Is there any way to do this with this hack?

Thanks!

EvilHawk
05-04-2008, 11:41 PM
It should. Let me know if it does not and i'll take a look at what is needed to make it compatible.

Hi Andreas, it works with the forums but it needs to be updated to support the new 3.7.0 moderator permissions for visitors messages, albums & social groups etc.

Thanks again for this time saving hack. :up:

Andreas
05-05-2008, 04:08 AM
It doesn't really need an upgrade - the new permissions are not forum-related, and this hack was meant to manage a usergroup for forums.

EvilHawk
05-05-2008, 08:27 AM
Of course, you are right about the meaning of this hack sir, but if you assign a usergroup to a forum you can not edit the new moderator permissions for each moderator.

shadowevil
05-08-2008, 05:28 AM
It would be nice if the MOD would pick up the colour associated to the group being assigned and display it where applicable.

Does anyone know how to do this? I'd like this to display like this:

Usergroup Name

instead of

Usergroup Name

on my site.

Edit file product-modusrgrp.xml, find:

$moderator['usergrouptitle'] = $vbulletin->usergroupcache["$moderator[modusergroupid]"]['title'];

Replace all:
$moderator['usergrouptitle'] = $vbulletin->usergroupcache["$moderator[modusergroupid]"]['opentag'].$vbulletin->usergroupcache["$moderator[modusergroupid]"]['title'].$vbulletin->usergroupcache["$moderator[modusergroupid]"]['closetag'];

It's work in 3.7.x :)

[I]Regards,

EvilHawk
05-08-2008, 04:03 PM
It's work in 3.7.x :)

No it doesn't because you can not edit the new 3.7.x permissions ...

Karri
07-21-2008, 02:53 PM
No it doesn't because you can not edit the new 3.7.x permissions ...I am seconding this. I am trying to give my mods permissions to mod social groups and I can't since it isn't included in this mod. I can't do it from the mod since the options aren't there and when I try to do it individually it says
You cannot modify this Moderator individually.
If you want to modify this Moderator, modify the Moderator Usergroup So how do I let my mods mod social groups, visitor messages and user albums?

Xoxideforums
07-22-2008, 07:13 PM
Hi,

I have been using your plugin for quite a while and recently updated to latest Vbulletin patch. I seem to be having some emails dropping off from being sent since doing this. Is there any chance this could be because your plugin is only good up to 3.5? If so, do you plan on doing an update for 3.7?

Thanks!

kud0gfx
07-25-2008, 06:32 PM
Excelent mod, does anybody know why in my forumhome it shows the text " Staff || || || || || " and not only "Staff"

it's very strange, and I don't know how to change it :S

b3nw
07-27-2008, 08:50 PM
i'm on 3.7.2 and also getting the || || || || || || || || || || || || || || || || || || || || || || || || || || || ||

any suggestions?

kawzaki
08-21-2008, 07:19 PM
brilliant,
i have been looking for this for a while.. using wrong key words :D


vb forum 3.6.8 and working smooth so far.

however, be careful,
once u add a group on a forum to moderate, they get view permission to all other forums ( including private ones ). must check the other forums permissions to avoid giving unwanted access.

thanks a lot!

jluerken
09-30-2008, 12:42 PM
I really would like to see Andreas updating this mod. Its very useful. I'll send him a PM and maybe he has time to do it

AndyJensen
10-03-2008, 04:33 AM
I got the || || || error as well...update to 3.7.x.

DerMatze
10-09-2008, 04:24 PM
work this addon with 3.7.3???

Abe1
10-13-2008, 11:32 AM
work this addon with 3.7.3???
works for me

Karri
10-13-2008, 03:08 PM
Has anyone figured out how to make this work with the social groups, visitor messages and user albums? As it stands now there is no way to assign mods to those areas when you use this plugin.

NolF
10-20-2008, 08:38 AM
I got the || || || error as well...update to 3.7.x.

A quick but dirty method to get rid of it is to go in to the following plugin
Add Usergroup as Moderator: Show Usergroup forumdisplay_moderator

find
$show['doshowmodgroup'] = false;
$moderatorslist .= '||';
change to
$show['doshowmodgroup'] = false;
$moderatorslist .= '';

It seems to work :)


Would be nice if it was updated to 3.7 though 3.8 is coming "soon" so I wouldn't hold my breath for a 3.7 release unfortunetly

raggyt
10-29-2008, 02:45 PM
ty m8 need this for new forum

developpez.com
11-12-2008, 02:26 PM
Has anyone figured out how to make this work with the social groups, visitor messages and user albums? As it stands now there is no way to assign mods to those areas when you use this plugin.
Same problem here.

This is even worse that the inability to give moderation access or not to those areas, because when you upgrade your forum from 3.6 to 3.7, all your existing moderators will be given rights to any social groups (for example), without ability to remove those rights, but any new moderator (added to a moderator usergroup) won't, without ability to give those rights (except by adding the moderator to a dummy forum by the standard way and give the rights to social groups).

demoniavbh
11-26-2008, 10:52 AM
OK, PERFECT :)

But is there anyway not to list this moderators? I mean, in Forum Leaders, in Moderators, I'd like to have only in "User name" the group's name and if I cliked there, then list that group's members.
Now they are 2 times: as part of that group and as moderators, and I prefere having them listed as part of that group.

BaziCenter
01-16-2009, 08:07 PM
OK, PERFECT :)

But is there anyway not to list this moderators? I mean, in Forum Leaders, in Moderators, I'd like to have only in "User name" the group's name and if I cliked there, then list that group's members.
Now they are 2 times: as part of that group and as moderators, and I prefere having them listed as part of that group.

i have this problem too

i want it for 3.8.0

kud0gfx
03-04-2009, 08:46 AM
A quick but dirty method to get rid of it is to go in to the following plugin
Add Usergroup as Moderator: Show Usergroup forumdisplay_moderator

find
$show['doshowmodgroup'] = false;
$moderatorslist .= '||';
change to
$show['doshowmodgroup'] = false;
$moderatorslist .= '';

It seems to work :)


Would be nice if it was updated to 3.7 though 3.8 is coming "soon" so I wouldn't hold my breath for a 3.7 release unfortunetly

It worked in 3.8.1

Thank you dude!

Been Told
04-25-2009, 03:23 PM
Working great with 3.8.2 here. Thanks for a great mod that really should have become a part of vBulletin many versions ago.

myown
06-24-2009, 02:25 PM
Database error in vBulletin 3.8.3:

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))
WHERE (NOT ISNULL(user.userid)) AND moderatorusergroup.moderatorusergroupid=2;

MySQL Error : Duplicate entry '830-118' for key 2
Error Number : 1062

got this error when tried to add usergroup ad moderator.

edgegamers
07-27-2009, 01:00 PM
myown: We are encountering the same issue. The problem is you have a member who already has moderator rights above/below the forum category you are trying to add to. The script needs to attempt to locate if a user has moderator rights higher up in the tree and assign the access appropriately. This will be a fairly significant change to the code. Is the owner of this project still around?

jluerken
10-13-2009, 05:15 AM
Hey Andreas,

this is still one of the most needed features for vBulletin admins maintaining larger boards.
Is there a chance that you'll update the mod please?

Kind regards
jluerken

jfuchs
10-16-2009, 07:00 PM
Hey Andreas,

this is still one of the most needed features for vBulletin admins maintaining larger boards.
Is there a chance that you'll update the mod please?

Kind regards
jluerken

Hi I also use this addon, it's really nice.
A new version would be very nice :D

I don't like to add more than 20 mods by hand !

Regards johannes

ChopSuey
10-21-2009, 11:31 AM
Agreed, a new version for 3.8.4 would be great.

giraffesyo
11-04-2009, 07:20 AM
Agreed, a new version for 3.8.4 would be great.

As far as compatibility, it looks like it runs, but a version meant for 3.8.4 would be much better.

Looking forward to future editions.

jesus likes pie
03-12-2010, 05:59 PM
There's an annoying bug where SQL errors get spat out if a user is a member of 2 usergroups which are both moderators of a single forum.

Miras
03-24-2010, 02:40 PM
has anyone seen an update for vb4 for this mod?

hoangminh
06-16-2010, 01:05 AM
has anyone seen an update for vb4 for this mod?
Any port for vB 4.0 :(

walshymyster
08-27-2010, 02:45 AM
yes please could do with one for version 4!!!
please :)

Avrojet
09-24-2010, 02:30 PM
Nothing for VB4?

jluerken
10-02-2010, 04:07 PM
Hi Andreas,

I am sure you are very busy but can you please reply if you will release a vb4 version?

/jluerken

mokonzi
10-17-2010, 04:25 PM
I would be keen to see this in vB4 at some point :)

Faskis
11-21-2010, 02:11 PM
I'm having a bit of an issue with making this work with vB4 (so if anyone can provide assistance, it would be greatly appreciated). It displays fine, for the most part, except that it adds extra spaces for names that are in the usergroup if you have more than one person in the usergroup (See also: attachment).


Here's the PHP code for the display:

if ($moderator['moderatorusergroupid'])
{
$show['modgroup'] = true;
$moderator['usergrouptitle'] = $vbulletin->usergroupcache["$moderator[modusergroupid]"]['opentag'] .''.$vbulletin->usergroupcache["$moderator[modusergroupid]"]['title'] . $vbulletin->usergroupcache["$moderator[modusergroupid]"]['closetag'].'';
if (!isset($forum['moderators']))
{
unset($showmodgroups);
}
if (!$showmodgroups["$moderator[moderatorusergroupid]"])
{
$show['doshowmodgroup'] = true;
}
else
{
$show['doshowmodgroup'] = false;
$forum['moderators'] .= '||';

}
$showmodgroups["$moderator[moderatorusergroupid]"] = true;
}
else
{
$show['modgroup'] = false;
}

Avrojet
03-01-2011, 10:45 AM
Has anyone tested this in VB4.x?

Avrojet
03-05-2011, 08:46 AM
Ok, I'm using this on VB4.1.1 and it works fine. :)

Fickey
07-16-2011, 11:49 AM
Using this on VB 4.1.4 with no issues yet :) Since I don't show who moderates the forums except from the forum leaders page I didn't use the modification suggested.

fajny_nick
01-26-2012, 11:33 AM
Hi,

I have an error, since install and use it on version 4.1.10.

Fatal error: Cannot use string offset as an array in /var/www/html/vb/includes/functions_forumlist.php on line 402

or

Fatal error: Cannot use string offset as an array in /var/www/html/vb/forumdisplay.php on line 329

How can i fix this error and use this mod in vb 4.1.10?

Sory for my english and thank you for your help.

HMBeaty
01-27-2012, 12:29 AM
Hi,

I have an error, since install and use it on version 4.1.10.

Fatal error: Cannot use string offset as an array in /var/www/html/vb/includes/functions_forumlist.php on line 402or

Fatal error: Cannot use string offset as an array in /var/www/html/vb/forumdisplay.php on line 329How can i fix this error and use this mod in vb 4.1.10?

Sory for my english and thank you for your help.
That is because of how the commas are now applied in vBulletin. So this modification more than likely won't work from 4.1.8 on up. :(

fajny_nick
01-27-2012, 11:12 AM
Thank you for answer.

Is there a simmilar modification for vb 4.1.8 and up?

Phases
03-01-2012, 07:26 PM
Installed on 3.8.7, seems to work well. Gives mysql error if you try to add a group to a forum that already has members of said group as mods of said forum - so you have to remove all the mods first. (and I had 52 of this type of 'mod'!)

Otherwise all that I'm missing are a few of the permissions that I don't care too much about, like "edit social group (titles)", etc.

(Would be nice to have it all though)

Thanks for the great mod! I've wanted this a long time.

Phases
03-05-2012, 02:36 PM
Does this product change the way VB redirects moderators after performing actions? I'm getting complaints for the staff that they are now redirected to the first page of a forum after changing a thread prefix from within the thread, instead of back to the thread itself.

So, when doing work, they would:
- Go in thread
- Decide a prefix change was appropriate
- Be redirected back into the thread, where they would post saying they've done so
- Hit back button a few times to be back on the page they were on in the forum while making rounds

Now:
- Go into thread
- Decide needs prefix change, changes
- Redirect to first page of forum
- Have to find way back to thread to post reply, and find out what page they were on.

Deal breaker? Maybe. I have a number of people complaining that this is killing productivity/ease-of-volunteering.

Any thoughts?

ssslippy
03-09-2012, 04:27 AM
To make this work on 4.1.11 you need to go into the plugin manager and disable the parts that are hooked into forumbit_display forumdisplay_query forumdisplay_moderator and forumbit_moderator.

This will disable the showing of the mod group name on the pages but it will still work on the back end.

KGodel
01-31-2013, 04:55 AM
Bumping this. Has anyone successfully ported this mod fully and easily to vb 4.2.x yet?

JaredC01
02-13-2013, 09:39 PM
Thanks ssslippy for the info! I had disabled the mod due to the error and lack of need at the time. The need is back, and there's literally no other mod out there that does the same thing.

I've considered rewriting the code for 4.2+ myself, though I'd have to do a bit of homework on the back-end.

Dogma21cw
10-19-2013, 09:23 AM
Bumping this. Has anyone successfully ported this mod fully and easily to vb 4.2.x yet?

If you use slippy's advice, it should work fine. We have it running fine on our 4.2.1 install. I can export our plugin settings if you really need it.