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
DECLARE
[USER=1333370467]point[/USER] INT,
[USER=289231]Zen[/USER] INT,
@LVL INT,
@STR INT,
@AGI INT,
@VIT INT,
@ENE INT,
[USER=12178]cmd[/USER] INT,
[USER=551894]Char[/USER] varchar(10)
SELECT [USER=551894]Char[/USER]= Name FROM INSERTED
SET [USER=1333370467]point[/USER] = 1000 -- INSERT NUMBER OF POINT
SET [USER=289231]Zen[/USER] = 1000000 -- INSERT NUMBER OF ZEN
SET @LVL = 10 -- INSERT NUMBER OF LEVEL
SET @STR = 25 -- INSERT NUMBER OF STRENGTH
SET @AGI = 25 -- INSERT NUMBER OF DEXTERITY
SET @VIT = 25 -- INSERT NUMBER OF VITALITY
SET @ENE = 25 -- INSERT NUMBER OF ENGRGY
SET [USER=12178]cmd[/USER]= 25 -- INSERT NUMBER OF LEADERSHIP
UPDATE Dbo.Character
SET LevelUpPoint = [USER=1333370467]point[/USER], Money = [USER=289231]Zen[/USER], cLevel = @LVL, Strength = @STR, Dexterity = @AGI, Vitality = @VIT, Energy = @ENE, Leadership = [USER=12178]cmd[/USER]
WHERE Name = [USER=551894]Char[/USER]
END