maniacoo
07-19-2022, 09:26 PM
Script que server para todos tipos de MU.
Achei que já tinha aqui mais pesquisei e não encontrei, se eu estiver errado pode excluir ^^
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
CREATE TRIGGER [dbo].[Z_PK_HERO] ON [dbo].[Character]
AFTER UPDATE
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @rank int
DECLARE @valor int
DECLARE @char varchar(10)
SELECT @valor = PkCount FROM DELETED
SELECT @rank = PkCount, @char = Name FROM INSERTED
IF (@rank > 0) and (@rank > @valor)
UPDATE [dbo].[Character] SET Z_RankPK = Z_RankPK + (@rank-@valor) WHERE Name = @char
ELSE IF (@rank < 0) and (@rank < @valor)
UPDATE [dbo].[Character] SET Z_RankHR = Z_RankHR + (@valor-@rank) WHERE Name = @char
SET NOCOUNT OFF
SET XACT_ABORT OFF
Abraço
Achei que já tinha aqui mais pesquisei e não encontrei, se eu estiver errado pode excluir ^^
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
CREATE TRIGGER [dbo].[Z_PK_HERO] ON [dbo].[Character]
AFTER UPDATE
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @rank int
DECLARE @valor int
DECLARE @char varchar(10)
SELECT @valor = PkCount FROM DELETED
SELECT @rank = PkCount, @char = Name FROM INSERTED
IF (@rank > 0) and (@rank > @valor)
UPDATE [dbo].[Character] SET Z_RankPK = Z_RankPK + (@rank-@valor) WHERE Name = @char
ELSE IF (@rank < 0) and (@rank < @valor)
UPDATE [dbo].[Character] SET Z_RankHR = Z_RankHR + (@valor-@rank) WHERE Name = @char
SET NOCOUNT OFF
SET XACT_ABORT OFF
Abraço