83 lines
2 KiB
Transact-SQL
83 lines
2 KiB
Transact-SQL
CREATE PROCEDURE [dbo].[up_insert_log_item]
|
|
@log_type int
|
|
,@world_id int
|
|
,@auth_id uniqueidentifier
|
|
,@bcust_id nvarchar(24)
|
|
,@character_id uniqueidentifier
|
|
,@character_name nvarchar(16)
|
|
,@item_guid uniqueidentifier
|
|
,@item_id int
|
|
,@item_header int
|
|
,@enchant_level tinyint
|
|
,@item_active int
|
|
,@socket_count tinyint
|
|
,@remain_recon tinyint
|
|
,@item_option1 int
|
|
,@item_option2 int
|
|
,@item_option3 int
|
|
,@item_count int
|
|
,@target_itemid int
|
|
,@before_money int
|
|
,@after_money int
|
|
,@change_money int
|
|
,@result int
|
|
,@item_option_value1 int
|
|
,@item_option_value2 int
|
|
,@item_option_value3 int
|
|
|
|
--,@value1 int
|
|
--,@value2 int
|
|
--,@value3 int
|
|
-- ,@value4 int
|
|
-- ,@value5 int
|
|
-- ,@value6 int
|
|
-- ,@value7 int
|
|
-- ,@value8 int
|
|
-- ,@value9 int
|
|
-- ,@value10 int
|
|
--,@value11 int
|
|
-- ,@value1 int
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
as begin
|
|
|
|
set nocount on
|
|
-------------------------------------------------------
|
|
|
|
begin
|
|
exec RustyHearts_Log.dbo.up_set_item_log @log_type
|
|
,@world_id
|
|
,@auth_id
|
|
,@bcust_id
|
|
,@character_id
|
|
,@character_name
|
|
,@item_guid
|
|
,@item_id
|
|
,@item_header
|
|
,@enchant_level
|
|
,@item_active
|
|
,@socket_count
|
|
,@remain_recon
|
|
,@item_option1
|
|
,@item_option2
|
|
,@item_option3
|
|
,@item_count
|
|
,@target_itemid
|
|
,@before_money
|
|
,@after_money
|
|
,@change_money
|
|
,@result
|
|
,@item_option_value1
|
|
,@item_option_value2
|
|
,@item_option_value3
|
|
end
|
|
|
|
end
|
|
|
|
/****** Object: StoredProcedure [dbo].[up_insert_log_item_enchant] Script Date: 04/08/2011 23:12:49 ******/
|
|
SET ANSI_NULLS ON
|