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

[share] Handy SQL Updates

DragonHunter
 Share

Recommended Posts

DragonHunter Newbie

DragonHunter

Posted
Posted

I hope you like it :)

 

Credits is going to DragonHunter because I wrote them self

 

 

No Weight Limit

UPDATE armor SET weight=0;
UPDATE etcitem SET weight=0;
UPDATE weapon SET weight=0;
UPDATE custom_armor SET weight=0;
UPDATE custom_etcitem SET weight=0;
UPDATE custom_weapon SET weight=0;

 

 

Customize your guards

UPDATE npc SET level='85' where type='L2Guard';
UPDATE npc SET hp='30000' where type='L2Guard';
UPDATE npc SET mp='30000' where type='L2Guard';
UPDATE npc SET patk='30000' where type='L2Guard';
UPDATE npc SET pdef='10000' where type='L2Guard';
UPDATE npc SET mdef='10000' where type='L2Guard';
UPDATE npc SET title='Customized Guard' where type='L2Guard';
UPDATE npc SET serverSideTitle='1' where type='L2Guard';
UPDATE npc SET serverSideTitle='1' where type='L2Guard';
UPDATE npc SET rhand='0' where type='L2Guard';
UPDATE npc SET lhand='0' where type='L2Guard';
UPDATE npc SET runspd='300' where type='L2Guard';
UPDATE npc SET ss='1' where type='L2Guard';
UPDATE npc SET bss='1' where type='L2Guard';
UPDATE npc SET ss_rate='100' where type='L2Guard';
UPDATE npc SET attackrange='100' where type='L2Guard';
UPDATE npc SET aggro='5000' where type='L2Guard';
UPDATE npc SET str='100' where type='L2Guard';
UPDATE npc SET con='100' where type='L2Guard';
UPDATE npc SET dex='100' where type='L2Guard';
UPDATE npc SET wit='100' where type='L2Guard';
UPDATE npc SET men='100' where type='L2Guard';
UPDATE npc SET str='100' where type='L2Guard';

 

 

Make mobs stronger

UPDATE npc SET level='85' where id='******';
UPDATE npc SET aggro='200' where id='******';
UPDATE `npc` SET `patk` = `patk` * 3 where id='******'; -- 3x the P.Atk
UPDATE `npc` SET `matk` = `matk` * 2 where id='******'; -- 3x the M.Atk

by Monster Type:
-- This is maybe not handy because every mob in the game will have these settings!
-- Even level 1 mobs :P
UPDATE npc SET level='85' where type='L2Monster';
UPDATE npc SET aggro='200' where type='L2Monster';
UPDATE `npc` SET `hp` = `hp` * 2 where type='L2Monster'; -- 2x the HP
UPDATE `npc` SET `patk` = `patk` * 3 where type='L2Monster'; -- 3x the P.Atk
UPDATE `npc` SET `matk` = `matk` * 2 where type='L2Monster'; -- 3x the M.Atk

 

 

Automatic Server Restart:

INSERT INTO global_tasks(task,type,last_activation,param1,param2,param3) VALUES 
('restart', 'TYPE_GLOBAL_TASK', '2147483647', '1', '00:00:00', '300'); -- At 00:00 in the night he will do a server restart players will have 5 minutes to logout

INSERT INTO global_tasks(task,type,last_activation,param1,param2,param3) VALUES 
('restart', 'TYPE_GLOBAL_TASK', '2147483647', '1', '12:00:00', '300');-- At 12:00 in the midday he will do a server restart players will have 5 minutes to logout

 

 

Make all Raidbosses stronger:

-- Baium
UPDATE npc SET level='85' where id='29020';
UPDATE npc SET title='Improved Raid' where id='29020';
UPDATE npc SET serverSideTitle='1' where id='29020';
UPDATE npc SET aggro='1000' where id='29020';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29020';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29020';

-- Zaken
UPDATE npc SET level='85' where id='29022';
UPDATE npc SET title='Improved Raid' where id='29022';
UPDATE npc SET serverSideTitle='1' where id='29022';
UPDATE npc SET aggro='1000' where id='29022';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29022';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29022';

-- Queen Ant
UPDATE npc SET level='85' where id='29001';
UPDATE npc SET title='Improved Raid' where id='2901';
UPDATE npc SET serverSideTitle='1' where id='29001';
UPDATE npc SET aggro='1000' where id='29001';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29001';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29001';

