Database

Alpha 0.5.3

Shadowhorn Stag

Creature

General

Creature model for display ID 1991
Field Value
entry 3817
display_id1 1991
level_min 22
faction 189: Creature
npc_flags None
health_multiplier 1.02
mana_multiplier 1

Spawn points — Kalimdor (70)

2577.12 -1331.8 151.48 1 [Random: 15 yards]
1970.87 -579.038 112.508 1 [Random: 3 yards]
2075.69 -526.669 100.156 1 [Random: 5 yards]
2632.97 -1423.21 180.707 1 [Random: 3 yards]
2391.98 -694.825 151.623 1 [Random: 3 yards]
2935.38 -1244.76 190.396 1 [Random: 15 yards]
2753.1 -1242.78 172.849 1 [Random: 5 yards]
2286.51 -939.285 86.8047 1 [Random: 15 yards]
2194.07 -916.772 93.3797 1 [Random: 5 yards]
2735.73 -1195.89 164.726 1 [Random: 15 yards]
1925.15 -481.529 114.499 1 [Random: 5 yards]
2226.83 -969.273 89.3588 1 [Random: 5 yards]
2681.25 -1529.27 208.826 1 [Random: 5 yards]
2584.25 -1249.04 145.567 1 [Random: 15 yards]
2011.87 -607.283 101.978 1 [Random: 15 yards]
2119.27 -529.646 110.777 1 [Random: 5 yards]
2253.2 -1152.72 87.2554 1 [Random: 5 yards]
2330.89 -1029.68 109.335 1 [Random: 5 yards]
2318.73 -981.721 91.5928 1 [Random: 15 yards]
2248.8 -1077.61 106.463 1 [Random: 5 yards]
2533.06 -1463.97 163.013 1 [Random: 5 yards]
2253.85 -562.269 102.872 1 [Random: 15 yards]
2222.21 -552.833 102.454 1 [Random: 15 yards]
2078.69 -435.192 96.6761 1 [Random: 5 yards]
2355.48 -517.081 120.157 1 [Random: 3 yards]
2391.41 -880.808 150.454 1 [Random: 5 yards]
2704.8 -1196.6 160.537 1 [Random: 15 yards]
2801.19 -1171.08 171.143 1 [Random: 5 yards]
2882.65 -1189.58 178.648 1 [Random: 5 yards]
2277.95 -1112.29 95.5275 1 [Random: 5 yards]
2876.64 -1178.3 180.808 1 [Idle]
1921.31 -423.498 106.255 1 [Random: 10 yards]
2350.59 -917.808 96.6732 1 [Random: 3 yards]
2144.89 -723.621 108.262 1 [Random: 5 yards]
2504.29 -1546.59 150.124 1 [Random: 3 yards]
2684.25 -1429.06 194.283 1 [Random: 10 yards]
2644.24 -1200.97 154.895 1 [Random: 5 yards]
2647.83 -1499.03 188.674 1 [Random: 2 yards]
2054.87 -678.462 111.674 1 [Random: 5 yards]
2232.9 -604.037 104.21 1 [Random: 15 yards]
1871.73 -640.883 117.19 1 [Random: 5 yards]
2623.74 -1287.77 149.159 1 [Random: 15 yards]
2293.29 -684.948 139.502 1 [Random: 5 yards]
2552.09 -1503.75 158.614 1 [Random: 15 yards]
2039.83 -773.295 103.686 1 [Random: 5 yards]
2124.95 -957.928 98.8138 1 [Random: 5 yards]
2148.96 -573.959 102.676 1 [Random: 5 yards]
2498.43 -1314.07 135.964 1 [Random: 5 yards]
2454.05 -1642.28 162.593 1 [Random: 5 yards]
2055.54 -512.441 99.8552 1 [Random: 5 yards]
2929.49 -1301.79 203.112 1 [Random: 5 yards]
2414.56 -780.304 121.838 1 [Random: 15 yards]
2329.69 -751.042 113.097 1 [Random: 5 yards]
2196.8 -670.255 127.967 1 [Random: 5 yards]
2258.02 -787.399 109.02 1 [Random: 15 yards]
2009.65 -368.157 99.8312 1 [Random: 15 yards]
2205.78 -779.697 105.724 1 [Random: 15 yards]
2296.9 -466.944 99.612 1 [Random: 15 yards]
2236.11 -812.53 110.747 1 [Random: 15 yards]
2663.02 -1038.33 125.144 1 [Random: 3 yards]
2265.01 -862.158 100.72 1 [Random: 15 yards]
1980.64 -728.288 99.5879 1 [Random: 5 yards]
2803.17 -1271.04 204.158 1 [Random: 5 yards]
2590.89 -1426.69 162.857 1 [Random: 15 yards]
2325.23 -466.488 102.47 1 [Random: 15 yards]
2616.41 -1010.29 120.638 1 [Random: 15 yards]
1940.86 -693.591 112.464 1 [Random: 5 yards]
2522.59 -1104.93 131.297 1 [Random: 15 yards]
2210.76 -1310.19 77.1685 1 [Random: 5 yards]
2447.45 -1546.35 137.242 1 [Random: 10 yards]

Loot (39)

