db table droplist

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
rehtafdog
Posts: 7
Joined: Wed Apr 22, 2009 6:50 am

db table droplist

Post 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:
User avatar
janiii
L2j Veteran
L2j Veteran
Posts: 4269
Joined: Wed May 28, 2008 3:15 pm
Location: Slovakia

Re: db table droplist

Post 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
DO NOT EVEN TRY TO MESS WITH ME!
forum flOOder dancing dEVILoper
I don't give private support - PM will be ignored!
User avatar
Reimu
Posts: 40
Joined: Wed Apr 15, 2009 9:56 am
Location: Rus

Re: db table droplist

Post 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?
bjc435
Posts: 73
Joined: Sun Jan 18, 2009 4:07 pm

Re: db table droplist

Post 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.
User avatar
Notorious
Posts: 501
Joined: Thu May 28, 2009 3:50 pm
Location: Sweden

Re: db table droplist

Post 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.
Post Reply