Delete some items of certains accounts using SQL

[Kakaroto]

Hello, does anyone know how do I delete a specific item in the storage of an account using SQL command, for example: the account 20000000 has 5 items equal to the account, and I want to delete this item using his ID to completely delete the item storage and character inventory, but using the item ID.

 

Sorry for my bad English.
I thank anyone who can help me.

Edited October 5, 2016 by Kakaroto

[Sryx]

DELETE FROM `storage` WHERE `nameid` = '4407' and account_id = '2000000';

If you want to delete in more than 1 account or more than 1 item.

DELETE FROM `storage` WHERE `nameid` in ('4407','4408') and account_id in ('2000000','2000001');

[Bringer]

1st off your Server

 

This Code Delete all Randgris Card Just change the id #

DELETE FROM `storage` WHERE `nameid`=4407;

[Kakaroto]

 

1st off your Server

 

This Code Delete all Randgris Card Just change the id #

DELETE FROM `storage` WHERE `nameid`=4407;

 

 

but I need to delete only a specific account ...

[Azeroth]

DELETE FROM `storage` WHERE `nameid` = '4407' and account_id = '2000000';

If you want to delete in more than 1 account or more than 1 item.

DELETE FROM `storage` WHERE `nameid` in ('4407','4408') and account_id in ('2000000','2000001');

If multiple this?

DELETE FROM `storage` WHERE `nameid` in ('4407','4408','4407') and account_id in ('2000000','2000001','20000002');

[Emistry]

DELETE FROM `inventory` WHERE `char_id` = 12345 AND `nameid` = 4407

DELETE FROM `inventory` WHERE `char_id` = 12345 AND `card0` = 4407

DELETE FROM `inventory` WHERE `char_id` = 12345 AND `card1` = 4407

DELETE FROM `inventory` WHERE `char_id` = 12345 AND `card2` = 4407

DELETE FROM `inventory` WHERE `char_id` = 12345 AND `card3` = 4407

you need to do this for other table like

• cart_inventory
• auction
• mail
• storage
• etc

Edited October 6, 2016 by Emistry

[Sryx]

 

DELETE FROM `storage` WHERE `nameid` = '4407' and account_id = '2000000';

If you want to delete in more than 1 account or more than 1 item.

DELETE FROM `storage` WHERE `nameid` in ('4407','4408') and account_id in ('2000000','2000001');

If multiple this?

DELETE FROM `storage` WHERE `nameid` in ('4407','4408','4407') and account_id in ('2000000','2000001','20000002');

 

Yes you can also use BETWEEN if you have a series/continuous of account id's. (BETWEEN keyword speak itself)

DELETE FROM `storage` WHERE `nameid` in ('4407','4408','4407') and account_id BETWEEN '2000000' and '2000005';

[Kakaroto]

DELETE FROM `storage` WHERE `nameid` = '4407' and account_id = '2000000';

If you want to delete in more than 1 account or more than 1 item.

DELETE FROM `storage` WHERE `nameid` in ('4407','4408') and account_id in ('2000000','2000001');

 

 

 

DELETE FROM `storage` WHERE `nameid` = '4407' and account_id = '2000000';

If you want to delete in more than 1 account or more than 1 item.

DELETE FROM `storage` WHERE `nameid` in ('4407','4408') and account_id in ('2000000','2000001');

If multiple this?

DELETE FROM `storage` WHERE `nameid` in ('4407','4408','4407') and account_id in ('2000000','2000001','20000002');

 

 

DELETE FROM `inventory` WHERE `char_id` = 12345 AND `nameid` = 4407
DELETE FROM `inventory` WHERE `char_id` = 12345 AND `card0` = 4407
DELETE FROM `inventory` WHERE `char_id` = 12345 AND `card1` = 4407
DELETE FROM `inventory` WHERE `char_id` = 12345 AND `card2` = 4407
DELETE FROM `inventory` WHERE `char_id` = 12345 AND `card3` = 4407

you need to do this for other table like

• cart_inventory
• auction
• mail
• storage
• etc

 

 

 

thank you guys!