set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
/****** Object: Stored Procedure dbo.spInsertCharItem Script Date: 5/10/2007 3:42:11 PM ******/
/* 캐릭터 아이템 추가 - 땜빵 */
ALTER PROC [dbo].[spInsertCharItem]
@CID int,
@ItemID int,
@per int
AS
SET NOCOUNT ON
DECLARE @OrderCIID int
DECLARE @varBP int
-- 땜빵
SELECT @varBP = BP FROM Character where CID=@CID
IF @varBP < 0
BEGIN
UPDATE Character SET BP=0 WHERE CID=@CID
RETURN (-1)
END
BEGIN TRAN
INSERT INTO CharacterItem (CID, ItemID, RegDate, RentDate, RentHourPeriod) Values (@CID, @ItemID, GETDATE(), GETDATE(), @per)
IF 0 <> @@ERROR BEGIN
ROLLBACK TRAN
RETURN (-1)
END
COMMIT TRAN
SET @OrderCIID = @@IDENTITY
SELECT @OrderCIID as ORDERCIID
