Skip to content

Database

The expedition system uses the following database tables

table name description
expeditions Current active expeditions
expedition_lockouts Internal lockouts for current active expeditions
expedition_members Characters in active expeditions
character_expedition_lockouts Character lockouts
dynamic_zones Extends instances with additional dz data (compass, safereturn, zone-in)

expeditions

column type description
id unsigned int Expedition ID (auto incremented)
uuid varchar(36) Expedition UUID generated on creation used for certain lockout conflict checks
dynamic_zone_id unsigned int dynamic_zones ID used by the expedition
expedition_name varchar(128) Name of expedition
leader_id unsigned int Current leader's character ID
min_players tinyint Minimum players required to request expedition (1-255)
max_players tinyint Maximum players allowed in expedition (1-255)
add_replay_on_join tinyint (bool) If added members automatically receive Replay Timer lockout when joining an expedition that has it (default: 1)
is_locked tinyint (bool) Allow adding new members (0: unlocked, 1: locked)

expedition_lockouts

column type description
id unsigned int Auto incremented ID
expedition_id unsigned int Expedition ID the lockout belongs to
event_name varchar(256) Lockout event name
expire_time datetime Time the lockout expires
duration unsigned int Original duration (seconds) the lockout was added with
from_expedition_uuid varchar(36) Original source expedition uuid the lockout was assigned in (will differ from current expedition if inherited by leader on creation)

expedition_members

column type description
id unsigned int Auto incremented ID
expedition_id unsigned int Expedition ID the member belongs to
character_id unsigned int Member character ID
is_current_member tinyint (bool) Character is current member or past member of expedition

character_expedition_lockouts

column type description
id unsigned int Auto incremented ID
character_id unsigned int Character ID lockout belongs to
expedition_name varchar(128) Lockout expedition name
event_name varchar(256) Lockout event name
expire_time datetime Time the lockout expires
duration unsigned int Original duration (seconds) the lockout was added with
from_expedition_uuid varchar(36) Original source expedition uuid the lockout was assigned in

dynamic_zones

column type description
id unsigned int Dynamic Zone ID (auto incremented)
instance_id int ID for zone instance in instance_list table
type tinyint 0: None 1: Expedition 2: Tutorial 3: Task 4: Mission (Shared Task) 5: Quest
compass_zone_id unsigned int Zone ID the compass should be drawn in (0: no compass)
compass_zone_x float Compass x coordinate
compass_zone_y float Compass y coordinate
compass_zone_z float Compass z coordinate
safe_return_zone_id unsigned int Zone ID characters are moved to when removed from a dz (0: no safe return)
safe_return_x float Safe return x coordinate
safe_return_y float Safe return y coordinate
safe_return_z float Safe return z coordinate
safe_return_heading float Safe return heading
zone_in_x float Zone in x coordinate when character moved via MovePCDynamicZone()
zone_in_y float Zone in y coordinate when character moved via MovePCDynamicZone()
zone_in_z float Zone in z coordinate when character moved via MovePCDynamicZone()
zone_in_heading float Zone in heading when character moved via MovePCDynamicZone()
has_zone_in tinyint (bool) If zone in override coordinates are valid (zone's default zone-in location is used if not)
Back to top