Database

Alpha 0.5.3

Jademir Oracle

Creature

General

Creature model for display ID 623
Field Value
entry 5317
display_id1 623
level_min 61
faction 50: Dragonflight - Green
npc_flags None
health_multiplier 25
mana_multiplier 10

Spawn points — Kalimdor (60)

-2837.16 1663.72 34.3553 1 [Random: 15 yards]
-2847.97 2083.64 39.4078 1 [Random: 2 yards]
-2939.1 2078.28 30.0111 1 [Random: 2 yards]
-2727.16 1867.88 35.2998 1 [Random: 2 yards]
-3050.19 1713.52 36.5682 1 [Random: 15 yards]
-2783.29 1783.1 31.7774 1 [Random: 2 yards]
-2679.99 1958.7 29.6939 1 [Random: 2 yards]
-2924.57 1844.73 33.064 1 [Random: 2 yards]
-3130.09 1693.26 50.632 1 [Random: 15 yards]
-2834.08 1917.16 32.009 1 [Random: 15 yards]
-3117.38 1789.5 40.1409 1 [Random: 2 yards]
-3114.44 1949.67 35.2513 1 [Random: 2 yards]
-3121.64 1880.16 41.5756 1 [Idle]
-3201.39 1901.78 49.3696 1 [Idle]
-2716.82 1909.08 38.3583 1 [Random: 2 yards]
-2735.24 2077.16 35.1143 1 [Random: 2 yards]
-2716.81 1646.22 40.4159 1 [Random: 15 yards]
-2627.72 1784.56 28.8405 1 [Random: 15 yards]
-3096.3 2039.67 40.77 1 [Random: 15 yards]
-2844.29 1785.89 33.9902 1 [Random: 2 yards]
-2853.02 1693.06 30.499 1 [Random: 15 yards]
-2851.57 2088.13 42.1382 1 [Random: 2 yards]
-2717.6 1846.97 33.7834 1 [Random: 2 yards]
-3052.64 1720.99 34.8531 1 [Random: 15 yards]
-2782.99 1775.32 30.7901 1 [Random: 2 yards]
-2695.2 1936.33 29.3092 1 [Random: 2 yards]
-2921.87 1857.79 33.8178 1 [Random: 2 yards]
-3132.39 1690.71 49.421 1 [Idle]
-2857.9 1921.55 36.4524 1 [Random: 2 yards]
-3120.56 1778.15 41.9014 1 [Random: 2 yards]
-3126.14 1945.33 36.5192 1 [Random: 2 yards]
-3117.99 1884.63 36.9998 1 [Idle]
-3204.86 1900.21 49.2446 1 [Idle]
-2717.97 1919.55 35.7941 1 [Random: 2 yards]
-2725.22 2087.18 37.7317 1 [Random: 2 yards]
-2698.27 1663.48 41.5445 1 [Random: 15 yards]
-2628.98 1787.04 27.4655 1 [Random: 15 yards]
-3109.61 2031.78 39.1529 1 [Random: 2 yards]
-2851.21 1791.71 31.3023 1 [Random: 2 yards]
-3018.17 2087.76 28.7643 1 [Random: 15 yards]
-2851.83 1685.53 36.4012 1 [Random: 15 yards]
-2840.29 2068.61 38.7391 1 [Random: 2 yards]
-2939.23 2080.73 30.0898 1 [Random: 2 yards]
-2941.5 2078.56 30.2621 1 [Random: 2 yards]
-2713.67 1853.18 33.2834 1 [Random: 2 yards]
-3058.29 1717.95 36.5259 1 [Random: 15 yards]
-2784.49 1785.99 32.509 1 [Random: 2 yards]
-2684.5 1955.75 29.5732 1 [Random: 2 yards]
-2915.53 1854.39 34.4333 1 [Random: 2 yards]
-3123.47 1700.29 50.633 1 [Idle]
-2845.57 1929.27 34.009 1 [Random: 15 yards]
-3126.57 1782.01 43.2673 1 [Random: 2 yards]
-3102.69 1940.71 29.0269 1 [Random: 2 yards]
-3108.6 1878.8 40.0893 1 [Random: 2 yards]
-3203.08 1896.9 49.2757 1 [Idle]
-2718.63 1927.12 33.3663 1 [Random: 2 yards]
-2712.01 2071.96 36.7464 1 [Random: 2 yards]
-2621.93 1792.67 28.3405 1 [Random: 15 yards]
-3097.92 2024.38 38.1591 1 [Random: 2 yards]
-2847.77 1777.42 33.3509 1 [Random: 2 yards]

