XF 1.5 SQL to modify members' usergroups

Khalid

Member
I want SQL statement that I can execute using PHPMyAdmin (Cpanel) which can modify the usergroups setting for some members at once.

The SQL should modify usergroups of users whose their primary usergroup is (name: Special, group id: 23) TO Primary usergroup (Registered, ID: 2) and secondary usergroup (Special).

Can someone please help me with this SQL statement?

Thanks
 

Mike

XenForo developer
Staff member
The short answer is that you can't do this via SQL. There are a lot of things that need to be updated/recalculated.
 
Top