Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--

[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

Link to comment
Share on other sites
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 ;)

Link to comment
Share on other sites
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 :)

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing


  • Posts

    • Nefalem
      WIP Free Assasins Interface for Interlude

      By Nefalem · Posted

      a beautiful response from a liar who is not even a man to admit it, at least it is recorded here that you are nothing more than a thief, this is your character as a person, which I hope one day you will have the courage and apologize to whoever you stole from, which I don't even need to talk about anymore, you know very well who you stole each job from, here I end the attacks, because someone deserved to come here and unmask you to the l2 community.
    • Vraekar
      WIP Free Assasins Interface for Interlude

      By Vraekar · Posted

      Yes Sir. Of course Sir, you know everything, Sir. If you said so, Sir. What about asking your "friends" where they get it they patch from? Kappa
    • Nefalem
      WIP Free Assasins Interface for Interlude

      By Nefalem · Posted

      Let's make one thing clear here, you don't have a patch/rev, what you have is a complete theft of codes, and if you are a real man, admit it, because my BR friends know very well that you are known for being the so-called interface copy/paste, because you don't create anything, you take advantage of years of work from people and steal it and sell it and you have the courage to talk about my patch, be ashamed of yourself.
    • Vraekar
      WIP Free Assasins Interface for Interlude

      By Vraekar · Posted

      i dont know why im the topic here if this is not even my patch, it seems you love me, even know my whole story... xd but good old times when we would EXCHANGE stuff betwen our selfs to make interfaces to our usage and likening... never talked to much with OMGz, but seems like a good guy   good old times when was all just having fun and editing stuff and playing, today is all about clout and money, i have that u dont hahahah   they will never come back..   i already left anything beside long time ago idk why think on me too much, just want to enjoy my free time to play some games and have fun.. but looks like somehow find a way to relate me to something, maybe you think on me to much idk, kinda weird.. unfortunately, you are looking at this code thinking that  "oh it has his name and abreviation, its from him" but i must say its not... i dont need to stay here saying that this and that happened, because i know very well that you know exactly what happened... peace for all PS: and.. my main language is pt br, not spanish like in the src...
    • KejbL
      WIP Free Assasins Interface for Interlude

      By KejbL · Posted

      Hi, i copy patch from L2acdc but have problem with 2 things... HP indicator, target animation... some1 know fix it ? i think need edit .dll files for it. Or its working it here in this patch ? thx    

  • Topics

×
×
  • Create New...