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.

[ToraTora!]

you keep this up firefly, and vb is going to throw you into the staff lineup. If one didnt know better, a person would swear that you and tubedog are having a hack release contest...

Keep up the good work!

[Admin]

[QUOTE]Originally posted by ToraTora!
you keep this up firefly, and vb is going to throw you into the staff lineup. If one didnt know better, a person would swear that you and tubedog are having a hack release contest...

Keep up the good work!

[MarkB]

I look forward to adding this You're a hacking machine!

[orca]

Had the following mySQL-error:

Database error in vBulletin Control Panel: Invalid SQL: SELECT userid,username,usergroupid,password,email,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,posts FROM user WHERE userid IN ()
mysql error: You have an error in your SQL syntax near ')' at line 1
mysql error number: 1064
Date: Monday 17th of September 2001 08:45:51 AM
Script: /admin/user.php
Referer: http://forum.arachid.org/admin/user....ion=findaccess

It seems there's a missing line in the form because the variable $inquery is empty (I guess it should be between the ()...

[Admin]

Ooops, if there are no results I should bring you back to the search screen.
I'll fix it in a mo.

[Admin]

Fixed.
If no users are found an appropriate line appears and you are brought back to main search screen.

[orca]

It fails even if there should be search results. I checked it on a forum where everyone has access and it gets me that error. Actually, the members should be listed there.
Other question: If the forum's set that only admins and mods can post and reply but users can only read it, will that be included in the search?

[Admin]

You missed something:
This searches by access masks, not by regular forum/usergroup permissions.

So only users that you specifically selected Yes for them will appear.

See this thread for more info:
http://www.vbulletin.com/forum/showt...threadid=27668

[orca]

Hmm, ok, now after the bug fix I see somehow how it's working...