mmo-ref/ddon-server
1
0
Fork 0
mirror of https://github.com/sebastian-heinz/Arrowgene.DragonsDogmaOnline synced 2026-08-03 11:12:41 -04:00
Code Issues Projects Releases Packages Wiki Activity Actions
ddon-server/Arrowgene.Ddon.Database/Files/Database/Script/migration_quest_variant.sql

16 lines
615 B
MySQL
Raw Permalink Normal View History

Modified migration_quest_variant.sql to delete a non existent quest id which would throw errors when processing. Added extra check for adding quest variations to ensure standard behaviour
2024-08-30 19:55:27 +01:00
Added a way for variant quests to be added to the project. This version stored a variant id within quest progress if a quest has started. This is used to find the specific quest version the client needs to show the correct enemies. Rewards may still not work as expected. Needs further looking at.
2024-08-29 18:27:23 +01:00
ALTER TABLE "ddon_quest_progress"
Added support for variant quests to drop their independent rewards as defined in their JSON. Renamed variant id to be more explicit within the schema.
2024-08-30 18:20:15 +01:00
ADD COLUMN "variant_quest_id" INTEGER NOT NULL DEFAULT 0;
ALTER TABLE "ddon_reward_box"
ADD COLUMN "variant_quest_id" INTEGER NOT NULL DEFAULT 0;
Implemented review changes and updated sql to not delete but update entries
2024-09-03 10:03:15 +01:00
UPDATE "ddon_quest_progress" SET "quest_id" = 20055001 WHERE "quest_id" = 2005501;
UPDATE "ddon_quest_progress" SET "variant_quest_id" = 102030 WHERE "quest_id" = 20055001;
UPDATE "ddon_priority_quests" SET "quest_id" = 20055001 WHERE "quest_id" = 2005501;
UPDATE "ddon_reward_box" SET "quest_id" = 20055001 WHERE "quest_id" = 2005501;
UPDATE "ddon_completed_quests" SET "quest_id" = 20055001 WHERE "quest_id" = 2005501;
Reference in a new issue Copy permalink