[QUERY] Char Start stats FULll

[muonlinegr2]

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
 @Resets INT,
 @pontos INT,
 @Dinheiro INT,
 @forca INT,
 @Agilidade INT,
 @energia INT,
 @vitalidade INT,
 @Char varchar(10)
SELECT @Char = Name FROM INSERTED
 
SET @Resets = 10 -- INSERIR QUANTIDADE DE RESETS
SET @pontos = 3500 -- INSERIR QUANTIDADE DE PONTOS PARA DESTRIBUIR
SET @Dinheiro = 1000000 -- INSERIR QUANTIDADE DE DINHEIRO
SET @Agilidade = 32767 -- INSERIR QUANTIDADE DE PONTOS
SET @forca = 32767 -- INSERIR QUANTIDADE DE PONTOS
SET @energia = 32767 -- INSERIR QUANTIDADE DE PONTOS
SET @vitalidade = 32767 -- INSERIR QUANTIDADE DE PONTOS
 
UPDATE Dbo.Character
SET Resets = @Resets, LevelUpPoint = @pontos, Money = @Dinheiro, Strength = @forca, Dexterity = @Agilidade, Vitality = @vitalidade, Energy = @energia
WHERE Name = @Char
END

[MentaL]

[KarLi]

and in english

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 for new Characters
DECLARE ReseTS INT, points INT, Money INT, Strength INT, Agility INT, Energy INT, Vitality INT, Char varchar(10)
SELECT Char = Name FROM INSERTED

SET Resets = 10 -- Put amount of resets
SET points = 3500 -- Put amount of points
SET Money = 1000000 -- Put amount of money/zen
SET Agility = 32767 -- Put amount of Agility Stats
SET Strength = 32767 -- Put amount of Strength Stats
SET EnergY = 32767 -- Put amount of Energy Stats
SET vitality = 32767 -- Put amount of Vitality Stats

[chise08]

i cant get it working...