|
|
|
|
Joined: Jun 2002
Posts: 47
User
|
|
User
Joined: Jun 2002
Posts: 47 |
How can I change the Title of every user in a group.
I have a group (GroupA) and every member in that group should have a custom title, the same title. Now I can do it by hand on each user but I have 400 users. Is there an SQL command or a script that can change them all for me?>
Thanks!
|
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
UPDATE w3t_Users SET U_Title = 'Widget' WHERE U_Groups LIKE '%-5-%' where 5 is the number of the group
|
|
|
|
|
Joined: Jun 2002
Posts: 47
User
|
|
User
Joined: Jun 2002
Posts: 47 |
Wonderful, that worked perfectly ... now what if I want to change a title ... lets say I have a bunch of users with the title "Board Member" and I want to change that title to "Board User", how could that be done.
Thank you!!!!!
|
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
UPDATE w3t_Users SET U_Title = 'Board User' WHERE U_Title = 'Board Member'
|
|
|
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.
|
|
|
Posts: 5,834
Joined: January 2000
|
|
|
Forums63
Topics37,583
Posts293,955
Members13,824
| |
Most Online151,614
Nov 14th, 2025
|
|
Currently Online 1336
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 3
|
|
|
|
|
|
