CREATE PROCEDURE dbo.Forum_Moderate_Delete
    @PostID INT,
    @ModeratorID INT,
    @Notes NVARCHAR(1024),
    @Approved BIT,
    @PortalID INT,
    @ThreadID INT,
    @ForumID INT,
    @GroupID INT,
    @AuthorID INT
AS
    DECLARE @PostsToModerate INT

    IF @Approved = 1
        BEGIN
            UPDATE  dbo.Forum_Users
            SET     PostCount = PostCount - 1
            WHERE   UserID = @AuthorID
                    AND PortalID = @PortalID
        END
    ELSE
        BEGIN
            SET @PostsToModerate = ( SELECT COUNT(IsApproved)
                                     FROM   dbo.Forum_Posts FP
                                            INNER JOIN dbo.Forum_Threads FT ON FP.ThreadID = FT.ThreadID
                                            INNER JOIN dbo.Forum_Forums FF ON FT.ForumID = FF.ForumID
                                     WHERE  FT.ForumID = @ForumID
                                            AND FP.IsApproved = 0
                                   )
            UPDATE  dbo.Forum_Forums
            SET     PostsToModerate = @PostsToModerate
            WHERE   ForumID = @ForumID
        END
    EXEC dbo.Forum_Moderate_AddHistory @PostID, @PortalID, @ModeratorID,
        @Notes, 3

GO