Houses

[Denyy]

How to delate all items from houses i delated all chars from database but still there are items in houses without owners.

Cuz.

 

[Denyy]

Come on! where i can do it?

 

[SpiderOT]

tils_items

 

[Cykotitan]

TRUNCATE TABLE house_data;
TRUNCATE TABLE tile_items;
TRUNCATE TABLE tiles;

 

[Denyy]

Thank you very much!

Anyway if any of you have the same problems do not delete each page just delet all table and add this.

CREATE TABLE `tile_items`
(
	`tile_id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`sid` INT NOT NULL,
	`pid` INT NOT NULL DEFAULT 0,
	`itemtype` INT NOT NULL,
	`count` INT NOT NULL DEFAULT 0,
	`attributes` BLOB NOT NULL,
	UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
	FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[SpiderOT]

well you suppose to use "TRUNCATE/empty" not drop xD