New loot system

[Akkadius]

Originally Posted by ChaosSlayerZ

In NEW system if you saying that probabilities are removed, how can you replicate the system above where I want a situation where npc may or may not drop anything at all even before we get to the items?

I know this is easy to over think and I did it too when I was question Cavedude on changing the system before we bring in the data that I parsed from Magelo.

Think of it as a header.

loottable_entry:

mysql> select * from loottable_entries WHERE loottable_id
 = 1000 limit 1;
+--------------+-------------+------------+-------------+-----------+---------+
| loottable_id | lootdrop_id | multiplier | probability | droplimit | mindrop |
+--------------+-------------+------------+-------------+-----------+---------+
|         1000 |        2014 |          1 |          25 |         1 |       0 |
+--------------+-------------+------------+-------------+-----------+---------+

You have a 25% probability of rolling into the lootdrop:

Inside that lootdrop (2014):

mysql> select * from lootdrop_entries where lootdrop_id = 2014;
+-------------+---------+--------------+------------+--------+----------+----------+------------+
| lootdrop_id | item_id | item_charges | equip_item | chance | minlevel | maxlevel | multiplier |
+-------------+---------+--------------+------------+--------+----------+----------+------------+
|        2014 |    3329 |            1 |          1 |   8.25 |        0 |      127 |          1 |
|        2014 |    3342 |            1 |          1 |    8.5 |        0 |      127 |          1 |
|        2014 |    3353 |            1 |          1 |   8.25 |        0 |      127 |          1 |
+-------------+---------+--------------+------------+--------+----------+----------+------------+

Each item in this lootdrop now is rolled individually. In other words, all three of these items could drop at the same time but they are all rolled individually instead of ONE roll a random number 1-100 and it being (3329 - 8.25%) - (3342 - 8.5%) - (3353 - 8.25%)

Now it is a roll for each item:
3353 - 8.25 (Rolled 10, well shucks)
3329 - 8.5 (Rolled 4, nice it dropped!)
3342 - 8.5 (Rolled 94, no cigar)

Originally Posted by ChaosSlayerZ

Also, when you say that items will now "roll individually" - I do know that all %% on items were screwed up and place in list was affecting proper percentages, but "roll individually" sounds somewhat vague - do items total still have to add up to 100%?

No items do not have to add up to 100% as they are rolled individually, the existing % and drops for PEQ will be audited against the script I am building to dump the new data and audit the existing data.

Make sense?