Need a hint about __LOOKCHANGE

[LookAtTheFlower]

Hi epvp.

I just added __LOOKCHANGE system , compile without error.
But when i entered the game i dont see any of the my gear even when im trying to put in off and put it on again . Nothing.
The "Item Transmutation System" Window (APP) kind of working.

Video:


So all im asking is a hint or if you want to help me with this it will be much appriciated.
It happens because of a database issue? something missing? or something is
wrong with the code?

BTW: Dont have any errorlog , not in the client , And not in the server files.
Thanks!!
And im not sure if this is necessary, but my ODBC is running on Native Client 10.00.

[Sonraiku]

Look into your database, you need to update your items in the basevalue_tbl. For that sell your starter Equipment and buy them again, equip them and look in the inventory_tbl the new parameters and copy them in the basevalue_tbl to the same coloumn.

Don't forget to paste them in the right line, because there are two, for male and female characters.

[LookAtTheFlower]

Originally Posted by Sonraiku

Look into your database, you need to update your items in the basevalue_tbl. For that sell your starter Equipment and buy them again, equip them and look in the inventory_tbl the new parameters and copy them in the basevalue_tbl to the same coloumn.

Don't forget to paste them in the right line, because there are two, for male and female characters.

I need to do that to every single player who shows up in the tbl_inventory?

[- Major]

Originally Posted by LookAtTheFlower

I need to do that to every single player who shows up in the tbl_inventory?

Every new database part need a update for all existing items.

[Knusper02]

Normally you can just execute this sql query:

BEGIN TRAN

USE [CHARACTER_01_DBF]

UPDATE [BASE_VALUE_TBL] SET [m_Inventory] = '0,502,0,0,,1,0,9000000,0,0,0,0,0,0,0,0,0,-1/1,2801,0,0,,1,0,0,0,0,0,0,0,0,0,0,0,-1/2,4805,0,0,,5,0,0,0,0,0,0,0,0,0,0,0,-1/42,506,0,0,,1,0,5850000,0,0,0,0,0,0,0,0,0,-1/43,510,0,0,,1,0,4500000,0,0,0,0,0,0,0,0,0,-1/44,21,0,0,,1,0,7200000,0,0,0,0,0,0,0,0,0,-1/45,2800,0,0,,3,0,0,0,0,0,0,0,0,0,0,0,-1/$' WHERE g_nSex = '0'
UPDATE [BASE_VALUE_TBL] SET [m_Inventory] = '0,504,0,0,,1,0,9000000,0,0,0,0,0,0,0,0,0,-1/1,2801,0,0,,1,0,0,0,0,0,0,0,0,0,0,0,-1/2,4805,0,0,,5,0,0,0,0,0,0,0,0,0,0,0,-1/42,508,0,0,,1,0,5850000,0,0,0,0,0,0,0,0,0,-1/43,512,0,0,,1,0,4500000,0,0,0,0,0,0,0,0,0,-1/44,21,0,0,,1,0,7200000,0,0,0,0,0,0,0,0,0,-1/45,2800,0,0,,3,0,0,0,0,0,0,0,0,0,0,0,-1/$' WHERE g_nSex = '1'

ROLLBACK

Edit:
doesnt work with 168 slot inv
every old item wont have a look -> you need to update them

[LookAtTheFlower]

Originally Posted by - DK ACE

Every new database part need a update for all existing items.

Just to make sure I understand, I need to take the parameters from Inventory_TBL and copy them to base_value_tbl according to male and female?

Originally Posted by Knusper02

Normally you can just execute this sql query:

BEGIN TRAN

USE [CHARACTER_01_DBF]

UPDATE [BASE_VALUE_TBL] SET [m_Inventory] = '0,502,0,0,,1,0,9000000,0,0,0,0,0,0,0,0,0,-1/1,2801,0,0,,1,0,0,0,0,0,0,0,0,0,0,0,-1/2,4805,0,0,,5,0,0,0,0,0,0,0,0,0,0,0,-1/42,506,0,0,,1,0,5850000,0,0,0,0,0,0,0,0,0,-1/43,510,0,0,,1,0,4500000,0,0,0,0,0,0,0,0,0,-1/44,21,0,0,,1,0,7200000,0,0,0,0,0,0,0,0,0,-1/45,2800,0,0,,3,0,0,0,0,0,0,0,0,0,0,0,-1/$' WHERE g_nSex = '0'
UPDATE [BASE_VALUE_TBL] SET [m_Inventory] = '0,504,0,0,,1,0,9000000,0,0,0,0,0,0,0,0,0,-1/1,2801,0,0,,1,0,0,0,0,0,0,0,0,0,0,0,-1/2,4805,0,0,,5,0,0,0,0,0,0,0,0,0,0,0,-1/42,508,0,0,,1,0,5850000,0,0,0,0,0,0,0,0,0,-1/43,512,0,0,,1,0,4500000,0,0,0,0,0,0,0,0,0,-1/44,21,0,0,,1,0,7200000,0,0,0,0,0,0,0,0,0,-1/45,2800,0,0,,3,0,0,0,0,0,0,0,0,0,0,0,-1/$' WHERE g_nSex = '1'

ROLLBACK

Edit:
doesnt work with 168 slot inv
every old item wont have a look -> you need to update them

With those parameters? or parameters form Inventory_TBL?

[LookAtTheFlower]

Originally Posted by LookAtTheFlower

Just to make sure I understand, I need to take the parameters from Inventory_TBL and copy them to base_value_tbl according to male and female?

With those parameters? or parameters form Inventory_TBL?

*BUMP*
Still need help...
I tried to execute the with the parameters i have in inventory_tbl from each character..
Nothing work.

[Sonraiku]

When the Query isn't working for you, then you have to do it by yourself.

1.Create a new character male/female
2.Sell your Equipment and rebuy the same parts/weapons
3. Equip them and log out
4. Go to your database and open Inventory_tbl
5. copy&paste m_apIndex to the same coloumn in the base_value_tbl
6. Do the same with the opposite gender, take care of what line you pasting the parameters.

[LookAtTheFlower]

Originally Posted by Sonraiku

When the Query isn't working for you, then you have to do it by yourself.

1.Create a new character male/female
2.Sell your Equipment and rebuy the same parts/weapons
3. Equip them and log out
4. Go to your database and open Inventory_tbl
5. copy&paste m_apIndex to the same coloumn in the base_value_tbl
6. Do the same with the opposite gender, take care of what line you pasting the parameters.

Hi , i did it but it still the same.

[Sonraiku]

Try with both m_apIndex and m_dwObjIndex.

[LookAtTheFlower]

Originally Posted by Sonraiku

Try with both m_apIndex and m_dwObjIndex.

Not working..