Register for your free account! | Forgot your password?

You last visited: Today at 03:32

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Silk Scroll - 1000

Discussion on Silk Scroll - 1000 within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old 04/10/2015, 00:27   #31
 
elite*gold: 0
Join Date: Dec 2008
Posts: 38
Received Thanks: 14
Quote:
Originally Posted by capovip View Post
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

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?
ersers2 is offline  
Old 04/10/2015, 01:00   #32
 
elite*gold: 0
Join Date: Sep 2008
Posts: 39
Received Thanks: 3
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
Attached Files
File Type: txt Silk Scroll .txt (1.2 KB, 111 views)
capovip is offline  
Old 04/10/2015, 08:20   #33
 
elite*gold: 0
Join Date: Dec 2008
Posts: 38
Received Thanks: 14
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.
ersers2 is offline  
Old 04/10/2015, 22:16   #34

 
AceSpace's Avatar
 
elite*gold: 71
Join Date: Mar 2011
Posts: 1,594
Received Thanks: 1,099
Quote:
Originally Posted by ersers2 View Post
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?
You gotta edit it. Should I do it manually for the people? I edited/updated the thread
AceSpace is offline  
Thanks
1 User
Old 07/11/2015, 18:44   #35
 
elite*gold: 0
Join Date: Dec 2012
Posts: 92
Received Thanks: 3
Anyone can explain me how i can get a icon to that scoll ?thanks
wilber1414 is offline  
Old 07/11/2015, 19:07   #36
 
elite*gold: 0
Join Date: Jul 2015
Posts: 6
Received Thanks: 2
Good Jop
IpexOnline2015 is offline  
Old 07/13/2015, 09:48   #37
 
elite*gold: 0
Join Date: Jul 2015
Posts: 613
Received Thanks: 192
Useful release
But can i change 1000 and write 500 and scrol will be 500 silk ?
Zargrin is offline  
Old 07/14/2015, 23:39   #38
 
spinal2's Avatar
 
elite*gold: 0
Join Date: Dec 2007
Posts: 241
Received Thanks: 16
Quote:
Originally Posted by #BourBon View Post
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 ..

If 500 silks .


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 !!!!
spinal2 is offline  
Old 07/15/2015, 01:05   #39
 
elite*gold: 0
Join Date: Jul 2015
Posts: 613
Received Thanks: 192
Quote:
Originally Posted by spinal2 View Post
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 .


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 !!!!
Good Job Man And Very Thanks
Zargrin is offline  
Old 07/15/2015, 01:09   #40
 
spinal2's Avatar
 
elite*gold: 0
Join Date: Dec 2007
Posts: 241
Received Thanks: 16
Quote:
Originally Posted by #BourBon View Post
Good Job Man And Very Thanks
I I'm Happy to help
spinal2 is offline  
Thanks
1 User
Old 07/15/2015, 02:36   #41

 
AceSpace's Avatar
 
elite*gold: 71
Join Date: Mar 2011
Posts: 1,594
Received Thanks: 1,099
Quote:
Originally Posted by spinal2 View Post
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 .


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...
AceSpace is offline  
Old 07/15/2015, 03:33   #42
 
spinal2's Avatar
 
elite*gold: 0
Join Date: Dec 2007
Posts: 241
Received Thanks: 16
Quote:
Originally Posted by Skipper* View Post
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 ..

C ya ..
spinal2 is offline  
Old 07/15/2015, 05:23   #43
 
spinal2's Avatar
 
elite*gold: 0
Join Date: Dec 2007
Posts: 241
Received Thanks: 16
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 ?
spinal2 is offline  
Old 07/15/2015, 10:53   #44

 
AceSpace's Avatar
 
elite*gold: 71
Join Date: Mar 2011
Posts: 1,594
Received Thanks: 1,099
Quote:
Originally Posted by spinal2 View Post
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 ?
Check if you added the scrolls in the right way..
AceSpace is offline  
Old 07/15/2015, 11:47   #45
 
spinal2's Avatar
 
elite*gold: 0
Join Date: Dec 2007
Posts: 241
Received Thanks: 16
Quote:
Originally Posted by Skipper* View Post
Check if you added the scrolls in the right way..
Yes .. ALL lines too in _RefPricePolice ..ScrapPackageItem...PackageItem and ShopGoods ..

Look ..



When CLick "COMPRAR' ..Client Crash and Nothing apear after Re Conecct ..
spinal2 is offline  
Reply


Similar Threads Similar Threads
Silk Scroll
06/15/2014 - SRO Private Server - 4 Replies
Anyone know how to make silk scroll or silk Potion? Please share it.
[Buying] [ZIAN] 1000 Scraps for 1 Scroll or 7 Janus Box
06/05/2013 - Archlord Trading - 0 Replies
pm me or /w ingame
WTS 1000 PREMIUM SILK
08/28/2012 - Silkroad Online Trading - 1 Replies
WTS 1000 PREMIUM SILK 50 EUROS MBANK TRASFFER My email [email protected]
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.



All times are GMT +1. The time now is 03:32.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.