[mysql] Query that gives points and takes items

[wesoly136]

Hi!
I need a query that will take an item from player and give them amount of points.

For example.
Account manager has item with id 9999

and When I execute the query he will lose this item and get points which I will write in query

It should work for all players in database.

Thanks

 

[Cykotitan]

triple post? ^_^
what?

 

[Darkhaos]

Just use:

delete * from player_items where itemtype = 2195;

It will delete all boots of haste(2195) from all players.

delete * from player_items;

It will delete ALL items from all players.

 

[Cykotitan]

why would he need that :S