MSQ Season 1.0

[pacampbell]

Added limited support for the main story quests released in Season 1.0

• Resolutions and Omens
• The Slumbering God
• Envoy of Reconciliation
• Soldiers of the Rift
• A Servants Pledge
• The Crimson Crystal
• The Dull Grey Ark
• The Girl in the Forest
• The Goblin King
• The House of Steam
• The Assailed Fort
• The Castle of Dusk
• The Gods Awakening

Check the quest document for more information about what does and does not work for each MSQ.

Database Migration Scripts

CREATE TABLE IF NOT EXISTS "ddon_quest_progress" (
    "character_common_id"   INTEGER NOT NULL,
    "quest_type"    INTEGER NOT NULL,
    "quest_id"  INTEGER NOT NULL,
    "step"  INTEGER NOT NULL,
    FOREIGN KEY("character_common_id") REFERENCES "ddon_character_common"("character_common_id") ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS "ddon_completed_quests" (
    "character_common_id"   INTEGER NOT NULL,
    "quest_type"    INTEGER NOT NULL,
    "quest_id"  INTEGER NOT NULL,
    FOREIGN KEY("character_common_id") REFERENCES "ddon_character_common"("character_common_id") ON DELETE CASCADE
);

[!WARNING] If using an existing character, the database needs to be adjusted to put that character starting from the second MSQ

REPLACE INTO ddon_completed_quests
SELECT character_common_id, 0, 1
FROM ddon_character;

REPLACE INTO ddon_quest_progress
SELECT character_common_id, 0, 2, 0
FROM ddon_character;

The first main story quest does not work well on any job other than the starting 4.

Co-authored-by: @Abiel-Machioni Co-authored-by: @abiorugu0044 Co-authored-by: @certwdtwyrmab

Checklist:

• [x] The project compiles
• [x] The PR targets develop branch