Pygmy Tide Crawler

Creature

General

Creature model for display ID 996
Field Value
entry 2231
display_id1 996
level_min 9
faction 7: Creature
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Kalimdor (47)

6572.55 490.47 -4.35711 1 [Random: 10 yards]
6099.65 622.176 -16.883 1 [Random: 10 yards]
6508.3 528.684 -6.855 1 [Random: 10 yards]
6553.63 500.796 1.235 1 [Random: 10 yards]
6768.32 510.012 0.313 1 [Random: 10 yards]
6766.5 528.856 -1.39557 1 [Random: 10 yards]
6564.36 525.848 1.24242 1 [Random: 10 yards]
6613.53 548.947 -1.11178 1 [Random: 10 yards]
6519.31 534.221 -1.703 1 [Random: 10 yards]
6701.2 538.34 1.004 1 [Random: 10 yards]
6699.21 545.364 -0.299 1 [Random: 10 yards]
6456.29 637.494 -1.688 1 [Random: 10 yards]
6583.54 559.128 -1.334 1 [Random: 10 yards]
6580.92 562.914 -8.74 1 [Random: 10 yards]
6612.4 582.29 -3.699 1 [Random: 10 yards]
6230.72 614.642 -1.839 1 [Random: 10 yards]
6151.58 603.786 -8.51736 1 [Random: 10 yards]
6394.72 649.759 -15.8482 1 [Random: 10 yards]
6384.17 620.565 -5.54881 1 [Random: 10 yards]
6118.29 612.486 -8.6752 1 [Random: 10 yards]
6158.83 576.162 0.988 1 [Random: 10 yards]
6175.4 578.148 0.786 1 [Random: 10 yards]
6226.07 615.735 -2.701 1 [Random: 10 yards]
6275.68 607.261 -6.5261 1 [Random: 10 yards]
6300.87 648.843 1.102 1 [Random: 10 yards]
6238.65 603.599 0.053 1 [Random: 10 yards]
6341.68 600.028 0.336 1 [Random: 10 yards]
6223.96 592.709 0.91362 1 [Random: 10 yards]
6219.98 539.372 6.82679 1 [Random: 10 yards]
6188.76 558.592 4.5108 1 [Random: 10 yards]
6261.08 605.526 -3.194 1 [Random: 10 yards]
6734.56 517.94 -0.043476 1 [Random: 10 yards]
6667.3 550.134 -0.562 1 [Random: 10 yards]
6781.98 518.284 0.137367 1 [Random: 10 yards]
6234.65 606.588 -0.379 1 [Random: 10 yards]
6724.72 543.251 -1.80785 1 [Random: 10 yards]
6187.59 551.989 5.2469 1 [Random: 10 yards]
6771.32 469.764 9.03506 1 [Random: 10 yards]
6159.18 547.081 5.7858 1 [Random: 10 yards]
6391.15 570.254 -1.17991 1 [Random: 10 yards]
6600.4 494.107 -1.85818 1 [Random: 10 yards]
6282.93 586.061 -0.445736 1 [Random: 10 yards]
6328.1 587.972 0.998501 1 [Random: 10 yards]
6758.12 535.652 -2.203 1 [Random: 10 yards]
6247.81 555.3 8.34744 1 [Random: 10 yards]
6644.44 508.35 0.595 1 [Random: 10 yards]
6714.96 511.258 2.26345 1 [Random: 10 yards]

Quest item loot (1)

Loot (70)

2675 Crawler Claw 34.98% 5523 Small Barnacled Clam 34.73% 2674 Crawler Meat 33.23% 4874 Clean Fishbones 21.08% 5506 Beady Eye Stalk 8.99% 774 Malachite 1.36% 5503 Clam Meat 1.24% 818 Tigerseye 0.44% 4563 Billy Club 0.38% 768 Lumberjack Axe 0.36% 4671 Ancestral Cloak 0.32% 3642 Ancestral Bracers 0.3% 2598 Pattern: Red Linen Robe 0.26% 3609 Plans: Copper Chain Vest 0.26% 5571 Small Black Pouch 0.25% 828 Small Blue Pouch 0.25% 4496 Small Brown Pouch 0.25% 5572 Small Green Pouch 0.25% 805 Small Red Pouch 0.25% 3280 Battle Chain Bracers 0.21% 2698 Recipe: Cooked Crab Claw 0.2% 3641 Strapped Bracers 0.2% 4675 Tribal Belt 0.18% 4674 Tribal Cloak 0.16% 4672 Ancestral Sash 0.15% 3190 Beatstick 0.14% 3189 Wood Chopper 0.14% 767 Long Bo Staff 0.12% 3289 Ancestral Boots 0.12% 4668 Battle Chain Cloak 0.12% 3649 Battle Buckler 0.11% 3285 Tribal Bracers 0.11% 4669 Battle Chain Girdle 0.08% 3281 Battle Chain Gloves 0.08% 3290 Ancestral Gloves 0.07% 4692 Ceremonial Leather Cloak 0.07% 3650 Battle Shield 0.05% 3644 Runic Cloth Bracers 0.05% 1179 Ice Cold Milk 0.04% 5498 Small Lustrous Pearl 0.04% 3303 Brackwater Bracers 0.04% 4686 Runic Cloth Cloak 0.04% 3286 Tribal Gloves 0.04% 3279 Battle Chain Boots 0.03% 4680 Brackwater Cloak 0.02% 3200 Burnt Leather Bracers 0.02% 785 Common Magebloom 0.02% 2959 Cozy Moccasins 0.02% 414 Dalaran Sharp 0.02% 6342 Formula: Enchant Chest - Minor Mana 0.02% 4541 Freshly Baked Bread 0.02% 2287 Haunch of Meat 0.02% 2960 Journeyman's Gloves 0.02% 4592 Longjaw Mud Snapper 0.02% 4683 Magister's Cloak 0.02% 2406 Pattern: Fine Leather Boots 0.02% 2408 Pattern: Fine Leather Gloves 0.02% 6271 Pattern: Red Linen Vest 0.02% 2407 Pattern: White Leather Jerkin 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 4408 Plans: Mechanical Squirrel 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 2555 Recipe: Swiftness Potion 0.02% 3820 Stranglekelp 0.02% 4537 Tel'Abim Banana 0.02% 2967 Warrior's Boots 0.02% 4658 Warrior's Cloak 0.02% 2968 Warrior's Gloves 0.02% 3312 Ceremonial Leather Bracers 0.01% 3284 Tribal Boots 0.01%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 2231);
Field Value
entry 2231
display_id1 996
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Pygmy Tide Crawler
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 9
level_max 10
faction 7: Creature
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
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 8
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 1: Beast
type_flags 16
loot_id 2231
pickpocket_loot_id 0
skinning_loot_id 0
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, 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