Database

Alpha 0.5.3

Elder Gray Bear

Creature

General

Creature model for display ID 3201
Field Value
entry 2356
display_id1 3201
level_min 25
faction 44: Bear
npc_flags None
health_multiplier 1.35
mana_multiplier 1

Spawn points — Eastern Kingdoms (109)

-511.27 -1802.18 67.2102 0 [Random: 5 yards]
-677.415 -1445.49 63.7163 0 [Random: 10 yards]
-231.367 150.752 71.9621 0 [Random: 10 yards]
-614.494 -1673.26 61.3654 0 [Random: 10 yards]
-1010.29 142.993 57.5302 0 [Random: 10 yards]
-330.917 202.579 87.4494 0 [Random: 10 yards]
-1018.39 -1398.95 56.5173 0 [Random: 10 yards]
-999.111 120.493 54.7334 0 [Random: 10 yards]
-598.9 -1604.41 58.311 0 [Random: 3 yards]
-381.533 -1587.1 71.7978 0 [Random: 10 yards]
-359.228 -1541.89 71.2492 0 [Random: 10 yards]
-369.407 -1471.97 64.219 0 [Random: 3 yards]
-362.476 -1499.41 67.7939 0 [Random: 10 yards]
-718.576 -1552.33 56.9426 0 [Random: 10 yards]
-708.808 -1564.22 57.1721 0 [Random: 10 yards]
-776.073 -1424.26 64.9163 0 [Random: 10 yards]
-809.068 -207.296 35.9963 0 [Random: 5 yards]
-287.524 124.381 72.8622 0 [Random: 10 yards]
-716.667 -1450 64.7344 0 [Random: 10 yards]
-913.083 -62.5935 20.6685 0 [Random: 10 yards]
-845.23 -136.44 33.2369 0 [Random: 5 yards]
-973.241 -54.3898 21.0261 0 [Random: 3 yards]
-435.174 -1678.54 85.5527 0 [Random: 10 yards]
-449.045 -1742.75 85.1255 0 [Random: 10 yards]
-311.404 -1644.78 91.9629 0 [Random: 10 yards]
-807.772 -36.9599 28.1008 0 [Random: 10 yards]
-673.206 -953.951 34.3057 0 [Random: 5 yards]
-350.965 -1654.61 85.1407 0 [Random: 10 yards]
-751.606 -1604.24 54.3439 0 [Random: 3 yards]
-521.376 -1813.02 64.3255 0 [Random: 3 yards]
-755.428 243.031 47.8912 0 [Random: 10 yards]
-990.571 88.243 52.563 0 [Random: 10 yards]
-818.808 -216.651 35.1432 0 [Idle]
-1026.78 -1235.22 55.3446 0 [Random: 10 yards]
-711.968 280.62 50.3726 0 [Random: 10 yards]
-999.128 -1244.96 55.4553 0 [Random: 10 yards]
-486.045 -1762.78 78.3197 0 [Random: 10 yards]
-218.005 -1152.81 47.0572 0 [Random: 10 yards]
-717.384 217.487 51.0391 0 [Random: 10 yards]
-694.844 260.69 49.3467 0 [Random: 10 yards]
-975.31 6.93124 33.4362 0 [Random: 10 yards]
-723.421 -1241.92 59.0946 0 [Random: 5 yards]
-931.532 -1205 52.6331 0 [Random: 10 yards]
-473.383 -1739.4 81.8203 0 [Random: 10 yards]
-921.308 -1268.8 51.6933 0 [Random: 10 yards]
-82.5978 -1282.8 87.5094 0 [Random: 5 yards]
-583.157 -950.196 40.9115 0 [Random: 10 yards]
-717.936 -1325.88 64.0866 0 [Random: 10 yards]
-1022.24 -1328.58 55.315 0 [Random: 10 yards]
-374.216 212.246 89.5004 0 [Random: 10 yards]
-278.076 -1385.03 86.8718 0 [Random: 10 yards]
-68.66 -1181.52 47.3617 0 [Random: 10 yards]
-855.191 -1469.6 58.4068 0 [Random: 5 yards]
-77.5577 -1195.15 48.3649 0 [Random: 5 yards]
-654.437 -153.729 43.5559 0 [Random: 5 yards]
-680.263 -179.913 41.8462 0 [Random: 5 yards]
-365.631 -1719.53 90.7495 0 [Random: 3 yards]
-758.306 -49.6266 30.1268 0 [Random: 10 yards]
-831.404 291.294 41.6835 0 [Random: 10 yards]
-685.863 -89.7957 42.4598 0 [Random: 10 yards]
-910.833 -1111.2 48.4799 0 [Random: 10 yards]
-644.092 -929.563 35.8359 0 [Random: 10 yards]
-615.59 -1021.85 66.6835 0 [Random: 5 yards]
-300.846 -1447.99 83.7408 0 [Random: 10 yards]
-149.249 -1187.73 56.6616 0 [Random: 10 yards]
-1001.48 -140.175 16.1595 0 [Random: 5 yards]
-805.364 91.4179 37.0051 0 [Random: 5 yards]
-781.78 127.34 43.5662 0 [Random: 10 yards]
-735.729 -180.585 37.4502 0 [Random: 5 yards]
-185.838 -1326.63 101.229 0 [Random: 5 yards]
-722.575 86.4662 40.9657 0 [Random: 10 yards]
-942.348 125.093 45.2666 0 [Random: 10 yards]
-953.82 -309.01 57.5317 0 [Random: 10 yards]
-717.341 -307.902 18.2617 0 [Random: 10 yards]
-829.649 -372.96 19.0983 0 [Random: 10 yards]
-409.194 -1718.52 88.3221 0 [Random: 10 yards]
-780.306 29.5933 33.9577 0 [Random: 5 yards]
-257.809 -123.868 72.527 0 [Random: 10 yards]
-314.518 -1318.04 73.0841 0 [Random: 10 yards]
-844.534 -263.891 37.0155 0 [Idle]
-881.253 -379.278 23.3121 0 [Random: 10 yards]
-230.366 -1294.41 98.5433 0 [Random: 5 yards]
-254.389 -1408.28 95.1853 0 [Random: 10 yards]
-629.613 -962.754 42.5213 0 [Random: 10 yards]
-877.319 -1290.6 50.9381 0 [Random: 10 yards]
-826.047 -1334.96 63.2817 0 [Random: 5 yards]
-315.579 -82.5931 62.699 0 [Random: 10 yards]
-680.857 -1181.33 61.6242 0 [Random: 10 yards]
-940.448 -157.44 55.1219 0 [Random: 3 yards]
-803.369 -428.865 17.0093 0 [Random: 10 yards]
-901.496 -217.981 49.357 0 [Random: 5 yards]
-884.18 -50.4254 23.0071 0 [Random: 10 yards]
-716.492 145.898 45.0026 0 [Random: 10 yards]
-618.101 -251.71 43.6369 0 [Random: 5 yards]
-612.918 -288.413 45.2608 0 [Random: 5 yards]
-257.786 163.965 81.7131 0 [Random: 10 yards]
81.7462 130.012 49.6645 0 [Random: 10 yards]
292.679 82.2178 49.298 0 [Random: 10 yards]
-45.5915 118.028 57.9524 0 [Random: 10 yards]
60.749 88.7913 49.2333 0 [Random: 10 yards]
210.3 -8.49704 72.8186 0 [Random: 10 yards]
43.7503 45.5611 57.517 0 [Random: 10 yards]
-29.2921 29.8512 73.5496 0 [Random: 10 yards]
390.428 89.3012 46.2104 0 [Random: 5 yards]
137.513 177.587 50.0034 0 [Random: 5 yards]
-13.7593 91.8976 54.9062 0 [Random: 10 yards]
86.9317 186.725 45.28 0 [Random: 10 yards]
-53.8835 351.264 62.5955 0 [Random: 10 yards]
209.326 188.713 44.1624 0 [Random: 10 yards]

Quest item loot (1)

3476 Gray Bear Tongue 80%

Loot (78)

3730 Big Bear Meat 41.98% 2940 Bloody Bear Paw 31.78% 3702 Bear Gall Bladder 18.97% 5635 Sharp Claw 5.07% 1206 Moss Agate 0.12% 1705 Lesser Moonstone 0.11% 3356 Crownroyal 0.08% 4633 Heavy Bronze Lockbox 0.08% 2771 Tin Ore 0.06% 2770 Copper Ore 0.04% 2772 Iron Ore 0.04% 4632 Ornate Bronze Lockbox 0.03% 2450 Briarthorn 0.02% 2453 Bruiseweed 0.02% 3864 Citrine 0.02% 2836 Coarse Stone 0.02% 785 Common Magebloom 0.02% 6375 Formula: Enchant Bracer - Lesser Spirit 0.02% 6347 Formula: Enchant Bracer - Minor Strength 0.02% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.02% 929 Healing Potion 0.02% 2838 Heavy Stone 0.02% 5576 Large Brown Sack 0.02% 3357 Liferoot 0.02% 774 Malachite 0.02% 3770 Mutton Chop 0.02% 4957 Old Moneybag 0.02% 4297 Pattern: Barbaric Gloves 0.02% 4352 Pattern: Boots of the Enchanter 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% 4299 Pattern: Guardian Armor 0.02% 4346 Pattern: Heavy Woolen Cloak 0.02% 4294 Pattern: Hillman's Belt 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% 3867 Plans: Golden Iron Destroyer 0.02% 3872 Plans: Golden Scale Leggings 0.02% 3611 Plans: Green Iron Boots 0.02% 3612 Plans: Green Iron Gauntlets 0.02% 3870 Plans: Green Iron Shoulders 0.02% 5543 Plans: Iridescent Hammer 0.02% 6044 Plans: Iron Shield Spike 0.02% 3866 Plans: Jade Serpentblade 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% 2835 Rough Stone 0.02% 4412 Schematic: Moonsight Rifle 0.02% 4410 Schematic: Shadow Goggles 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 955 Scroll of Intellect 0.02% 1210 Shadowgem 0.02% 2775 Silver Ore 0.02% 5498 Small Lustrous Pearl 0.02% 2452 Swiftthistle 0.02% 5504 Tangy Clam Meat 0.02% 818 Tigerseye 0.02% 3355 Wild Steelbloom 0.02% 1529 Jade 0.01% 857 Large Red Sack 0.01% 3173 Bear Meat 0.01% 804 Large Blue Sack 0.01% 5575 Large Green Sack 0.01%

