loot_fishing
This table contains the fishing loots for zones.
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| entryid | int(10) | 0 | |
| itemid | int(11) | 0 | |
| normal10percentchance | float(5) | 0.00 | Floating? Really? |
| normal25percentchance | float(5) | 0.00 | |
| heroic10percentchance | float(5) | 0.00 | |
| heroic25percentchance | float(5) | 0.00 | |
| mincount | int(10) | 0 | |
| maxcount | int(10) | 0 |
entryid
The Entry ID of the zone from fishing.
itemid
The Entry ID of the Item that will drop, from item_properties.
normal10percentchance
The percent chance (1 - 100) that the Item will drop outside instances, in normal dungeons, normal 10 mode raids, old 25 and 40 man raids.
normal25percentchance
The percent chance (1 - 100) that the Item will drop in heroic dungeons and in Normal 25-mode raids.
heroic10percentchance
The percent chance (1 - 100) that the Item will drop in Heroic 10-mode.
heroic25percentchance
The percent chance (1 - 100) that the Item will drop in Heroic 25-mode.
mincount
The minimum amount of the Item that will drop.
maxcount
The maximum amount of the Item that will drop.