[Help please!]

USE [Telecaster]
GO

/****** Object:  StoredProcedure [dbo].[smp_takeout_commercial_item]    Script Date: 8/1/2012 9:38:40 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[smp_takeout_commercial_item]

@OUT_ITEM_CODE          INT OUTPUT,
@IN_SID                 INT,
@IN_COUNT               INT,
@IN_ACCOUNT_ID          INT,
@IN_AVATAR_ID           INT,
@IN_AVATAR_NAME         VARCHAR(61),
@IN_SERVER_NAME         VARCHAR(30),
@IN_TRANSACTION_CODE	INT,
@IN_IDX					INT
 
AS
SET NOCOUNT ON

SET @OUT_ITEM_CODE = 0

DECLARE @RET INT
SET @RET = -1

DECLARE @REST_ITEM_COUNT INT
SET @REST_ITEM_COUNT = -1

-- °¹¼ِ ہج»َ
IF @IN_COUNT < 1
BEGIN
    GOTO ON_END
END

BEGIN TRANSACTION

	SELECT @REST_ITEM_COUNT = rest_item_count FROM dbo.PaidItem WHERE sid = @IN_SID;

	IF @REST_ITEM_COUNT < @IN_COUNT
	BEGIN
		ROLLBACK TRANSACTION
        GOTO ON_END
	END

	-- Remove item(s) from Item Box
	UPDATE dbo.PaidItem SET

        rest_item_count = ( @REST_ITEM_COUNT - @IN_COUNT ),
        taken_avatar_id = @IN_AVATAR_ID,
        taken_avatar_name = @IN_AVATAR_NAME,
        taken_server_name = @IN_SERVER_NAME,
        taken_time = GETDATE()
        
    WHERE sid = @IN_SID and taken_account_id = @IN_ACCOUNT_ID;
    SET @RET = 0

	DECLARE @ACCOUNT_ID INT
	SET @ACCOUNT_ID = -1

	SELECT @OUT_ITEM_CODE = item_code, @ACCOUNT_ID = taken_account_id from dbo.PaidItem where sid = @IN_SID;

	IF @ACCOUNT_ID <> @IN_ACCOUNT_ID
		BEGIN
			SET @OUT_ITEM_CODE = 0
			ROLLBACK TRANSACTION
			GOTO ON_END
		END

	-- Add the item(s) to the character
	INSERT INTO dbo.Item (

		sid,							-- 0
		owner_id,						-- 1
		account_id,						-- 2
		summon_id,						-- 3
		auction_id,						-- 4
		keeping_id,						-- 5
		idx,							-- 6
		code,							-- 7
		flag,							-- 8
		cnt,							-- 9
		[level],						-- 10
		enhance,
		ethereal_durability,						-- 11
		endurance,						-- 12
		gcode,							-- 13
		create_time,						-- 14
		wear_info,						-- 15
		socket_0,						-- 16
		socket_1,						-- 17
		socket_2,						-- 18
		socket_3,						-- 19
		remain_time,						-- 20
		elemental_effect_type,					-- 21
		elemental_effect_expire_time,				-- 22
		elemental_effect_attack_point,				-- 23
		elemental_effect_magic_point,				-- 24
		update_time						-- 25

	)
	VALUES (
	
		@IN_TRANSACTION_CODE,					-- 0
		@IN_AVATAR_ID,						-- 1
		@IN_ACCOUNT_ID,						-- 2
		0,							-- 3
		0,							-- 4
		0,							-- 5
		@IN_IDX,						-- 6
		@OUT_ITEM_CODE,						-- 7
		0,							-- 8
		@IN_COUNT,						-- 9
		0,							-- 10
		0,
		0,							-- 11
		0,							-- 12
		0,							-- 13
		GETDATE(),						-- 14	
		-1,							-- 15
		0,							-- 16
		0,							-- 17
		0,							-- 18
		0,							-- 19
		0,							-- 20
		0,							-- 21
		0,							-- 22
		0,							-- 23
		0,							-- 24
		GETDATE()						-- 25
	);

	SET @RET = @@ERROR

	IF @RET <> 0
	BEGIN
		ROLLBACK TRANSACTION
        GOTO ON_END
	END

COMMIT TRANSACTION

ON_END:
RETURN @RET



GO