cs_moderate_deletepost.prc

解压即可使用

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cs_Moderate_DeletePost]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_Moderate_DeletePost]
GO







CREATE        PROCEDURE [dbo].cs_Moderate_DeletePost
(
	@PostID INT,
	@DeletedBy INT,
	@Reason NVARCHAR(1024),
	@DeleteChildPosts BIT = 1,
	@SettingsID int
)
AS
SET Transaction Isolation Level Read UNCOMMITTED
DECLARE @IsApproved bit

-- First, get information about the post that is about to be deleted.
SELECT
    @IsApproved = IsApproved
FROM
    cs_Posts
WHERE
    PostID = @PostID and SettingsID = @SettingsID

-- If the post is not approved, permanently delete the post, otherwise, execute forums_Post_Delete
IF @IsApproved = 0
BEGIN
	
    -- Delete the post.
    DELETE FROM cs_Posts
    WHERE PostID = @PostID and SettingsID = @SettingsID

END	
ELSE
    EXEC cs_system_DeletePostAndChildren @PostID = @PostID, @DeleteChildren = @DeleteChildPosts, @SettingsID = @SettingsID

-- Update Moderation Audit table
exec cs_system_ModerationAction_AuditEntry 4, @DeletedBy, @PostID, null, null, @SettingsID, @Reason












GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

grant execute on [dbo].[cs_Moderate_DeletePost] to public
go