Hmm, this Query works just fine for me.
Which mySQL Version do you use?

3.23.58-log

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!

sorry for the chaos: now I uninstalled the mod, so the table should have been deleted from the database. right?

I think that 3.23 is too old.
The table should have been automatically created by the product install code.

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?

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
Looking forward to a fix.

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

@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.

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.

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?

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.

This is now implemented in Version 1.0.7

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

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

Support for moderated public Usergroups as Moderator Usergroups is now available in Version 1.0.8

Nice hack, but this code is kind of creepy:

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

My code is correct, yours isn't - you are opening 4 <if> but close only 3 :)

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

:)

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

It does matter, cause you might/will get template compile errors otherwise ;)

Jeez........... I know that... I'm just giving you an ESTIMATE of what the code should be. -.-

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

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

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

For me it shows 0 Moderators

Only the last that I entered. Mod OR Modgroup

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?

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?

I won't do that, sorry.

Then you must have done smth. wrong.

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


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.

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 don't know either :)
Only thing I can say is that it works just fine on my system.

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.

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.

So is this pretty Stable now with 3.5 Gold?

Works perfectly for me :) Thanks for this, saves a lot of time ;) *installs*

will effect when upgrade to 3.5.2 or higher?

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.

The above post can be ignored since Ive figured how to do what I wanted now...

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

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.

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.

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

It is otherwise a very nice extension. :) Thank you.