You are not logged in. [Log In] UBB.threads Community » Forums » UBB.threads 7 Discussion » General Assistance (How Do I?) » How to list members in a group
Register User    Portal Page     Forum List        Calendar     Active Topics     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 registered (GEN™, packlite, Thelockman, 1 invisible), 36 Guests and 20 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 02/15/08
Posts: 18
Top Posters (30 Days)
Ruben Rocha 95
Rick 85
Mark S 74
Gizmo 49
Thelockman 49
driv 35
Sirdude 32
ntdoc 28
packlite 27
AllenAyres 25
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#217612 - 10/06/08 04:04 PM How to list members in a group
ScriptKeeper Offline
old hand
***

Registered: 12/09/06
Posts: 1045
Loc: UK
I've created a separate group for regulars and would like to keep those invited up-to-date with the members list for that group. Is there any way that I can bring up a list that I can copy and post into a thread so that the selected members know who has access to that area?

SQL query perhaps?

Top
#217616 - 10/06/08 05:24 PM Re: How to list members in a group [Re: ScriptKeeper]
Thelockman Online crying
addict
***

Registered: 02/10/07
Posts: 523
Loc: Pennsylvania
Go to the group section and click on the number of users in that group. This will bring up a page with all the members in that group. I think you an delete, move, email, or any other function you can do on a search result.
_________________________
Beagle World - A forum for those who are owned by beagles.
Track Thunder - The Unofficial Racing Forum

Top
#217623 - 10/07/08 02:24 AM Re: How to list members in a group [Re: Thelockman]
ScriptKeeper Offline
old hand
***

Registered: 12/09/06
Posts: 1045
Loc: UK
Yes, I know that but it brings up all their details. All I want is a list of usernames that I can simply copy and paste.

Group 6 - Current Members:

Member1
Member2
Member3
Member4
Member5
Member6

Top
#217624 - 10/07/08 05:29 AM Re: How to list members in a group [Re: ScriptKeeper]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7998
Loc: Aberdeen, WA
Sql Query:
select t1.USER_DISPLAY_NAME
from ubbt_USERS as t1,
ubbt_USER_GROUPS as t2
where t2.GROUP_ID='6'
and t1.USER_ID = t2.USER_ID


Change 6 to whatever group number you want.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#217627 - 10/07/08 06:23 AM Re: How to list members in a group [Re: Rick]
Thelockman Online crying
addict
***

Registered: 02/10/07
Posts: 523
Loc: Pennsylvania
It would be nice to have some type of short technical manual for all the different fields in the database to be able to do MySQL stuff from standard SQL commands for this software some where.

This way for dude's like us that have and run the servers we can relate to data in order to do stuff like this without bugging you all the time Rick would be really great.
_________________________
Beagle World - A forum for those who are owned by beagles.
Track Thunder - The Unofficial Racing Forum

Top
#217629 - 10/07/08 07:46 AM Re: How to list members in a group [Re: ScriptKeeper]
blaaskaak Offline

****

Registered: 08/30/06
Posts: 1316
Loc: Breda, NL
Originally Posted By: ScriptKeeper
Yes, I know that but it brings up all their details. All I want is a list of usernames that I can simply copy and paste.


I have a list like that that I just auto update in an existing post. Saves the copy/paste smile
_________________________

Top
#217634 - 10/07/08 01:36 PM Re: How to list members in a group [Re: Rick]
ScriptKeeper Offline
old hand
***

Registered: 12/09/06
Posts: 1045
Loc: UK
Originally Posted By: Rick
Sql Query:
select t1.USER_DISPLAY_NAME
from ubbt_USERS as t1,
ubbt_USER_GROUPS as t2
where t2.GROUP_ID='6'
and t1.USER_ID = t2.USER_ID


Change 6 to whatever group number you want.

Spot on! Exactly what I was looking for. Thanks.

I know absolutely nothing about SQL queries. frown

Top
#217635 - 10/07/08 01:38 PM Re: How to list members in a group [Re: blaaskaak]
ScriptKeeper Offline
old hand
***

Registered: 12/09/06
Posts: 1045
Loc: UK
Originally Posted By: blaaskaak
I have a list like that that I just auto update in an existing post. Saves the copy/paste smile

Tell me more. laugh

Top


Moderator:  AllenAyres, Gizmo, Harold, Ian, Ian Spence, Ron M, usrbingeek 
Shout Box

Today's Birthdays
theregit
Recent Topics
7.4.2 UNREAD
by Thelockman
57 minutes 41 seconds ago
7.4.1 show/hide category bug
by Seattlebrian
Today at 11:56 AM
7.4.2 Discussion
by Rick
Today at 10:21 AM
UBBCentral now running 7.4.2
by Rick
Today at 10:21 AM
New members don't get access and are not displayed in the config panel
by Yomar
Yesterday at 03:32 AM
Forum Stats
4298 Members
33 Forums
30693 Topics
156040 Posts

Max Online: 978 @ 06/24/07 08:19 PM
Mark all read
Contact Us · UBBCentral · Top