/****** Object:  Stored Procedure dbo.lin_AdenaChange    Script Date: 2003-09-20 오전 11:51:56 ******/
/********************************************
lin_AdenaChange
	change adena and return result amount
INPUT
	@char_id	INT,
	@price	 	INT
OUTPUT
	adena id		INT,
	amount		INT
return
made by
	carrot
date
	2002-04-22
********************************************/
CREATE PROCEDURE [DBO].[lin_AdenaChange]
(
	@char_id	INT,
	@price	 	INT
)
AS
SET NOCOUNT ON

DECLARE @nAmount	INT

SET @nAmount = NULL

SELECT @nAmount = amount FROM user_item WHERE char_id = @char_id AND item_type = 57
IF @nAmount IS NULL
	BEGIN
		SELECT -1, -1
	END
ELSE IF @nAmount + @price < 0
	BEGIN
		SELECT -1, -1
	END
ELSE
	BEGIN
		UPDATE user_item SET amount = amount + @price WHERE char_id = @char_id AND item_type = 57 AND warehouse = 0
		SELECT item_id, amount FROM user_item WHERE char_id = @char_id AND item_type = 57 AND warehouse = 0
	END





GO