zone¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
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 |