Database Editor:Loot

Loot tables consist of both a random coin value range and zero or more lootdrops. The input coin values are in copper, but the looted coin in-game will be higher denominations.

The same loot table may be applied to multiple NPCs. Take care to click the correct button when removing loot tables from an NPC that you do not inadvertently delete a table in use by other NPCs. 'Drop this loot table' will remove the table from that particular NPC without deleting it. Deleting the table (clicking the red X) will remove it from all the NPCs using it.

Loot Drops

Loot drops have a complex unintuitive logic because the loot drop system that was designed for EQ Emu originally could not facilitate the functionality that Sony had implemented and band-aid fixes were tacked on top of a flawed design instead of rewriting from scratch. It's important to understand how this works, else drop rates will be very different than intended.

Like loot tables, loot drops can be applied to multiple loot tables and deleting one will remove it from all the tables that use it.

Each loot drop contains a list of possible item drops. A loot drop when rolled can drop either none, one, or many items. Each item entry has its own drop chance, a toggle as to whether the NPC may equip the item, the number of item charges if applicable, the level range the NPC may use the item, and a multiplier.

Mindrop, Droplimit, Multiplier, Multiplier Min and Probability control how any items may drop. It's very important to understand how these work.

Mindrop sets a minimum number of items that must drop per multiplier. If this value is non-zero, then the server will keep rolling items in the lootdrop until the number of items equals or exceeds mindrop.

Droplimit sets a maximum number of items that may drop per multiplier. The lootdrop will stop dropping items when this value is reached, but only for each multiplier instance.

Multiplier essentially re-runs the lootdrop as if it were multiple identical lootdrops. Mindrop and Droplimit both only apply to each instance of Multiplier. For example, if you set Mindrop 1 and Droplimit 1 to force only one item drop, and set Multiplier to 3, then 3 items will drop.

Probability is a roll chance for the entire lootdrop. If the roll fails, then none of the items are checked. This probability roll is done once for each Multiplier.

Multiplier Min is a way of guaranteeing that some items drop even with a Probability set below 100%. It essentially forces Probability to 100% for Multiplier Min number of Multipliers. For example: if Mindrop and Droplimit are both 1 to force 1 item to drop per Mult, Probability is between 1 and 99, Multiplier is 10 and Mult Min is 5, then anywhere from between 5-10 items will drop. The first five Mults will be 100%, and the latter five will each roll a Probabiliy chance of dropping an item. In this way you can vary the number of items that may drop while still guaranteeing one or more.

To mimic Sony's loot logic for raid bosses, generally you will want to set both Mindrop and Droplimit to 1 and have all the item chances in the table add up to 100%; then set Multiplier, Probability, and Mult Min appropriately.

Individual Item Rolls

When individual item rolls are checked, a roll is done for each item's multiplier. I.e. you'll get a range of possible drops from 0 to X drops instead of always either 0 or X.

If Droplimit and Mindrop are both 0, then the items are each checked once from top to bottom and nothing more. None of the items may drop, or all of them my drop depending on the rolls.

If either Droplimit or Mindrop are non-zero, then some special logic is done to avoid a problem that results in real-world drop chances that don't match expected rates. The drop code logic will add up each items' drop chance and roll a value up to that sum to avoid problems such as if you had set the first item to 100% or greater with Droplimit 1 giving no other items after it a chance to drop.

Overall lootdrop logic works like this:

• Multiplier is checked first to determine how many instances of this lootdrop will iterate, then loops over them.
• Probability is ignored if Mult Min hasn't been met yet, else it's rolled for each remaining Multiplier.
• Individual item multipliers are then checked and item chances are rolled for each item's multiplier.
• If Droplimit is reached, the loop ends.
• The loop reruns until Mindrop is reached.

Loot Simulator

Tools/math are often required to know how the results of a configuration of Multiplier, Probability, and Multiplier Minimum will be. A lua script for this purpose is available here. With this you can use some trial and error to get a drop profile that agrees with you.

The output looks like this:

Simulated Kills: 1000000; MIN: 1; MULT: 7; PROBABILITY: 45; Total Drops: 3701197

1 drops: 27759 (2.7%)

2 drops: 135443 (13.5%)

3 drops: 278189 (27.8%)

4 drops: 302977 (30.2%)

5 drops: 186034 (18.6%)

6 drops: 61279 (6.1%)

7 drops: 8319 (0.8%)

RARE_CHANCE: 100; Rares: 3701197 (100%) Kills w/ Rare: 1000000 (100%)

Note however that this script assumes a Droplimit of 1.