UBB.Developers Forums Community Development Programming MySQL and Server Configuration Need sql command

Ok, first lets get your group numbers:

SELECT * FROM w3t_Groups

For my board it is:

code:
 
G_Name                    G_Id 
Administrators            1 
Moderators                2 
Users                     3 
Guests                    4 

---

Yours may vary, so for the sake of this demo we'll say your "Member" group is G_Id 5 and your "Users" G_Id is 3.

UPDATE w3t_Users SET U_Groups = '-5-' WHERE U_Groups = '-3-5-'

That should do it. Be sure to make a backup of the db first. Always make a backup before doing anything else if you're tinkering directly with the database.

Remember to check those group numbers first!