Add new Edit Delete History Source

loot_template

The *_loot_template tables

Table Structure

Field	Type	Attributes	Key	Null	Default	Comment
Entry	INT	UNSIGNED	PRI	NO	0
Item	INT	UNSIGNED	PRI	NO	0
Reference	INT			NO	0
Chance	FLOAT			NO	0
QuestRequired	TINYINT			NO	0
LootMode	SMALLINT	UNSIGNED		NO	1
GroupId	TINYINT	UNSIGNED		NO	0	PRI in creature_loot_template
MinCount	TINYINT	UNSIGNED		NO	1
MaxCount	TINYINT	UNSIGNED		NO	1
Comment	VARCHAR(255)			YES	NULL	TEXT in player_loot_template

Description of the fields

Table	Entry	Comment
creature_loot_template	creature_template.lootid	Usually the same as creature_template.entry
disenchant_loot_template	item_template.DisenchantID
fishing_loot_template	area id
gameobject_loot_template	gameobject_template.data1	Need to have gamobject type GAMEOBJECT_TYPE_CHEST (3) or GAMEOBJECT_TYPE_FISHINGHOLE (25)
item_loot_template	item_template.entry
mail_loot_template	mail template id
milling_loot_template	item_template.entry
pickpocket_loot_template	creature_template.pickpocketloot
player_loot_template	TeamID (0 Horde/1 Alliance)	Only drops in BGs as insignia removal.
prospecting_loot_template	item_template.entry
reference_loot_template	*_loot_template.reference
skinning_loot_template	creature_template.skinloot	Also includes minable/herbable loot from creatures
spell_loot_template	SpellID

Uses the entries in the referenced template in the current template.

Note: Self reference is never allowed. This will lead to a crash.

Chance for loot to drop. Chance can never exceed a total of 100 for all entries with the same GroupID.

If the field is left at 0 the chance will be even across all entries with the same GroupID and chance = 0.

0 - Loot is always available.

1 - Loot can only drop if the player has a quest with the item id specified in quest_template.RequiredItemId1-6.

Bitmask.

Used to separate conditional loot. Such as Hardmode loot in Ulduar. The active lootmode(s) can be changed at any time by the core.

In most cases this field is left as 1.

Used to group items within the same loot template.

Only one item from the group can drop.
If the total chance for the group is 100 then one item will always drop.
If the total chance for the group is less than 100, then there is a risk of empty loot.

Referenced loot can not be a part of a group.

Note: The client can only display 16 items in the loot windows, this includes gold. Therefore it is not recomended to use more than 16 groups.

Minimum amount of an item to drop in a single loot. Cannot be 0.

Table	Comment
*_loot_template	Maximum amount of an item to drop in a single loot.
referenced_loot_template	How many times a referenced loot template should be processed. Note: The core only rolls chance per loot definition once. If the initial reference roll was lost, it will skip the current loot completely, regardless of MaxCount.