Sorry, coloquei vírgula onde era ponto e vírgula... ^^
Teste assim:
Código:/*
| @author - Renato Valer
| @version - 1.0.0
| @last update - 2016/06/15 - 21h56min
| @warning: Não me responsabilizo por uso incorreto e possíveis deadlocks. Use por sua conta e risco.
*/
USE MuOnline
GO
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'BonusReset' AND type = 'TR')
DROP TRIGGER [BonusReset]
GO
CREATE TRIGGER [BonusReset] ON [dbo].[Character]
AFTER UPDATE AS
SET NOCOUNT ON
IF UPDATE(ResetsCount) BEGIN
DECLARE @Login VARCHAR(10),
@Bonus INT,
@ResetsOld INT,
@ResetsNew INT;
SET @Login = (SELECT AccountID FROM INSERTED);
SET @ResetsOld = (SELECT ResetsCount FROM DELETED);
SET @ResetsNew = (SELECT ResetsCount FROM INSERTED);
SET @Bonus = 10; -- Defina aqui o valor do bonus
IF(@ResetsNew > @ResetsOld)
BEGIN
UPDATE CashShopData SET GoblinPoint = GoblinPoint + @Bonus WHERE AccountID = @Login;
END
SET NOCOUNT OFF
END
