Q>Delete SQL Item

[GM Winter]

hello guys i would like to ask how to delete specific item in the SQL , in my case one of my Player Get bug in wearing one item so it means he wear it then after he wear it he get crash and he cant login in the game so i would like to ask how to delete the item he is wearing so he can login in the game thank in advance more power rathena Team!!!

[Haruka Mayumi]

Edit the Equip value of the item to 0 from the inventory table.. 

[GM Winter]

hello sir i try to search its item id in the inventory table but its nothing there it is just a simple item but cause the player bug  item monocle item id 2239 

[Chaos92]

1 hour ago, chadness said:

hello sir i try to search its item id in the inventory table but its nothing there it is just a simple item but cause the player bug  item monocle item id 2239 

then go to inventory table in your database/mysql/phpmyadmin then find/search for itemid 2239. delete it.

[Balfear]

6 hours ago, chadness said:

hello guys i would like to ask how to delete specific item in the SQL , in my case one of my Player Get bug in wearing one item so it means he wear it then after he wear it he get crash and he cant login in the game so i would like to ask how to delete the item he is wearing so he can login in the game thank in advance more power rathena Team!!!

Also when you delete items (only if it is headgear or robe) from inventory you should update `char` table: set value 0 for head_top, head_mid, head_bottom, robe.

SELECT * FROM `inventory` WHERE char_id = <char id> AND equip > 0;

UPDATE `char` SET head_top = 0, head_mid = 0, head_bottom = 0, robe = 0 WHERE char_id = <char id>;

 

Edited March 15, 2021 by Balfear