Jump to content
  • 0

Request Sql Script


Question

2 answers to this question

Recommended Posts

  • 0
Posted
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.

  • Upvote 1
  • 0
Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...