spCloneSite_ClientSites

Used in site copy to client sites

Parameters

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

Definition

Copy



CREATE procedure [dbo].[spCloneSite_ClientSites]
(
     @SourceClientSitesID    int
    ,@TargetClientSitesID    int
    ,@CurrentUserID            int
    ,@CopyBatchGUID            uniqueidentifier
)
as
begin

    set nocount on;

    UPDATE    dbo.ClientSites
    SET        
         CopySourceID    = @SourceClientSitesID
        ,CopyBatchGUID    = @CopyBatchGUID
    WHERE ID = @TargetClientSitesID

    UPDATE    TSS
    SET        VALUE = ISNULL(sp.ID, 0)
    FROM    dbo.CMSSITESETTING TSS
    left outer join dbo.CMSSITESETTING SSS on SSS.ENUMID = TSS.ENUMID
    left outer join    dbo.SitePages sp on    sp.CopySourceID = ISNULL(CAST(SSS.VALUE as int), 0) and sp.CopyBatchGUID = @CopyBatchGUID
    WHERE    TSS.CLIENTSITESID = @TargetClientSitesID 
    and        SSS.CLIENTSITESID = @SourceClientSitesID
    AND        TSS.ENUMID in (1,2,3,4,5,30,32,36,37,38,40,43,45,46,53)

    UPDATE    TSS
    SET        VALUE = ISNULL(sf.FolderID, 0)
    FROM    dbo.CMSSITESETTING TSS
    left outer join dbo.CMSSITESETTING SSS on SSS.ENUMID = TSS.ENUMID
    left outer join    dbo.SiteFolders SF on sf.CopySourceID = ISNULL(CAST(SSS.VALUE as int), 0) and sf.CopyBatchGUID = @CopyBatchGUID
    WHERE    TSS.CLIENTSITESID = @TargetClientSitesID 
    and        SSS.CLIENTSITESID = @SourceClientSitesID
    AND        TSS.ENUMID in (16,54)


end