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 |