Вот решил написать мануал по очистки БД realmd(чистка акков не заходяших больше 50 дней)
Quote
DELETE FROM `account` where
`id` not in (select account from
`characters`.`characters`);
DELETE FROM `account` WHERE
`last_login`>50;
DELETE FROM `account` where
`id` not in (select `account` from
`characters`.`characters`) AND
gmlevel = '0';
DELETE FROM `account_banned`;
DELETE FROM `characters` where
level<3;
DELETE FROM `character_action`
where guid not in (select guid
from `characters`);
DELETE FROM `character_aura`
where guid not in (select guid
from `characters`);
DELETE FROM `character_gifts`
where guid not in (select guid
from `characters`);
DELETE FROM
`character_homebind` where
guid not in (select guid from
`characters`);
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_reputation` where
guid not in (select guid from
`characters`);
DELETE FROM `character_social`
where guid not in (select guid
from `characters`);
DELETE FROM `character_spell`
where guid not in (select guid
from `characters`);
DELETE FROM
`character_spell_cooldown`
where guid not in (select guid
from `characters`);
DELETE FROM `character_ticket`
where guid not in (select guid
from `characters`);
DELETE FROM `character_tutorial`
where account not in (select
account from `characters`);
DELETE FROM `corpse` where
`player` not in (select guid from
`characters`);
DELETE FROM
`character_inventory` where guid
not in (SELECT guid FROM
`characters`);
DELETE FROM `item_instance`
where owner_guid not in (SELECT
guid FROM `characters`);
DELETE FROM `account_data`
where `account` not in (select
account from `characters`);
DELETE FROM
`character_account_data` 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_talent`
where `guid` not in (select guid
from `characters`);
Этот код пихаем в документ.txt
и меняем на документ.sql и
заливаем в базу. И етим мы удаляем старые аккаунты.
