I need to copy the function sql query that updates the field membergroupids in the table user. Where is this sql query/php function located?
$userdata->set('membergroupids', '*');
Collapse
X
-
It is difficult with direct SQL. I recommend parsing the list with PHP if you can.
John once posted this untested query for removing all users from secondary usergroupid X:
Code:UPDATE user SET membergroupids = TRIM( ',' FROM REPLACE( CONCAT( ',' , membergroupids , ',' ) , ',[color=red]X[/color],' , ',' ) )
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment