[SQL]Question - Answer

[EdenEternal]

i think sql script is much easy and it's was just example

[Realtek2]

it's because we have different packs. i have la2base IL, and that sql query is working for me. which pack you have?

 

i have my own custom pack ... but the databace is from l2jserver so there will be no problem if you make this codes for l2jserver.

Thanks in advice :)

[EdenEternal]

i have my own custom pack ... but the databace is from l2jserver so there will be no problem if you make this codes for l2jserver.

Thanks in advice :)

 

For L2jServer

 

DELETE FROM characters WHERE lastAccess < 155520000;
DELETE FROM character_quests WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM items WHERE owner_id=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_friends WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_shortcuts WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_hennas WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_macroses WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_recipebook WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_recommends WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills_save WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_subclasses WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM clan_data WHERE leader_id=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM heroes WHERE char_id=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM olympiad_nobles WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM augmentations WHERE item_id=(SELECT item_id FROM items WHERE owner_id=(SELECT charId FROM characters WHERE lastAccess < 155520000));
DELETE FROM auction_bid WHERE clan_name=(SELECT clan_name FROM clan_data WHERE leader_id=(SELECT charId FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_privs WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT charId FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_subpledges WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT charId FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_wars WHERE clan1=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT charId FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_wars WHERE clan2=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT charId FROM characters WHERE lastAccess < 155520000));
UPDATE clanhall SET ownerId="0" WHERE ownerId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM pets WHERE item_obj_id=(SELECT object_id FROM items WHERE owner_id=(SELECT charId FROM characters WHERE lastAccess < 155520000));
DELETE FROM seven_signs WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM siege_clans WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT charId FROM characters WHERE lastAccess < 155520000));
DELETE FROM character_instance_time WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_offline_trade WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_offline_trade_items WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_quest_global_data WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_raid_points WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_recipeshoplist WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_tpbookmark WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_ui_actions WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_ui_categories WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_tpbookmark WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);
DELETE FROM olympiad_nobles_eom WHERE charId=(SELECT charId FROM characters WHERE lastAccess < 155520000);

[Realtek2]

Thanks.

I will use it :)