CREATE PROCEDURE dbo.Forum_Post_Reported_Address
    (
      @PostReportedID INT,
      @UserID INT,
      @PortalID INT
    )
AS
    DECLARE @PostID INT
    DECLARE @Count INT

    SET @PostID = ( SELECT  PostID
                    FROM    dbo.Forum_Post_Reported
                    WHERE   PostReportedID = @PostReportedID
                  )
    SET @Count = ( SELECT   COUNT(PostID)
                   FROM     dbo.Forum_Post_Reported
                   WHERE    PostID = @PostID
                            AND Addressed = 1
                 )

    UPDATE  dbo.Forum_Posts
    SET     Addressed = @Count + 1
    WHERE   PostID = @PostID

    UPDATE  dbo.Forum_Post_Reported
    SET     Addressed = 1
    WHERE   PostReportedID = @PostReportedID

    EXEC dbo.Forum_Moderate_AddHistory @PostID, @PortalID, @UserID, '',
        13

    SELECT  @PostID

GO