TFS 0.X Delete one item for all players

[hiwyn]

Some people get a golden helmet (2471) from a map bug i made...
There is a way to on DB i use a command and delete all golden helmets from players,depots and houses?
Idk how many they get and who get

 

[Addams]

Search in your whole data pack using Notepad++ for the golden helmet id, Just change the directory and then check the scripts/areas where it is.

and search in your map/quests to find if there's an easy quest for it or it is in any container/hidden in your map.
Did your server crash? It may be duplicated golden helmet.

 

[hiwyn]

Search in your whole data pack using Notepad++ for the golden helmet id, Just change the directory and then check the scripts/areas where it is.
View attachment 62207
and search in your map/quests to find if there's an easy quest for it or it is in any container/hidden in your map.
Did your server crash? It may be duplicated golden helmet.

I already fix the map problem, i found where the golden helmet spawns, my problem now is to remove all that golden helmets people pick on each server save...

 

[Addams]

Sorry, I read it all wrong.
insert this query in your database.

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 2471;