Guide Usefull Sql Scripts !

[Belzebul]

ye, it helped me a lot, thank you.

[kikboxer]

It's good!!!! Please create SQL scripts,that Increases reidboss stats In 2 times and sql that make all reidboss 80 lvl!

[kikboxer]

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;

 

[kikboxer]

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;

[EdenEternal]

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"

[EdenEternal]

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

 

 

[d1nos]

where i can edit this cause i am new at developing and dont know much about it

 

[kasta]

can any one make code to delete all drop items exept adena pls

[mikrosgiwrgakis.com]

very nice to share all those things with us :D some of them are really useful!!!

[LioNtaraki]

man this nice job but put this

?

[PwnedTheGod™]

Indeed very usefull...!

Thnx for sharing.Keep up at it :)

Btw I was searching about:Weight limit :P

[striker15]

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

[Onix]

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

[masterkill9000]

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?

[Warmaster™]

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