Looking for SQL Scripts

[CAPITOL]

I'm looking for the script for my Test Server:
- Upon creating Character it will be Level 400 automatically with complete stats and quest. If possible, with Master Level and points would be great.

 

[DragonSeth]

SQL Server > Enterprise Manager> MuOnline>DefaultClassType> Open all rows and look for starting level (1) and change it to 399 once that level up one time it will be 400. But there is another way to do this as well.

This way is more simple. Open up mumaker>accountmaker>click the book and edit through there.

Now for the quest i can't really say for sure on that one since i have never done that. Master and level points you would have to set through the master skill tree database.

 

[nofeara]

I did not yet try it however i think you can set default values with constraints in like if this is a DL his npoints would be 2700+ or if a bk like 2100+. For sure you can set default clevel by 400, mlevel by any amount but i think with constraints per character if you want to set automatic quest and type .

 

[myheart]

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