Database

Alpha 0.5.3

Kolkar Wrangler

Creature

General

Creature model for display ID 172
Field Value
entry 3272
display_id1 172
level_min 12
faction 130: Kolkar
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Kalimdor (70)

-1220.16 -2118.23 92.8913 1 [Random: 5 yards]
-1219 -2176.22 91.7113 1 [Idle]
-883.566 -2787.95 93.7307 1 [Waypoints]
151.877 -1861.91 93.5671 1 [Random: 5 yards]
184.106 -1804.53 93.8466 1 [Random: 5 yards]
192.636 -1772.6 91.7917 1 [Random: 5 yards]
90.2752 -1880.74 94.3379 1 [Random: 5 yards]
-1052.44 -2323.25 91.7931 1 [Idle]
237.426 -1912.43 91.9167 1 [Random: 5 yards]
-46.3752 -2194.34 91.7917 1 [Random: 5 yards]
-40.1317 -2211.18 91.7917 1 [Idle]
-61.2225 -1630.93 91.7917 1 [Idle]
27.1542 -1984.15 93.246 1 [Random: 5 yards]
-892.432 -2814.67 94.7109 1 [Random: 5 yards]
-911.451 -2942.63 91.7917 1 [Idle]
-1034.55 -2315.42 91.6823 1 [Idle]
10.724 -1711.42 91.875 1 [Random: 5 yards]
238.412 -1933.69 92.5417 1 [Idle]
31.25 -1792.19 91.7936 1 [Idle]
161.303 -1812.76 92.4406 1 [Idle]
-235.018 -1662.62 91.7916 1 [Random: 2 yards]
68.654 -2000.5 92.0207 1 [Random: 5 yards]
-57.6553 -1675.64 92.4138 1 [Random: 15 yards]
261.554 -1950.92 91.9167 1 [Idle]
-12.6241 -1678.53 93.675 1 [Random: 5 yards]
-17.6744 -1694.72 94.6865 1 [Random: 5 yards]
-185.922 -1662.92 92.3214 1 [Random: 5 yards]
-213.642 -1662.75 91.7917 1 [Idle]
-171.789 -1761.49 92.7395 1 [Random: 5 yards]
-164.74 -1785.2 91.7917 1 [Random: 5 yards]
-176.116 -1794.72 91.7917 1 [Random: 5 yards]
-199.084 -1788.87 91.8735 1 [Random: 5 yards]
-131.936 -2009.62 91.7917 1 [Idle]
-143.534 -2007.58 91.7917 1 [Waypoints]
-110.625 -2006.86 91.7917 1 [Idle]
-100.629 -1988.76 92.0425 1 [Random: 5 yards]
78.4045 -2054.62 94.0309 1 [Random: 5 yards]
-103.71 -2026.18 91.7917 1 [Idle]
29.7405 -2162.99 91.7917 1 [Random: 5 yards]
49.3321 -2098.9 91.7917 1 [Idle]
120.852 -1992.2 93.781 1 [Random: 5 yards]
75.4589 -2098.06 91.7917 1 [Random: 5 yards]
-29.2992 -1905.12 93.5599 1 [Random: 5 yards]
-1186.66 -2001.55 91.7917 1 [Idle]
-1071.06 -1910.3 94.278 1 [Random: 5 yards]
-1059.31 -1909.57 91.7878 1 [Random: 5 yards]
-62.2892 -2243.04 92.5 1 [Random: 15 yards]
12.7517 -1876.91 94.046 1 [Random: 5 yards]
-42.4506 -2272.18 93.0944 1 [Random: 15 yards]
-44.8874 -2235.58 91.7917 1 [Random: 15 yards]
-861.458 -2746.88 91.7917 1 [Idle]
-1090.55 -2280.31 83.328 1 [Random: 10 yards]
-979.216 -2017.72 83.5079 1 [Random: 5 yards]
-923.257 -2013.57 90.641 1 [Random: 5 yards]
-947.931 -2110.6 84.0315 1 [Random: 15 yards]
-990.286 -2118.76 82.7387 1 [Random: 10 yards]
-1048.89 -2214.67 83.9597 1 [Random: 5 yards]
-1011.03 -2186.89 91.833 1 [Random: 15 yards]
-1120.4 -2287.36 87.624 1 [Random: 10 yards]
-1128.09 -2143.72 82.4703 1 [Random: 5 yards]
-1147.45 -2246.23 84.4488 1 [Random: 5 yards]
-1150.27 -2182.11 83.2411 1 [Random: 5 yards]
-1149.63 -2043.95 93.074 1 [Random: 5 yards]
-1047.93 -1982.15 81.619 1 [Random: 5 yards]
-1118.29 -1988.4 91.0466 1 [Random: 5 yards]
-990.02 -1883.74 94.9167 1 [Waypoints]
-951.649 -1885.02 98.0439 1 [Waypoints]
-940.293 -1899.8 97.74 1 [Idle]
-921.444 -2104.01 86.3951 1 [Random: 5 yards]
-876.737 -2789.97 92.6684 1 [Random: 5 yards]

Spells they cast (2)

3374 Entangling Net 6660 Shoot

Quest item loot (1)

5030 Centaur Bracers 80%

Loot (76)

