Hello
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 [Only registered and activated users can see links. Click Here To Register...]
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]
@[Only registered and activated users can see links. Click Here To Register...]D int,
@[Only registered and activated users can see links. Click Here To Register...]RefID int,
@[Only registered and activated users can see links. Click Here To Register...]erial bigint,
@[Only registered and activated users can see links. Click Here To Register...]ta int,
@[Only registered and activated users can see links. Click Here To Register...]torage tinyint,
@[Only registered and activated users can see links. Click Here To Register...] tinyint,
@[Only registered and activated users can see links. Click Here To Register...]From tinyint,
@[Only registered and activated users can see links. Click Here To Register...]To tinyint,
@[Only registered and activated users can see links. Click Here To Register...]Pos varchar(64),
@[Only registered and activated users can see links. Click Here To Register...]esc varchar(128)
as
declare @[Only registered and activated users can see links. Click Here To Register...]_pos int
declare @[Only registered and activated users can see links. Click Here To Register...]_desc int
set @[Only registered and activated users can see links. Click Here To Register...]_pos = len @[Only registered and activated users can see links. Click Here To Register...]Pos)
set @[Only registered and activated users can see links. Click Here To Register...]_desc = len @[Only registered and activated users can see links. Click Here To Register...]esc)
if @[Only registered and activated users can see links. Click Here To Register...]_pos > 0 and @[Only registered and activated users can see links. Click Here To Register...]_desc > 0)
begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64)
values(GetDate(), @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]ta, @[Only registered and activated users can see links. Click Here To Register...]torage, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]From, @[Only registered and activated users can see links. Click Here To Register...]To, @[Only registered and activated users can see links. Click Here To Register...]Pos, @[Only registered and activated users can see links. Click Here To Register...]esc, @[Only registered and activated users can see links. Click Here To Register...]erial)
end
else if @[Only registered and activated users can see links. Click Here To Register...]_pos > 0 and @[Only registered and activated users can see links. Click Here To Register...]_desc = 0)
begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64)
values(GetDate(), @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]ta, @[Only registered and activated users can see links. Click Here To Register...]torage, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]From, @[Only registered and activated users can see links. Click Here To Register...]To, @[Only registered and activated users can see links. Click Here To Register...]Pos, @[Only registered and activated users can see links. Click Here To Register...]erial)
end
else if @[Only registered and activated users can see links. Click Here To Register...]_pos = 0 and @[Only registered and activated users can see links. Click Here To Register...]_desc > 0)
begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64)
values(GetDate(), @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]ta, @[Only registered and activated users can see links. Click Here To Register...]torage, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]From, @[Only registered and activated users can see links. Click Here To Register...]To, @[Only registered and activated users can see links. Click Here To Register...]esc, @[Only registered and activated users can see links. Click Here To Register...]erial)
end
else if @[Only registered and activated users can see links. Click Here To Register...]_pos = 0 and @[Only registered and activated users can see links. Click Here To Register...]_desc = 0)
begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
values(GetDate(), @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]ta, @[Only registered and activated users can see links. Click Here To Register...]torage, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]From, @[Only registered and activated users can see links. Click Here To Register...]To, @[Only registered and activated users can see links. Click Here To Register...]erial)
end
-- 유료 아이템 구입이면!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if @[Only registered and activated users can see links. Click Here To Register...] = 35)
begin
insert LOG_VICTOR.._LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]ta, GetDate(), @[Only registered and activated users can see links. Click Here To Register...]erial)
end
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 [Only registered and activated users can see links. Click Here To Register...]
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]
@[Only registered and activated users can see links. Click Here To Register...]D int,
@[Only registered and activated users can see links. Click Here To Register...]RefID int,
@[Only registered and activated users can see links. Click Here To Register...]erial bigint,
@[Only registered and activated users can see links. Click Here To Register...]ta int,
@[Only registered and activated users can see links. Click Here To Register...]torage tinyint,
@[Only registered and activated users can see links. Click Here To Register...] tinyint,
@[Only registered and activated users can see links. Click Here To Register...]From tinyint,
@[Only registered and activated users can see links. Click Here To Register...]To tinyint,
@[Only registered and activated users can see links. Click Here To Register...]Pos varchar(64),
@[Only registered and activated users can see links. Click Here To Register...]esc varchar(128)
as
declare @[Only registered and activated users can see links. Click Here To Register...]_pos int
declare @[Only registered and activated users can see links. Click Here To Register...]_desc int
set @[Only registered and activated users can see links. Click Here To Register...]_pos = len @[Only registered and activated users can see links. Click Here To Register...]Pos)
set @[Only registered and activated users can see links. Click Here To Register...]_desc = len @[Only registered and activated users can see links. Click Here To Register...]esc)
if @[Only registered and activated users can see links. Click Here To Register...]_pos > 0 and @[Only registered and activated users can see links. Click Here To Register...]_desc > 0)
begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64)
values(GetDate(), @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]ta, @[Only registered and activated users can see links. Click Here To Register...]torage, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]From, @[Only registered and activated users can see links. Click Here To Register...]To, @[Only registered and activated users can see links. Click Here To Register...]Pos, @[Only registered and activated users can see links. Click Here To Register...]esc, @[Only registered and activated users can see links. Click Here To Register...]erial)
end
else if @[Only registered and activated users can see links. Click Here To Register...]_pos > 0 and @[Only registered and activated users can see links. Click Here To Register...]_desc = 0)
begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64)
values(GetDate(), @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]ta, @[Only registered and activated users can see links. Click Here To Register...]torage, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]From, @[Only registered and activated users can see links. Click Here To Register...]To, @[Only registered and activated users can see links. Click Here To Register...]Pos, @[Only registered and activated users can see links. Click Here To Register...]erial)
end
else if @[Only registered and activated users can see links. Click Here To Register...]_pos = 0 and @[Only registered and activated users can see links. Click Here To Register...]_desc > 0)
begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64)
values(GetDate(), @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]ta, @[Only registered and activated users can see links. Click Here To Register...]torage, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]From, @[Only registered and activated users can see links. Click Here To Register...]To, @[Only registered and activated users can see links. Click Here To Register...]esc, @[Only registered and activated users can see links. Click Here To Register...]erial)
end
else if @[Only registered and activated users can see links. Click Here To Register...]_pos = 0 and @[Only registered and activated users can see links. Click Here To Register...]_desc = 0)
begin
insert LOG_VICTOR.._LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
values(GetDate(), @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]ta, @[Only registered and activated users can see links. Click Here To Register...]torage, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]From, @[Only registered and activated users can see links. Click Here To Register...]To, @[Only registered and activated users can see links. Click Here To Register...]erial)
end
-- 유료 아이템 구입이면!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if @[Only registered and activated users can see links. Click Here To Register...] = 35)
begin
insert LOG_VICTOR.._LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values @[Only registered and activated users can see links. Click Here To Register...]RefID, @[Only registered and activated users can see links. Click Here To Register...]D, @[Only registered and activated users can see links. Click Here To Register...]ta, GetDate(), @[Only registered and activated users can see links. Click Here To Register...]erial)
end