SCRIPTS Dar bonus a novos player!!!

[clairtoncb]

USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO

CREATE TRIGGER MUC_BONUS ON Dbo.Character FOR INSERT
AS
BEGIN

-- Bonus para Novos Chars
DECLARE
@cLevel INT,
@Strength INT,
@Dexterity INT,
@Vitality INT,
@Energy INT,
@Leadership INT,
@ResetCount INT,
@Pontos INT,
@Dinheiro INT,
@Char varchar(10)
SELECT @Char = Name FROM INSERTED


SET @cLevel = 400 -- LEVEl STATUS
SET @ResetCount = 0 -- INSERIR QUANTIDADE DE ResetCount
SET @Pontos = 0 -- INSERIR QUANTIDADE DE PONTOS INICIAIS
SET @Dinheiro = 20000000 -- INSERIR QUANTIDADE DE DINHEIRO
SET @Strength = 65000 -- INSERIR PONTOS
SET @Dexterity = 65000 -- INSERIR PONTOS
SET @Vitality = 65000 -- INSERIR PONTOS
SET @Energy = 65000 -- INSERIR PONTOS
SET @Leadership = 65000 -- INSERIR PONTOS


UPDATE Dbo.Character
SET ResetCount = @ResetCount, LevelUpPoint = @Pontos, Money = @Dinheiro,  Strength = @Strength,  Dexterity = @Dexterity,
Vitality = @Vitality,  Energy = @Energy,  Leadership = @Leadership, cLevel = @cLevel
WHERE Name = @Char

END