Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 0 Weight FOR items/armors/weapons:
- Quote
- 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%:
- Quote
- UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';
- WHEN you sell, everything will cost 0 adena:
- Quote
- 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:
- Quote
- UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.TYPE='L2Raidboss';
- DELETE ALL mobs UNDER 40 lvl:
- Quote
- 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:
- Quote
- DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );
- Increase DROP rate FOR recipes:
- Quote
- 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:
- Quote
- DELETE FROM characters WHERE lastAccess < 466560000;
- DELETE FROM accounts WHERE lastactive < 466560000;
- ADD FOR ALL monsters IN DROP: Coins
- Quote
- 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)
- Quote
- 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:
- Quote
- 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:
- Code:
- 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%:
- Code:
- 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%:
- Code:
- 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:
- Code:
- 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%:
- Code:
- 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%:
- Code:
- 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..
- Code:
- 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..
- Code:
- UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;
- Teleports cost 0 adena:
- Code:
- 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...
- Code:
- DELETE FROM skill_trees WHERE skill_id = 1320;
- DELETE FROM skill_trees WHERE skill_id = 1322;
- Grade penality DELETE:
- Disables grade penality...
- Code:
- 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...
- Code:
- UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;
- Dies adding price reduced TO 5 adena (OR increased TO 100kk):
- Good one FOR faction servers.
- Code:
- UPDATE henna SET price=5;
- ..OR TO 100kk (good one FOR high rates servers).
- Code:
- 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).
- Code:
- 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..
- Code:
- UPDATE enchant_skill_trees SET sp=0;
- UPDATE enchant_skill_trees SET exp=0;
- Auto server restart:
- Every week..
- Code:
- INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360");
- Every two days..
- Code:
- INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360");
- Every 24h..
- Code:
- INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");
- Every 12h..
- Code:
- INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360");
- Every 6h..
- Code:
- INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");
- Every 3h..
- Code:
- INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");
- Thx to lekino
- 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)
- Code:
- 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 Wink
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement