Great Goretusk

Creature

General

Creature model for display ID 499
Field Value
entry 547
display_id1 499
level_min 16
faction 189: Creature
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Eastern Kingdoms (47)

-9291.38 -1889.91 79.8584 0 [Random: 5 yards]
-9254.54 -1944.67 78.7819 0 [Random: 10 yards]
-8822.79 -2574.16 131.618 0 [Random: 5 yards]
-8781.58 -2587.95 130.887 0 [Random: 5 yards]
-8725.97 -2577.49 132.657 0 [Random: 5 yards]
-8940.86 -2624.51 132.326 0 [Random: 5 yards]
-9206.77 -1972.63 110.657 0 [Random: 5 yards]
-9153.69 -2001.35 121.791 0 [Random: 5 yards]
-8871.61 -2551.55 130.748 0 [Random: 5 yards]
-9710.89 -2107.72 60.2623 0 [Random: 5 yards]
-9620.74 -2252.31 85.1398 0 [Random: 10 yards]
-9636.79 -2200.59 69.9214 0 [Random: 5 yards]
-8811.43 -2488.36 132.978 0 [Random: 5 yards]
-9666.22 -2172.84 60.6417 0 [Random: 5 yards]
-9724.1 -2153.24 59.8127 0 [Random: 10 yards]
-9527.5 -2294.12 73.1432 0 [Random: 10 yards]
-9459.22 -2307.58 69.6735 0 [Random: 5 yards]
-9606.78 -2306.57 70.7103 0 [Random: 10 yards]
-9708.88 -2227.86 58.3406 0 [Random: 10 yards]
-9636.21 -2404.24 62.0477 0 [Random: 10 yards]
-9723.79 -2185.7 59.5904 0 [Random: 5 yards]
-9451.39 -2122.71 69.88 0 [Random: 5 yards]
-9375.17 -1954.55 59.1294 0 [Random: 10 yards]
-9356.52 -1909.16 66.1403 0 [Random: 5 yards]
-9356.55 -1968.46 58.7977 0 [Random: 5 yards]
-9332.29 -1935.76 58.4154 0 [Random: 5 yards]
-9604.3 -2267.13 85.2955 0 [Random: 5 yards]
-9628.7 -1992.81 61.5397 0 [Random: 10 yards]
-9604.07 -1959.59 64.5037 0 [Random: 5 yards]
-9557.83 -2247.17 85.381 0 [Random: 10 yards]
-10993.6 1105.98 39.0421 0 [Random: 5 yards]
-11054.6 652.899 34.2431 0 [Random: 10 yards]
-10776.3 959.516 43.0739 0 [Random: 10 yards]
-10602 831.624 49.6781 0 [Random: 5 yards]
-11003.5 1278.4 43.1867 0 [Random: 10 yards]
-10854.7 982.644 33.8116 0 [Random: 5 yards]
-10978.9 1019.41 37.3854 0 [Random: 10 yards]
-10987 965.955 35.0471 0 [Random: 10 yards]
-10976.4 887.5 36.1314 0 [Random: 5 yards]
-10988.6 1108.85 39.6838 0 [Random: 5 yards]
-10977 1207.59 43.4901 0 [Random: 10 yards]
-10578.1 908.086 38.957 0 [Random: 5 yards]
-10545.4 953.413 43.8703 0 [Random: 5 yards]
-10955.7 767.409 41.0726 0 [Random: 10 yards]
-10989.2 682.318 34.6875 0 [Random: 10 yards]
-10685 778.717 48.4887 0 [Random: 10 yards]
-10728.1 952.895 47.0933 0 [Random: 5 yards]

Loot (75)

769 Chunk of Boar Meat 77.25% 723 Goretusk Liver 36.96% 3172 Boar Intestines 36.79% 2296 Great Goretusk Snout 36.43% 2677 Boar Ribs 31.84% 771 Chipped Boar Tusk 6.02% 2295 Large Boar Tusk 4.42% 1210 Shadowgem 0.32% 1206 Moss Agate 0.1% 818 Tigerseye 0.1% 2700 Recipe: Succulent Pork Ribs 0.08% 2770 Copper Ore 0.06% 856 Blue Leather Bag 0.02% 2996 Bolt of Linen Cloth 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% 414 Dalaran Sharp 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% 6342 Formula: Enchant Chest - Minor Mana 0.02% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.02% 4541 Freshly Baked Bread 0.02% 2287 Haunch of Meat 0.02% 1179 Ice Cold Milk 0.02% 858 Lesser Healing Potion 0.02% 2589 Linen Cloth 0.02% 774 Malachite 0.02% 2455 Minor Mana Potion 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 2406 Pattern: Fine Leather Boots 0.02% 2408 Pattern: Fine Leather Gloves 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% 2598 Pattern: Red Linen Robe 0.02% 6271 Pattern: Red Linen Vest 0.02% 4345 Pattern: Red Woolen Boots 0.02% 4347 Pattern: Reinforced Woolen Shoulders 0.02% 6390 Pattern: Stylish Blue Shirt 0.02% 6391 Pattern: Stylish Green Shirt 0.02% 2407 Pattern: White Leather Jerkin 0.02% 2447 Peacebloom 0.02% 2883 Plans: Deadly Bronze Poniard 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 4408 Plans: Mechanical Squirrel 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 5578 Plans: Silvered Bronze Breastplate 0.02% 2882 Plans: Silvered Bronze Shoulders 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 3394 Recipe: Elixir of Poison Resistance 0.02% 3393 Recipe: Minor Magic Resistance Potion 0.02% 2555 Recipe: Swiftness Potion 0.02% 4605 Red-speckled Mushroom 0.02% 2835 Rough Stone 0.02% 4410 Schematic: Shadow Goggles 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 2775 Silver Ore 0.02% 765 Silverleaf 0.02% 5498 Small Lustrous Pearl 0.02% 2449 Snakeroot 0.02% 2452 Swiftthistle 0.02% 4537 Tel'Abim Banana 0.02% 2771 Tin Ore 0.02% 5573 Green Leather Bag 0.01% 2657 Red Leather Bag 0.01% 5574 White Leather Bag 0.01%

