List users by access masks

This was requested by David Copeland.
He wanted to be able to list all users that have or don't have access to a certain forum.
This is very very easy to install, you just need to add one block of code and a link!

Demo:
http://www.vbulletin.com/forum/attac...&postid=172632

Install:
In user.php (admin folder), add this code:

PHP Code:

  echo "<li><a href=\"user.php?s=$session[sessionhash]&action=findaccess\">List by access masks</a></li>\n"; 


right after

PHP Code:

  echo "<li><a href=\"user.php?s=$session[sessionhash]&action=find\">List all users</a></li>\n"; 


Still in user.php, add this code:

PHP Code:

// ###################### Start Find by Access #######################
if ($action=="dofindaccess") {

  if ($checkaccess!="1" and $checkaccess!="0") {
    $action = "findaccess";
  } else {
    $lists = $DB_site->query("SELECT * FROM access");
    $inquery = "";

    while ($list = $DB_site->fetch_array($lists)) {
      if ($list[forumid]==$forumfrom and $list[accessmask]==$checkaccess) {
        if ($inquery) {
          $inquery .= ",";
        }
        $inquery .= "$list[userid]";
      }
    }

    if ($inquery=="") {
      echo "No users found.";
      $action = "findaccess";
    } else {
      $users = $DB_site->query("SELECT userid,username,usergroupid,password,email,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,posts FROM user WHERE userid IN ($inquery)");

      echo "<p>Click username to view forum profile.</p>";
      doformheader("","");

      echo "<tr class='tblhead'>";

      echo "<td><p><b><span class='tblhead'>Name</span></b></p></td>";
      echo "<td><p><b><span class='tblhead'>Options</span></b></p></td>";
      echo "<td><p><b><span class='tblhead'>Email</span></b></p></td>";
      echo "<td><p><b><span class='tblhead'>Password</span></b></p></td>";
      echo "<td><p><b><span class='tblhead'>Join Date</span></b></p></td>";
      echo "<td><p><b><span class='tblhead'>Last Visit</span></b></p></td>";
      echo "<td><p><b><span class='tblhead'>Posts</span></b></p></td>";

      echo "</tr>\n";

      while ($user=$DB_site->fetch_array($users)) {

        echo "<tr class='".getrowbg()."'>";

        echo "<td><p><a href='../member.php?s=$session[sessionhash]&action=getinfo&userid=$user[userid]' target='_blank'>$user[username]</a>&nbsp;</p></td>";
        echo "<td><p>".
              makelinkcode("edit","user.php?s=$session[sessionhash]&action=edit&userid=$user[userid]").
              makelinkcode("email password","user.php?s=$session[sessionhash]&action=emailpassword&email=$user[email]").
              makelinkcode("remove","user.php?s=$session[sessionhash]&action=remove&userid=$user[userid]").
              makelinkcode("edit access masks","user.php?s=$session[sessionhash]&action=editaccess&userid=$user[userid]").
              "</p></td>";
        echo "<td><p><a href='mailto:$user[email]'>$user[email]</a>&nbsp;</p></td>";
        echo "<td><p>$user[password]&nbsp;</p></td>";
        echo "<td><p>$user[joindate]</p></td>";
        echo "<td><p>$user[lastvisit]</p></td>";
        echo "<td><p>$user[posts]</p></td>";

        echo "</tr>\n";

      }
      echo "</table></td></tr></table></form>";
    }
  }

}

// ###################### Start List by Access #######################

if ($action=="findaccess") {

  doformheader("user","dofindaccess");

  maketableheader("List Users by Access Masks","",0);
  echo "<tr class='firstalt'><td colspan=2><p>Here you can list all users that match the settings you set below.</p></td></tr>\n";

  maketableheader("Forum Select");

  makeforumchoosercode("Forum you'd like to order by:",forumfrom);
  makeyesnocode("Does the user has access to that forum?",checkaccess,"2");
  echo "</p></td></tr>\n";

  doformfooter("List users");
} 


right before

PHP Code:

cpfooter();
?> 


The end.
See, I told you it's easy!
Now you have a link for this under Users => Find => List by access masks (under List all users).

By the way, I know that one part of the code there could be combined with the other search part, but this is just as good.
Sue me.
Feedback please.

[Jawelin]

Thanks a lot, even for such a fast answer!
Anyway...


I can't manage to use 'UNION' on two simple select ... Even returning the 'userid' alone....

ERRATA CORRIGE: ooops. The UNION [ALL] SQL command requires +4.x version of MySQL...
I think the hack should merge itself the different result sets within php code and not sql-query...

Bye

[Warlord]

Thanks this hack works great! And it makes it MUCH more convenient when trying to find out who all has access to certain forums.

As previously stated, it seems that it doesn't list users that have access to certain forums because they are allowed entry because of the user group they are in. Unless it is actually selected in the persons access masks, it doesn't list them as having access to that forum.

But this is better than nothing.

Thanks.

[Jawelin]

Originally posted by FireFly
I'll see what I can come up with Jawelin, but I can't promise anything.

I know what you said, but just for reminder... :supwink:

Meanwhile I tried myself but can't manage to merge different result sets within php code, as my server has mySQL 3.2x and not +4...
Anyway is very hard to findout an algorithm to select and make explicit permissions with inherited ones...
:noid:

Thnx

[Shenlong]

MY question:

why isnt firefly on vbb staff? damn man u can do ANYTHING and what u do with ur skillz is awesome

:up: :up:

[Jawelin]

Originally posted by Shenlong
MY question:

why isnt firefly on vbb staff? damn man u can do ANYTHING and what u do with ur skillz is awesome
:up: :up:

Above all, if he isn't an official vb developer, they should listen to him when upgrading to a newer release... :greedy:
leased:

P.S.: it's a bump, did you realize that ?

[ladyfyre]

Ok....i am VERY sorry to be such a brat...but I have a BIG request here......

Any way I could talk you into adding a link in this hack that would reset a user's "custom status'" to usergroup defaults for ALL forums?? I have over 300 at present...and doing it by hand if a mod gets demoted gets REALLY old.

[Recluse]

works fine on my forums, thanks

[Jawelin]

Just a tip:
what about
1) choose a forum from a combo-list (best ordered the same way in jump-combo is, not alphabetically), fixing a parameter, this way.
2) seek all the user table checking :

PHP Code:

                 $permissions=getpermissions($forum[forumid],$userid);
                 if ($permissions['canview'] == 1/0 ) {
                   // add this user to the enabled/disabled list
                 } 


The complexity should be linear than the usercount, and this way the search should keep the inheritance, the access table, the usergroup permission, etc.

???

Thanks, FF.

[KISS]

The man, much needed installed great too.

[over]

niec hack cheers makes my life easier