Register for your free account! | Forgot your password?

You last visited: Today at 23:43

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

Advertisement



problem with Plus Scroll

Discussion on problem with Plus Scroll within the SRO Private Server forum part of the Silkroad Online category.

Closed Thread
 
Old   #1

 
elite*gold: 4398
Join Date: Feb 2016
Posts: 1,321
Received Thanks: 383
Exclamation problem with Plus Scroll

i just added a plus scroll procedure

but this error keep pop up

btw the procedure copied from other website, so i didn't make it by my self...





alydandy is offline  
Old 08/11/2018, 23:56   #2
 
elite*gold: 0
Join Date: Sep 2017
Posts: 845
Received Thanks: 472
WTF is that code...


#HB is online now  
Thanks
1 User
Old 08/12/2018, 00:11   #3

 
elite*gold: 4398
Join Date: Feb 2016
Posts: 1,321
Received Thanks: 383
Quote:
Originally Posted by #HB View Post
WTF is that code...



i got it from that topic, please help me if u have a better one
alydandy is offline  
Old 08/12/2018, 01:40   #4
 
elite*gold: 0
Join Date: Sep 2017
Posts: 845
Received Thanks: 472
I think , he and that guy are the same person. But the code at that topic is bullshit too.

I don't have a better one, I can write one. But I won't write it, because I don't need it.


#HB is online now  
Thanks
1 User
Old 08/12/2018, 03:32   #5

 
elite*gold: 4398
Join Date: Feb 2016
Posts: 1,321
Received Thanks: 383
Quote:
Originally Posted by #HB View Post
I think , he and that guy are the same person. But the code at that topic is bullshit too.

I don't have a better one, I can write one. But I won't write it, because I don't need it.
hmmm, what can i say, except thanks anyway HB i really apprecaite ur answeres, i will wait maybe some1 have it then i will close it if i give up.
alydandy is offline  
Old 08/12/2018, 11:55   #6
 
elite*gold: 0
Join Date: Feb 2013
Posts: 47
Received Thanks: 11
this code is rly **** but there

Quote:
IF(@JobID = '33937') -- Plus Scroll (+3) coded by [Crap_iLegend]
Begin
Declare @OptLvl int , @ItemID1 int
Select @OptLvl = OptLevel From dbo._Items Where ID64 = (Select ItemID From _Inventory Where CharID = @CharID and Slot = '13' and ItemID>0)
Set @NewOptLvl = (@OptLvl+3)
Select [email protected] From _Inventory Where CharID = @CharID
Update dbo._Items Set OptLevel = @NewOptLvl Where ID64 = (Select ItemID From _Inventory Where CharID = @CharID and Slot = '13' and ItemID>0) and OptLevel < 7
End
but i am sure this code will not work xD


try this

Quote:
IF(@JobID = '< ENTER ID THERE >') -- Plus Scroll (+3) coded by [Crap_iLegend]
Begin
Declare @OptLvl int ,@NewOptLvl int , @ItemID int

SET @ItemID = (Select ItemID From _Inventory Where CharID = @CharID and Slot = '13')
SET @OptLvl = (SELECT OptLevel FROM dbo._Items Where ID64 = @ItemID) +3
IF (@ItemID > 0) BEGIN
Update dbo._Items Set OptLevel = @OptLvl Where ID64 = @ItemID and OptLevel < 7
END
End
Imunium is offline  
Thanks
1 User
Old 08/12/2018, 13:53   #7

 
elite*gold: 4398
Join Date: Feb 2016
Posts: 1,321
Received Thanks: 383
Quote:
Originally Posted by Imunium View Post
this code is rly **** but there



but i am sure this code will not work xD


try this
i will try it and i will write back

Quote:
Originally Posted by Imunium View Post
this code is rly **** but there



but i am sure this code will not work xD


try this
i can excute it successfully now and that wasn't happen, but the scroll do nothing....
i tried to change the plus and the < number

and still not working..sorry
alydandy is offline  
Old 08/13/2018, 08:13   #8
 
elite*gold: 177
Join Date: Feb 2011
Posts: 733
Received Thanks: 224
try this one :

SRO_VT_LOG -> SP -> _AddLogItem

Quote:
IF(@Operation = 41 and @ItemRefID = 42497) -- Plus Scroll (+3) coded by [Crap_iLegend]
Begin
Declare @OptLvl int , @Item int

