i want help in Fix Procedure

[muger4]

IF (@Operation = 41) -- If item used!
BEGIN
IF(@ItemRefID = '62745') +1 Plus Scroll
Declare @Opt int
Declare @wOpt int
Select @Opt = OptLevel From SRO_VT_SHARD..dbo._Items Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @D and Slot = '13' and ItemID>0)
Set @wOpt = @Opt+1)

Update SRO_VT_SHARD.dbo._Items Set OptLevel = @wOpt Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @D and Slot = '13' and ItemID>0) and OptLevel < 1


This To Make Plus to item but his procedure have problem i want fix it

[muger4]

UP

[athena1410]

here

[muger4]

Originally Posted by athena1410

here

i'm Very thx you but this Procedure make plus no limits. i want make limits To 18

[athena1410]

IF ( @ IS NOT NULL) AND @ > 0 AND @Lvl < 20)

[muger4]

Originally Posted by athena1410

here

Originally Posted by athena1410

IF ( @ IS NOT NULL) AND @ > 0 AND @Lvl < 20)

really really you are legend i can add you in facebook ?
please leave your account here to you