doors¶
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 |
| One-to-One | dz_switch_id | dynamic_zones | dz_switch_id |
| One-to-One | keyitem | items | id |
| One-to-One | zone | zone | short_name |
| One-to-One | dest_zone | zone | short_name |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| id | int | Unique Entry Identifier |
| doorid | smallint | Unique Door Identifier |
| zone | varchar | Zone Short Name |
| version | smallint | Zone Version: -1 For All |
| name | varchar | This is the name of the door, such as 'IT11161' or 'POPCREATE501', for names of objects you can see. |
| pos_y | float | Door Y Coordinate |
| pos_x | float | Door X Coordinate |
| pos_z | float | Door Z Coordinate |
| heading | float | Door Heading Coordinate |
| opentype | smallint | Door Open Type |
| guild | smallint | Guild Identifier |
| lockpick | smallint | Lockpicking Skill Required: -1 = Unpickable |
| keyitem | int | Item Identifier |
| nokeyring | tinyint | No Key Ring: 0 = False, 1 = True |
| triggerdoor | smallint | Trigger Door: 0 For Current Door or use a Unique Door Identifier |
| triggertype | smallint | Trigger Type: 1 = Open a Type 255 door, 255 = Will Not Open |
| disable_timer | tinyint | Disable Timer |
| doorisopen | smallint | Door Is Open: 0 = False, 1 = True |
| door_param | int | Door Parameter |
| dest_zone | varchar | Zone Short Name |
| dest_instance | int | Destination Instance |
| dest_x | float | Destination X Coordinate |
| dest_y | float | Destination Y Coordinate |
| dest_z | float | Destination Z Coordinate |
| dest_heading | float | Destination Heading Coordinate |
| invert_state | int | This column will basically behave like such: if the door has a click type and it is to raise up like a door, it will be raised on spawn of the door. Meaning it is inverted. Another example: If a Door Open Type is set to a spinning object on click, you could set this to 1 to have the door be spinning on spawn. |
| incline | int | Incline |
| size | smallint | Size |
| buffer | float | Unused |
| client_version_mask | int | Client Version Mask |
| is_ldon_door | smallint | Is LDoN Door: 0 = False, 1 = True |
| dz_switch_id | int | Dynamic Zone Switch Identifier |
| min_expansion | tinyint | Minimum Expansion](../../../../server/operation/expansion-list) |
| max_expansion | tinyint | Maximum Expansion](../../../../server/operation/expansion-list) |
| content_flags | varchar | Content Flags Required to be Enabled |
| content_flags_disabled | varchar | Content Flags Required to be Disabled |