Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
L2JForge.live Interlude Premium Emulator

[SHARE] Usefull SQL scripts V2

EdenEternal
 Share

Recommended Posts

EdenEternal Newbie

EdenEternal

Posted
Posted

Hello Maxcheaters!

 

i prefer to open new topic because old was very passive and no updates....

 

let's start

 

Thx to badriniki

 

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 `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');

 

Thx to 1tm

 

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%:

 

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):

 

UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;

 

Teleports cost 0 adena:

 

UPDATE teleport SET price=0;

 

Create common item skill delete:

 

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

 

Grade penality delete:

 

DELETE FROM skill_trees WHERE skill_id = 239;

 

Raidbosses always spawns with 70% hp:

 

UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;

 

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

 

UPDATE henna SET price=5;

 

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

 

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

 

To enchant skill doesn't need exp/sp:

 

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

 

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)

 

 

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");

 

Thx to Leki

 

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 ;

 

2x more(Str,Int,Dex,Wit,Men,Con)

 

UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40'); 
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22'); 
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36'); 
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21'); 
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23'); 
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27'); 
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39'); 
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43'); 
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27'); 
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36'); 
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25'); 
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32'); 
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24'); 
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47'); 
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40'); 
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');
UPDATE `char_templates` SET `dex`='68' WHERE (SELECT ClassId) AND (dex = '34');
UPDATE `char_templates` SET `dex`='46' WHERE (SELECT ClassId) AND (dex = '23');
UPDATE `char_templates` SET `dex`='52' WHERE (SELECT ClassId) AND (dex = '26');
UPDATE `char_templates` SET `dex`='58' WHERE (SELECT ClassId) AND (dex = '29');

 

Make all raidboss 80 lvl!

 

UPDATE npc SET `level`=80 WHERE `type`="L2RaidBoss"

 

Grandboss

 

UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss"

 

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 all the pets 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';

 

Delete Monsters Lower 51 Lvl

 

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

 

Full Database Delete

DROP DATABASE `Database_name`;

 

Delete from droplist all items except 57 and 4037(or that items you want)

DELETE FROM droplist WHERE itemId NOT IN (57,4037);

 

Thx to kikboxer

 

Removal of all things with defined ID at the certain character.

 

DELETE * FROM items WHERE item_id=(item id) AND owner_id=(character id)

 

Display of all things defined character.

 

mysql> select a.name,"armor",a.crystal_type,i.count,i.enchant_level from armor a, items i where a.item_id=i.item_id and i.owner_id=идчара union select a.name,"weapon",a.crystal_type,i.count,i.enchant_level from weapon a, items i where a.item_id=i.item_id and i.owner_id=идчара union select a.name,"some",a.crystal_type,i.count,i.enchant_level from etcitem a, items i where a.item_id=i.item_id and i.owner_id=character id;

 

 

 

if some1 have new sql script post and i will update :)

EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Check first before make a post:

http://www.maxcheaters.com/forum/index.php?topic=98212.0

 

What the point to make 50k same post ?

Update it/ask me for update/add your sql...

i have posted same sql scripts but you don't updated it! not only my scripts....

Sido Apprentice

Sido

Posted
Posted

Nice collection!

nice collection indeed, just keep it update :) i will find useful most of them .

EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Updated 11/07/2010

 

Delete Monsters Lower 51 Lvl

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

EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

what meens karma -1 ?

Karma Rules

 

Karma can give Staffers and Platinum Members only.

Karma abusing, without any reasons is not allowed.

When you give karma make as more specific as you can in description reasons.

Karma in pms is not allowed for any reasons.

Use [more] and [less] buttons once in a Topic, no double karma is allowed.

Karma abusing means -1, or even ban.

Users with -4 karma or less will be banned.

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

    • Williams
      L2JOne Website System — Features & Security Overview

      By Williams · Posted

      Update: Advanced Rate Limiting Rate limiting is now applied to: Login attempts Account registration Password recovery Email confirmation resends WhatsApp verification Checkout access The system maintains independent counters by IP address and user identity, helping prevent traditional brute-force attacks as well as distributed credential-stuffing attempts using multiple proxies. Brute-Force and Credential-Stuffing Protection Protection is not limited to the visitor's IP address. The system also tracks attempts associated with the account, username, or email address, reducing the effectiveness of attacks performed through rotating IP addresses, proxies, or VPN services. Global HTTP Security Headers Security headers are applied across the entire website: X-Frame-Options X-Content-Type-Options Referrer-Policy HTTP Strict Transport Security These headers help protect the website against clickjacking, MIME-type confusion, insecure referrer exposure, and HTTP downgrade attempts. Secure Error Handling Internal exceptions are recorded in protected security logs while visitors receive sanitized error messages. This prevents the accidental exposure of: Internal file paths Database information SQL errors Server configuration Application stack traces Private Storage Exposure Monitoring The system automatically checks whether the private storage directory is publicly accessible in production. If exposure is detected, a security warning is recorded for the administrator without interrupting the website. This directory may contain licensing information, rate-limit records, and security logs and must never be publicly accessible. OAuth Request Protection Google and Facebook authentication flows use cryptographically random state values stored in the user's session. Returned state values are validated using constant-time comparison, helping prevent OAuth request forgery and unauthorized account-linking attacks. Telegram Authentication Validation Telegram login information is protected through: HMAC signature validation Constant-time hash comparison Authentication timestamp verification Expired-login rejection Secure Verification Tokens Email, password recovery, and WhatsApp verification systems include: Cryptographically secure random tokens Hashed WhatsApp verification codes Automatic expiration Limited verification attempts Resend cooldowns One-time token invalidation Account Activation Protection When email or WhatsApp verification is required, the game account remains restricted until all required verification steps are completed. Unverified users cannot bypass the confirmation process through standard or social login. Secure Upload Processing Administrative image uploads include: Real MIME-type inspection Image-content validation File-size limits Extension allowlists Server-generated random filenames Rejection of invalid or disguised files Original user-provided filenames are never used as the final stored filename. Path Traversal Protection Theme and template identifiers are restricted to validated slugs and must exist in the internal list of allowed themes. This prevents directory traversal and unauthorized local-file access through manipulated template names. Atomic Ticket Transfer Protection Ticket transfers use transactional and durable delivery processing. The balance is conditionally debited, the delivery is recorded before communication with the game database, and failed deliveries remain pending for safe reprocessing. This helps prevent: Free-item delivery Inconsistent balances Duplicate delivery Partial transaction failures Lost transfer records Concurrent Balance Protection Administrative balance adjustments use database transactions and row-level locking. This prevents simultaneous balance operations from overwriting each other or creating inconsistent account balances. Secure Redirect Handling Redirect values are sanitized against header injection, and external redirects are restricted to HTTPS destinations. Password Security Improvements The website uses modern password hashing for player-panel accounts and bcrypt with a configurable cost for supported game-server account systems. Compatibility is included for game-server implementations requiring the $2a$ bcrypt prefix. Duplicate Payment Prevention Built-in protections include: Idempotency control Transaction reference validation Payment status verification Unique external payment references Database transactions and rollback Durable payment history Completed-order verification These protections prevent: Double credits Repeated processing Duplicate payment callbacks Incomplete financial operations Signed Payment Callback Protection Payment callbacks are protected through: HMAC-SHA256 authentication Constant-time signature comparison Signed callback timestamps Callback freshness validation Shared callback secrets This helps prevent forged payment notifications, callback manipulation, and replay attacks. SQL Injection Protection The database layer uses: PDO Prepared statements Parameter binding Controlled internal allowlists for dynamic identifiers User-controlled values are not directly concatenated into SQL queries. XSS Protection Output and form data are protected through: HTML escaping Attribute escaping Input filtering HttpOnly session cookies MIME-sniffing protection Frame embedding restrictions These measures reduce the risk of Cross-Site Scripting, malicious HTML injection, session theft, and clickjacking. CSRF Protection Sensitive forms and administrative operations use session-based CSRF tokens. Requests without a valid token are rejected, helping prevent unauthorized actions performed through malicious external websites. Secure Session Protection The session system includes: HttpOnly cookies Secure cookie support SameSite restrictions Session ID regeneration Authentication state validation Session timeout controls These protections reduce the risks of session fixation, session theft, and unauthorized account reuse. reCAPTCHA Protection Google reCAPTCHA may be enabled on sensitive public forms to reduce: Automated account registrations Spam submissions Bot login attempts Automated password recovery abuse Confirmation Resend Limits Email and WhatsApp confirmation resends are protected through: Cooldown periods Rate limiting Expiring verification codes Attempt counters This prevents verification-message flooding and excessive external API usage. Licensing and Anti-Cloning Protection The website includes centralized licensing controls with: License-key validation Domain binding Signed license responses Cached license validation Temporary offline grace period Circuit-breaker protection Unauthorized-domain rejection These measures help prevent unauthorized installation, cloning, and redistribution of the system.
    • Projack
      Lineage 2 Patch Downloader

      By Projack · Posted

      Tool that allows you to download the Lineage 2 game client directly from the official publisher CDNs. It fetches the CDN's file list and downloads every patch file, decompresses it (LZMA / Zip) and writes the finished client to disk — and can resume or repair an existing installation instead of starting over. It runs several client downloads at once through a batch queue, so you can prepare multiple regions or versions in a single session.   Supported: NCSoft CDNs (TW / KR / JP / NA) and  4game CDNs(RU / EU)   Download: https://drive.google.com/file/d/11SDcNASqO2GKOBT79LFu7mqvSRSJZvBS
    • deMEV
      Canon Cathedral for all L2 clients

      By deMEV · Posted

    • gerardas
      L2Avokado | Active Development

      By gerardas · Posted

      https://l2avokado.com/ Hello everyone,   After some time of development, we've decided to open L2Avokado to the public in its current development stage. We're looking for players who enjoy Interlude and would like to help shape the project before its official release.   This isn't a "launch" announcement. Instead, we're inviting the community to log in, explore the server, test the systems we've built, and provide honest feedback. Whether it's bug reports, balance suggestions, progression ideas, or quality-of-life improvements, we'd love to hear them.   Our goal has always been to create an Interlude server that feels familiar while offering a fresh progression experience. We've intentionally avoided custom weapons, armor, and client modifications. Instead, we've focused on redesigning progression through reworked hunting grounds, quests, crafting, and gameplay systems while remaining compatible with a clean Interlude client.   At this stage, the core progression path has been implemented, including the main hunting grounds, quests, custom systems, and events. However, as the project is still under active development, there will inevitably be bugs, balance issues, and areas that require further polishing.   This is exactly why we'd like your help.   We're looking for players who are willing to: Test gameplay and progression. Report bugs and exploits. Suggest balance improvements. Share ideas for new features or quality-of-life changes. Help us build a server that the community genuinely enjoys playing.   The Client and System downloads are already available on our website, so you can jump straight into the game. We're also working on a dedicated launcher that will simplify installation and future updates.   If you're interested in helping develop a unique Interlude project and want your feedback to genuinely influence the direction of the server, we'd love to have you with us.   We look forward to seeing you in-game and hearing your thoughts on Discord. https://l2avokado.com/
    • Dragic
      La2Tools — Lineage 2 Texture Pack Editor 3.0.3

      By Dragic · Posted

      Μoved to the correct section..    

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