CREATE PROCEDURE forums_BlockedIpAddress_CreateUpdateDelete
(
@IpID int = 0 out,
@DeleteBlockedIpAddress bit = 0,
@Address nvarchar(50) = '',
@Reason nvarchar(512) = '',
@ExpireDate DateTime
)
AS
-- Are we deleting the role?
IF @DeleteBlockedIpAddress = 1
BEGIN
DELETE
forums_BlockedIpAddresses
WHERE
IpID = @IpID
RETURN
END
-- Are we updating a forum
IF @IpID > 0
BEGIN
-- Update the role
UPDATE
forums_BlockedIpAddresses
SET
Address = @Address,
Reason = @Reason,
[ExpireDate]=@ExpireDate
WHERE
IpID = @IpID
END
ELSE
BEGIN
-- Create a new Forum
INSERT INTO
forums_BlockedIpAddresses (
Address,
Reason,
[ExpireDate]
)
VALUES (
@Address,
@Reason,
@ExpireDate
)
SET @IpID = @@Identity
END
GO