Murloc Minor Oracle

Creature

General

Creature model for display ID 486
Field Value
entry 456
display_id1 486
level_min 13
faction 18: Murloc
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Eastern Kingdoms (50)

-9789.81 1816.33 7.88402 0 [Random: 3 yards]
-9790.02 1836.2 -2.06848 0 [Random: 5 yards]
-9800.66 1822.51 4.03045 0 [Random: 5 yards]
-9788.99 1823.17 -8.06371 0 [Idle]
-9770.04 1818.43 -4.82148 0 [Idle]
-9770.69 1807.24 1.94291 0 [Idle]
-9776.22 1828.67 0.233093 0 [Idle]
-9818.31 1842.65 1.81078 0 [Random: 3 yards]
-9776.35 1812.31 10.7871 0 [Random: 3 yards]
-9672.34 1513.39 14.1054 0 [Random: 5 yards]
-9667.69 1538.59 10.589 0 [Random: 10 yards]
-9780.57 1684.74 7.60068 0 [Random: 10 yards]
-9768.37 1714.89 3.45522 0 [Random: 10 yards]
-9759.5 1650.8 9.76584 0 [Random: 10 yards]
-9733.4 1669.21 3.39156 0 [Random: 10 yards]
-9755.74 1697.16 1.89156 0 [Random: 10 yards]
-9777.88 1658.88 10.8996 0 [Random: 10 yards]
-9743.09 1656.23 7.69151 0 [Random: 10 yards]
-9756.8 1675.25 6.26656 0 [Random: 10 yards]
-9783.95 1708.12 8.11724 0 [Random: 10 yards]
-9926.85 1762.97 13.6785 0 [Random: 5 yards]
-9809.17 1864.33 -16.7733 0 [Random: 5 yards]
-9790.04 1830.64 -10.198 0 [Idle]
-9795.21 1790.53 -4.07209 0 [Random: 5 yards]
-9798.57 1842.76 -3.44893 0 [Random: 3 yards]
-9791.47 1826.97 5.37233 0 [Idle]
-9753.35 1845.93 -16.4015 0 [Random: 10 yards]
-9836.86 1828.98 -6.16082 0 [Random: 5 yards]
-9766.46 1813.28 2.43849 0 [Random: 5 yards]
-9781.9 1830.19 -11.1869 0 [Random: 5 yards]
-9811.94 1843.51 -4.54433 0 [Idle]
-9682.83 1546.78 12.964 0 [Random: 10 yards]
-9829.85 1803.09 -1.85927 0 [Random: 5 yards]
-9807.28 1838.85 -8.1311 0 [Idle]
-9798.47 1844.69 4.57742 0 [Random: 3 yards]
-9777.56 1822.77 10.1445 0 [Random: 3 yards]
-9771.19 1816.85 1.46678 0 [Random: 5 yards]
-9765.1 1808.33 -4.73589 0 [Idle]
-9802.37 1846.35 -14.8858 0 [Random: 5 yards]
-9806.18 1826.43 -4.46597 0 [Random: 3 yards]
-9687.95 1529.92 13.8549 0 [Idle]
-9687.61 1522.07 14.2513 0 [Idle]
-9590.83 1511.04 0.098443 0 [Idle]
-9626.67 1547.82 0.748849 0 [Random: 10 yards]
-9589.85 1503.48 -0.147509 0 [Idle]
-9637.87 1573.42 0.748535 0 [Idle]
-9609.7 1519.33 2.38142 0 [Random: 5 yards]
-9665.49 1527.82 10.6811 0 [Random: 5 yards]
-9783.84 1836.71 -1.26479 0 [Idle]
-9615.7 1493.02 6.76234 0 [Random: 10 yards]

Loot (63)