-- Core
UPDATE npc SET level='85' where id='29006';
UPDATE npc SET title='Improved Raid' where id='29006';
UPDATE npc SET serverSideTitle='1' where id='29006';
UPDATE npc SET aggro='1000' where id='29006';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29006';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29006';


-- Orfen
UPDATE npc SET level='85' where id='29014';
UPDATE npc SET title='Improved Raid' where id='29014';
UPDATE npc SET serverSideTitle='1' where id='29014';
UPDATE npc SET aggro='1000' where id='29014';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29014';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29014';

-- Antharas
UPDATE npc SET level='85' where id='29019';
UPDATE npc SET title='Improved Raid' where id='29019';
UPDATE npc SET serverSideTitle='1' where id='29019';
UPDATE npc SET aggro='1000' where id='29019';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29019';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29019';

-- Valakas
UPDATE npc SET level='85' where id='29028';
UPDATE npc SET title='Improved Raid' where id='29028';
UPDATE npc SET serverSideTitle='1' where id='29028';
UPDATE npc SET aggro='1000' where id='29028';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29028';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29028';

-- Frintezza
UPDATE npc SET level='85' where id='29045';
UPDATE npc SET title='Improved Raid' where id='29045';
UPDATE npc SET serverSideTitle='1' where id='29045';
UPDATE npc SET aggro='0' where id='29045'; -- 0 = Retail... I think
UPDATE `npc` SET `patk` = `patk` * 3 where id='29045';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29045';

-- Scarlet van Halisha - Transformation 1
UPDATE npc SET level='85' where id='29046';
UPDATE npc SET title='Improved Raid' where id='29046';
UPDATE npc SET serverSideTitle='1' where id='29046';
UPDATE npc SET aggro='1000' where id='29046';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29046';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29046';

-- Scarlet van Halisha - Transformation 2
UPDATE npc SET level='85' where id='29047';
UPDATE npc SET title='Improved Raid' where id='29047';
UPDATE npc SET serverSideTitle='1' where id='29047';
UPDATE npc SET aggro='1000' where id='29047';
UPDATE `npc` SET `patk` = `patk` * 3 where id='29047';
UPDATE `npc` SET `matk` = `matk` * 2 where id='29047';

 

Ban Account IP:

UPDATE accounts SET accessLevel=-100 where lastIP='IP HERE';

 

Un-Ban all IP's and players

UPDATE accounts SET accessLevel=0 where accesslevel=-100;
UPDATE characters SET accesslevel=0 where accesslevel=-100;

 

Delete an Item from the players inventory:

-- Only use this when something realy wrong is going on because in every inventory this item will be deleted!
DELETE FROM items WHERE item_id = 'ITEM ID';

 

 

Remove skills from the skill tree:

DELETE FROM skill_trees WHERE skill_id = '****';

 

Remove all the monument of heroes:

DELETE FROM spawnlist WHERE npc_templateid = '31690';

 

Make the raidbosses easier

-- Baium
UPDATE `npc` SET `hp` = `hp` / 2 where id='29020';
-- Zaken
UPDATE `npc` SET `hp` = `hp` / 2 where id='29022';
-- Queen Ant
UPDATE `npc` SET `hp` = `hp` / 2 where id='29001';
-- Core
UPDATE `npc` SET `hp` = `hp` / 2 where id='29006';
-- Orfen
UPDATE `npc` SET `hp` = `hp` / 2 where id='29014';
-- Antharas
UPDATE `npc` SET `hp` = `hp` / 2 where id='29019';
-- Valakas
UPDATE `npc` SET `hp` = `hp` / 2 where id='29028';
-- Frintezza
UPDATE `npc` SET `hp` = `hp` / 2 where id='29045';
-- Scarlet van Halisha - Transformation 1
UPDATE `npc` SET `hp` = `hp` / 2 where id='29046';
-- Scarlet van Halisha - Transformation 2
UPDATE `npc` SET `hp` = `hp` / 2 where id='29047';

 

 

Remove all the heroes stats (L2 Emu)

UPDATE characters_custom_data SET hero='0' where hero='1';

 

 

Remove the XP/SP for skill enchants

UPDATE enchant_skill_trees SET sp=0;
UPDATE enchant_skill_trees SET exp=0;

 

 

Un-Jail all the players

UPDATE characters SET in_jail='0';
UPDATE characters SET jail_timer='0';

 

 

Make all the pets stronger

-- This could be handy for a high-rate server with custom items
-- It will make the pets 50% stronger
UPDATE `npc` SET `hp` = `hp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mp` = `mp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `patk` = `patk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `matk` = `matk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `pdef` = `pdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mdef` = `mdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `runspd` = `runspd` * 1.5 where type='L2Pet';

 

 

