import { DEFAULT_WORLD_SETTINGS } from "../../../shared/protocol/constants.js"; import { normalizeStarterLoadout } from "../../../shared/items/starterLoadout.js"; import { normalizeEquipmentStatBonuses } from "../../../shared/definitions/equipmentStatCategories.js"; import { normalizeInitialQuests } from "../../../shared/quests/initialQuests.js"; import { OVERWORLD_ID, DIMENSION_PURGE_MS, defaultDimensionRecord, normalizeDimensionRecord, normalizeDimensionId, isOverworld } from "../../../shared/world/dimensions.js"; import { openDatabase, withTransaction } from "./database.js"; const WORLD_SCHEMA = ` CREATE TABLE IF NOT EXISTS world_revisions ( revision_id INTEGER PRIMARY KEY AUTOINCREMENT, created_at INTEGER NOT NULL, created_by TEXT NOT NULL, status TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS world_chunk_versions ( dimension_id TEXT NOT NULL DEFAULT 'overworld', chunk_x INTEGER NOT NULL, chunk_y INTEGER NOT NULL, revision_id INTEGER NOT NULL, open INTEGER NOT NULL, data_blob TEXT NOT NULL, PRIMARY KEY (dimension_id, chunk_x, chunk_y, revision_id) ); CREATE TABLE IF NOT EXISTS world_meta ( key TEXT PRIMARY KEY, value INTEGER ); CREATE TABLE IF NOT EXISTS world_settings ( revision_id INTEGER PRIMARY KEY, settings_blob TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS world_chunk_edit_log ( log_id INTEGER PRIMARY KEY AUTOINCREMENT, dimension_id TEXT NOT NULL DEFAULT 'overworld', chunk_x INTEGER NOT NULL, chunk_y INTEGER NOT NULL, revision_id INTEGER NOT NULL, editor_admin_id TEXT NOT NULL, edited_at INTEGER NOT NULL, diff_entries TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS world_live_settings ( id INTEGER PRIMARY KEY CHECK (id = 1), settings_blob TEXT NOT NULL, updated_at INTEGER NOT NULL, updated_by TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS world_settings_edit_log ( log_id INTEGER PRIMARY KEY AUTOINCREMENT, editor_admin_id TEXT NOT NULL, edited_at INTEGER NOT NULL, diff_entries TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS world_quest_defs ( revision_id INTEGER NOT NULL, quest_id TEXT NOT NULL, def_blob TEXT NOT NULL, PRIMARY KEY (revision_id, quest_id) ); CREATE TABLE IF NOT EXISTS world_dialogue_trees ( revision_id INTEGER NOT NULL, dialogue_id TEXT NOT NULL, tree_blob TEXT NOT NULL, PRIMARY KEY (revision_id, dialogue_id) ); CREATE TABLE IF NOT EXISTS world_quest_edit_log ( log_id INTEGER PRIMARY KEY AUTOINCREMENT, quest_id TEXT NOT NULL, revision_id INTEGER NOT NULL, editor_admin_id TEXT NOT NULL, edited_at INTEGER NOT NULL, diff_entries TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS world_dialogue_edit_log ( log_id INTEGER PRIMARY KEY AUTOINCREMENT, dialogue_id TEXT NOT NULL, revision_id INTEGER NOT NULL, editor_admin_id TEXT NOT NULL, edited_at INTEGER NOT NULL, diff_entries TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS world_dimensions ( revision_id INTEGER NOT NULL, dimension_id TEXT NOT NULL, display_name TEXT NOT NULL, lighting_mode TEXT NOT NULL, season_mode TEXT NOT NULL, default_ground_type_id INTEGER NOT NULL, deleted_at INTEGER, purge_after INTEGER, PRIMARY KEY (revision_id, dimension_id) ); `; export class WorldDatabase { constructor (filePath) { this.db = openDatabase(filePath); this.db.exec(WORLD_SCHEMA); this.#migrateChunkDimensionColumn(); this.#ensureInitialRevision(); this.#ensureLiveSettings(); this.#ensureOverworldDimension(this.getActiveRevisionId()); } #migrateChunkDimensionColumn () { const cols = this.db.prepare("PRAGMA table_info(world_chunk_versions)").all(); const hasDim = cols.some((col) => col.name === "dimension_id"); if (hasDim) { this.#migrateEditLogDimensionColumn(); return; } withTransaction(this.db, () => { this.db.exec(` CREATE TABLE world_chunk_versions_v2 ( dimension_id TEXT NOT NULL DEFAULT 'overworld', chunk_x INTEGER NOT NULL, chunk_y INTEGER NOT NULL, revision_id INTEGER NOT NULL, open INTEGER NOT NULL, data_blob TEXT NOT NULL, PRIMARY KEY (dimension_id, chunk_x, chunk_y, revision_id) ); INSERT INTO world_chunk_versions_v2 (dimension_id, chunk_x, chunk_y, revision_id, open, data_blob) SELECT 'overworld', chunk_x, chunk_y, revision_id, open, data_blob FROM world_chunk_versions; DROP TABLE world_chunk_versions; ALTER TABLE world_chunk_versions_v2 RENAME TO world_chunk_versions; `); }); this.#migrateEditLogDimensionColumn(); } #migrateEditLogDimensionColumn () { const cols = this.db.prepare("PRAGMA table_info(world_chunk_edit_log)").all(); const hasDim = cols.some((col) => col.name === "dimension_id"); if (hasDim) { return; } withTransaction(this.db, () => { this.db.exec(` CREATE TABLE world_chunk_edit_log_v2 ( log_id INTEGER PRIMARY KEY AUTOINCREMENT, dimension_id TEXT NOT NULL DEFAULT 'overworld', chunk_x INTEGER NOT NULL, chunk_y INTEGER NOT NULL, revision_id INTEGER NOT NULL, editor_admin_id TEXT NOT NULL, edited_at INTEGER NOT NULL, diff_entries TEXT NOT NULL ); INSERT INTO world_chunk_edit_log_v2 (log_id, dimension_id, chunk_x, chunk_y, revision_id, editor_admin_id, edited_at, diff_entries) SELECT log_id, 'overworld', chunk_x, chunk_y, revision_id, editor_admin_id, edited_at, diff_entries FROM world_chunk_edit_log; DROP TABLE world_chunk_edit_log; ALTER TABLE world_chunk_edit_log_v2 RENAME TO world_chunk_edit_log; `); }); } #ensureInitialRevision () { const meta = this.db.prepare("SELECT key, value FROM world_meta").all(); if (meta.length > 0) { return; } withTransaction(this.db, () => { this.db.prepare( "INSERT INTO world_revisions (created_at, created_by, status) VALUES (?, ?, ?)" ).run(Date.now(), "system", "active"); const revisionId = Number(this.db.prepare("SELECT last_insert_rowid() AS id").get().id); this.db.prepare("INSERT INTO world_meta (key, value) VALUES ('active_revision', ?)").run(revisionId); this.db.exec("INSERT INTO world_meta (key, value) VALUES ('pending_revision', NULL)"); this.db.prepare("INSERT INTO world_settings (revision_id, settings_blob) VALUES (?, ?)").run( revisionId, JSON.stringify(DEFAULT_WORLD_SETTINGS) ); this.#upsertDimensionRow(revisionId, defaultDimensionRecord(OVERWORLD_ID, { defaultGroundTypeId: DEFAULT_WORLD_SETTINGS.defaultGroundTypeId })); }); } #ensureOverworldDimension (revisionId) { if (revisionId == null) { return; } const existing = this.getDimension(revisionId, OVERWORLD_ID); if (existing) { return; } const settings = this.getSettings(revisionId); this.#upsertDimensionRow(revisionId, defaultDimensionRecord(OVERWORLD_ID, { defaultGroundTypeId: settings.defaultGroundTypeId })); } #upsertDimensionRow (revisionId, record) { const dim = normalizeDimensionRecord(record); this.db.prepare(` INSERT INTO world_dimensions ( revision_id, dimension_id, display_name, lighting_mode, season_mode, default_ground_type_id, deleted_at, purge_after ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(revision_id, dimension_id) DO UPDATE SET display_name = excluded.display_name, lighting_mode = excluded.lighting_mode, season_mode = excluded.season_mode, default_ground_type_id = excluded.default_ground_type_id, deleted_at = excluded.deleted_at, purge_after = excluded.purge_after `).run( revisionId, dim.dimensionId, dim.displayName, dim.lightingMode, dim.seasonMode, dim.defaultGroundTypeId, dim.deletedAt, dim.purgeAfter ); } #rowToDimension (row) { if (!row) { return null; } return normalizeDimensionRecord({ dimensionId: row.dimension_id, displayName: row.display_name, lightingMode: row.lighting_mode, seasonMode: row.season_mode, defaultGroundTypeId: row.default_ground_type_id, deletedAt: row.deleted_at, purgeAfter: row.purge_after }); } #ensureLiveSettings () { const existing = this.db.prepare("SELECT id FROM world_live_settings WHERE id = 1").get(); if (existing) { return; } const settings = this.getSettings(this.getActiveRevisionId()); this.db.prepare( "INSERT INTO world_live_settings (id, settings_blob, updated_at, updated_by) VALUES (1, ?, ?, ?)" ).run(JSON.stringify(settings), Date.now(), "system"); } getLiveSettings () { this.#ensureLiveSettings(); const row = this.db.prepare("SELECT settings_blob FROM world_live_settings WHERE id = 1").get(); const merged = row ? { ...DEFAULT_WORLD_SETTINGS, ...JSON.parse(row.settings_blob) } : { ...DEFAULT_WORLD_SETTINGS }; const loadout = normalizeStarterLoadout(merged); merged.starterEquipment = loadout.equipment; merged.starterInventory = loadout.inventory; merged.equipmentStatBonuses = normalizeEquipmentStatBonuses(merged.equipmentStatBonuses); merged.initialQuests = normalizeInitialQuests(merged.initialQuests); return merged; } saveLiveSettings (settings, updatedBy) { this.db.prepare(` INSERT INTO world_live_settings (id, settings_blob, updated_at, updated_by) VALUES (1, ?, ?, ?) ON CONFLICT(id) DO UPDATE SET settings_blob = excluded.settings_blob, updated_at = excluded.updated_at, updated_by = excluded.updated_by `).run(JSON.stringify(settings), Date.now(), updatedBy); } appendSettingsChangelog (editorAdminId, diffEntries) { this.db.prepare(` INSERT INTO world_settings_edit_log (editor_admin_id, edited_at, diff_entries) VALUES (?, ?, ?) `).run(editorAdminId, Date.now(), JSON.stringify(diffEntries)); } listSettingsChangelog () { return this.db.prepare(` SELECT log_id, editor_admin_id, edited_at, diff_entries FROM world_settings_edit_log ORDER BY edited_at ASC, log_id ASC `).all().map((row) => ({ ...row, diffEntries: JSON.parse(row.diff_entries) })); } appendQuestChangelog (questId, revisionId, editorAdminId, diffEntries) { this.db.prepare(` INSERT INTO world_quest_edit_log (quest_id, revision_id, editor_admin_id, edited_at, diff_entries) VALUES (?, ?, ?, ?, ?) `).run(String(questId), revisionId, editorAdminId, Date.now(), JSON.stringify(diffEntries)); } listQuestChangelog (questId = null) { if (questId != null) { return this.db.prepare(` SELECT log_id, quest_id, revision_id, editor_admin_id, edited_at, diff_entries FROM world_quest_edit_log WHERE quest_id = ? ORDER BY edited_at ASC, log_id ASC `).all(String(questId)).map(mapQuestLogRow); } return this.db.prepare(` SELECT log_id, quest_id, revision_id, editor_admin_id, edited_at, diff_entries FROM world_quest_edit_log ORDER BY edited_at ASC, log_id ASC `).all().map(mapQuestLogRow); } appendDialogueChangelog (dialogueId, revisionId, editorAdminId, diffEntries) { this.db.prepare(` INSERT INTO world_dialogue_edit_log (dialogue_id, revision_id, editor_admin_id, edited_at, diff_entries) VALUES (?, ?, ?, ?, ?) `).run(String(dialogueId), revisionId, editorAdminId, Date.now(), JSON.stringify(diffEntries)); } listDialogueChangelog (dialogueId = null) { if (dialogueId != null) { return this.db.prepare(` SELECT log_id, dialogue_id, revision_id, editor_admin_id, edited_at, diff_entries FROM world_dialogue_edit_log WHERE dialogue_id = ? ORDER BY edited_at ASC, log_id ASC `).all(String(dialogueId)).map(mapDialogueLogRow); } return this.db.prepare(` SELECT log_id, dialogue_id, revision_id, editor_admin_id, edited_at, diff_entries FROM world_dialogue_edit_log ORDER BY edited_at ASC, log_id ASC `).all().map(mapDialogueLogRow); } /** * Recent edits across chunks, settings, quests, and dialogues (newest first). * @param {number} [limit] */ listGlobalChangelog (limit = 250) { const cap = Math.max(1, Math.min(1000, limit | 0 || 250)); const chunkRows = this.db.prepare(` SELECT log_id, dimension_id, chunk_x, chunk_y, editor_admin_id, edited_at, diff_entries FROM world_chunk_edit_log ORDER BY edited_at DESC, log_id DESC LIMIT ? `).all(cap).map((row) => ({ kind: "chunk", scope: `${row.dimension_id} ${row.chunk_x},${row.chunk_y}`, editor_admin_id: row.editor_admin_id, edited_at: row.edited_at, diffEntries: JSON.parse(row.diff_entries), _key: row.log_id })); const settingsRows = this.db.prepare(` SELECT log_id, editor_admin_id, edited_at, diff_entries FROM world_settings_edit_log ORDER BY edited_at DESC, log_id DESC LIMIT ? `).all(cap).map((row) => ({ kind: "settings", scope: "settings", editor_admin_id: row.editor_admin_id, edited_at: row.edited_at, diffEntries: JSON.parse(row.diff_entries), _key: row.log_id })); const questRows = this.db.prepare(` SELECT log_id, quest_id, editor_admin_id, edited_at, diff_entries FROM world_quest_edit_log ORDER BY edited_at DESC, log_id DESC LIMIT ? `).all(cap).map((row) => ({ kind: "quest", scope: row.quest_id, editor_admin_id: row.editor_admin_id, edited_at: row.edited_at, diffEntries: JSON.parse(row.diff_entries), _key: row.log_id })); const dialogueRows = this.db.prepare(` SELECT log_id, dialogue_id, editor_admin_id, edited_at, diff_entries FROM world_dialogue_edit_log ORDER BY edited_at DESC, log_id DESC LIMIT ? `).all(cap).map((row) => ({ kind: "dialogue", scope: row.dialogue_id, editor_admin_id: row.editor_admin_id, edited_at: row.edited_at, diffEntries: JSON.parse(row.diff_entries), _key: row.log_id })); return [...chunkRows, ...settingsRows, ...questRows, ...dialogueRows] .sort((a, b) => (b.edited_at - a.edited_at) || (b._key - a._key)) .slice(0, cap) .map(({ _key, ...entry }) => entry); } getActiveRevisionId () { return this.db.prepare("SELECT value FROM world_meta WHERE key = 'active_revision'").get()?.value ?? null; } getPendingRevisionId () { return this.db.prepare("SELECT value FROM world_meta WHERE key = 'pending_revision'").get()?.value ?? null; } getEditorRevisionId () { return this.getPendingRevisionId() ?? this.getActiveRevisionId(); } getSettings (revisionId) { const row = this.db.prepare("SELECT settings_blob FROM world_settings WHERE revision_id = ?").get(revisionId); if (row) { return { ...DEFAULT_WORLD_SETTINGS, ...JSON.parse(row.settings_blob) }; } const fallback = this.db.prepare( "SELECT settings_blob FROM world_settings WHERE revision_id <= ? ORDER BY revision_id DESC LIMIT 1" ).get(revisionId); return fallback ? { ...DEFAULT_WORLD_SETTINGS, ...JSON.parse(fallback.settings_blob) } : { ...DEFAULT_WORLD_SETTINGS }; } listDimensions (revisionId) { this.#ensureOverworldDimension(revisionId); return this.db.prepare(` SELECT dimension_id, display_name, lighting_mode, season_mode, default_ground_type_id, deleted_at, purge_after FROM world_dimensions WHERE revision_id = ? ORDER BY dimension_id ASC `).all(revisionId).map((row) => this.#rowToDimension(row)); } getDimension (revisionId, dimensionId) { const id = normalizeDimensionId(dimensionId); const row = this.db.prepare(` SELECT dimension_id, display_name, lighting_mode, season_mode, default_ground_type_id, deleted_at, purge_after FROM world_dimensions WHERE revision_id = ? AND dimension_id = ? `).get(revisionId, id); return this.#rowToDimension(row); } /** Latest dimension row at or before revision (for live fallback). */ getDimensionAtOrBefore (revisionId, dimensionId) { const id = normalizeDimensionId(dimensionId); const row = this.db.prepare(` SELECT dimension_id, display_name, lighting_mode, season_mode, default_ground_type_id, deleted_at, purge_after FROM world_dimensions WHERE dimension_id = ? AND revision_id <= ? ORDER BY revision_id DESC LIMIT 1 `).get(id, revisionId); return this.#rowToDimension(row); } saveDimension (revisionId, record) { const dim = normalizeDimensionRecord(record); if (isOverworld(dim.dimensionId)) { dim.deletedAt = null; dim.purgeAfter = null; } this.#upsertDimensionRow(revisionId, dim); return dim; } softDeleteDimension (revisionId, dimensionId, now = Date.now()) { const id = normalizeDimensionId(dimensionId); if (isOverworld(id)) { return { ok: false, error: "Cannot delete overworld." }; } const existing = this.getDimension(revisionId, id) ?? defaultDimensionRecord(id); existing.deletedAt = now; existing.purgeAfter = now + DIMENSION_PURGE_MS; this.#upsertDimensionRow(revisionId, existing); return { ok: true, dimension: existing }; } cancelDimensionDeletion (revisionId, dimensionId) { const id = normalizeDimensionId(dimensionId); const existing = this.getDimension(revisionId, id); if (!existing) { return { ok: false, error: "Unknown dimension." }; } existing.deletedAt = null; existing.purgeAfter = null; this.#upsertDimensionRow(revisionId, existing); return { ok: true, dimension: existing }; } /** Permanently remove dimensions past purge_after and all their chunk versions. */ purgeExpiredDimensions (now = Date.now()) { const rows = this.db.prepare(` SELECT DISTINCT dimension_id FROM world_dimensions WHERE purge_after IS NOT NULL AND purge_after <= ? AND dimension_id != ? `).all(now, OVERWORLD_ID); let purged = 0; for (const row of rows) { const id = row.dimension_id; withTransaction(this.db, () => { this.db.prepare("DELETE FROM world_chunk_versions WHERE dimension_id = ?").run(id); this.db.prepare("DELETE FROM world_chunk_edit_log WHERE dimension_id = ?").run(id); this.db.prepare("DELETE FROM world_dimensions WHERE dimension_id = ?").run(id); }); purged += 1; } return purged; } getChunkVersion (chunkX, chunkY, revisionId, dimensionId = OVERWORLD_ID) { const dim = normalizeDimensionId(dimensionId); return this.db.prepare(` SELECT dimension_id, chunk_x, chunk_y, revision_id, open, data_blob FROM world_chunk_versions WHERE dimension_id = ? AND chunk_x = ? AND chunk_y = ? AND revision_id <= ? ORDER BY revision_id DESC LIMIT 1 `).get(dim, chunkX, chunkY, revisionId) ?? null; } listChunkCoords (revisionId, dimensionId = null) { if (dimensionId != null) { const dim = normalizeDimensionId(dimensionId); return this.db.prepare(` SELECT dimension_id, chunk_x, chunk_y, MAX(revision_id) AS revision_id FROM world_chunk_versions WHERE revision_id <= ? AND dimension_id = ? GROUP BY dimension_id, chunk_x, chunk_y `).all(revisionId, dim); } return this.db.prepare(` SELECT dimension_id, chunk_x, chunk_y, MAX(revision_id) AS revision_id FROM world_chunk_versions WHERE revision_id <= ? GROUP BY dimension_id, chunk_x, chunk_y `).all(revisionId); } ensurePendingRevision (createdBy) { const existing = this.getPendingRevisionId(); if (existing) { return existing; } return withTransaction(this.db, () => { const activeId = this.getActiveRevisionId(); this.db.prepare( "INSERT INTO world_revisions (created_at, created_by, status) VALUES (?, ?, ?)" ).run(Date.now(), createdBy, "pending"); const revisionId = Number(this.db.prepare("SELECT last_insert_rowid() AS id").get().id); this.db.prepare("UPDATE world_meta SET value = ? WHERE key = 'pending_revision'").run(revisionId); const settings = this.getSettings(activeId); this.db.prepare("INSERT INTO world_settings (revision_id, settings_blob) VALUES (?, ?)").run( revisionId, JSON.stringify(settings) ); this.#copyQuestDefs(activeId, revisionId); this.#copyDialogueTrees(activeId, revisionId); this.#copyDimensions(activeId, revisionId); return revisionId; }); } #copyDimensions (fromRevisionId, toRevisionId) { const rows = this.listDimensions(fromRevisionId); for (const dim of rows) { this.#upsertDimensionRow(toRevisionId, dim); } this.#ensureOverworldDimension(toRevisionId); } #copyQuestDefs (fromRevisionId, toRevisionId) { const rows = this.listQuestDefs(fromRevisionId); const insert = this.db.prepare(` INSERT INTO world_quest_defs (revision_id, quest_id, def_blob) VALUES (?, ?, ?) `); for (const def of rows) { insert.run(toRevisionId, def.questId, JSON.stringify(def)); } } #copyDialogueTrees (fromRevisionId, toRevisionId) { const rows = this.listDialogueTrees(fromRevisionId); const insert = this.db.prepare(` INSERT INTO world_dialogue_trees (revision_id, dialogue_id, tree_blob) VALUES (?, ?, ?) `); for (const tree of rows) { insert.run(toRevisionId, tree.dialogueId, JSON.stringify(tree)); } } listQuestDefs (revisionId) { return this.db.prepare(` SELECT quest_id, def_blob FROM world_quest_defs WHERE revision_id = ? `).all(revisionId).map((row) => JSON.parse(row.def_blob)); } getQuestDef (revisionId, questId) { const row = this.db.prepare(` SELECT def_blob FROM world_quest_defs WHERE revision_id = ? AND quest_id = ? `).get(revisionId, questId); return row ? JSON.parse(row.def_blob) : null; } saveQuestDef (revisionId, def) { this.db.prepare(` INSERT INTO world_quest_defs (revision_id, quest_id, def_blob) VALUES (?, ?, ?) ON CONFLICT(revision_id, quest_id) DO UPDATE SET def_blob = excluded.def_blob `).run(revisionId, def.questId, JSON.stringify(def)); } deleteQuestDef (revisionId, questId) { this.db.prepare(` DELETE FROM world_quest_defs WHERE revision_id = ? AND quest_id = ? `).run(revisionId, questId); } listDialogueTrees (revisionId) { return this.db.prepare(` SELECT dialogue_id, tree_blob FROM world_dialogue_trees WHERE revision_id = ? `).all(revisionId).map((row) => JSON.parse(row.tree_blob)); } getDialogueTree (revisionId, dialogueId) { const row = this.db.prepare(` SELECT tree_blob FROM world_dialogue_trees WHERE revision_id = ? AND dialogue_id = ? `).get(revisionId, dialogueId); return row ? JSON.parse(row.tree_blob) : null; } saveDialogueTree (revisionId, tree) { this.db.prepare(` INSERT INTO world_dialogue_trees (revision_id, dialogue_id, tree_blob) VALUES (?, ?, ?) ON CONFLICT(revision_id, dialogue_id) DO UPDATE SET tree_blob = excluded.tree_blob `).run(revisionId, tree.dialogueId, JSON.stringify(tree)); } deleteDialogueTree (revisionId, dialogueId) { this.db.prepare(` DELETE FROM world_dialogue_trees WHERE revision_id = ? AND dialogue_id = ? `).run(revisionId, dialogueId); } saveChunkVersion (chunkX, chunkY, revisionId, open, dataBlob, dimensionId = OVERWORLD_ID) { const dim = normalizeDimensionId(dimensionId); this.db.prepare(` INSERT INTO world_chunk_versions (dimension_id, chunk_x, chunk_y, revision_id, open, data_blob) VALUES (?, ?, ?, ?, ?, ?) ON CONFLICT(dimension_id, chunk_x, chunk_y, revision_id) DO UPDATE SET open = excluded.open, data_blob = excluded.data_blob `).run(dim, chunkX, chunkY, revisionId, open ? 1 : 0, dataBlob); } saveSettings (revisionId, settings) { this.db.prepare(` INSERT INTO world_settings (revision_id, settings_blob) VALUES (?, ?) ON CONFLICT(revision_id) DO UPDATE SET settings_blob = excluded.settings_blob `).run(revisionId, JSON.stringify(settings)); } appendChangelog (chunkX, chunkY, revisionId, editorAdminId, diffEntries, dimensionId = OVERWORLD_ID) { const dim = normalizeDimensionId(dimensionId); this.db.prepare(` INSERT INTO world_chunk_edit_log (dimension_id, chunk_x, chunk_y, revision_id, editor_admin_id, edited_at, diff_entries) VALUES (?, ?, ?, ?, ?, ?, ?) `).run(dim, chunkX, chunkY, revisionId, editorAdminId, Date.now(), JSON.stringify(diffEntries)); } listChangelog (chunkX, chunkY, dimensionId = OVERWORLD_ID) { const dim = normalizeDimensionId(dimensionId); return this.db.prepare(` SELECT log_id, dimension_id, chunk_x, chunk_y, revision_id, editor_admin_id, edited_at, diff_entries FROM world_chunk_edit_log WHERE dimension_id = ? AND chunk_x = ? AND chunk_y = ? ORDER BY edited_at ASC, log_id ASC `).all(dim, chunkX, chunkY).map((row) => ({ ...row, dimensionId: row.dimension_id, diffEntries: JSON.parse(row.diff_entries) })); } promotePendingRevision () { const pendingId = this.getPendingRevisionId(); if (!pendingId) { return this.getActiveRevisionId(); } return withTransaction(this.db, () => { const activeId = this.getActiveRevisionId(); this.db.prepare("UPDATE world_revisions SET status = 'superseded' WHERE revision_id = ?").run(activeId); this.db.prepare("UPDATE world_revisions SET status = 'active' WHERE revision_id = ?").run(pendingId); this.db.prepare("UPDATE world_meta SET value = ? WHERE key = 'active_revision'").run(pendingId); this.db.exec("UPDATE world_meta SET value = NULL WHERE key = 'pending_revision'"); return pendingId; }); } close () { this.db.close(); } } function mapQuestLogRow (row) { return { ...row, questId: row.quest_id, diffEntries: JSON.parse(row.diff_entries) }; } function mapDialogueLogRow (row) { return { ...row, dialogueId: row.dialogue_id, diffEntries: JSON.parse(row.diff_entries) }; }