Jump to content
The Best Lineage 2 Mods – Free & Custom
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team

Usefull Sql Scripts !

badriniki

By badriniki
in Server Shares & Files [L2J]

 Share

Recommended Posts

badriniki Newbie

badriniki

Posted
Posted

Hi everyone,

here is some usefull SQL scripts (examples, you can edit them whatever you want) !

 

[glow=green,2,300]Thx to badriniki[/glow]

0 Weight for items/armors/weapons:

UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id);

UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id);

UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id);

 

Drop Adena 100%:

UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';

 

When you sell, everything will cost 0 adena:

UPDATE `armor` SET price=0 where price > 1;

UPDATE `etcitem` SET price=0 where price > 1;

UPDATE `weapon` SET price=0 where price > 1;

 

Update all RaidBoss 5000k hp:

UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss';

 

Delete all mobs under 40 lvl:

DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster';

 

Delete all materials and recipes from db:

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );

 

Increase drop rate for recipes:

UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe');

 

Delete characters and accounts if they do not connect for 3 months:

DELETE FROM characters WHERE lastAccess < 466560000;

DELETE FROM accounts WHERE lastactive < 466560000;

 

Add for all monsters in drop: Coins

insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster';

 

Top No-Grade in start:(Need to modif for kamaels)

REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);

REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588);

REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588);

REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588);

REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588);

REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);

REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588);

REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588);

REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);

 

Add RaidBoss jewels if you have deleted them:

INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000');

INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000');

INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000');

INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000');

INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');

INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000');

INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');

 

[glow=green,2,300]Thx to 1tm[/glow]

Delete all spellbooks from db:

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );

 

Increases Guards (p.def, m.def, p.atk, hp) by 50%:

UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard';

 

Decreases Raidboss defense by 40%:

UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss';

 

All new player chars spawn loc:

UPDATE char_templates SET x=yourXcoordinate;
UPDATE char_templates SET y=yourYcoordinate;
UPDATE char_templates SET z=yourZcoordinate;

 

Increases all chars p.def/m.def by 10%:

UPDATE char_templates SET P_DEF = P_DEF * 1.1;
UPDATE char_templates SET M_DEF = M_DEF * 1.1;

 

Increases all chars speed by 20%:

UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;

 

Increases all chars CP. At 20lv by 22%, at 40lv by 44%, at 76lv by 66%:

This one good one for longer pvps..

UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20';

 

MP rengerates 10 times more(unlimited mp):

Good one for high servers who has mp potions etc..

UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;

 

Teleports cost 0 adena:

UPDATE teleport SET price=0;

 

Create common item skill delete:

It used as bug at olympiad, with it you can buff with soes, mental dagers etc in secs...

DELETE FROM skill_trees WHERE skill_id = 1320;
DELETE FROM skill_trees WHERE skill_id = 1322;

 

Grade penality delete:

Disables grade penality...

DELETE FROM skill_trees WHERE skill_id = 239;

 

Raidbosses always spawns with 70% hp:

More realistic that new spawned rb has not full hp. Good one for organized clans or parties...

UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;

 

Dies adding price reduced to 5 adena (or increased to 100kk):

Good one for faction servers.

UPDATE henna SET price=5;

..or to 100kk (good one for high rates servers).

UPDATE henna SET price=100000000;

 

Newbie npc buffer buffes all buffs from 1lv to 62lv:

Really use full newbie characters to have all buffs from 1lv (if yuo want U may change upper level to 85, for daily bufer).

UPDATE helper_buff_list SET lower_level=1;
UPDATE helper_buff_list SET upper_level=62;

 

To enchant skill doesn't need exp/sp:

Good one for high rates servers or faction servers..

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

 

Auto server restart:

Every week..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360");

Every two days..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360");

Every 24h..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");

Every 12h..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360");

Every 6h..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");

Every 3h..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");

 

[glow=green,2,300]Thx to lekino[/glow]

Custom Spawn in Giran Castle Town & items.(For Fighters Theca Leather Armor Set and Crystal Dagger .For Mystics Karmian Robe Set and Homunkulus's Sword)

UPDATE `char_templates` SET `x` = '83400',
`y` = '147943',
`z` = '-3404';
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =0 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =18 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =31 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =44 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =53 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =10 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =25 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =38 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =49 LIMIT 1 ;

 

Hope this will help you a little ;)

t0p3a Newbie

t0p3a

Posted
Posted

top non-grade sql script its not working for me

 

[Err] 1136 - Column count doesn't match value count at row 1
[Err] REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
[Msg] Finished - Unsuccessfully

 

