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.