CREATE PROCEDURE dbo.[Forum_Post_Update]
    (
      @ThreadID INT,
      @PostID INT,
      @Subject NVARCHAR(255),
      @Body NVARCHAR(MAX),
      @IsPinned BIT,
      @PinnedDate DATETIME,
      @IsClosed BIT,
      @UpdatedByUser INT,
      @PortalID INT,
      @PollID INT,
      @ParseInfo INT
    )
AS
    DECLARE @ForumID INT
    DECLARE @GroupID INT

    SELECT  @ForumID = ForumID
    FROM    dbo.Forum_Threads
    WHERE   ThreadID = @ThreadID
    
    SELECT  @GroupID = GroupID
    FROM    dbo.Forum_Forums
    WHERE   ForumID = @ForumID

    UPDATE  dbo.Forum_Posts
    SET     [Subject] = @Subject,
            Body = @Body,
            UpdatedDate = GETDATE(),
            IsClosed = @IsClosed,
            UpdatedByUser = @UpdatedByUser,
            ParseInfo = @ParseInfo
    WHERE   PostID = @PostID    
        
    EXEC dbo.Forum_AA_ThreadUpdate @ThreadID, @PostID, @IsPinned, @PinnedDate,
        'postedit', @PollID
        
    SELECT  @GroupID AS GroupID

GO