Database

Alpha 0.5.3

Giant Grizzled Bear

Creature

General

Creature model for display ID 820
Field Value
entry 1797
display_id1 820
level_min 12
faction 44: Bear
npc_flags None
health_multiplier 1.2
mana_multiplier 1

Spawn points — Eastern Kingdoms (45)

1064.33 1909.29 10.0951 0 [Random: 10 yards]
1119.25 1972.27 0.818851 0 [Random: 5 yards]
1287.42 1811.21 23.1797 0 [Random: 5 yards]
1140.42 1619.07 31.8286 0 [Random: 5 yards]
1184.34 1961.32 9.59904 0 [Random: 10 yards]
1171.82 1892.13 18.8476 0 [Random: 5 yards]
1189.8 1585.62 26.7093 0 [Random: 10 yards]
1214.8 1548.08 33.4479 0 [Random: 5 yards]
1249.31 1782.21 12.7217 0 [Random: 10 yards]
1220.21 1807.42 15.3095 0 [Random: 10 yards]
1184.25 1880.68 17.1796 0 [Random: 5 yards]
1201.2 1867.42 18.4268 0 [Random: 5 yards]
1231.25 1857.81 10.502 0 [Random: 5 yards]
1205.11 1776.17 15.4958 0 [Random: 10 yards]
1160.67 1475.3 34.6033 0 [Random: 10 yards]
1239.04 2002.68 14.1142 0 [Random: 5 yards]
1155.47 1519.06 37.2919 0 [Random: 10 yards]
1120.89 1664.6 29.5052 0 [Random: 10 yards]
1162.88 1702.64 18.5242 0 [Random: 10 yards]
1158.75 1665.98 24.9131 0 [Random: 10 yards]
1058.35 1682.05 28.1638 0 [Random: 5 yards]
1155.99 1721.3 17.7316 0 [Random: 10 yards]
-233.982 1310.88 44.6871 0 [Random: 5 yards]
219.528 1114.58 75.2298 0 [Random: 3 yards]
-211.737 1093.68 60.6197 0 [Random: 5 yards]
-278.768 1153.32 64.3192 0 [Random: 10 yards]
-154.203 1124.6 58.5677 0 [Random: 5 yards]
-320.852 1117.41 74.8466 0 [Random: 10 yards]
-48.8666 1246.44 60.6744 0 [Random: 10 yards]
217.217 1227.29 68.8747 0 [Random: 5 yards]
92.6028 1171.89 67.6928 0 [Random: 5 yards]
156.96 1285.44 69.5698 0 [Random: 10 yards]
155.145 1217.37 67.9373 0 [Random: 5 yards]
13.2094 1282.69 61.6673 0 [Random: 10 yards]
-210.926 1228.94 55.0969 0 [Random: 10 yards]
118.75 1293.75 69.4602 0 [Random: 10 yards]
39.4396 1275.63 63.4846 0 [Random: 10 yards]
187.751 1288.45 70.7082 0 [Random: 10 yards]
-302.147 1375.94 34.8876 0 [Random: 5 yards]
-82.8995 1284.23 56.8944 0 [Random: 10 yards]
-214.962 1327.58 37.5295 0 [Random: 10 yards]
-201.677 1281.97 43.3835 0 [Random: 10 yards]
-275.778 1342.36 36.05 0 [Random: 10 yards]
-152.705 1205.62 57.5753 0 [Random: 10 yards]
-29.7372 1219.67 61.6027 0 [Random: 10 yards]

Quest item loot (1)

3253 Grizzled Bear Heart 80%

Loot (58)