any idea?

1tm Newbie

1tm

Posted
Posted

top non-grade sql script its not working for me

 

[Err] 1136 - Column count doesn't match value count at row 1
[Err] REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
[Msg] Finished - Unsuccessfully

 

any idea?

I think that script doesn't work for l2jserver, be cuz of it's has char_creation_items.sql.. so try use this one:

 

Wooden/Devotion set, best non weapons, soulshots pack, extra gloves/boots in start:

 

UPDATE char_creation_items SET itemId='736' WHERE itemId = 12753; 
-- kamael soe for simple soe (x10)


UPDATE char_creation_items SET itemId='219' WHERE itemId = 10; 
-- starting dagger for Sword Breaker
UPDATE char_creation_items SET itemId='311' WHERE itemId = 6; 
-- starting wand for Crucifix of Blessing
UPDATE char_creation_items SET itemId='68' WHERE itemId = 2369; 
-- starting sword for Falchion
UPDATE char_creation_items SET itemId='257' WHERE itemId = 2368; 
-- starting fists for Viper Fang
UPDATE char_creation_items SET itemId='155' WHERE itemId = 2370; 
-- starting fists for Flanged Mace


UPDATE char_creation_items SET itemId='1101' WHERE itemId = 425; 
-- starting mystics armor for Devotion armor
UPDATE char_creation_items SET itemId='1104' WHERE itemId = 461; 
-- starting mystics armor for Devotion armor

UPDATE char_creation_items SET itemId='23' WHERE itemId = 1146; 
-- starting fifghers armor for Wooden armor
UPDATE char_creation_items SET itemId='2386' WHERE itemId = 1147; 
-- starting fifghers armor for Wooden armor


