[Typo3] How to update fe_user usergroup

[Peter Russ]

Jason Brock wrote:

> Hi,
> 
> Does anyone know how to update the "usergroup" field in the "fe_user" table?
> 
> I'm getting a list of the groups that the user is in:
> 
> $user_group = $GLOBALS['TSFE']->fe_user->user['usergroup'];
> 
> I'm testing to see if they're a member a required group, if they're
> not I want to update their profile so they're added to the group...
> 
> $query = "UPDATE fe_users SET group =
> '".$user_group.",".$theNewGroupId."' WHERE uid='".$user_uid."'";
> 
> But I'm having no joy -- even when I try to execute my sql in
> phpMyAdmin I get an error, I guess it's got something to do with the
> usergroup field being a tinyblob binary? -- can't find any doco or
> discussions, can anyone give me some pointers.... any suggestions?
> 
> thx,
> Jason.
> --

change group to usergroup in your query ;-)

$query = "UPDATE fe_users SET USERgroup 
='".$user_group.",".$theNewGroupId."' WHERE uid='".$user_uid."'";