Question/Request....

[Vlad]

I searched and couldn't find this anywhere, but correct me if I am wrong.

At my forum, every now and again one of my admins sets up a forum and then makes it private, at which point all moderators on the entire site are granted access to that forum when they shouldn't be. Now, I have over 100 moderators so as you can see it becomes a pain in the butt to edit all accesses, or even to delete and re-create the forum. Anyway, is there a hack or can one be made that either allows you to mass edit forum access by usergroups or see who and what usergroups have access to specific forums?

Even knowing who has access to certain forums becomes helpful, especially once certain private forums have added a number of people to it and then have no idea who has access and who doesn't, especially when those with access need to be removed and so forth...

Any help is appreciated!

Vlad

[Xenon]

usergroup permissions can be massedited with a hack from me.
look into my profile.

also to list users when you have accesmask enabled there is a hack by firefly for that.

[Vlad]

great thanks for replying, i appreciate it!

[amykhar]

I actully posted a fix to this, which I consider a bug. I'll try to go find it because it was a very simple fix that stopped vbulletin from granting access to mods automatically when a private forum is created.

Amy

[amykhar]

Found it. In admin/forum.php The private forums are handled as such: When a private forum is created, the script sets the permissions for everybody except admins so that they cannot see it. THEN the stupid script goes and finds all the mods and explicitly gives them access. Removing this chunk of code:

   $mods=$DB_site->query("SELECT DISTINCT moderator.userid FROM moderator,user WHERE moderator.userid=user.userid AND user.usergroupid<>6 AND user.usergroupid<>5");
    if ($DB_site->num_rows($mods)) {
      while ($mod=$DB_site->fetch_array($mods)) {
        $accessto[] = $mod['userid'];
      }
      while ( list($key,$userid)=each($accessto) ) {
        $DB_site->query("INSERT INTO access (userid,forumid,accessmask) VALUES ('$userid','$forumid',1)");
      }
    }

from admin/forum.php solves that problem.

Amy

[Vlad]

Originally posted by amykhar
Found it. In admin/forum.php The private forums are handled as such: When a private forum is created, the script sets the permissions for everybody except admins so that they cannot see it. THEN the stupid script goes and finds all the mods and explicitly gives them access. Removing this chunk of code:

   $mods=$DB_site->query("SELECT DISTINCT moderator.userid FROM moderator,user WHERE moderator.userid=user.userid AND user.usergroupid<>6 AND user.usergroupid<>5");
    if ($DB_site->num_rows($mods)) {
      while ($mod=$DB_site->fetch_array($mods)) {
        $accessto[] = $mod['userid'];
      }
      while ( list($key,$userid)=each($accessto) ) {
        $DB_site->query("INSERT INTO access (userid,forumid,accessmask) VALUES ('$userid','$forumid',1)");
      }
    }

from admin/forum.php solves that problem.

Amy

So by removing that, it will fix it? Wow, thanks!

[Threshold]

Amy, thanks for that information.

That is my first official hack to my vBulletin.