Create Character level and stats

[HellYeahMU]

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

[MentaL]

[hellang3l]

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

			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.

[HellYeahMU]

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

			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.