3173 Bear Meat 29.33% 3169 Small Bear Tooth 27.97% 3170 Large Bear Tooth 27.48% 2940 Bloody Bear Paw 7.17% 5635 Sharp Claw 1.34% 818 Tigerseye 0.56% 2770 Copper Ore 0.28% 774 Malachite 0.16% 4690 Hunting Belt 0.15% 1210 Shadowgem 0.14% 765 Silverleaf 0.14% 4684 Magister's Sash 0.14% 2835 Rough Stone 0.12% 4689 Hunting Cloak 0.11% 2979 Veteran Boots 0.1% 3213 Veteran Bracers 0.1% 3207 Hunting Bracers 0.08% 4683 Magister's Cloak 0.08% 4677 Veteran Cloak 0.08% 856 Blue Leather Bag 0.07% 2450 Briarthorn 0.06% 2598 Pattern: Red Linen Robe 0.06% 2447 Peacebloom 0.06% 2972 Magister's Gloves 0.06% 3643 Magister's Bracers 0.04% 2971 Magister's Shoes 0.04% 4678 Veteran Girdle 0.04% 785 Common Magebloom 0.04% 3609 Plans: Copper Chain Vest 0.04% 2452 Swiftthistle 0.04% 5573 Green Leather Bag 0.03% 2657 Red Leather Bag 0.03% 2453 Bruiseweed 0.02% 5503 Clam Meat 0.02% 2836 Coarse Stone 0.02% 6344 Formula: Enchant Bracer - Minor Spirit 0.02% 6347 Formula: Enchant Bracer - Minor Strength 0.02% 6342 Formula: Enchant Chest - Minor Mana 0.02% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.02% 1179 Ice Cold Milk 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 2406 Pattern: Fine Leather Boots 0.02% 2408 Pattern: Fine Leather Gloves 0.02% 4292 Pattern: Green Woolen Bag 0.02% 4346 Pattern: Heavy Woolen Cloak 0.02% 4293 Pattern: Hillman's Leather Vest 0.02% 6271 Pattern: Red Linen Vest 0.02% 4345 Pattern: Red Woolen Boots 0.02% 2407 Pattern: White Leather Jerkin 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 4408 Plans: Mechanical Squirrel 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 2555 Recipe: Swiftness Potion 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 2771 Tin Ore 0.02% 2975 Hunting Boots 0.01% 5574 White Leather Bag 0.01%

Reference loot (63)

3291 Ancestral Leggings 0.5% 3292 Ancestral Tunic 0.5% 3282 Battle Chain Pants 0.5% 3283 Battle Chain Tunic 0.5% 5069 Bent Fire Wand 0.5% 4570 Birchwood Maul 0.5% 5212 Blazing Wand 0.5% 3302 Brackwater Boots 0.5% 3653 Brackwater Buckler 0.5% 3305 Brackwater Leggings 0.5% 3654 Brackwater Shield 0.5% 2962 Burnt Leather Pants 0.5% 2961 Burnt Leather Vest 0.5% 2140 Carving Knife 0.5% 3314 Ceremonial Leather Gloves 0.5% 3315 Ceremonial Leather Pants 0.5% 4577 Compact Shotgun 0.5% 2632 Curved Dagger 0.5% 6267 Disciple's Pants 0.5% 6266 Disciple's Vest 0.5% 2073 Dwarven Hatchet 0.5% 3036 Heavy Shortbow 0.5% 2976 Hunting Gloves 0.5% 2974 Hunting Pants 0.5% 2973 Hunting Vest 0.5% 6337 Infantry Leggings 0.5% 6336 Infantry Tunic 0.5% 6379 Inscribed Leather Belt 0.5% 3205 Inscribed Leather Bracers 0.5% 4701 Inscribed Leather Cloak 0.5% 2958 Journeyman's Pants 0.5% 2957 Journeyman's Vest 0.5% 2970 Magister's Pants 0.5% 2969 Magister's Vest 0.5% 727 Notched Shortsword 0.5% 6269 Pioneer Trousers 0.5% 6268 Pioneer Tunic 0.5% 2075 Priest's Mace 0.5% 3307 Runic Cloth Boots 0.5% 3308 Runic Cloth Gloves 0.5% 3309 Runic Loin Cloth 0.5% 4561 Scalping Tomahawk 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% 4562 Severing Axe 0.5% 5071 Shadow Wand 0.5% 4567 Short Bastard Sword 0.5% 4564 Spiked Club 0.5% 4569 Staunch Mace 0.5% 4566 Sturdy Quarterstaff 0.5% 3192 Training Sword 0.5% 3287 Tribal Pants 0.5% 3288 Tribal Vest 0.5% 2977 Veteran Armor 0.5% 3652 Veteran Buckler 0.5% 2980 Veteran Gloves 0.5% 2978 Veteran Leggings 0.5% 3651 Veteran Shield 0.5% 4571 War Knife 0.5% 2966 Warrior's Pants 0.5% 2965 Warrior's Tunic 0.5%

Skinning loot (3)

2318 Light Leather 59.97% 2934 Ruined Leather Scraps 35.12% 783 Light Hide 4.91%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 1797);
Field Value
entry 1797
display_id1 820
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Giant Grizzled Bear
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 12
level_max 13
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.2
mana_multiplier 1
armor_multiplier 0.5
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 1797
pickpocket_loot_id 0
skinning_loot_id 1797
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