TFS 1.2 Quick way to delete items from player houses

[henkas]

Hello,
so i deleted all players from the database and i noticed that there is still items in the houses is there a quick way to remove it? Or i have to do it by hand?

 

[Fifflaren]

I mean doesnt the items get deleted when you sell the house?

 

[Rombadr]

The house items are also stored in the DB, so you should delete those too

 

[henkas]

I mean doesnt the items get deleted when you sell the house?

Well players are already deleted and it says that no one owns the house but there is still items in it Well i see only houses table and house_list table there is nothing about items like house_items

Post automatically merged: Nov 20, 2020

The house items are also stored in the DB, so you should delete those too

Well i see only houses table and house_list table there is nothing about items like house_items

 

[Rombadr]

Well players are already deleted and it says that no one owns the house but there is still items in it Well i see only houses table and house_list table there is nothing about items like house_items

Post automatically merged: Nov 20, 2020

Well i see only houses table and house_list table there is nothing about items like house_items

tile_store

 

[henkas]

tile_store

hmmm?

Gyazo

gyazo.com

 

[Rombadr]

yup, delete those

 

[henkas]

yup, delete those

There is no delete function

 

[Rombadr]

DELETE FROM `tile_store` WHERE 1

run that query

 

[henkas]

DELETE FROM `tile_store` WHERE 1

run that query

did it and there is still items in house. Reloaded server everything and still same. So what i noticed those items appeared in tile_store again. Like wtf. Maybe somekind of talkaction would fix it? that deletes all items in houses

 

[Leesne]

Tile_store is every item on the map that isn't in default map file and gets saved at server shutdown and loaded.
Shutdown server, run command above. then restart server.