problem with Plus Scroll

[alydandy]

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

[#HB]

WTF is that code...

[alydandy]

Originally Posted by #HB

WTF is that code...

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

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

[alydandy]

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.

[Imunium]

this code is rly **** but there

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

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

[alydandy]

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

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

[InPanic Kev]

try this one :

SRO_VT_LOG -> SP -> _AddLogItem

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

[alydandy]

Originally Posted by InPanic Kev

try this one :

SRO_VT_LOG -> SP -> _AddLogItem

i will try it now and i will write back

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 ?

[InPanic Kev]

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.

[alydandy]

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

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

[athena1410]

try this

[alydandy]

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

Originally Posted by athena1410

try this

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