traps¶
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 | version | zone | version |
One-to-One | zone | zone | short_name |
Schema¶
Column | Data Type | Description |
---|---|---|
id | int | Unique Trap Identifier |
zone | varchar | Zone Short Name |
version | smallint | Version: -1 For All |
x | int | X Coordinate |
y | int | Y Coordinate |
z | int | Z Coordinate |
chance | tinyint | Chance: 0 = None, 100 = Always |
maxzdiff | float | Max Z Difference |
radius | float | Trap Radius |
effect | int | Trap Type |
effectvalue | int | Effect Value: (Based on Trap Type) 0 = Spell Identifier, 1 = Radius, 2 = NPC Type Identifier, 3 = NPC Type Identifier, 4 = Minimum Damage |
effectvalue2 | int | Effect Value 2: (Based on Trap Type) 0 = Unused, 1 = (0 = Everything Will Aggro, 1 = Only KoS Will Agro), 2 = Number of NPCs, 3 = Number of NPCs, 4 = Maximum Damage |
message | varchar | Message |
skill | int | Skill Required |
level | mediumint | Level |
respawn_time | int | Respawn Timer in Seconds |
respawn_var | int | Random Respawn Timer Variance in Seconds |
triggered_number | tinyint | Triggered Member |
group | tinyint | Group |
despawn_when_triggered | tinyint | Despawn When Triggered: 0 = False, 1 = True |
undetectable | tinyint | Undetectable: 0 = False, 1= True |
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 |