Форум администраторов игровых серверов

помогоите удалить старых чаров и их итемы
как просто удалить старых чаров я знаю а как удалить итемы
DELETE FROM characters WHERE lastAccess < 1292846400;
DELETE FROM accounts WHERE lastactive < 1292846400;

Добавлено через 2 часа 50 минут
тему можно закрыть, нашел

Код:

DELETE FROM accounts WHERE login NOT IN (SELECT account_name FROM characters);

DELETE FROM characters WHERE account_name NOT IN (SELECT login FROM accounts);

DELETE FROM character_friends WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_hennas WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_macroses WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_quests WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_recipebook WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_shortcuts WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_skills WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_skills_save WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_subclasses WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM character_raid_points WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM clan_data WHERE leader_id NOT IN (SELECT charId FROM characters);

DELETE FROM clan_privs WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM clan_skills WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);

UPDATE clan_subpledges SET leader_id = 0 where leader_id NOT IN (SELECT charid from characters);

DELETE FROM pets WHERE item_obj_id NOT IN (SELECT object_id FROM items WHERE owner_id IN (SELECT charId FROM characters));

DELETE FROM items WHERE owner_id NOT IN (SELECT charId FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM seven_signs WHERE charId NOT IN (SELECT charId FROM characters);

UPDATE characters SET clanid = 0, title = "", clan_privs = 0 where clanid NOT IN (SELECT clan_id FROM clan_data);

UPDATE clanhall SET ownerId = 0, paidUntil = 0 where ownerId NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM forums WHERE forum_owner_id NOT IN (SELECT clan_id FROM clan_data) AND forum_owner_id != 0;

DELETE FROM posts WHERE post_ownerid NOT IN (SELECT charId FROM characters);

DELETE FROM topic WHERE topic_ownerid NOT IN (SELECT charId FROM characters);

DELETE FROM olympiad_nobles WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM heroes WHERE charId NOT IN (SELECT charId FROM characters);

DELETE FROM item_attributes WHERE itemId NOT IN (SELECT object_id FROM items);

DELETE FROM siege_clans WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);

Добавлено через 4 часа 5 минут
еще 1 проблема , немогу перенести таблицу

Код:

[Err] 1366 - Incorrect integer value: 'INVENTORY' for column 'loc' at row 1

[Err] --

-- Дамп данных таблицы `items`

--



INSERT INTO `items` (`owner_id`, `object_id`, `item_id`, `count`, `enchant_level`, `loc`, `loc_data`, `time_of_use`, `custom_type1`, `custom_type2`, `mana_left`, `time`) VALUES

(268482587, 268482588, 5588, 1, 0, 'INVENTORY', 81, NULL, 0, 0, -1, -1),

Добавлено через 5 часов 30 минут
и сново сам нашел, сорь за флуд))