General
| Field | Value |
|---|---|
| entry | 3086 |
| display_id1 | 3378 |
| level_min | 20 |
| faction | 11: Human, Stormwind |
| npc_flags | 0x1: Vendor |
| health_multiplier | 1 |
| mana_multiplier | 1 |
Spawn points — Eastern Kingdoms (1)
-9215.79 -2066.68 82.855 0 [Idle]
NPC sells (14)
4593
Bristle Whisker Catfish
4541
Freshly Baked Bread
1179
Ice Cold Milk
4592
Longjaw Mud Snapper
1205
Melon Juice
4542
Moist Cornbread
1645
Moonberry Juice
4544
Mulgore Spice Bread
159
Refreshing Spring Water
4594
Rockscale Cod
787
Slitherskin Mackerel
4601
Soft Banana Bread
1708
Sweet Nectar
4540
Tough Hunk of Bread
Database entry for NPC
UPDATE `creature_template` SET `field`
= xxxx WHERE (`entry` = 3086);
| Field | Value |
|---|---|
| entry | 3086 |
| display_id1 | 3378 |
| display_id2 | 0 |
| display_id3 | 0 |
| display_id4 | 0 |
| mount_display_id | 0 |
| name | Gretchen Vogel |
| subname | Waitress |
| static_flags | 0x66: No XP, No loot, Immune player, Immune NPC |
| gossip_menu_id | 0 |
| level_min | 20 |
| level_max | 20 |
| faction | 11: Human, Stormwind |
| npc_flags | 0x1: Vendor |
| 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 | 0.85 |
| health_multiplier | 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 | 0 |
| trainer_type | 0 |
| trainer_spell | 0 |
| trainer_class | 0 |
| trainer_race | 0 |
| type | 7: Humanoid |
| type_flags | 102 |
| loot_id | 0 |
| 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 | 0 |
| pet_spell_list_id | 0 |
| auras | |
| gold_min | 0 |
| gold_max | 0 |
| ai_name | |
| movement_type | 0: Idle |
| inhabit_type | Ground, Water |
| 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 | 0x8000a: No aggro, Summon guard, PvP |
| script_name |