Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Feb 2002
Posts: 1,759
Addict
Addict
Offline
Joined: Feb 2002
Posts: 1,759
Ok, it would be ideal if a hack was made to automate this, but for now I will settle for the quick and dirty manual way.

Here is my situation. On my forums, we have regular users, Bronze, Silver, and Gold members. The 3 highest levels are for people who donate money to the site. And since I can't thank everyone individually all of the time, I want to create a list of users under each group and make a post thanking everyone in public.

So really, all I need to do is query to find all users in the bronze group. Then all users in the silver, and gold groups. I would like it so I can just copy/paste the list of names to add to a post, but any way I can easily get the names would be great.

But really, I think this would be a great addition to threads, if admins could send PMs and/or emails to specific groups. This way I can easily send messages to a whole group thanking them, or giving them special instructions, etc.

So anyway, let me hear the suggestions Thanks.

Sponsored Links
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
SELECT U_Username FROM w3t_Users WHERE U_Groups LIKE '%-3-%'


Replace 3 with the group number of your choice. I believe this will work.

Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
[]But really, I think this would be a great addition to threads, if admins could send PMs and/or emails to specific groups.[/]

You can do that now: Admin -> Send email to users

Joined: Feb 2002
Posts: 1,759
Addict
Addict
Offline
Joined: Feb 2002
Posts: 1,759
[][]But really, I think this would be a great addition to threads, if admins could send PMs and/or emails to specific groups.[/]

You can do that now: Admin -> Send email to users [/]

Well dang it all, when did this take shape? I was under the impression you couldn't send emails just to particular groups *hits himself in the head*

Thanks.. both Daves


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)