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

XF 1.5 SQL to modify members' usergroups

#1
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
#2
The short answer is that you can't do this via SQL. There are a lot of things that need to be updated/recalculated.