vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   [Release vb2.0] Exclude/Include Usergroups from Members List (https://vborg.vbsupport.ru/showthread.php?t=16140)

bira 05-06-2001 09:00 PM
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.

http://www.atlasf1.com/personal/bira/showinlist.gif

Cheers,

Bira

bira 05-06-2001 10:22 PM
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

wajones 05-06-2001 11:40 PM
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.

bira 05-07-2001 05:52 PM
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).

wajones 05-07-2001 06:03 PM
Great, Thank you very much!!!

bira 05-07-2001 06:35 PM
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

netphreak 05-18-2001 10:32 AM
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


All times are GMT. The time now is 01:20 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02001 seconds
  • Memory Usage 1,756KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (11)bbcode_code_printable
  • (10)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete