USP_CLONESITE_PROFILEFORM

Handles the Profile 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_PROFILEFORM
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


INSERT INTO ProfileEditorFields
(FieldID, Caption, Editable, Required, AllowDelete, AllowPrivate, UseCodeTable, AllowNewCodes, ContentID, Include, FieldAttribID, ShowInGrid)
SELECT
FieldID,
Caption,
Editable,
Required,
AllowDelete,
AllowPrivate,
UseCodeTable,
AllowNewCodes,
SiteContent.ID,
Include,
FieldAttribID,
ShowInGrid
FROM ProfileEditorFields
INNER JOIN SiteContent ON SiteContent.CopySourceID = ProfileEditorFields.ContentID AND SiteContent.CopyBatchGuid = @CopyBatchGuid

-- update XML for Profile Form

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

-- update XML for Change User ID/Password

    set @Data = 
    (
        select P.SiteContentID, SP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,94, 'navigateToPageId') P
        inner join dbo.SitePages SP on SP.CopySourceID = P.[Value] and SP.CopyBatchGUID = @CopyBatchGuid
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'navigateToPageId', @Data