Database

Alpha 0.5.3

Scorpid Tail Lasher

Creature

General

Creature model for display ID 3247
Field Value
entry 5423
display_id1 3247
level_min 43
faction 60: Dragonflight - Red
npc_flags None
health_multiplier 1.2
mana_multiplier 1

Spawn points — Kalimdor (85)

-7936.11 -4297.19 10.2756 1 [Random: 25 yards]
-8116.22 -4193.72 10.2781 1 [Random: 25 yards]
-6980.81 -3286.42 9.38604 1 [Random: 25 yards]
-7390.82 -2822.11 12.199 1 [Random: 25 yards]
-7292.88 -3289.68 10.6841 1 [Random: 25 yards]
-7386.8 -3180.47 9.9087 1 [Random: 25 yards]
-7725.01 -3479.49 33.0362 1 [Random: 25 yards]
-7386.31 -3420.73 15.8742 1 [Random: 25 yards]
-7853.14 -3804.69 41.8746 1 [Random: 25 yards]
-7976.05 -4014.97 10.231 1 [Random: 25 yards]
-7841.39 -3756.24 50.5255 1 [Random: 25 yards]
-6881.34 -2710.84 22.2261 1 [Random: 25 yards]
-7442.66 -3686.23 10.6602 1 [Random: 25 yards]
-7715.32 -3537.01 36.1593 1 [Random: 25 yards]
-7641.94 -3755.18 21.5109 1 [Random: 25 yards]
-7685.1 -3681.94 31.2961 1 [Random: 25 yards]
-7719.86 -3415.48 40.909 1 [Random: 25 yards]
-7602.86 -3281.38 48.8921 1 [Random: 25 yards]
-8327.98 -3897.75 9.44948 1 [Random: 25 yards]
-7785.82 -4153.24 14.2622 1 [Random: 25 yards]
-7312.86 -2743.86 9.70745 1 [Random: 25 yards]
-7128.29 -2618.83 9.00248 1 [Random: 10 yards]
-7852.16 -3007.69 41.897 1 [Random: 25 yards]
-7787.96 -3477.04 45.5783 1 [Random: 25 yards]
-8229.95 -3887.97 9.93412 1 [Random: 25 yards]
-7925.92 -4360.7 11.56 1 [Random: 25 yards]
-7412.54 -2951.99 11.0024 1 [Random: 25 yards]
-6976.5 -2621.54 9.08253 1 [Random: 3 yards]
-7188.15 -2761.84 16.3768 1 [Random: 25 yards]
-7414.61 -3481.76 12.2657 1 [Random: 25 yards]
-7825.8 -3282.71 64.8954 1 [Random: 25 yards]
-7767.01 -4555.26 9.154 1 [Random: 25 yards]
-8325.22 -3809.93 10.5217 1 [Random: 25 yards]
-8182.48 -4021.8 11.8722 1 [Random: 25 yards]
-7034.76 -3487.32 9.52945 1 [Random: 25 yards]
-6850.51 -2612.12 10.0486 1 [Random: 25 yards]
-7604.91 -3749.6 14.3761 1 [Random: 25 yards]
-7852.94 -4648.37 9.32224 1 [Random: 25 yards]
-8178.83 -4074.16 9.48266 1 [Random: 25 yards]
-8167.1 -3889 9.00177 1 [Random: 25 yards]
-8103.33 -4036.67 11.8408 1 [Random: 25 yards]
-6977.7 -2955.35 9.97284 1 [Random: 25 yards]
-6931.15 -3413.37 21.3212 1 [Random: 25 yards]
-7244.03 -3371.19 10.2585 1 [Random: 25 yards]
-7501.83 -3215.54 21.0324 1 [Random: 25 yards]
-7533.42 -3348.7 30.152 1 [Random: 25 yards]
-7733.2 -3150.28 68.8759 1 [Random: 25 yards]
-7593.19 -3552.06 16.1066 1 [Random: 25 yards]
-7387.94 -3544.47 7.79651 1 [Random: 25 yards]
-7774.82 -4082.21 9.65412 1 [Random: 25 yards]
-7786.98 -3737.85 38.8395 1 [Random: 25 yards]
-7795.45 -3414.67 46.9164 1 [Random: 25 yards]
-7576.33 -3658.57 12.533 1 [Random: 25 yards]
-7654.17 -3428.39 37.2282 1 [Random: 25 yards]
-7646.14 -3020.92 17.126 1 [Random: 25 yards]
-7849.01 -4484.66 10.7769 1 [Random: 25 yards]
-7915.38 -4619.03 9.00176 1 [Random: 25 yards]
-7855.42 -3212.71 74.4522 1 [Random: 25 yards]
-7734.77 -4101.96 12.9187 1 [Random: 25 yards]
-7850.22 -3479.7 66.061 1 [Random: 25 yards]
-7783.31 -3550.74 50.5624 1 [Random: 25 yards]
-7903.94 -4211.53 13.0872 1 [Random: 25 yards]
-8067.28 -3822.07 15.8541 1 [Random: 25 yards]
-7784.73 -4486.21 8.932 1 [Random: 25 yards]
-7983.46 -4484.83 10.5406 1 [Random: 25 yards]
-7841.54 -4162.16 11.0443 1 [Random: 25 yards]
-7851.79 -4219.1 9.43035 1 [Random: 25 yards]
-7817.53 -3683.68 48.3538 1 [Random: 25 yards]
-8372.07 -3954.6 11.7762 1 [Random: 25 yards]
-7913.06 -4479.69 9.6691 1 [Random: 25 yards]
-7585.87 -3815.25 9.27372 1 [Random: 25 yards]
-7754.05 -3887.37 18.984 1 [Random: 25 yards]
-7717.86 -3892.73 15.2447 1 [Random: 25 yards]
-7781.88 -3950.46 9.97005 1 [Random: 25 yards]
-7841.65 -3971.16 10.08 1 [Random: 25 yards]
-7915.36 -4015.85 9.06812 1 [Random: 25 yards]
-7848.67 -4017.45 11.0553 1 [Random: 25 yards]
-7052.75 -3425.61 9.80869 1 [Random: 25 yards]
-8052.13 -4218.5 9.00174 1 [Random: 25 yards]
-8046.15 -4419.08 10.9307 1 [Random: 25 yards]
-8113.02 -4349.56 9.21963 1 [Random: 25 yards]
-8252.46 -4348.79 9.51991 1 [Random: 25 yards]
-8317.64 -4235.68 10.8793 1 [Random: 25 yards]
-7548.94 -3683.21 9.19625 1 [Random: 25 yards]
-8320.01 -4083.51 10.9431 1 [Random: 25 yards]

