Database

Alpha 0.5.3

Scorpashi Snapper

Creature

General

Creature model for display ID 2729
Field Value
entry 4696
display_id1 2729
level_min 30
faction 60: Dragonflight - Red
npc_flags None
health_multiplier 1.1
mana_multiplier 1

Spawn points — Kalimdor (69)

-187.046 1069.25 89.0476 1 [Random: 5 yards]
-352.297 1280.59 90.3587 1 [Random: 20 yards]
-316.937 1251.15 91.0924 1 [Random: 5 yards]
-423.442 1049.23 91.5231 1 [Random: 20 yards]
-630.436 647.271 143.71 1 [Random: 20 yards]
-523.118 959.122 91.1127 1 [Random: 20 yards]
-208.544 1791.22 144.987 1 [Random: 2 yards]
-552.124 849.011 91.0193 1 [Random: 20 yards]
-348.248 1063.16 92.3109 1 [Random: 5 yards]
-215.064 1251.49 92.9798 1 [Random: 20 yards]
-384.228 1290.46 90.6672 1 [Random: 5 yards]
-346.06 976.9 90.8713 1 [Random: 20 yards]
-294.469 1349.54 89.337 1 [Random: 5 yards]
-110.376 1794.62 145.638 1 [Random: 5 yards]
-121.218 1214.18 94.7778 1 [Random: 20 yards]
104.334 1655.41 117.289 1 [Random: 5 yards]
-487.637 910.659 90.2516 1 [Random: 20 yards]
-316.426 1183.51 92.0399 1 [Random: 5 yards]
-481.783 1400.63 90.605 1 [Random: 5 yards]
-543.243 929.734 92.4357 1 [Random: 5 yards]
-543.902 1035.91 91.4965 1 [Random: 20 yards]
-444.045 1001.96 90.227 1 [Random: 20 yards]
-542.646 1016.62 90.1727 1 [Random: 20 yards]
-389.231 1003.58 91.6529 1 [Random: 20 yards]
-533.896 712.564 135.938 1 [Random: 3 yards]
-265.246 1048.77 90.7887 1 [Random: 5 yards]
-551.761 1147.73 95.2218 1 [Random: 5 yards]
-578.388 1035.39 90.7608 1 [Random: 20 yards]
6.56492 1726.87 107.153 1 [Random: 30 yards]
-551.732 1542.34 90.5948 1 [Random: 20 yards]
-150.257 1353.07 89.7639 1 [Random: 20 yards]
-675.305 1373.97 91.5072 1 [Random: 5 yards]
-423.06 1289.27 89.6362 1 [Random: 5 yards]
-596.54 1378.33 91.603 1 [Random: 20 yards]
-620.075 780.594 91.9797 1 [Random: 5 yards]
208.215 1881.31 128.28 1 [Random: 5 yards]
-452.982 889.185 91.0182 1 [Random: 20 yards]
-350.272 1480.95 91.4946 1 [Random: 5 yards]
-613.85 717.245 130.95 1 [Random: 5 yards]
114.611 1885.86 133.049 1 [Random: 3 yards]
36.7724 1786.93 113.27 1 [Random: 15 yards]
-447.565 966.948 95.663 1 [Random: 20 yards]
-502.075 1138.65 91.986 1 [Random: 5 yards]
-647.275 616.612 143.781 1 [Random: 5 yards]
-616.752 1288.71 90.1089 1 [Random: 20 yards]
102.104 1606.33 134.893 1 [Random: 5 yards]
-590.771 1148.66 90.4028 1 [Random: 5 yards]
267.729 1974.04 143.045 1 [Random: 5 yards]
-587.735 815.979 90.5805 1 [Random: 5 yards]
-322.098 1226.43 91.0808 1 [Random: 5 yards]
-218.257 1337.6 88.9389 1 [Random: 20 yards]
10.6142 1422.84 93.1507 1 [Random: 20 yards]
-542.617 1388.44 91.1213 1 [Random: 20 yards]
-1473.77 1560.34 61.3273 1 [Random: 20 yards]
-439.121 1489.11 89.6557 1 [Random: 5 yards]
246.6 1777.91 102.271 1 [Random: 5 yards]
-317.975 1089.13 92.9511 1 [Random: 5 yards]
219.275 1948.89 147.2 1 [Random: 5 yards]
-213.646 1143.55 91.6026 1 [Random: 5 yards]
-645.202 1035.15 93.1813 1 [Random: 5 yards]
184.291 1609.49 150.767 1 [Random: 20 yards]
-129.39 1641.16 90.5788 1 [Random: 5 yards]
-1460.68 1353.68 61.1049 1 [Random: 20 yards]
-1485.94 1715.63 61.0968 1 [Random: 20 yards]
-1612.89 1843.98 61.4739 1 [Random: 20 yards]
-83.0985 1380.14 89.5884 1 [Random: 20 yards]
-53.9914 1417.31 89.4036 1 [Random: 20 yards]
-85.9225 1114.08 92.1892 1 [Random: 20 yards]
-354.37 1586.21 95.2642 1 [Random: 5 yards]

