USP_DATAFORMTEMPLATE_ADD_FAFNFG_PRELOAD

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAFNFG_PRELOAD
(
      @CURRENTAPPUSERID uniqueidentifier = null,
      @SITEREQUIRED bit = null output,
      @SITES xml = null output,
    @CAMPAIGNID uniqueidentifier
)
as
    set nocount on;

    declare @DEFAULTSITEID uniqueidentifier,
            @USERDEFAULTSITEID uniqueidentifier        

        set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

    select @USERDEFAULTSITEID = SITEID from dbo.APPUSER where APPUSER.ID = @CURRENTAPPUSERID 

  set @DEFAULTSITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
    /*  
    if @USERDEFAULTSITEID is not null
    select @SITES = (
      SELECT newID() as ID, S.ID as [SITEID], S.NAME
     FROM dbo.[SITE] S where S.ID = @USERDEFAULTSITEID
     for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64 )


  if @SITEREQUIRED = 1
  begin 
    if @USERDEFAULTSITEID is null
      raiserror('You are not assigned to a default site. To continue, contact your administrator and verify your default site setup.', 13,1);
    else
      if dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID) is null
         raiserror('Your default site is not included in your role??????????????????s record access.  To continue, contact your administrator and update your role.', 13,1);
  end
 */

    return 0;