Northshire Valley
Sulfuras · area entry 9 · 14 quests set here · 5 fishing sources · weather of the zone it sits in
- Entry
- 9
- Name, as the realm stores it
- Northshire Valley
- Where it sits
- in Elwynn Forest
- Map id, as stored
- 0
- Areas filed under this one
- 0
- `area_level`, as stored
- 0
- `explore_flag`, as stored
- 125
- `flags`, as stored
- 64
Every one of these columns holds 0 in this row: team, liquid_type. This realm's source has no named constant for any of them, so they are named by column and left at that.
`area_template` carries no patch column on this realm: 1,081 rows for 1,081 entries, so this page answers from the one row that exists and is not choosing between copies. Where a related table is patch-versioned -- the quest table, `map_template`, the graveyard rows -- this site takes the newest row it can see, and the map row above came from the newest `patch` row in this realm's own `map_template` (patch 0). Neither number says which patch this realm runs: the daemon's own load queries add a bound against a number only the running server holds.
Where this area sits
This realm files the row under Elwynn Forest (area 12), its own `zone_id` column; the name comes from the same table, not from a list this site carries.
The realm's own `map_template` names map 0 “Eastern Kingdoms”.
Quests set in this area
| Quest |
|---|
| Bounty on Garrick Padfoot entry 6 |
| Kobold Camp Cleanup entry 7 |
| Investigate Echo Ridge entry 15 |
| Brotherhood of Thieves entry 18 |
| Skirmish at Echo Ridge entry 21 |
| Wolves Across the Border entry 33 |
| Report to Goldshire entry 54 |
| A Threat Within entry 783 |
| Milly Osworth entry 3903 |
| Milly's Harvest entry 3904 |
| Grape Manifest entry 3905 |
| Eagan Peltskinner entry 5261 |
| Waskily Wabbits! entry 7961 |
| Wabbit Pelts entry 7962 |
This realm's quest table files 14 quests under this area id in `ZoneOrSort`, counted one per quest entry at its newest patch row. Every one of them is listed.
The weather this daemon rolls here
This area has no weather row of its own. The daemon rolls weather per zone id -- it looks the zone up as an area entry and then asks for that zone's weather (`Player.cpp:6590-6602`) -- and every one of this realm's 33 weather rows is keyed to a zone, none to a sub-area. The row below is the one filed under Elwynn Forest (area 12).
| Season | Rain | Snow | Storm |
|---|---|---|---|
| spring | 20 | 0 | 0 |
| summer | 15 | 0 | 0 |
| fall | 20 | 0 | 0 |
| winter | 20 | 0 | 0 |
These are the stored chances, one row per season, in the daemon's own column names. They are not measurements: the daemon reads exactly these columns (`Weather.cpp:451`) and compares rain, then rain+snow, then rain+snow+storm against a single draw of 1 to 100 (`Weather.cpp:172-181`), so a 25 is one chance in a hundred of that daemon's own random draw.
Resurrections
1 row of `game_graveyard_zone` names this area as its ghost zone, stored as faction 469, which this realm's source gives no player-facing name for. The daemon keeps only the rows whose `patch_min`/`patch_max` window contains the patch it is running (`ObjectMgr.cpp:7457`) and skips a row naming a zone its area table does not know (`:7493`); both numbers are ones this site cannot read from a database connection, so the count above is of the realm's rows, not of what a player would actually be sent to.
Spells the realm restricts to this area
This realm's `spell_area` table has no row for this area.
Fishing and bound items
5 rows of `fishing_loot_template` are filed under this area id -- the key's meaning in the daemon's own words, from its registration line `LootStore LootTemplates_Fishing("fishing_loot_template", "area id", true)` (`LootMgr.cpp:46`). What each row drops is the item page's job, and this site does not link an item it has not read.
No item in this realm's item table names this area in `area_bound`; an item that is bound nowhere stores 0 there. The realm binds 31 items to some area, and none of them is this one.
Where this realm starts a character
No row of this realm's `playercreateinfo` starts a character in this area. The realm has 40 such rows for other zones, so this is the realm's own choice of starting places.
Browse areas Search quests Search creatures Search game objects Search items