Как Сделать Вайп?

[goldform 55]

)

[Grend 39]

))))))))))))) ахахахах

[KillerProMW 84]

пффффффффф ухахаххаха

бд переустанови и все

Изменено 21 марта, 2013 пользователем KillerProMW

[Mixer 67]

)

Розширений вопрос )))))))

[FludGod 91]

characters - зашел - alt+a - delete

[Hotaka 769]

characters - зашел - alt+a - delete

этого слишком мало для полноценного вайпа. Ваш вариант может привести к проблемам в будущем

[Twinker 487]

о_О

Вы чего ребят? А потом тогда надо будет заного вливать таблицы.

 

SQL запрос в БД:

DELETE FROM characters;
DELETE FROM accounts;
DELETE FROM characters_*;

 

characters_* замените на те, что у Вас есть вида characters_что-то. То есть еще несколько запросов создайте.

[Hotaka 769]

о_О

Вы чего ребят? А потом тогда надо будет заного вливать таблицы.

 

SQL запрос в БД:

DELETE FROM characters;
DELETE FROM accounts;
DELETE FROM characters_*;

 

characters_* замените на те, что у Вас есть вида characters_что-то. То есть еще несколько запросов создайте.

если на то пошло то надо вычищать все эти таблицы

 

 

account_data
accounts
augmentations
characters
clan_data
clan_notices
clan_privs
clan_skills
clan_subpledges
clan_wars
clanhall_functions
global_tasks
heroes
items
olympiad_nobles

[Detect 618]

delete bd потом заново установить) ЧТо бы в будущем не было проблем с оставшимися таблицами)

[Hotaka 769]

delete bd - глупый вариант. в период обт в бд всегда происходят те или иные изменения. постом выше я написал список таблиц которые нужно полностью вычищать для нормального существования сервера после старта.

[StarLight 14]

да если токо Акаунт и чарактерс удалить этого понятно что мало

 

На ОБТ епиков вальнут (на старте будут мертвыми)

Итемс (на старте будут персонажи с вещами Донки/колы/Пухи+++) у меня было уже такое чел стартанул с нефом и 55 донок в кармане, пришлось донки забрать неф оставить в качестве награды, игрокам сказал что неф за то что он первый на серве)

[heka 32]

базу данных удалить полностью это тупо, прийдется потом заного добавлять все нпц и то что добавлял

[KROFI 114]

UPDATE characters SET online=0;

DELETE FROM characters WHERE lastAccess < 1191211200;

DELETE FROM accounts WHERE lastactive < 1191211200;

DELETE FROM characters WHERE level < 75;

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

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

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

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

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

DELETE FROM clan_wars WHERE clan1 NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM clan_wars WHERE clan2 NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM auction_bid WHERE bidderId NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM clanhall_functions WHERE hall_id NOT IN (SELECT ID FROM clanhall WHERE ownerId <> '0');

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

UPDATE clanhall SET ownerId='0' WHERE ownerId NOT IN (SELECT clan_id FROM clan_data);

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

DELETE FROM account_data WHERE account_name NOT IN (SELECT account_name FROM characters);

DELETE FROM account_data WHERE value NOT IN (SELECT obj_Id FROM characters);

DELETE FROM items WHERE loc <> 'clanwh' and owner_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM items WHERE loc = 'clanwh' and owner_id NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM character_skills WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_skills_save WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_shortcuts WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_recipebook WHERE char_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_quests WHERE char_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_macroses WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_hennas WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_friends WHERE char_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_subclasses WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);\

DELETE FROM pets where item_obj_id not in (SELECT object_id FROM items);

DELETE FROM seven_signs WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM forums WHERE forum_owner_id <> '0' AND forum_owner_id NOT IN (SELECT clan_id FROM clan_data);

Вот на тебе запрос на вайп сервера, а то тебе щас насоветуют) модераторы всякие и тому подобные)

[Pro1ooVova 20]

ахахахах автор насмешыл

[WingChun 31]

DELETE FROM account;

DELETE FROM auction_bid;

DELETE FROM augmentations;

DELETE FROM character_friends;

DELETE FROM character_hennas;

DELETE FROM character_macroses;

DELETE FROM character_quests;

DELETE FROM character_shortcuts;

DELETE FROM character_skills;

DELETE FROM character_skills_save;

DELETE FROM character_subclasses;

DELETE FROM characters;

DELETE FROM clan_data;

DELETE FROM clan_privs;

DELETE FROM clan_skills;

DELETE FROM clan_subpledges;

DELETE FROM items;

DELETE FROM olympiad_nobles;

DELETE FROM pets;

DELETE FROM privatepanel_activeacc;

DELETE FROM siege_clans;

[Twinker 487]

UPDATE characters SET online=0;

DELETE FROM characters WHERE lastAccess < 1191211200;

DELETE FROM accounts WHERE lastactive < 1191211200;

DELETE FROM characters WHERE level < 75;

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

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

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

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

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

DELETE FROM clan_wars WHERE clan1 NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM clan_wars WHERE clan2 NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM auction_bid WHERE bidderId NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM clanhall_functions WHERE hall_id NOT IN (SELECT ID FROM clanhall WHERE ownerId <> '0');

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

UPDATE clanhall SET ownerId='0' WHERE ownerId NOT IN (SELECT clan_id FROM clan_data);

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

DELETE FROM account_data WHERE account_name NOT IN (SELECT account_name FROM characters);

DELETE FROM account_data WHERE value NOT IN (SELECT obj_Id FROM characters);

DELETE FROM items WHERE loc <> 'clanwh' and owner_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM items WHERE loc = 'clanwh' and owner_id NOT IN (SELECT clan_id FROM clan_data);

DELETE FROM character_skills WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_skills_save WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_shortcuts WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_recipebook WHERE char_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_quests WHERE char_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_macroses WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_hennas WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_friends WHERE char_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM character_subclasses WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);\

DELETE FROM pets where item_obj_id not in (SELECT object_id FROM items);

DELETE FROM seven_signs WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);

DELETE FROM forums WHERE forum_owner_id <> '0' AND forum_owner_id NOT IN (SELECT clan_id FROM clan_data);

Вот на тебе запрос на вайп сервера, а то тебе щас насоветуют) модераторы всякие и тому подобные)

Сами то подумайте, что даете ТСу.

При чем тут удаление чаров, если лвл < 75? o_O

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

Удалить из accounts_data если account_name не равен логин из accounts.

 

Полный бред.

Все после DELETE FROM * надо удалить. WHERE тут вообще ни к чему.

Изменено 21 марта, 2013 пользователем Twinker