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 |