SQL query/ How to replace a specific item from player inventory or equiped item

[DanialFX]

For example. I want to replace item id 8888 with 4444 for all players item

[sandbox]

If you mean via phpmyadmin..

UPDATE `inventory` SET `nameid`=4444 WHERE `nameid`=8888;
UPDATE `cart_inventory` SET `nameid`=4444 WHERE `nameid`=8888;
UPDATE `storage` SET `nameid`=4444 WHERE `nameid`=8888;
UPDATE `guild_storage` SET `nameid`=4444 WHERE `nameid`=8888;

 

If you want it via npc script, just add enclose them in

query_sql()'

 

Make sure your server is turned off.. And you have a backup.

[DanialFX]

Thanks. How about to change the items that player is equiped?

UPDATE `inventory` SET `equip`=4444 WHERE `equip`=8888;

is it true?

Edited March 4, 2014 by DanialFX

[sandbox]

It should work the same even if its equipped, 'equip' column contains the equipment slot, not the item id