-
Silks scroll
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
http://prntscr.com/5z7vwv
http://prntscr.com/5z7w8s
after using
http://prntscr.com/5z7wpk
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 ONGOSET QUOTED_IDENTIFIER ONGO
--------------------------------------------------------------------------------------------------------------------- Step 2-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤-- DataBase : Shard Log ALTER procedure [dbo].[_AddLogItem] [MENTION=551894]Char[/MENTION]ID int, @ItemRefID int, @ItemSerial bigint, @dwData int, [MENTION=1333461823]Target[/MENTION]Storage tinyint, [MENTION=2000154287]operation[/MENTION] tinyint, [MENTION=558012]slot[/MENTION]_From tinyint, [MENTION=558012]slot[/MENTION]_To tinyint, [MENTION=1333442518]even[/MENTION]tPos varchar(64), @strDesc varchar(128), [MENTION=496618]Gold[/MENTION] bigint -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ as declare @len_pos int declare @len_desc int set @len_pos = len [MENTION=1333442518]even[/MENTION]tPos) 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(), [MENTION=551894]Char[/MENTION]ID, @ItemRefID, @dwData, [MENTION=1333461823]Target[/MENTION]Storage, [MENTION=2000154287]operation[/MENTION], [MENTION=558012]slot[/MENTION]_From, [MENTION=558012]slot[/MENTION]_To, [MENTION=1333442518]even[/MENTION]tPos, @strDesc, @ItemSerial, [MENTION=496618]Gold[/MENTION]) -- #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(), [MENTION=551894]Char[/MENTION]ID, @ItemRefID, @dwData, [MENTION=1333461823]Target[/MENTION]Storage, [MENTION=2000154287]operation[/MENTION], [MENTION=558012]slot[/MENTION]_From, [MENTION=558012]slot[/MENTION]_To, [MENTION=1333442518]even[/MENTION]tPos, @ItemSerial, [MENTION=496618]Gold[/MENTION]) -- #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(), [MENTION=551894]Char[/MENTION]ID, @ItemRefID, @dwData, [MENTION=1333461823]Target[/MENTION]Storage, [MENTION=2000154287]operation[/MENTION], [MENTION=558012]slot[/MENTION]_From, [MENTION=558012]slot[/MENTION]_To, @strDesc, @ItemSerial, [MENTION=496618]Gold[/MENTION]) -- #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(), [MENTION=551894]Char[/MENTION]ID, @ItemRefID, @dwData, [MENTION=1333461823]Target[/MENTION]Storage, [MENTION=2000154287]operation[/MENTION], [MENTION=558012]slot[/MENTION]_From, [MENTION=558012]slot[/MENTION]_To, @ItemSerial, [MENTION=496618]Gold[/MENTION]) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ end -- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é! -- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35 if [MENTION=2000154287]operation[/MENTION] = 35) begin insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64) values(@ItemRefID, [MENTION=551894]Char[/MENTION]ID, @dwData, GetDate(), @ItemSerial) end-----AS4N0 ScrollsIF [MENTION=2000154287]operation[/MENTION] = 41 AND @ItemRefID = 41799)BEGINDECLARE [MENTION=820632]JiD[/MENTION] int [MENTION=372748]Silk[/MENTION] int;
SET [MENTION=372748]Silk[/MENTION] = 500SELECT [MENTION=820632]JiD[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = [MENTION=551894]Char[/MENTION]ID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=820632]JiD[/MENTION])UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=372748]Silk[/MENTION] where JID = [MENTION=820632]JiD[/MENTION]ELSEINSERT INTO SRO_VT_ACCOUNT..SK_SilkSELECT [MENTION=820632]JiD[/MENTION], [MENTION=372748]Silk[/MENTION], 0, 0END------500 silkIF [MENTION=2000154287]operation[/MENTION] = 41 AND @ItemRefID = 41798)BEGIN
SET [MENTION=372748]Silk[/MENTION] = 130SELECT [MENTION=820632]JiD[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = [MENTION=551894]Char[/MENTION]ID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=820632]JiD[/MENTION])UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=372748]Silk[/MENTION] where JID = [MENTION=820632]JiD[/MENTION]ELSEINSERT INTO SRO_VT_ACCOUNT..SK_SilkSELECT [MENTION=820632]JiD[/MENTION], [MENTION=372748]Silk[/MENTION], 0, 0END---IF [MENTION=2000154287]operation[/MENTION] = 41 AND @ItemRefID = 41800)BEGIN
SET [MENTION=372748]Silk[/MENTION] = 1000SELECT [MENTION=820632]JiD[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = [MENTION=551894]Char[/MENTION]ID
IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=820632]JiD[/MENTION])UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=372748]Silk[/MENTION] where JID = [MENTION=820632]JiD[/MENTION]ELSEINSERT INTO SRO_VT_ACCOUNT..SK_SilkSELECT [MENTION=820632]JiD[/MENTION], [MENTION=372748]Silk[/MENTION], 0, 1000END
Help pls, sorry bad english
-
Re: Silks scroll
"MENTION"? Never saw that kind of SP inside of vSRO databases...
Please repost your procedure with the original structure, e.g.:
Code:
USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 31.01.2015 12:44:13 ******/
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, ...
...
...
etc.
-
Re: Silks scroll
I know the cause, when I changed my SR_Gameserver by Evangelion no longer works.
How to solve this?
-
Re: Silks scroll
Isn't MENTION tags are happened by RaGEZONE Forums?
-
Re: Silks scroll
edit on srozor on config -misc.ini
to be like this
[misc]
disableMsg = 0
disableLog = 0
disableBsobjMsgbox=0
[spoof]
spoofIP = 0
spoofIPaddr =
-
Re: Silks scroll
