Printable View
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
:)
♦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
300 = stat pointsQuote:
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
2000000 = Zen