Premiação Eventos MuEmu|X-Team Season Season 4
Vi uma galera com dificuldade pra fazer umas query que eu também estava procurando e nosso amigo @[Only registered and activated users can see links. Click Here To Register...] compartilhou
E muita gente ainda ficou com duvidas então decidi postar as que adaptei
Premiar BloodCastle
Código:
CREATE TRIGGER [dbo].[PREMIO_BC] ON [dbo].[RankingBloodCastle]
AFTER UPDATE
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @rank int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_novo int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_anterior int
DECLARE @char varchar(10)
SELECT @[Only registered and activated users can see links. Click Here To Register...]or_anterior = Score FROM DELETED
SELECT @[Only registered and activated users can see links. Click Here To Register...]or_novo = Score, @char = Name FROM INSERTED
IF @[Only registered and activated users can see links. Click Here To Register...]or_novo > 0) and @[Only registered and activated users can see links. Click Here To Register...]or_novo > @[Only registered and activated users can see links. Click Here To Register...]or_anterior)
UPDATE MEMB_INFO set gold = gold + 20 where memb___id = (select top 1 AccountID from character where name=@char)
SET NOCOUNT OFF
SET XACT_ABORT OFF
Premiar ChaosCastle
Código:
CREATE TRIGGER [dbo].[PREMIO_CC] ON [dbo].[RankingChaosCastle]
AFTER UPDATE
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @rank int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_novo int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_anterior int
DECLARE @char varchar(10)
SELECT @[Only registered and activated users can see links. Click Here To Register...]or_anterior = Score FROM DELETED
SELECT @[Only registered and activated users can see links. Click Here To Register...]or_novo = Score, @char = Name FROM INSERTED
IF @[Only registered and activated users can see links. Click Here To Register...]or_novo > 0) and @[Only registered and activated users can see links. Click Here To Register...]or_novo > @[Only registered and activated users can see links. Click Here To Register...]or_anterior)
UPDATE MEMB_INFO set gold = gold + 20 where memb___id = (select top 1 AccountID from character where name=@char)
SET NOCOUNT OFF
SET XACT_ABORT OFF
Premiar DevilSquare
Código:
CREATE TRIGGER [dbo].[PREMIO_DC] ON [dbo].[RankingDevilSquare]
AFTER UPDATE
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @rank int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_novo int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_anterior int
DECLARE @char varchar(10)
SELECT @[Only registered and activated users can see links. Click Here To Register...]or_anterior = Score FROM DELETED
SELECT @[Only registered and activated users can see links. Click Here To Register...]or_novo = Score, @char = Name FROM INSERTED
IF @[Only registered and activated users can see links. Click Here To Register...]or_novo > 0) and @[Only registered and activated users can see links. Click Here To Register...]or_novo > @[Only registered and activated users can see links. Click Here To Register...]or_anterior)
UPDATE MEMB_INFO set gold = gold + 20 where memb___id = (select top 1 AccountID from character where name=@char)
SET NOCOUNT OFF
SET XACT_ABORT OFF
Premiar IllusionTemple
Código:
CREATE TRIGGER [dbo].[PREMIO_IT] ON [dbo].[RankingIllusionTemple]
AFTER UPDATE
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @rank int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_novo int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or_anterior int
DECLARE @char varchar(10)
SELECT @[Only registered and activated users can see links. Click Here To Register...]or_anterior = Score FROM DELETED
SELECT @[Only registered and activated users can see links. Click Here To Register...]or_novo = Score, @char = Name FROM INSERTED
IF @[Only registered and activated users can see links. Click Here To Register...]or_novo > 0) and @[Only registered and activated users can see links. Click Here To Register...]or_novo > @[Only registered and activated users can see links. Click Here To Register...]or_anterior)
UPDATE MEMB_INFO set gold = gold + 20 where memb___id = (select top 1 AccountID from character where name=@char)
SET NOCOUNT OFF
SET XACT_ABORT OFF
Como alterar a premiação
UPDATE MEMB_INFO set gold = gold + 20 where memb___id = (select top 1 AccountID from character where name=@char)
gold é a coluna da moeda
o 20 é a quantidade de moeda que vai ser inserido
Créditos
Eu por adaptar @[Only registered and activated users can see links. Click Here To Register...] por fazer