Create Character level and stats

Hello. i changed create character stats but when friend created character sql data defaultcharacter type section reloaded old options with new options and didnt work.

Is it possible to set up create character level and stats each char ?(For example "Blade Master"+level 400+str 1000+agi 1000+vit 1000+ene 1000) If someone can explain it would be great i really need it.:/:

Have a nice day..

There's a stored procedure named "WZ_CreateCharacter" in "MuOnline" database which can be modify easily

Code:

---

                        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, resets )
                        SELECT @AccountID As AccountID, @Name As Name, 220, 0, @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,0 ,0
                        FROM  DefaultClassType WHERE Class = @Class

---

On SQL2000 you can see it on Databases->MuOnline->Stored Procedures

On SQL 2005 it's Databases->MuOnline->Programmability->Stored Procedures.

Some settings can be changed easily on DefaultClassType table, some must be changed in that stored procedure.

Quote:

---

Originally Posted by hellang3l

There's a stored procedure named "WZ_CreateCharacter" in "MuOnline" database which can be modify easily

Code:

---

                        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, resets )
                        SELECT @AccountID As AccountID, @Name As Name, 220, 0, @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,0 ,0
                        FROM  DefaultClassType WHERE Class = @Class

---

On SQL2000 you can see it on Databases->MuOnline->Stored Procedures

On SQL 2005 it's Databases->MuOnline->Programmability->Stored Procedures.

Some settings can be changed easily on DefaultClassType table, some must be changed in that stored procedure.

---

I tried to change defaultclasstype lvl/stats and hp/mana. But after that when someone create new character, database dont accept that and when i open defaultclasstype on sql i see old options added on new options. but in game old options work only. I tought wz_createcharacter is taking numbers from defaultclasstype also but nope it crash cuz of something.