Murloc Oracle

Creature

General

Creature model for display ID 529
Field Value
entry 517
display_id1 529
level_min 16
faction 18: Murloc
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Eastern Kingdoms (58)

-11004.6 2046.43 10.9429 0 [Random: 10 yards]
-11041 2021.3 11.2134 0 [Random: 5 yards]
-10691.3 2072.81 6.17765 0 [Random: 10 yards]
-10664.9 2074.58 7.22251 0 [Random: 10 yards]
-11340.9 1835.32 8.96161 0 [Random: 10 yards]
-10807.6 2086.28 7.45641 0 [Random: 5 yards]
-11033.9 2047.56 9.52603 0 [Random: 10 yards]
-11038.3 2079.93 1.87699 0 [Random: 5 yards]
-10624.3 2057.91 12.6655 0 [Random: 10 yards]
-11137 2102.61 -6.99985 0 [Random: 10 yards]
-11104.8 2035.63 0.80971 0 [Random: 10 yards]
-11107.2 2077.05 -2.15916 0 [Random: 10 yards]
-11120.2 2110.28 -5.86168 0 [Random: 10 yards]
-11139.3 2039.28 0.277747 0 [Random: 10 yards]
-11118.2 2089.5 -4.631 0 [Idle]
-11097.3 2067.77 1.10995 0 [Idle]
-11095.4 2094.78 -0.155 0 [Random: 10 yards]
-11072.9 2099.11 1.1694 0 [Random: 10 yards]
-11144.9 2090.64 -7.18677 0 [Random: 10 yards]
-10799.8 2038.96 11.2187 0 [Idle]
-10798.5 2054.77 10.7607 0 [Idle]
-10797.9 2045.54 10.5618 0 [Idle]
-11014.4 2036.97 10.2512 0 [Idle]
-11016.8 2030.12 10.7599 0 [Idle]
-11009.9 2030.85 11.0509 0 [Idle]
-10787.3 2078.2 8.63765 0 [Random: 10 yards]
-10767.5 2046.83 15.0832 0 [Random: 10 yards]
-10776.5 2103.37 1.69464 0 [Random: 10 yards]
-11414.4 1821.84 -1.18796 0 [Random: 5 yards]
-11367.2 1806.27 8.11069 0 [Random: 10 yards]
-11371.4 1796.91 8.50641 0 [Idle]
-11365.1 1799.64 8.41003 0 [Idle]
-10647 2074.4 7.70761 0 [Random: 10 yards]
-10770.8 2062.44 10.7035 0 [Random: 10 yards]
-10751.9 2057.75 12.6267 0 [Random: 10 yards]
-11127.7 2123.97 -10.9382 0 [Random: 10 yards]
-11162.7 2061.85 -3.56641 0 [Random: 10 yards]
-11082.8 2079.71 11.3781 0 [Idle]
-11118.6 2103.77 -6.40406 0 [Random: 10 yards]
-11135.5 2065.5 -4.70716 0 [Random: 10 yards]
-11073.6 2069.53 6.38764 0 [Random: 10 yards]
-11079.7 2085.96 9.63451 0 [Idle]
-11165.7 2037.17 0.362662 0 [Idle]
-10732.2 2188.65 16.507 0 [Idle]
-11379.6 1829.08 2.5493 0 [Random: 10 yards]
-10757.5 2082.63 5.41489 0 [Random: 10 yards]
-10651.7 2053.26 7.76899 0 [Random: 10 yards]
-10659.6 2042.48 8.33358 0 [Idle]
-10665.5 2042.45 7.97644 0 [Idle]
-10678.2 2061.01 7.84587 0 [Random: 10 yards]
-11390.7 1805.56 7.73824 0 [Random: 10 yards]
-10634.2 2045.94 11.2488 0 [Random: 10 yards]
-11404.5 1773.51 9.03428 0 [Random: 10 yards]
-11365.7 1779.55 9.82954 0 [Random: 10 yards]
-11405.3 1807.93 4.98193 0 [Idle]
-11390 1789.89 8.38229 0 [Idle]
-11392.9 1790.27 8.36698 0 [Idle]
-11411 1806.41 4.07039 0 [Idle]

Spells they cast (1)

Loot (64)

1468 Murloc Fin 43.01% 5523 Small Barnacled Clam 36.6% 730 Murloc Eye 36.48% 5784 Slimy Murloc Scale 17% 6289 Raw Longjaw Mud Snapper 4.24% 1179 Ice Cold Milk 2.2% 5503 Clam Meat 1.62% 858 Lesser Healing Potion 1.5% 1405 Foamspittle Staff 1% 1357 Captain Sander's Treasure Map 0.75% 2455 Minor Mana Potion 0.56% 1180 Scroll of Stamina 0.54% 955 Scroll of Intellect 0.46% 3012 Scroll of Agility 0.38% 954 Scroll of Strength 0.38% 1210 Shadowgem 0.38% 2770 Copper Ore 0.24% 1206 Moss Agate 0.12% 818 Tigerseye 0.12% 2835 Rough Stone 0.1% 5573 Green Leather Bag 0.06% 2698 Recipe: Cooked Crab Claw 0.06% 5498 Small Lustrous Pearl 0.05% 6347 Formula: Enchant Bracer - Minor Strength 0.04% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.04% 4293 Pattern: Hillman's Leather Vest 0.04% 4345 Pattern: Red Woolen Boots 0.04% 5574 White Leather Bag 0.03% 856 Blue Leather Bag 0.02% 2996 Bolt of Linen Cloth 0.02% 2450 Briarthorn 0.02% 2453 Bruiseweed 0.02% 4364 Coarse Blasting Powder 0.02% 785 Common Magebloom 0.02% 414 Dalaran Sharp 0.02% 6344 Formula: Enchant Bracer - Minor Spirit 0.02% 6342 Formula: Enchant Chest - Minor Mana 0.02% 4541 Freshly Baked Bread 0.02% 4359 Handful of Copper Bolts 0.02% 2287 Haunch of Meat 0.02% 4700 Inscribed Leather Spaulders 0.02% 774 Malachite 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 2406 Pattern: Fine Leather Boots 0.02% 2408 Pattern: Fine Leather Gloves 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% 6271 Pattern: Red Linen Vest 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% 2881 Plans: Runed Copper Breastplate 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 3394 Recipe: Elixir of Poison Resistance 0.02% 4605 Red-speckled Mushroom 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 4698 Seer's Mantle 0.02% 2449 Snakeroot 0.02% 2452 Swiftthistle 0.02% 4537 Tel'Abim Banana 0.02% 2657 Red Leather Bag 0.02%

