Help me set usergroupid to a custom user field

[Xenon]

replace this:

PHP Code:

$DB_site->query("UPDATE user SET usergroupid=2 WHERE userid=$key"); 


with this:

PHP Code:

$fields=$DB_site->query_first("SELECT field8 FROM userfields WHERE userid=$key");
$DB_site->query("UPDATE user SET usergroupid=".$fields[field8]." WHERE userid=$key"); 


should work, but be carefull, because the can became admins when field8 == 6 so i'd add an ifclause before