Loot (1)

5760 Eternium Lockbox 1.26%

Reference loot (68)

4025 Balanced Long Bow 5% 3989 Blocking Targe 5% 4021 Blunting Mace 5% 3990 Crested Buckler 5% 3936 Crochet Belt 5% 3937 Crochet Boots 5% 3938 Crochet Bracers 5% 3939 Crochet Cloak 5% 3940 Crochet Gloves 5% 3941 Crochet Pants 5% 3942 Crochet Shoulderpads 5% 3943 Crochet Vest 5% 4022 Crushing Maul 5% 3987 Deflecting Tower 5% 4023 Fine Pointed Dagger 5% 4019 Heavy Flint Axe 5% 4024 Heavy War Staff 5% 3999 Laminated Scale Armor 5% 3992 Laminated Scale Belt 5% 3993 Laminated Scale Boots 5% 3994 Laminated Scale Bracers 5% 3995 Laminated Scale Cloak 5% 3996 Laminated Scale Gloves 5% 3997 Laminated Scale Pants 5% 3998 Laminated Scale Shoulderpads 5% 4007 Overlinked Chain Armor 5% 4000 Overlinked Chain Belt 5% 4001 Overlinked Chain Boots 5% 4002 Overlinked Chain Bracers 5% 4003 Overlinked Chain Cloak 5% 4004 Overlinked Chain Gloves 5% 4005 Overlinked Chain Pants 5% 4006 Overlinked Chain Shoulderpads 5% 3986 Protective Pavise 5% 4026 Sentinel Musket 5% 4017 Sharp Shortsword 5% 3972 Smooth Cloak 5% 3976 Smooth Leather Armor 5% 3969 Smooth Leather Belt 5% 3970 Smooth Leather Boots 5% 3971 Smooth Leather Bracers 5% 3973 Smooth Leather Gloves 5% 3974 Smooth Leather Pants 5% 3975 Smooth Leather Shoulderpads 5% 4020 Splintering Battle Axe 5% 3964 Thick Cloak 5% 3961 Thick Leather Belt 5% 3962 Thick Leather Boots 5% 3963 Thick Leather Bracers 5% 3965 Thick Leather Gloves 5% 3966 Thick Leather Pants 5% 3967 Thick Leather Shoulderpads 5% 3968 Thick Leather Tunic 5% 3944 Twill Belt 5% 3945 Twill Boots 5% 3946 Twill Bracers 5% 3947 Twill Cloak 5% 3948 Twill Gloves 5% 3949 Twill Pants 5% 3950 Twill Shoulderpads 5% 3951 Twill Vest 5% 4018 Whetted Claymore 5% 4696 Lapidis Tankard of Tidesippe 0.03% 1973 Orb of Deception 0.03% 5267 Scarlet Kris 0.03% 1263 Brain Hacker 0.01% 1443 Jeweled Amulet of Cainwyn 0.01% 944 Magebane Staff 0.01%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 5317);
Field Value
entry 5317
display_id1 623
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Jademir Oracle
subname
static_flags 0x800000:
gossip_menu_id 0
level_min 61
level_max 61
faction 50: Dragonflight - Green
npc_flags None
speed_walk 0.888888
speed_run 1.14286
scale 0
detection_range 20
call_for_help_range 5
leash_range 0
rank 1: Elite
xp_multiplier 1
damage_school 0: Normal
damage_variance 0.14
damage_multiplier 5.45
health_multiplier 25
mana_multiplier 10
armor_multiplier 1.15
base_attack_time 1.166 sec
ranged_attack_time 2 sec
unit_class 2
unit_flags 0
dynamic_flags 0
beast_family 0
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 2: Dragon
type_flags 8
loot_id 5317
pickpocket_loot_id 0
skinning_loot_id 15412
holy_res 0
fire_res 5
nature_res 5
frost_res 5
shadow_res 5
arcane_res 5
spell_id1 -
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 0
auras
gold_min 27s 78c
gold_max 36s 33c
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