Mass removing secondary groups

Solidus

Well-known member
Nearly every member has 'registered' as their secondary user group, I'd like to remove this for all of them.
However, a lot of users also have a different group as their secondary, and I don't want to remove those.
Is there an sql query for this?
 

Solidus

Well-known member
Thing is, I'm using an addon which disallows signature editing until 5 posts and restricts images and lines, this is defined in options though, not permissions. So if I set it to affect registered users, it affects everyone.
 

Solidus

Well-known member
Alright, I'll do it your way. Which SQL query will place all users in registered group as primary?
 

Brogan

XenForo moderator
Staff member
You can't use queries to change user groups as the permission sets won't be updated.

Note that if you delete one of the non-default user groups, any members will fall back to the Registered user group.
 
Top