Database

Alpha 0.5.3

Clattering Scorpid

Creature

General

Creature model for display ID 2486
Field Value
entry 3125
display_id1 2486
level_min 5
faction 60: Dragonflight - Red
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Kalimdor (71)

197.564 -4969.24 13.6588 1 [Random: 10 yards]
188.641 -5019.8 12.6547 1 [Random: 10 yards]
-688.159 -4987.74 19.7873 1 [Random: 10 yards]
-284.233 -4857.56 34.3123 1 [Random: 10 yards]
-848.249 -4618.33 44.8452 1 [Random: 10 yards]
-344.096 -4845.91 39.8805 1 [Random: 10 yards]
-663.184 -4903.87 30.8102 1 [Random: 10 yards]
304.512 -4987.1 17.1312 1 [Random: 5 yards]
294.561 -5019.29 13.4365 1 [Random: 10 yards]
232.716 -5084.86 11.0905 1 [Random: 10 yards]
-691.481 -4957.31 23.1926 1 [Random: 10 yards]
-746.218 -4744.62 31.5489 1 [Random: 5 yards]
-486.359 -4824.19 36.5391 1 [Random: 10 yards]
-688.767 -5045.84 17.2011 1 [Random: 10 yards]
-591.821 -4809.46 32.2656 1 [Random: 10 yards]
-786.505 -4714.73 31.3035 1 [Random: 5 yards]
-680.672 -4655.35 38.1271 1 [Random: 10 yards]
236.772 -5057.58 11.2487 1 [Random: 10 yards]
-781.204 -4705.88 32.8319 1 [Random: 5 yards]
345.725 -5016.48 19.2973 1 [Random: 5 yards]
210.404 -4972.72 14.4258 1 [Random: 10 yards]
-103.086 -4657.6 33.676 1 [Random: 10 yards]
326.787 -5118.37 3.74095 1 [Random: 10 yards]
27.9387 -5073.43 8.73164 1 [Random: 5 yards]
114.34 -5121.52 1.79737 1 [Random: 5 yards]
-788.5 -4724.95 30.19 1 [Random: 5 yards]
77.7985 -4921.86 12.4946 1 [Random: 5 yards]
104.669 -4977.64 11.5578 1 [Random: 5 yards]
244.559 -5122.25 5.86734 1 [Random: 10 yards]
-731.343 -5038.89 15.7219 1 [Random: 10 yards]
-553.688 -4840.2 36.8342 1 [Random: 10 yards]
-761.495 -4582.7 51.4225 1 [Random: 5 yards]
-658.536 -4858.06 40.104 1 [Random: 5 yards]
-622.742 -4823.74 26.245 1 [Random: 5 yards]
318.62 -5042.76 12.2757 1 [Random: 5 yards]
158.573 -5011.06 9.11651 1 [Random: 10 yards]
-588.754 -4895.5 34.1713 1 [Random: 10 yards]
-832.27 -4638.75 41.8502 1 [Random: 10 yards]
-432.512 -4854.03 37.6829 1 [Random: 5 yards]
-188.732 -4844.76 24.6295 1 [Random: 5 yards]
-823.612 -4577.57 51.0542 1 [Random: 10 yards]
-405.919 -4717.56 44.4453 1 [Random: 10 yards]
-478.389 -4839.04 37.4476 1 [Random: 10 yards]
-725.941 -4613.79 41.1353 1 [Random: 10 yards]
-622.387 -4837.24 26.4352 1 [Random: 5 yards]
189.8 -5111.89 5.41148 1 [Random: 10 yards]
284.559 -5082.87 9.10461 1 [Random: 10 yards]
-646.478 -4928.2 30.3386 1 [Random: 10 yards]
-121.162 -4709.15 28.195 1 [Random: 5 yards]
65.0834 -5017.19 10.4039 1 [Random: 5 yards]
19.2551 -4813.54 23.2508 1 [Random: 5 yards]
-706.37 -5014.12 17.3949 1 [Random: 10 yards]
286.425 -4947.95 22.0564 1 [Random: 5 yards]
250.882 -4982.37 19.254 1 [Random: 10 yards]
-747.245 -4649.64 41.1089 1 [Random: 5 yards]
-781.648 -4611.14 45.3457 1 [Random: 10 yards]
-138.576 -4819.18 23.9827 1 [Random: 5 yards]
-79.0009 -4787.46 24.0587 1 [Random: 5 yards]
80.1492 -4814.94 18.7142 1 [Random: 5 yards]
-677.986 -4930.12 25.1055 1 [Random: 10 yards]
-554.579 -4777.85 36.107 1 [Random: 10 yards]
132.915 -4918.65 12.9131 1 [Random: 5 yards]
-17.9669 -4769.81 25.2121 1 [Random: 5 yards]
249.331 -4915.08 20.4446 1 [Random: 10 yards]
41.419 -4856.5 18.8172 1 [Random: 5 yards]
-815.818 -4781.79 23.1941 1 [Random: 5 yards]
-451.499 -4820.5 38.2678 1 [Random: 10 yards]
-1021.26 -4858.54 10.0914 1 [Random: 10 yards]
208.736 -4882.42 14.6597 1 [Random: 10 yards]
-327.766 -4760.08 36.7095 1 [Random: 5 yards]
-886.264 -4782.01 20.216 1 [Random: 5 yards]

Loot (28)

5466 Scorpid Stinger 71.72% 4867 Broken Scorpid Leg 24.43% 4872 Dry Scorpid Eye 16.77% 774 Malachite 0.76% 2770 Copper Ore 0.66% 2447 Peacebloom 0.42% 2835 Rough Stone 0.3% 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% 818 Tigerseye 0.24% 765 Silverleaf 0.2% 2598 Pattern: Red Linen Robe 0.12% 3609 Plans: Copper Chain Vest 0.12% 2449 Snakeroot 0.08% 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% 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% 1210 Shadowgem 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%

Skinning loot (2)

2934 Ruined Leather Scraps 61.56% 2318 Light Leather 38.44%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 3125);
Field Value
entry 3125
display_id1 2486
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Clattering Scorpid
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 5
level_max 6
faction 60: Dragonflight - Red
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.13
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 20
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 1: Beast
type_flags 1
loot_id 3125
pickpocket_loot_id 0
skinning_loot_id 3125
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
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