Silk Scroll - 1000

Quote:

Originally Posted by capovip the scroll teleport me but no silk :( and this _LogEventItem [Only registered and activated users can see links. Click Here To Register...]

IF (@Operation = 41 AND @ItemRefID = 36790)

Quote:

Originally Posted by ersers2 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 36790 ITEM_SILK_SCROLL_1000 ... SN_ITEM_SILK_SCROLL_1000 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?

Quote:

Originally Posted by #BourBon Useful release But can i change 1000 and write 500 and scrol will be 500 silk ?

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

Quote:

Originally Posted by spinal2 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 .. If 500 silks .  Spoiler =-=- 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  Spoiler IF (@Operation = 16 AND @ItemRefID = 36790) Same if u wanna add more Scroll just change @Silkx and value ... Reguard !!!!

Quote:

Originally Posted by #BourBon Good Job Man And Very Thanks

Quote:

Originally Posted by spinal2 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 .. If 500 silks .  Spoiler =-=- 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  Spoiler IF (@Operation = 16 AND @ItemRefID = 36790) Same if u wanna add more Scroll just change @Silkx and value ... Reguard !!!!

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

Quote:

Originally Posted by Skipper* 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 :facepalm: 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 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...

Quote:

Originally Posted by spinal2 Why Iam Take DC When CLick in Buy Scroll ? don't Buy it .. Any One ? Why Iam Take DC When CLick in Buy Scroll ? don't Buy it .. Any One ?

Quote:

Originally Posted by Skipper* Check if you added the scrolls in the right way..