the scroll teleport me but no silk
and this _LogEventItem
capovip, thanks for your screenshot!
Column ItemRefID from SRO_VT_LOG._LogEventItem on your picture shows an ID of 50000. But remember that you have added an ID of 36790 to _RefObjCommon and itemdata_45000.txt
The amended stored procedure (SRO_VT_SHARD._AddLogItem) will not activate unless this matches:
Code:
IF (@Operation = 41 AND @ItemRefID = 36790)
The server seems to be detecting the proper scroll right clicking event (41) but receiving a wrong object/scroll ID number (ItemRefID)
BTW, question to ˛˛Rock˛˛: Why does RefObjItem.txt in Silk Scroll - 1000.rar give the object/scroll ID as 26713 to be added to the server's _RefObjItem?
first thanks for your answer
i do all id right in db and media side and the scroll working only in teleport but not give silk i will uplaod my txt for u check , thanks for replay
capovip, first I want to say I haven't installed this to see if it's working or not. I see you have changed the scroll's ID to 50000. Should not be a problem.
Can you try running the stored proc's code in a new query window. Everything from BEGIN to END (including both keywords). I also wonder if you manually give a character some silk, if this scroll will be able to increase the silk on the account.
Column ItemRefID from SRO_VT_LOG._LogEventItem on your picture shows an ID of 50000. But remember that you have added an ID of 36790 to _RefObjCommon and itemdata_45000.txt
The amended stored procedure (SRO_VT_SHARD._AddLogItem) will not activate unless this matches:
Code:
IF (@Operation = 41 AND @ItemRefID = 36790)
The server seems to be detecting the proper scroll right clicking event (41) but receiving a wrong object/scroll ID number (ItemRefID)
BTW, question to ˛˛Rock˛˛: Why does RefObjItem.txt in Silk Scroll - 1000.rar give the object/scroll ID as 26713 to be added to the server's _RefObjItem?
You gotta edit it. Should I do it manually for the people? I edited/updated the thread
Useful release
But can i change 1000 and write 500 and scrol will be 500 silk ?
The Item Will Write in ur dbo.Silk what Procedure _AddLogItem Indicate..
Then He make it in this lines ..
Quote:
SET @Silk = 1000
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID
Quote:
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
The RED IS SILK AMOUNT IS ADD IN CHAR.
THE BLUE IS COMANDE .. He is ADD silks to char .. Exemple .. If char have 50 silks and use scroll. he is add more 1.000 Then (Silk-own (is silk he alhead have ) + @silk (is 1.000) . after this he have 1.050 silves..
But if u wanna add more then 1 Tipe of Scrool .. u need declare others value .. try this ..
=-=- Silks Scrool 500 created By Spinal2 -> chaparim -=-=
IF (@Operation = 16 AND @ItemRefID = 36790)
BEGIN
DECLARE @Silk2 int;
SET @Silk2 = 500
SELECT @JID = UserJID from SRO_VT_SHARD.dbo._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT.dbo.SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @Silk2 where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk
SELECT @JID, @Silk2, 0, 0
END
You need add News Lines in _RefObjCommon and _RefObjItem To take ID From Common Like
The Item Will Write in ur dbo.Silk what Procedure _AddLogItem Indicate..
Then He make it in this lines ..
The RED IS SILK AMOUNT IS ADD IN CHAR.
THE BLUE IS COMANDE .. He is ADD silks to char .. Exemple .. If char have 50 silks and use scroll. he is add more 1.000 Then (Silk-own (is silk he alhead have ) + @silk (is 1.000) . after this he have 1.050 silves..
But if u wanna add more then 1 Tipe of Scrool .. u need declare others value .. try this ..
=-=- Silks Scrool 500 created By Spinal2 -> chaparim -=-=
IF (@Operation = 16 AND @ItemRefID = 36790)
BEGIN
DECLARE @JID int,
@Silk2 int;
SET @Silk2 = 500
SELECT @JID = UserJID from SRO_VT_SHARD.dbo._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT.dbo.SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @Silk2 where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk
SELECT @JID, @Silk2, 0, 0
END
You need add News Lines in _RefObjCommon and _RefObjItem To take ID From Common Like
The Item Will Write in ur dbo.Silk what Procedure _AddLogItem Indicate..
Then He make it in this lines ..
The RED IS SILK AMOUNT IS ADD IN CHAR.
THE BLUE IS COMANDE .. He is ADD silks to char .. Exemple .. If char have 50 silks and use scroll. he is add more 1.000 Then (Silk-own (is silk he alhead have ) + @silk (is 1.000) . after this he have 1.050 silves..
But if u wanna add more then 1 Tipe of Scrool .. u need declare others value .. try this ..
=-=- Silks Scrool 500 created By Spinal2 -> chaparim -=-=
IF (@Operation = 16 AND @ItemRefID = 36790)
BEGIN
DECLARE @Silk2 int;
SET @Silk2 = 500
SELECT @JID = UserJID from SRO_VT_SHARD.dbo._User where CharID = @CharID
IF EXISTS (Select * from SRO_VT_ACCOUNT.dbo.SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @Silk2 where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk
SELECT @JID, @Silk2, 0, 0
END
You need add News Lines in _RefObjCommon and _RefObjItem To take ID From Common Like
Same if u wanna add more Scroll just change @Silkx and value ...
Reguard !!!!
Did you just copy what I did and change the amount from 1000 to 500? and claimed that you did it? OMG. This is so freaking stupid
If you want to create many scrolls, I wouldn't advise using this and re-adding it over and over. This'll fuck performance.
The best solution is:
Code:
IF @Operation = 16 AND @ItemRefID in (37666,37667,37668,37669)
BEGIN
DECLARE @JID INT,
@Silk INT;
SET @Silk = CASE
WHEN @ItemRefID = 37666
THEN 100
WHEN @ItemRefID = 37667
THEN 300
WHEN @ItemRefID = 37668
THEN 500
WHEN @ItemRefID = 37669
THEN 1000
ELSE 0
END
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
That's it. You should figure it by yourself. If you don't then seriously...
Did you just copy what I did and change the amount from 1000 to 500? and claimed that you did it? OMG. This is so freaking stupid
If you want to create many scrolls, I wouldn't advise using this and re-adding it over and over. This'll **** performance.
The best solution is:
Code:
IF @Operation = 16 AND @ItemRefID in (37666,37667,37668,37669)
BEGIN
DECLARE @JID INT,
@Silk INT;
SET @Silk = CASE
WHEN @ItemRefID = 37666
THEN 100
WHEN @ItemRefID = 37667
THEN 300
WHEN @ItemRefID = 37668
THEN 500
WHEN @ItemRefID = 37669
THEN 100
ELSE 0
END
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
That's it. You should figure it by yourself. If you don't then seriously...
Serious .. Id it Work . Have no problem For me or someone .. As u have a better solution all us ask Thanks .. but don't need going with a Kid Action ..
Wts zszc char with 18 bil and 1000 silk 08/06/2011 - Silkroad Online Trading - 1 Replies Ok i wts an account with a Str bower ff....it had 1000 silk and 18 bil
Its clean thats mean no set or weapon
its on Zszc Water
for more infos and offers contact me here on elitepvpers or on [email protected]
(Explanation) Dont get tricked by the +3 (for 30minutes) silk scroll 12/19/2010 - SRO Guides & Templates - 2 Replies Read the guild notice in the screenshot below, it explains everything.
Not in the mood to type twice, typed once in the guild notice :P .
http://img3.imageshack.us/img3/2812/sro2010121814 453880.jpg
So people, always look at the bottom of the item for the timer before buying an item that you believe is super, otherwise you might regret it 30 minutes later.
Sadly i did not take a screen of the item with timer, but the next time i find another i will, and gonna post it here.