Need a hint about __LOOKCHANGE

09/21/2019 14:45 LookAtTheFlower#1
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:
[Only registered and activated users can see links. Click Here To Register...]

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.
09/21/2019 20:13 Sonraiku#2
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.
09/22/2019 10:55 LookAtTheFlower#3
Quote:
Originally Posted by Sonraiku View Post
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?
09/22/2019 11:14 - DK#4
Quote:
Originally Posted by LookAtTheFlower View Post
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.
09/22/2019 11:17 Knusper02#5
Normally you can just execute this sql query:
Code:
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
09/22/2019 11:58 LookAtTheFlower#6
Quote:
Originally Posted by - DK ACE View Post
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?



Quote:
Originally Posted by Knusper02 View Post
Normally you can just execute this sql query:
Code:
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?
09/23/2019 17:08 LookAtTheFlower#7
Quote:
Originally Posted by LookAtTheFlower View Post
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 [Only registered and activated users can see links. Click Here To Register...] with the parameters i have in inventory_tbl from each character..
Nothing work.
09/23/2019 17:56 Sonraiku#8
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.
09/23/2019 23:37 LookAtTheFlower#9
Quote:
Originally Posted by Sonraiku View Post
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.
09/24/2019 06:43 Sonraiku#10
Try with both m_apIndex and m_dwObjIndex.
09/24/2019 15:16 LookAtTheFlower#11
Quote:
Originally Posted by Sonraiku View Post
Try with both m_apIndex and m_dwObjIndex.
Not working..