Reference loot (188)

1814 Battered Mallet 2.5% 1823 Bludgeoning Cudgel 2.5% 1811 Blunt Claymore 2.5% 2220 Box Shield 2.5% 3378 Brocade Belt 2.5% 3379 Brocade Bracers 2.5% 1774 Brocade Cloak 2.5% 1776 Brocade Cloth Pants 2.5% 1777 Brocade Cloth Shoulderpads 2.5% 1778 Brocade Cloth Vest 2.5% 1775 Brocade Gloves 2.5% 1772 Brocade Shoes 2.5% 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% 3376 Canvas Belt 2.5% 1764 Canvas Boots 2.5% 3377 Canvas Bracers 2.5% 1766 Canvas Cloak 2.5% 1767 Canvas Gloves 2.5% 1768 Canvas Pants 2.5% 1769 Canvas Shoulderpads 2.5% 1770 Canvas Vest 2.5% 1822 Cedar Walking Staff 2.5% 2778 Cheap Blunderbuss 2.5% 1813 Chipped Quarterstaff 2.5% 1512 Crude Battle Axe 2.5% 2781 Dirty Blunderbuss 2.5% 2777 Feeble Shortbow 2.5% 2763 Fisherman Knife 2.5% 1819 Gouging Pick 2.5% 1510 Heavy Club 2.5% 2765 Hunting Knife 2.5% 1738 Laced Mail Belt 2.5% 1739 Laced Mail Boots 2.5% 1740 Laced Mail Bracers 2.5% 1741 Laced Mail Cloak 2.5% 1742 Laced Mail Gloves 2.5% 1743 Laced Mail Pants 2.5% 1744 Laced Mail Shoulderpads 2.5% 1745 Laced Mail Vest 2.5% 2780 Light Hunting Bow 2.5% 1746 Linked Chain Belt 2.5% 1747 Linked Chain Boots 2.5% 1748 Linked Chain Bracers 2.5% 1749 Linked Chain Cloak 2.5% 1750 Linked Chain Gloves 2.5% 1751 Linked Chain Pants 2.5% 1752 Linked Chain Shoulderpads 2.5% 1753 Linked Chain Vest 2.5% 2782 Mishandled Recurve Bow 2.5% 1513 Old Greatsword 2.5% 1815 Ornamental Mace 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% 1794 Patched Leather Jerkin 2.5% 1792 Patched Leather Pants 2.5% 1507 Patched Leather Pants 2.5% 1509 Patched Leather Vest 2.5% 1787 Rawhide Belt 2.5% 1788 Rawhide Boots 2.5% 1796 Rawhide Boots 2.5% 1789 Rawhide Bracers 2.5% 1790 Rawhide Cloak 2.5% 1798 Rawhide Cloak 2.5% 1791 Rawhide Gloves 2.5% 1799 Rawhide Gloves 2.5% 1800 Rawhide Pants 2.5% 1793 Rawhide Shoulderpads 2.5% 1802 Rawhide Vest 2.5% 2217 Rectangular Shield 2.5% 1515 Rough Wooden Staff 2.5% 1514 Rusty Warhammer 2.5% 1824 Shiny War Axe 2.5% 2783 Shoddy Blunderbuss 2.5% 1817 Short Cutlass 2.5% 1812 Short-handled Battle Axe 2.5% 2216 Simple Buckler 2.5% 2764 Small Dagger 2.5% 2219 Small Round Shield 2.5% 1818 Standard Claymore 2.5% 1795 Tough Leather Belt 2.5% 1797 Tough Leather Bracers 2.5% 1801 Tough Leather Shoulderpads 2.5% 1816 Unbalanced Axe 2.5% 1821 Warped Blade 2.5% 1511 Warped Shortsword 2.5% 2214 Wooden Buckler 2.5% 1820 Wooden Maul 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% 3195 Barbaric Battle Axe 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% 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% 3314 Ceremonial Leather Gloves 0.5% 3315 Ceremonial Leather Pants 0.5% 3313 Ceremonial Leather Tunic 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% 3196 Edged Bastard Sword 0.5% 4568 Grunt Axe 0.5% 3036 Heavy Shortbow 0.5% 3040 Hunter's Muzzle Loader 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% 2987 Inscribed Leather Boots 0.5% 3205 Inscribed Leather Bracers 0.5% 2985 Inscribed Leather Breastplate 0.5% 4701 Inscribed Leather Cloak 0.5% 2988 Inscribed Leather Gloves 0.5% 2986 Inscribed Leather Pants 0.5% 4576 Light Bow 0.5% 2970 Magister's Pants 0.5% 2969 Magister's Vest 0.5% 4575 Medicine Staff 0.5% 2078 Northern Shortsword 0.5% 3193 Oak Mallet 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% 3310 Runic Cloth 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% 2984 Seer's Gloves 0.5% 2982 Seer's Pants 0.5% 2981 Seer's Robe 0.5% 4699 Seer's Sash 0.5% 2079 Sergeant's Warhammer 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% 5207 Twilight Wand 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% 3184 Wavy Blladed Knife 0.5%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 547);
Field Value
entry 547
display_id1 499
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Great Goretusk
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 16
level_max 17
faction 189: Creature
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
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 5
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 1: Beast
type_flags 16
loot_id 547
pickpocket_loot_id 0
skinning_loot_id 547
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 6268: Rushing Charge
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 0
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