Private Forum Improvement

It irked me to no end that when I added a new usergroup, they had access to all private forums if I wasn't careful. Thus, I wrote this.

It should also be useful for other things. With this field in the forum table, queries to exclude private forums are MUCH easier.

Do not download this attachment for new installs. Download this one

[Tommy Boy]

Can you please explain in more details what this hack does?

I have a similar problem, that when I opened a new hidden forum, all people who had access to the first one also had access to the new one, and I don't like it. Will your hack help me?

[amykhar]

What it does is when you create a new private forum or make a forum private that wasn't private before, it sets a field in the database to mark it as private.

Then, when you create a new user group, it sets the forumpermissions to can't view for all private forums. This way, you can create a new group and not have them see your private forums by default.

I am not 100% sure, but cutting this code:

PHP 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)");
      }
    }
  } 


out of your forum.php file should fix your problem for NEW forums that you create. However, if you take an existing forum and make it private, the same thing would still happen. I will investigate the code for changing a forum a little closer and see if I can't get that fixed as well.

Amy

[Admin]

Just one thing.

Instead of this:

$tempGroupid=$DB_site->query_first("Select usergroupid from usergroup ORDER BY usergroupid DESC limit 1");

You can simply do this:

$tempGroupid=$DB_site->insert_id();

For more info:
http://www.php.net/manual/en/functio...-insert-id.php

[amykhar]

Cool. I learn something every day.

Amy

[DarkReaper]

Hm...ok. Lets say I have 2 private forums already, and all moderators and admins have access to it. I then create another private forum, but want the moderators for that one not to have access to the previous forum, and I don't want any existing moderators to have access to the forum I just created. Can I do this?

[Wayne2k1.com]

[QUOTE]Originally posted by DarkReaper
Hm...ok. Lets say I have 2 private forums already, and all moderators and admins have access to it. I then create another private forum, but want the moderators for that one not to have access to the previous forum, and I don't want any existing moderators to have access to the forum I just created. Can I do this?

[The Red Devil]

Installed the hack, but it dont work for me. Im using 2.3.0
Everything is added and I get no error messages, but the new usergroup's I make still got access to all "hidden" forums.

Wayne2k1.com: A quite fast and easy solution to your problem would be to make another usergroup and make that "moderators" too, then edit the settings on who got rights of the usergroups to view the different forums.

[amykhar]

This is a real oldie and I can't guarantee it works anymore. I don't use it because I don't install more usergroups.

Amy

[Dean C]

Wow this is an oldie but a lovely idea !

How do i miss these hacks ?

- miSt