Greymist Oracle

Creature

General

Creature model for display ID 3615
Field Value
entry 2207
display_id1 3615
level_min 18
faction 18: Murloc
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Kalimdor (30)

7847.52 -634.231 -20.859 1 [Random: 5 yards]
7842.23 -647.137 -20.858 1 [Random: 5 yards]
4504.81 902.006 1.226 1 [Idle]
4596.74 920.727 1.063 1 [Idle]
4596.63 910.044 -0.101 1 [Idle]
4530.33 883.491 -0.75 1 [Idle]
4602.19 911.433 -0.76 1 [Idle]
7785.44 -690.589 -11.859 1 [Random: 5 yards]
7786.5 -661.654 -19.3308 1 [Random: 5 yards]
4669.05 869.903 1.21204 1 [Random: 3 yards]
4669.98 883.959 -1.03256 1 [Random: 10 yards]
4612.17 896.245 -3.255 1 [Random: 10 yards]
4495.58 902.892 5.746 1 [Idle]
4511.78 884.784 -1.817 1 [Idle]
7843.45 -656.608 -20.859 1 [Random: 5 yards]
7835.27 -637.334 -20.859 1 [Random: 5 yards]
4712.5 866.014 2.658 1 [Random: 3 yards]
4685.92 886.589 0.031 1 [Random: 3 yards]
4527.36 904.167 -0.151 1 [Idle]
4696.18 870.938 0.087038 1 [Random: 3 yards]
7794.87 -682.31 -11.993 1 [Random: 5 yards]
7772.01 -675.13 -15.862 1 [Random: 5 yards]
7803.45 -671.911 -17.467 1 [Random: 5 yards]
7844.2 -663.655 -20.87 1 [Random: 5 yards]
4687.95 863.727 2.52746 1 [Random: 3 yards]
4675.84 857.685 0.515 1 [Random: 3 yards]
4597.29 898.025 -0.354 1 [Idle]
4599.56 890.452 -3.154 1 [Idle]
4494.82 885.169 1.632 1 [Idle]
4493.62 894.452 -0.913 1 [Idle]

Reference loot (94)

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% 3039 Archer's Longbow 0.5% 3195 Barbaric Battle Axe 0.5% 3198 Battering Hammer 0.5% 3199 Battle Slayer 0.5% 5212 Blazing Wand 0.5% 3305 Brackwater Leggings 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% 3315 Ceremonial Leather Pants 0.5% 3313 Ceremonial Leather Tunic 0.5% 3196 Edged Bastard Sword 0.5% 3065 Flameweave Boots 0.5% 3647 Flameweave Bracers 0.5% 6381 Flameweave Cloak 0.5% 6382 Forest Leather Belt 0.5% 4710 Forest Leather Cloak 0.5% 790 Forester's Axe 0.5% 4568 Grunt Axe 0.5% 3040 Hunter's Muzzle Loader 0.5% 2974 Hunting Pants 0.5% 2973 Hunting Vest 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% 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% 4567 Short Bastard Sword 0.5% 789 Stout Battlehammer 0.5% 5207 Twilight Wand 0.5% 2977 Veteran Armor 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` = 2207);
Field Value
entry 2207
display_id1 3615
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Greymist Oracle
subname
static_flags 0x10080000: Amphibious
gossip_menu_id 0
level_min 18
level_max 19
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 2207
pickpocket_loot_id 0
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 18089 (not found)
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 22070
pet_spell_list_id 0
auras
gold_min 21c
gold_max 45c
ai_name EventAI
movement_type 1: Random
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 2207
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name