Bringer Posted August 19, 2016 Posted August 19, 2016 Hello i have 4 kinds of Weapon 1100 Sword 1400 Lance 1600 Staff 1700 Bow is possible to Delete Only The +10 Weapons? Quote
0 Emistry Posted August 19, 2016 Posted August 19, 2016 DELETE FROM `inventory` WHERE `nameid` IN ( 1100,1400,1600 ) AND `refine` = 10; DELETE FROM `cart_inventory` WHERE `nameid` IN ( 1100,1400,1600 ) AND `refine` = 10; DELETE FROM `storage` WHERE `nameid` IN ( 1100,1400,1600 ) AND `refine` = 10; DELETE FROM `guild_storage` WHERE `nameid` IN ( 1100,1400,1600 ) AND `refine` = 10; DELETE FROM `mail` WHERE `nameid` IN ( 1100,1400,1600 ) AND `refine` = 10; DELETE FROM `auction` WHERE `nameid` IN ( 1100,1400,1600 ) AND `refine` = 10; shut down server and execute the query. 1 Quote
0 nitrous Posted August 19, 2016 Posted August 19, 2016 query_sql("DELETE FROM inventory WHERE (nameid = 1100 OR nameid = 1400 OR nameid = 1600 OR nameid = 1700) AND refine = 10;"); query_sql("DELETE FROM cart_inventory WHERE (nameid = 1100 OR nameid = 1400 OR nameid = 1600 OR nameid = 1700) AND refine = 10;"); query_sql("DELETE FROM storage WHERE (nameid = 1100 OR nameid = 1400 OR nameid = 1600 OR nameid = 1700) AND refine = 10;"); query_sql("DELETE FROM guild_storage WHERE (nameid = 1100 OR nameid = 1400 OR nameid = 1600 OR nameid = 1700) AND refine = 10;"); Quote
Question
Bringer
Hello i have 4 kinds of Weapon
1100 Sword
1400 Lance
1600 Staff
1700 Bow
is possible to Delete Only The +10 Weapons?
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.