GorDJrHzz

Sry does'nt see

Delete items weight (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); Adena drop chance 100%: UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57'; Items for sell 0aden UPDATE `armor` SET price=0 where price > 1; UPDATE `etcitem` SET price=0 where price > 1; UPDATE `weapon` SET price=0 where price > 1; All raid boss hp same - 5000k hp: UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss'; Delete mobs lower that 40 lvl DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster'; Delete all mats, recipes from db drop list. DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' ); Recept drop change 100%. UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe'); Delete chars and account alder that 31days DELETE FROM characters WHERE lastAccess < 155520000; DELETE FROM accounts WHERE lastactive < 155520000; add extra drop for all mobs - coints: insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster'; Top non gr items for newbie. (Dont working for kameal.) 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); If you delete rb drop from db this code back drop. 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'); Wooden/Devotion set, best non weapon soulshots pack, gloves/boots for new char: 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) Add new char more adena INSERT INTO char_creation_items VALUES (0,57,adenu_skaicius,'false'); Delete all sb from db droplist. DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' ); Guards boost (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'; weaken rb 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 spawn place: UPDATE char_templates SET x=jusuXcoordinates; UPDATE char_templates SET y=jusuYcoordinates; UPDATE char_templates SET z=jusuZcoordinates; Boost all char p.def/m.def 10%: UPDATE char_templates SET P_DEF = P_DEF * 1.1; UPDATE char_templates SET M_DEF = M_DEF * 1.1; Boost char speed 20%: UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2; Boost all char CP. 20lv - 22%, 40lv - 44%, 76lv - 66%: For longer PvP 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 regen 10x time UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0; TP price 0 aden UPDATE teleport SET price=0; Delete create common skill: 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; Raid boss spawn with 70% hp: UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7; Dyes price 5adena for draw dyes UPDATE henna SET price=5; Auto server sertarts: Week.. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360"); 2 days.. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360"); 24 hour.. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360"); 12 hour.. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360"); 6 hour.. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360"); 3 hour.. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");

I see that problem in many server. when you with warlock summon party cubics and for exp: wind rider in olympiad with cubic. So this is file: Olympiad.java Insert this code: import net.l2off.gameserver.model.actor.instance.L2CubicInstance; After this: import net.l2off.gameserver.model.actor.instance.L2PetInstance; For Ex: import net.l2off.gameserver.model.actor.instance.L2PetInstance; import net.l2off.gameserver.model.actor.instance.L2CubicInstance; When find rows with this text: //Remove Buffs player.stopAllEffects(); // Avoid prefrenzy(and others) exploit player.stopSkillEffects(176); player.stopSkillEffects(139); player.stopSkillEffects(406); //Remove Summon's Buffs if (player.getPet() != null) { L2Summon summon = player.getPet(); summon.stopAllEffects(); if (summon instanceof L2PetInstance) summon.unSummon(player); } After thems put this code: if (player.getCubics() != null) { for(L2CubicInstance cubic : player.getCubics().values()) { cubic.stopAction(); player.delCubic(cubic.getId()); } player.getCubics().clear(); } For Ex: //Remove Buffs player.stopAllEffects(); // Avoid prefrenzy(and others) exploit player.stopSkillEffects(176); player.stopSkillEffects(139); player.stopSkillEffects(406); //Remove Summon's Buffs if (player.getPet() != null) { L2Summon summon = player.getPet(); summon.stopAllEffects(); if (summon instanceof L2PetInstance) summon.unSummon(player); } if (player.getCubics() != null) { for(L2CubicInstance cubic : player.getCubics().values()) { cubic.stopAction(); player.delCubic(cubic.getId()); } player.getCubics().clear(); } //Remove player from his party if (player.getParty() != null) { L2Party party = player.getParty(); party.removePartyMember(player); } I am not speak in english very well.

Awesome!