CGroupAuthProvider::UpdateCodes

public function UpdateCodes($USER_ID)
{
	global $DB;
	$USER_ID = intval($USER_ID);

	$DB->Query("
		INSERT INTO b_user_access (USER_ID, PROVIDER_ID, ACCESS_CODE)
		SELECT UG.USER_ID, '".$DB->ForSQL($this->id)."', ".$DB->Concat("'G'", "UG.GROUP_ID")."
		FROM b_user_group UG, b_group G 
		WHERE UG.USER_ID=".$USER_ID."
			AND G.ID=UG.GROUP_ID
			AND G.ACTIVE='Y'
			AND ((UG.DATE_ACTIVE_FROM IS NULL) OR (UG.DATE_ACTIVE_FROM <= ".$DB->CurrentTimeFunction().")) 
			AND ((UG.DATE_ACTIVE_TO IS NULL) OR (UG.DATE_ACTIVE_TO >= ".$DB->CurrentTimeFunction().")) 
		UNION 
		SELECT ID, '".$DB->ForSQL($this->id)."', 'G2' 
		FROM b_user
		WHERE ID=".$USER_ID."
	");
}