Mu Server QUERY BONUS VIP PARA MU EMU

[danielmutti]

TO POSTANDO AQUI PQ EU TIVE QUE FAZER E NAO ACHEI AQUI PRONTA ENTAO RESOLVI FAZER
BOM PARA QUEM USA WEBENGINE PQ NAO TEM COMO COLOCA O BONUS NO CADASTRO EM ALGUNS TEMPLATES

CODIGO ABAIXO SO RODA E SER FELIZ

USE [MuOnline]
GO
/****** Object: Trigger [dbo].[MUC_BONUS_VIP] Script Date: 12/1/2023 4:08:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[MUC_BONUS_VIP] ON [dbo].[MEMB_INFO] FOR INSERT
AS
BEGIN

DECLARE
@AccountExpireDate smalldatetime,
@AccountLevel INT,
@Id varchar(10)
SELECT @Id = memb___id FROM INSERTED

SELECT @Id = memb___id FROM INSERTED
SET @AccountExpireDate = GETDATE() + 15 //QUANTIDADE DE VIP
SET @AccountLevel = 2 //NIVEL DO VIP

UPDATE Dbo.MEMB_INFO

SET AccountExpireDate = @AccountExpireDate, AccountLevel = @AccountLevel

WHERE memb___id = @Id

end


CREDITOS ADM FULL MU FULL