2589 Linen Cloth 38.56% 2287 Haunch of Meat 4.48% 5020 Kolkar Booty Key 2.84% 1179 Ice Cold Milk 2.39% 858 Lesser Healing Potion 1.48% 2455 Minor Mana Potion 0.65% 818 Tigerseye 0.34% 1181 Scroll of Spirit 0.26% 3013 Scroll of Spirit Armor 0.26% 955 Scroll of Intellect 0.18% 1180 Scroll of Stamina 0.18% 1210 Shadowgem 0.11% 774 Malachite 0.1% 3644 Runic Cloth Bracers 0.1% 4692 Ceremonial Leather Cloak 0.1% 3286 Tribal Gloves 0.1% 4680 Brackwater Cloak 0.09% 4686 Runic Cloth Cloak 0.09% 3290 Ancestral Gloves 0.08% 3303 Brackwater Bracers 0.07% 3312 Ceremonial Leather Bracers 0.07% 3284 Tribal Boots 0.06% 3279 Battle Chain Boots 0.06% 4693 Ceremonial Leather Belt 0.04% 3649 Battle Buckler 0.03% 3311 Ceremonial Leather Boots 0.03% 4687 Runic Cloth Belt 0.03% 3281 Battle Chain Gloves 0.02% 856 Blue Leather Bag 0.02% 4681 Brackwater Girdle 0.02% 765 Silverleaf 0.02% 2996 Bolt of Linen Cloth 0.02% 2450 Briarthorn 0.02% 5503 Clam Meat 0.02% 2836 Coarse Stone 0.02% 785 Common Magebloom 0.02% 2770 Copper Ore 0.02% 414 Dalaran Sharp 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% 4592 Longjaw Mud Snapper 0.02% 1206 Moss Agate 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 2406 Pattern: Fine Leather Boots 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% 4345 Pattern: Red Woolen Boots 0.02% 2407 Pattern: White Leather Jerkin 0.02% 2447 Peacebloom 0.02% 3609 Plans: Copper Chain Vest 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 4605 Red-speckled Mushroom 0.02% 2835 Rough Stone 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 2775 Silver Ore 0.02% 2449 Snakeroot 0.02% 2452 Swiftthistle 0.02% 4537 Tel'Abim Banana 0.02% 2771 Tin Ore 0.02% 3289 Ancestral Boots 0.02% 2408 Pattern: Fine Leather Gloves 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 2555 Recipe: Swiftness Potion 0.01% 3304 Brackwater Gauntlets 0.01% 5574 White Leather Bag 0.01% 4408 Plans: Mechanical Squirrel 0.01% 2553 Recipe: Elixir of Minor Agility 0.01% 6271 Pattern: Red Linen Vest 0.01% 6342 Formula: Enchant Chest - Minor Mana 0.01% 5573 Green Leather Bag 0.01% 2657 Red Leather Bag 0.01% 4690 Hunting Belt 0% 118 Minor Healing Potion 0%

Reference loot (96)

3374 Calico Belt 2.5% 1495 Calico Boots 2.5% 3375 Calico Bracers 2.5% 1497 Calico Cloak 2.5% 1498 Calico Gloves 2.5% 1499 Calico Pants 2.5% 1501 Calico Vest 2.5% 2778 Cheap Blunderbuss 2.5% 1512 Crude Battle Axe 2.5% 2777 Feeble Shortbow 2.5% 2763 Fisherman Knife 2.5% 1510 Heavy Club 2.5% 1513 Old Greatsword 2.5% 1502 Patched Leather Belt 2.5% 1503 Patched Leather Boots 2.5% 1504 Patched Leather Bracers 2.5% 1505 Patched Leather Cloak 2.5% 1506 Patched Leather Gloves 2.5% 1507 Patched Leather Pants 2.5% 1509 Patched Leather Vest 2.5% 1515 Rough Wooden Staff 2.5% 1514 Rusty Warhammer 2.5% 1511 Warped Shortsword 2.5% 2214 Wooden Buckler 2.5% 2215 Wooden Shield 2.5% 1516 Worn Hatchet 2.5% 1730 Worn Mail Belt 2.5% 1731 Worn Mail Boots 2.5% 1732 Worn Mail Bracers 2.5% 1733 Worn Mail Cloak 2.5% 1734 Worn Mail Gloves 2.5% 1735 Worn Mail Pants 2.5% 1737 Worn Mail Vest 2.5% 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%

Pickpocketing loot (4)

5369 Gnawed Bone 7.39% 2287 Haunch of Meat 7.39% 858 Lesser Healing Potion 3.11% 818 Tigerseye 0.78%

NPC equips (2)

5258 Monster - Bow, Black 1895 Monster - Sword, Short Rusty

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 3272);
Field Value
entry 3272
display_id1 172
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Kolkar Wrangler
subname
static_flags 0x80000: Amphibious
gossip_menu_id 0
level_min 12
level_max 13
faction 130: Kolkar
npc_flags None
speed_walk 0.666668
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
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 7: Humanoid
type_flags 0
loot_id 3272
pickpocket_loot_id 3272
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 12024 (not found)
spell_id2 6660: Shoot
spell_id3 -
spell_id4 -
spell_list_id 32720
pet_spell_list_id 0
auras
gold_min 3c
gold_max 27c
ai_name EventAI
movement_type 1: Random
inhabit_type Ground
civilian 0
racial_leader 0
regeneration 3
equipment_id 3272
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name