Database

Alpha 0.5.3

Stormwind City Guard

Creature

General

Creature model for display ID 3167
Field Value
entry 68
display_id1 3167
level_min 90
faction 11: Human, Stormwind
npc_flags None
health_multiplier 2
mana_multiplier 1

Spawn points — Eastern Kingdoms (26)

-8528.64 689.028 97.6514 0 [Idle]
-8643.52 808.983 96.6525 0 [Idle]
-8857 937.947 102.143 0 [Idle]
-8838.84 792.17 96.0788 0 [Idle]
-8803 862.081 98.887 0 [Idle]
-8800.07 864.517 98.888 0 [Idle]
-8854.14 541.299 105.984 0 [Idle]
-8833 542.104 96.942 0 [Waypoints]
-8888.17 566.203 92.6715 0 [Idle]
-8938.22 518.206 96.3645 0 [Idle]
-8895.63 575.369 92.8007 0 [Idle]
-8950.27 537.283 96.3667 0 [Idle]
-8887.27 635.868 99.6059 0 [Idle]
-8889.65 640.301 99.6059 0 [Idle]
-8675.93 638.677 97.0547 0 [Idle]
-8684.41 575.301 96.9743 0 [Idle]
-8679.41 635.96 97.0551 0 [Idle]
-8687.19 578.601 96.9748 0 [Idle]
-8833.54 785.599 95.8423 0 [Idle]
-8836.68 722.916 97.7159 0 [Idle]
-8969.75 517.726 96.6413 0 [Waypoints]
-9008.35 469.265 96.6211 0 [Waypoints]
-9078.46 440.514 93.2955 0 [Idle]
-9062.18 420.085 93.2955 0 [Idle]
-9095.62 422.026 92.0445 0 [Idle]
-9085.59 408.559 92.1695 0 [Idle]

Spells they cast (3)

6660 Shoot 2565 Shield Block 6574 Revenge

Loot (6)

3974 Smooth Leather Pants 0.46% 3990 Crested Buckler 0.24% 3987 Deflecting Tower 0.24% 3994 Laminated Scale Bracers 0.24% 3975 Smooth Leather Shoulderpads 0.24% 3945 Twill Boots 0.24%

NPC equips (3)

2551 Monster - Crossbow 143 Monster - Shield, Stormwind Guard 1899 Monster - Sword, Long Basic

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 68);
Field Value
entry 68
display_id1 3167
display_id2 3257
display_id3 0
display_id4 0
mount_display_id 0
name Stormwind City Guard
subname
static_flags None
gossip_menu_id 435
level_min 90
level_max 90
faction 11: Human, Stormwind
npc_flags None
speed_walk 1
speed_run 1.42857
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 2
health_multiplier 2
mana_multiplier 1
armor_multiplier 1
base_attack_time 1.6 sec
ranged_attack_time 2 sec
unit_class 1
unit_flags 0
dynamic_flags 0
beast_family 0
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 7: Humanoid
type_flags 0
loot_id 68
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 680
pet_spell_list_id 0
auras
gold_min 1c
gold_max 6s 90c
ai_name EventAI
movement_type 0: Idle
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 68
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra 0x80400: Guard, PvP
script_name