SET @Item = (Select ItemID From sro_vt_shard.._Inventory Where CharID = @CharID and Slot = '13')
SET @OptLvl = (SELECT OptLevel FROM sro_vt_shard.._Items Where ID64 = @Item) +3
IF (@Item > 0) BEGIN
Update sro_vt_shard.._Items Set OptLevel = @OptLvl Where ID64 = @Item
END
End
InPanic Kev is offline  
Thanks
1 User
Old 08/13/2018, 16:57   #9

 
elite*gold: 4398
Join Date: Feb 2016
Posts: 1,321
Received Thanks: 383
Quote:
Originally Posted by InPanic Kev View Post
try this one :

SRO_VT_LOG -> SP -> _AddLogItem
i will try it now and i will write back

Quote:
Originally Posted by InPanic Kev View Post
try this one :

SRO_VT_LOG -> SP -> _AddLogItem
works perfectly, but it can be done at any plus item, i want it for under a spcific plus, wish means items over+7 can't use on it, so on....

can you do that , please ?
alydandy is offline  
Old 08/14/2018, 06:22   #10
 
elite*gold: 177
Join Date: Feb 2011
Posts: 733
Received Thanks: 224
Quote:
IF(@Operation = 41 and @ItemRefID = 42497) -- Plus Scroll (+3) coded by [Crap_iLegend]
Begin
Declare @OptLvl int , @Item int

SET @Item = (Select ItemID From sro_vt_shard.._Inventory Where CharID = @CharID and Slot = '13')
SET @OptLvl = (SELECT OptLevel FROM sro_vt_shard.._Items Where ID64 = @Item) +3
IF (@Item > 0 and @OptLvl < 7) BEGIN
Update sro_vt_shard.._Items Set OptLevel = @OptLvl Where ID64 = @Item
END
End
If u wanna check the optLvl befor a player is using the scroll you need a filter.

Hint: better use a system based on a Click Item ( with a Yellow Arrow ) and a Filter.
InPanic Kev is offline  
Thanks
1 User
Old 08/14/2018, 19:22   #11

 
elite*gold: 4398
Join Date: Feb 2016
Posts: 1,321
Received Thanks: 383
Quote:
Originally Posted by InPanic Kev View Post
If u wanna check the optLvl befor a player is using the scroll you need a filter.

Hint: better use a system based on a Click Item ( with a Yellow Arrow ) and a Filter.
Thanks for ur answer, i really apprecaite it,
but i don't like filters since iam newbie on this scene so i dont want to stuck later,
i will just wait few days for answer for procedure, if not i will just close the topic and forgot it...
alydandy is offline  
Old 08/15/2018, 14:16   #12
 
elite*gold: 177
Join Date: Feb 2011
Posts: 733
Received Thanks: 224
i have allrdy post the proc for the + scroll

PS: if you dont use a filter its easy to kill ur server just saying. If u wanna buy one let me know.
InPanic Kev is offline  
Thanks
1 User
Old 08/15/2018, 16:21   #13
 
elite*gold: 0
Join Date: Jul 2017
Posts: 118
Received Thanks: 65
try this
athena1410 is offline  
Thanks
1 User
Old 08/15/2018, 20:39   #14

 
elite*gold: 4398
Join Date: Feb 2016
Posts: 1,321
Received Thanks: 383
Quote:
Originally Posted by InPanic Kev View Post
i have allrdy post the proc for the + scroll

PS: if you dont use a filter its easy to kill ur server just saying. If u wanna buy one let me know.
oh... i didn't know about that, thanks for the info, hmmm i can't pay much, so can you tell me what filters cost ?, i just need to make my server unkill able, so i dont need a special features or something

Quote:
Originally Posted by athena1410 View Post
try this
thanks , i really apprecaite ur help, i will try it now and i will be back with result...


alydandy is offline  
Closed Thread



« Samurai avatar | Item mall »

Similar Threads
Vsro silk scroll and gift scroll doesn't work
10/17/2015 - SRO Private Server - 1 Replies
solved topic can delete
(ALB) WTS Effect Scroll - Megadolon Drop Scroll
01/09/2012 - Trading - 1 Replies
Im looking for plats just serious offers please
WTT 3X Scroll for Shuta( Come with ur Scroll)(Evengarda)
06/16/2010 - Archlord Trading - 1 Replies
İ want to change 4x Scroll for shuta ... u need to come with ur scroll



All times are GMT +1. The time now is 23:43.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

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