loot_groups
This table contains the loot groups the loot tables link to. A group is a reusable list of items that several creatures, gameobjects or items share, for example the world drops of a level range or the disenchant results of an item quality.
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| groupid | int unsigned | key | |
| build | int unsigned | 0 | key |
| itemid | int unsigned | 0 | key |
| group_link | int unsigned | 0 | key |
| chance | float | 0 | |
| groupindex | tinyint unsigned | 0 | |
| mincount | int unsigned | 1 | |
| maxcount | int unsigned | 1 |
groupid
The id of the group. The loot tables (loot_creatures, loot_gameobjects, loot_items, loot_fishing, loot_pickpocketing, loot_skinning) reference it in their groupid column. The disenchant groups use 900000 + the disenchant id of the item.
build
Client build the group is valid from. The server loads, for every group, the rows with the highest build that does not exceed its own build.
itemid
The entry ID of the item from item_properties. 0 for a link to another group.
group_link
A nested group that is rolled in place of an item, 0 for an item row. Groups nest up to five levels deep.
chance
The percent chance of the row. With groupindex 0 the row rolls on its own, inside an exclusive group the value is the share of the row and rows with chance 0 split the rest equally.
groupindex
0 = own roll, every other value forms an exclusive group with the rows of the same index: one of them drops.
mincount
The minimum amount of the item.
maxcount
The maximum amount of the item, for a nested group the number of its rolls.