Lua Remove all player items

[Raggaer]

How can I do that to remove all players items without knowing what items the player have?

Thanks

 

[seleo]

drop player_items table and create it again
i dont have the commands
may someone else help you
or google it

 

[Raggaer]

I mean player called "Neck" types /removeall and all items of that players dissapear!

 

[Cronox]

For Delete ALL ITEMS.. you need exequte query in phpmyadmin - SQL

DELETE FROM player_depotitems;
DELETE FROM player_items;
DELETE FROM tile_items;

for only remove 1 item need use query

DELETE FROM player_depotitems WHERE itemtype = 2160;
DELETE FROM player_items WHERE itemtype = 2160;
DELETE FROM tile_items WHERE itemtype = 2160;

For delete all items need have offline your otserver and edit 2160 for what ID item wanna remove

 

[Raggaer]

But for determinate player?

 

[Cronox]

DELETE FROM `player_depotitems` , `player_items`  WHERE `player_id` = '1234'

ID player you look in Seach and write waht player wanna delete items .. in table look
ID - NAME example
1 - cronox

Etc for delete need edit 1234 for ID player