Database

Alpha 0.5.3

Snapjaw

Creature

General

Creature model for display ID 1244
Field Value
entry 2408
display_id1 1244
level_min 30
faction 7: Creature
npc_flags None
health_multiplier 1.1
mana_multiplier 1

Spawn points — Eastern Kingdoms (83)

220.06 -1246.31 31.8931 0 [Random: 10 yards]
-217.324 -1112.84 36.5141 0 [Random: 10 yards]
-353.883 -1101.47 34.308 0 [Random: 10 yards]
-282.934 -1101.48 34.6138 0 [Random: 10 yards]
-10.297 -1111.86 36.0626 0 [Random: 10 yards]
38.7226 -1118.58 35.1442 0 [Random: 10 yards]
109.992 -1144.96 35.6038 0 [Random: 10 yards]
-147.432 -1122.47 35.0195 0 [Random: 10 yards]
-89.647 -1107.8 36.2228 0 [Random: 10 yards]
-416.085 -1047.23 33.5042 0 [Random: 10 yards]
-817.78 -722.526 5.98992 0 [Random: 10 yards]
-679.263 -737.658 4.99451 0 [Random: 10 yards]
-750.862 -723.454 6.51497 0 [Random: 10 yards]
-513.542 -907.291 27.3546 0 [Random: 10 yards]
-554.598 -827.135 4.103 0 [Random: 10 yards]
-607.361 -751.986 9.6924 0 [Random: 10 yards]
-446.439 -979.246 29.3821 0 [Random: 10 yards]
1305.14 -165.002 31.715 0 [Random: 10 yards]
1382.63 -48.008 29.06 0 [Random: 10 yards]
501.71 367.273 32.092 0 [Random: 10 yards]
626.913 226.556 30.2463 0 [Random: 10 yards]
522.449 287.346 31.376 0 [Random: 10 yards]
1107.05 -245.07 31.518 0 [Random: 10 yards]
1083.79 -233.505 31.873 0 [Random: 10 yards]
1276.19 -173.948 32.26 0 [Random: 10 yards]
989.906 -182.861 32.318 0 [Random: 10 yards]
643.507 -1759.37 35.255 0 [Random: 10 yards]
627.497 351.656 32.973 0 [Random: 10 yards]
1098.03 -239.337 31.408 0 [Random: 10 yards]
771.679 61.923 31.09 0 [Random: 10 yards]
692.105 222.504 30.788 0 [Random: 10 yards]
1248.5 -218.781 31.3986 0 [Random: 10 yards]
464.305 458.728 31.448 0 [Random: 10 yards]
537.292 252.91 31.146 0 [Random: 10 yards]
1019.31 -209.28 32.9553 0 [Random: 10 yards]
996.828 -183.086 31.21 0 [Random: 10 yards]
782.688 -46.53 32.774 0 [Random: 10 yards]
757.872 97.118 31.082 0 [Random: 10 yards]
758.471 -7.942 29.354 0 [Random: 10 yards]
526.512 317.447 28.928 0 [Random: 10 yards]
531.549 356.939 23.545 0 [Random: 10 yards]
472.883 391.111 36.0622 0 [Random: 10 yards]
483.717 437.453 24.762 0 [Random: 10 yards]
477.272 417.999 30.783 0 [Random: 10 yards]
930.129 -113.634 32.018 0 [Random: 10 yards]
986.152 -175.353 31.4827 0 [Random: 10 yards]
953.817 -138.11 31.4956 0 [Random: 10 yards]
841.197 -58.457 29.115 0 [Random: 10 yards]
838.392 -88.2026 35.664 0 [Random: 10 yards]
821.06 -79.2174 34.6273 0 [Random: 10 yards]
898.499 -85.499 32.216 0 [Random: 10 yards]
870.975 -91.2215 34.4972 0 [Random: 10 yards]
815.594 -66.103 32.532 0 [Random: 10 yards]
622.258 -1715.54 34.859 0 [Random: 10 yards]
521.358 -1538.59 36.5165 0 [Random: 10 yards]
457.212 -1482.02 34.3521 0 [Random: 10 yards]
493.588 -1531.61 33.828 0 [Random: 10 yards]
419.324 -1464.54 33.9715 0 [Random: 10 yards]
404.519 -1464.41 34.9943 0 [Random: 10 yards]
542.834 -1592 34.943 0 [Random: 10 yards]
588.471 -1651.22 34.9343 0 [Random: 10 yards]
392.686 -1445.17 34.7555 0 [Random: 10 yards]
320.698 -1378.55 34.7827 0 [Random: 10 yards]
303.062 -1356.19 35.3282 0 [Random: 10 yards]
759.524 -22.0947 32.0148 0 [Random: 10 yards]
790.977 -48.3493 32.1981 0 [Random: 10 yards]
1149.13 -254.463 30.377 0 [Random: 10 yards]
514.773 287.679 33.3248 0 [Random: 10 yards]
569.215 233.347 28.891 0 [Random: 10 yards]
544.797 260.476 28.611 0 [Random: 10 yards]
584.333 217.015 32.3279 0 [Random: 10 yards]
653.175 123.714 33.0338 0 [Random: 10 yards]
675.248 104.815 30.684 0 [Random: 10 yards]
616.758 188.439 33.1991 0 [Random: 10 yards]
644.817 143.254 32.0083 0 [Random: 10 yards]
684.251 87.6968 32.2845 0 [Random: 10 yards]
914.714 -109.735 33.8974 0 [Random: 10 yards]
705.295 34.7223 33.9719 0 [Random: 10 yards]
229.941 -1254.32 32.1782 0 [Random: 10 yards]
264.946 -1277.44 37.1807 0 [Random: 10 yards]
285.907 -1316.24 35.1194 0 [Random: 10 yards]
332.292 -1421.88 35 0 [Random: 10 yards]
1386.61 -58.675 34.514 0 [Random: 5 yards]

