[V15] Starter Items

[dmanjrod]

I saw this question asked a while ago and I figured i'd post a guide since it isn't the same as v14 where yo did it through a database procedure.

First thing you need to do is make 2 new characters one male and one female. Spawn any items you want them to have, wear any items you want them to wear. Note that if you make them wear something at lvl 15 that they cant normally wear at level 1 it will be unequipped when they log in.

After you made your characters execute this query.

USE CHARACTER_01_DBF
SELECT m_idPlayer, m_szName FROM CHARACTER_TBL WHERE m_szName='char1' OR m_szName='Char2'

Replace char1 and char2 with the names of your characters.

When you get a result copy down the ID listed in the m_idPlayer column and make sure you write down which one is male and which one is female.

After you have the id of each char execute this query

USE CHARACTER_01_DBF
SELECT m_idPlayer, m_Inventory, m_apIndex, m_dwObjectIndex FROM INVENTORY_TBL WHERE m_idPlayer='ID1' OR m_idPlayer='ID2'

After you have the result, copy down the results and make sure you take note of which one is male and which one is female.


After you have all that down execute one final query.

USE CHARACTER_01_DBF
UPDATE BASE_VALUE_TBL SET m_Inventory='', m_apIndex='', m_dwObjIndex='' WHERE g_nSex='1'
UPDATE BASE_VALUE_TBL SET m_Inventory='', m_apIndex='', m_dwObjIndex='' WHERE g_nSex='0'

Make sure you replace the values with the results from the previous query. The first one is for female and the second is for male.

[MentaL]

[Dell Honne]

Naise release.

[Improved]

Wauw thanks alot for this, never thought of it :P

[ptuser]

o well, good job for bringing it up again lol.

[BGxApixen]

Nice job. Well done.

[silver0214]

i got a error m_dwObjectIndex how to fix this?

[yarinil]

i got a error m_dwObjectIndex how to fix this?

Read the Query, if the Query say:

USE CHARACTER_01_DBF
SELECT m_idPlayer, m_Inventory, m_apIndex, m_dwObjectIndex FROM INVENTORY_TBL WHERE m_idPlayer='ID1' OR m_idPlayer='ID2'

its mean m_idPlayer, m_Inventory, m_apIndex, m_dwObjectIndex taken FROM INVENTORY_TBL then you go to INVENTORY_TBL check if m_dwObjectIndex is there , i guess you got it as m_dwObjIndex. go back to the Query and change it to m_dwObjIndex and that's it, easy.

[muffins]

hello guys i got an error on m_dwObjectIndex

how to fix this help me ? add me msn sinx_banzuela@yahoo.com
then team viewer i guess ..
i cant fix this . need response

[aelozore]

Very useful :)

[rayjenscode]

this are working for v16 and v19?

[Xakzi]

this are working for v16 and v19?

yessss

[jblazer]

Also can be used to change default starting gold, or any default value.

USE CHARACTER_01_DBF
UPDATE BASE_VALUE_TBL SET m_dwGold='2000000000' WHERE g_nSex='1'
UPDATE BASE_VALUE_TBL SET m_dwGold='2000000000' WHERE g_nSex='0'