нужна помощь Как сделать вайп на сборке l2base?

[Владимир_Бушковский 2]

Подскажите как сделать вайп?

[Bloondin 0]

Подскажите как сделать вайп?

очисти таблицу в бд с персонажами и аккаунтами. Обычно это accounts и characters

[zGosu 396]

А clans, items не?

[UltrusAra 0]

Очистить все таблицы которые содержат статистические данные от персонажей или других параметров которые изменяются в базе игроками, затем сделать бекап чистой базы (на будущее) и у вас готовая база под вайпы.

В будущем просто - с двух кликов (удалить все) и залить чистый бекап.

Изменено 27 февраля, 2017 пользователем UltrusAra

[Nammi 147]

Запросы в базу вот такие:

DELETE FROM `characters` WHERE 1;

DELETE FROM `character_colors` WHERE 1;

DELETE FROM `character_friends` WHERE 1;;

DELETE FROM `character_hennas` WHERE 1;

DELETE FROM `character_macroses` WHERE 1;

DELETE FROM `character_quests` WHERE 1;

DELETE FROM `character_recipebook` WHERE 1;

DELETE FROM `character_recommends` WHERE 1;

DELETE FROM `character_shortcuts` WHERE 1;

DELETE FROM `character_skills` WHERE 1;

DELETE FROM `character_skills_save` WHERE `1;

DELETE FROM `character_subclasses` WHERE `1;

DELETE FROM `clan_data` WHERE 1;

DELETE FROM `clan_privs` WHERE 1;

DELETE FROM `clan_skills` WHERE 1;

DELETE FROM `clan_subpledges` WHERE 1;

DELETE FROM `clan_wars` WHERE 1;

DELETE FROM `items` WHERE  1;

DELETE FROM `pets` WHERE 1;

DELETE FROM `olympiad_data` WHERE 1;

DELETE FROM `olympiad_fights` WHERE 1;

DELETE FROM `olympiad_nobles` WHERE 1;

DELETE FROM `olympiad_nobles_eom` WHERE 1;

DELETE FROM `heroes` WHERE 1;

DELETE FROM `heroes_diary` WHERE 1;

DELETE FROM `ghosts_players` WHERE 1;

DELETE FROM `mdt_history` WHERE 1;

[NEWFARM 4]

Л2бейс ещё актуальна?

[Norman 78]

 

Запросы в базу вот такие:

DELETE FROM `characters` WHERE 1;

DELETE FROM `character_colors` WHERE 1;

DELETE FROM `character_friends` WHERE 1;;

DELETE FROM `character_hennas` WHERE 1;

DELETE FROM `character_macroses` WHERE 1;

DELETE FROM `character_quests` WHERE 1;

DELETE FROM `character_recipebook` WHERE 1;

DELETE FROM `character_recommends` WHERE 1;

DELETE FROM `character_shortcuts` WHERE 1;

DELETE FROM `character_skills` WHERE 1;

DELETE FROM `character_skills_save` WHERE `1;

DELETE FROM `character_subclasses` WHERE `1;

DELETE FROM `clan_data` WHERE 1;

DELETE FROM `clan_privs` WHERE 1;

DELETE FROM `clan_skills` WHERE 1;

DELETE FROM `clan_subpledges` WHERE 1;

DELETE FROM `clan_wars` WHERE 1;

DELETE FROM `items` WHERE  1;

DELETE FROM `pets` WHERE 1;

DELETE FROM `olympiad_data` WHERE 1;

DELETE FROM `olympiad_fights` WHERE 1;

DELETE FROM `olympiad_nobles` WHERE 1;

DELETE FROM `olympiad_nobles_eom` WHERE 1;

DELETE FROM `heroes` WHERE 1;

DELETE FROM `heroes_diary` WHERE 1;

DELETE FROM `ghosts_players` WHERE 1;

DELETE FROM `mdt_history` WHERE 1;

 

а не проще ли TRUNCATE TABLE ?

[aquamarine 248]

+ за инфу

[LifeGame32 312]

а таблица с аргументацией где?

[Norman 78]

а таблица с аргументацией где?

под каждый сервер - сборку лучше делать свой трункат таблиц  везде они разные