Problema ranking Hero

[Reenan]

Tente altera essa parte:

IF (@rank < 0) and (@rank < @valor)
UPDATE [dbo].[Character]
SET Z_RankHR = Z_RankHR + (@valor-@rank)
WHERE Name = @char

Coloque

IF (@rank > 0) and (@rank > @valor)
UPDATE [dbo].[Character]
SET Z_RankHR = Z_RankHR + (@valor-@rank)
WHERE Name = @char

ou

IF (@rank < 0) and (@rank < @valor)
UPDATE [dbo].[Character]
SET Z_RankHR = Z_RankHR + (@valor+@rank)
WHERE Name = @char