57 lines
1.1 KiB
Transact-SQL
57 lines
1.1 KiB
Transact-SQL
CREATE PROCEDURE [dbo].[up_read_item_mail]
|
|
@character_id [uniqueidentifier]
|
|
|
|
as
|
|
set nocount on
|
|
set transaction isolation level read uncommitted
|
|
|
|
select
|
|
[item_uid]
|
|
,[mail_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]
|
|
,[link_id]
|
|
,[is_seizure]
|
|
,[socket_1_color]
|
|
,[socket_2_color]
|
|
,[socket_3_color]
|
|
,[rank]
|
|
,[acquireroute]
|
|
,[physical]
|
|
,[magical]
|
|
,[durabilitymax]
|
|
,[weight]
|
|
|
|
|
|
from dbo.N_MailItem with (nolock) where character_id = @character_id;
|
|
|
|
return @@error
|