Bluegill Murloc

Creature

General

Creature model for display ID 188
Field Value
entry 1024
display_id1 188
level_min 20
faction 18: Murloc
npc_flags None
health_multiplier 1.02
mana_multiplier 1

Spawn points — Eastern Kingdoms (25)

-3213.86 -900.087 -2.344 0 [Random: 10 yards]
-3246.6 -842.02 -15.1982 0 [Random: 10 yards]
-3213.06 -1177.98 6.21252 0 [Random: 10 yards]
-3283.66 -880.341 -11.4841 0 [Random: 10 yards]
-3314.26 -914.791 2.90813 0 [Random: 10 yards]
-3244.29 -906.829 4.09774 0 [Random: 10 yards]
-3273.98 -1124.94 9.294 0 [Random: 10 yards]
-3270.44 -968.283 6.40014 0 [Random: 10 yards]
-3306.93 -948.141 9.862 0 [Random: 10 yards]
-3281.98 -936.932 7.331 0 [Idle]
-3247.93 -947.564 9.90014 0 [Random: 10 yards]
-3203.43 -1153.68 6.58752 0 [Random: 10 yards]
-3248.29 -1090.11 6.52715 0 [Random: 10 yards]
-3257.93 -1159.55 9.28688 0 [Random: 10 yards]
-3284.94 -977.369 9.77514 0 [Random: 10 yards]
-3245.83 -1020.83 8.65014 0 [Random: 10 yards]
-3230.29 -1005.43 6.485 0 [Random: 10 yards]
-3221.4 -1022.76 7.77514 0 [Idle]
-3215.16 -1012.35 9.77514 0 [Idle]
-3212.56 -1027.55 8.52514 0 [Idle]
-3221.05 -1035.13 6.04052 0 [Random: 10 yards]
-3272.26 -1040.97 9.43597 0 [Random: 10 yards]
-3282.06 -1245.29 9.4277 0 [Random: 10 yards]
-3280.77 -1173.35 9.11705 0 [Random: 10 yards]
-3251.78 -1209.42 9.19991 0 [Random: 10 yards]

Loot (98)

730 Murloc Eye 38.6% 1468 Murloc Fin 34.11% 5524 Thick-shelled Clam 29.99% 5784 Slimy Murloc Scale 19.51% 6308 Raw Bristle Whisker Catfish 4.68% 1205 Melon Juice 2.17% 929 Healing Potion 1.55% 5504 Tangy Clam Meat 1.42% 3385 Lesser Mana Potion 0.63% 3012 Scroll of Agility 0.5% 954 Scroll of Strength 0.48% 1478 Scroll of Protection II 0.32% 1712 Scroll of Spirit II 0.32% 1210 Shadowgem 0.24% 1206 Moss Agate 0.16% 5500 Iridescent Pearl 0.06% 4698 Seer's Mantle 0.06% 818 Tigerseye 0.06% 4700 Inscribed Leather Spaulders 0.05% 4538 Snapvine Watermelon 0.04% 856 Blue Leather Bag 0.02% 2996 Bolt of Linen Cloth 0.02% 2997 Bolt of Wool Cloth 0.02% 2450 Briarthorn 0.02% 4593 Bristle Whisker Catfish 0.02% 3864 Citrine 0.02% 2836 Coarse Stone 0.02% 785 Common Magebloom 0.02% 2770 Copper Ore 0.02% 3356 Crownroyal 0.02% 422 Dwarven Mild 0.02% 6375 Formula: Enchant Bracer - Lesser Spirit 0.02% 6344 Formula: Enchant Bracer - Minor Spirit 0.02% 6347 Formula: Enchant Bracer - Minor Strength 0.02% 6342 Formula: Enchant Chest - Minor Mana 0.02% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.02% 5573 Green Leather Bag 0.02% 5575 Large Green Sack 0.02% 858 Lesser Healing Potion 0.02% 2589 Linen Cloth 0.02% 2455 Minor Mana Potion 0.02% 4542 Moist Cornbread 0.02% 3770 Mutton Chop 0.02% 4297 Pattern: Barbaric Gloves 0.02% 4296 Pattern: Dark Leather Shoulders 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 2406 Pattern: Fine Leather Boots 0.02% 2408 Pattern: Fine Leather Gloves 0.02% 5972 Pattern: Fine Leather Pants 0.02% 2601 Pattern: Gray Woolen Robe 0.02% 4292 Pattern: Green Woolen Bag 0.02% 4346 Pattern: Heavy Woolen Cloak 0.02% 4294 Pattern: Hillman's Belt 0.02% 4293 Pattern: Hillman's Leather Vest 0.02% 4348 Pattern: Phoenix Gloves 0.02% 4349 Pattern: Phoenix Pants 0.02% 6271 Pattern: Red Linen Vest 0.02% 4345 Pattern: Red Woolen Boots 0.02% 4347 Pattern: Reinforced Woolen Shoulders 0.02% 4350 Pattern: Spider Silk Slippers 0.02% 6390 Pattern: Stylish Blue Shirt 0.02% 6391 Pattern: Stylish Green Shirt 0.02% 2407 Pattern: White Leather Jerkin 0.02% 2883 Plans: Deadly Bronze Poniard 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 3612 Plans: Green Iron Gauntlets 0.02% 5543 Plans: Iridescent Hammer 0.02% 6044 Plans: Iron Shield Spike 0.02% 4408 Plans: Mechanical Squirrel 0.02% 3608 Plans: Mighty Iron Hammer 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 5578 Plans: Silvered Bronze Breastplate 0.02% 2882 Plans: Silvered Bronze Shoulders 0.02% 3396 Recipe: Elixir of Lesser Agility 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 3394 Recipe: Elixir of Poison Resistance 0.02% 3393 Recipe: Minor Magic Resistance Potion 0.02% 2555 Recipe: Swiftness Potion 0.02% 2657 Red Leather Bag 0.02% 2835 Rough Stone 0.02% 4412 Schematic: Moonsight Rifle 0.02% 4410 Schematic: Shadow Goggles 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 2775 Silver Ore 0.02% 2449 Snakeroot 0.02% 4606 Spongy Morel 0.02% 3820 Stranglekelp 0.02% 2452 Swiftthistle 0.02% 2771 Tin Ore 0.02% 5574 White Leather Bag 0.02% 3355 Wild Steelbloom 0.02% 2592 Wool Cloth 0.02% 5576 Large Brown Sack 0.02% 1705 Lesser Moonstone 0.02% 857 Large Red Sack 0.02% 4694 Burnished Chain Spaulders 0.01% 804 Large Blue Sack 0.01% 5498 Small Lustrous Pearl 0.01%

