Database

Alpha 0.5.3

Searing Ghoul

Creature

General

Creature model for display ID 414
Field Value
entry 1795
display_id1 414
level_min 54
faction 21: Undead, Scourge
npc_flags None
health_multiplier 1.35
mana_multiplier 1

Spawn points — Eastern Kingdoms (79)

1377.89 -1280.29 71.437 0 [Random: 10 yards]
1406.83 -1408.34 70.73 0 [Random: 5 yards]
1232.55 -1559.56 70.693 0 [Random: 5 yards]
1445.2 -1742.94 81.569 0 [Random: 3 yards]
1417.24 -1215.97 75.4773 0 [Random: 3 yards]
1393.87 -1534.93 69.489 0 [Random: 10 yards]
1369.11 -1502.66 69.489 0 [Idle]
1396.39 -1501.01 69.489 0 [Idle]
1411.78 -1521.35 70.135 0 [Random: 10 yards]
1449.57 -1247.65 69.8898 0 [Random: 3 yards]
1387.67 -1392.5 72.953 0 [Idle]
1279.41 -1414.14 71.295 0 [Random: 10 yards]
1265.94 -1570.99 70.592 0 [Random: 3 yards]
1510.37 -1710.45 71.691 0 [Random: 5 yards]
1517.02 -1642.81 72.353 0 [Random: 5 yards]
1291.8 -1338.2 76.387 0 [Idle]
1361.98 -1522.74 69.414 0 [Random: 10 yards]
1380.68 -1553.87 69.489 0 [Idle]
1343.54 -1346.84 69.506 0 [Random: 10 yards]
1216.18 -1519.31 72.076 0 [Random: 3 yards]
1247.6 -1416.84 70.478 0 [Idle]
1328.38 -1322.12 76.39 0 [Idle]
1577.7 -1575.06 71.179 0 [Random: 3 yards]
1345.53 -1406.07 71.728 0 [Random: 5 yards]
1322.79 -1383.91 69.489 0 [Random: 5 yards]
1485.37 -1679.01 77.127 0 [Idle]
1614.04 -1444.54 63.5273 0 [Random: 10 yards]
1293.32 -1593.1 72.417 0 [Idle]
1545.84 -1552.33 71.471 0 [Random: 10 yards]
1463.56 -1343.76 73.425 0 [Random: 5 yards]
1344.3 -1213.78 80.838 0 [Idle]
1351.56 -1648.44 68.447 0 [Random: 10 yards]
1415.76 -1649.27 67.9841 0 [Random: 10 yards]
1470.37 -1430.04 77.144 0 [Idle]
1541.69 -1587.52 70.708 0 [Random: 10 yards]
1402.84 -1565.1 71.287 0 [Random: 5 yards]
1414.53 -1688.59 70.275 0 [Random: 10 yards]
1301.64 -1431.73 71.247 0 [Idle]
1462.42 -1332.71 71.992 0 [Random: 5 yards]
1289.02 -1448.26 69.75 0 [Idle]
1431.75 -1517.05 72.339 0 [Random: 10 yards]
1256.05 -1514.67 71.41 0 [Idle]
1582.02 -1511.56 77.785 0 [Random: 5 yards]
1350.09 -1382.61 72.115 0 [Random: 10 yards]
1418.87 -1620.5 71.812 0 [Random: 10 yards]
1352.47 -1320.15 69.474 0 [Random: 10 yards]
1242.33 -1384.4 73.67 0 [Random: 10 yards]
1504.74 -1671.55 77.055 0 [Random: 3 yards]
1481.26 -1553.53 73.424 0 [Random: 5 yards]
1490.69 -1397.43 80.057 0 [Random: 5 yards]
1380.55 -1243.18 72.329 0 [Random: 3 yards]
1573.79 -1675.01 69.386 0 [Random: 10 yards]
1433.27 -1234.64 73.304 0 [Random: 3 yards]
1363.9 -1366.71 72.552 0 [Random: 3 yards]
1291.11 -1394.41 73.73 0 [Random: 5 yards]
1332.71 -1511.9 71.111 0 [Random: 5 yards]
1479.75 -1744.31 64.3249 0 [Random: 3 yards]
1517.68 -1616.02 71.852 0 [Random: 10 yards]
1291.96 -1476.07 70.991 0 [Random: 5 yards]
1593.07 -1551.77 78.14 0 [Random: 3 yards]
1588.34 -1660.22 64.82 0 [Random: 3 yards]
1419.89 -1414.38 69.455 0 [Random: 10 yards]
1252.9 -1347.71 75.604 0 [Random: 10 yards]
1481.72 -1583.72 75.493 0 [Random: 10 yards]
1547.83 -1497.26 73.809 0 [Idle]
1244.85 -1481.84 71.327 0 [Random: 3 yards]
1409.3 -1480.49 69.455 0 [Random: 5 yards]
1407.44 -1329.17 71.192 0 [Random: 3 yards]
1246.55 -1314.9 72.258 0 [Random: 5 yards]
1295.47 -1308.58 76.323 0 [Idle]
1312.68 -1545.57 70.558 0 [Random: 10 yards]
1558.83 -1454.51 83.308 0 [Idle]
1454.11 -1321.38 71.702 0 [Random: 5 yards]
1246.74 -1453.32 71.417 0 [Idle]
1514.86 -1518.22 78.543 0 [Random: 5 yards]
1311.41 -1451.09 70.149 0 [Random: 5 yards]
1387.08 -1743.09 85.965 0 [Random: 5 yards]
1347.92 -1623.18 65.915 0 [Random: 10 yards]
1429.05 -1349.13 76.567 0 [Idle]

Spells they cast (1)

3140 Fireball

Loot (21)

4425 Scroll of Agility III 0.26% 4426 Scroll of Strength III 0.25% 5758 Mithril Lockbox 0.05% 5759 Thorium Lockbox 0.05% 4500 Traveler's Backpack 0.04% 3858 Mithril Ore 0.03% 4305 Bolt of Silk Cloth 0.02% 3864 Citrine 0.02% 3818 Fadeleaf 0.02% 2776 Gold Ore 0.02% 3821 Goldthorn 0.02% 1710 Greater Healing Potion 0.02% 6149 Greater Mana Potion 0.02% 2772 Iron Ore 0.02% 3358 Khadgar's Whisker 0.02% 4338 Mageweave Cloth 0.02% 3827 Mana Potion 0.02% 3395 Recipe: Limited Invulnerability Potion 0.02% 4306 Silk Cloth 0.02% 2449 Snakeroot 0.02% 3928 Superior Healing Potion 0.02%

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%

Pickpocketing loot (2)

3419 Red Rose 9.62% 3928 Superior Healing Potion 2.06%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 1795);
Field Value
entry 1795
display_id1 414
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Searing Ghoul
subname
static_flags None
gossip_menu_id 0
level_min 54
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 2
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 1795
pickpocket_loot_id 1795
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 13376 (not found)
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 17950
pet_spell_list_id 0
auras
gold_min 1s 21c
gold_max 8s 25c
ai_name EventAI
movement_type 0: Idle
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