Skip to content

zone

Info

This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Diagram Edit

Relationships

Relationship Type Local Key Relates to Table Foreign Key
One-to-One content_flags content_flags flag_name
One-to-One content_flags_disabled content_flags flag_name
Has-Many short_name adventure_template zone
Has-Many short_name doors zone
Has-Many short_name doors dest_zone
Has-Many short_name global_loot zone
Has-Many short_name hackers zone
Has-Many short_name launcher_zones zone
Has-Many short_name spawn_conditions zone
Has-Many short_name spawn_condition_values zone
Has-Many short_name spawn_events zone
Has-Many short_name spawn2 zone
Has-Many short_name spells_new teleport_zone
Has-Many short_name traps zone
Has-Many short_name zone_points zone
Has-Many zoneidnumber adventure_template graveyard_zone_id
Has-Many zoneidnumber adventure_template zone_in_zone_id
Has-Many zoneidnumber bot_data zone_id
Has-Many zoneidnumber blocked_spells zoneid
Has-Many zoneidnumber char_create_combinations start_zone
Has-Many zoneidnumber character_bind zone_id
Has-Many zoneidnumber character_corpses zone_id
Has-Many zoneidnumber character_data zone_id
Has-Many zoneidnumber character_exp_modifiers zone_id
Has-Many zoneidnumber character_peqzone_flags zone_id
Has-Many zoneidnumber fishing zoneid
Has-Many zoneidnumber forage zoneid
Has-Many zoneidnumber graveyard zone_id
Has-Many zoneidnumber grid zoneid
Has-Many zoneidnumber grid_entries zoneid
Has-Many zoneidnumber ground_spawns zoneid
Has-Many zoneidnumber instance_list zone
Has-Many zoneidnumber object zoneid
Has-Many zoneidnumber object_contents zoneid
Has-Many zoneidnumber petitions zone
Has-Many zoneidnumber proximities zoneid
Has-Many zoneidnumber qs_merchant_transaction_record zone_id
Has-Many zoneidnumber qs_player_npc_kill_record zone_id
Has-Many zoneidnumber quest_globals zoneid
Has-Many zoneidnumber start_zones zone_id
Has-Many zoneidnumber start_zones start_zone
Has-Many zoneidnumber starting_items zoneid
Has-Many zoneidnumber task_activities zones
Has-Many zoneidnumber zone_flags zoneID
Has-Many zoneidnumber zone_points target_zone_id
Has-Many version adventure_template version
Has-Many version doors version
Has-Many version ground_spawns version
Has-Many version instance_list version
Has-Many version object version
Has-Many version spawn2 version
Has-Many version traps version
Has-Many version zone_points version

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 Safe Heading Coordinate
graveyard_id float Graveyard Identifier
min_level tinyint Minimum Level
max_level tinyint Maximum 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
bucket_name varchar
bucket_value varchar
bucket_comparison tinyint
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
bypass_expansion_check tinyint Bypass Expansion Check: 0 = False, 1 = True
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 Minimum Expansion
max_expansion tinyint Maximum Expansion
content_flags varchar Content Flags Required to be Enabled
content_flags_disabled varchar Content Flags Required to be Disabled
underworld_teleport_index int Underworld Teleport Index
lava_damage int Lava Damage Modifier
min_lava_damage int Minimum Lava Damage Modifier