Request Sql Script

[Bringer]

Hello i have 4 kinds of Weapon

1100 Sword

1400 Lance

1600 Staff

1700 Bow

is possible to Delete Only The +10 Weapons?

[Emistry]

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.

[nitrous]

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;");