INSERT INTO char_creation_items VALUES (0,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (18,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (31,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (44,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (53,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (123,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (124,43,1,'true'); 
-- Wooden set helm

INSERT INTO char_creation_items VALUES (10,44,1,'true'); 
-- Devotion set helm
INSERT INTO char_creation_items VALUES (25,44,1,'true'); 
-- Devotion set helm
INSERT INTO char_creation_items VALUES (38,44,1,'true'); 
-- Devotion set helm
INSERT INTO char_creation_items VALUES (49,44,1,'true'); 
-- Devotion set helm


INSERT INTO char_creation_items VALUES (0,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (18,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (31,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (44,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (53,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (123,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (124,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (10,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (25,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (38,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (49,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)


INSERT INTO char_creation_items VALUES (0,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (18,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (31,51,1,'true'); 
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (44,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (53,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (123,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (124,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (10,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (25,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (38,51,1,'true'); 
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (49,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)


INSERT INTO char_creation_items VALUES (0,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (18,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (31,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (44,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (53,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (123,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (124,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (10,5262,1,'false'); 
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (25,5262,1,'false'); 
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (38,5262,1,'false'); 
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (49,5262,1,'false'); 
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)

I suggest to change want you doesn't want, for example at notepad change(ctrl+h) "squeaking shoes" for "Boots": change all "5590"  to "39" id items...  ;D

1tm Newbie

1tm

Posted
Posted

Delete all spellbooks from db:

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );

 

Increases Guards (p.def, m.def, p.atk, hp) by 50%:

UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard';

 

Decreases Raidboss defense by 40%:

UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss';

 

All new player chars spawn loc:

UPDATE char_templates SET x=yourXcoordinate;
UPDATE char_templates SET y=yourYcoordinate;
UPDATE char_templates SET z=yourZcoordinate;

 

Increases all chars p.def/m.def by 10%:

UPDATE char_templates SET P_DEF = P_DEF * 1.1;
UPDATE char_templates SET M_DEF = M_DEF * 1.1;

 

Increases all chars speed by 20%:

UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;

 

 

Increases all chars CP. At 20lv by 22%, at 40lv by 44%, at 76lv by 66%:

This one good one for longer pvps..

UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20';

 

MP rengerates 10 times more(unlimited mp):

Good one for high servers who has mp potions etc..

UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;

 

Teleports cost 0 adena:

UPDATE teleport SET price=0;

 

1tm Newbie

1tm

Posted
Posted

Create common item skill delete:

It used as bug at olympiad, with it you can buff with soes, mental dagers etc in secs...

DELETE FROM skill_trees WHERE skill_id = 1320;
DELETE FROM skill_trees WHERE skill_id = 1322;

 

Grade penality delete:

Disables grade penality...

DELETE FROM skill_trees WHERE skill_id = 239;

 

Raidbosses always spawns with 70% hp:

More realistic that new spawned rb has not full hp. Good one for organized clans or parties...

UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;

 

Dies adding price reduced to 5 adena (or increased to 100kk):

Good one for faction servers.

UPDATE henna SET price=5;

..or to 100kk (good one for high rates servers).

UPDATE henna SET price=100000000;

 

Newbie npc buffer buffes all buffs from 1lv to 62lv:

Really use full newbie characters to have all buffs from 1lv (if yuo want U may change upper level to 85, for daily bufer).

UPDATE helper_buff_list SET lower_level=1;
UPDATE helper_buff_list SET upper_level=62;

 

To enchant skill doesn't need exp/sp:

Good one for high rates servers or faction servers..

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

 

Auto server restart:

Every week..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360");

Every two days..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360");

Every 24h..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");

Every 12h..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360");

Every 6h..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");

Every 3h..

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");

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

    • Cygnus
      [L2J] L2 Cygnus

      By Cygnus · Posted

      --- Interlude Faction/GvE PvP grand opening 2025-11-15 19:00 GMT+2 ---   Gameplay: Chronicle: Interlude Type: Faction/GvE (Angels vs Nature vs Demons) GM Shop: B-S grade Buff slots: 20+4 Starting level: 74 + rebirth system   New Features: Client: Modern interface based on Essence Balance: New class skills for better balance Achievement Rewards: Daily, Weekly, One-time TOP rankings: PvP, Event PvP, Map PvP, Clan PvP, Event MvP, Map MvP Zones: 70 different PvP zones,  18 different events (8 map events | 10 main events) 12 Grand/raid bosses. Castle siege Olympiad Clan Hall challenge Custom Enchant System: Dynamic success chance (greater enchant level or item grade less enchanting success chance) Enchant rate: Blessed scrolls dynamic from 100% to 25%. Crystal Scrolls: 100%; Max enchant weapon +12 Max enchant armor +8 Safe point enchant system Extra Features: PvP items with level upgrade Weapon/Armor upgrade (from B grade to S) system Attributes system   Website: https://l2cygnus.com Community: Discord Facebook: https://www.facebook.com/l2cygnus Youtube:   
    • 4TOP
      L2J4Team - Oath of Blood C5

      By 4TOP · Posted

      More fluid combat, not 100% yet, but I think it's acceptable. I put the following logic in movetopawn, moveto, maybemovetopawn, validatelocation, movetolocation: If Config.GeoData is active, it applies the coordinates using geodata; if disabled, use setdistanceplansq to measure the distance of things! Fix for reflected damage (if the attacker is null, it will not be calculated). Minor improvements to the Day/Night item generation manager. Fix to not punish players who destroy items with a count = 0... Fix for when a player tried to use a resurrection scroll while seated, it disappeared without effect. Fix for when it was possible to equip armor while paralyzed. Cleanup of System message. Rework of PathNodes. Fixed the ia for mobs attack range when chasing the player (test) Fixed Pathnodes loading Added # ------------------------ #Show Red Name for Aggressive Mobs # ------------------------ ShowRedName = True Which was missing in the configs
    • L2JOmen
      ⚔️ L2JOmen High Five - SERVIDOR 100% RETAIL ⚔️

      By L2JOmen · Posted

      ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⚔️ L2JOmen High Five - SERVIDOR 100% RETAIL ⚔️ 📢 SOLICITAMOS APOYO PARA TESTING 📢 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ¡Saludos, comunidad de Lineage II! Estamos desarrollando un proyecto ambicioso y de calidad: L2JOmen High Five, un servidor  100% RETAIL que busca ofrecer la experiencia más auténtica de High Five.  Nos encontramos en la fase de desarrollo y testing, y necesitamos tu ayuda para hacerlo  grande. Si eres un amante del retail, disfrutas probar nuevas funciones y quieres formar  parte de un proyecto serio desde sus inicios, ¡tu apoyo es invaluable! ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎮 CARACTERÍSTICAS PRINCIPALES 🎮 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ✅ SERVIDOR 100% RETAIL    • Experiencia auténtica de High Five    • Geodata PTS Official    • Plataforma Premium 2025 ✅ SISTEMA DE RATES DINÁMICO (Progresión Retail x1 con ayuda x5 -> x1)    • XP: 1-20 (5.0x) | 21-40 (3.0x) | 41-60 (2.0x) | 61-75 (1.5x) | 76-85 (1.0x)    • SP: 1-20 (5.0x) | 21-40 (3.0x) | 41-60 (2.0x) | 61-75 (1.5x) | 76-85 (1.0x)    • Adena: x2.0 (Retail con pequeño ajuste)    • Drop y Spoil: x1.0 (Mobs, Raids y Epics) ✅ SISTEMA DE ENCANTAMIENTO PROFESIONAL    • Enchant Safe: +6 (100% seguro hasta +6)    • Enchant Máximo: +30    • Tasas de encantamiento balanceadas:      * 0-3: 100% | 4: 80% | 5: 75% | 6: 70% | 7: 65% | 8: 60%      * 9: 55% | 10: 50% | 11: 45% | 12: 40%      * 13: 10% | 14-25: 5-9% | 26-30: 1-4%    • Sistema Blessed Enchant habilitado ✅ INICIO DE PERSONAJE    • Dynasty Masterwork Set completo +12    • 1 Ticket para Weapon S +12    • Duración: 7 días ✅ CONFIGURACIÓN RETAIL    • Element Limit: Nivel 4    • Buffs: Duración de 1 hora    • Nobless: Obtenible mediante quest    • Subclass Máxima: 10 (Certificación para cada Subclass) ✅ SISTEMA DE FARM Y ECONOMÍA    • Múltiples monedas de farm (Adena, Ancient Adena, Coin of Luck, PC Bang Points, Farm Coins)    • Varias zonas de farm disponibles    • Zona de Party Farm (se habilita cada 3 horas por 1 hora)    • 4 Raids diarias programadas ✅ SISTEMA PC BANG POINTS    • Aproximadamente 10,000 puntos por 24 horas conectado    • Entrega cada 10 minutos    • Jugadores Normales: 60-72 puntos/intervalo    • Jugadores Premium: 96-116 puntos/intervalo    • 5% probabilidad de doble puntos ✅ SHOPS COMPLETOS    • Shop Normal (Adena y Farm Coins)    • Shop Donate (con opciones premium)    • Armaduras y Armas hasta Grado Dynasty, Moirai, S84    • Joyas completas, no incluye Epics    • Scrolls (Normales, Blessed, Divine, Ancient)    • Elementos hasta nivel 4-7    • Accesorios y consumibles ✅ SISTEMA VIP    • 5 niveles de VIP disponibles    • Bonificaciones progresivas de XP/SP/Drop    • Recompensas diarias exclusivas ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🤝 ¿QUÉ NECESITAMOS DE TI? 🤝 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🔍 TESTERS ACTIVOS    • Jugadores que prueben todas las funciones del servidor    • Feedback constructivo sobre bugs, balance y mejoras    • Reporte de problemas encontrados 🎮 JUGADORES DEDICADOS    • Amantes del retail que valoren la experiencia auténtica    • Personas dispuestas a ayudar a mejorar el proyecto    • Comunidad comprometida con el crecimiento del servidor 📊 REPORTES DETALLADOS    • Bugs y errores encontrados    • Sugerencias de balance    • Opiniones sobre el gameplay    • Feedback sobre sistemas implementados ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 💎 ¿POR QUÉ UNIRTE A L2JOmen? 💎 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🌟 PROYECTO SERIO Y COMPROMETIDO    • Desarrollo constante y mejoras continuas    • Atención a la comunidad activa    • Transparencia en todas las decisiones 🎯 EXPERIENCIA 100% RETAIL    • Sin modificaciones que rompan el juego original    • Balance auténtico de High Five    • Gameplay puro y tradicional ⚡ TECNOLOGÍA DE VANGUARDIA    • Servidor optimizado y estable    • Geodata oficial de PTS    • Sistema robusto y sin lag    • Sistema Anticheat Premium 🎁 RECOMPENSAS PARA TESTERS    • Participación activa en el desarrollo    • Reconocimiento especial en el lanzamiento    • Beneficios exclusivos para early testers ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 📞 CONTACTO E INFORMACIÓN 📞 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Si estás interesado en formar parte de este proyecto y ayudarnos a crear el mejor  servidor retail de High Five, contáctanos. Tu apoyo es fundamental para hacer realidad  este grandioso proyecto. 💬 Únete a nuestro grupo de testing 🌐 WhatsApp: https://chat.whatsapp.com/Km6uRtFsoUq2tNZZalo5HB?mode=wwt ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🏆 ¡Juntos construimos el mejor servidor retail! 🏆 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━  
    • drakenn
      Full interlude on classic client

      By drakenn · Posted

      any server used these files? if yes let me know in pm.
    • Alex K.
      Need OOG bot that works with L2J Interlude

      By Alex K. · Posted

      L2Net is an in-game (IG) bot. I already have Adrenaline for that. I'm looking for an out-of-game (OOG) bot - one that doesn’t require the Lineage 2 client to run.

  • 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