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) |
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 table ID |
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 | Settings that determines if added members automatically receive |
is_locked | tinyint | Expedition lock state (1: new members can not be added) |
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 the lockout was assigned 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) |
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 | If member is current active member or past member of expedition |
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 | Lockout expire time |
duration | unsigned int | Lockout's original duration when added |
from_expedition_uuid | varchar(36) | Original source expedition uuid the lockout was assigned in |
column | type | description |
id | unsigned int | Dynamic Zone ID (auto incremented) |
instance_id | int | ID for zone instance in |
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 | If zone in override coordinates are valid (zone's default zone-in location is used if not) |
