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
2 registered (Thelockman, 1 invisible), 22 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/07/06
Posts: 728
Top Posters (30 Days)
Ruben Rocha 177
Gizmo 110
Rick 109
Thelockman 80
driv 48
AllenAyres 35
Ian 33
ntdoc 27
Sirdude 23
Mark S 21
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
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: 1039
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: 438
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: 1039
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: 7898
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: 438
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: 1299
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: 1039
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: 1039
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
brushie, cass, Monte G., twebman, White Gold Wielder
Recent Topics
Font and column shifts occuring
by Bill B
Yesterday at 06:21 PM
changing colors in quoted thread box
by sbserves
Yesterday at 07:08 AM
[7.3.1] Image Not Found
by BellaOnline
11/29/08 09:48 PM
Private topic (PM) to a user that doesn't exist...
by bakerzdosen
11/29/08 10:56 AM
Forum Permissions - Can see forum
by Geoff
11/29/08 08:55 AM
Forum Stats
4261 Members
33 Forums
30528 Topics
154942 Posts

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