starting stat points

Results 1 to 2 of 2
  1. #1
    Proficient Member heureux is offline
    MemberRank
    Jun 2012 Join Date
    181Posts

    starting stat points

    how can i solve this problem about starting stat points , it seems after reset the free stat points comes back again and again . for example my free stat points is 1k for starting new characters but after reset it gives again 1k free stats .

    what is the code in the db?. thanks

    :)


  2. #2
    $ \/\/ /-\ G G Emari is offline
    MemberRank
    Apr 2011 Join Date
    PhilippinesLocation
    670Posts

    Re: starting stat points

    ♦Go to Start> Programm Files>Microsoft SQL Server> Enterprise Manager and Open it.
    ♦Click Microsoft SQL Servers> SQL Server Group> (local) (Windows NT)
    ♦go to stored procedures of DataBase MuOnline and search for WZ_CreateCharacter and search this
    f( @Result <> 0 )
    begin
    GOTO TranProcEnd
    end
    else
    begin
    INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
    Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership,money )
    SELECT @AccountID As AccountID, @Name As Name, Level, 300, @Class As Class,
    Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
    getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,200000
    FROM DefaultClassType WHERE Class = @Class

    SET @Result = @@Error
    300 = stat points
    2000000 = Zen



Advertisement