Spells they cast (1)

5416 Venom Sting

Quest item loot (1)

6248 Scorpashi Venom 80%

Loot (62)

4867 Broken Scorpid Leg 20.93% 1288 Large Venom Sac 14.02% 4872 Dry Scorpid Eye 13.92% 4633 Heavy Bronze Lockbox 0.11% 1529 Jade 0.09% 1705 Lesser Moonstone 0.09% 4634 Iron Lockbox 0.06% 3864 Citrine 0.05% 2770 Copper Ore 0.04% 1206 Moss Agate 0.04% 804 Large Blue Sack 0.04% 2836 Coarse Stone 0.02% 3356 Crownroyal 0.02% 6375 Formula: Enchant Bracer - Lesser Spirit 0.02% 2776 Gold Ore 0.02% 2838 Heavy Stone 0.02% 2772 Iron Ore 0.02% 5575 Large Green Sack 0.02% 857 Large Red Sack 0.02% 774 Malachite 0.02% 4297 Pattern: Barbaric Gloves 0.02% 4352 Pattern: Boots of the Enchanter 0.02% 4296 Pattern: Dark Leather Shoulders 0.02% 5774 Pattern: Green Silk Pack 0.02% 4299 Pattern: Guardian Armor 0.02% 4298 Pattern: Guardian Belt 0.02% 4300 Pattern: Guardian Leather Bracers 0.02% 4347 Pattern: Reinforced Woolen Shoulders 0.02% 4351 Pattern: Shadow Hood 0.02% 4350 Pattern: Spider Silk Slippers 0.02% 6390 Pattern: Stylish Blue Shirt 0.02% 3867 Plans: Golden Iron Destroyer 0.02% 3873 Plans: Golden Scale Cuirass 0.02% 3872 Plans: Golden Scale Leggings 0.02% 3871 Plans: Golden Scale Shoulders 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% 3874 Plans: Polished Steel Boots 0.02% 4414 Plans: Portable Bronze Mortar 0.02% 3869 Plans: Shadow Crescent Axe 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% 3394 Recipe: Elixir of Poison Resistance 0.02% 2835 Rough Stone 0.02% 4416 Schematic: Goblin Land Mine 0.02% 4417 Schematic: Large Seaforium Charge 0.02% 4412 Schematic: Moonsight Rifle 0.02% 1210 Shadowgem 0.02% 2775 Silver Ore 0.02% 5504 Tangy Clam Meat 0.02% 818 Tigerseye 0.02% 2771 Tin Ore 0.02% 3355 Wild Steelbloom 0.02% 1725 Large Knapsack 0.01% 5576 Large Brown Sack 0.01%

Reference loot (77)

3041 "Mage-Eye" Blunderbuss 0.5% 3185 Acrobatic Staff 0.5% 3042 BKP "Sparrow" Smallbore 0.5% 5007 Band of Thorns 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% 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% 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% 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)

4234 Heavy Leather 49.99% 2319 Medium Leather 42.78% 4232 Medium Hide 4.1% 4235 Heavy Hide 3.13%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 4696);
Field Value
entry 4696
display_id1 2729
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Scorpashi Snapper
subname
static_flags 0x10: Tameable
gossip_menu_id 0
level_min 30
level_max 31
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.1
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 4696
pickpocket_loot_id 0
skinning_loot_id 4696
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 5416: Venom Sting
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 46960
pet_spell_list_id 5866
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