Personagem Desaparecendo

[mixisco]

Estou com seguinte problemas , entro no servidor normalmente , mais quando algum player faz PK em cima de outro player , seleciono servidor e volto , personagem tudo desaparece , Alguém pode ajudar?

[lorranmota]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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]
[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]


SET NOCOUNT OFF
SET XACT_ABORT OFF

[Mentor]

lorranmota essa query serve para qualquer servidor com esse problema?

[lorranmota]

@lorranmota ([Only registered and activated users can see links]) essa query serve para qualquer servidor com esse problema?
Que use ferrarezi web sim. ja daldegam e outras não testei mais creio que funcione também.

[mixisco]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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]
[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]


SET NOCOUNT OFF
SET XACT_ABORT OFF

resolveu , infelizmente agora o ranking hero está contando somente até 3 pontos rsrs