Database

Alpha 0.5.3

Thistle Bear

Creature

General

Creature model for display ID 1006
Field Value
entry 2163
display_id1 1006
level_min 11
faction 44: Bear
npc_flags None
health_multiplier 1.25
mana_multiplier 1

Spawn points — Kalimdor (81)

6952.43 30.7177 15.1094 1 [Random: 10 yards]
7147.37 4.19446 10.2681 1 [Random: 10 yards]
6510.52 -60.6708 34.5754 1 [Random: 5 yards]
6403.39 112.84 36.0033 1 [Random: 10 yards]
6923.3 -10.2967 20.7932 1 [Random: 5 yards]
7073.01 -50.1616 16.3863 1 [Random: 10 yards]
7082.81 18.2285 16.4387 1 [Random: 5 yards]
7297.03 -154.166 13.603 1 [Random: 5 yards]
6446.69 20.2979 29.1625 1 [Random: 10 yards]
6876.25 23.4208 22.2693 1 [Random: 5 yards]
5896.86 153.815 29.12 1 [Random: 5 yards]
7295.18 -179.016 14.9421 1 [Random: 5 yards]
6843.06 250.148 17.7492 1 [Random: 5 yards]
6520.11 -50.3446 33.9653 1 [Random: 5 yards]
5919.21 -50.4607 41.812 1 [Random: 3 yards]
7364.27 -246.737 10.0085 1 [Random: 5 yards]
5869.78 111.83 31.7887 1 [Random: 5 yards]
6739.36 311.01 24.0622 1 [Random: 5 yards]
6724.76 308.587 24.5658 1 [Random: 5 yards]
6853.91 219.44 12.9635 1 [Random: 5 yards]
6608.81 327.811 28.9928 1 [Random: 5 yards]
6648.36 426.383 26.7427 1 [Random: 5 yards]
6656.02 288.861 32.1827 1 [Random: 5 yards]
6662.83 410.104 26.2989 1 [Random: 5 yards]
7048.54 80.9535 16.9582 1 [Random: 10 yards]
6820 97.5871 19.6779 1 [Random: 5 yards]
6572.81 298.632 32.0814 1 [Random: 5 yards]
6928.91 52.2576 16.0139 1 [Random: 5 yards]
6659.38 -270.631 47.0861 1 [Random: 5 yards]
6468.98 76.1526 34.9721 1 [Random: 10 yards]
6813.57 216.138 20.1 1 [Random: 5 yards]
5940.99 -91.4186 44.849 1 [Random: 10 yards]
6431.76 -44.0037 37.0905 1 [Random: 5 yards]
6505.71 -139.835 36.4572 1 [Random: 10 yards]
6472.22 113.158 38.6066 1 [Random: 10 yards]
7200.72 33.2228 10.448 1 [Random: 10 yards]
6421.98 -9.86445 30.3185 1 [Random: 5 yards]
6467.01 78.6208 35.3671 1 [Random: 10 yards]
6504.04 91.3375 35.8166 1 [Random: 10 yards]
6640.41 429.545 27.8345 1 [Random: 5 yards]
6504.41 248.525 29.4294 1 [Random: 5 yards]
7029.24 -41.0434 19.6464 1 [Random: 5 yards]
6920.07 76.1889 14.1604 1 [Random: 5 yards]
5704.81 16.947 39.2277 1 [Random: 3 yards]
7173.6 -70.2085 15.8925 1 [Random: 5 yards]
6977.61 41.8601 15.855 1 [Random: 5 yards]
6876.34 100.906 14.3866 1 [Random: 5 yards]
7024.54 92.4182 15.1654 1 [Random: 10 yards]
7330.21 -59.5434 11.1063 1 [Random: 10 yards]
6277.86 193.395 31.698 1 [Random: 5 yards]
7244.56 129.521 10.8882 1 [Random: 10 yards]
7207.38 91.6158 11.956 1 [Random: 10 yards]
6241.67 148.66 33.949 1 [Random: 5 yards]
7157.91 99.3053 13.3836 1 [Random: 10 yards]
7029.72 21.5478 16.5202 1 [Random: 10 yards]
6987.45 5.71158 13.2148 1 [Random: 10 yards]
7180.34 -66.9861 15.41 1 [Random: 5 yards]
7332.71 119.902 11.7834 1 [Random: 10 yards]
7291.88 -47.4621 8.17893 1 [Random: 10 yards]
7346.64 -122.564 13.6169 1 [Random: 10 yards]
7301.18 -17.649 11.7287 1 [Random: 10 yards]
6238.67 218.854 36.706 1 [Random: 5 yards]
7347.09 94.1124 12.981 1 [Random: 10 yards]
5939.81 130.066 29.9255 1 [Random: 5 yards]
6209.82 450.424 23.1752 1 [Random: 10 yards]
7181.8 -22.3868 9.92127 1 [Random: 5 yards]
6851.94 -2.32602 21.8626 1 [Random: 5 yards]
7256.2 30.1272 10.4305 1 [Random: 5 yards]
6710.89 376.755 25.9951 1 [Random: 5 yards]
6746.27 354.115 28.7608 1 [Random: 5 yards]
6673.2 290.389 30.8061 1 [Random: 5 yards]
5934.2 88.4144 31.9707 1 [Random: 5 yards]
7197.92 -43.75 12.6035 1 [Random: 5 yards]
7222.81 -120.275 14.7227 1 [Random: 5 yards]
6804.94 297.139 23.9473 1 [Random: 5 yards]
6552.46 -213.007 39.1891 1 [Random: 3 yards]
7309.57 -199.452 13.175 1 [Random: 5 yards]
7246.89 -82.7165 13.2468 1 [Random: 5 yards]
5846.97 214.47 36.195 1 [Random: 10 yards]
6216.91 254.894 37.5754 1 [Random: 5 yards]
6280.19 446.94 25.3244 1 [Random: 5 yards]

