Jump to content
  • 0

More than 1 Drop at same time?



so, i have a really bad solution for this, but it is a solution :D


it sets a variable and increments it with every run. it sets an incremental value to category column where drop is not spoil.

set @a := 0;
update droplist set category = (@a := @a+1) where category <> -1;


the result looks like this, you can see the incrementing category number through the whole table.



This maybe work?


So i make 3 categories for 1 mob with diferent drop and this will make mob drop all items at same time?

And what is this a Query for modify the Custom Drop Table?


set @a := 0;
update droplist set category = (@a := @a+1) where category <> -1;

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

On the screen you have all what you need..

Only put mobid, itemid, (...) and you are done. (in category put 0 or 1)

Or you can add drop in game (shift click on a monster) :P

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.

Answer this question...

×   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