problem with Plus Scroll

08/11/2018 23:42 devdash#1

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...

[Only registered and activated users can see links. Click Here To Register...]

08/11/2018 23:56 #HB#2

WTF is that code...

08/12/2018 00:11 devdash#3

Quote:

Originally Posted by #HB

WTF is that code...

[Only registered and activated users can see links. Click Here To Register...]

i got it from that topic, please help me if u have a better one

08/12/2018 01:40 #HB#4

I think [Only registered and activated users can see links. Click Here To Register...], 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 devdash#5

Quote:

Originally Posted by #HB

I think [Only registered and activated users can see links. Click Here To Register...], 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 Imunium#6

this code is rly Crap ;) 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 ItemID=@ItemID1 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 devdash#7

Quote:

Originally Posted by Imunium

this code is rly Crap ;) 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 Crap ;) 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 InPanic Kev#8

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 devdash#9

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 InPanic Kev#10

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 devdash#11

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 InPanic Kev#12

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 athena1410#13

try this
[Only registered and activated users can see links. Click Here To Register...]

08/15/2018 20:39 devdash#14

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
[Only registered and activated users can see links. Click Here To Register...]

thanks , i really apprecaite ur help, i will try it now and i will be back with result...