Windows Remove items SQL query

[xkevinz]

could someone give me the sql query to remove a certain item out of everyone player? please and thank you, rep++ to whoever who helps me

 

[xkevinz]

can soemoen help me pls

 

[Korrex]

Player items are not stored in SQL, so no, that's not possible.

 

[Diath]

Player items are not stored in SQL, so no, that's not possible.

What is player_items table then?

 

[Korrex]

What is player_items table then?

Fake table.

 

[RaikND]

Delete Tileitems (Houses):

DELETE FROM tile_items WHERE itemtype = ID-ITEM;

Delete Players items:

DELETE FROM player_items WHERE itemtype = ID-ITEM;

Delete Player Depot Items:

DELETE FROM player_depotitems WHERE itemtype = ID-ITEM;

 

[Blanz420]

Woo thanxx very much RaikND, helpd us out on that one big time. do we need to execute the command when the server off?