USP_CLONESITE_NEWSREADER

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


    insert into dbo.NewsReaders ( SiteContentID, Guid, ShowDate, ShowGraphic, MaxHeadlines, HeadlineOnly, ArticlesPerPage, PagedOutput, NewsReaderURL, NewsReaderAuthType, NewsReaderUsername, NewsReaderPassword)
    select
    SC.ID,
    NEWID(),
    NR.ShowDate,
    NR.ShowGraphic,
    NR.MaxHeadlines,
    NR.HeadlineOnly,
    NR.ArticlesPerPage,
    NR.PagedOutput,
    NR.NewsReaderURL,
    NR.NewsReaderAuthType,
    NR.NewsReaderUsername,
    NR.NewsReaderPassword
    from dbo.NewsReaders NR
    inner join dbo.SiteContent SC on SC.CopySourceID = NR.SiteContentID
    where SC.CopyBatchGUID = @CopyBatchGuid


    --Update XML Data

    declare @Data xml
    set @Data = 
    (
        select P.SiteContentID, NR.ID as Value
        from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,64, 'ClientNewsReaderID') P
        inner join dbo.NewsReaders NR on NR.SiteContentID = P.SiteContentID
        FOR XML RAW, ELEMENTS
    )    
    exec USP_UPDATEXMLPROPERTYFORSITECOPY 'ClientNewsReaderID', @Data