Loot (85)

3712 Turtle Meat 100% 5524 Thick-shelled Clam 53.11% 4556 Speckled Shell Fragment 26.35% 4555 Thick Scaly Tail 26.21% 6308 Raw Bristle Whisker Catfish 13.17% 5504 Tangy Clam Meat 2.22% 3357 Liferoot 0.12% 1529 Jade 0.08% 4633 Heavy Bronze Lockbox 0.07% 4634 Iron Lockbox 0.07% 1705 Lesser Moonstone 0.06% 1206 Moss Agate 0.06% 2771 Tin Ore 0.04% 5498 Small Lustrous Pearl 0.04% 5500 Iridescent Pearl 0.02% 3864 Citrine 0.02% 4305 Bolt of Silk Cloth 0.02% 2997 Bolt of Wool 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% 2770 Copper Ore 0.02% 3356 Crownroyal 0.02% 6375 Formula: Enchant Bracer - Lesser Spirit 0.02% 929 Healing Potion 0.02% 2838 Heavy Stone 0.02% 2772 Iron Ore 0.02% 3358 Khadgar's Whisker 0.02% 5576 Large Brown Sack 0.02% 5575 Large Green Sack 0.02% 857 Large Red Sack 0.02% 3385 Lesser Mana Potion 0.02% 774 Malachite 0.02% 3827 Mana Potion 0.02% 4297 Pattern: Barbaric Gloves 0.02% 4352 Pattern: Boots of the Enchanter 0.02% 4296 Pattern: Dark Leather Shoulders 0.02% 5972 Pattern: Fine Leather Pants 0.02% 2601 Pattern: Gray Woolen Robe 0.02% 5774 Pattern: Green Silk Pack 0.02% 4299 Pattern: Guardian Armor 0.02% 4298 Pattern: Guardian Belt 0.02% 5974 Pattern: Guardian Cloak 0.02% 4300 Pattern: Guardian Leather Bracers 0.02% 4294 Pattern: Hillman's Belt 0.02% 4348 Pattern: Phoenix Gloves 0.02% 4349 Pattern: Phoenix Pants 0.02% 4351 Pattern: Shadow Hood 0.02% 4353 Pattern: Spider Belt 0.02% 4350 Pattern: Spider Silk Slippers 0.02% 6391 Pattern: Stylish Green Shirt 0.02% 2883 Plans: Deadly Bronze Poniard 0.02% 3868 Plans: Frost Tiger Blade 0.02% 3867 Plans: Golden Iron Destroyer 0.02% 3873 Plans: Golden Scale Cuirass 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% 6045 Plans: Iron Counterweight 0.02% 6044 Plans: Iron Shield Spike 0.02% 3866 Plans: Jade Serpentblade 0.02% 3608 Plans: Mighty Iron Hammer 0.02% 4414 Plans: Portable Bronze Mortar 0.02% 3869 Plans: Shadow Crescent Axe 0.02% 5578 Plans: Silvered Bronze Breastplate 0.02% 2882 Plans: Silvered Bronze Shoulders 0.02% 3830 Recipe: Elixir of Fortitude 0.02% 3396 Recipe: Elixir of Lesser Agility 0.02% 6211 Recipe: Elixir of Ogre's Strength 0.02% 3831 Recipe: Mighty Troll's Blood Potion 0.02% 3393 Recipe: Minor Magic Resistance Potion 0.02% 2835 Rough Stone 0.02% 4415 Schematic: Craftsman's Monocle 0.02% 4417 Schematic: Large Seaforium Charge 0.02% 4412 Schematic: Moonsight Rifle 0.02% 4410 Schematic: Shadow Goggles 0.02% 2775 Silver Ore 0.02% 2452 Swiftthistle 0.02% 3355 Wild Steelbloom 0.02% 1725 Large Knapsack 0.01% 804 Large Blue Sack 0%

