Looking for SQL Scripts

Results 1 to 4 of 4
  1. #1
    HITMAN CAPITOL is offline
    True MemberRank
    Apr 2013 Join Date
    PhilippinesLocation
    675Posts

    Looking for SQL Scripts


    RaGEZONE Recommends

    RaGEZONE Recommends

    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.
    “Knowledge, like air, is vital to life. Like air, no one should be denied it.”


  2. #2
    Alpha Member DragonSeth is offline
    Alpha MaleRank
    Aug 2011 Join Date
    2,307Posts

    Re: Looking for SQL Scripts

    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.

  3. #3
    Account Upgraded | Title Enabled! nofeara is offline
    True MemberRank
    Nov 2009 Join Date
    313Posts

    Re: Looking for SQL Scripts

    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 :D.

  4. #4
    Member myheart is online now
    MemberRank
    Jun 2017 Join Date
    DeviasLocation
    92Posts

    Re: Looking for SQL Scripts

    Code:
    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
     @point INT,
     @Zen INT,
     @LVL INT,
     @STR INT,
     @AGI INT,
     @VIT INT,
     @ENE INT,
    
     @cmd INT,
    
     @Char varchar(10)
    SELECT @Char= Name FROM INSERTED
    
    SET @point = 1000 -- INSERT NUMBER OF POINT 
    SET @Zen = 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 @cmd= 25 -- INSERT NUMBER OF LEADERSHIP
    
    UPDATE Dbo.Character
    SET  LevelUpPoint = @point, Money = @Zen, cLevel = @LVL, Strength = @STR, Dexterity = @AGI, Vitality = @VIT, Energy = @ENE, Leadership = @cmd
    WHERE Name = @Char
    END
    Last edited by myheart; 1 Week Ago at 03:03 AM.




Advertisement