DB/AreaTable

Contains general information about the areas (different from Zones, but included) in the game.

Header Info

Records..................2283
Fields.....................36
Record Size...............144
String Block Size.......34363

Structure

Column 	Field 				Type 		 	Notes
1 	ID 				Integer 		id of record
2 	iRefID_Map 			Integer 		reference to map.dbc record.
3 	iRefID_AreaTable 		Integer 		Recursive. If this is a sub-area, it will link to its parent area.
4 	exploreFlag 			Integer 	
5 	Flags 				BitMask 		See below.
6 	iRefID_SoundPreferences		Integer 		
7 	Unknown 			Integer 		This seems to point to a SoundProviderPreferences.dbc too. But it would be duplicate and all would be UNDERWATER. oO Seems to be only read if preceeding is null.
8 	iRefID_SoundAmbience 		Integer 		ambient sound
9 	iRefID_ZoneMusic 		Integer 		ambient music	
10 	iRefID_ZoneIntroMusicTable 	Integer 		music upon entering the zone
11 	areaLevel 			Signed Integer 		level this zone is made for.
12-28 	sRefName 			String + Loc 		
29 	iRefMask_FactionGroup 		BitMask 		
30 	Unknown 			Integer 		
31 	Unknown 			Null			NULL
32 	Unknown 			Null 			NULL
33 	Unknown 			Integer 		Only value: Naxxramas with an 21.
34 	Unknown 			Float 			-5000, -500, 1000
35 	Unknown 			Float 			0 - 1; Something to do with character ambient lightning.
36 	Unknown 			Null 			NULL

-Raindog 10-Dec-2007: updated for increased number of localization fields.

enum AREATABLE_FLAGS

   AREA_FLAG_SNOW                  = 0x00000001,           // snow (only Dun Morogh, Naxxramas, Razorfen Downs and Winterspring)
   AREA_FLAG_UNK1                  = 0x00000002,           // may be necropolis?
   AREA_FLAG_UNK2                  = 0x00000004,           // Only used for areas on map 571 (development before)
   AREA_FLAG_SLAVE_CAPITAL         = 0x00000008,           // city and city subsones
   AREA_FLAG_UNK3                  = 0x00000010,           // can't find common meaning
   AREA_FLAG_SLAVE_CAPITAL2        = 0x00000020,           // slave capital city flag?
   AREA_FLAG_UNK4                  = 0x00000040,           // many zones have this flag
   AREA_FLAG_ARENA                 = 0x00000080,           // arena, both instanced and world arenas
   AREA_FLAG_CAPITAL               = 0x00000100,           // main capital city flag
   AREA_FLAG_CITY                  = 0x00000200,           // only for one zone named "City" (where it located?)
   AREA_FLAG_OUTLAND               = 0x00000400,           // expansion zones? (only Eye of the Storm not have this flag, but have 0x00004000 flag)
   AREA_FLAG_SANCTUARY             = 0x00000800,           // sanctuary area (PvP disabled)
   AREA_FLAG_NEED_FLY              = 0x00001000,           // only Netherwing Ledge, Socrethar's Seat, Tempest Keep, The Arcatraz, The Botanica, The Mechanar, Sorrow Wing Point, Dragonspine Ridge, Netherwing Mines, Dragonmaw Base Camp, Dragonmaw Skyway
   AREA_FLAG_UNUSED1               = 0x00002000,           // not used now (no area/zones with this flag set in 3.0.3)
   AREA_FLAG_OUTLAND2              = 0x00004000,           // expansion zones? (only Circle of Blood Arena not have this flag, but have 0x00000400 flag)
   AREA_FLAG_PVP                   = 0x00008000,           // pvp objective area? (Death's Door also has this flag although it's no pvp object area)
   AREA_FLAG_ARENA_INSTANCE        = 0x00010000,           // used by instanced arenas only
   AREA_FLAG_UNUSED2               = 0x00020000,           // not used now (no area/zones with this flag set in 3.0.3)
   AREA_FLAG_UNK5                  = 0x00040000,           // only used for Amani Pass, Hatchet Hills
   AREA_FLAG_UNK6                  = 0x00080000,           // Valgarde and Acherus: The Ebon Hold
   AREA_FLAG_LOWLEVEL              = 0x00100000,           // used for some starting areas with area_level <=15
   AREA_FLAG_TOWN                  = 0x00200000,           // small towns with Inn
   AREA_FLAG_UNK7                  = 0x00400000,           // Warsong Hold, Acherus: The Ebon Hold, New Agamand Inn, Vengeance Landing Inn
   AREA_FLAG_UNK8                  = 0x00800000,           // Westguard Inn, Acherus: The Ebon Hold, Valgarde
   AREA_FLAG_OUTDOOR_PVP           = 0x01000000,           // Wintergrasp and it's subzones
   AREA_FLAG_UNK9                  = 0x02000000,           // unknown
   AREA_FLAG_UNK10                 = 0x04000000,           // unknown
   AREA_FLAG_CAN_HEARTH_AND_RES    = 0x08000000            // Wintergrasp and it's subzones
   // 0x20000000 not flyable?

from MaNGOS source. + --Khira 18:52, 12 April 2010 (GMT+1)