darking123 Posted May 31, 2014 Posted May 31, 2014 How to delete item in the database using sql command if the item is worn in the costume tab? Quote
0 squire14 Posted February 24, 2023 Posted February 24, 2023 (edited) 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 Quote
Kichi Posted June 1, 2014 Posted June 1, 2014 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 1 Quote
Question
darking123
How to delete item in the database using sql command if the item is worn in the costume tab?
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.