Ranking pk e hero

[cruskado]

ola bom dia amigo eu queria pedir a ajuda de voces para que possa me ajudar resolver um probleminha simples q eu n to conseguindo resolver e o seguinte meu site do ferrarezi nao esta marcando pk e nem hero e nem pkday nem semanal e nem mensal alguem me ajuda por favor

[russo1]

Rode essa query para contar os tops..




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

SET NOCOUNT ON
SET XACT_ABORT ON

[Only registered and activated users can see links]
DECLARE valor int
[Only registered and activated users can see links]

SELECT valor = PkCount FROM DELETED
[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]

SET NOCOUNT OFF
SET XACT_ABORT OFF