Freezing Ghoul

Creature

General

Creature model for display ID 547
Field Value
entry 1796
display_id1 547
level_min 55
faction 21: Undead, Scourge
npc_flags None
health_multiplier 1.35
mana_multiplier 1

Spawn points — Eastern Kingdoms (26)

1472.79 -1931.67 60.2077 0 [Random: 5 yards]
1494.52 -1895.06 60.0306 0 [Random: 3 yards]
1479.98 -1903.58 59.7526 0 [Random: 3 yards]
1439.15 -1864.47 58.8058 0 [Random: 10 yards]
1523.57 -1849.63 60.9699 0 [Random: 5 yards]
1449.13 -1846.6 58.6686 0 [Random: 10 yards]
1514.06 -1868.82 59.2271 0 [Random: 5 yards]
1512.2 -1833.83 61.7444 0 [Random: 5 yards]
1444.68 -1910.35 60.1867 0 [Random: 10 yards]
1561.66 -1904.53 58.2853 0 [Random: 10 yards]
1420.06 -1897.65 62.5144 0 [Random: 3 yards]
1490.67 -1816.92 60.5182 0 [Random: 5 yards]
1469.97 -1877.12 58.8102 0 [Random: 3 yards]
1417.97 -1876.85 59.1394 0 [Random: 3 yards]
1460.6 -1961.98 59.6732 0 [Random: 10 yards]
1498.21 -1872.28 58.7943 0 [Random: 3 yards]
1453.64 -1818.3 58.6678 0 [Random: 10 yards]
1486.4 -1933.12 61.1098 0 [Random: 3 yards]
1444.57 -1879.98 58.8036 0 [Random: 10 yards]
1476.47 -1850.78 58.8697 0 [Random: 3 yards]
1430.74 -1889.53 59.3894 0 [Random: 3 yards]
1539.68 -1860.39 60.2235 0 [Random: 5 yards]
1532.36 -1825.93 61.6615 0 [Random: 5 yards]
1420.16 -1851.68 58.997 0 [Random: 10 yards]
1544.94 -1875.5 58.3936 0 [Random: 10 yards]
1508.95 -1917.18 59.4825 0 [Random: 3 yards]

Reference loot (83)

4025 Balanced Long Bow 2.5% 3989 Blocking Targe 2.5% 4021 Blunting Mace 2.5% 3990 Crested Buckler 2.5% 3936 Crochet Belt 2.5% 3937 Crochet Boots 2.5% 3938 Crochet Bracers 2.5% 3939 Crochet Cloak 2.5% 3940 Crochet Gloves 2.5% 3941 Crochet Pants 2.5% 3942 Crochet Shoulderpads 2.5% 3943 Crochet Vest 2.5% 4022 Crushing Maul 2.5% 3987 Deflecting Tower 2.5% 4023 Fine Pointed Dagger 2.5% 4019 Heavy Flint Axe 2.5% 4024 Heavy War Staff 2.5% 3999 Laminated Scale Armor 2.5% 3992 Laminated Scale Belt 2.5% 3993 Laminated Scale Boots 2.5% 3994 Laminated Scale Bracers 2.5% 3995 Laminated Scale Cloak 2.5% 3996 Laminated Scale Gloves 2.5% 3997 Laminated Scale Pants 2.5% 3998 Laminated Scale Shoulderpads 2.5% 4007 Overlinked Chain Armor 2.5% 4000 Overlinked Chain Belt 2.5% 4001 Overlinked Chain Boots 2.5% 4002 Overlinked Chain Bracers 2.5% 4003 Overlinked Chain Cloak 2.5% 4004 Overlinked Chain Gloves 2.5% 4005 Overlinked Chain Pants 2.5% 4006 Overlinked Chain Shoulderpads 2.5% 3986 Protective Pavise 2.5% 4026 Sentinel Musket 2.5% 4017 Sharp Shortsword 2.5% 3972 Smooth Cloak 2.5% 3976 Smooth Leather Armor 2.5% 3969 Smooth Leather Belt 2.5% 3970 Smooth Leather Boots 2.5% 3971 Smooth Leather Bracers 2.5% 3973 Smooth Leather Gloves 2.5% 3974 Smooth Leather Pants 2.5% 3975 Smooth Leather Shoulderpads 2.5% 4020 Splintering Battle Axe 2.5% 3964 Thick Cloak 2.5% 3961 Thick Leather Belt 2.5% 3962 Thick Leather Boots 2.5% 3963 Thick Leather Bracers 2.5% 3965 Thick Leather Gloves 2.5% 3966 Thick Leather Pants 2.5% 3967 Thick Leather Shoulderpads 2.5% 3968 Thick Leather Tunic 2.5% 3944 Twill Belt 2.5% 3945 Twill Boots 2.5% 3946 Twill Bracers 2.5% 3947 Twill Cloak 2.5% 3948 Twill Gloves 2.5% 3949 Twill Pants 2.5% 3950 Twill Shoulderpads 2.5% 3951 Twill Vest 2.5% 4018 Whetted Claymore 2.5% 1203 Aegis of Stormwind 0.01% 5266 Eye of Adaegus 0.01% 4696 Lapidis Tankard of Tidesippe 0.01% 1721 Mithril Warhammer 0.01% 1973 Orb of Deception 0.01% 1607 Soulkeeper 0.01% 811 Axe of the Deep Woods 0% 647 Destiny 0% 2099 Dwarven Hand Cannon 0% 3075 Eye of Flame 0% 942 Freezing Band 0% 812 Glowing Brightwood Staff 0% 810 Hammer of the Northern Wind 0% 2245 Helm of Narv 0% 2824 Hurricane 0% 2244 Krol Blade 0% 833 Lifestone 0% 2246 Myrmidon's Signet 0% 2163 Shadowblade 0% 1168 Skullflame Shield 0% 2915 Taran Icebreaker 0%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 1796);
Field Value
entry 1796
display_id1 547
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Freezing Ghoul
subname
static_flags None
gossip_menu_id 0
level_min 55
level_max 56
faction 21: Undead, Scourge
npc_flags None
speed_walk 0.777776
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.35
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 6: Undead
type_flags 0
loot_id 1796
pickpocket_loot_id 1796
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 150
shadow_res 0
arcane_res 0
spell_id1 20005 (not found)
spell_id2 16803 (not found)
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 0
auras
gold_min 1s 22c
gold_max 8s 7c
ai_name EventAI
movement_type 1: Random
inhabit_type Ground
civilian 0
racial_leader 0
regeneration 3
equipment_id 0
trainer_id 0
vendor_id 0
mechanic_immune_mask 0x800010: Fear, Horror
school_immune_mask 0
flags_extra None
script_name