Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

[SHARE] Usefull SQL scripts v3

EdenEternal
 Share

Recommended Posts

EdenEternal Iron Initiate

EdenEternal

Posted
  • Author
Posted

Updated 18/07/2010

 

Give All Clan Skills to Clan

INSERT INTO `clan_skills` VALUES
('id clana','370','3','Clan Vitality'),
('id clana','371','3','Clan Spirituality'),
('id clana','372','3','Clan Essence'),
('id clana','373','3','Clan Lifeblood'),
('id clana','374','3','Clan Morale'),
('id clana','375','3','Clan  Clarity'),
('id clana','376','3','Clan  Might'),
('id clana','377','3','Clan Aegis'),
('id clana','378','3','Clan Empowerment'),
('id clana','379','3','Clan Magic Protection'),
('id clana','380','3','Clan Guidance'),
('id clana','381','3','Clan Agility'),
('id clana','382','3','Clan Withstand-Attack'),
('id clana','383','3','Clan Shield Boost'),
('id clana','384','3','Clan Cyclonic Resistance'),
('id clana','385','3','Clan Magmatic Resistance'),
('id clana','386','3','Clan Fortitude'),
('id clana','387','3','Clan Freedom'),
('id clana','388','3','Clan Vigilance'),
('id clana','389','3','Clan March'),
('id clana','390','3','Clan Luck'),
('id clana','391','1','Clan Imperium');

EdenEternal Iron Initiate

EdenEternal

Posted
  • Author
Posted

Updated 18/07/2010

 

Delete from Server All Data of Character that is not active more then 1 month.

DELETE FROM characters WHERE lastAccess < 155520000;
DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_friends WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_hennas WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_macroses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_recipebook WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_recommends WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM heroes WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM olympiad_nobles WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM augmentations WHERE item_id=(SELECT item_id FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM auction_bid WHERE clan_name=(SELECT clan_name FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM auction_watch WHERE charObjId=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM clan_privs WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_subpledges WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_wars WHERE clan1=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_wars WHERE clan2=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
UPDATE clanhall SET ownerId="0" WHERE ownerId=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM pets WHERE item_obj_id=(SELECT object_id FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM seven_signs WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM siege_clans WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));

Thx Realteк for idea

assassinhachik Iron Initiate

assassinhachik

Posted
Posted

Updated 18/07/2010

 

Delete from Server All Data of Character that is not active more then 1 month.

DELETE FROM characters WHERE lastAccess < 155520000;
DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

Thx Realteк for idea

finally i found it thx you Leki!!

  • 2 months later...
  • 4 months later...
  • 1 month later...
v1hack Iron Initiate

v1hack

Posted
Posted

Updated 18/07/2010

 

Delete from Server All Data of Character that is not active more then 1 month.

DELETE FROM characters WHERE lastAccess < 155520000;
DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_friends WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_hennas WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_macroses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_recipebook WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_recommends WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM heroes WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM olympiad_nobles WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM augmentations WHERE item_id=(SELECT item_id FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM auction_bid WHERE clan_name=(SELECT clan_name FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM auction_watch WHERE charObjId=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM clan_privs WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_subpledges WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_wars WHERE clan1=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM clan_wars WHERE clan2=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
UPDATE clanhall SET ownerId="0" WHERE ownerId=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM pets WHERE item_obj_id=(SELECT object_id FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));
DELETE FROM seven_signs WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM siege_clans WHERE clan_id=(SELECT clan_id FROM clan_data WHERE leader_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000));

Thx Realteк for idea

 

don't understand something 155520000 is 180days in unix timestamp right? so how he get 1 month lol?

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Posts

    • Top4s
      Damage on screen Interlude

      By Top4s · Posted

      Hey, any one can help me or tell advice how to make this shown damage on screen directly on enemy when im hitting it, becuase now this damage is located on my screen near my character. What script or what interface.u class i need modify?
    • RMTgold
      Buying & Selling POE & POE2 Divine-Mirrors

      By RMTgold · Posted

      PAYPAL& BINANCE
    • RMTgold
      Buying & Selling Wynncraft Stx

      By RMTgold · Posted

      PAYPAL& BINANCE
    • RMTgold
      Buying & Selling Torn City Cash

      By RMTgold · Posted

      PAYPAL& BINANCE
    • Happii
      [L2J] L2Berserk

      By Happii · Posted

      Opening Date: Q4 2026 (exact date TBA) Chronicle: High Five (H5) Rates: Mob EXP/SP: low (secondary) | PvP EXP: main progression source (custom formula, exact rate TBA)   Hey everyone,   Announcing L2Berserk, a custom Lineage 2 High Five project currently in development. This is a solo project, so progress may take a bit longer than a full team would need — but it's moving forward steadily. The idea behind it is simple: most servers either force you into rigid factions or let PvP happen almost by accident while everyone grinds mobs for hours. L2Berserk is a crossover of both worlds — there's no faction split, no separate towns, everyone spawns and plays in one shared hub, but progression itself is built around fighting other players instead of farming spots. If you enjoy PvP more than staring at a bot-farming route, this is being built with you in mind.   Already implemented: Custom launcher — own CDN and updater, auto-detects your existing install so setup is fast and low-friction Tower of Trials — a 10-floor PvE dungeon, 3 monster waves per floor, difficulty scales as you climb; built as a solo/small-group challenge track separate from the PvP-EXP loop PvP Arena — an NPC that queues players into Party vs Party or Command Channel vs Command Channel arena matches on demand Olympiad — implemented and functional for structured 1v1/team PvP Event Manager — automated system running rotating events every 10 minutes non-stop, so there's always something active for players to jump into Single shared hub — no faction-locked zones; PvP-driven EXP progression is the main way you level PvP Zone — a dedicated zone avaiable through PvP Zone Teleport Scroll. Zones have boundaries so players won't run from pvp forever. Planned: Kill-streak rewards / bounty system — the more active you are in PvP, the more visible and rewarded you become PvP ranking / leaderboard with seasonal recognition More content and events Additional Discord integrations A live testing phase with the community before the official opening, so mechanics get stress-tested before Q4 A lot more features are planned beyond what's listed here — the project is still actively growing If you have suggestions, feel free to post them on Discord   A note on where things stand: the server is currently offline (0% uptime) — that's expected at this early stage, not a sign the project stalled. Following along and feedback from anyone interested in this kind of PvP-first server are very welcome.   Website: l2berserk.fun

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..