Skip to content

zone

Info

This page was last generated 2022.05.11

Schema

Column Data Type Description
short_name varchar Short Name
id int Unique Entry Identifier
file_name varchar File Name
long_name text Long Name
map_file_name varchar Map File Name
safe_x float Safe X Coordinate
safe_y float Safe Y Coordinate
safe_z float Safe Z Coordinate
safe_heading float
graveyard_id float Graveyard Identifier
min_level tinyint Minimum Level
min_status tinyint Minimum Status
zoneidnumber int Unique Zone Identifier
version tinyint Version
timezone int Timezone
maxclients int Maximum Clients
ruleset int Ruleset Identifier
note varchar Note
underworld float Bottom Z to represent when the player is under the world
minclip float Minimum Clipping Distance
maxclip float Maximum Clipping Distance
fog_minclip float Fog Minimum Clipping Distance
fog_maxclip float Fog Maximum Clipping Distance
fog_blue tinyint Fog Blue Level: 0 = None, 255 = Max
fog_red tinyint Fog Red Level: 0 = None, 255 = Max
fog_green tinyint Fog Green Level: 0 = None, 255 = Max
sky tinyint Sky type the client will present as the backdrop
ztype tinyint This field is sent directly to the client on zone-in, most zones are set to 0, 1 or 255.
zone_exp_multiplier decimal This will multiply the XP to this percentage value (decimal based, 100% = 1.0)
walkspeed float Walkspeed in this zone
time_type tinyint This value varies depending on the zone but it is sent to the client on zone in. Most starting zones/newbie areas have this value set to 2, dungeons tyically have this set to 0, some zones break from the norm and have values greater than 2, (akanon = 3, blackburrow = 5, cazicthule = 5, crushbone = 5, erudnint = 4, kaladima = 3, etc.)
fog_red1 tinyint Fog Red Level 1: 0 = None, 255 = Max
fog_green1 tinyint Fog Green Level 1: 0 = None, 255 = Max
fog_blue1 tinyint Fog Blue Level 1: 0 = None, 255 = Max
fog_minclip1 float Fog Minimum Clipping Distance 1
fog_maxclip1 float Fog Maximum Clipping Distance 1
fog_red2 tinyint Fog Red Level 2: 0 = None, 255 = Max
fog_green2 tinyint Fog Green Level 2: 0 = None, 255 = Max
fog_blue2 tinyint Fog Blue Level 2: 0 = None, 255 = Max
fog_minclip2 float Fog Minimum Clipping Distance 2
fog_maxclip2 float Fog Maximum Clipping Distance 2
fog_red3 tinyint Fog Red Level 3: 0 = None, 255 = Max
fog_green3 tinyint Fog Green Level 3: 0 = None, 255 = Max
fog_blue3 tinyint Fog Blue Level 3: 0 = None, 255 = Max
fog_minclip3 float Fog Minimum Clipping Distance 3
fog_maxclip3 float Fog Maximum Clipping Distance 4
fog_red4 tinyint Fog Red Level 4: 0 = None, 255 = Max
fog_green4 tinyint Fog Green Level 4: 0 = None, 255 = Max
fog_blue4 tinyint Fog Blue Level 4: 0 = None, 255 = Max
fog_minclip4 float Fog Minimum Clipping Distance 4
fog_maxclip4 float Fog Maximum Clipping Distance 4
fog_density float This is the intensity of the fog, this should be a number between 0-1, most commonly used is .1 or .33
flag_needed varchar Flag Required
canbind tinyint Can Bind: 0 = False, 1 = True (for Caster), 2 = True (for All)
cancombat tinyint Can Combat: 0 = False, 1 = True
canlevitate tinyint Can Levitate: 0 = False, 1 = True (Does not affect those with #gm on)
castoutdoor tinyint Cast Outdoors: 0 = False, 1 = True
hotzone tinyint Hotzone: 0 = False, 1 = True
insttype tinyint Instance Type
shutdowndelay bigint Shutdown Delay
peqzone tinyint #peqzone: 0 = False, 1 = True
expansion tinyint Expansion
suspendbuffs tinyint Suspend Buffs: 0 = False, 1 = True
rain_chance1 int Rain Chance 1
rain_chance2 int Rain Chance 2
rain_chance3 int Rain Chance 3
rain_chance4 int Rain Chance 4
rain_duration1 int Rain Duration 1
rain_duration2 int Rain Duration 2
rain_duration3 int Rain Duration 3
rain_duration4 int Rain Duration 4
snow_chance1 int Snow Chance 1
snow_chance2 int Snow Chance 2
snow_chance3 int Snow Chance 3
snow_chance4 int Snow Chance 4
snow_duration1 int Snow Duration 1
snow_duration2 int Snow Duration 2
snow_duration3 int Snow Duration 3
snow_duration4 int Snow Duration 4
gravity float Gravity
type int Type (0 = Unknown, 1 = Regular, 2 = Instanced, 3 = Hybrid, 4 = Raid, 5 = City)
skylock tinyint Sky Lock
fast_regen_hp int Fast Regen Health
fast_regen_mana int Fast Regen Mana
fast_regen_endurance int Fast Regen Endurance
npc_max_aggro_dist int NPC Max Aggro Distance
max_movement_update_range int Max Movement Update Range
min_expansion tinyint
max_expansion tinyint
content_flags varchar
content_flags_disabled varchar
underworld_teleport_index int
lava_damage int
min_lava_damage int
Back to top