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 Iron Initiate

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 Iron Initiate

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 Iron Initiate

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

    • RMTgold
      Buying & Selling POE & POE2 Divine-Mirrors

      By RMTgold · Posted

      PAYPAL& BINANCE
    • RMTgold
      Buying & Selling Torn City Cash

      By RMTgold · Posted

      PAYPAL& BINANCE
    • aguy
      Unofficial fantasy lore and stories from Aden continent

      By aguy · Posted

      I decided to write some beautiful custom fantasy stories about the beautiful world of Lineage 2 and its oldschool territories. Fictional theme, not related to the real lore of Lineage 2. Besides, everyone has read the real ones. Whenever I have a new story I will post. So without further delay:   The Boat Blessed by Einhasad (Story written by me, proof-reading only by AI) Part 1: The Stranger and Einhasad One beautiful morning, Orcis the clan leader and Chapan, the beautiful female bishop, were sitting in Giran Harbor waiting for the boat. "I have a feeling that this will be a great day, beautiful lady," Orcis told Chapan. The boat arrived, and on top of it stood a stranger. "Ahoy, fellas!" he called out, giving them a high five. "Ahoy... stranger," replied Chapan. "What brings you to this boat?" asked the stranger. "We want to travel the world," said Chapan. "And we want to conquer it all," added Orcis. The stranger looked at them both and said, "I'm in a good mood today, so I will share something with you. Einhasad came to me yesterday and gave me wisdom—wisdom that will let you explore and allow you to conquer. Here, let me show you." The stranger stepped off the boat. Then he stepped back on. He lifted his right foot to step off again, but he didn't; he only pretended to, stepping right back onto the boat instead. He repeated the motion with his right foot again and again. Orcis and Chapan laughed, but the ferryman was furious. "Why are you pretending to disembark while staying on the boat?" shouted the ferryman. "Stop being a fool and either stay on or off! You're making me dizzy acting like a clown!" The stranger stepped off the boat. As he was escorted away from the furious ferryman, he whispered to Chapan, "You can do this dance too. It's funny—try it." As the ferryman and the stranger walked away, Orcis and Chapan started doing the foolish move. They stepped onto the boat, pretended to return to shore, only to place their foot back on the boat at the last moment. They did it many times and had great fun. As they were playing through this crazy dance routine on the boat, something magical happened: Einhasad appeared in front of them. "I see you have found wisdom," Einhasad said. "I will allow you your wisdom, but you are never to step on the boat more than 127 times. And you must never go to the man who lives forever alone on the Primeval Isle, for he can see through your dance and will not like it." Einhasad vanished, the boat departed, and our comedic duo continued their journey... Part 2: The Greatest Healer and the Castle Lord Two days later, a boat arrived at Rune Harbor. Off it stepped an orc and a healer. "You take the town, lady—find a mercenary to help you. I will go take the castle," said the orc. A couple of minutes later, the lone orc appeared at a siege-battered castle. The defenders were repairing the fortress after successfully repelling an attacking force. They saw the orc walking toward the castle with small, steady steps and laughed at him. "Who dares walk against the mightiest clan alone?" The orc continued on his path until he was close to the defenders. Bows were armed; swords were unsheathed. The defenders lunged at the orc, only to find it impossible to hit him. Their weapons could not touch his skin or armor and were instantly repelled. They chased behind the orc, who proceeded into the engraving room and began commune with the artifact, all while the defenders tried in vain to slash and blunt him. Nothing landed—not a single blow. The orc was casting as peacefully as if he were in town, completely uninterrupted. "Masters, masters!" a voice shouted. "I bring bad news from the city! There is a female healer—she came with an orc and a mercenary. They killed the guards, wiped out our force, and took over the city!" "How could that be?" said the castle masters, momentarily forgetting that an orc was actively taking their castle. "The healer, masters! The healer—she can't be killed! Our swords slip right off her armor!" Before they could respond, the engraving completed. "I am now your master, your voice, your ruler," the orc declared. "Bow before me, for I am blessed by Einhasad and I am immortal!" Part 3: The Sanctuary of Primeval Isle Three days later, a female human healer stepped off the boat onto Primeval Isle. She had fool-stepped on the boat 126 times now, taking care never to exceed 127—for as Einhasad had warned, doing so would make her mortal again. "I seek the ruler of this island, for he is to bow before me," she announced. Suddenly, an arrow flew through the dense foliage of Primeval Isle. It pierced straight through the healer's armor and crushed her to the ground. As her eyes closed in her final moments, she heard the voice of Einhasad echo the old warning given to them days ago: "Primeval Isle is sacred. The man who lives there forever has made it so—for I might not have given him wisdom, but I have given him luck." The End   The Man at Primeval Isle Word reached the newly crowned King of the Aden territory—Orcis the Orc—about the tragic end of his beloved Chapan, who had dared to set foot upon the fog-shrouded shores of Primeval Isle. A thousand bards sang in the grand halls, yet not a single melody could soothe the sovereign's profound rage and grief. Days bled into weeks. The court watched their ruler wither in inconsolable silence, until a lone traveler requested an audience at the castle gates. "My Lord," the captain of the guard announced, kneeling before the throne. "A wanderer demands entry. He claims to hold the key to the island." "The island?" Orcis grunted, his voice like grinding stone. "He speaks of a way to walk upon those cursed sands untouched by mortality... and to face the solitary warden who governs the primeval wild." "Bring him in," ordered the King. When the stranger approached the dais, Orcis instantly recognized the weathered face. It was the enigmatic figure from Giran Harbor—the nomad who had first taught them the strange ritual of steps that granted them divine immunity. The wanderer bowed low, but Orcis raised a hand. "Rise, old friend. This kingdom was forged on the strange wisdom you shared. Speak. What do you know of the island’s master?" The stranger leaned in, his eyes gleaming with secret knowledge. "The warden believes his sanctuary is absolute, my King—that the ancient currents protecting his domain cannot be broken by the dance of the harbor," the stranger whispered. "Yet in his pride, he misjudged the rhythm of the crossing. He guards against those who linger in the threshold...   ... but he never foresaw what happens when the voyage comes to its absolute end."
    • Dragic
      Buy server files interlude

      By Dragic · Posted

      You have pm.
    • Celestine
      unpacket system protocol 140

      By Celestine · Posted

      @AlisaCodeDragon

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