Useful SQL queries

ESTEBAN2010 · October 13, 2009

To remove an item special:

DELETE FROM items WHERE item_id = ID_ITEM AND owner_id = ID_CHARACTER;

To remove several items:

DELETE FROM items WHERE item_id IN (ID_ITEM1, ID_ITEM2,....) AND owner_id = ID_CHARACTER;

To delete everything a player has:

DELETE FROM items WHERE owner_id = ID_CHARACTER;

and even stronger

DELETE FROM items WHERE owner_id = (SELECT obj_Id FROM characters WHERE name = 'NAME_PERSO');

To remove just the inventory and not what he wears or the warehouse must be added to each query :

AND loc = 'INVENTORY';

_________________ ;)

Mart · October 13, 2009

Here is some too

Set Price Items = 0 adena

( u can do this in anothers colums too, just change the "price" for other thing like "weight" )

UPDATE armor SET price = 0;

UPDATE weapon SET price = 0;

UPDATE etcitem SET price = 0;

npro · October 13, 2009

Thank you for letting us know. Server has been operating to help.

Tell us another thing to read a lot. Thank you

max1flo · November 6, 2009

Thx good job , go on , we need ppl who posts importatnt news :D

1tm · November 7, 2009

˚°▫•Eмiизм●▫°˚™ · November 7, 2009

good job ;)

Recommended Posts