|
You last visited: Today at 16:51
Advertisement
problem with Plus Scroll
Discussion on problem with Plus Scroll within the SRO Private Server forum part of the Silkroad Online category.
08/11/2018, 23:42
|
#1
|
elite*gold: 0
Join Date: Feb 2016
Posts: 1,491
Received Thanks: 407
|
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...
|
|
|
08/11/2018, 23:56
|
#2
|
elite*gold: 0
Join Date: Sep 2017
Posts: 1,015
Received Thanks: 717
|
WTF is that code...
|
|
|
08/12/2018, 00:11
|
#3
|
elite*gold: 0
Join Date: Feb 2016
Posts: 1,491
Received Thanks: 407
|
Quote:
Originally Posted by #HB
WTF is that code...
|
i got it from that topic, please help me if u have a better one
|
|
|
08/12/2018, 01:40
|
#4
|
elite*gold: 0
Join Date: Sep 2017
Posts: 1,015
Received Thanks: 717
|
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.
|
|
|
08/12/2018, 03:32
|
#5
|
elite*gold: 0
Join Date: Feb 2016
Posts: 1,491
Received Thanks: 407
|
Quote:
Originally Posted by #HB
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.
|
|
|
08/12/2018, 11:55
|
#6
|
elite*gold: 0
Join Date: Feb 2013
Posts: 51
Received Thanks: 12
|
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
|
|
|
|
08/12/2018, 13:53
|
#7
|
elite*gold: 0
Join Date: Feb 2016
Posts: 1,491
Received Thanks: 407
|
Quote:
Originally Posted by Imunium
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
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
|
|
|
08/13/2018, 08:13
|
#8
|
elite*gold: 260
Join Date: Feb 2011
Posts: 749
Received Thanks: 237
|
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
|
|
|
|
08/13/2018, 16:57
|
#9
|
elite*gold: 0
Join Date: Feb 2016
Posts: 1,491
Received Thanks: 407
|
Quote:
Originally Posted by InPanic Kev
try this one :
SRO_VT_LOG -> SP -> _AddLogItem
|
i will try it now and i will write back
Quote:
Originally Posted by InPanic Kev
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 ?
|
|
|
08/14/2018, 06:22
|
#10
|
elite*gold: 260
Join Date: Feb 2011
Posts: 749
Received Thanks: 237
|
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.
|
|
|
08/14/2018, 19:22
|
#11
|
elite*gold: 0
Join Date: Feb 2016
Posts: 1,491
Received Thanks: 407
|
Quote:
Originally Posted by InPanic Kev
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...
|
|
|
08/15/2018, 14:16
|
#12
|
elite*gold: 260
Join Date: Feb 2011
Posts: 749
Received Thanks: 237
|
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.
|
|
|
08/15/2018, 16:21
|
#13
|
elite*gold: 0
Join Date: Jul 2017
Posts: 118
Received Thanks: 66
|
try this
|
|
|
08/15/2018, 20:39
|
#14
|
elite*gold: 0
Join Date: Feb 2016
Posts: 1,491
Received Thanks: 407
|
Quote:
Originally Posted by InPanic Kev
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
try this

|
thanks , i really apprecaite ur help, i will try it now and i will be back with result...
|
|
|
All times are GMT +1. The time now is 16:51.
|
|