Skip to content

zone

Relationships

erDiagram
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    content_flags {
        varchar flag_name
    }
    adventure_template {
        intunsigned id
        intunsigned graveyard_zone_id
        varchar zone
        smallintunsigned zone_in_zone_id
        tinyintunsigned zone_version
        varchar version
    }
    doors {
        varchar content_flags
        varchar content_flags_disabled
        int dz_switch_id
        int keyitem
        varchar zone
        varchar dest_zone
        intunsigned dest_instance
        smallint version
    }
    global_loot {
        varchar content_flags
        varchar content_flags_disabled
        int loottable_id
        mediumtext zone
    }
    hackers {
        varchar account
        varchar name
        varchar zone
    }
    zone ||--o{ content_flags : "One-to-One"
    zone ||--o{ content_flags : "One-to-One"
    zone ||--o{ adventure_template : "Has-Many"
    zone ||--o{ doors : "Has-Many"
    zone ||--o{ doors : "Has-Many"
    zone ||--o{ global_loot : "Has-Many"
    zone ||--o{ hackers : "Has-Many"
    zone ||--o{ adventure_template : "Has-Many"
    zone ||--o{ adventure_template : "Has-Many"
    zone ||--o{ adventure_template : "Has-Many"
    zone ||--o{ doors : "Has-Many"


erDiagram
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    launcher_zones {
        varchar launcher
        varchar zone
    }
    spawn_conditions {
        mediumintunsigned id
        varchar zone
    }
    spawn_condition_values {
        intunsigned instance_id
        intunsigned id
        varchar zone
    }
    spawn_events {
        mediumintunsigned cond_id
        varchar zone
    }
    spawn2 {
        varchar content_flags
        varchar content_flags_disabled
        int pathgrid
        int id
        int spawngroupID
        smallint version
        varchar zone
    }
    zone ||--o{ launcher_zones : "Has-Many"
    zone ||--o{ spawn_conditions : "Has-Many"
    zone ||--o{ spawn_condition_values : "Has-Many"
    zone ||--o{ spawn_events : "Has-Many"
    zone ||--o{ spawn2 : "Has-Many"
    zone ||--o{ spawn2 : "Has-Many"


erDiagram
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    traps {
        varchar content_flags
        varchar content_flags_disabled
        smallintunsigned version
        varchar zone
    }
    zone_points {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned target_instance
        varchar zone
        intunsigned target_zone_id
        int version
    }
    bot_data {
        varchar bot_id
        varchar owner_id
        varchar spells_id
        varchar zone_id
    }
    blocked_spells {
        mediumintunsigned spellid
        int zoneid
    }
    zone ||--o{ spells_new : "Has-Many"
    zone ||--o{ traps : "Has-Many"
    zone ||--o{ zone_points : "Has-Many"
    zone ||--o{ bot_data : "Has-Many"
    zone ||--o{ blocked_spells : "Has-Many"
    zone ||--o{ zone_points : "Has-Many"
    zone ||--o{ traps : "Has-Many"
    zone ||--o{ zone_points : "Has-Many"


erDiagram
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    char_create_combinations {
        intunsigned allocation_id
        intunsigned start_zone
    }
    character_bind {
        intunsigned id
        smallintunsigned zone_id
        mediumintunsigned instance_id
    }
    character_corpses {
        intunsigned id
        intunsigned charid
        varchar charname
        smallintunsigned instance_id
        smallint zone_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    character_exp_modifiers {
        int character_id
        int zone_id
    }
    zone ||--o{ char_create_combinations : "Has-Many"
    zone ||--o{ character_bind : "Has-Many"
    zone ||--o{ character_corpses : "Has-Many"
    zone ||--o{ character_data : "Has-Many"
    zone ||--o{ character_exp_modifiers : "Has-Many"


erDiagram
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    character_peqzone_flags {
        int id
        int zone_id
    }
    fishing {
        varchar content_flags
        varchar content_flags_disabled
        int Itemid
        int zoneid
        int npc_id
    }
    forage {
        varchar content_flags
        varchar content_flags_disabled
        int Itemid
        int zoneid
    }
    graveyard {
        int zone_id
    }
    grid {
        int id
        int zoneid
    }
    zone ||--o{ character_peqzone_flags : "Has-Many"
    zone ||--o{ fishing : "Has-Many"
    zone ||--o{ forage : "Has-Many"
    zone ||--o{ graveyard : "Has-Many"
    zone ||--o{ grid : "Has-Many"


erDiagram
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    grid_entries {
        int gridid
        varchar grid_id
        int zoneid
    }
    ground_spawns {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned item
        smallint version
        intunsigned zoneid
    }
    instance_list {
        int id
        tinyintunsigned version
        intunsigned zone
    }
    object {
        varchar content_flags
        varchar content_flags_disabled
        int itemid
        int id
        smallint version
        intunsigned zoneid
    }
    object_contents {
        intunsigned itemid
        intunsigned parentid
        mediumintunsigned augslot1
        mediumintunsigned augslot2
        mediumintunsigned augslot3
        mediumintunsigned augslot4
        mediumintunsigned augslot5
        mediumint augslot6
        intunsigned zoneid
    }
    zone ||--o{ grid_entries : "Has-Many"
    zone ||--o{ ground_spawns : "Has-Many"
    zone ||--o{ instance_list : "Has-Many"
    zone ||--o{ object : "Has-Many"
    zone ||--o{ object_contents : "Has-Many"
    zone ||--o{ ground_spawns : "Has-Many"
    zone ||--o{ instance_list : "Has-Many"
    zone ||--o{ object : "Has-Many"


erDiagram
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    petitions {
        varchar accountname
        varchar charname
        varchar lastgm
        varchar zone
    }
    proximities {
        varchar zoneid
    }
    qs_merchant_transaction_record {
        int char_id
        int merchant_id
        int zone_id
    }
    qs_player_npc_kill_record {
        int npc_id
        int zone_id
    }
    quest_globals {
        int charid
        varchar name
        int npcid
        int zoneid
    }
    zone ||--o{ petitions : "Has-Many"
    zone ||--o{ proximities : "Has-Many"
    zone ||--o{ qs_merchant_transaction_record : "Has-Many"
    zone ||--o{ qs_player_npc_kill_record : "Has-Many"
    zone ||--o{ quest_globals : "Has-Many"


erDiagram
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    start_zones {
        varchar content_flags
        varchar content_flags_disabled
        int start_zone
        int zone_id
    }
    starting_items {
        varchar content_flags
        varchar content_flags_disabled
        varchar itemid
        varchar zone_id
        varchar zoneid
    }
    task_activities {
        intunsigned activityid
        varchar goalid
        varchar delivertonpc
        intunsigned taskid
        varchar zones
    }
    zone_flags {
        int charID
        int zoneID
        varchar zoneid
    }
    zone ||--o{ start_zones : "Has-Many"
    zone ||--o{ start_zones : "Has-Many"
    zone ||--o{ starting_items : "Has-Many"
    zone ||--o{ task_activities : "Has-Many"
    zone ||--o{ zone_flags : "Has-Many"
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
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
idle_when_empty tinyint
seconds_before_idle int