Anonymous

USE [lin2world]
GO
/****** Object:  StoredProcedure [dbo].[lin_CreateItem]    Script Date: 11/08/2011 21:58:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/****** Object:  Stored Procedure dbo.lin_CreateItem    Script Date: 2003-09-20 오전 11:51:57 ******/
/********************************************
lin_CreateItem
	create item sp
INPUT
	@char_id	INT,
	@item_type 	INT,
	@amount 	INT,
	@enchant 	INT,
	@eroded 	INT,
	@bless 		TINYINT,
	@ident 		TINYINT,
	@ready 		TINYINT,
	@wished 	TINYINT,
	@warehouse	INT,
 	@variation_opt1 INT,
	@variation_opt2 INT,
	@intensive_item_type INT
OUTPUT
	Item_ID, @@IDENTITY
return
made by
	carrot
date
	2002-01-31
modified by 
	kernel0
modified date 
	2006-10-16	
********************************************/
ALTER PROCEDURE [dbo].[lin_CreateItem]
(
@char_id	INT,
@item_type 	INT,
@amount 	BIGINT,
@enchant 	INT,
@eroded 	INT,
@bless 		INT,
@ident 		INT,
@wished 	TINYINT,
@warehouse	INT,
@variation_opt1 INT,
@variation_opt2 INT,
@intensive_item_type INT
)
AS
SET NOCOUNT ON

--FOR TEST
/*
IF (select is_stackable from itemdata where item_type = @item_type) > 0
begin
	set @amount = @amount + 2150000000
end
*/

insert into user_item 
	(char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse, variation_opt1, variation_opt2, intensive_item_type) 
	values 
	(@char_id, @item_type , @amount , @enchant , @eroded , @bless , @ident , @wished , @warehouse, @variation_opt1, @variation_opt2, @intensive_item_type)
SELECT @@IDENTITY