Page 1 of 1

db table droplist

Posted: Fri Apr 24, 2009 8:10 pm
by rehtafdog
L2J Revision Number:2939
L2JDP Revision Number:5984

1. how do i know what does field chance mean? is there any calculation i got to make with those numbers?

2. its suposed that every mob drop has a category and only one item from that list is dropped. how do i know what chance has that category to drop?

example: drops for elpy
mobId itemId min max category chance
20432 1873 1 1 -1 6368
20432 1871 1 1 -1 15920
20432 57 8 12 0 700000
20432 11 1 1 1 4286
20432 1873 1 1 2 941
20432 1868 1 1 2 4703
20432 1866 1 1 2 1568
20432 1865 1 1 2 2352
20432 1864 1 1 2 4703
20432 1787 1 1 2 1881
20432 17 10 30 2 11757

a. its going to drop only item 57, item 11 and only one in ( 1873, 1868, 1866, 1865, 1864, 1787, 17)
but not every elpies drop 3 items... so each category has a chance to drop. how do i get % of each category?
b. i guess category value -1 = spoil... so it doesnt meet point 2 requierment
c. if chances where 941. how do i convert that to %? :roll:

Re: db table droplist

Posted: Fri Apr 24, 2009 8:34 pm
by janiii
100 0000 = 100%

scenario 1: having 3 items with chance 1000000 (100%) in category 2, gives you a drop of 1 of the items. it just takes 1 item from 1 category and takes it's chance to drop and drops or drops not depending of the chance.

scenario 2: having 1 item with 10% chance in category 3, gives you a 10% to drop that item.

scenario 3: having 2 items with 10% chance in category 4, choosing between the one of the items, you have 10% chance to drop the selected item

Re: db table droplist

Posted: Fri Apr 24, 2009 11:47 pm
by Reimu
I try to search but nothing found. May be I use wrong keywords :? Anyway: exists tools for automatic generation knowledge base (on html or smth another) with drop\spoil chances based on information from server database?

Re: db table droplist

Posted: Tue Jun 23, 2009 10:31 pm
by bjc435
So is the droplist like extractable item, when it comes to chance. For example:

In extractable item all the items together can not go over 100 when you add all the chances up.

SO would drop list be like when you add up all the chances of all the items, they can not go over 1000000?
Or is it like Catagory 1 can have up to 1000000 chance when all chances are added. catagory 2 1000000 chance....
Or does it not matter at all? I could have a you get item x50% of the time. item y 60% of the time. item z 70% of the time in the same catagory.

Re: db table droplist

Posted: Wed Jun 24, 2009 7:31 am
by Notorious
If the dropchance is 50%, and you have a x2 server, the chance is not 100%, but it's like you kill every mob twice, and each time you have 50% chance for a drop.

Secondly, you can only get one type of drop from each category.