Reference loot (169)

1814 Battered Mallet 2.5% 1823 Bludgeoning Cudgel 2.5% 1811 Blunt Claymore 2.5% 2220 Box Shield 2.5% 3378 Brocade Belt 2.5% 3379 Brocade Bracers 2.5% 1774 Brocade Cloak 2.5% 1776 Brocade Cloth Pants 2.5% 1777 Brocade Cloth Shoulderpads 2.5% 1778 Brocade Cloth Vest 2.5% 1775 Brocade Gloves 2.5% 1772 Brocade Shoes 2.5% 1825 Bulky Bludgeon 2.5% 3376 Canvas Belt 2.5% 1764 Canvas Boots 2.5% 3377 Canvas Bracers 2.5% 1766 Canvas Cloak 2.5% 1767 Canvas Gloves 2.5% 1768 Canvas Pants 2.5% 1769 Canvas Shoulderpads 2.5% 1770 Canvas Vest 2.5% 1822 Cedar Walking Staff 2.5% 1813 Chipped Quarterstaff 2.5% 3380 Cross-stitched Belt 2.5% 1780 Cross-stitched Boots 2.5% 3381 Cross-stitched Bracers 2.5% 1782 Cross-stitched Cloak 2.5% 1783 Cross-stitched Gloves 2.5% 1784 Cross-stitched Pants 2.5% 1785 Cross-stitched Shoulderpads 2.5% 1786 Cross-stitched Vest 2.5% 2766 Deft Stiletto 2.5% 2781 Dirty Blunderbuss 2.5% 1819 Gouging Pick 2.5% 1809 Hardened Leather Shoulderpads 2.5% 2765 Hunting Knife 2.5% 1738 Laced Mail Belt 2.5% 1739 Laced Mail Boots 2.5% 1740 Laced Mail Bracers 2.5% 1741 Laced Mail Cloak 2.5% 1742 Laced Mail Gloves 2.5% 1743 Laced Mail Pants 2.5% 1744 Laced Mail Shoulderpads 2.5% 1745 Laced Mail Vest 2.5% 2780 Light Hunting Bow 2.5% 1746 Linked Chain Belt 2.5% 1747 Linked Chain Boots 2.5% 1748 Linked Chain Bracers 2.5% 1749 Linked Chain Cloak 2.5% 1750 Linked Chain Gloves 2.5% 1751 Linked Chain Pants 2.5% 1752 Linked Chain Shoulderpads 2.5% 1753 Linked Chain Vest 2.5% 1830 Long Bastard Sword 2.5% 1827 Meat Cleaver 2.5% 2782 Mishandled Recurve Bow 2.5% 1831 Oaken War Staff 2.5% 2786 Oiled Blunderbuss 2.5% 1815 Ornamental Mace 2.5% 1794 Patched Leather Jerkin 2.5% 1792 Patched Leather Pants 2.5% 1787 Rawhide Belt 2.5% 1788 Rawhide Boots 2.5% 1796 Rawhide Boots 2.5% 1789 Rawhide Bracers 2.5% 1798 Rawhide Cloak 2.5% 1790 Rawhide Cloak 2.5% 1799 Rawhide Gloves 2.5% 1791 Rawhide Gloves 2.5% 1800 Rawhide Pants 2.5% 1793 Rawhide Shoulderpads 2.5% 1802 Rawhide Vest 2.5% 2217 Rectangular Shield 2.5% 1754 Reinforced Chain Belt 2.5% 1755 Reinforced Chain Boots 2.5% 1756 Reinforced Chain Bracers 2.5% 1757 Reinforced Chain Cloak 2.5% 1758 Reinforced Chain Gloves 2.5% 1759 Reinforced Chain Pants 2.5% 1760 Reinforced Chain Shoulderpads 2.5% 1761 Reinforced Chain Vest 2.5% 1826 Rock Maul 2.5% 1824 Shiny War Axe 2.5% 2783 Shoddy Blunderbuss 2.5% 1817 Short Cutlass 2.5% 1829 Short Cutlass 2.5% 1812 Short-handled Battle Axe 2.5% 2216 Simple Buckler 2.5% 2764 Small Dagger 2.5% 2219 Small Round Shield 2.5% 1818 Standard Claymore 2.5% 2785 Stiff Recurve Bow 2.5% 1828 Stone War Axe 2.5% 2221 Targe Shield 2.5% 3778 Taut Compound Bow 2.5% 1806 Tough Cloak 2.5% 1810 Tough Leather Armor 2.5% 1795 Tough Leather Belt 2.5% 1803 Tough Leather Belt 2.5% 1804 Tough Leather Boots 2.5% 1797 Tough Leather Bracers 2.5% 1805 Tough Leather Bracers 2.5% 1807 Tough Leather Gloves 2.5% 1808 Tough Leather Pants 2.5% 1801 Tough Leather Shoulderpads 2.5% 2222 Tower Shield 2.5% 1816 Unbalanced Axe 2.5% 1821 Warped Blade 2.5% 1820 Wooden Maul 2.5% 3039 Archer's Longbow 0.5% 3195 Barbaric Battle Axe 0.5% 3198 Battering Hammer 0.5% 3199 Battle Slayer 0.5% 4998 Blood Ring 0.5% 3306 Brackwater Vest 0.5% 6380 Burnished Buckler 0.5% 2991 Burnished Chain Boots 0.5% 3211 Burnished Chain Bracers 0.5% 4695 Burnished Chain Cloak 0.5% 4697 Burnished Chain Girdle 0.5% 2992 Burnished Chain Gloves 0.5% 2990 Burnished Chain Leggings 0.5% 2989 Burnished Chain Tunic 0.5% 3655 Burnished Shield 0.5% 3313 Ceremonial Leather Tunic 0.5% 3740 Decapitating Sword 0.5% 3196 Edged Bastard Sword 0.5% 4708 Flameweave Belt 0.5% 3065 Flameweave Boots 0.5% 3647 Flameweave Bracers 0.5% 6381 Flameweave Cloak 0.5% 3066 Flameweave Gloves 0.5% 6382 Forest Leather Belt 0.5% 3057 Forest Leather Boots 0.5% 3202 Forest Leather Bracers 0.5% 4710 Forest Leather Cloak 0.5% 3058 Forest Leather Gloves 0.5% 4709 Forest Leather Mantle 0.5% 790 Forester's Axe 0.5% 6383 Glinting Buckler 0.5% 4706 Glinting Scale Cloak 0.5% 4568 Grunt Axe 0.5% 3040 Hunter's Muzzle Loader 0.5% 2987 Inscribed Leather Boots 0.5% 2985 Inscribed Leather Breastplate 0.5% 2988 Inscribed Leather Gloves 0.5% 2986 Inscribed Leather Pants 0.5% 4576 Light Bow 0.5% 4575 Medicine Staff 0.5% 2078 Northern Shortsword 0.5% 3193 Oak Mallet 0.5% 3310 Runic Cloth Vest 0.5% 2984 Seer's Gloves 0.5% 2982 Seer's Pants 0.5% 2981 Seer's Robe 0.5% 4699 Seer's Sash 0.5% 789 Stout Battlehammer 0.5% 5207 Twilight Wand 0.5% 3184 Wavy Blladed Knife 0.5% 2879 Antipodean Rod 0.01% 2236 Blackfang 0.01% 2194 Diamond Hammer 0.01% 2911 Keller's Girdle 0.01% 935 Night Watch Shortsword 0.01% 3021 Ranger Bow 0.01% 2059 Sentry Cloak 0.01% 2256 Skeletal Club of Pain 0.01% 1121 Thick-soled Boots 0.01% 890 Twisted Chanter's Staff 0.01%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 1024);
Field Value
entry 1024
display_id1 188
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Bluegill Murloc
subname
static_flags 0x10080000: Amphibious
gossip_menu_id 0
level_min 20
level_max 21
faction 18: Murloc
npc_flags None
speed_walk 1
speed_run 1.14286
scale 0
detection_range 18
call_for_help_range 5
leash_range 0
rank 0: Normal
xp_multiplier 1
damage_school 0: Normal
damage_variance 0.14
damage_multiplier 1
health_multiplier 1.02
mana_multiplier 1
armor_multiplier 1
base_attack_time 2 sec
ranged_attack_time 2 sec
unit_class 1
unit_flags 0
dynamic_flags 0
beast_family 0
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 7: Humanoid
type_flags 0
loot_id 1024
pickpocket_loot_id 1024
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 30
shadow_res 0
arcane_res 0
spell_id1 -
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 0
auras
gold_min 10c
gold_max 71c
ai_name EventAI
movement_type 1: Random
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 1024
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name