darking123 Posted May 31, 2014 Group: Members Topic Count: 318 Topics Per Day: 0.07 Content Count: 931 Reputation: 13 Joined: 12/20/11 Last Seen: November 21, 2020 Share Posted May 31, 2014 How to delete item in the database using sql command if the item is worn in the costume tab? Quote Link to comment Share on other sites More sharing options...
0 squire14 Posted February 24, 2023 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 4 Reputation: 0 Joined: 12/06/22 Last Seen: March 13, 2023 Share 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 Link to comment Share on other sites More sharing options...
Kichi Posted June 1, 2014 Group: Members Topic Count: 25 Topics Per Day: 0.01 Content Count: 509 Reputation: 80 Joined: 11/20/11 Last Seen: October 3, 2020 Share 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 Link to comment Share on other sites More sharing options...
Question
darking123
How to delete item in the database using sql command if the item is worn in the costume tab?
Link to comment
Share on other sites
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.