1468 Murloc Fin 76.71% 5523 Small Barnacled Clam 34.21% 730 Murloc Eye 32.84% 6289 Raw Longjaw Mud Snapper 5.41% 1179 Ice Cold Milk 2.7% 5503 Clam Meat 2.08% 858 Lesser Healing Potion 1.43% 1357 Captain Sander's Treasure Map 0.75% 818 Tigerseye 0.66% 1181 Scroll of Spirit 0.58% 3013 Scroll of Spirit Armor 0.58% 955 Scroll of Intellect 0.5% 1180 Scroll of Stamina 0.24% 4689 Hunting Cloak 0.18% 774 Malachite 0.18% 2971 Magister's Shoes 0.16% 2972 Magister's Gloves 0.16% 2698 Recipe: Cooked Crab Claw 0.16% 1210 Shadowgem 0.16% 3643 Magister's Bracers 0.13% 4683 Magister's Cloak 0.13% 4684 Magister's Sash 0.13% 3207 Hunting Bracers 0.1% 2406 Pattern: Fine Leather Boots 0.1% 2975 Hunting Boots 0.1% 2598 Pattern: Red Linen Robe 0.08% 4690 Hunting Belt 0.07% 2979 Veteran Boots 0.07% 3213 Veteran Bracers 0.07% 6342 Formula: Enchant Chest - Minor Mana 0.06% 2287 Haunch of Meat 0.06% 5574 White Leather Bag 0.06% 4537 Tel'Abim Banana 0.05% 4541 Freshly Baked Bread 0.04% 5573 Green Leather Bag 0.04% 118 Minor Healing Potion 0.04% 4605 Red-speckled Mushroom 0.04% 765 Silverleaf 0.04% 856 Blue Leather Bag 0.03% 5498 Small Lustrous Pearl 0.03% 4677 Veteran Cloak 0.03% 4678 Veteran Girdle 0.03% 2770 Copper Ore 0.02% 414 Dalaran Sharp 0.02% 6344 Formula: Enchant Bracer - Minor Spirit 0.02% 6347 Formula: Enchant Bracer - Minor Strength 0.02% 2589 Linen Cloth 0.02% 2455 Minor Mana Potion 0.02% 2408 Pattern: Fine Leather Gloves 0.02% 4292 Pattern: Green Woolen Bag 0.02% 4346 Pattern: Heavy Woolen Cloak 0.02% 4293 Pattern: Hillman's Leather Vest 0.02% 6271 Pattern: Red Linen Vest 0.02% 2407 Pattern: White Leather Jerkin 0.02% 3609 Plans: Copper Chain Vest 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 4408 Plans: Mechanical Squirrel 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 2555 Recipe: Swiftness Potion 0.02% 2657 Red Leather Bag 0.02% 2835 Rough Stone 0.02% 2449 Snakeroot 0.02% 3820 Stranglekelp 0.02%

Reference loot (111)

3374 Calico Belt 2.5% 1495 Calico Boots 2.5% 3375 Calico Bracers 2.5% 1497 Calico Cloak 2.5% 1498 Calico Gloves 2.5% 1499 Calico Pants 2.5% 1501 Calico Vest 2.5% 2778 Cheap Blunderbuss 2.5% 1512 Crude Battle Axe 2.5% 2777 Feeble Shortbow 2.5% 2763 Fisherman Knife 2.5% 1510 Heavy Club 2.5% 1513 Old Greatsword 2.5% 1502 Patched Leather Belt 2.5% 1503 Patched Leather Boots 2.5% 1504 Patched Leather Bracers 2.5% 1505 Patched Leather Cloak 2.5% 1506 Patched Leather Gloves 2.5% 1507 Patched Leather Pants 2.5% 1509 Patched Leather Vest 2.5% 1515 Rough Wooden Staff 2.5% 1514 Rusty Warhammer 2.5% 1511 Warped Shortsword 2.5% 2214 Wooden Buckler 2.5% 2215 Wooden Shield 2.5% 1516 Worn Hatchet 2.5% 1730 Worn Mail Belt 2.5% 1731 Worn Mail Boots 2.5% 1732 Worn Mail Bracers 2.5% 1733 Worn Mail Cloak 2.5% 1734 Worn Mail Gloves 2.5% 1735 Worn Mail Pants 2.5% 1737 Worn Mail Vest 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% 3211 Burnished Chain Bracers 0.5% 4695 Burnished Chain Cloak 0.5% 2962 Burnt Leather Pants 0.5% 2961 Burnt Leather Vest 0.5% 2140 Carving Knife 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% 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% 4701 Inscribed Leather Cloak 0.5% 2988 Inscribed Leather Gloves 0.5% 2958 Journeyman's Pants 0.5% 2957 Journeyman's Vest 0.5% 2970 Magister's Pants 0.5% 2969 Magister's Vest 0.5% 4575 Medicine Staff 0.5% 2078 Northern Shortsword 0.5% 727 Notched Shortsword 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% 4561 Scalping Tomahawk 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% 4699 Seer's Sash 0.5% 2079 Sergeant's Warhammer 0.5% 4562 Severing Axe 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% 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% 2966 Warrior's Pants 0.5% 2965 Warrior's Tunic 0.5%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 456);
Field Value
entry 456
display_id1 486
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Murloc Minor Oracle
subname
static_flags None
gossip_menu_id 0
level_min 13
level_max 14
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
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 456
pickpocket_loot_id 456
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 9532 (not found)
spell_id2 332: Restoration
spell_id3 -
spell_id4 -
spell_list_id 4560
pet_spell_list_id 0
auras
gold_min 8c
gold_max 24c
ai_name EventAI
movement_type 1: Random
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 456
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name