Guide Usefull Sql Scripts !

[Nomimous]

helpful topic

awesome share thanks

[CorLeoNe]

 

insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster';

 

i want to add this but only for moobs level 70+

 

how can i do that ?

[dymek1984]

insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster' and level>='70';

try this

[Monkey D. Luffy]

Good share.

[millerose23]

really awesome share dude... The only sad is that new projects replace .sqls with the fucking xmls...Tnx a lot for your share :)

[bella]

Awesome share. For a newb like me.

[lazaros127]

Hi everyone,

here is some usefull SQL scripts (examples, you can edit them whatever you want

good job man ! ty for share

[TeoWinc]

thx is not enough .. full of respect

[Elune]

Nice share.

[Kusaty]

A question. How can I remove all the drop from the raid bosses? My pack is L2JFrozen (interlude).
 

[HyperBlown]

14 minutes ago, Kusaty said:

A question. How can I remove all the drop from the raid bosses? My pack is L2JFrozen (interlude).
 

what is the structure of the table where the drops are beeing saved?