Jump to content

Usefull Sql Scripts !

Recommended Posts

  • 2 years later...


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 ?

Link to comment
Share on other sites

  • 3 months later...
  • 1 month later...
  • 1 month later...
  • 2 weeks later...
  • 4 months later...
  • 6 years later...
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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock