Database

Alpha 0.5.3

Ashenvale Bear

Creature

General

Creature model for display ID 820
Field Value
entry 3809
display_id1 820
level_min 21
faction 44: Bear
npc_flags None
health_multiplier 1.27
mana_multiplier 1

Spawn points — Kalimdor (92)

1386.15 -2214.12 92.69 1 [Random: 5 yards]
2090.41 -595.307 103.248 1 [Random: 5 yards]
2315.13 -903.292 98.4071 1 [Idle]
2444.84 -892.368 145.42 1 [Random: 5 yards]
2575.67 -1543.62 157.972 1 [Random: 3 yards]
2382.4 -948.031 102.523 1 [Random: 3 yards]
2981.77 -1276.44 199.81 1 [Random: 5 yards]
2281.03 -580.195 111.808 1 [Random: 5 yards]
2291.61 -679.881 136.875 1 [Random: 5 yards]
2295.47 -997.381 95.4581 1 [Random: 5 yards]
2047.98 -415.036 95.6911 1 [Random: 15 yards]
1923.78 -458.803 111.815 1 [Random: 10 yards]
2554.92 -1485.88 161.328 1 [Random: 15 yards]
2700.04 -1458.27 212.929 1 [Random: 5 yards]
2420.54 -792.628 122.464 1 [Random: 15 yards]
2171.58 -1082.99 101.932 1 [Random: 5 yards]
2352.21 -947.693 92.2136 1 [Random: 15 yards]
2281.85 -484.178 99.1736 1 [Random: 15 yards]
2207.49 -540.074 103.787 1 [Random: 2 yards]
2318.05 -748.627 116.195 1 [Random: 15 yards]
2625.22 -1030.09 119.367 1 [Random: 15 yards]
2239.46 -586.661 104.313 1 [Random: 15 yards]
1449.25 -2149.99 90.3586 1 [Random: 5 yards]
2260.23 -507.636 100.283 1 [Random: 15 yards]
2618.79 -894.747 144.478 1 [Random: 5 yards]
2254.86 -784.795 108.752 1 [Random: 15 yards]
2337.8 -946.903 90.4868 1 [Random: 15 yards]
2314.33 -715.631 126.767 1 [Random: 3 yards]
2111.07 -639.402 104.116 1 [Random: 3 yards]
2141.24 -854.411 99.1271 1 [Random: 5 yards]
2373.18 -771.121 118.432 1 [Random: 15 yards]
3160.04 -479.183 138.007 1 [Random: 15 yards]
2269.88 -876.464 98.5102 1 [Random: 15 yards]
1980.71 -724.178 99.9177 1 [Random: 15 yards]
2219.49 -845.046 101.904 1 [Random: 15 yards]
1938.87 -667.573 113.119 1 [Random: 5 yards]
2130.43 -643.652 104.83 1 [Random: 15 yards]
2548.52 -1265.93 140.822 1 [Random: 15 yards]
2710.55 -1146.07 170.394 1 [Random: 5 yards]
2611.94 -1051.11 120.239 1 [Random: 15 yards]
2644.81 -1023.05 121.211 1 [Random: 15 yards]
1667.42 -2173.62 92.3751 1 [Random: 5 yards]
1981.45 -404.674 97.3993 1 [Random: 5 yards]
2107.84 -873.458 98.5271 1 [Random: 15 yards]
1970.88 -521.337 112.632 1 [Random: 5 yards]
2239.6 -942.449 86.1625 1 [Random: 15 yards]
2618.02 -1088.63 127.145 1 [Random: 3 yards]
2939.92 -1190.74 184.463 1 [Random: 5 yards]
3041.08 -175.291 103.941 1 [Random: 15 yards]
2555.23 -1207.54 139.703 1 [Random: 15 yards]
2741.01 -1268.67 178.61 1 [Random: 5 yards]
2100.38 -689.776 103.712 1 [Random: 3 yards]
3104.42 -565.507 152.001 1 [Random: 3 yards]
3230.43 -517.199 147.136 1 [Random: 5 yards]
3035.38 -628.197 170.407 1 [Random: 3 yards]
2357.82 -469.013 104.018 1 [Random: 15 yards]
2623.98 -1498.69 183.829 1 [Random: 3 yards]
3035.1 -949.248 205.483 1 [Random: 3 yards]
2166.23 -584.794 103.011 1 [Random: 15 yards]
1704.95 -1975.24 97.7747 1 [Random: 5 yards]
2979.3 -774.917 176.734 1 [Random: 3 yards]
3109.1 -119.269 102.574 1 [Random: 5 yards]
3015.16 -721.037 171.259 1 [Random: 5 yards]
2906.17 -806.347 168.929 1 [Random: 15 yards]
2971.16 -745.943 173.004 1 [Random: 15 yards]
3115.61 -579.792 152.719 1 [Random: 15 yards]
2986.54 -682.877 170.452 1 [Random: 5 yards]
2113 -664.809 105.073 1 [Random: 15 yards]
2176.03 -941.531 93.4146 1 [Random: 15 yards]
1965.6 -567.09 112.857 1 [Random: 3 yards]
2008.08 -571.563 100.442 1 [Random: 15 yards]
2620.36 -1227.94 148.455 1 [Random: 3 yards]
2238.71 -1108.68 92.7443 1 [Random: 15 yards]
2701.1 -859.84 146.784 1 [Random: 3 yards]
2581.83 -1314.35 148.634 1 [Random: 15 yards]
1992.54 -685.709 100.961 1 [Random: 15 yards]
2526.61 -1585 147.364 1 [Random: 10 yards]
2845.49 -1220.14 182.958 1 [Random: 15 yards]
2944.73 -1209.27 185.919 1 [Random: 5 yards]
2512.28 -1257.36 132.656 1 [Random: 15 yards]
2604.13 -1473.39 170.667 1 [Random: 15 yards]
2680.95 -1186.97 157.48 1 [Random: 15 yards]
2601.04 -1337.02 154.732 1 [Random: 5 yards]
3295.97 -242.628 121.883 1 [Random: 15 yards]
2574.87 -924.745 140.396 1 [Random: 3 yards]
1647.81 -2133.18 108.292 1 [Random: 5 yards]
2514.67 -1204.2 131.146 1 [Random: 15 yards]
2194.04 -729.431 105.157 1 [Random: 3 yards]
1303.79 -2153.59 92.1994 1 [Random: 10 yards]
1385.5 -2217.12 93.133 1 [Random: 5 yards]
1347.55 -2113.53 93.7973 1 [Random: 10 yards]
1721.67 -2162.38 95.3106 1 [Random: 5 yards]

Loot (62)

3730 Big Bear Meat 41.86% 2940 Bloody Bear Paw 34.12% 3702 Bear Gall Bladder 10.76% 5635 Sharp Claw 4.37% 1206 Moss Agate 0.16% 3173 Bear Meat 0.14% 4694 Burnished Chain Spaulders 0.13% 2770 Copper Ore 0.08% 1705 Lesser Moonstone 0.06% 2835 Rough Stone 0.04% 1210 Shadowgem 0.04% 2771 Tin Ore 0.04% 804 Large Blue Sack 0.02% 5575 Large Green Sack 0.02% 857 Large Red Sack 0.02% 2450 Briarthorn 0.02% 2453 Bruiseweed 0.02% 5503 Clam Meat 0.02% 2836 Coarse Stone 0.02% 785 Common Magebloom 0.02% 3356 Crownroyal 0.02% 6375 Formula: Enchant Bracer - Lesser Spirit 0.02% 6344 Formula: Enchant Bracer - Minor Spirit 0.02% 6347 Formula: Enchant Bracer - Minor Strength 0.02% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.02% 5500 Iridescent Pearl 0.02% 4297 Pattern: Barbaric Gloves 0.02% 4296 Pattern: Dark Leather Shoulders 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 5972 Pattern: Fine Leather Pants 0.02% 2601 Pattern: Gray Woolen Robe 0.02% 4292 Pattern: Green Woolen Bag 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% 4350 Pattern: Spider Silk Slippers 0.02% 6390 Pattern: Stylish Blue Shirt 0.02% 6391 Pattern: Stylish Green Shirt 0.02% 2883 Plans: Deadly Bronze Poniard 0.02% 3611 Plans: Green Iron Boots 0.02% 3612 Plans: Green Iron Gauntlets 0.02% 5543 Plans: Iridescent Hammer 0.02% 6044 Plans: Iron Shield Spike 0.02% 3608 Plans: Mighty Iron Hammer 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 5578 Plans: Silvered Bronze Breastplate 0.02% 2882 Plans: Silvered Bronze Shoulders 0.02% 3396 Recipe: Elixir of Lesser Agility 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% 4412 Schematic: Moonsight Rifle 0.02% 4410 Schematic: Shadow Goggles 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 2452 Swiftthistle 0.02% 5504 Tangy Clam Meat 0.02% 3355 Wild Steelbloom 0.02% 5576 Large Brown Sack 0.01%

Reference loot (81)

3039 Archer's Longbow 0.5% 3195 Barbaric Battle Axe 0.5% 3198 Battering Hammer 0.5% 3199 Battle Slayer 0.5% 4998 Blood Ring 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% 3313 Ceremonial Leather Tunic 0.5% 3740 Decapitating Sword 0.5% 3196 Edged Bastard 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% 3040 Hunter's Muzzle Loader 0.5% 2987 Inscribed Leather Boots 0.5% 2985 Inscribed Leather Breastplate 0.5% 2988 Inscribed Leather Gloves 0.5% 2986 Inscribed Leather Pants 0.5% 4576 Light Bow 0.5% 4575 Medicine Staff 0.5% 2078 Northern Shortsword 0.5% 3193 Oak Mallet 0.5% 3310 Runic Cloth Vest 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% 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% 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% 2236 Blackfang 0.01% 2194 Diamond Hammer 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%

Skinning loot (4)

2319 Medium Leather 50.22% 2318 Light Leather 42.34% 4232 Medium Hide 4.87% 783 Light Hide 2.57%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 3809);
Field Value
entry 3809
display_id1 820
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Ashenvale Bear
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 21
level_max 22
faction 44: Bear
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.27
mana_multiplier 1
armor_multiplier 0.45
base_attack_time 2 sec
ranged_attack_time 2 sec
unit_class 1
unit_flags 0
dynamic_flags 0
beast_family 4
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 1: Beast
type_flags 1
loot_id 3809
pickpocket_loot_id 0
skinning_loot_id 3809
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 5803
auras
gold_min 0
gold_max 0
ai_name
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 None
school_immune_mask 0
flags_extra None
script_name