Promazávání postav a účtů http://pastebin.com/g2uPqHWB

[mirra]

-- Je potreba editovat jakorat datum/cas posledniho lognuti a pripadne zmenit databazi auth na aktualne pouzivanou. Vse z toho je v 1. radku.
-- Pro 3server vytvoril Rohlik
DELETE FROM auth.account WHERE `last_login` < '0000-00-00 00:00:00';
TRUNCATE TABLE `account_data`;
DELETE FROM `arena_team` WHERE captainGuid NOT IN (SELECT guid FROM characters );
DELETE FROM `arena_team_member` WHERE arenaTeamId NOT IN (SELECT arenaTeamId FROM `arena_team` );
DELETE FROM `arena_team_member` WHERE guid NOT IN (SELECT guid FROM characters );
DELETE FROM `auctionhouse` WHERE itemowner NOT IN ( SELECT guid FROM characters );
TRUNCATE TABLE `character_account_data`;
DELETE FROM characters WHERE ( `account` ) NOT IN ( SELECT id FROM auth.`account` );
DELETE FROM `account_instance_times` WHERE ( `accountId` ) NOT IN ( SELECT id FROM auth.`account` );
DELETE FROM `character_action` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_achievement` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_achievement_progress` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_arena_stats` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_aura` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_battleground_data` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_battleground_random` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_equipmentsets` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_feed_log` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_gifts` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_glyphs` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_homebind` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_stats` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
TRUNCATE TABLE `character_instance`;
DELETE FROM `character_inventory` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_pet` WHERE ( OWNER ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_queststatus` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_queststatus_daily` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_queststatus_weekly` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_reputation` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_social` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_talent` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_spell` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `character_skills` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
TRUNCATE TABLE `character_spell_cooldown`;
DELETE FROM `corpse` WHERE ( guid ) NOT IN ( SELECT guid FROM characters );
TRUNCATE TABLE `creature_respawn`;
TRUNCATE TABLE `gameobject_respawn`;
TRUNCATE TABLE `gm_tickets`;
TRUNCATE TABLE `groups`;
TRUNCATE TABLE `group_instance`;
TRUNCATE TABLE `group_member`;
TRUNCATE TABLE `instance`;
TRUNCATE TABLE `instance_reset`;
DELETE FROM `item_refund_instance` WHERE ( player_guid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `item_refund_instance` WHERE `item_guid` NOT IN (SELECT `guid` FROM `item_instance`);
DELETE FROM `item_soulbound_trade_data` WHERE `itemGuid` NOT IN (SELECT `guid` FROM `item_instance`);
TRUNCATE TABLE `lag_reports`;
DELETE FROM `mail` WHERE (receiver ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `mail_items` WHERE (mail_id ) NOT IN ( SELECT id FROM `mail` );
DELETE FROM `petition` WHERE (ownerguid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `petition` WHERE (petitionguid ) NOT IN ( SELECT guid FROM `item_instance` );
DELETE FROM `petition_sign` WHERE (ownerguid ) NOT IN ( SELECT guid FROM characters );
DELETE FROM `petition_sign` WHERE playerguid NOT IN (SELECT guid FROM characters );
DELETE FROM `petition_sign` WHERE petitionguid NOT IN (SELECT petitionguid FROM `petition` );
TRUNCATE TABLE `pet_aura`;
DELETE FROM `pet_spell` WHERE guid NOT IN (SELECT id FROM `character_pet` );
TRUNCATE TABLE `pet_spell_cooldown`;
DELETE FROM `item_instance` WHERE `guid` NOT IN (SELECT `item` FROM `character_inventory`) AND `guid` NOT IN (SELECT `itemguid` FROM `auctionhouse`) AND `guid` NOT IN (SELECT `item_guid` FROM `guild_bank_item`) AND `guid` NOT IN (SELECT `item_guid` FROM `mail_items`) AND `guid` NOT IN (SELECT `item_guid` FROM `character_gifts`);
DELETE FROM `item_instance` WHERE `owner_guid` NOT IN (SELECT `guid` FROM `character_inventory`) AND `owner_guid`<>'0';
DELETE FROM `character_inventory` WHERE `item` NOT IN (SELECT `guid` FROM `item_instance`);
DELETE FROM `auctionhouse` WHERE `itemguid` 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`);





//Děkuji Tomovi. Poslal jsem to tomu Legend serveru - oni to ještě zeefektivní.