Spells they cast (1)

6607 Tail Lash

Loot (23)

4872 Dry Scorpid Eye 25.96% 4637 Steel Lockbox 0.15% 3914 Journeyman's Backpack 0.06% 3864 Citrine 0.02% 4625 Firebloom 0.02% 2838 Heavy Stone 0.02% 2772 Iron Ore 0.02% 1529 Jade 0.02% 3858 Mithril Ore 0.02% 5974 Pattern: Guardian Cloak 0.02% 4300 Pattern: Guardian Leather Bracers 0.02% 4353 Pattern: Spider Belt 0.02% 3868 Plans: Frost Tiger Blade 0.02% 3873 Plans: Golden Scale Cuirass 0.02% 3874 Plans: Polished Steel Boots 0.02% 3869 Plans: Shadow Crescent Axe 0.02% 3832 Recipe: Elixir of Detect Lesser Invisibility 0.02% 3831 Recipe: Mighty Troll's Blood Potion 0.02% 4416 Schematic: Goblin Land Mine 0.02% 4425 Scroll of Agility III 0.02% 4421 Scroll of Protection III 0.02% 1685 Troll-hide Bag 0.02% 4867 Broken Scorpid Leg 0.01%

Reference loot (76)

6426 Blackforge Bracers 0.5% 4082 Blackforge Breastplate 0.5% 4069 Blackforge Buckler 0.5% 6424 Blackforge Cape 0.5% 4080 Blackforge Cowl 0.5% 4083 Blackforge Gauntlets 0.5% 6425 Blackforge Girdle 0.5% 6423 Blackforge Greaves 0.5% 4084 Blackforge Leggings 0.5% 4733 Blackforge Pauldrons 0.5% 4044 Brightweave Pants 0.5% 6415 Brightweave Robe 0.5% 6411 Chief Brigadier Armor 0.5% 4079 Chief Brigadier Leggings 0.5% 4725 Chief Brigadier Pauldrons 0.5% 4068 Chief Brigadier Shield 0.5% 3208 Conk Hammer 0.5% 4088 Dreadblade 0.5% 1994 Ebonclaw Reaver 0.5% 5215 Ember Wand 0.5% 4058 Glyphed Breastplate 0.5% 4060 Glyphed Leggings 0.5% 1639 Grinning Axe 0.5% 6432 Imperial Cloak 0.5% 4738 Imperial Leather Belt 0.5% 6431 Imperial Leather Boots 0.5% 4061 Imperial Leather Bracers 0.5% 6430 Imperial Leather Breastplate 0.5% 4063 Imperial Leather Gloves 0.5% 6433 Imperial Leather Helm 0.5% 4062 Imperial Leather Pants 0.5% 4737 Imperial Leather Spaulders 0.5% 4070 Jouster's Crest 0.5% 4047 Mistscape Boots 0.5% 4045 Mistscape Bracers 0.5% 4735 Mistscape Cloak 0.5% 6428 Mistscape Gloves 0.5% 4734 Mistscape Mantle 0.5% 4046 Mistscape Pants 0.5% 6427 Mistscape Robe 0.5% 4736 Mistscape Sash 0.5% 6429 Mistscape Wizard Hat 0.5% 866 Monk's Staff 0.5% 1640 Monstrous War Axe 0.5% 4089 Ricochet Blunderbuss 0.5% 3187 Sacrificial Kris 0.5% 1625 Shin Blade 0.5% 1608 Skullcrusher Mace 0.5% 3430 Sniper Rifle 0.5% 1613 Spiritchaser Staff 0.5% 4087 Trueshot Bow 0.5% 5216 Umbral Wand 0.5% 5011 Welken Ring 0.5% 1718 Basilisk Hide Pants 0.01% 2802 Blazing Emblem 0.01% 2815 Curve-bladed Ripper 0.01% 4090 Goblin Nutcracker 0.01% 1714 Necklace of Calisea 0.01% 1715 Polished Jazeraint Armor 0.01% 1713 Ring of Healing 0.01% 1716 Robe of the Magi 0.01% 754 Shortsword of Vengeance 0.01% 1720 Tanglewood Staff 0.01% 1722 Thornstone Sledgehammer 0.01% 4091 Widowmaker 0.01% 868 Ardent Custodian 0% 2825 Bow of Searing Arrows 0% 869 Dazzling Longsword 0% 870 Fiery War Axe 0% 867 Gloves of Holy Might 0% 2164 Gut Ripper 0% 1981 Icemail Jerkin 0% 1982 Nightblade 0% 873 Staff of Jordan 0% 1204 The Green Tower 0% 1980 Underworld Band 0%

Skinning loot (3)

4304 Thick Leather 32.3% 4234 Heavy Leather 20.54% 4235 Heavy Hide 3.04%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 5423);
Field Value
entry 5423
display_id1 3247
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Scorpid Tail Lasher
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 43
level_max 44
faction 60: Dragonflight - Red
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.2
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 20
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 1: Beast
type_flags 1
loot_id 5423
pickpocket_loot_id 0
skinning_loot_id 5423
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 6607: Tail Lash
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 54230
pet_spell_list_id 8857
auras
gold_min 0
gold_max 0
ai_name
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