Belzebul Posted April 15, 2010 Share Posted April 15, 2010 ye, it helped me a lot, thank you. Link to comment Share on other sites More sharing options...
kikboxer Posted April 15, 2010 Share Posted April 15, 2010 It's good!!!! Please create SQL scripts,that Increases reidboss stats In 2 times and sql that make all reidboss 80 lvl! Link to comment Share on other sites More sharing options...
kikboxer Posted April 15, 2010 Share Posted April 15, 2010 1. Removal of all things with defined ID at the certain character. DELETE * FROM items WHERE item_id=(item id) AND owner_id=(character id) 2. 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; Link to comment Share on other sites More sharing options...
kikboxer Posted April 15, 2010 Share Posted April 15, 2010 remove weight update etcitem set weight=1 where weight> 1; update weapon set weight=1 where weight> 1; update armor set weight=1 where weight > 1; Link to comment Share on other sites More sharing options...
EdenEternal Posted April 15, 2010 Share Posted April 15, 2010 sql that make all reidboss 80 lvl! RaidBosses UPDATE npc SET `level`=80 WHERE `type`="L2RaidBoss" GrandBosses UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss" Link to comment Share on other sites More sharing options...
EdenEternal Posted April 17, 2010 Share Posted April 17, 2010 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'; Link to comment Share on other sites More sharing options...
d1nos Posted April 20, 2010 Share Posted April 20, 2010 where i can edit this cause i am new at developing and dont know much about it Link to comment Share on other sites More sharing options...
kasta Posted April 23, 2010 Share Posted April 23, 2010 can any one make code to delete all drop items exept adena pls Link to comment Share on other sites More sharing options...
mikrosgiwrgakis.com Posted April 29, 2010 Share Posted April 29, 2010 very nice to share all those things with us :D some of them are really useful!!! Link to comment Share on other sites More sharing options...
LioNtaraki Posted April 29, 2010 Share Posted April 29, 2010 man this nice job but put this ? Link to comment Share on other sites More sharing options...
PwnedTheGod™ Posted May 1, 2010 Share Posted May 1, 2010 Indeed very usefull...! Thnx for sharing.Keep up at it :) Btw I was searching about:Weight limit :P Link to comment Share on other sites More sharing options...
striker15 Posted May 18, 2010 Share Posted May 18, 2010 http://www.maxcheaters.com/forum/index.php?topic=98212.0 Link to comment Share on other sites More sharing options...
Onix Posted May 18, 2010 Share Posted May 18, 2010 http://www.maxcheaters.com/forum/index.php?topic=98212.0 lol mate dont spam in old topic ! this link is the same what have here .... Link to comment Share on other sites More sharing options...
masterkill9000 Posted May 20, 2010 Share Posted May 20, 2010 how do i make all the L2Monster in game stronger then what there are if am using an full npc buffer? so i dont have to do 1 by 1 so that it be harder for players to kill then 1 hit kills? Link to comment Share on other sites More sharing options...
Warmaster™ Posted July 5, 2010 Share Posted July 5, 2010 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? you change the original spawn newbie charters??? if you change it is this the problem Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now