function build_user_activation_id($userid, $usergroupid, $type, $emailchange = 0)
{
global $vbulletin;

if ($usergroupid == 3 OR $usergroupid == 0)
{ // stop them getting stuck in email confirmation group forever
$usergroupid = 2;
}

$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "useractivation WHERE userid = $userid AND type = $type");
$activateid = fetch_random_string(40);
/*insert query*/
$vbulletin->db->query_write("
REPLACE INTO " . TABLE_PREFIX . "useractivation
(userid, dateline, activationid, type, usergroupid, emailchange)
VALUES
($userid, " . TIMENOW . ", '$activateid' , $type, $usergroupid, " . intval($emailchange) . ")
");

if ($userinfo = fetch_userinfo($userid))
{
$userdata =& datamanager_init('User', $vbulletin, ERRTYPE_SILENT);
$userdata->set_existing($userinfo);
$userdata->set_bitfield('options', 'noactivationmails', 0);
$userdata->save();
}

return $activateid;
}