Jump to content
MaxCheaters Official Group on Discord
-> Place your ad text here <-
We're Rebuilding – Join Our Staff Team

[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

jossoo Newbie

jossoo

Posted
Posted

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

 

where u found them ?

 

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

    • GX-Ext
      🌟 [RELEASE] Full Lineage 2 C4 Accumulative

      By GX-Ext · Posted

      Stop paying for files that are already public and free. Here you can download a fully working Interlude server with C4-like gameplay, including source code so you can compile it yourself and verify everything. People will try to convince you that free releases are “broken”, “full of backdoors”, etc. That’s exactly why I’m also providing the SVN with the full source – so you can: Review the code yourself Remove / modify whatever you don’t like Compile your own binaries What’s included GX-EXT Interlude server (C4-style gameplay) – L2Off Client Interlude tweaked for C4 gameplay Public SVN with source code Downloads: Server GX-EXT: https://www.mediafire.com/file/aktanlwyuqc9jsa/L2OFF_C4_C4_ACU_GXEXT.rar/file Client Interlude C4 Gameplay: https://www.mediafire.com/file/5iaosvnwspbuky4/Cliente_Interlude_Jugabilidad_C4.rar/file SVN (source code, delayed a couple of months to avoid reselling fresh work): https://svn.l2servers.com.ar/!/#GX-EXT_INTERLUDE User: gx Pass: gx How to compile To compile the source you will need: Visual Studio 2005 (x64 toolset) (Classic L2Off toolchain – yes, it’s old, but that’s what the original server uses.) Use this as you want: learn, test, open your own server, or just audit the code. But please, stop buying the same leaked/resold files over and over when you can get them here for free, with source, and actually know what you’re running.  
    • paparas22
      🌟 [RELEASE] Full Lineage 2 C4 Accumulative

      By paparas22 · Posted

      @GX-Ext Please reupload the pack+web+client because all the links inside that post or in the https://l2servers.com.ar/ are dead
    • Atom
      Help hero glow on weapons

      By Atom · Posted

      Weapon dat is not the same for all, since you have custom things for sure no. You can contact @NevesOma
    • DarkPL
      Help hero glow on weapons

      By DarkPL · Posted

      hello guys im facing a problem with the weapons .. i want to add hero glow on s weapons arcana ,dragonic bow etc.. some weapons are work peftect .. some not for example i add the line  LineageEffect.e_u092_h for fists and didnt work didnt even get the hero glow.. and the arcana the glow is on the top of weapon not down side like hero zeus mace any ideas?.. or does anybody has the weapongrp.dat file ready ?
    • vNShh
      VIDEO EDITING SERVICES, GRAPHICS FOR YOUR PROJECT

      By vNShh · Posted

      UP

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock