USP_CLONESITE_SPONSORSHIPSEARCH

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

    declare @CHANGEAGENTID uniqueidentifier
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output                
    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()


    insert into dbo.SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS
    (
    ID,
    SEARCHRESULTHTML,
    SEARCHCRITERIADESIGNCODE,
    HTMLSEARCHRESULTCODE,
    SHOWPAGINGCONTROLSCODE,
    AUTOSEARCHENABLED,
    SEARCHCOLUMNS,
    SIMPLEFIELDSLIST,
    ADVANCEDFIELDSLIST,
    OUTPUTFIELDSLIST,
    RECORDSPERPAGE,
    COLUMNSPERPAGE,
    RESULTSPERSESSION,
    QUERYVIEWID,
    QUERYID,
    ADDEDBYID,
    CHANGEDBYID,
    DATEADDED,
    DATECHANGED,
    SPONSORSHIPFORMPAGEID
    )
    select
    NSC.Guid,
    dbo.UFN_UPDATECOPYCONTENTHTML(SEARCHRESULTHTML, @CopyBatchGuid),
    SEARCHCRITERIADESIGNCODE,
    HTMLSEARCHRESULTCODE,
    SHOWPAGINGCONTROLSCODE,
    AUTOSEARCHENABLED,
    SEARCHCOLUMNS,
    SIMPLEFIELDSLIST,
    ADVANCEDFIELDSLIST,
    OUTPUTFIELDSLIST,
    RECORDSPERPAGE,
    COLUMNSPERPAGE,
    RESULTSPERSESSION,
    QUERYVIEWID,
    QUERYID,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE,
    ISNULL(SP.ID,SPONSORSHIPFORMPAGEID) AS SPONSORSHIPFORMPAGEID
    from dbo.SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS SOS
    inner join dbo.SiteContent OSC on OSC.Guid = SOS.ID
    inner join dbo.SiteContent NSC on NSC.CopySourceID = OSC.ID
    left outer join dbo.SitePages SP on SP.CopySourceID = SOS.SPONSORSHIPFORMPAGEID AND SP.CopyBatchGUID = @CopyBatchGuid
    where NSC.CopyBatchGUID = @CopyBatchGuid