USP_CLONESITE_DISCUSSIONGROUP

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


    insert into dbo.DiscussionGroups(RequiresApproval,Guid,SiteContentID,GroupName,PostNewTopicMessage,PostNewReplyMessage,SpellTopicWithErrors,SpellTopicNoErrors,SpellReplyWithErrors,SpellReplyNoErrors,AllowAnonymous,AnonymousName)
    select
    DG.RequiresApproval,
    NEWID(),
    SC.ID,
    DG.GroupName,
    DG.PostNewTopicMessage,
    DG.PostNewReplyMessage,
    DG.SpellTopicWithErrors,
    DG.SpellTopicNoErrors,
    DG.SpellReplyWithErrors,
    DG.SpellReplyNoErrors,
    DG.AllowAnonymous,
    DG.AnonymousName
    from dbo.DiscussionGroups DG
    inner join dbo.SiteContent SC on SC.CopySourceID = DG.SiteContentID
    where SC.CopyBatchGUID = @CopyBatchGuid

    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, DP.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,54, 'ClientDiscussionGroupID') P
        inner join dbo.DiscussionGroups DP on DP.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'ClientDiscussionGroupID', @Data