|
You last visited: Today at 16:43
Advertisement
addlogitem
Discussion on addlogitem within the SRO Private Server forum part of the Silkroad Online category.
12/11/2014, 02:19
|
#1
|
elite*gold: 0
Join Date: May 2013
Posts: 227
Received Thanks: 13
|
addlogitem
red line`s in addlogitem`S
db castaway ! what can i do to fix ? it
|
|
|
12/11/2014, 11:02
|
#2
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Copy the whole procedure and add it here
|
|
|
12/11/2014, 14:25
|
#3
|
elite*gold: 0
Join Date: May 2013
Posts: 227
Received Thanks: 13
|
Quote:
Originally Posted by xExorcist
Copy the whole procedure and add it here
|
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 11/12/2014 03:24:57 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128)
as
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial)
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial)
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial)
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial)
end
-- 유료 아이템 구입이면!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end
done
|
|
|
12/11/2014, 14:50
|
#4
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Wait a min, are you trying to modify _AddLogItem @ Shard?
|
|
|
12/11/2014, 19:34
|
#5
|
elite*gold: 0
Join Date: May 2013
Posts: 227
Received Thanks: 13
|
ye !!
|
|
|
12/11/2014, 20:14
|
#6
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Log >> check the procedure there
|
|
|
Similar Threads
|
[Procedures] AddLogItem and AddLogChar
07/16/2013 - SRO Coding Corner - 3 Replies
Hi.
Can someone explain me the IDs or this procedures on logs db?
I mean, on AddLogChar procedure there is "@EventID" which stands for the different events.. I only know that ID "9" is when you teleport.. Do you know any other IDs?
And for AddLogItem there is @Operation, which stands for the different type events with the item.. And I figured out that @Operation "90" is when plusing your item..
Is there an ID that explain the all the IDs or maybe most of them?
|
All times are GMT +2. The time now is 16:43.
|
|