Skip to content

traps

Info

This page was last generated 2022.09.16

Relationship Diagram(s)

Diagram Edit

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