Reference loot (110)

3041 "Mage-Eye" Blunderbuss 0.5% 3039 Archer's Longbow 0.5% 5007 Band of Thorns 0.5% 3198 Battering Hammer 0.5% 3199 Battle Slayer 0.5% 5212 Blazing Wand 0.5% 4998 Blood Ring 0.5% 3305 Brackwater Leggings 0.5% 3210 Brutal War Axe 0.5% 3315 Ceremonial Leather Pants 0.5% 2819 Cross Dagger 0.5% 5003 Crystal Starfire Medallion 0.5% 3740 Decapitating Sword 0.5% 2077 Dwarven War Staff 0.5% 3186 Ebon Scimitar 0.5% 6398 Emblazoned Belt 0.5% 4051 Emblazoned Boots 0.5% 4049 Emblazoned Bracers 0.5% 6397 Emblazoned Gloves 0.5% 4048 Emblazoned Helm 0.5% 4050 Emblazoned Pants 0.5% 6399 Emblazoned Shoulders 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% 6393 Frostweave Gloves 0.5% 6395 Frostweave Mantle 0.5% 4037 Frostweave Pants 0.5% 4035 Frostweave Robe 0.5% 3201 Gladiator War Axe 0.5% 4064 Glimmering Buckler 0.5% 4073 Glimmering Mail Boots 0.5% 6387 Glimmering Mail Bracers 0.5% 4071 Glimmering Mail Chestpiece 0.5% 4711 Glimmering Mail Cloak 0.5% 6389 Glimmering Mail Coif 0.5% 4072 Glimmering Mail Gauntlets 0.5% 4712 Glimmering Mail Girdle 0.5% 6386 Glimmering Mail Leggings 0.5% 6388 Glimmering Mail Pauldrons 0.5% 6400 Glimmering Shield 0.5% 6383 Glinting Buckler 0.5% 4706 Glinting Scale Cloak 0.5% 5002 Glowing Green Talisman 0.5% 2974 Hunting Pants 0.5% 2973 Hunting Vest 0.5% 6379 Inscribed Leather Belt 0.5% 3205 Inscribed Leather Bracers 0.5% 4701 Inscribed Leather Cloak 0.5% 865 Leaden Mace 0.5% 2970 Magister's Pants 0.5% 2969 Magister's 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% 2079 Sergeant's Warhammer 0.5% 4567 Short Bastard Sword 0.5% 789 Stout Battlehammer 0.5% 3206 Two-handed Cavalier Sword 0.5% 2977 Veteran Armor 0.5% 4571 War 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% 2878 Bearded Axe 0.01% 2800 Black Velvet Robes 0.01% 2236 Blackfang 0.01% 720 Brawler Gloves 0.01% 3203 Dense Triangle Mace 0.01% 2194 Diamond Hammer 0.01% 1717 Double Link Mail Tunic 0.01% 2098 Double-barreled Shotgun 0.01% 2278 Forest Tracker Epaulets 0.01% 791 Gnarled Ash Staff 0.01% 2911 Keller's Girdle 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 49.11% 2318 Light Leather 43.7% 4232 Medium Hide 4.65% 783 Light Hide 2.54%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 2356);
Field Value
entry 2356
display_id1 3201
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Elder Gray Bear
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 25
level_max 26
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.35
mana_multiplier 1
armor_multiplier 0.35
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 2356
pickpocket_loot_id 0
skinning_loot_id 2356
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
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