USP_CLONESITE_PAGESHARING

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


    declare @IDs xml
    set @IDs = 
    (
        select SP.EmailTemplateID as ID
        from dbo.SharingPart SP
        inner join dbo.SiteContent SC on SC.CopySourceID = SP.SiteContentID
        where SC.CopyBatchGUID = @CopyBatchGuid
        FOR XML RAW, ELEMENTS
    )        
    exec spCloneSite_EmailTemplate @TargetClientSitesID,@CurrentUserID,@CopyBatchGUID,@IDs

    insert into dbo.SharingPart (SiteContentID,CreateDate,UpdateDate,CreateID,UpdateID,SharingCaption,EmailTemplateID,ShowEmail,ShowDelicious,ShowDigg,ShowFacebook,ShowNewsVine,ShowYahoo,Guid)
    select
    SC.ID,
    GETUTCDATE() ,
    GETUTCDATE(),
    SP.CreateID,
    SP.UpdateID,
    SP.SharingCaption,
    ET.ID,
    SP.ShowEmail,
    SP.ShowDelicious,
    SP.ShowDigg,
    SP.ShowFacebook,
    SP.ShowNewsVine,
    SP.ShowYahoo,
    NEWID()
    from dbo.SharingPart SP
    inner join dbo.SiteContent SC on SC.CopySourceID = SP.SiteContentID
    inner join dbo.EmailTemplate ET on ET.CopySourceID = SP.EmailTemplateID
    where SC.CopyBatchGUID = @CopyBatchGuid and ET.CopyBatchGUID = @CopyBatchGuid

    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, SP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,108, 'SharingPartID') P
        inner join dbo.SharingPart SP on SP.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'SharingPartID', @Data