CREATE PROCEDURE [dbo].[up_insert_reward_item]
@reward_type	int,
@reward_grade	int,
--------------------------------------------
@sender_name		nvarchar(16),
@recver_name		nvarchar(16),
@msg				nvarchar(100),
@money				int,
@return_day			int,
@req_money			int,
@mail_id			[uniqueidentifier],
@createType			int,
--------------------------------------------
@item_id			[uniqueidentifier],
@code				int,
@use_cnt			int,
@remain_time		int,
@gcode				int,
@durability			int,
@enhance_level		int,
@option_1_code		int,
@option_1_value		int,
@option_2_code		int,
@option_2_value		int,
@option_3_code		int,
@option_3_value		int,
@option_group		int,
@ReconNum			int,
@ReconState			tinyint,
@socket_count		int,
@socket_1_code		int,
@socket_1_value		int,
@socket_2_code		int,
@socket_2_value		int,
@socket_3_code		int,
@socket_3_value		int,
@expire_time		int,
@activity_value     int,--활성석 20100928 jojo
@link_id			[uniqueidentifier],
@socket_1_color		tinyint,
@socket_2_color		tinyint,
@socket_3_color		tinyint,
@rank				tinyint,
@acquireroute	tinyint,
@physical		int,
@magical		int,
@durabilitymax	int,
@weight			int

as
set nocount on

declare @character_id [uniqueidentifier],
		@auth_id [uniqueidentifier]

begin tran
	select @auth_id = [AuthID], @character_id = [character_id] from CharacterTable with (READUNCOMMITTED) where [Name] = @recver_name
	insert into MailTable	values	(	@mail_id,           --0
										@character_id,        --1
										@recver_name,         --2
										@character_id, --3
										@sender_name,         --4
										@msg,         --3
										@money,       --4
										@return_day,
										@req_money,
										0,            --8
										GETDATE(),
										@createType );
	Exec dbo.up_insert_item_MailItem	@character_id,
										@auth_id,
										@item_id,
										@code,
										@use_cnt,
										@remain_time,
										@gcode,
										@durability,
										@enhance_level,
										@option_1_code,
										@option_1_value,
										@option_2_code,
										@option_2_value,
										@option_3_code,
										@option_3_value,
										@option_group,
										@ReconNum,
										@ReconState,
										@socket_count,
										@socket_1_code,
										@socket_1_value,
										@socket_2_code,
										@socket_2_value,
										@socket_3_code,
										@socket_3_value,
										@expire_time,
										@mail_id,
										@activity_value, --활성석 20100928 jojo			
										@link_id,
										@socket_1_color,
										@socket_2_color,
										@socket_3_color,
										@rank,
										@acquireroute,
										@physical,
										@magical,
										@durabilitymax,
										@weight

	exec dbo.up_update_reward	@character_id,
								@reward_type,
								@code,
								@use_cnt,
								@reward_grade,
								1

declare @ERR int

SET @ERR = @@ERROR
IF @ERR <> 0
BEGIN
	RAISERROR('처리오류', 16, 10)
	IF @@TRANCOUNT <> 0  ROLLBACK
	RETURN (@ERR)
END

COMMIT TRAN