Hey every one !
2day i'll Release new scroll for RZ
this procedure created for give extra +3 to the item in slot '1' at char inventory, but this scroll not work if your item +8 or more.
i mean it will give the extra +3 to any D11 EGY A or B +1 ~ +7 in Slot 1 in your inventory.
you can change the values as u want !
Slot, Extra plus, Items ID's and which item plus to work
Notice: This ID's is D11 EGY A + EGY B ID's you can change it to the target Items ID's
2day i'll Release new scroll for RZ
this procedure created for give extra +3 to the item in slot '1' at char inventory, but this scroll not work if your item +8 or more.
i mean it will give the extra +3 to any D11 EGY A or B +1 ~ +7 in Slot 1 in your inventory.
you can change the values as u want !
Slot, Extra plus, Items ID's and which item plus to work
Notice: This ID's is D11 EGY A + EGY B ID's you can change it to the target Items ID's
PHP:
IF(@JobID = 'Write Here Scroll Skill ID') -- Plus Scroll (+3) coded by [iLegend] Dont copy under your Name!
Begin
Declare @OptLvl int
Declare [USER=571372]newo[/USER]ptLvl int
Select @OptLvl = OptLevel From dbo._Items Where ID64 = ( Select ItemID From _Inventory Where CharID = [USER=551894]Char[/USER]ID and Slot = '13' and ItemID > 0 )
Set [USER=571372]newo[/USER]ptLvl = (@OptLvl + '3') --# To Change Extra Plus Value
Update dbo._Items Set OptLevel = [USER=571372]newo[/USER]ptLvl Where ID64 = ( Select ItemID From _Inventory Where CharID = [USER=551894]Char[/USER]ID and Slot = '13' and ItemID > 0 ) and OptLevel <= '7' --# To Change Which Item Plus to Work
and ((RefItemID between '25611' and '25668') Or (RefItemID between '25727' and '25762') Or (RefItemID between '25669' and '25726') Or (RefItemID between '25763' and '25798')) --# To Change Item ID's
End
Last edited: