Start stat points and zen (With ScreenShot)! 300 point thing :)

[shadowvzs]

go to stored procedures of DB muonline and search for WZ_CreateCharacter and search this

if( @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

THX to gradius!

double click to WZ_CreateCharacter

[MentaL]

[vaiben]

"go to stored procedures of DB "

Can you tell me how to do that in a more noobish way? :)

[shadowvzs]

"go to stored procedures of DB "

Can you tell me how to do that in a more noobish way? :)

its easy, i uploaded 2 screen shot

[vaiben]

Thx! ;)

[Faronnia]

Looks like good work to me :red_india Thanks for this very useful Guide.

[bramdebouvere]

Nice guide for the new guyz :)

[-/7y/I9I-]

Good & useful guide, Thanks.

[Lincolin]

nice but can be done even better

I can make it change anything .. like quest,inventory well anything .. even warehouse.. if someone needs this .. i can explain

[shadowvzs]

nice but can be done even better

I can make it change anything .. like quest,inventory well anything .. even warehouse.. if someone needs this .. i can explain

so why didn't you open the guide because there where many questions about this in help section before

[jim3481]

Thank!

I need all guides of store procedures...!

[DarkerLT]

jim3481
D:D You Made Me Laughing D:D
it doesn't need any guides.. just open up Procedures, Read it, Close it..
And then you can create some things like Create Character in Website , new Reset system or smth ^^

[Caspa]

Tnx, nice guide!

[Lincolin]

so why didn't you open the guide because there where many questions about this in help section before

Was it ? ohh// sry didin't know .. I will make a guide on making a realy custom character creation :D... SQL ofcourse .. but olso can make one in php .. or a very custom reset script...

[epik]

[juztaz]

How to make that all new char, except DK would get points?

[Netzo]

how to make it for this? 1.01e...

CREATE  procedure  MX_CreateCharacter 

@AccountID varchar(10), 
@Name nvarchar(12),
@cLevel smallint, 
@LevelUpPoint int, 
@Class tinyint, 
@Experience int, 
@Strength int, 
@Dexterity int, 
@Vitality int, 
@Energy int, 
@Money int, 
@Life real, 
@MaxLife real, 
@Mana real, 
@MaxMana real, 
@MapNumber smallint, 
@MapPosX smallint, 
@MapPosY smallint, 
@MapDir tinyint 

as 
set nocount on

INSERT INTO Character 
(AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, MDate,LDate,DbVersion
,zs_count
)  
VALUES 
(@AccountID, @Name, @cLevel, @LevelUpPoint, @Class, @Experience, @Strength, @Dexterity, @Vitality, @Energy, @Money, @Life, @MaxLife, @Mana, @MaxMana, @MapNumber, @MapPosX, @MapPosY, @MapDir, getdate(), getdate(), 1
,5
)

set nocount off
GO 

[mathiasdk]

Great guide, thanks alot :)

[lekiller]

Hello, maybe this is old guide, very old guide, sorry for bump, but i just want help. I had same error 121. I know now, how to fix it.

            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, 100, @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, 1000000

Bold font shows changed items. 100 = level up points, 1000000 = starting zen and Money, you just needed to insert that ! Now it will work!
BTW: it doesnt funct in 1.2Q ! for me :(

[jrroger]

How can I fix it, if your way to do it doesn't work for me, let me show you I can't get a good result...

By the way I am working with WZT Group Release I use 2 DB, MuOnline and MuLog

I thougth I could resolve this issue by makin a task to erase the 300 stat points, but if the player can see the 300 points, just doing a small change in points of any characteristic of his/her character, the task wont work...

Maybe i can try just changing 300 leveluppoints if level up points = 300 and Resets = 0 or working in a more complex query...

Any idea?....

I did a job, I know it is not the best way to fix it, but it would be until find anything else better and not laggy

UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('28') and Dexterity=('20') and Vitality=('25') and energy=('10') and Resets=('0') and LevelUpPoint=('300')

UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('18') and Dexterity=('18') and Vitality=('15') and energy=('30') and Resets=('0') and LevelUpPoint=('300')

UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('22') and Dexterity=('25') and Vitality=('20') and energy=('15') and Resets=('0') and LevelUpPoint=('300')

UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('26') and Dexterity=('26') and Vitality=('26') and energy=('26') and Resets=('0') and LevelUpPoint=('300')

UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('26') and Dexterity=('20') and Vitality=('20') and energy=('15') and Resets=('0') and LevelUpPoint=('300')

UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('26') and Dexterity=('26') and Vitality=('26') and energy=('26') and Resets=('0') and LevelUpPoint=('300')

UPDATE Character
SET LevelUpPoint=('0'), Inventory=NULL
WHERE Strength=('21') and Dexterity=('21') and Vitality=('18') and energy=('23') and Resets=('0') and LevelUpPoint=('300')

[das4o]

HELP ?! I dont have WZ_CreateCharacter in MuOnline stored procedures

[drake112]

And what to do if you don't see that text when double clicking WZ_CreateCharacter ?

[mushan]

how aboout adding set or creits after register

[Phant0m]

Sorry for the bump, but I cant seem to get rid of the points...
I edited the procedure, but it still gives them...

[catalin090]

wow, thanks alot. really nice

[freakmastersx]

how about what if starter item?instead of stats and zen?