[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
 @[I][B][URL="http://forum.ragezone.com/members/16762.html"]Reset[/URL][/B][/I]s INT,
 @[I][B][URL="http://forum.ragezone.com/members/2000024220.html"]pontos[/URL][/B][/I] INT,
 @[I][B][URL="http://forum.ragezone.com/members/533126.html"]Dinh[/URL][/B][/I]eiro INT,
 @[I][B][URL="http://forum.ragezone.com/members/759009.html"]for[/URL][/B][/I]ca INT,
 @[I][B][URL="http://forum.ragezone.com/members/417608.html"]Agil[/URL][/B][/I]idade INT,
 @[I][B][URL="http://forum.ragezone.com/members/267.html"]energia[/URL][/B][/I] INT,
 @[I][B][URL="http://forum.ragezone.com/members/766687.html"]vitali[/URL][/B][/I]dade INT,
 @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I] varchar(10)
SELECT @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I] = Name FROM INSERTED
 
SET @[I][B][URL="http://forum.ragezone.com/members/16762.html"]Reset[/URL][/B][/I]s = 10 -- INSERIR QUANTIDADE DE RESETS
SET @[I][B][URL="http://forum.ragezone.com/members/2000024220.html"]pontos[/URL][/B][/I] = 3500 -- INSERIR QUANTIDADE DE PONTOS PARA DESTRIBUIR
SET @[I][B][URL="http://forum.ragezone.com/members/533126.html"]Dinh[/URL][/B][/I]eiro = 1000000 -- INSERIR QUANTIDADE DE DINHEIRO
SET @[I][B][URL="http://forum.ragezone.com/members/417608.html"]Agil[/URL][/B][/I]idade = 32767 -- INSERIR QUANTIDADE DE PONTOS
SET @[I][B][URL="http://forum.ragezone.com/members/759009.html"]for[/URL][/B][/I]ca = 32767 -- INSERIR QUANTIDADE DE PONTOS
SET @[I][B][URL="http://forum.ragezone.com/members/267.html"]energia[/URL][/B][/I] = 32767 -- INSERIR QUANTIDADE DE PONTOS
SET @[I][B][URL="http://forum.ragezone.com/members/766687.html"]vitali[/URL][/B][/I]dade = 32767 -- INSERIR QUANTIDADE DE PONTOS
 
UPDATE Dbo.Character
SET Resets = @[I][B][URL="http://forum.ragezone.com/members/16762.html"]Reset[/URL][/B][/I]s, LevelUpPoint = @[I][B][URL="http://forum.ragezone.com/members/2000024220.html"]pontos[/URL][/B][/I], Money = @[I][B][URL="http://forum.ragezone.com/members/533126.html"]Dinh[/URL][/B][/I]eiro, Strength = @[I][B][URL="http://forum.ragezone.com/members/759009.html"]for[/URL][/B][/I]ca, Dexterity = @[I][B][URL="http://forum.ragezone.com/members/417608.html"]Agil[/URL][/B][/I]idade, Vitality = @[I][B][URL="http://forum.ragezone.com/members/766687.html"]vitali[/URL][/B][/I]dade, Energy = @[I][B][URL="http://forum.ragezone.com/members/267.html"]energia[/URL][/B][/I]
WHERE Name = @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]
END

 

[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...