If you want to remove the mobs between a level of...10 - 60 (Its long time ago but I think around level 10-60 mobs)

This can highly improve your server load time

Use it for high-rate servers

 

www.wde.wargodsnetwork.com/delete not used mobs.zip

DragonHunter Newbie

DragonHunter

Posted
  • Author
Posted

OMAGAD nice [share][guide]i hink its is....very nice man some  of them they are really helpfull

 

where u found them ?

 

 

I wrote them self, Learning some SQL is handy for a server admin ;)

Chandy Newbie

Chandy

Posted
Posted

nice 1 DragonHunter thx.

U can add initial itens in the inventory plz.

here's a custom initial itens,but i need to put items in inventory like tutorial book:

-- this sql updates db to make diff intial items.
update char_templates set `items1`=  24 where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter'); -- chest/ bone breast plate
update char_templates set `items2`=  31 where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter'); --  legs/ bone gaiters
update char_templates set `items3`= 219 where  `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter'); --  sword breaker
update char_templates set `items4`=  44  where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter');-- leather helmet
update char_templates set `items5`= 38  where `ClassName` in ( 'Human Fighter','Elf Fighter','DE Fighter','Orc Fighter','Dwarf Fighter');--  low boots

update char_templates set `items1`=  430 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage'); --robe of evotion, 
update char_templates set `items2`=  1104 where `ClassName`  in ('Human Mage','Elf Mage','DE Mage','Orc Mage'); -- stocking of devotion 
update char_templates set `items3`=  100 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage');  --vood do dool 
update char_templates set `items4`=  49 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage');  -- gloves
update char_templates set `items5`=  44 where `ClassName` in ('Human Mage','Elf Mage','DE Mage','Orc Mage');-- leather helmet

You can add this please?

Thx in advanced :)

Guest
This topic is now closed to further replies.
 Share
Go to topic listing


  • Posts

    • Traumann
      [DESIGN SERVICES] LOGOS | WEBS | LAUNCHERS | ETC

      By Traumann · Posted

      I ended up sorting a similar mess by working with a team that handled everything from discovery to launch and kept things super clear. Their business website design approach made it easy for me to get a site that actually fit my goals, plus I kept full ownership of everything. The long-term support and simple pricing structure saved me a ton of headaches down the road.
    • eMommy
      Interface P447

      By eMommy · Posted

      Interface sources for P447 (7s update) for Classic/Essence   NWindow + InterfaceClassic + L2Editor + L2ClientDat Mobius + XDat Editor   Download
    • ArezG
      Interlude - classic server and client files help

      By ArezG · Posted

      Hey there, welcome to the community – no worries about being new, we all started exactly where you are. Let me break this down based on what you’re trying to achieve with your Interlude‑Classic idea.   What you’re describing is actually a pretty popular concept: basically Interlude gameplay and balance, but with Classic‑style UI and a cleaner overall user experience. A “hybrid client”, not a full chronicle change.   Projects that have done something similar or are worth studying:   Lucera 2 – You’re right about this one. They use a custom client that blends Interlude gameplay with a more modern/Classic‑like interface. Their UI work (inventory, skill bar, lobby, etc.) is a good reference point.   L2J Mobius – Not exactly your target, but it’s very flexible and has a lot of examples of customizations and adaptations between chronicles.   Smaller custom projects – There are (or were) a few hybrid attempts using Interlude server files with heavily modified clients, but most are private or closed‑source, so you mainly get ideas, not ready‑to-use files.   Where the real challenge is (the client side):   What you want is possible, but the heavy lifting is on the client, not the server. The main pain points usually are:   Making sure interface files are compatible between chronicles (UI textures, layouts, systemmsg, etc.).   L2Font and localization edits: titles, chat, system messages – a small mistake here can break visuals or cause weird text issues.   Character selection / lobby screens: if you take them from another chronicle, you have to adapt them carefully so they don’t conflict with Interlude data.   Inventory, status bars and shortcuts: they must still work with Interlude’s item/skill structure and packet format, or you’ll get visual desyncs and client errors.   About multi‑protocol:   You’re correct that multi‑protocol is often used by projects that want to support different client versions or custom blends. In your case, it can help “talk” properly with a customized client while keeping an Interlude base server. It doesn’t magically fix everything, but it gives you more flexibility on how client and server exchange data.   Quick chronicle breakdown (relevant for your idea):   2.0–2.6: Early, simpler mechanics, good base for old‑school vibes.   2.7: More skills and better balance, often used as a base for custom projects.   2.9.5: A “bridge” between old and new, very common choice for hybrid or heavily modded setups.   3.0+: Adds Kamael and systems you said you don’t want, so you’d mainly use it as a reference, not as a direct base.   My honest recommendation:   Start from a solid Interlude base (files you understand and can actually maintain). Interlude still has the most support, tools and community knowledge.   Focus first on UI/interface modifications instead of trying to change core mechanics. Use Lucera‑style clients and similar projects as visual/technical reference.   Consider a multi‑protocol setup only after you’re comfortable with a normal Interlude client; otherwise you’ll just stack complexity.   Join active L2J / client‑mod Discords and forums. There are specific channels for interface, system edits and client reverse‑engineering where people share tips and tools.   What I would avoid at the beginning:   No intentar mezclar tres o cuatro chronicles a la vez; con uno bien entendido + UI custom ya tienes más que suficiente trabajo.   No subestimar la parte de cliente; muchas veces es más complicada y más frágil que el lado del servidor.   No saltarte el testeo en entorno local; los híbridos rompen cosas pequeñas (tooltips raros, skills que crashean el cliente, UI bugueada) si no pruebas bien.   Resources worth checking:   L2J forums and old MaxCheaters threads about faction/hybrid servers and client mods.   GitHub repos with client tools and interface mods (even si no son exactamente tu chronicle, te sirven como ejemplo).   Discord communities focused on L2 client development; ahí es donde se mueve hoy la parte “seria” del modding.   The good news: what you want is achievable, just not “plug & play”. It will require patience, testing and a bit of learning on both server and client sides. If you share exactly which files/pack you’re planning to use and what you want your UI to look like, people here (me included) can give you more concrete, step‑by‑step advice.
    • ArezG
      The Brutal Truth About Lineage 2 That Will Make You Ragequit

      By ArezG · Posted

      I’m done with Lineage 2. Not because I “grew up”, not because I “don’t have time for games” anymore, but because this game has slowly turned into everything it was supposed to be against.   Let’s be honest: most people are not playing Lineage 2 anymore. They are running 5–10 boxes, macros and scripts, setting up their characters and going to watch Netflix. The core loop isn’t PvP, clan wars or raids – it’s AFK grinding and praying your gear upgrades don’t fail.   The game used to be about outplaying your enemy with positioning, timing and coordination. Now it’s about:   Who has more boxes logged in.   Who is willing to swipe the credit card harder.   Who abuses the most broken script, cheat or exploit before it gets “patched”.   And let’s talk about pay‑to‑win. You can pretend it’s “supporting the server” all you want, but when someone can buy power that takes others months (or is literally impossible) to reach, that’s not support, that’s buying victories. When top players are just walking credit cards with epics, donations and event gear, you don’t have competition, you have a spending contest.   The community? It’s just as bad. Most “friends” are temporary party members until they find a better CP, clan or donation package. Drama, backstabbing, ninja looting, clan leaders selling clan resources, spies in Discord – it’s more like a cheap political simulator than an MMO. People talk about “honor” and “fair play”, then log their 10th box, run radar and target through walls.   And private servers… So many promises: “long‑term project”, “no corruption”, “no over‑enchant items”, “balanced gameplay”. Then after a few weeks you see:   Admin friends with full gear “testing”.   Hidden donations or “special offers” for “supporters”.   GMs closing their eyes to obvious abuse because it’s their buddies or biggest donors. Every wipe and every “fresh start” is just another cycle of the same lie, and we all pretend “this time will be different”.   The saddest part? Most of us know all this and still keep coming back because Lineage 2 has an insane core – the world, the classes, the adrenaline of real PvP, the politics, the sieges. But that core is buried under layers of greed, abuse, bots, scripts, egos and fake promises.   So here is the brutal truth: Lineage 2 is not a hardcore competitive MMORPG anymore. It’s a casino disguised as nostalgia, kept alive by whales, box armies and people too addicted or too hopeful to finally let go.   If you’re still playing, ask yourself honestly: Are you having fun, or are you just grinding, coping and praying that “next server” will finally be the one that isn’t corrupt, pay‑to‑win or dead in three months?   For me, I’m out. Flame me, defend the game, call me salty – I don’t care. But deep down, most of you know I’m not lying.
    • VPSLab
      — VPSLAB — Fast & Private RDP/VPS | 100% Instant Setup

      By VPSLab · Posted

      Active & Taking Orders!

  • 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..