вайпаем шмот, с инвенторя, гб, банка, почты итд
Код:
DELETE FROM item_instance WHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 4), ' ', -1) AS UNSIGNED)=номер шмотки;
DELETE FROM item_instance WHERE CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 4), ' ', -1) AS UNSIGNED)=номер шмотки;
DELETE FROM `auctionhouse` where `itemguid` not in (SELECT `guid` FROM `item_instance`);
DELETE FROM `character_inventory` where `item` not in (SELECT `guid` FROM `item_instance`);
DELETE FROM `guild_bank_item` where `item_guid` not in (SELECT `guid` FROM `item_instance`);
DELETE FROM `mail_items` where `item_guid` not in (SELECT `guid` FROM `item_instance`);
DELETE FROM `character_gifts` where `item_guid` not in (SELECT `guid` FROM `item_instance`);
удаляем мусор от удалённых чаров
Код:
DELETE FROM `item_instance` WHERE `guid` NOT IN (SELECT `itemguid` FROM `auctionhouse`) AND `guid` NOT IN (SELECT `item_guid` FROM `character_gifts`) AND `guid` NOT IN (SELECT `item` FROM `character_inventory`) AND `guid` NOT IN (SELECT `item_guid` FROM `guild_bank_item`) AND `guid` NOT IN (SELECT `item_guid` FROM `mail_items`);