CREATE PROCEDURE [dbo].[up_item_update]
	@character_id  [uniqueidentifier],
	@auth_id       [uniqueidentifier],
	@item_id       [uniqueidentifier],
	@use_cnt       int,
	@remain_time   int,
	@enhance_level int,
	@durability    int,
	@sock_optcode01 int,
	@sock_value01	int,
	@sock_optcode02 int,
	@sock_value02   int,
	@sock_optcode03 int,
	@sock_value03   int,
	@expiretime     int,
	@activity_value int, --활성석 추가
	@socket_1_color	tinyint,	-- 소켓
	@socket_2_color	tinyint,
	@socket_3_color	tinyint,
	@deferment_time int,
	@rank			tinyint,
	@acquireroute	tinyint,
	@physical		int,
	@magical		int,
	@durabilitymax	int,
	@weight			int,
	@socket_count	int,
	@option_group	int
as
set nocount on

	if exists ( select [item_uid] from dbo.N_InventoryItem with (READUNCOMMITTED) where item_uid = @item_id )
	begin
		update dbo.N_InventoryItem set 
		use_cnt        = @use_cnt,
		remain_time    = @remain_time,
		enhance_level  = @enhance_level,
		durability     = @durability,
		socket_1_code  = @sock_optcode01,
		socket_1_value = @sock_value01	,
		socket_2_code  = @sock_optcode02,
		socket_2_value = @sock_value02  ,
		socket_3_code  = @sock_optcode03,
		socket_3_value = @sock_value03  ,
		expire_time	   = @expiretime,
		activity_value = @activity_value,
		socket_1_color = @socket_1_color,	--소켓
		socket_2_color = @socket_2_color,
		socket_3_color = @socket_3_color,
		deferment_time = @deferment_time,
		rank		   = @rank,
		acquireroute   = @acquireroute,
		physical       = @physical,		
		magical        = @magical,		
		durabilitymax  = @durabilitymax,	
		weight         = @weight,
		socket_count   = @socket_count,
		option_group   = @option_group

		where item_uid = @item_id;
	end
	else 
	begin
		update dbo.N_EquipItem set 
		use_cnt        = @use_cnt,
		remain_time    = @remain_time,
		enhance_level  = @enhance_level,
		durability     = @durability,
		socket_1_code  = @sock_optcode01,
		socket_1_value = @sock_value01	,
		socket_2_code  = @sock_optcode02,
		socket_2_value = @sock_value02  ,
		socket_3_code  = @sock_optcode03,
		socket_3_value = @sock_value03,  
		expire_time	   = @expiretime,
		activity_value = @activity_value,
		socket_1_color = @socket_1_color,	--소켓
		socket_2_color = @socket_2_color,
		socket_3_color = @socket_3_color,
		deferment_time = @deferment_time,
		rank		   = @rank,
		acquireroute   = @acquireroute,
		physical       = @physical,		
		magical        = @magical,		
		durabilitymax  = @durabilitymax,	
		weight         = @weight,
		socket_count   = @socket_count,
		option_group   = @option_group

		where item_uid = @item_id;
	end

return @@error