Command for changing Item ID in Database

campomanes25 · 04/18/2019, 01:47

Hello anyone got the sql command to change the item ID to a new ITEM ID that works for Inventory, Bag and Guild Warehouse?

I really appreciate your help.

Fatcode · 08/27/2019, 08:06

Hmmm the thought would be like this:

Query the database to look for the item id ex: 11323 and once found change it to 11324.

xTwiLightx · 08/27/2019, 19:13

You should take a look at the following function, which was developed for this purpose - kinda:

Code:

BOOL CDbManager::Conv(LPCSTR lpFileName)

alfredico · 08/28/2019, 13:50

I've done before using replace function, it could be risky in some cases, but may work for you.

Code:

UPDATE CHARACTER_01_DBF.dbo.INVENTORY_TBL SET m_Inventory = REPLACE(m_Inventory, ',OldId,', ',NewId,') WHERE m_Inventory LIKE '%,OldId,%'

There is a chance of altering other item params like an item count that matches the id or something else, so use at your own risk.