zone¶
Info
This page was last generated 2022.09.16
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 |
| 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 | 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 |