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

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

PHP Code:

---

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 


---

Great guide, thanks alot :)

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.

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)
            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! :w00t::thumbup:
BTW: it doesnt funct in 1.2Q ! for me :(

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

Code:

---

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')

---

HELP ?! I dont have WZ_CreateCharacter in MuOnline stored procedures :grr::grr:

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

how aboout adding set or creits after register

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

wow, thanks alot. really nice :tongue:

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

thank you for this guide ^^