How to: remove itens from house of deleted players ?

[1268995]

I am trying this command:

UPDATE `houses` SET `owner` = '0' WHERE `houses`.`owner` NOT IN ( SELECT `players`.`id` FROM `players` WHERE `players`.`id` = `houses`.`owner` );

But its not working. Do not appear any error, but itens inside houses are not being deleted.

EDIT: i am reseting my server... if u guys have other way to remove itens from deleted players from house, tell me!

 

[Xikini]

I have no clue how to automatically do it.. but you could create another god character, then make him the house owner, then remove house, and all items will go into his depot. xD
(I'll look for a better solution though. )

https://otland.net/threads/remove-house-owner.129065/

I'm not good with the commands, but this was interesting.
Maybe the commands used will help you.

 

[Lordfire]

Please do backup before trying. I could not test it:

DELETE FROM `tile_store` WHERE `tile_store`.`house_id` NOT IN ( SELECT `houses`.`id` FROM `houses` WHERE `houses`.`owner` NOT IN ( SELECT `players`.`id` FROM `players` WHERE `players`.`id` = `houses`.`owner` ) );