USP_CLONESITE_USEREMAILPREFERENCESFORM

Handles the User Email Preferences Form-specific steps for cloning a CMS site.

Parameters

Parameter	Parameter Type	Mode
@SourceClientSitesID	int	IN
@TargetClientSitesID	int	IN
@CurrentUserID	int	IN
@CopyBatchGuid	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_CLONESITE_USEREMAILPREFERENCESFORM
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, SP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,50, 'afterUpdatePageID') P
        inner join dbo.SitePages SP on SP.CopySourceID = P.Value
        where SP.CopyBatchGUID = @CopyBatchGUID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'afterUpdatePageID', @Data