How to WIPE a specify item on database?

[Tales]

How?

[Conflicts]

You can, though you'd have to write 4x more queries for it, it's still do-able. Here's an example for cart_inventory;

UPDATE `cart_inventory` SET `card0` = '0' WHERE `cart_inventory`.`card0` = 'XXXX';
UPDATE `cart_inventory` SET `card1` = '0' WHERE `cart_inventory`.`card1` = 'XXXX';
UPDATE `cart_inventory` SET `card2` = '0' WHERE `cart_inventory`.`card2` = 'XXXX';
UPDATE `cart_inventory` SET `card3` = '0' WHERE `cart_inventory`.`card3` = 'XXXX';

Replace XXXX with the Item ID of the MVP Card you wanted to delete. Setting it to 0 is better than deleting it, for me at least.

[Winz]

DELETE FROM `table_name` WHERE condition1 = "string" OR condition2 = number AND condition3 = "whatever";

ex:

DELETE FROM `global_reg_value` WHERE `str` = "#CASHPOINTS" AND account_id = 20000;

to embed with a NPC script, it will be:

query_sql("DELETE FROM `global_reg_value` WHERE `str` = "#CASHPOINTS" AND account_id = "+escape_sql(getcharid(3))+"");

SQL::DELETE. Refer: http://www.w3schools.com/sql/sql_delete.asp

how did I found this out? https://www.google.com/

Edited November 20, 2014 by Winz

[Tales]

Maybe this can help me, but if i want to delete a MvP card that are equipped this can be a problem?