Max PLUS System

[RenePunik]

Hello community, i have added max plus system on my server. but it doesn't count advances elixirs.

IF (@Operation = 90 AND @strDesc like '%Opt: +13%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END

This lines only decrease if item +12 and make it +13 with normal elixirs. it will decrease again to +12, but if i used adv elixir and my weapon was +12 and added on it adv elixir it will be +14 and plus didn't back again to +12.
Synx gave me hint: it's on _BindingOptionWithItem but lool, how i can!

[MentaL]

[Caosfox]

unless you "refresh" the plus on real time at client, is a easy way to scam players

lets say i have a +12 item, use adv elix, plus to +14 or +15 (in the db the proc change it back to +12) but on client, until the player teleports or relogin, shows as +14 or +15
so i can sell it as +15, others check the plus on it and say +15, and when i sell it, the scamed guy got it as +12.

you get the idea, right?

[BadFist]

to make easy make +10 limit and with adv elixir will be +12 and you solve the problem.

[RenePunik]

unless you "refresh" the plus on real time at client, is a easy way to scam players

lets say i have a +12 item, use adv elix, plus to +14 or +15 (in the db the proc change it back to +12) but on client, until the player teleports or relogin, shows as +14 or +15
so i can sell it as +15, others check the plus on it and say +15, and when i sell it, the scamed guy got it as +12.

you get the idea, right?

Yes, I got it.

to make easy make +10 limit and with adv elixir will be +12 and you solve the problem.

Thanks, this is good solution. and i will make my (+11 & +12) rates are "0"
btw, i must make normal elixirs rate like lucky powder?
and which of these query is better?
this one:

IF (@Operation = 90 AND @strDesc like '%Opt: +13%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END

or this one:

if @eventID in (4,6,9)
begin
update SRO_VT_SHARD.dbo._Items set OptLevel = 10 where OptLevel in (11,12)
end