when i try to use some items or sell or drop some item iget dc
and have this msg from sr shard and sr gameserver

and this addlogitem
USE [SHARD_VICTOR]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 09-May-20 6:09:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_AddLogItem]
@
D int,@
RefID int,@
erial bigint,@
ta int,@
torage tinyint,@
tinyint,@
From tinyint,@
To tinyint,@
Pos varchar(64),@
esc varchar(128)as
declare @
_pos intdeclare @
_desc intset @
_pos = len @
Pos)set @
_desc = len @
esc)if @
_pos > 0 and @
_desc > 0)begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64)
values(GetDate(), @
D, @
RefID, @
ta, @
torage, @
, @
From, @
To, @
Pos, @
esc, @
erial)end
else if @
_pos > 0 and @
_desc = 0)begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64)
values(GetDate(), @
D, @
RefID, @
ta, @
torage, @
, @
From, @
To, @
Pos, @
erial)end
else if @
_pos = 0 and @
_desc > 0)begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64)
values(GetDate(), @
D, @
RefID, @
ta, @
torage, @
, @
From, @
To, @
esc, @
erial)end
else if @
_pos = 0 and @
_desc = 0)begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
values(GetDate(), @
D, @
RefID, @
ta, @
torage, @
, @
From, @
To, @
erial)end
-- 유료 아이템 구입이면!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if @
= 35)begin
insert LOG_VICTOR.._LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values @
RefID, @
D, @
ta, GetDate(), @
erial)end



.gif)


