Announcement

Collapse
No announcement yet.

[Release vb2.0] Exclude/Include Usergroups from Members List

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Release vb2.0] Exclude/Include Usergroups from Members List

    This one is for CJ:

    it allows you to select in a usergroup's settings whether the members of this usergroup will show up in the Members List.

    For example, on my Bulletin Board members of the "Banned Users" and "Users Awaiting Email Confirmation" are excluded and will not show up on the Members List.

    Others might find it useful if they want to exclude Administrators or other site personnel.

    In any case, it's a very simple hack (I think). It involves runnign one MySQL query and editing two scripts.

    Installation:

    1. Run the following MySQL command via phpMyAdmin or Telnet:

    Code:
    ALTER TABLE usergroup ADD showinlist SMALLINT (6) DEFAULT '1' not null
    (explanation: the above query will add a column to the usergroup table 'showinlist' with the default value being '1' so that by default, ALL usergroups are included in the Members List (like it is now)).

    2. Open admin/usergroup.php.

    Find:

    PHP Code:
    makeyesnocode("Can modify profile","canmodifyprofile",1); 
    BELOW it add:

    PHP Code:
    makeyesnocode("Appear in Members List","showinlist",1); 
    Find:

    Code:
    candenypmreceipts,maxbuddypm,maxforwardpm)
    REPLACE it with (change is in red):

    Code:
    candenypmreceipts,maxbuddypm,maxforwardpm,showinlist)
    Find:

    Code:
    $maxbuddypm,$maxforwardpm)
    REPLACE it with (change is in red):

    Code:
    $maxbuddypm,$maxforwardpm,$showinlist)
    Find:

    PHP Code:
    makeyesnocode("Can modify profile","canmodifyprofile",$usergroup[canmodifyprofile]); 
    BELOW it add:

    PHP Code:
    makeyesnocode("Appear in Members List","showinlist",$usergroup[showinlist]); 
    Find:

    Code:
    maxforwardpm=$maxforwardpm
    REPLACE it with (change is in red):

    Code:
    maxforwardpm=$maxforwardpm,showinlist=$showinlist
    Save the file.

    3. Open memberlist.php

    Find:

    PHP Code:
    $memberlistbit ""
    ABOVE it put:

    PHP Code:
      $showugroup=$DB_site->query("SELECT usergroupid FROM usergroup WHERE showinlist=0");
        while(
    $thisgroup=$DB_site->fetch_array($showugroup)) {
            
    $condition.=" AND usergroupid!='$thisgroup[usergroupid]'";
      } 
    Save and upload both files.


    Now, go to the Control Panel -> User Groups and Permissions -> Modify.

    Click on "edit" next to the usergroup you want to EXCLUDE from the Members List. (meaning: the members of that usergroup will not appear in the Members List).

    Under the "Miscellaneous Permissions" section you will find a yes/no option whether members of this usergroup will show up in the Members List or not.



    Cheers,

    Bira

  • #2
    One more thing.

    I did not include this in the hack as it wasn't directly the same however I thought I'd mention this:

    On my Bulletin Board, users with 0 posts are excluded from the members list as well.

    If you are interested in this too (not showing users who never posted), then also do the following in memberlist.php:

    Find TWICE:

    Code:
    WHERE $condition AND
    And REPLACE it with (change is marked in red):

    Code:
    WHERE $condition AND posts!='0' AND
    Cheers,

    Bira

    Comment


    • #3
      This is great and on the lines of something I'm tying to achieve, but a little different. I want to have new members be able to join a particular group, show up in that groups membership list but not in other's. Sort of like having different lists for different groups but in actuallity everyone is in the same user table. Does that make any sense?
      Well would I do something simular to this to achieve that or am I off base.

      Comment


      • #4
        wajones, this can be achieved quite easily:

        Open memberlist.php

        find:

        PHP Code:
            if ($postsupper!="") {
              
        $condition.=" AND posts<'$postsupper'";
            } 
        Below it add:

        PHP Code:
            if ($usergroup!="") {
              
        $condition.=" AND usergroupid='$usergroup'";
            } 
        Now, if you view the Members List via url memberlist.php?usergroup=xx

        you will see only the users in usergroup whose id is xx

        example:

        http://www.atlasf1.com/bb/memberlist.php?usergroup=6 -- you will see all the members of the Administrator usergroup.

        ***
        Now here's another twist you can add.

        If you want a logged in user to see only members of his group, do the following instead:

        PHP Code:
            if ($usergroup!="") {
              
        $condition.=" AND usergroupid='$usergroup'";
            } elseif (
        $bbuserinfo[usergroupid]!="") {
              
        $condition.=" AND usergroupid='$bbuserinfo[usergroupid]'";
            } 
        This means that a user viewing memberlist.php will see only members of his own usergroup listed. A user not logged in or unregistered will see ALL members (unless you excluded a certain group using the previously posted hack).

        Comment


        • #5
          Great, Thank you very much!!!

          Comment


          • #6
            One more option for those interested:

            If you want the "Registered Members: XXXX" on the BB's front page to NOT include those whom you excluded from the Members List (example: if you don't want Banned Users to be included in neither the Members List nor the total Members count), then do the following:

            Open index.php

            Find:

            Code:
            $numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
            And REPLACE with (changes marked in red):

            Code:
            $condition="1=1";
            $showugroup=$DB_site->query("SELECT usergroupid FROM usergroup WHERE showinlist=0");
              while($thisgroup=$DB_site->fetch_array($showugroup)) {
                  $condition.=" AND usergroupid!='$thisgroup[usergroupid]'";
            }        
            $numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE $condition');
            Cheers,

            Bira

            Comment


            • #7
              Fatal error: Call to unsupported or undefined function     while() in /home/sites/site25/web/bb/memberlist.php on line 90

              Is this a result of using non-supported functions by php3?

              Really, all I am looking for is a way to prevent (COPPA) Users to show up in the "Welcome to our newest user, XXXXX"

              And preferably a way to show (COPPA) Users on the index site, as links to their profiles.

              I tried to add this in the index.php:

              PHP Code:
              $getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max] AND usergroupid=2"); 
              where the code I added was "AND usergroupid=2"

              Shouldn't this work?

              -net

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X