95 lines
2.2 KiB
Transact-SQL
95 lines
2.2 KiB
Transact-SQL
CREATE PROCEDURE [dbo].[up_reward_mail_item]
|
|
@bcust_id nvarchar(50)
|
|
AS
|
|
BEGIN
|
|
|
|
set nocount on
|
|
set xact_abort on
|
|
|
|
declare @recvName nvarchar(16)
|
|
declare @recvCharID uniqueidentifier
|
|
declare @recvAuthID uniqueidentifier
|
|
declare @mailID uniqueidentifier
|
|
declare @rewardItemID uniqueidentifier
|
|
|
|
SELECT top 1 @recvAuthID = [AuthID], @recvCharID = [character_id],@recvName = [Name] FROM [dbo].[CharacterTable] with (READUNCOMMITTED) where [bcust_id]=@bcust_id and Block_Type > 0 order by [level] desc
|
|
|
|
set @mailID = NewID()
|
|
set @rewardItemID = NewID()
|
|
|
|
INSERT INTO [dbo].[N_InventoryItem]
|
|
([item_uid]
|
|
,[character_id]
|
|
,[auth_id]
|
|
,[page_index]
|
|
,[slot_index]
|
|
,[code]
|
|
,[use_cnt]
|
|
,[remain_time]
|
|
,[create_time]
|
|
,[update_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]
|
|
,[lock_pwd]
|
|
,[activity_value]
|
|
,[socket_1_color]
|
|
,[socket_2_color]
|
|
,[socket_3_color] )
|
|
VALUES
|
|
( @rewardItemID
|
|
, @recvCharID
|
|
, @recvAuthID
|
|
, 10
|
|
, 1
|
|
, 70000007
|
|
, 1
|
|
, 0
|
|
, GetDate()
|
|
, GetDate()
|
|
, 777
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0
|
|
, 0 )
|
|
|
|
exec dbo.up_insert_mail_item01 @recvCharID, 'GM', @recvName, '태초의 계약자 칭호 아이템', 0, 0, 0, @mailID, 777, @rewardItemID, 1
|
|
|
|
end
|