Skip to content



    adventure_template {
        intunsigned id
        intunsigned graveyard_zone_id
        varchar zone
        smallintunsigned zone_in_zone_id
        tinyintunsigned zone_version
        varchar version
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    adventure_details {
        intunsigned id
        smallintunsigned adventure_id
        int instance_id
    adventure_template ||--o{ zone : "One-to-One"
    adventure_template ||--o{ adventure_details : "One-to-One"
    adventure_template ||--o{ zone : "One-to-One"
    adventure_template ||--o{ zone : "One-to-One"
    adventure_template ||--o{ zone : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One graveyard_zone_id zone zoneidnumber
One-to-One id adventure_details id
One-to-One zone zone short_name
One-to-One zone_in_zone_id zone zoneidnumber
One-to-One zone_version zone version


Column Data Type Description
id int Adventure Identifier
zone varchar Zone Short Name
zone_version tinyint Zone Version
is_hard tinyint Hard: 0 = False, 1 = True
is_raid tinyint Raid: 0 = False, 1 = True
min_level tinyint Minimum Level
max_level tinyint Maximum Level
type tinyint Type
type_data int Type Data
type_count smallint Type Count
assa_x float Assassination X Coordinate
assa_y float Assassination Y Coordinate
assa_z float Assassination Z Coordinate
assa_h float Assassination Heading Coordinate
text varchar Text
duration int Duration
zone_in_time int Zone In Duration
win_points smallint LDoN Points for Winning
lose_points smallint LDoN Points for Losing
theme tinyint LDoN Theme
zone_in_zone_id smallint Zone In Zone Identifier
zone_in_x float Zone In X Coordinate
zone_in_y float Zone In Y Coordinate
zone_in_object_id smallint Zone In Object Identifier
dest_x float Destination X Coordinate
dest_y float Destination Y Coordinate
dest_z float Destination Z Coordinate
dest_h float Destination Heading Coordinate
graveyard_zone_id int Zone Identifier
graveyard_x float Graveyard X Coordinate
graveyard_y float Graveyard Y Coordinate
graveyard_z float Graveyard Z Coordinate
graveyard_radius float Graveyard Radius