Loot (73)

3169 Small Bear Tooth 30.99% 3170 Large Bear Tooth 30.26% 3173 Bear Meat 29.33% 2940 Bloody Bear Paw 7.3% 5635 Sharp Claw 1.48% 856 Blue Leather Bag 0.75% 818 Tigerseye 0.52% 3290 Ancestral Gloves 0.22% 3286 Tribal Gloves 0.2% 774 Malachite 0.18% 2698 Recipe: Cooked Crab Claw 0.18% 3289 Ancestral Boots 0.17% 2770 Copper Ore 0.16% 1210 Shadowgem 0.16% 3303 Brackwater Bracers 0.15% 3644 Runic Cloth Bracers 0.14% 3279 Battle Chain Boots 0.12% 3312 Ceremonial Leather Bracers 0.12% 3281 Battle Chain Gloves 0.11% 5574 White Leather Bag 0.11% 3284 Tribal Boots 0.09% 5503 Clam Meat 0.08% 2835 Rough Stone 0.08% 4692 Ceremonial Leather Cloak 0.08% 4686 Runic Cloth Cloak 0.08% 4675 Tribal Belt 0.08% 3285 Tribal Bracers 0.08% 2450 Briarthorn 0.06% 785 Common Magebloom 0.06% 765 Silverleaf 0.06% 3649 Battle Buckler 0.05% 4680 Brackwater Cloak 0.05% 4693 Ceremonial Leather Belt 0.05% 2447 Peacebloom 0.04% 2452 Swiftthistle 0.04% 4669 Battle Chain Girdle 0.03% 3304 Brackwater Gauntlets 0.03% 4681 Brackwater Girdle 0.03% 4687 Runic Cloth Belt 0.03% 2963 Burnt Leather Boots 0.02% 2964 Burnt Leather Gloves 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% 3207 Hunting Bracers 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% 2598 Pattern: Red Linen Robe 0.02% 6271 Pattern: Red Linen Vest 0.02% 4345 Pattern: Red Woolen Boots 0.02% 2407 Pattern: White Leather Jerkin 0.02% 3609 Plans: Copper Chain Vest 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% 2657 Red Leather Bag 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 5498 Small Lustrous Pearl 0.02% 2449 Snakeroot 0.02% 5504 Tangy Clam Meat 0.02% 2771 Tin Ore 0.02% 4677 Veteran Cloak 0.02% 4672 Ancestral Sash 0.02% 3311 Ceremonial Leather Boots 0.02% 5573 Green Leather Bag 0.02%

Reference loot (45)

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% 3302 Brackwater Boots 0.5% 3653 Brackwater Buckler 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% 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% 6337 Infantry Leggings 0.5% 6336 Infantry Tunic 0.5% 2958 Journeyman's Pants 0.5% 2957 Journeyman'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% 4561 Scalping Tomahawk 0.5% 4562 Severing Axe 0.5% 5071 Shadow Wand 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% 3652 Veteran Buckler 0.5% 2980 Veteran Gloves 0.5% 2978 Veteran Leggings 0.5% 3651 Veteran Shield 0.5% 2966 Warrior's Pants 0.5% 2965 Warrior's Tunic 0.5%

Skinning loot (3)

2318 Light Leather 58.92% 2934 Ruined Leather Scraps 35.79% 783 Light Hide 5.29%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 2163);
Field Value
entry 2163
display_id1 1006
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Thistle Bear
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 11
level_max 12
faction 44: Bear
npc_flags None
speed_walk 1
speed_run 1.14286
scale 0.75
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.25
mana_multiplier 1
armor_multiplier 0.4
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 16
loot_id 2163
pickpocket_loot_id 0
skinning_loot_id 2163
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 3242: Ravage
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 5798
auras
gold_min 0
gold_max 0
ai_name EventAI
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