delete item in costume tab

[darking123]

How to delete item in the database using sql command if the item is worn in the costume tab?

[squire14]

hi

On 6/1/2014 at 1:59 PM, Kichi said:

example

 

from char 150000

want to delete 19507

and it worn by that char (equip )

DELETE FROM `inventory` WHERE char_id='150000' AND nameid='19507' AND equip='1024;

equip will return to value of headgear position, and it will be 0 if the equip is not worn to the char

 

CMIWW

hi tried to run query coz i wanna delete item id: 20285 custom item tab in lower headgear

i ran

DELETE FROM `inventory` WHERE char_id='150007' AND nameid='20285' AND equip='1024';

 

tried to log in and error still exist. need help

Edited February 24, 2023 by squire14

[Kichi]

example

 

from char 150000

want to delete 19507

and it worn by that char (equip )

DELETE FROM `inventory` WHERE char_id='150000' AND nameid='19507' AND equip='1024;

equip will return to value of headgear position, and it will be 0 if the equip is not worn to the char

 

CMIWW