Reference loot (119)

1814 Battered Mallet 2.5% 1811 Blunt Claymore 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% 1813 Chipped Quarterstaff 2.5% 2781 Dirty Blunderbuss 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% 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% 1789 Rawhide Bracers 2.5% 1790 Rawhide Cloak 2.5% 1791 Rawhide Gloves 2.5% 1793 Rawhide Shoulderpads 2.5% 2217 Rectangular Shield 2.5% 1817 Short Cutlass 2.5% 1812 Short-handled Battle Axe 2.5% 2216 Simple Buckler 2.5% 2764 Small Dagger 2.5% 1816 Unbalanced Axe 2.5% 3291 Ancestral Leggings 0.5% 3292 Ancestral Tunic 0.5% 3195 Barbaric Battle Axe 0.5% 3282 Battle Chain Pants 0.5% 3283 Battle Chain Tunic 0.5% 5069 Bent Fire Wand 0.5% 4570 Birchwood Maul 0.5% 5212 Blazing Wand 0.5% 3302 Brackwater Boots 0.5% 3653 Brackwater Buckler 0.5% 3305 Brackwater Leggings 0.5% 3654 Brackwater Shield 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% 3314 Ceremonial Leather Gloves 0.5% 3315 Ceremonial Leather Pants 0.5% 3313 Ceremonial Leather Tunic 0.5% 4577 Compact Shotgun 0.5% 2632 Curved Dagger 0.5% 6267 Disciple's Pants 0.5% 6266 Disciple's Vest 0.5% 2073 Dwarven Hatchet 0.5% 3196 Edged Bastard Sword 0.5% 4568 Grunt Axe 0.5% 3036 Heavy Shortbow 0.5% 3040 Hunter's Muzzle Loader 0.5% 2976 Hunting Gloves 0.5% 2974 Hunting Pants 0.5% 2973 Hunting Vest 0.5% 6337 Infantry Leggings 0.5% 6336 Infantry Tunic 0.5% 6379 Inscribed Leather Belt 0.5% 2987 Inscribed Leather Boots 0.5% 3205 Inscribed Leather Bracers 0.5% 2985 Inscribed Leather Breastplate 0.5% 4701 Inscribed Leather Cloak 0.5% 2988 Inscribed Leather Gloves 0.5% 2986 Inscribed Leather Pants 0.5% 4576 Light Bow 0.5% 2970 Magister's Pants 0.5% 2969 Magister's Vest 0.5% 4575 Medicine Staff 0.5% 2078 Northern Shortsword 0.5% 3193 Oak Mallet 0.5% 6269 Pioneer Trousers 0.5% 6268 Pioneer Tunic 0.5% 2075 Priest's Mace 0.5% 3307 Runic Cloth Boots 0.5% 3308 Runic Cloth Gloves 0.5% 3310 Runic Cloth Vest 0.5% 3309 Runic Loin Cloth 0.5% 2983 Seer's Boots 0.5% 3645 Seer's Bracers 0.5% 6378 Seer's Cape 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% 2079 Sergeant's Warhammer 0.5% 5071 Shadow Wand 0.5% 4567 Short Bastard Sword 0.5% 4564 Spiked Club 0.5% 4569 Staunch Mace 0.5% 4566 Sturdy Quarterstaff 0.5% 3192 Training Sword 0.5% 3287 Tribal Pants 0.5% 3288 Tribal Vest 0.5% 5207 Twilight Wand 0.5% 2977 Veteran Armor 0.5% 3652 Veteran Buckler 0.5% 2980 Veteran Gloves 0.5% 2978 Veteran Leggings 0.5% 3651 Veteran Shield 0.5% 4571 War Knife 0.5% 3184 Wavy Blladed Knife 0.5%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 517);
Field Value
entry 517
display_id1 529
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Murloc Oracle
subname
static_flags 0x10080000: Amphibious
gossip_menu_id 0
level_min 16
level_max 18
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 0.95
health_multiplier 1
mana_multiplier 1
armor_multiplier 1
base_attack_time 2 sec
ranged_attack_time 2 sec
unit_class 2
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 517
pickpocket_loot_id 517
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 9734 (not found)
spell_id2 6074: Renew
spell_id3 4980: Quick Frost Ward
spell_id4 -
spell_list_id 5170
pet_spell_list_id 0
auras
gold_min 10c
gold_max 53c
ai_name EventAI
movement_type 1: Random
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 517
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name