Ranking hero muemu (x-team) season6

[Rey Mysterious]

alguém tem alguma query para ranking hero compativel com muemu (x-team) season6 ?

[fyre]

1° Roda essa query:


ALTER TABLE dbo.Character ADD
Z_RankPK int NOT NULL CONSTRAINT DF_Character_Z_RankPK DEFAULT 0,
Z_RankHR int NOT NULL CONSTRAINT DF_Character_Z_RankHR DEFAULT 0

2° Roda essa query:


CREATE TRIGGER [dbo].[Z_PK_HERO] ON [dbo].[Character]
AFTER UPDATE
AS

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE [dbo].[Character]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
ELSE
[Only registered and activated users can see links]
UPDATE [dbo].[Character]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Rey Mysterious]

1° Roda essa query:



2° Roda essa query:


fyre obrigado por tentar ajudar , infelizmente essa query não está 100% , o rank hero quando chega ate 3 para de contabilizar , e apos eu executar essa query , aconteceu um bug , quando seleciono servidor ou personagem , todos os personagem desaparecem .