USP_NON_FAFEVENT_DEFAULT_THEMEM_SET

CREATE PROCEDURE dbo.USP_NON_FAFEVENT_DEFAULT_THEMEM_SET
AS
BEGIN
    SET NOCOUNT ON;

    begin try
        declare @siteID int, @enumID smallint, @enumValue nvarchar(2048)

        declare nonFAFEventCursor cursor local fast_forward for
            select cs.id, s.enumID, s.value from clientsites cs
            left join dbo.eventextension ex on cs.id = ex.ClientSitesID
            left join dbo.cmssitesetting s on cs.id = s.clientsitesid and s.enumid=29
            where ex.eventid is null

        open nonFAFEventCursor

        fetch next from nonFAFEventCursor into @siteID, @enumID, @enumValue;

        while @@FETCH_STATUS = 0
        begin
            if @enumID is null
                insert into dbo.cmssitesetting (ENUMID, SETTING, CLIENTSITESID, VALUE)
                values (29, 'DefaultTheme', @siteID, '89aff510-1e09-4a89-8124-c96bc40f6a19')
            else
                update dbo.CMSSITESETTING set VALUE = '89aff510-1e09-4a89-8124-c96bc40f6a19'
                where CLIENTSITESID = @siteID and ENUMID = @enumID

            fetch next from nonFAFEventCursor into @siteID, @enumID, @enumValue;
        end

    close nonFAFEventCursor
    deallocate nonFAFEventCursor
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;
END