Guide Usefull Sql Scripts !

[Nomimous]

helpful topic

awesome share thanks

[CorLeoNe]

 

  Quote

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]

  On 10/29/2009 at 8:09 PM, badriniki said:

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]

  On 12/13/2021 at 7:40 PM, Kusaty said:

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

Expand  

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