mirror of
https://github.com/sebastian-heinz/Arrowgene.DragonsDogmaOnline
synced 2026-08-03 11:12:41 -04:00
49a6221d75
Decayed quest cancellation notice on area reset. Clean up EnemyId/EnemyUIId/ClientItemInfos implementation; use ItemId, EnemyId, and EnemyUIId when possible instead of uints Light quest DB stuff, adjustments to handle variant ids, removing decayed quests when returning to town, rotation task and RPC for child servers. Fix some tasks announcing to the non-head servers on the wrong route. Migration 43 -> 44; add support for new quest_id + variant_index scheme for decoupling quest and schedule id. Cleanup inconsistent packet id naming; add some new quest cancellation packets. Light quest generation, mixin for light quest rewards, and asset. Add DeliveryItemsLight and KillTargetEnemies block support to QuestBlockExtension. Add explicit support for DistributionStart/End in the quest asset and quest system. Remove existing board quests.
20 lines
794 B
SQL
20 lines
794 B
SQL
CREATE TABLE "ddon_light_quests"
|
|
(
|
|
"variant_id" INTEGER NOT NULL,
|
|
"quest_schedule_id" INTEGER NOT NULL,
|
|
"quest_id" INTEGER NOT NULL,
|
|
"target" INTEGER NOT NULL,
|
|
"level" INTEGER NOT NULL,
|
|
"count" INTEGER NOT NULL,
|
|
"reward_xp" INTEGER NOT NULL,
|
|
"reward_g" INTEGER NOT NULL,
|
|
"reward_r" INTEGER NOT NULL,
|
|
"reward_ap" INTEGER NOT NULL,
|
|
"distribution_end" DATETIME NOT NULL,
|
|
CONSTRAINT "pk_ddon_light_quests_variant_id" PRIMARY KEY ("variant_id")
|
|
);
|
|
INSERT INTO "ddon_schedule_next"(type, timestamp)
|
|
VALUES (6, 0);
|
|
|
|
DELETE FROM ddon_priority_quests;
|
|
DELETE FROM ddon_rank_record;
|