Вайп

[NakomoDE 27]

дайте запрос пожалуйста

[black yoga 6]

И нах*й так жить? Смысл тебе открывать серьёзный проект если ты элементарных вещей не знаешь? Начел бы с чего попроще. Деньги есть? Закончатся.

[Absent 263]

дайте запрос пожалуйста

 

таблице items удали и залей по новой) весь запрос)

[HECKBuK 229]

запрос кидать не буду, т.к. нет желания, но объясню что удалить

данные из:

items

characters и все подобные с character_***

l2top

donat

premium

accounts

возможно есть еще таблицы, т.к. название сборки я не знаю

[Noobasik24 214]

DELETE FROM characters;

DELETE FROM character_friends;

DELETE FROM character_hennas;

DELETE FROM character_macroses;

DELETE FROM character_quests;

DELETE FROM character_quests_item;

DELETE FROM character_raid_points;

DELETE FROM character_recipebook;

DELETE FROM character_recommends;

DELETE FROM character_shortcuts;

DELETE FROM character_skills;

DELETE FROM character_skills_save;

DELETE FROM character_stats;

DELETE FROM character_subclasses;

DELETE FROM character_custom_data;

DELETE FROM items;

DELETE FROM item_attributes;

DELETE FROM accounts;

DELETE FROM clan_data;

DELETE FROM clan_notices;

DELETE FROM clan_skills;

DELETE FROM clan_wars;

DELETE FROM clan_privs;

DELETE FROM clan_subpledges;

Примерно так))

Изменено 17 декабря, 2012 пользователем Noobasik24

[Noobasik24 214]

Только добавь какие столбцы еще тебе не нужны)и делай запрос

[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);

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

Скрипт для очистки базы ява сервера:

суть простая, удаляются чары и все вещи и прочее ниже определенного времени или не заходившие с какого то времени.