Reference loot (87)

3041 "Mage-Eye" Blunderbuss 0.5% 3185 Acrobatic Staff 0.5% 3042 BKP "Sparrow" Smallbore 0.5% 5007 Band of Thorns 0.5% 4998 Blood Ring 0.5% 3210 Brutal War Axe 0.5% 4066 Combat Buckler 0.5% 2819 Cross Dagger 0.5% 5003 Crystal Starfire Medallion 0.5% 6406 Darkweave Boots 0.5% 4719 Darkweave Cloak 0.5% 4039 Darkweave Cowl 0.5% 6407 Darkweave Cuffs 0.5% 4040 Darkweave Gloves 0.5% 4718 Darkweave Mantle 0.5% 4720 Darkweave Sash 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% 6396 Emblazoned Chestpiece 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% 3066 Flameweave Gloves 0.5% 3057 Forest Leather Boots 0.5% 3202 Forest Leather Bracers 0.5% 3058 Forest Leather Gloves 0.5% 4709 Forest Leather Mantle 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% 2080 Hillborne Axe 0.5% 6409 Insignia Belt 0.5% 4055 Insignia Boots 0.5% 6410 Insignia Bracers 0.5% 4722 Insignia Cloak 0.5% 6408 Insignia Gloves 0.5% 4052 Insignia Helm 0.5% 4054 Insignia Leggings 0.5% 4721 Insignia Mantle 0.5% 865 Leaden Mace 0.5% 6403 Mail Combat Armguards 0.5% 4717 Mail Combat Belt 0.5% 4076 Mail Combat Boots 0.5% 4716 Mail Combat Cloak 0.5% 4075 Mail Combat Gauntlets 0.5% 4077 Mail Combat Helm 0.5% 6404 Mail Combat Spaulders 0.5% 5213 Scorching Wand 0.5% 3197 Stonecutter Claymore 0.5% 3206 Two-handed Cavalier Sword 0.5% 5214 Wand of Eventide 0.5% 3037 Whipwood Recurve Bow 0.5% 2878 Bearded Axe 0.01% 720 Brawler Gloves 0.01% 2299 Burning War Axe 0.01% 2877 Claymore of the Martyr 0.01% 3203 Dense Triangle Mace 0.01% 1717 Double Link Mail Tunic 0.01% 3020 Enduring Cap 0.01% 2278 Forest Tracker Epaulets 0.01% 791 Gnarled Ash Staff 0.01% 2721 Holy Shroud 0.01% 2277 Necromancer Leggings 0.01% 2565 Rod of Molten Fire 0.01% 2912 Shadow Claw 0.01%

Skinning loot (4)

2319 Medium Leather 73.39% 4234 Heavy Leather 19.94% 4232 Medium Hide 4.72% 4235 Heavy Hide 1.93%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 2408);
Field Value
entry 2408
display_id1 1244
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Snapjaw
subname
static_flags 0x10080010: Tameable, Amphibious
gossip_menu_id 0
level_min 30
level_max 31
faction 7: 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.1
mana_multiplier 1
armor_multiplier 1.5
base_attack_time 2 sec
ranged_attack_time 2 sec
unit_class 1
unit_flags 0
dynamic_flags 0
beast_family 21
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 1: Beast
type_flags 1
loot_id 2408
pickpocket_loot_id 0
skinning_loot_id 2408
holy_res 0
fire_res 0
nature_res 0
frost_res 75
shadow_res 0
arcane_res 0
spell_id1 -
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 5924
auras
gold_min 0
gold_max 0
ai_name
movement_type 1: Random
inhabit_type Ground, Water
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