Useful SQL queries

[ESTEBAN2010]

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]

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]

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

Tell us another thing to read a lot. Thank you

[max1flo]

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

[1tm]

http://www.maxcheaters.com/forum/index.php?topic=98212.0 <-- look here.. :|

[˚°▫•Eмiизм●▫°˚™]

good job ;)