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 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_anteriror = 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_antigo)
UPDATE CashShopData set WcoinC = WcoinC + 20 where AccountID = (select top 1 AccountID from character where name=@char)
SET NOCOUNT OFF
SET XACT_ABORT OFF