• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 How to set all members to registred group via Sql

#1
Hi,
is there a way, via sql to set all member to Registred group (exept the admin)?

Because, after import from phpbb i have so many members in so many differents user groups

Thank you
 

Liam W

Well-known member
#2
Hi,
is there a way, via sql to set all member to Registred group (exept the admin)?

Because, after import from phpbb i have so many members in so many differents user groups

Thank you
Can't you use the batch user update system?

admin.php?users/batch-update

Not in secondary groups: Administrator or whatever

Click search, confirm the found users are all fine with being moved

Set primary group: Registered users.

P.S All users, including admins, should have the registered users group as their primary really.
 

Brogan

XenForo moderator
Staff member
#3
You can't do it via SQL due to the permission combinations - they won't be updated correctly.

Use the batch update users function in the ACP.
Or, delete the custom user groups and they will revert to the Registered group and then you can start again.
 
#4
Thank you for fast answer,

it will be kind if you can you list me all user groups created by xenforo (not phpbb)

like this i will remove only old phpbb groups
 

Liam W

Well-known member
#5
Thank you for fast answer,

it will be kind if you can you list me all user groups created by xenforo (not phpbb)

like this i will remove only old phpbb groups
xenForo won't allow you delete pre-created usergroups, but here they are anyway:

Administrator
Unconfirmed/Guest
Moderator
Registered User

I believe that's it.