Hello friends, I wanted to help all of you, Silk scroll works fine for me, but stopped working for no reason. I'm desperate, help me my server needs it.
images
after using
Simply does not work anymore
my procedure
PHP Code:
USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 01/31/2015 03:23:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
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),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ
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, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
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, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
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, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
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
-----AS4N0 Scrolls
IF (@Operation = 41 AND @ItemRefID = 41799)
BEGIN
DECLARE @JID int,
@Silk int;
SET @Silk = 500
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
------500 silk
IF (@Operation = 41 AND @ItemRefID = 41798)
BEGIN
SET @Silk = 130
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
---
IF (@Operation = 41 AND @ItemRefID = 41800)
BEGIN
SET @Silk = 1000
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 1000
END
I am too lazy too read it but, things do not simply 'stop working' maybe you played with the procedure. Just get another non-edited AddLogItem and re add those silk scrolls.
