CREATE PROCEDURE dbo.[Forum_Forum_Update]
    (
      @GroupID INT,
      @ForumID INT,
      @IsActive BIT,
      @ParentID INT,
      @Name NVARCHAR(255),
      @Description NVARCHAR(2048),
      @IsModerated BIT,
      @ForumType INT,
      @PublicView BIT,
      @UpdatedByUser INT,
      @PublicPosting BIT,
      @EnableForumsThreadStatus BIT,
      @EnableForumsRating BIT,
      @ForumLink NVARCHAR(255),
      @ForumBehavior INT,
      @AllowPolls BIT,
      @EnableRSS BIT,
      @EmailAddress NVARCHAR(100),
      @EmailFriendlyFrom NVARCHAR(50),
      @NotifyByDefault BIT,
      @EmailStatusChange BIT,
      @EmailServer NVARCHAR(150),
      @EmailUser NVARCHAR(100),
      @EmailPass NVARCHAR(50),
      @EmailEnableSSL BIT,
      @EmailAuth INT,
      @EmailPort INT,
      @EnableSitemap BIT,
      @SitemapPriority FLOAT
    )
AS
    BEGIN
        UPDATE  dbo.Forum_Forums
        SET     GroupID = @GroupID,
                IsActive = @IsActive,
                ParentID = @ParentID,
                Name = @Name,
                [Description] = @Description,
                IsModerated = @IsModerated,
                ForumType = @ForumType,
                PublicView = @PublicView,
                UpdatedByUser = @UpdatedByUser,
                UpdatedDate = GETDATE(),
                PublicPosting = @PublicPosting,
                EnableForumsThreadStatus = @EnableForumsThreadStatus,
                EnableForumsRating = @EnableForumsRating,
                ForumLink = @ForumLink,
                ForumBehavior = @ForumBehavior,
                AllowPolls = @AllowPolls,
                EnableRSS = @EnableRSS,
                EmailAddress = @EmailAddress,
                EmailFriendlyFrom = @EmailFriendlyFrom,
                NotifyByDefault = @NotifyByDefault,
                EmailStatusChange = @EmailStatusChange,
                EmailServer = @EmailServer,
                EmailUser = @EmailUser,
                EmailPass = @EmailPass,
                EmailEnableSSL = @EmailEnableSSL,
                EmailAuth = @EmailAuth,
                EmailPort = @EmailPort,
                EnableSitemap = @EnableSitemap,
                SitemapPriority = @SitemapPriority
        WHERE   ForumID = @ForumID
        
        UPDATE  dbo.Forum_Forums
        SET     GroupID = @GroupID
        WHERE   ParentID = @ForumID
    END

GO