say i was banning somebody named "Joe", UID number "47" how would this procedure be modified?
Code:
USE [PS_userdata]
GO
/****** Object: StoredProcedure [dbo].[usp_Update_UserStatus] Script Date: 07/21/2010 14:26:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/****** Object: Stored Procedure dbo.usp_Update_UserStatus Script Date: 2008-6-7 18:34:05 ******/
/*==================================================
@author lenasoft
@date 2006-10-27
@return
@brief 상태변경.
==================================================*/
ALTER Proc [dbo].[usp_Update_UserStatus]
@UserUID int,
@Status smallint,
@BlockEndDate datetime = null,
@GmID varchar(32) = null
AS
SET NOCOUNT ON
DECLARE
@ReturnValue int
BEGIN TRAN
UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
IF @@ERROR <> 0
GOTO ERROR
-- Block Set
IF ( @Status = 2 )
BEGIN
IF EXISTS ( SELECT UserUID FROM Users_Block WHERE UserUID = @UserUID )
BEGIN
UPDATE Users_Block SET BlockEndDate = @BlockEndDate
WHERE UserUID = @UserUID
END
ELSE
BEGIN
INSERT INTO Users_Block ( UserUID, BlockEndDate)
VALUES( @UserUID, @BlockEndDate )
END
END
IF @@ERROR <> 0
GOTO ERROR
-- InsertLog
IF ( @GmID IS NOT NULL )
BEGIN
INSERT INTO Users_BlockLog ( UserUID, Status, BlockEndDate, GmID, InsertDate)
VALUES( @UserUID, @Status, @BlockEndDate, @GmID, GETDATE() )
IF @@ERROR <> 0
GOTO ERROR
END
SET @ReturnValue = 1
COMMIT TRAN
SET NOCOUNT OFF
RETURN @ReturnValue
ERROR:
SET @ReturnValue = -1
ROLLBACK TRAN
SET NOCOUNT OFF
RETURN @ReturnValue