mirror of
https://github.com/sebastian-heinz/Arrowgene.DragonsDogmaOnline
synced 2026-08-03 11:12:41 -04:00
2fdc6a7988
- Added comments documenting some special numbers. - Fixed an issue with GetContentStatusFromOmReq. - Updated migration logic to use sql commands directly. - Fixed an issue a crash occured after resetting progress and changing jobs. - S2CBattleContentAreaChange.cs => S2CBattleContentAreaChangeNtc.cs. - Moved loot generation into instanced manager for BBM. - Moved SwapCharacterInventories to CharacterSwitchGameModeHandler. - Added a DB query to get all storages by character id. - Fixed issue with new character creation. - Fixed an issue where main quests didn't start. - Delete BBM character when main character is deleted
41 lines
1.8 KiB
SQL
41 lines
1.8 KiB
SQL
ALTER TABLE "ddon_character" ADD "game_mode" INTEGER DEFAULT 1 NOT NULL;
|
|
|
|
CREATE TABLE "ddon_bbm_character_map" (
|
|
"character_id" INTEGER PRIMARY KEY NOT NULL,
|
|
"bbm_character_id" INTEGER NOT NULL,
|
|
CONSTRAINT fk_ddon_bbm_character_map_character_id FOREIGN KEY ("character_id") REFERENCES "ddon_character" ("character_id") ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE TABLE "ddon_bbm_progress" (
|
|
"character_id" INTEGER PRIMARY KEY NOT NULL,
|
|
"start_time" INTEGER NOT NULL,
|
|
"content_id" INTEGER NOT NULL,
|
|
"content_mode" INTEGER NOT NULL,
|
|
"tier" INTEGER NOT NULL,
|
|
"killed_death" BOOLEAN NOT NULL,
|
|
"last_ticket_time" INTEGER NOT NULL,
|
|
CONSTRAINT fk_ddon_bbm_progress_character_id FOREIGN KEY ("character_id") REFERENCES "ddon_character" ("character_id") ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE TABLE "ddon_bbm_rewards" (
|
|
"character_id" INTEGER PRIMARY KEY NOT NULL,
|
|
"gold_marks" INTEGER NOT NULL,
|
|
"silver_marks" INTEGER NOT NULL,
|
|
"red_marks" INTEGER NOT NULL,
|
|
CONSTRAINT fk_ddon_bbm_rewards_character_id FOREIGN KEY ("character_id") REFERENCES "ddon_character" ("character_id") ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE TABLE "ddon_bbm_content_treasure" (
|
|
"character_id" INTEGER PRIMARY KEY NOT NULL,
|
|
"content_id" INTEGER NOT NULL,
|
|
"amount" INTEGER NOT NULL,
|
|
CONSTRAINT fk_ddon_bbm_content_treasure_character_id FOREIGN KEY ("character_id") REFERENCES "ddon_character" ("character_id") ON DELETE CASCADE
|
|
);
|
|
|
|
INSERT INTO ddon_bbm_progress (character_id, start_time, content_id, content_mode, tier, killed_death, last_ticket_time)
|
|
SELECT character_id, 0, 0, 0, 0, 0, 0
|
|
FROM ddon_character;
|
|
|
|
INSERT INTO ddon_bbm_rewards (character_id, gold_marks, silver_marks, red_marks)
|
|
SELECT character_id, 0, 0, 0
|
|
FROM ddon_character;
|