Previous Thread
Next Thread
Print Thread
Rate Thread
Need easy querry to move users in one group to another #282323
11/28/2004 2:33 PM
11/28/2004 2:33 PM
Joined: Jul 2001
Posts: 462
Colorado
C
coloradok5 Offline OP
Enthusiast
coloradok5  Offline OP
Enthusiast
C

Joined: Jul 2001
Posts: 462
Colorado
Hi guys
I just need a querry to move all the users from one group into another group. Hell, I don't even think I spelled querry right.:o The mass move in the admin section would not work because it doesn't show what groups the other users are in.

Sponsored Links
Re: Need easy querry to move users in one group to another [Re: bisbell] #282324
11/28/2004 3:14 PM
11/28/2004 3:14 PM
Joined: Aug 2002
Posts: 1,271
Vienna, Austria
dimopoulos Offline
Kahuna
dimopoulos  Offline
Kahuna

Joined: Aug 2002
Posts: 1,271
Vienna, Austria
If we assume that you want to move users from the group with ID 4 to the group with ID 5 (you can see the ID's of each group by looking at the w3t_Groups table) then all you need is to issue this statement:

UPDATE w3t_Users SET U_Groups = REPLACE(U_Groups, '-4-', '-5-');

and just to be on the safe side you need to enter this one as well:
UPDATE w3t_Users SET U_Groups = REPLACE(U_Groups, '-5-5-', '-5-');

The second one will make sure that the new group is not referenced twice.

It is better to use those queries for one record alone i.e. add a WHERE U_Number = 'xx' first (where xx is the U_Number of a record you know fits the criteria) and then run them against your database.

Just to be safe, backup your db first.


Nikos
Re: Need easy querry to move users in one group to another [Re: Hal_dup2] #282325
11/28/2004 10:04 PM
11/28/2004 10:04 PM
Joined: Jul 2001
Posts: 462
Colorado
C
coloradok5 Offline OP
Enthusiast
coloradok5  Offline OP
Enthusiast
C

Joined: Jul 2001
Posts: 462
Colorado
Thank you


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
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,941
Joined: January 2000
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,454
Posts293,496
Members13,800
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,941
Greg Hard 5,533
Top Posters(30 Days)
isaac 8
Gizmo 3
driv 1
Today's Statistics
Currently Online 852
Topics Created 1
Posts Made 1
Users Online 1
Birthdays 21
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.3
(Snapshot build 20180915.dev)
Page Time: 0.071s Queries: 15 (0.049s) Memory: 3.2483 MB (Peak: 3.4852 MB) Zlib enabled. Server Time: 2018-09-22 05:03:32 UTC