DragonHunter Posted March 8, 2009 Share Posted March 8, 2009 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 Link to comment Share on other sites More sharing options...
jossoo Posted March 8, 2009 Share Posted March 8, 2009 OMAGAD nice [share][guide]i think its is....very nice man some of them they are really helpfull where u found them ? Link to comment Share on other sites More sharing options...
Junkee Posted March 8, 2009 Share Posted March 8, 2009 Very usefull :D Thx for share Link to comment Share on other sites More sharing options...
DragonHunter Posted March 8, 2009 Author Share Posted March 8, 2009 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 ;) Link to comment Share on other sites More sharing options...
Hax0r Posted March 8, 2009 Share Posted March 8, 2009 +1 for your general work in mxc, keep up. Link to comment Share on other sites More sharing options...
Frank Posted March 8, 2009 Share Posted March 8, 2009 Nice share. Really usefull and cool too. Keep sharing Link to comment Share on other sites More sharing options...
Versus Posted March 8, 2009 Share Posted March 8, 2009 Indeed it's really nice and it deserves +1 karma. Cool! Keep it up. Link to comment Share on other sites More sharing options...
DragonHunter Posted March 8, 2009 Author Share Posted March 8, 2009 Soon a L2J Buff Creator 1.0 will be released :) So you can generate/create you own buffer Link to comment Share on other sites More sharing options...
Nicopoltios Posted March 8, 2009 Share Posted March 8, 2009 hot share and guide thx ;) Link to comment Share on other sites More sharing options...
DāЯқŜiĐє Posted March 9, 2009 Share Posted March 9, 2009 Nice share and ty :P (something like SQL AIO :P ) cool Link to comment Share on other sites More sharing options...
TzizDeveloper Posted March 9, 2009 Share Posted March 9, 2009 nice share bro! Link to comment Share on other sites More sharing options...
DrachaVonDrachen Posted March 10, 2009 Share Posted March 10, 2009 really very good share thanks.. Link to comment Share on other sites More sharing options...
Chandy Posted March 10, 2009 Share Posted March 10, 2009 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 :) Link to comment Share on other sites More sharing options...
Captivator Posted March 10, 2009 Share Posted March 10, 2009 very usefull thanks a lot Link to comment Share on other sites More sharing options...
Fogotendx20 Posted March 10, 2009 Share Posted March 10, 2009 bad idea to run query to ban players to ban ip ... cause ppl play and from nets... can pay all for one Link to comment Share on other sites More sharing options...
Recommended Posts