Database

Alpha 0.5.3

Surf Crawler

Creature

General

Creature model for display ID 1938
Field Value
entry 3107
display_id1 1938
level_min 7
faction 7: Creature
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Kalimdor (59)

-990.279 -5455.54 3.426 1 [Random: 5 yards]
809.335 -5074.06 3.526 1 [Random: 5 yards]
-801.224 -5301.3 0.549 1 [Random: 10 yards]
-1463.44 -5314.72 -1.81 1 [Random: 5 yards]
-760.886 -5470.73 -1.76081 1 [Random: 10 yards]
-1477.05 -5301.59 1.616 1 [Random: 5 yards]
-885.142 -5507.15 -2.12263 1 [Random: 5 yards]
-1059.25 -5285.51 -0.918 1 [Random: 5 yards]
-873.053 -5278.66 -9.99352 1 [Random: 10 yards]
-686.708 -5462.52 -0.809426 1 [Random: 5 yards]
-1538.25 -5234.88 4.898 1 [Random: 5 yards]
-961.545 -5556.51 2.674 1 [Random: 5 yards]
1006.22 -5142.18 -2.398 1 [Random: 5 yards]
-868.156 -5688.42 -2.09878 1 [Random: 5 yards]
-968.844 -5645.49 0.147 1 [Random: 5 yards]
917.165 -5132.88 0.207 1 [Random: 5 yards]
-710.822 -5723.1 2.232 1 [Random: 5 yards]
-1511.35 -5376.41 2.6803 1 [Random: 10 yards]
-1391 -5504.86 -3.305 1 [Random: 5 yards]
937.858 -5149.32 -3.69777 1 [Random: 5 yards]
-1212.61 -5144.8 -3.282 1 [Random: 5 yards]
-798.381 -5715.48 2.559 1 [Random: 5 yards]
1186.65 -5183.53 -23.386 1 [Random: 5 yards]
-1480.49 -5408.35 -5.752 1 [Random: 5 yards]
-959.173 -5370.48 -2.339 1 [Random: 5 yards]
-1330.08 -5341.29 -0.113 1 [Random: 5 yards]
-905.512 -5327.26 -1.797 1 [Random: 5 yards]
-1229.8 -5076.13 -3.718 1 [Random: 5 yards]
-988.221 -5245.89 -2.926 1 [Random: 5 yards]
856.114 -5127.18 -0.986 1 [Random: 5 yards]
-1476.89 -5328.13 1.298 1 [Random: 5 yards]
-1593.28 -5380.13 1.135 1 [Random: 5 yards]
-1443.96 -5150.13 -0.475 1 [Random: 5 yards]
-879.573 -5610.25 -0.631 1 [Random: 10 yards]
-1359.53 -5402.94 1.619 1 [Random: 5 yards]
-852.655 -5519.09 -0.082 1 [Random: 5 yards]
-727.78 -5350.62 -2.776 1 [Random: 5 yards]
-1136.39 -5044.12 -4.92716 1 [Random: 5 yards]
-892.788 -5246.16 -9.60551 1 [Random: 10 yards]
-1399.05 -5449.02 -4.319 1 [Random: 5 yards]
-645.165 -5472.78 -2.009 1 [Random: 5 yards]
-1645.65 -5309.75 2.489 1 [Random: 5 yards]
-1015.17 -5687.38 -0.678 1 [Random: 5 yards]
-1244.33 -5179.53 -2.432 1 [Random: 5 yards]
-1261.19 -5215.46 -1.688 1 [Random: 5 yards]
-1075.95 -5195.07 -0.832 1 [Random: 5 yards]
-1276.97 -5639.94 2.224 1 [Random: 5 yards]
-1383.3 -5244.66 -1.079 1 [Random: 5 yards]
-614.52 -5552.22 0.932 1 [Random: 5 yards]
916.73 -5173.42 -10.969 1 [Random: 5 yards]
-623.455 -5691.47 -0.394 1 [Random: 5 yards]
-822.853 -5425.31 -1.797 1 [Random: 5 yards]
-950.246 -5625.07 -0.574 1 [Random: 5 yards]
-1654.57 -5378.45 -0.304 1 [Random: 5 yards]
975.653 -5123.24 3.281 1 [Random: 5 yards]
-1044.68 -5244.82 -7.59438 1 [Random: 5 yards]
-857.67 -5448.66 -4.81423 1 [Random: 5 yards]
-1014.99 -5126.25 -0.062 1 [Random: 5 yards]
-744.849 -5434.33 -4.494 1 [Random: 5 yards]

Quest item loot (1)

4888 Crawler Mucus 80%

Loot (34)

4873 Dry Hardened Barnacle 54.27% 4874 Clean Fishbones 22.26% 774 Malachite 1.54% 818 Tigerseye 0.42% 766 Flanged Mace 0.4% 767 Long Bo Staff 0.38% 3189 Wood Chopper 0.36% 3190 Beatstick 0.34% 2598 Pattern: Red Linen Robe 0.34% 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% 4563 Billy Club 0.22% 4565 Battle Knife 0.18% 4560 Fine Scimitar 0.14% 768 Lumberjack Axe 0.14% 2770 Copper Ore 0.02% 6342 Formula: Enchant Chest - Minor Mana 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% 2447 Peacebloom 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 2555 Recipe: Swiftness Potion 0.02% 159 Refreshing Spring Water 0.02% 2835 Rough Stone 0.02% 4536 Shiny Red Apple 0.02% 765 Silverleaf 0.02% 4540 Tough Hunk of Bread 0.02%

Reference loot (10)

2962 Burnt Leather Pants 0.5% 2961 Burnt Leather Vest 0.5% 2140 Carving Knife 0.5% 2958 Journeyman's Pants 0.5% 2957 Journeyman's Vest 0.5% 727 Notched Shortsword 0.5% 4561 Scalping Tomahawk 0.5% 4562 Severing Axe 0.5% 2966 Warrior's Pants 0.5% 2965 Warrior's Tunic 0.5%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 3107);
Field Value
entry 3107
display_id1 1938
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Surf Crawler
subname
static_flags 0x80010: Tameable, Amphibious
gossip_menu_id 0
level_min 7
level_max 8
faction 7: Creature
npc_flags None
speed_walk 1
speed_run 0.857143
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.101 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 1
loot_id 3107
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 EventAI
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