Houses SQL

-- 1- Copiar itens da casa para o dp

INSERT INTO player_depotitems
(player_id, itemtype, COUNT)

SELECT players.id, ti.itemtype, ti.COUNT
FROM tile_items ti
JOIN tiles ON tiles.id = ti.tile_id
JOIN houses ON houses.id = tiles.house_id
JOIN players ON players.id = houses.owner



-- 2- Limpar itens das casas

DELETE FROM tile_items ti
WHERE houses.owner = players.id
AND ti.tile_id = tiles.id
AND tiles.house_id = houses.id