5566 Broken Antler 52.59% 5471 Stag Meat 49.29% 5871 Large Hoof 22.65% 5120 Long Tail Hair 8.2% 1206 Moss Agate 0.12% 857 Large Red Sack 0.06% 6375 Formula: Enchant Bracer - Lesser Spirit 0.04% 804 Large Blue Sack 0.04% 5576 Large Brown Sack 0.04% 1705 Lesser Moonstone 0.04% 1210 Shadowgem 0.04% 5503 Clam Meat 0.02% 2770 Copper Ore 0.02% 3356 Crownroyal 0.02% 6344 Formula: Enchant Bracer - Minor Spirit 0.02% 6347 Formula: Enchant Bracer - Minor Strength 0.02% 5575 Large Green Sack 0.02% 4296 Pattern: Dark Leather Shoulders 0.02% 5972 Pattern: Fine Leather Pants 0.02% 2601 Pattern: Gray Woolen Robe 0.02% 4346 Pattern: Heavy Woolen Cloak 0.02% 4294 Pattern: Hillman's Belt 0.02% 4293 Pattern: Hillman's Leather Vest 0.02% 4348 Pattern: Phoenix Gloves 0.02% 4349 Pattern: Phoenix Pants 0.02% 4345 Pattern: Red Woolen Boots 0.02% 4347 Pattern: Reinforced Woolen Shoulders 0.02% 6390 Pattern: Stylish Blue Shirt 0.02% 6391 Pattern: Stylish Green Shirt 0.02% 2883 Plans: Deadly Bronze Poniard 0.02% 6044 Plans: Iron Shield Spike 0.02% 4412 Plans: Moonsight Rifle 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 4410 Plans: Shadow Goggles 0.02% 5578 Plans: Silvered Bronze Breastplate 0.02% 6211 Recipe: Elixir of Ogre's Strength 0.02% 3394 Recipe: Elixir of Poison Resistance 0.02% 3393 Recipe: Minor Magic Resistance Potion 0.02% 2835 Rough Stone 0.02%

Reference loot (70)

3039 Archer's Longbow 0.5% 3198 Battering Hammer 0.5% 3199 Battle Slayer 0.5% 4998 Blood Ring 0.5% 2991 Burnished Chain Boots 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% 3740 Decapitating Sword 0.5% 4708 Flameweave Belt 0.5% 3065 Flameweave Boots 0.5% 3647 Flameweave Bracers 0.5% 6381 Flameweave Cloak 0.5% 3066 Flameweave Gloves 0.5% 6382 Forest Leather Belt 0.5% 3057 Forest Leather Boots 0.5% 3202 Forest Leather Bracers 0.5% 4710 Forest Leather Cloak 0.5% 3058 Forest Leather Gloves 0.5% 4709 Forest Leather Mantle 0.5% 790 Forester's Axe 0.5% 6383 Glinting Buckler 0.5% 4706 Glinting Scale Cloak 0.5% 4568 Grunt Axe 0.5% 2985 Inscribed Leather Breastplate 0.5% 2986 Inscribed Leather Pants 0.5% 4576 Light Bow 0.5% 3193 Oak Mallet 0.5% 2982 Seer's Pants 0.5% 2981 Seer's Robe 0.5% 789 Stout Battlehammer 0.5% 5207 Twilight Wand 0.5% 3184 Wavy Blladed Knife 0.5% 4999 Azora's Will 0.05% 5001 Band of Vitality 0.05% 2072 Dwarven Magestaff 0.05% 4715 Emblazoned Cloak 0.05% 4661 Flameweave Mantle 0.05% 3067 Flameweave Pants 0.05% 3069 Flameweave Robe 0.05% 3055 Forest Leather Breastplate 0.05% 3056 Forest Leather Pants 0.05% 6394 Frostweave Boots 0.05% 4036 Frostweave Bracers 0.05% 4713 Frostweave Cloak 0.05% 3068 Frostweave Cowl 0.05% 4714 Frostweave Sash 0.05% 3045 Glinting Scale Boots 0.05% 3212 Glinting Scale Bracers 0.05% 3049 Glinting Scale Breastplate 0.05% 4707 Glinting Scale Girdle 0.05% 3047 Glinting Scale Gloves 0.05% 3048 Glinting Scale Pants 0.05% 4705 Glinting Scale Pauldrons 0.05% 3656 Glinting Shield 0.05% 2879 Antipodean Rod 0.01% 2800 Black Velvet Robes 0.01% 2236 Blackfang 0.01% 2194 Diamond Hammer 0.01% 2098 Double-barreled Shotgun 0.01% 2911 Keller's Girdle 0.01% 935 Night Watch Shortsword 0.01% 3021 Ranger Bow 0.01% 2059 Sentry Cloak 0.01% 2256 Skeletal Club of Pain 0.01% 1121 Thick-soled Boots 0.01% 890 Twisted Chanter's Staff 0.01% 2011 Twisted Sabre 0.01%

Skinning loot (4)

2319 Medium Leather 48.5% 2318 Light Leather 43.71% 4232 Medium Hide 4.57% 783 Light Hide 3.21%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 3817);
Field Value
entry 3817
display_id1 1991
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Shadowhorn Stag
subname
static_flags None
gossip_menu_id 0
level_min 22
level_max 23
faction 189: Creature
npc_flags None
speed_walk 0.8
speed_run 1.42857
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.02
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 1: Beast
type_flags 0
loot_id 3817
pickpocket_loot_id 0
skinning_loot_id 3817
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 -
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 0
auras
gold_min 0
gold_max 0
ai_name EventAI
movement_type 1: Random
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 0
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name