USP_CLONESITE_USERPHOTOS

Handles the User Photos-specific tasks for cloning a 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_USERPHOTOS
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


INSERT INTO SiteProfilePhotoForm
        (
              ContentId,
              CaptionEditable, 
              DefaultCaption,
              PhotoEditable,
              ApprovalRequired,
              ThumbSize,
              AfterUpdatePageID,
              CategoryFolderID,
              LargeSize,            
              TAGCODEID
        )
    SELECT SC.ID,
           SPPF.CaptionEditable,
           SPPF.DefaultCaption,
           SPPF.PhotoEditable,
           SPPF.ApprovalRequired,
           SPPF.ThumbSize,
           isnull(SP.ID,0),
           isnull(SF.FolderID,0),
           SPPF.LargeSize,
           TAGCODEID
    from SiteProfilePhotoForm SPPF
    inner join SiteContent SC on SC.CopySourceID = SPPF.ContentId and SC.CopyBatchGUID = @CopyBatchGUID
    left outer join SitePages SP on SP.CopySourceID = SPPF.AfterUpdatePageID and SP.CopyBatchGUID = @CopyBatchGUID
    left outer join SiteFolders SF on SF.CopySourceID = SPPF.CategoryFolderID and SF.CopyBatchGUID = @CopyBatchGUID