[sql] Запрос на удаление чаров
10 replies112 viewsCurrently viewing: 1
· 07/20/2009, 07:21 AM
Здравствуйте все.
У меня такой вопрос.
Существует ли запрос в базу для удалениче чаров определенных лвл?
или например удалить всех чаров до 30 лвл.
или удалить всех чаров 1ых лвлов.
буду очень благодарен кто поделиться этим запросом.
0
· 07/20/2009, 07:23 AM
delete from characters where level<30;
— Perpetuum Mobile
0
· 07/20/2009, 07:28 AM
Может в нем что-то не то? так-как проверил, чары 30ых лвлов есть. но пишет, что удаленно 0.
и в базе тоже остались они.
0
· 07/20/2009, 07:31 AM
morfeus: delete from characters where level<30;
а можно не от фонаря слова написать, а с символами прямой запрос, такой как должен быть в файле, с знаками ' "???
Тут не все мего умники сидят...
— АдмиралЪ О_о
0
· 07/20/2009, 07:54 AM
morfeus: delete from characters where level<30;
буду благодарен, если даш полный запрос.
всем кому понадобиться запрос на удаление то вот
DELETE FROM characters where level='30';
'30'; это лвлч аров можете менять на какой захотите.
0
· 07/20/2009, 08:04 AM
gashish: Может в нем что-то не то? так-как проверил, чары 30ых лвлов есть. но пишет, что удаленно 0.
и в базе тоже остались они.
запрос удалит всех чаров до 30го лвл, т.е. максимальный уровень удаляемых чаров - 29. чтобы удалить с 30 включительно нужно либо поставить 31, либо <=
tiesto: а можно не от фонаря слова написать, а с символами прямой запрос, такой как должен быть в файле, с знаками ' "???
Тут не все мего умники сидят...
это итак корректный запрос, от наличия ' и " тут ничего не изменится. что за глупые предъявы?
вы понимаете, что используя такой запрос вы оставляете огромное кол-во мусора в бд - к примеру остаются вещи, которые были у игрока?
0
· 07/20/2009, 08:12 AM
ansa: вы понимаете, что используя такой запрос вы оставляете огромное кол-во мусора в бд - к примеру остаются вещи, которые были у игрока?
зря беспокоишся..сервер при загрузке почистит
— Perpetuum Mobile
0
· 07/20/2009, 08:19 AM
morfeus: зря беспокоишся..сервер при загрузке почистит
а если нет? :) или почистит не так...
имхо человеку, который не понимает почему не удаляется 30 лвл при условии <30 вообще опасно править бд ручками...
0
· 07/20/2009, 08:23 AM
я же отпсиал, вот вам запрос:
всем кому понадобиться запрос на удаление то вот
DELETE FROM characters where level='30';
'30'; это лвлч аров можете менять на какой захотите.
0
· 07/20/2009, 08:29 AM
Раскрывающийся текст
Код
DELETE FROM characters where level <= 30;
-- claning other
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);
DELETE FROM obj_restrictions WHERE obj_Id NOT IN (SELECT charId FROM characters);
DELETE FROM couples WHERE player1Id NOT IN (SELECT charId FROM characters);
DELETE FROM couples WHERE player2Id NOT IN (SELECT charId FROM characters);
DELETE FROM characters_custom_data WHERE charId NOT IN (SELECT charId FROM characters);
-- claning other
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);
DELETE FROM obj_restrictions WHERE obj_Id NOT IN (SELECT charId FROM characters);
DELETE FROM couples WHERE player1Id NOT IN (SELECT charId FROM characters);
DELETE FROM couples WHERE player2Id NOT IN (SELECT charId FROM characters);
DELETE FROM characters_custom_data WHERE charId NOT IN (SELECT charId FROM characters);
0
Войдите или зарегистрируйтесь чтобы ответить