i want help in Fix Procedure

08/14/2018 16:08 muger4#1
IF (@Operation = 41) -- If item used!
BEGIN
IF(@ItemRefID = '62745') +1 Plus Scroll
Declare @[Only registered and activated users can see links. Click Here To Register...]Opt int
Declare @[Only registered and activated users can see links. Click Here To Register...]wOpt int
Select @[Only registered and activated users can see links. Click Here To Register...]Opt = OptLevel From SRO_VT_SHARD..dbo._Items Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @[Only registered and activated users can see links. Click Here To Register...]D and Slot = '13' and ItemID>0)
Set @[Only registered and activated users can see links. Click Here To Register...]wOpt = @[Only registered and activated users can see links. Click Here To Register...]Opt+1)

Update SRO_VT_SHARD.dbo._Items Set OptLevel = @[Only registered and activated users can see links. Click Here To Register...]wOpt Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @[Only registered and activated users can see links. Click Here To Register...]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
08/18/2018 11:29 muger4#2
UP
08/18/2018 14:26 athena1410#3
here
[Only registered and activated users can see links. Click Here To Register...]
08/19/2018 12:52 muger4#4
Quote:
Originally Posted by athena1410 View Post
here
[Only registered and activated users can see links. Click Here To Register...]
i'm Very thx you but this Procedure make plus no limits. i want make limits To 18 :D
08/19/2018 15:10 athena1410#5
IF ( @[Only registered and activated users can see links. Click Here To Register...] IS NOT NULL) AND @[Only registered and activated users can see links. Click Here To Register...] > 0 AND @[Only registered and activated users can see links. Click Here To Register...]Lvl < 20)
08/19/2018 18:46 muger4#6
Quote:
Originally Posted by athena1410 View Post
here
[Only registered and activated users can see links. Click Here To Register...]
Quote:
Originally Posted by athena1410 View Post
IF ( @[Only registered and activated users can see links. Click Here To Register...] IS NOT NULL) AND @[Only registered and activated users can see links. Click Here To Register...] > 0 AND @[Only registered and activated users can see links. Click Here To Register...]Lvl < 20)
really really you are legend i can add you in facebook ?
please leave your account here to you :D