[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_461":462,"_463":464},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":53,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",352,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","82592d08-a4d9-11f1-854e-1607ee4eb77e","name","fileType","script","content","// SQLite persistence layer\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Character } from \"./types.ts\";\n\n// Channel-wide default cooldowns for custom commands/triggers (mods can\n// override per-command/per-trigger with !dndbot cooldown / !trigger cooldown).\nexport const DEFAULT_CUSTOM_COMMAND_COOLDOWN_MS = 5_000;\nexport const DEFAULT_CUSTOM_TRIGGER_COOLDOWN_MS = 15_000;\n\nasync function tableColumns(table: string): Promise {\n const res = await sqlite.execute(`PRAGMA table_info(${table})`);\n return res.rows.map((r: any) => String(r.name));\n}\n\nasync function migrateCharacterTables() {\n const chars = await tableColumns(\"characters\");\n if (chars.length && !chars.includes(\"broadcaster_id\")) {\n await sqlite.execute(\"ALTER TABLE characters RENAME TO characters_legacy\");\n }\n const backups = await tableColumns(\"character_backups\");\n if (backups.length && !backups.includes(\"broadcaster_id\")) {\n await sqlite.execute(\"ALTER TABLE character_backups RENAME TO character_backups_legacy\");\n }\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS characters (\n broadcaster_id TEXT, username TEXT, race TEXT, subrace TEXT, class TEXT, level INTEGER,\n xp INTEGER DEFAULT 0, str INTEGER, dex INTEGER, con INTEGER, int INTEGER, wis INTEGER, cha INTEGER,\n speed INTEGER, hp_max INTEGER, hp_current INTEGER, proficiency INTEGER, traits TEXT,\n spells TEXT DEFAULT '[]', items TEXT DEFAULT '[]', feats TEXT DEFAULT '[]', abilities TEXT DEFAULT '[]',\n PRIMARY KEY (broadcaster_id, username)\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS character_backups (\n broadcaster_id TEXT, username TEXT, race TEXT, subrace TEXT, class TEXT, level INTEGER,\n xp INTEGER DEFAULT 0, str INTEGER, dex INTEGER, con INTEGER, int INTEGER, wis INTEGER, cha INTEGER,\n speed INTEGER, hp_max INTEGER, hp_current INTEGER, proficiency INTEGER, traits TEXT,\n spells TEXT DEFAULT '[]', items TEXT DEFAULT '[]', feats TEXT DEFAULT '[]', abilities TEXT DEFAULT '[]',\n PRIMARY KEY (broadcaster_id, username)\n )`);\n const legacyChars = await tableColumns(\"characters_legacy\");\n if (legacyChars.length) {\n for (const column of [\"spells\", \"items\", \"feats\", \"abilities\", \"xp\"]) {\n if (!legacyChars.includes(column)) {\n await sqlite.execute(`ALTER TABLE characters_legacy ADD COLUMN ${column} ${column === \"xp\" ? \"INTEGER DEFAULT 0\" : \"TEXT DEFAULT '[]'\"}`);\n }\n }\n await sqlite.execute(`INSERT OR IGNORE INTO characters\n (broadcaster_id,username,race,subrace,class,level,xp,str,dex,con,int,wis,cha,speed,hp_max,hp_current,proficiency,traits,spells,items,feats,abilities)\n SELECT cc.broadcaster_id,c.username,c.race,c.subrace,c.class,c.level,COALESCE(c.xp,0),c.str,c.dex,c.con,c.int,c.wis,c.cha,c.speed,c.hp_max,c.hp_current,c.proficiency,c.traits,COALESCE(c.spells,'[]'),COALESCE(c.items,'[]'),COALESCE(c.feats,'[]'),COALESCE(c.abilities,'[]')\n FROM characters_legacy c JOIN channel_characters cc ON cc.username=c.username`);\n await sqlite.execute(\"DROP TABLE characters_legacy\");\n }\n const legacyBackups = await tableColumns(\"character_backups_legacy\");\n if (legacyBackups.length) {\n for (const column of [\"spells\", \"items\", \"feats\", \"abilities\", \"xp\"]) {\n if (!legacyBackups.includes(column)) {\n await sqlite.execute(`ALTER TABLE character_backups_legacy ADD COLUMN ${column} ${column === \"xp\" ? \"INTEGER DEFAULT 0\" : \"TEXT DEFAULT '[]'\"}`);\n }\n }\n await sqlite.execute(`INSERT OR IGNORE INTO character_backups\n (broadcaster_id,username,race,subrace,class,level,xp,str,dex,con,int,wis,cha,speed,hp_max,hp_current,proficiency,traits,spells,items,feats,abilities)\n SELECT cc.broadcaster_id,c.username,c.race,c.subrace,c.class,c.level,COALESCE(c.xp,0),c.str,c.dex,c.con,c.int,c.wis,c.cha,c.speed,c.hp_max,c.hp_current,c.proficiency,c.traits,COALESCE(c.spells,'[]'),COALESCE(c.items,'[]'),COALESCE(c.feats,'[]'),COALESCE(c.abilities,'[]')\n FROM character_backups_legacy c JOIN channel_characters cc ON cc.username=c.username`);\n await sqlite.execute(\"DROP TABLE character_backups_legacy\");\n }\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_characters_channel ON characters(broadcaster_id)\");\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_backups_channel ON character_backups(broadcaster_id)\");\n}\n\nasync function migrateCreationSessions() {\n const cols = await tableColumns(\"creation_sessions\");\n if (cols.length && !cols.includes(\"broadcaster_id\")) {\n await sqlite.execute(\"ALTER TABLE creation_sessions RENAME TO creation_sessions_legacy\");\n await sqlite.execute(`CREATE TABLE creation_sessions (\n broadcaster_id TEXT, username TEXT, step TEXT, race TEXT, subrace TEXT, class TEXT, scores TEXT, updated_at INTEGER,\n PRIMARY KEY (broadcaster_id, username)\n )`);\n await sqlite.execute(`INSERT OR IGNORE INTO creation_sessions (broadcaster_id,username,step,race,subrace,class,scores,updated_at)\n SELECT cc.broadcaster_id,s.username,s.step,s.race,s.subrace,s.class,s.scores,s.updated_at\n FROM creation_sessions_legacy s JOIN channel_characters cc ON cc.username=s.username`);\n await sqlite.execute(\"DROP TABLE creation_sessions_legacy\");\n }\n}\n\nasync function migrateMapTables() {\n // Sparse cell storage: a map only stores *overridden* cells; anything not\n // present falls back to the map's own default_terrain. Keeps `!map fill`\n // and large grids cheap, in line with SQLite's limited ALTER TABLE support.\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS maps (\n broadcaster_id TEXT NOT NULL,\n map_name TEXT NOT NULL,\n width INTEGER NOT NULL,\n height INTEGER NOT NULL,\n default_terrain TEXT NOT NULL DEFAULT 'grass',\n created_by TEXT,\n created_at INTEGER,\n updated_at INTEGER,\n PRIMARY KEY (broadcaster_id, map_name)\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS map_cells (\n broadcaster_id TEXT NOT NULL,\n map_name TEXT NOT NULL,\n x INTEGER NOT NULL,\n y INTEGER NOT NULL,\n terrain TEXT NOT NULL,\n PRIMARY KEY (broadcaster_id, map_name, x, y)\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS map_tokens (\n broadcaster_id TEXT NOT NULL,\n map_name TEXT NOT NULL,\n username TEXT NOT NULL,\n display_name TEXT,\n x INTEGER NOT NULL,\n y INTEGER NOT NULL,\n placed_at INTEGER,\n updated_at INTEGER,\n PRIMARY KEY (broadcaster_id, map_name, username)\n )`);\n}\n\nexport async function ensureTables() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS channel_characters (broadcaster_id TEXT, username TEXT, created_at INTEGER, updated_at INTEGER, PRIMARY KEY (broadcaster_id, username))`);\n await migrateCharacterTables();\n await migrateMapTables();\n for (const table of [\"characters\", \"character_backups\"]) {\n for (const column of [\"spells\", \"items\", \"feats\", \"abilities\"]) {\n try {\n await sqlite.execute(`ALTER TABLE ${table} ADD COLUMN ${column} TEXT DEFAULT '[]'`);\n } catch (_) {\n /* column already exists */\n }\n }\n try {\n await sqlite.execute(`ALTER TABLE ${table} ADD COLUMN xp INTEGER DEFAULT 0`);\n } catch (_) {\n /* column already exists */\n }\n }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS eventsub_extra_subscriptions (\n broadcaster_id TEXT, kind TEXT, subscription_id TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, kind)\n )`,\n );\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS oauth_states (state TEXT PRIMARY KEY, expires_at INTEGER)`);\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS broadcasters (\n broadcaster_id TEXT PRIMARY KEY, login TEXT, display_name TEXT, subscription_id TEXT, connected_at INTEGER, connected INTEGER NOT NULL DEFAULT 1, disconnected_at INTEGER, disconnect_reason TEXT\n )`,\n );\n try { await sqlite.execute(`ALTER TABLE broadcasters ADD COLUMN connected INTEGER NOT NULL DEFAULT 1`); } catch (_) {}\n try { await sqlite.execute(`ALTER TABLE broadcasters ADD COLUMN disconnected_at INTEGER`); } catch (_) {}\n try { await sqlite.execute(`ALTER TABLE broadcasters ADD COLUMN disconnect_reason TEXT`); } catch (_) {}\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS channel_characters (broadcaster_id TEXT, username TEXT, created_at INTEGER, updated_at INTEGER, PRIMARY KEY (broadcaster_id, username))`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS channel_blocks (broadcaster_id TEXT PRIMARY KEY, reason TEXT, created_at INTEGER, updated_at INTEGER)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS monitor_events (id INTEGER PRIMARY KEY AUTOINCREMENT, kind TEXT, detail TEXT, created_at INTEGER)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS eventsub_messages (message_id TEXT PRIMARY KEY, received_at INTEGER NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS command_rate_limits (broadcaster_id TEXT, username TEXT, last_at INTEGER NOT NULL, PRIMARY KEY (broadcaster_id, username))`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS pending_eventsub_cancellations (subscription_id TEXT PRIMARY KEY, broadcaster_id TEXT NOT NULL, attempts INTEGER NOT NULL DEFAULT 0, last_error TEXT, updated_at INTEGER NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS welcomed_users (username TEXT PRIMARY KEY, welcomed_at INTEGER)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS goodnight_cooldowns (broadcaster_id TEXT PRIMARY KEY, last_at INTEGER NOT NULL)`);\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS creation_sessions (\n broadcaster_id TEXT, username TEXT, step TEXT, race TEXT, subrace TEXT, class TEXT, scores TEXT, updated_at INTEGER,\n PRIMARY KEY (broadcaster_id, username)\n )`,\n );\n await migrateCreationSessions();\n // BG3-flavored creation (!bg3) stores extra flavor text alongside the\n // standard wizard's race/subrace/class/scores columns.\n for (const column of [\"subclass\", \"background\", \"alignment\", \"hook\"]) {\n try {\n await sqlite.execute(`ALTER TABLE creation_sessions ADD COLUMN ${column} TEXT`);\n } catch (_) {\n /* column already exists */\n }\n }\n // target_user: who a pending confirm_createchar overwrite-warning applies\n // to (may differ from the session's own username when a mod is rolling a\n // random character for someone else via !createchar @user).\n try {\n await sqlite.execute(`ALTER TABLE creation_sessions ADD COLUMN target_user TEXT`);\n } catch (_) {\n /* column already exists */\n }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS encounters (\n broadcaster_id TEXT PRIMARY KEY, round INTEGER, current_index INTEGER, active INTEGER, entries TEXT, updated_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS activity_logs (\n id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT, broadcaster_id TEXT, action TEXT, detail TEXT, created_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS channel_settings (\n broadcaster_id TEXT PRIMARY KEY, enabled INTEGER NOT NULL DEFAULT 1, updated_at INTEGER\n )`,\n );\n // Open-stall merchant: off by default per channel. next_post_at is the\n // randomized due time (ms epoch) for the next ad; the merchant cron\n // trigger polls this rather than posting on every tick.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS merchant_settings (\n broadcaster_id TEXT PRIMARY KEY, enabled INTEGER NOT NULL DEFAULT 0, next_post_at INTEGER, updated_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS duel_challenges (\n broadcaster_id TEXT, challenger TEXT, defender TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, challenger, defender)\n )`,\n );\n try {\n await sqlite.execute(`ALTER TABLE duel_challenges ADD COLUMN mode TEXT DEFAULT 'auto'`);\n } catch (_) {\n /* column already exists */\n }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS duels (\n broadcaster_id TEXT PRIMARY KEY, challenger TEXT, defender TEXT, current_turn TEXT,\n challenger_hp INTEGER, defender_hp INTEGER, active INTEGER, updated_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS parties (\n broadcaster_id TEXT, party_name TEXT, owner TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, party_name)\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_members (\n broadcaster_id TEXT, party_name TEXT, username TEXT, joined_at INTEGER,\n PRIMARY KEY (broadcaster_id, party_name, username)\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_invites (\n broadcaster_id TEXT, party_name TEXT, target TEXT, inviter TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, party_name, target)\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_duel_challenges (\n broadcaster_id TEXT, challenger_party TEXT, defender_party TEXT,\n challenger_owner TEXT, defender_owner TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, challenger_party, defender_party)\n )`,\n );\n try {\n await sqlite.execute(`ALTER TABLE party_duel_challenges ADD COLUMN mode TEXT DEFAULT 'auto'`);\n } catch (_) {\n /* column already exists */\n }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_duels (\n broadcaster_id TEXT PRIMARY KEY, challenger_party TEXT, defender_party TEXT,\n current_side TEXT, current_index INTEGER, challenger_members TEXT, defender_members TEXT,\n challenger_hp TEXT, defender_hp TEXT, active INTEGER, updated_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS monster_duels (\n broadcaster_id TEXT PRIMARY KEY, player TEXT, monster_name TEXT, monster_cr TEXT,\n monster_ac INTEGER, monster_hp INTEGER, monster_hp_max INTEGER, monster_attack INTEGER,\n monster_damage_die INTEGER, monster_damage_bonus INTEGER, current_turn TEXT, active INTEGER, updated_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_monster_duels (\n broadcaster_id TEXT PRIMARY KEY,\n party_name TEXT,\n members TEXT,\n member_hp TEXT,\n current_index INTEGER,\n monster_name TEXT,\n monster_cr TEXT,\n monster_ac INTEGER,\n monster_hp INTEGER,\n monster_hp_max INTEGER,\n monster_attack INTEGER,\n monster_damage_die INTEGER,\n monster_damage_bonus INTEGER,\n active INTEGER,\n updated_at INTEGER\n )`,\n );\n // Custom commands (!dndbot add/edit/remove/cooldown/list) and passive\n // keyword triggers (!trigger), both authored from Twitch chat by the\n // broadcaster/mods — see customcommands.ts.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS custom_commands (\n broadcaster_id TEXT, name TEXT, response TEXT, created_by TEXT,\n created_at INTEGER, updated_at INTEGER, uses INTEGER NOT NULL DEFAULT 0,\n cooldown_ms INTEGER NOT NULL DEFAULT ${DEFAULT_CUSTOM_COMMAND_COOLDOWN_MS}, last_used_at INTEGER NOT NULL DEFAULT 0,\n PRIMARY KEY (broadcaster_id, name)\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS custom_triggers (\n broadcaster_id TEXT, keyword TEXT, response TEXT, created_by TEXT,\n created_at INTEGER, updated_at INTEGER, uses INTEGER NOT NULL DEFAULT 0,\n cooldown_ms INTEGER NOT NULL DEFAULT ${DEFAULT_CUSTOM_TRIGGER_COOLDOWN_MS}, last_used_at INTEGER NOT NULL DEFAULT 0,\n PRIMARY KEY (broadcaster_id, keyword)\n )`,\n );\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_custom_commands_channel ON custom_commands(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_custom_triggers_channel ON custom_triggers(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_activity_logs_channel_id ON activity_logs(broadcaster_id,id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_activity_logs_created ON activity_logs(created_at)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_channel_characters_channel ON channel_characters(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_party_members_channel ON party_members(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_parties_channel ON parties(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_activity_logs_username_channel ON activity_logs(broadcaster_id,username)`);\n}\n\nexport async function getPartyMonsterDuel(broadcasterId: string) {\n const res = await sqlite.execute(\n \"SELECT * FROM party_monster_duels WHERE broadcaster_id = ? AND active = 1\",\n [broadcasterId],\n );\n if (!res.rows.length) return null;\n const r = res.rows[0];\n return {\n ...r,\n current_index: Number(r.current_index),\n members: JSON.parse(r.members || \"[]\") as string[],\n member_hp: JSON.parse(r.member_hp || \"{}\") as Record,\n };\n}\n\nexport function rowToCharacter(r: any): Character {\n return {\n username: r.username,\n race: r.race,\n subrace: r.subrace,\n cls: r.class,\n level: r.level,\n xp: Number(r.xp ?? 0),\n scores: { STR: r.str, DEX: r.dex, CON: r.con, INT: r.int, WIS: r.wis, CHA: r.cha },\n speed: r.speed,\n hpMax: r.hp_max,\n hpCurrent: r.hp_current,\n proficiency: r.proficiency,\n traits: JSON.parse(r.traits || \"[]\"),\n spells: JSON.parse(r.spells || \"[]\"),\n items: JSON.parse(r.items || \"[]\"),\n feats: JSON.parse(r.feats || \"[]\"),\n abilities: JSON.parse(r.abilities || \"[]\"),\n };\n}\n\nexport async function getCharacter(username: string, broadcasterId: string) {\n const res = await sqlite.execute(\n \"SELECT * FROM characters WHERE broadcaster_id = ? AND username = ?\",\n [broadcasterId, username],\n );\n if (!res.rows.length) return null;\n await sqlite.execute(\n \"UPDATE channel_characters SET updated_at = ? WHERE broadcaster_id = ? AND username = ?\",\n [Date.now(), broadcasterId, username],\n );\n return rowToCharacter(res.rows[0]);\n}\n\nexport async function saveCharacter(c: Character, broadcasterId: string) {\n const existing = await sqlite.execute(\n \"SELECT 1 FROM channel_characters WHERE broadcaster_id = ? AND username = ?\",\n [broadcasterId, c.username],\n );\n if (!existing.rows.length) {\n const max = Math.max(1, Number(Deno.env.get(\"MAX_CHARACTERS_PER_CHANNEL\") ?? \"500\"));\n const count = await sqlite.execute(\"SELECT COUNT(*) AS count FROM channel_characters WHERE broadcaster_id = ?\", [broadcasterId]);\n if (Number(count.rows[0]?.count ?? 0) >= max) throw new Error(`Channel character cap reached (${max}).`);\n }\n const now = Date.now();\n await sqlite.execute(\n \"INSERT OR IGNORE INTO channel_characters (broadcaster_id,username,created_at,updated_at) VALUES (?,?,?,?)\",\n [broadcasterId, c.username, now, now],\n );\n await sqlite.execute(\"UPDATE channel_characters SET updated_at = ? WHERE broadcaster_id = ? AND username = ?\", [now, broadcasterId, c.username]);\n await sqlite.execute(\n `INSERT OR REPLACE INTO characters\n (broadcaster_id,username,race,subrace,class,level,xp,str,dex,con,int,wis,cha,speed,hp_max,hp_current,proficiency,traits,spells,items,feats,abilities)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n [\n broadcasterId,\n c.username,\n c.race,\n c.subrace,\n c.cls,\n c.level,\n c.xp ?? 0,\n c.scores.STR,\n c.scores.DEX,\n c.scores.CON,\n c.scores.INT,\n c.scores.WIS,\n c.scores.CHA,\n c.speed,\n c.hpMax,\n c.hpCurrent,\n c.proficiency,\n JSON.stringify(c.traits),\n JSON.stringify(c.spells),\n JSON.stringify(c.items),\n JSON.stringify(c.feats),\n JSON.stringify(c.abilities),\n ],\n );\n}\n\nexport async function adjustHp(username: string, delta: number, broadcasterId: string) {\n const c = await getCharacter(username, broadcasterId);\n if (!c) return null;\n c.hpCurrent = Math.max(0, Math.min(c.hpMax, c.hpCurrent + delta));\n await sqlite.execute(\"UPDATE characters SET hp_current = ? WHERE broadcaster_id = ? AND username = ?\", [c.hpCurrent, broadcasterId, username]);\n return c;\n}\n\nexport async function backupCharacter(username: string, broadcasterId: string) {\n const c = await getCharacter(username, broadcasterId);\n if (!c) return false;\n await sqlite.execute(\n `INSERT OR REPLACE INTO character_backups\n (broadcaster_id,username,race,subrace,class,level,xp,str,dex,con,int,wis,cha,speed,hp_max,hp_current,proficiency,traits,spells,items,feats,abilities)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n [\n broadcasterId,\n c.username,\n c.race,\n c.subrace,\n c.cls,\n c.level,\n c.xp ?? 0,\n c.scores.STR,\n c.scores.DEX,\n c.scores.CON,\n c.scores.INT,\n c.scores.WIS,\n c.scores.CHA,\n c.speed,\n c.hpMax,\n c.hpCurrent,\n c.proficiency,\n JSON.stringify(c.traits),\n JSON.stringify(c.spells),\n JSON.stringify(c.items),\n JSON.stringify(c.feats),\n JSON.stringify(c.abilities),\n ],\n );\n return true;\n}\n\nexport async function loadBackup(username: string, broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM character_backups WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n if (!res.rows.length) return null;\n const c = rowToCharacter(res.rows[0]);\n await saveCharacter(c, broadcasterId);\n return c;\n}\n\nexport async function resetCharacter(username: string, broadcasterId: string) {\n await sqlite.execute(\"DELETE FROM channel_characters WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n await sqlite.execute(\"DELETE FROM characters WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n await sqlite.execute(\"DELETE FROM character_backups WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n}\n\nexport async function getCreationSession(username: string, broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM creation_sessions WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n if (!res.rows.length) return null;\n const r = res.rows[0];\n return {\n username,\n broadcasterId,\n step: r.step,\n race: r.race,\n subrace: r.subrace,\n cls: r.class,\n scores: r.scores ? JSON.parse(r.scores) : null,\n subclass: r.subclass ?? null,\n background: r.background ?? null,\n alignment: r.alignment ?? null,\n hook: r.hook ?? null,\n targetUser: r.target_user ?? null,\n };\n}\n\nexport async function saveCreationSession(s: any, broadcasterId: string) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO creation_sessions (broadcaster_id,username,step,race,subrace,class,scores,subclass,background,alignment,hook,target_user,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)\",\n [\n broadcasterId,\n s.username,\n s.step,\n s.race ?? null,\n s.subrace ?? null,\n s.cls ?? null,\n s.scores ? JSON.stringify(s.scores) : null,\n s.subclass ?? null,\n s.background ?? null,\n s.alignment ?? null,\n s.hook ?? null,\n s.targetUser ?? null,\n Date.now(),\n ],\n );\n}\n\nexport async function clearCreationSession(username: string, broadcasterId: string) {\n await sqlite.execute(\"DELETE FROM creation_sessions WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n}\n\nexport async function getConnections() {\n const res = await sqlite.execute(\"SELECT display_name, login FROM broadcasters WHERE connected = 1 ORDER BY connected_at ASC\");\n return res.rows.map((r: any) => r.display_name || r.login);\n}\n\nexport async function isChannelBlocked(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT 1 FROM channel_blocks WHERE broadcaster_id = ?\", [broadcasterId]);\n return res.rows.length > 0;\n}\n\nexport async function blockChannel(broadcasterId: string, reason = \"operator block\") {\n await sqlite.execute(\"INSERT OR REPLACE INTO channel_blocks (broadcaster_id,reason,created_at,updated_at) VALUES (?,?,COALESCE((SELECT created_at FROM channel_blocks WHERE broadcaster_id = ?),?),?)\", [broadcasterId, reason.slice(0,240), broadcasterId, Date.now(), Date.now()]);\n await setChannelEnabled(broadcasterId, false);\n}\n\nexport async function unblockChannel(broadcasterId: string) {\n await sqlite.execute(\"DELETE FROM channel_blocks WHERE broadcaster_id = ?\", [broadcasterId]);\n await setChannelEnabled(broadcasterId, true);\n}\n\nexport async function markBroadcasterDisconnected(broadcasterId: string, reason: string, subscriptionId?: string) {\n await sqlite.execute(\n \"UPDATE broadcasters SET connected = 0, disconnected_at = ?, disconnect_reason = ?, subscription_id = COALESCE(?, subscription_id) WHERE broadcaster_id = ?\",\n [Date.now(), reason.slice(0, 240), subscriptionId ?? null, broadcasterId],\n );\n}\n\nexport async function getBroadcaster(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM broadcasters WHERE broadcaster_id = ?\", [broadcasterId]);\n return res.rows.length ? res.rows[0] : null;\n}\n\n// \"kind\" is a short label (\"sub\" for channel.subscribe, \"resub\" for\n// channel.subscription.message) distinguishing the two extra subscriptions\n// created alongside the main chat-message one in broadcasters.subscription_id.\nexport async function saveExtraEventSubSubscription(broadcasterId: string, kind: string, subscriptionId: string) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO eventsub_extra_subscriptions (broadcaster_id,kind,subscription_id,created_at) VALUES (?,?,?,?)\",\n [broadcasterId, kind, subscriptionId, Date.now()],\n );\n}\n\nexport async function getExtraEventSubSubscriptions(broadcasterId: string) {\n const res = await sqlite.execute(\n \"SELECT kind, subscription_id FROM eventsub_extra_subscriptions WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n return res.rows as Array<{ kind: string; subscription_id: string }>;\n}\n\nexport async function deleteExtraEventSubSubscriptions(broadcasterId: string) {\n await sqlite.execute(\"DELETE FROM eventsub_extra_subscriptions WHERE broadcaster_id = ?\", [broadcasterId]);\n}\n\nexport async function purgeChannelData(broadcasterId: string) {\n for (const table of [\n \"activity_logs\",\n \"creation_sessions\",\n \"encounters\",\n \"duel_challenges\",\n \"duels\",\n \"parties\",\n \"party_members\",\n \"party_invites\",\n \"party_duel_challenges\",\n \"party_duels\",\n \"monster_duels\",\n \"party_monster_duels\",\n \"channel_settings\",\n \"merchant_settings\",\n \"channel_characters\",\n \"characters\",\n \"character_backups\",\n \"eventsub_extra_subscriptions\",\n \"maps\",\n \"map_cells\",\n \"map_tokens\",\n ]) {\n await sqlite.execute(`DELETE FROM ${table} WHERE broadcaster_id = ?`, [broadcasterId]);\n }\n await sqlite.execute(\"DELETE FROM broadcasters WHERE broadcaster_id = ?\", [broadcasterId]);\n}\n\nexport async function disconnectBroadcasterData(broadcasterId: string, purge = false) {\n if (purge) await purgeChannelData(broadcasterId);\n else {\n await sqlite.execute(\"DELETE FROM channel_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n await sqlite.execute(\"DELETE FROM merchant_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n await sqlite.execute(\"DELETE FROM eventsub_extra_subscriptions WHERE broadcaster_id = ?\", [broadcasterId]);\n await sqlite.execute(\"DELETE FROM broadcasters WHERE broadcaster_id = ?\", [broadcasterId]);\n }\n}\n\nexport async function isChannelEnabled(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT enabled FROM channel_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n return !res.rows.length || Number(res.rows[0].enabled) === 1;\n}\n\nexport async function setChannelEnabled(broadcasterId: string, enabled: boolean) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO channel_settings (broadcaster_id, enabled, updated_at) VALUES (?,?,?)\",\n [broadcasterId, enabled ? 1 : 0, Date.now()],\n );\n}\n\nexport async function isMerchantEnabled(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT enabled FROM merchant_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n return res.rows.length > 0 && Number(res.rows[0].enabled) === 1;\n}\n\n/** Toggle the open-stall merchant. `nextPostAt` should be a freshly randomized\n * due time (ms epoch) when enabling; pass null when disabling. */\nexport async function setMerchantEnabled(broadcasterId: string, enabled: boolean, nextPostAt: number | null) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO merchant_settings (broadcaster_id, enabled, next_post_at, updated_at) VALUES (?,?,?,?)\",\n [broadcasterId, enabled ? 1 : 0, enabled ? nextPostAt : null, Date.now()],\n );\n}\n\n/** Channels whose merchant is enabled, due for a post, connected, not\n * operator-blocked, and not otherwise disabled via !dndbot off. */\nexport async function getDueMerchantChannels(now: number): Promise {\n const res = await sqlite.execute(\n `SELECT m.broadcaster_id AS broadcaster_id\n FROM merchant_settings m\n JOIN broadcasters b ON b.broadcaster_id = m.broadcaster_id AND b.connected = 1\n LEFT JOIN channel_settings cs ON cs.broadcaster_id = m.broadcaster_id\n LEFT JOIN channel_blocks cb ON cb.broadcaster_id = m.broadcaster_id\n WHERE m.enabled = 1\n AND m.next_post_at IS NOT NULL AND m.next_post_at <= ?\n AND cb.broadcaster_id IS NULL\n AND (cs.enabled IS NULL OR cs.enabled = 1)`,\n [now],\n );\n return res.rows.map((r: any) => String(r.broadcaster_id));\n}\n\nexport async function rescheduleMerchant(broadcasterId: string, nextPostAt: number) {\n await sqlite.execute(\n \"UPDATE merchant_settings SET next_post_at = ?, updated_at = ? WHERE broadcaster_id = ?\",\n [nextPostAt, Date.now(), broadcasterId],\n );\n}\n\nexport async function getDuel(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM duels WHERE broadcaster_id = ? AND active = 1\", [broadcasterId]);\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function getMonsterDuel(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM monster_duels WHERE broadcaster_id = ? AND active = 1\", [\n broadcasterId,\n ]);\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function getParty(broadcasterId: string, partyName: string) {\n const res = await sqlite.execute(\"SELECT * FROM parties WHERE broadcaster_id = ? AND party_name = ?\", [\n broadcasterId,\n partyName.toLowerCase(),\n ]);\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function getPartyMembers(broadcasterId: string, partyName: string) {\n const res = await sqlite.execute(\n \"SELECT username FROM party_members WHERE broadcaster_id = ? AND party_name = ? ORDER BY joined_at ASC\",\n [broadcasterId, partyName.toLowerCase()],\n );\n return res.rows.map((r: any) => String(r.username));\n}\n\n// A party invite must be explicitly accepted by the target before they're\n// added to party_members — see !party invite / accept / decline.\nexport async function createPartyInvite(\n broadcasterId: string,\n partyName: string,\n target: string,\n inviter: string,\n) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO party_invites (broadcaster_id,party_name,target,inviter,created_at) VALUES (?,?,?,?,?)\",\n [broadcasterId, partyName, target, inviter, Date.now()],\n );\n}\n\nexport async function getPartyInvites(broadcasterId: string, target: string) {\n const res = await sqlite.execute(\n \"SELECT * FROM party_invites WHERE broadcaster_id = ? AND target = ? ORDER BY created_at DESC\",\n [broadcasterId, target],\n );\n return res.rows;\n}\n\nexport async function getPartyInvite(broadcasterId: string, target: string, partyName: string) {\n const res = await sqlite.execute(\n \"SELECT * FROM party_invites WHERE broadcaster_id = ? AND target = ? AND party_name = ?\",\n [broadcasterId, target, partyName],\n );\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function deletePartyInvite(broadcasterId: string, partyName: string, target: string) {\n await sqlite.execute(\"DELETE FROM party_invites WHERE broadcaster_id = ? AND party_name = ? AND target = ?\", [\n broadcasterId,\n partyName,\n target,\n ]);\n}\n\nexport async function getPartyDuel(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM party_duels WHERE broadcaster_id = ? AND active = 1\", [\n broadcasterId,\n ]);\n if (!res.rows.length) return null;\n const r = res.rows[0];\n return {\n ...r,\n current_index: Number(r.current_index),\n challenger_members: JSON.parse(r.challenger_members || \"[]\"),\n defender_members: JSON.parse(r.defender_members || \"[]\"),\n challenger_hp: JSON.parse(r.challenger_hp || \"{}\"),\n defender_hp: JSON.parse(r.defender_hp || \"{}\"),\n };\n}\n\nexport async function getEncounter(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM encounters WHERE broadcaster_id = ?\", [broadcasterId]);\n if (!res.rows.length) return null;\n const r = res.rows[0];\n return {\n broadcasterId,\n round: Number(r.round),\n currentIndex: Number(r.current_index),\n active: Boolean(r.active),\n entries: JSON.parse(r.entries || \"[]\") as Array<{ name: string; initiative: number; dex?: number; rolled?: boolean }>,\n };\n}\n\nexport async function saveEncounter(e: any) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO encounters (broadcaster_id,round,current_index,active,entries,updated_at) VALUES (?,?,?,?,?,?)\",\n [e.broadcasterId, e.round, e.currentIndex, e.active ? 1 : 0, JSON.stringify(e.entries), Date.now()],\n );\n}\n\nexport async function recordActivity(username: string, broadcasterId: string, action: string, detail: string) {\n await sqlite.execute(\n \"INSERT INTO activity_logs (username,broadcaster_id,action,detail,created_at) VALUES (?,?,?,?,?)\",\n [username, broadcasterId, action.slice(0, 40), detail.replace(/\\s+/g, \" \").trim().slice(0, 220), Date.now()],\n );\n // Retain at most 5,000 rows per channel, plus a hard 90-day privacy window.\n await sqlite.execute(\n `DELETE FROM activity_logs\n WHERE created_at < ?\n OR (broadcaster_id = ? AND id NOT IN (SELECT id FROM activity_logs WHERE broadcaster_id = ? ORDER BY id DESC LIMIT 5000))`,\n [Date.now() - 90 * 24 * 60 * 60 * 1000, broadcasterId, broadcasterId],\n );\n}\n\nexport async function getRecentLogs(broadcasterId?: string, limit = 200) {\n const safeLimit = Math.max(1, Math.min(500, Math.floor(limit)));\n const query = broadcasterId\n ? `SELECT username,broadcaster_id,action,detail,created_at FROM activity_logs WHERE broadcaster_id = ? ORDER BY id DESC LIMIT ${safeLimit}`\n : `SELECT username,broadcaster_id,action,detail,created_at FROM activity_logs ORDER BY id DESC LIMIT ${safeLimit}`;\n const res = await sqlite.execute(query, broadcasterId ? [broadcasterId] : []);\n return res.rows;\n}\n\n/**\n * Distinct usernames who've used a bot command recently in this channel,\n * most-recently-active first. Powers !oracle's random-chatter pick — reuses\n * the existing activity_logs table rather than requiring a live Twitch\n * chatters-list API call (which would need a new OAuth scope + re-auth).\n */\nexport async function getRecentChatters(broadcasterId: string, limit = 50) {\n const safeLimit = Math.max(1, Math.min(200, Math.floor(limit)));\n const res = await sqlite.execute(\n `SELECT username, MAX(created_at) AS last_seen\n FROM (SELECT username, created_at FROM activity_logs WHERE broadcaster_id = ? ORDER BY id DESC LIMIT 500) AS recent\n GROUP BY username\n ORDER BY last_seen DESC\n LIMIT ${safeLimit}`,\n [broadcasterId],\n );\n return res.rows.map((r: any) => String(r.username));\n}\n\nexport { sqlite };\n\nexport async function queueEventSubCancellation(subscriptionId: string, broadcasterId: string, error: string) {\n if (!subscriptionId) return;\n await sqlite.execute(\n `INSERT OR REPLACE INTO pending_eventsub_cancellations (subscription_id,broadcaster_id,attempts,last_error,updated_at)\n VALUES (?, ?, COALESCE((SELECT attempts FROM pending_eventsub_cancellations WHERE subscription_id = ?), 0) + 1, ?, ?)`,\n [subscriptionId, broadcasterId, subscriptionId, error.slice(0, 500), Date.now()],\n );\n}\n\nexport async function getPendingEventSubCancellations(limit = 5) {\n const safeLimit = Math.max(1, Math.min(20, Math.floor(limit)));\n const res = await sqlite.execute(`SELECT * FROM pending_eventsub_cancellations ORDER BY updated_at ASC LIMIT ${safeLimit}`);\n return res.rows;\n}\n\nexport async function clearPendingEventSubCancellation(subscriptionId: string) {\n await sqlite.execute(\"DELETE FROM pending_eventsub_cancellations WHERE subscription_id = ?\", [subscriptionId]);\n}\n\nexport async function claimEventSubMessage(messageId: string, now = Date.now()) {\n if (!messageId) return false;\n try {\n await sqlite.execute(\"INSERT INTO eventsub_messages (message_id,received_at) VALUES (?,?)\", [messageId, now]);\n await sqlite.execute(\"DELETE FROM eventsub_messages WHERE received_at < ?\", [now - 24 * 60 * 60 * 1000]);\n return true;\n } catch (_) {\n return false;\n }\n}\n\nexport async function checkCommandRateLimit(broadcasterId: string, username: string, cooldownMs = 1200) {\n const now = Date.now();\n const res = await sqlite.execute(\"SELECT last_at FROM command_rate_limits WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n const last = Number(res.rows[0]?.last_at ?? 0);\n if (now - last < cooldownMs) return false;\n await sqlite.execute(\"INSERT OR REPLACE INTO command_rate_limits (broadcaster_id,username,last_at) VALUES (?,?,?)\", [broadcasterId, username, now]);\n await sqlite.execute(\"DELETE FROM command_rate_limits WHERE last_at < ?\", [now - 10 * 60 * 1000]);\n return true;\n}\n\n// Per-channel cooldown so a wave of \"goodnight\"s from many chatters only\n// gets one bot reply instead of one per person.\nexport async function checkGoodnightCooldown(broadcasterId: string, cooldownMs = 300_000) {\n const now = Date.now();\n const res = await sqlite.execute(\"SELECT last_at FROM goodnight_cooldowns WHERE broadcaster_id = ?\", [broadcasterId]);\n const last = Number(res.rows[0]?.last_at ?? 0);\n if (now - last < cooldownMs) return false;\n await sqlite.execute(\"INSERT OR REPLACE INTO goodnight_cooldowns (broadcaster_id,last_at) VALUES (?,?)\", [broadcasterId, now]);\n return true;\n}\n\nexport async function recordMonitorEvent(kind: string, detail: string) {\n await sqlite.execute(\"INSERT INTO monitor_events (kind,detail,created_at) VALUES (?,?,?)\", [kind.slice(0,80), detail.slice(0,500), Date.now()]);\n await sqlite.execute(\"DELETE FROM monitor_events WHERE id NOT IN (SELECT id FROM monitor_events ORDER BY id DESC LIMIT 1000)\");\n}\n\nexport async function getChannelCounts(broadcasterId: string) {\n const [p, c, l] = await Promise.all([\n sqlite.execute(\"SELECT COUNT(*) AS count FROM parties WHERE broadcaster_id = ?\", [broadcasterId]),\n sqlite.execute(\"SELECT COUNT(*) AS count FROM channel_characters WHERE broadcaster_id = ?\", [broadcasterId]),\n sqlite.execute(\"SELECT COUNT(*) AS count FROM activity_logs WHERE broadcaster_id = ?\", [broadcasterId]),\n ]);\n return { parties: Number(p.rows[0]?.count ?? 0), characters: Number(c.rows[0]?.count ?? 0), logs: Number(l.rows[0]?.count ?? 0) };\n}\n\n// ── Maps ──\n\nexport type MapRow = {\n broadcaster_id: string;\n map_name: string;\n width: number;\n height: number;\n default_terrain: string;\n created_by: string | null;\n created_at: number;\n updated_at: number;\n};\n\nexport type MapToken = {\n username: string;\n display_name: string | null;\n x: number;\n y: number;\n};\n\nexport async function getMap(broadcasterId: string, mapName: string): Promise {\n const res = await sqlite.execute(\"SELECT * FROM maps WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n if (!res.rows.length) return null;\n const r: any = res.rows[0];\n return {\n broadcaster_id: r.broadcaster_id,\n map_name: r.map_name,\n width: Number(r.width),\n height: Number(r.height),\n default_terrain: r.default_terrain,\n created_by: r.created_by,\n created_at: Number(r.created_at),\n updated_at: Number(r.updated_at),\n };\n}\n\nexport async function listMaps(broadcasterId: string): Promise {\n const res = await sqlite.execute(\"SELECT * FROM maps WHERE broadcaster_id = ? ORDER BY map_name ASC\", [broadcasterId]);\n return res.rows.map((r: any) => ({\n broadcaster_id: r.broadcaster_id,\n map_name: r.map_name,\n width: Number(r.width),\n height: Number(r.height),\n default_terrain: r.default_terrain,\n created_by: r.created_by,\n created_at: Number(r.created_at),\n updated_at: Number(r.updated_at),\n }));\n}\n\nexport async function createMap(\n broadcasterId: string,\n mapName: string,\n width: number,\n height: number,\n createdBy: string,\n) {\n const maxMaps = Math.max(1, Number(Deno.env.get(\"MAX_MAPS_PER_CHANNEL\") ?? \"25\"));\n const count = await sqlite.execute(\"SELECT COUNT(*) AS count FROM maps WHERE broadcaster_id = ?\", [broadcasterId]);\n if (Number(count.rows[0]?.count ?? 0) >= maxMaps) throw new Error(`Channel map cap reached (${maxMaps}).`);\n const now = Date.now();\n await sqlite.execute(\n \"INSERT INTO maps (broadcaster_id,map_name,width,height,default_terrain,created_by,created_at,updated_at) VALUES (?,?,?,?,?,?,?,?)\",\n [broadcasterId, mapName, width, height, \"grass\", createdBy, now, now],\n );\n}\n\nexport async function deleteMap(broadcasterId: string, mapName: string) {\n await sqlite.execute(\"DELETE FROM maps WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n await sqlite.execute(\"DELETE FROM map_cells WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n await sqlite.execute(\"DELETE FROM map_tokens WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n}\n\nasync function touchMap(broadcasterId: string, mapName: string) {\n await sqlite.execute(\"UPDATE maps SET updated_at = ? WHERE broadcaster_id = ? AND map_name = ?\", [Date.now(), broadcasterId, mapName]);\n}\n\nexport async function getMapCells(broadcasterId: string, mapName: string): Promise> {\n const res = await sqlite.execute(\"SELECT x,y,terrain FROM map_cells WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n const out: Record = {};\n for (const r of res.rows as any[]) out[`${r.x},${r.y}`] = r.terrain;\n return out;\n}\n\nexport async function setMapCell(broadcasterId: string, mapName: string, x: number, y: number, terrain: string) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO map_cells (broadcaster_id,map_name,x,y,terrain) VALUES (?,?,?,?,?)\",\n [broadcasterId, mapName, x, y, terrain],\n );\n await touchMap(broadcasterId, mapName);\n}\n\nexport async function fillMap(broadcasterId: string, mapName: string, terrain: string) {\n await sqlite.execute(\"DELETE FROM map_cells WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n await sqlite.execute(\"UPDATE maps SET default_terrain = ?, updated_at = ? WHERE broadcaster_id = ? AND map_name = ?\", [\n terrain,\n Date.now(),\n broadcasterId,\n mapName,\n ]);\n}\n\nexport async function getMapTokens(broadcasterId: string, mapName: string): Promise {\n const res = await sqlite.execute(\n \"SELECT username,display_name,x,y FROM map_tokens WHERE broadcaster_id = ? AND map_name = ?\",\n [broadcasterId, mapName],\n );\n return (res.rows as any[]).map((r) => ({ username: r.username, display_name: r.display_name, x: Number(r.x), y: Number(r.y) }));\n}\n\nexport async function getMapToken(broadcasterId: string, mapName: string, username: string): Promise {\n const res = await sqlite.execute(\n \"SELECT username,display_name,x,y FROM map_tokens WHERE broadcaster_id = ? AND map_name = ? AND username = ?\",\n [broadcasterId, mapName, username],\n );\n if (!res.rows.length) return null;\n const r: any = res.rows[0];\n return { username: r.username, display_name: r.display_name, x: Number(r.x), y: Number(r.y) };\n}\n\nexport async function findTokenAt(broadcasterId: string, mapName: string, x: number, y: number): Promise {\n const res = await sqlite.execute(\n \"SELECT username,display_name,x,y FROM map_tokens WHERE broadcaster_id = ? AND map_name = ? AND x = ? AND y = ?\",\n [broadcasterId, mapName, x, y],\n );\n if (!res.rows.length) return null;\n const r: any = res.rows[0];\n return { username: r.username, display_name: r.display_name, x: Number(r.x), y: Number(r.y) };\n}\n\nexport async function upsertMapToken(\n broadcasterId: string,\n mapName: string,\n username: string,\n displayName: string,\n x: number,\n y: number,\n) {\n const now = Date.now();\n await sqlite.execute(\n \"INSERT OR REPLACE INTO map_tokens (broadcaster_id,map_name,username,display_name,x,y,placed_at,updated_at) VALUES (?,?,?,?,?,?,?,?)\",\n [broadcasterId, mapName, username, displayName, x, y, now, now],\n );\n await touchMap(broadcasterId, mapName);\n}\n\nexport async function removeMapToken(broadcasterId: string, mapName: string, username: string) {\n await sqlite.execute(\"DELETE FROM map_tokens WHERE broadcaster_id = ? AND map_name = ? AND username = ?\", [broadcasterId, mapName, username]);\n await touchMap(broadcasterId, mapName);\n}\n\n// ── Custom commands & triggers ──\n\nexport async function countCustomCommands(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT COUNT(*) AS count FROM custom_commands WHERE broadcaster_id = ?\", [broadcasterId]);\n return Number(res.rows[0]?.count ?? 0);\n}\n\nexport async function getCustomCommand(broadcasterId: string, name: string) {\n const res = await sqlite.execute(\"SELECT * FROM custom_commands WHERE broadcaster_id = ? AND name = ?\", [broadcasterId, name]);\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function listCustomCommands(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT name, uses FROM custom_commands WHERE broadcaster_id = ? ORDER BY name ASC\", [broadcasterId]);\n return res.rows;\n}\n\nexport async function addCustomCommand(broadcasterId: string, name: string, response: string, createdBy: string) {\n if (await getCustomCommand(broadcasterId, name)) return { ok: false as const, error: \"exists\" as const };\n const max = Math.max(1, Number(Deno.env.get(\"MAX_CUSTOM_COMMANDS_PER_CHANNEL\") ?? \"100\"));\n if ((await countCustomCommands(broadcasterId)) >= max) return { ok: false as const, error: \"cap\" as const, max };\n const now = Date.now();\n await sqlite.execute(\n \"INSERT INTO custom_commands (broadcaster_id,name,response,created_by,created_at,updated_at,uses,cooldown_ms,last_used_at) VALUES (?,?,?,?,?,?,0,?,0)\",\n [broadcasterId, name, response, createdBy, now, now, DEFAULT_CUSTOM_COMMAND_COOLDOWN_MS],\n );\n return { ok: true as const };\n}\n\nexport async function editCustomCommand(broadcasterId: string, name: string, response: string) {\n if (!(await getCustomCommand(broadcasterId, name))) return false;\n await sqlite.execute(\n \"UPDATE custom_commands SET response = ?, updated_at = ? WHERE broadcaster_id = ? AND name = ?\",\n [response, Date.now(), broadcasterId, name],\n );\n return true;\n}\n\nexport async function deleteCustomCommand(broadcasterId: string, name: string) {\n if (!(await getCustomCommand(broadcasterId, name))) return false;\n await sqlite.execute(\"DELETE FROM custom_commands WHERE broadcaster_id = ? AND name = ?\", [broadcasterId, name]);\n return true;\n}\n\nexport async function setCustomCommandCooldown(broadcasterId: string, name: string, cooldownMs: number) {\n if (!(await getCustomCommand(broadcasterId, name))) return false;\n await sqlite.execute(\n \"UPDATE custom_commands SET cooldown_ms = ?, updated_at = ? WHERE broadcaster_id = ? AND name = ?\",\n [cooldownMs, Date.now(), broadcasterId, name],\n );\n return true;\n}\n\n/** Atomically checks cooldown and (if clear) records a use. Returns null if the command doesn't exist. */\nexport async function useCustomCommand(broadcasterId: string, name: string) {\n const row = await getCustomCommand(broadcasterId, name);\n if (!row) return null;\n const now = Date.now();\n const cooldownMs = Number(row.cooldown_ms ?? 0);\n const lastUsedAt = Number(row.last_used_at ?? 0);\n if (cooldownMs > 0 && now - lastUsedAt < cooldownMs) return { row, onCooldown: true as const };\n await sqlite.execute(\n \"UPDATE custom_commands SET uses = uses + 1, last_used_at = ? WHERE broadcaster_id = ? AND name = ?\",\n [now, broadcasterId, name],\n );\n return { row: { ...row, uses: Number(row.uses ?? 0) + 1 }, onCooldown: false as const };\n}\n\nexport async function countCustomTriggers(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT COUNT(*) AS count FROM custom_triggers WHERE broadcaster_id = ?\", [broadcasterId]);\n return Number(res.rows[0]?.count ?? 0);\n}\n\nexport async function getCustomTrigger(broadcasterId: string, keyword: string) {\n const res = await sqlite.execute(\"SELECT * FROM custom_triggers WHERE broadcaster_id = ? AND keyword = ?\", [broadcasterId, keyword]);\n return res.rows.length ? res.rows[0] : null;\n}\n\n// Every plain chat message is matched against this list (see\n// handleTriggerMatch in customcommands.ts), so it's kept small per channel\n// and cached only for the duration of a single request.\nexport async function listCustomTriggers(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM custom_triggers WHERE broadcaster_id = ? ORDER BY created_at ASC\", [broadcasterId]);\n return res.rows;\n}\n\nexport async function addCustomTrigger(broadcasterId: string, keyword: string, response: string, createdBy: string) {\n if (await getCustomTrigger(broadcasterId, keyword)) return { ok: false as const, error: \"exists\" as const };\n const max = Math.max(1, Number(Deno.env.get(\"MAX_CUSTOM_TRIGGERS_PER_CHANNEL\") ?? \"50\"));\n if ((await countCustomTriggers(broadcasterId)) >= max) return { ok: false as const, error: \"cap\" as const, max };\n const now = Date.now();\n await sqlite.execute(\n \"INSERT INTO custom_triggers (broadcaster_id,keyword,response,created_by,created_at,updated_at,uses,cooldown_ms,last_used_at) VALUES (?,?,?,?,?,?,0,?,0)\",\n [broadcasterId, keyword, response, createdBy, now, now, DEFAULT_CUSTOM_TRIGGER_COOLDOWN_MS],\n );\n return { ok: true as const };\n}\n\nexport async function deleteCustomTrigger(broadcasterId: string, keyword: string) {\n if (!(await getCustomTrigger(broadcasterId, keyword))) return false;\n await sqlite.execute(\"DELETE FROM custom_triggers WHERE broadcaster_id = ? AND keyword = ?\", [broadcasterId, keyword]);\n return true;\n}\n\nexport async function setCustomTriggerCooldown(broadcasterId: string, keyword: string, cooldownMs: number) {\n if (!(await getCustomTrigger(broadcasterId, keyword))) return false;\n await sqlite.execute(\n \"UPDATE custom_triggers SET cooldown_ms = ?, updated_at = ? WHERE broadcaster_id = ? AND keyword = ?\",\n [cooldownMs, Date.now(), broadcasterId, keyword],\n );\n return true;\n}\n\nexport async function markCustomTriggerUsed(broadcasterId: string, keyword: string) {\n await sqlite.execute(\n \"UPDATE custom_triggers SET uses = uses + 1, last_used_at = ? WHERE broadcaster_id = ? AND keyword = ?\",\n [Date.now(), broadcasterId, keyword],\n );\n}\n","// SQLite persistence layer\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Character } from \"./types.ts\";\n\n// Channel-wide default cooldowns for custom commands/triggers (mods can\n// override per-command/per-trigger with !dndbot cooldown / !trigger cooldown).\nexport const DEFAULT_CUSTOM_COMMAND_COOLDOWN_MS = 5_000;\nexport const DEFAULT_CUSTOM_TRIGGER_COOLDOWN_MS = 15_000;\n\nasync function tableColumns(table: string): Promise {\n const res = await sqlite.execute(`PRAGMA table_info(${table})`);\n return res.rows.map((r: any) => String(r.name));\n}\n\nasync function migrateCharacterTables() {\n const chars = await tableColumns(\"characters\");\n if (chars.length && !chars.includes(\"broadcaster_id\")) {\n await sqlite.execute(\"ALTER TABLE characters RENAME TO characters_legacy\");\n }\n const backups = await tableColumns(\"character_backups\");\n if (backups.length && !backups.includes(\"broadcaster_id\")) {\n await sqlite.execute(\"ALTER TABLE character_backups RENAME TO character_backups_legacy\");\n }\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS characters (\n broadcaster_id TEXT, username TEXT, race TEXT, subrace TEXT, class TEXT, level INTEGER,\n xp INTEGER DEFAULT 0, str INTEGER, dex INTEGER, con INTEGER, int INTEGER, wis INTEGER, cha INTEGER,\n speed INTEGER, hp_max INTEGER, hp_current INTEGER, proficiency INTEGER, traits TEXT,\n spells TEXT DEFAULT '[]', items TEXT DEFAULT '[]', feats TEXT DEFAULT '[]', abilities TEXT DEFAULT '[]',\n PRIMARY KEY (broadcaster_id, username)\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS character_backups (\n broadcaster_id TEXT, username TEXT, race TEXT, subrace TEXT, class TEXT, level INTEGER,\n xp INTEGER DEFAULT 0, str INTEGER, dex INTEGER, con INTEGER, int INTEGER, wis INTEGER, cha INTEGER,\n speed INTEGER, hp_max INTEGER, hp_current INTEGER, proficiency INTEGER, traits TEXT,\n spells TEXT DEFAULT '[]', items TEXT DEFAULT '[]', feats TEXT DEFAULT '[]', abilities TEXT DEFAULT '[]',\n PRIMARY KEY (broadcaster_id, username)\n )`);\n const legacyChars = await tableColumns(\"characters_legacy\");\n if (legacyChars.length) {\n for (const column of [\"spells\", \"items\", \"feats\", \"abilities\", \"xp\"]) {\n if (!legacyChars.includes(column)) {\n await sqlite.execute(`ALTER TABLE characters_legacy ADD COLUMN ${column} ${column === \"xp\" ? \"INTEGER DEFAULT 0\" : \"TEXT DEFAULT '[]'\"}`);\n }\n }\n await sqlite.execute(`INSERT OR IGNORE INTO characters\n (broadcaster_id,username,race,subrace,class,level,xp,str,dex,con,int,wis,cha,speed,hp_max,hp_current,proficiency,traits,spells,items,feats,abilities)\n SELECT cc.broadcaster_id,c.username,c.race,c.subrace,c.class,c.level,COALESCE(c.xp,0),c.str,c.dex,c.con,c.int,c.wis,c.cha,c.speed,c.hp_max,c.hp_current,c.proficiency,c.traits,COALESCE(c.spells,'[]'),COALESCE(c.items,'[]'),COALESCE(c.feats,'[]'),COALESCE(c.abilities,'[]')\n FROM characters_legacy c JOIN channel_characters cc ON cc.username=c.username`);\n await sqlite.execute(\"DROP TABLE characters_legacy\");\n }\n const legacyBackups = await tableColumns(\"character_backups_legacy\");\n if (legacyBackups.length) {\n for (const column of [\"spells\", \"items\", \"feats\", \"abilities\", \"xp\"]) {\n if (!legacyBackups.includes(column)) {\n await sqlite.execute(`ALTER TABLE character_backups_legacy ADD COLUMN ${column} ${column === \"xp\" ? \"INTEGER DEFAULT 0\" : \"TEXT DEFAULT '[]'\"}`);\n }\n }\n await sqlite.execute(`INSERT OR IGNORE INTO character_backups\n (broadcaster_id,username,race,subrace,class,level,xp,str,dex,con,int,wis,cha,speed,hp_max,hp_current,proficiency,traits,spells,items,feats,abilities)\n SELECT cc.broadcaster_id,c.username,c.race,c.subrace,c.class,c.level,COALESCE(c.xp,0),c.str,c.dex,c.con,c.int,c.wis,c.cha,c.speed,c.hp_max,c.hp_current,c.proficiency,c.traits,COALESCE(c.spells,'[]'),COALESCE(c.items,'[]'),COALESCE(c.feats,'[]'),COALESCE(c.abilities,'[]')\n FROM character_backups_legacy c JOIN channel_characters cc ON cc.username=c.username`);\n await sqlite.execute(\"DROP TABLE character_backups_legacy\");\n }\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_characters_channel ON characters(broadcaster_id)\");\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_backups_channel ON character_backups(broadcaster_id)\");\n}\n\nasync function migrateCreationSessions() {\n const cols = await tableColumns(\"creation_sessions\");\n if (cols.length && !cols.includes(\"broadcaster_id\")) {\n await sqlite.execute(\"ALTER TABLE creation_sessions RENAME TO creation_sessions_legacy\");\n await sqlite.execute(`CREATE TABLE creation_sessions (\n broadcaster_id TEXT, username TEXT, step TEXT, race TEXT, subrace TEXT, class TEXT, scores TEXT, updated_at INTEGER,\n PRIMARY KEY (broadcaster_id, username)\n )`);\n await sqlite.execute(`INSERT OR IGNORE INTO creation_sessions (broadcaster_id,username,step,race,subrace,class,scores,updated_at)\n SELECT cc.broadcaster_id,s.username,s.step,s.race,s.subrace,s.class,s.scores,s.updated_at\n FROM creation_sessions_legacy s JOIN channel_characters cc ON cc.username=s.username`);\n await sqlite.execute(\"DROP TABLE creation_sessions_legacy\");\n }\n}\n\nasync function migrateMapTables() {\n // Sparse cell storage: a map only stores *overridden* cells; anything not\n // present falls back to the map's own default_terrain. Keeps `!map fill`\n // and large grids cheap, in line with SQLite's limited ALTER TABLE support.\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS maps (\n broadcaster_id TEXT NOT NULL,\n map_name TEXT NOT NULL,\n width INTEGER NOT NULL,\n height INTEGER NOT NULL,\n default_terrain TEXT NOT NULL DEFAULT 'grass',\n created_by TEXT,\n created_at INTEGER,\n updated_at INTEGER,\n PRIMARY KEY (broadcaster_id, map_name)\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS map_cells (\n broadcaster_id TEXT NOT NULL,\n map_name TEXT NOT NULL,\n x INTEGER NOT NULL,\n y INTEGER NOT NULL,\n terrain TEXT NOT NULL,\n PRIMARY KEY (broadcaster_id, map_name, x, y)\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS map_tokens (\n broadcaster_id TEXT NOT NULL,\n map_name TEXT NOT NULL,\n username TEXT NOT NULL,\n display_name TEXT,\n x INTEGER NOT NULL,\n y INTEGER NOT NULL,\n placed_at INTEGER,\n updated_at INTEGER,\n PRIMARY KEY (broadcaster_id, map_name, username)\n )`);\n}\n\nexport async function ensureTables() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS channel_characters (broadcaster_id TEXT, username TEXT, created_at INTEGER, updated_at INTEGER, PRIMARY KEY (broadcaster_id, username))`);\n await migrateCharacterTables();\n await migrateMapTables();\n for (const table of [\"characters\", \"character_backups\"]) {\n for (const column of [\"spells\", \"items\", \"feats\", \"abilities\"]) {\n try {\n await sqlite.execute(`ALTER TABLE ${table} ADD COLUMN ${column} TEXT DEFAULT '[]'`);\n } catch (_) {\n /* column already exists */\n }\n }\n try {\n await sqlite.execute(`ALTER TABLE ${table} ADD COLUMN xp INTEGER DEFAULT 0`);\n } catch (_) {\n /* column already exists */\n }\n }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS eventsub_extra_subscriptions (\n broadcaster_id TEXT, kind TEXT, subscription_id TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, kind)\n )`,\n );\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS oauth_states (state TEXT PRIMARY KEY, expires_at INTEGER)`);\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS broadcasters (\n broadcaster_id TEXT PRIMARY KEY, login TEXT, display_name TEXT, subscription_id TEXT, connected_at INTEGER, connected INTEGER NOT NULL DEFAULT 1, disconnected_at INTEGER, disconnect_reason TEXT\n )`,\n );\n try { await sqlite.execute(`ALTER TABLE broadcasters ADD COLUMN connected INTEGER NOT NULL DEFAULT 1`); } catch (_) {}\n try { await sqlite.execute(`ALTER TABLE broadcasters ADD COLUMN disconnected_at INTEGER`); } catch (_) {}\n try { await sqlite.execute(`ALTER TABLE broadcasters ADD COLUMN disconnect_reason TEXT`); } catch (_) {}\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS channel_characters (broadcaster_id TEXT, username TEXT, created_at INTEGER, updated_at INTEGER, PRIMARY KEY (broadcaster_id, username))`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS channel_blocks (broadcaster_id TEXT PRIMARY KEY, reason TEXT, created_at INTEGER, updated_at INTEGER)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS monitor_events (id INTEGER PRIMARY KEY AUTOINCREMENT, kind TEXT, detail TEXT, created_at INTEGER)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS eventsub_messages (message_id TEXT PRIMARY KEY, received_at INTEGER NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS command_rate_limits (broadcaster_id TEXT, username TEXT, last_at INTEGER NOT NULL, PRIMARY KEY (broadcaster_id, username))`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS pending_eventsub_cancellations (subscription_id TEXT PRIMARY KEY, broadcaster_id TEXT NOT NULL, attempts INTEGER NOT NULL DEFAULT 0, last_error TEXT, updated_at INTEGER NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS welcomed_users (username TEXT PRIMARY KEY, welcomed_at INTEGER)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS goodnight_cooldowns (broadcaster_id TEXT PRIMARY KEY, last_at INTEGER NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS chronicle_cooldowns (broadcaster_id TEXT PRIMARY KEY, last_at INTEGER NOT NULL)`);\n // Running count of chat messages (any account, bots included) seen since\n // the chronicle's last quote in a channel — see bumpChronicleMessageCount.\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS chronicle_activity (broadcaster_id TEXT PRIMARY KEY, message_count INTEGER NOT NULL DEFAULT 0)`);\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS creation_sessions (\n broadcaster_id TEXT, username TEXT, step TEXT, race TEXT, subrace TEXT, class TEXT, scores TEXT, updated_at INTEGER,\n PRIMARY KEY (broadcaster_id, username)\n )`,\n );\n await migrateCreationSessions();\n // BG3-flavored creation (!bg3) stores extra flavor text alongside the\n // standard wizard's race/subrace/class/scores columns.\n for (const column of [\"subclass\", \"background\", \"alignment\", \"hook\"]) {\n try {\n await sqlite.execute(`ALTER TABLE creation_sessions ADD COLUMN ${column} TEXT`);\n } catch (_) {\n /* column already exists */\n }\n }\n // target_user: who a pending confirm_createchar overwrite-warning applies\n // to (may differ from the session's own username when a mod is rolling a\n // random character for someone else via !createchar @user).\n try {\n await sqlite.execute(`ALTER TABLE creation_sessions ADD COLUMN target_user TEXT`);\n } catch (_) {\n /* column already exists */\n }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS encounters (\n broadcaster_id TEXT PRIMARY KEY, round INTEGER, current_index INTEGER, active INTEGER, entries TEXT, updated_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS activity_logs (\n id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT, broadcaster_id TEXT, action TEXT, detail TEXT, created_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS channel_settings (\n broadcaster_id TEXT PRIMARY KEY, enabled INTEGER NOT NULL DEFAULT 1, updated_at INTEGER\n )`,\n );\n // Open-stall merchant: off by default per channel. next_post_at is the\n // randomized due time (ms epoch) for the next ad; the merchant cron\n // trigger polls this rather than posting on every tick.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS merchant_settings (\n broadcaster_id TEXT PRIMARY KEY, enabled INTEGER NOT NULL DEFAULT 0, next_post_at INTEGER, updated_at INTEGER\n )`,\n );\n // Single-row rolling status for the merchant cron trigger — lets an\n // operator (or an external monitor) check \"is the merchant actually\n // ticking, and did the last run have errors\" without digging through raw\n // monitor_events. Written by merchant.cron.ts on every run.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS merchant_cron_status (\n id INTEGER PRIMARY KEY,\n last_run_at INTEGER,\n last_channels_due INTEGER DEFAULT 0,\n last_posts_ok INTEGER DEFAULT 0,\n last_posts_failed INTEGER DEFAULT 0,\n last_error TEXT,\n last_error_at INTEGER,\n last_success_at INTEGER,\n total_runs INTEGER DEFAULT 0,\n total_posts_ok INTEGER DEFAULT 0,\n total_posts_failed INTEGER DEFAULT 0\n )`,\n );\n // Chronicle: randomly quotes a plain chat message back with a D&D-flavored\n // reply. Off by default per channel; toggled with !chronicle.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS chronicle_settings (\n broadcaster_id TEXT PRIMARY KEY, enabled INTEGER NOT NULL DEFAULT 0, updated_at INTEGER\n )`,\n );\n // Web dashboard login sessions (/dashboard). A viewer logs in with Twitch\n // (scope user:read:moderated_channels) so we can prove they're a\n // moderator/broadcaster of a channel before letting them flip module\n // switches. session_id is an opaque cookie value; the Twitch user tokens\n // live server-side only, never in the cookie itself.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS dashboard_sessions (\n session_id TEXT PRIMARY KEY, user_id TEXT NOT NULL, login TEXT, display_name TEXT,\n access_token TEXT NOT NULL, refresh_token TEXT, token_expires_at INTEGER NOT NULL,\n created_at INTEGER NOT NULL, last_seen_at INTEGER NOT NULL\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS duel_challenges (\n broadcaster_id TEXT, challenger TEXT, defender TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, challenger, defender)\n )`,\n );\n try {\n await sqlite.execute(`ALTER TABLE duel_challenges ADD COLUMN mode TEXT DEFAULT 'auto'`);\n } catch (_) {\n /* column already exists */\n }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS duels (\n broadcaster_id TEXT PRIMARY KEY, challenger TEXT, defender TEXT, current_turn TEXT,\n challenger_hp INTEGER, defender_hp INTEGER, active INTEGER, updated_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS parties (\n broadcaster_id TEXT, party_name TEXT, owner TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, party_name)\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_members (\n broadcaster_id TEXT, party_name TEXT, username TEXT, joined_at INTEGER,\n PRIMARY KEY (broadcaster_id, party_name, username)\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_invites (\n broadcaster_id TEXT, party_name TEXT, target TEXT, inviter TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, party_name, target)\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_duel_challenges (\n broadcaster_id TEXT, challenger_party TEXT, defender_party TEXT,\n challenger_owner TEXT, defender_owner TEXT, created_at INTEGER,\n PRIMARY KEY (broadcaster_id, challenger_party, defender_party)\n )`,\n );\n try {\n await sqlite.execute(`ALTER TABLE party_duel_challenges ADD COLUMN mode TEXT DEFAULT 'auto'`);\n } catch (_) {\n /* column already exists */\n }\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_duels (\n broadcaster_id TEXT PRIMARY KEY, challenger_party TEXT, defender_party TEXT,\n current_side TEXT, current_index INTEGER, challenger_members TEXT, defender_members TEXT,\n challenger_hp TEXT, defender_hp TEXT, active INTEGER, updated_at INTEGER\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS monster_duels (\n broadcaster_id TEXT PRIMARY KEY, player TEXT, monster_name TEXT, monster_cr TEXT,\n monster_ac INTEGER, monster_hp INTEGER, monster_hp_max INTEGER, monster_attack INTEGER,\n monster_damage_die INTEGER, monster_damage_bonus INTEGER, current_turn TEXT, active INTEGER, updated_at INTEGER,\n player_hp INTEGER\n )`,\n );\n // player_hp was added after the original table shipped — back-fill it for\n // channels whose monster_duels table predates this column, or every\n // !dndduel attack past the first exchange throws on the UPDATE below and\n // the bot goes silent.\n try { await sqlite.execute(`ALTER TABLE monster_duels ADD COLUMN player_hp INTEGER`); } catch (_) {}\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS party_monster_duels (\n broadcaster_id TEXT PRIMARY KEY,\n party_name TEXT,\n members TEXT,\n member_hp TEXT,\n current_index INTEGER,\n monster_name TEXT,\n monster_cr TEXT,\n monster_ac INTEGER,\n monster_hp INTEGER,\n monster_hp_max INTEGER,\n monster_attack INTEGER,\n monster_damage_die INTEGER,\n monster_damage_bonus INTEGER,\n active INTEGER,\n updated_at INTEGER\n )`,\n );\n // Custom commands (!dndbot add/edit/remove/cooldown/list) and passive\n // keyword triggers (!trigger), both authored from Twitch chat by the\n // broadcaster/mods — see customcommands.ts.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS custom_commands (\n broadcaster_id TEXT, name TEXT, response TEXT, created_by TEXT,\n created_at INTEGER, updated_at INTEGER, uses INTEGER NOT NULL DEFAULT 0,\n cooldown_ms INTEGER NOT NULL DEFAULT ${DEFAULT_CUSTOM_COMMAND_COOLDOWN_MS}, last_used_at INTEGER NOT NULL DEFAULT 0,\n PRIMARY KEY (broadcaster_id, name)\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS custom_triggers (\n broadcaster_id TEXT, keyword TEXT, response TEXT, created_by TEXT,\n created_at INTEGER, updated_at INTEGER, uses INTEGER NOT NULL DEFAULT 0,\n cooldown_ms INTEGER NOT NULL DEFAULT ${DEFAULT_CUSTOM_TRIGGER_COOLDOWN_MS}, last_used_at INTEGER NOT NULL DEFAULT 0,\n PRIMARY KEY (broadcaster_id, keyword)\n )`,\n );\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_custom_commands_channel ON custom_commands(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_custom_triggers_channel ON custom_triggers(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_activity_logs_channel_id ON activity_logs(broadcaster_id,id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_activity_logs_created ON activity_logs(created_at)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_channel_characters_channel ON channel_characters(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_party_members_channel ON party_members(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_parties_channel ON parties(broadcaster_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_activity_logs_username_channel ON activity_logs(broadcaster_id,username)`);\n}\n\nexport async function getPartyMonsterDuel(broadcasterId: string) {\n const res = await sqlite.execute(\n \"SELECT * FROM party_monster_duels WHERE broadcaster_id = ? AND active = 1\",\n [broadcasterId],\n );\n if (!res.rows.length) return null;\n const r = res.rows[0];\n return {\n ...r,\n current_index: Number(r.current_index),\n members: JSON.parse(r.members || \"[]\") as string[],\n member_hp: JSON.parse(r.member_hp || \"{}\") as Record,\n };\n}\n\nexport function rowToCharacter(r: any): Character {\n return {\n username: r.username,\n race: r.race,\n subrace: r.subrace,\n cls: r.class,\n level: r.level,\n xp: Number(r.xp ?? 0),\n scores: { STR: r.str, DEX: r.dex, CON: r.con, INT: r.int, WIS: r.wis, CHA: r.cha },\n speed: r.speed,\n hpMax: r.hp_max,\n hpCurrent: r.hp_current,\n proficiency: r.proficiency,\n traits: JSON.parse(r.traits || \"[]\"),\n spells: JSON.parse(r.spells || \"[]\"),\n items: JSON.parse(r.items || \"[]\"),\n feats: JSON.parse(r.feats || \"[]\"),\n abilities: JSON.parse(r.abilities || \"[]\"),\n };\n}\n\nexport async function getCharacter(username: string, broadcasterId: string) {\n const res = await sqlite.execute(\n \"SELECT * FROM characters WHERE broadcaster_id = ? AND username = ?\",\n [broadcasterId, username],\n );\n if (!res.rows.length) return null;\n await sqlite.execute(\n \"UPDATE channel_characters SET updated_at = ? WHERE broadcaster_id = ? AND username = ?\",\n [Date.now(), broadcasterId, username],\n );\n return rowToCharacter(res.rows[0]);\n}\n\nexport async function saveCharacter(c: Character, broadcasterId: string) {\n const existing = await sqlite.execute(\n \"SELECT 1 FROM channel_characters WHERE broadcaster_id = ? AND username = ?\",\n [broadcasterId, c.username],\n );\n if (!existing.rows.length) {\n const max = Math.max(1, Number(Deno.env.get(\"MAX_CHARACTERS_PER_CHANNEL\") ?? \"500\"));\n const count = await sqlite.execute(\"SELECT COUNT(*) AS count FROM channel_characters WHERE broadcaster_id = ?\", [broadcasterId]);\n if (Number(count.rows[0]?.count ?? 0) >= max) throw new Error(`Channel character cap reached (${max}).`);\n }\n const now = Date.now();\n await sqlite.execute(\n \"INSERT OR IGNORE INTO channel_characters (broadcaster_id,username,created_at,updated_at) VALUES (?,?,?,?)\",\n [broadcasterId, c.username, now, now],\n );\n await sqlite.execute(\"UPDATE channel_characters SET updated_at = ? WHERE broadcaster_id = ? AND username = ?\", [now, broadcasterId, c.username]);\n await sqlite.execute(\n `INSERT OR REPLACE INTO characters\n (broadcaster_id,username,race,subrace,class,level,xp,str,dex,con,int,wis,cha,speed,hp_max,hp_current,proficiency,traits,spells,items,feats,abilities)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n [\n broadcasterId,\n c.username,\n c.race,\n c.subrace,\n c.cls,\n c.level,\n c.xp ?? 0,\n c.scores.STR,\n c.scores.DEX,\n c.scores.CON,\n c.scores.INT,\n c.scores.WIS,\n c.scores.CHA,\n c.speed,\n c.hpMax,\n c.hpCurrent,\n c.proficiency,\n JSON.stringify(c.traits),\n JSON.stringify(c.spells),\n JSON.stringify(c.items),\n JSON.stringify(c.feats),\n JSON.stringify(c.abilities),\n ],\n );\n}\n\nexport async function adjustHp(username: string, delta: number, broadcasterId: string) {\n const c = await getCharacter(username, broadcasterId);\n if (!c) return null;\n c.hpCurrent = Math.max(0, Math.min(c.hpMax, c.hpCurrent + delta));\n await sqlite.execute(\"UPDATE characters SET hp_current = ? WHERE broadcaster_id = ? AND username = ?\", [c.hpCurrent, broadcasterId, username]);\n return c;\n}\n\nexport async function backupCharacter(username: string, broadcasterId: string) {\n const c = await getCharacter(username, broadcasterId);\n if (!c) return false;\n await sqlite.execute(\n `INSERT OR REPLACE INTO character_backups\n (broadcaster_id,username,race,subrace,class,level,xp,str,dex,con,int,wis,cha,speed,hp_max,hp_current,proficiency,traits,spells,items,feats,abilities)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n [\n broadcasterId,\n c.username,\n c.race,\n c.subrace,\n c.cls,\n c.level,\n c.xp ?? 0,\n c.scores.STR,\n c.scores.DEX,\n c.scores.CON,\n c.scores.INT,\n c.scores.WIS,\n c.scores.CHA,\n c.speed,\n c.hpMax,\n c.hpCurrent,\n c.proficiency,\n JSON.stringify(c.traits),\n JSON.stringify(c.spells),\n JSON.stringify(c.items),\n JSON.stringify(c.feats),\n JSON.stringify(c.abilities),\n ],\n );\n return true;\n}\n\nexport async function loadBackup(username: string, broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM character_backups WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n if (!res.rows.length) return null;\n const c = rowToCharacter(res.rows[0]);\n await saveCharacter(c, broadcasterId);\n return c;\n}\n\nexport async function resetCharacter(username: string, broadcasterId: string) {\n await sqlite.execute(\"DELETE FROM channel_characters WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n await sqlite.execute(\"DELETE FROM characters WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n await sqlite.execute(\"DELETE FROM character_backups WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n}\n\nexport async function getCreationSession(username: string, broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM creation_sessions WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n if (!res.rows.length) return null;\n const r = res.rows[0];\n return {\n username,\n broadcasterId,\n step: r.step,\n race: r.race,\n subrace: r.subrace,\n cls: r.class,\n scores: r.scores ? JSON.parse(r.scores) : null,\n subclass: r.subclass ?? null,\n background: r.background ?? null,\n alignment: r.alignment ?? null,\n hook: r.hook ?? null,\n targetUser: r.target_user ?? null,\n };\n}\n\nexport async function saveCreationSession(s: any, broadcasterId: string) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO creation_sessions (broadcaster_id,username,step,race,subrace,class,scores,subclass,background,alignment,hook,target_user,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)\",\n [\n broadcasterId,\n s.username,\n s.step,\n s.race ?? null,\n s.subrace ?? null,\n s.cls ?? null,\n s.scores ? JSON.stringify(s.scores) : null,\n s.subclass ?? null,\n s.background ?? null,\n s.alignment ?? null,\n s.hook ?? null,\n s.targetUser ?? null,\n Date.now(),\n ],\n );\n}\n\nexport async function clearCreationSession(username: string, broadcasterId: string) {\n await sqlite.execute(\"DELETE FROM creation_sessions WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n}\n\nexport async function getConnections() {\n const res = await sqlite.execute(\"SELECT display_name, login FROM broadcasters WHERE connected = 1 ORDER BY connected_at ASC\");\n return res.rows.map((r: any) => r.display_name || r.login);\n}\n\nexport async function isChannelBlocked(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT 1 FROM channel_blocks WHERE broadcaster_id = ?\", [broadcasterId]);\n return res.rows.length > 0;\n}\n\nexport async function blockChannel(broadcasterId: string, reason = \"operator block\") {\n await sqlite.execute(\"INSERT OR REPLACE INTO channel_blocks (broadcaster_id,reason,created_at,updated_at) VALUES (?,?,COALESCE((SELECT created_at FROM channel_blocks WHERE broadcaster_id = ?),?),?)\", [broadcasterId, reason.slice(0,240), broadcasterId, Date.now(), Date.now()]);\n await setChannelEnabled(broadcasterId, false);\n}\n\nexport async function unblockChannel(broadcasterId: string) {\n await sqlite.execute(\"DELETE FROM channel_blocks WHERE broadcaster_id = ?\", [broadcasterId]);\n await setChannelEnabled(broadcasterId, true);\n}\n\nexport async function markBroadcasterDisconnected(broadcasterId: string, reason: string, subscriptionId?: string) {\n await sqlite.execute(\n \"UPDATE broadcasters SET connected = 0, disconnected_at = ?, disconnect_reason = ?, subscription_id = COALESCE(?, subscription_id) WHERE broadcaster_id = ?\",\n [Date.now(), reason.slice(0, 240), subscriptionId ?? null, broadcasterId],\n );\n}\n\nexport async function getBroadcaster(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM broadcasters WHERE broadcaster_id = ?\", [broadcasterId]);\n return res.rows.length ? res.rows[0] : null;\n}\n\n/** Bulk-fetch connected broadcasters from a candidate id list (e.g. \"channels\n * this Twitch user moderates or owns\") — used by the /dashboard route to\n * intersect a viewer's Twitch moderator status with channels GuildScribe\n * actually knows about. Returns only rows that are currently connected. */\nexport async function getConnectedBroadcastersByIds(broadcasterIds: string[]) {\n const ids = [...new Set(broadcasterIds)].filter(Boolean);\n if (!ids.length) return [];\n const placeholders = ids.map(() => \"?\").join(\",\");\n const res = await sqlite.execute(\n `SELECT * FROM broadcasters WHERE connected = 1 AND broadcaster_id IN (${placeholders})`,\n ids,\n );\n return res.rows;\n}\n\n// \"kind\" is a short label (\"sub\" for channel.subscribe, \"resub\" for\n// channel.subscription.message) distinguishing the two extra subscriptions\n// created alongside the main chat-message one in broadcasters.subscription_id.\nexport async function saveExtraEventSubSubscription(broadcasterId: string, kind: string, subscriptionId: string) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO eventsub_extra_subscriptions (broadcaster_id,kind,subscription_id,created_at) VALUES (?,?,?,?)\",\n [broadcasterId, kind, subscriptionId, Date.now()],\n );\n}\n\nexport async function getExtraEventSubSubscriptions(broadcasterId: string) {\n const res = await sqlite.execute(\n \"SELECT kind, subscription_id FROM eventsub_extra_subscriptions WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n return res.rows as Array<{ kind: string; subscription_id: string }>;\n}\n\nexport async function deleteExtraEventSubSubscriptions(broadcasterId: string) {\n await sqlite.execute(\"DELETE FROM eventsub_extra_subscriptions WHERE broadcaster_id = ?\", [broadcasterId]);\n}\n\nexport async function purgeChannelData(broadcasterId: string) {\n for (const table of [\n \"activity_logs\",\n \"creation_sessions\",\n \"encounters\",\n \"duel_challenges\",\n \"duels\",\n \"parties\",\n \"party_members\",\n \"party_invites\",\n \"party_duel_challenges\",\n \"party_duels\",\n \"monster_duels\",\n \"party_monster_duels\",\n \"channel_settings\",\n \"merchant_settings\",\n \"chronicle_settings\",\n \"chronicle_activity\",\n \"channel_characters\",\n \"characters\",\n \"character_backups\",\n \"eventsub_extra_subscriptions\",\n \"maps\",\n \"map_cells\",\n \"map_tokens\",\n ]) {\n await sqlite.execute(`DELETE FROM ${table} WHERE broadcaster_id = ?`, [broadcasterId]);\n }\n await sqlite.execute(\"DELETE FROM broadcasters WHERE broadcaster_id = ?\", [broadcasterId]);\n}\n\nexport async function disconnectBroadcasterData(broadcasterId: string, purge = false) {\n if (purge) await purgeChannelData(broadcasterId);\n else {\n await sqlite.execute(\"DELETE FROM channel_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n await sqlite.execute(\"DELETE FROM merchant_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n await sqlite.execute(\"DELETE FROM chronicle_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n await sqlite.execute(\"DELETE FROM eventsub_extra_subscriptions WHERE broadcaster_id = ?\", [broadcasterId]);\n await sqlite.execute(\"DELETE FROM broadcasters WHERE broadcaster_id = ?\", [broadcasterId]);\n }\n}\n\nexport async function isChannelEnabled(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT enabled FROM channel_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n return !res.rows.length || Number(res.rows[0].enabled) === 1;\n}\n\nexport async function setChannelEnabled(broadcasterId: string, enabled: boolean) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO channel_settings (broadcaster_id, enabled, updated_at) VALUES (?,?,?)\",\n [broadcasterId, enabled ? 1 : 0, Date.now()],\n );\n}\n\nexport async function isMerchantEnabled(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT enabled FROM merchant_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n return res.rows.length > 0 && Number(res.rows[0].enabled) === 1;\n}\n\n/** Toggle the open-stall merchant. `nextPostAt` should be a freshly randomized\n * due time (ms epoch) when enabling; pass null when disabling. */\nexport async function setMerchantEnabled(broadcasterId: string, enabled: boolean, nextPostAt: number | null) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO merchant_settings (broadcaster_id, enabled, next_post_at, updated_at) VALUES (?,?,?,?)\",\n [broadcasterId, enabled ? 1 : 0, enabled ? nextPostAt : null, Date.now()],\n );\n}\n\nexport async function isChronicleEnabled(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT enabled FROM chronicle_settings WHERE broadcaster_id = ?\", [broadcasterId]);\n return res.rows.length > 0 && Number(res.rows[0].enabled) === 1;\n}\n\n/** Toggle the chronicle's random chat-quoting. Off by default. */\nexport async function setChronicleEnabled(broadcasterId: string, enabled: boolean) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO chronicle_settings (broadcaster_id, enabled, updated_at) VALUES (?,?,?)\",\n [broadcasterId, enabled ? 1 : 0, Date.now()],\n );\n}\n\n/** Create a /dashboard login session after a successful Twitch OAuth\n * exchange. session_id is the opaque value stored in the viewer's cookie. */\nexport async function createDashboardSession(opts: {\n sessionId: string;\n userId: string;\n login: string;\n displayName: string;\n accessToken: string;\n refreshToken: string | null;\n tokenExpiresAt: number;\n}) {\n const now = Date.now();\n await sqlite.execute(\n `INSERT OR REPLACE INTO dashboard_sessions\n (session_id, user_id, login, display_name, access_token, refresh_token, token_expires_at, created_at, last_seen_at)\n VALUES (?,?,?,?,?,?,?,?,?)`,\n [\n opts.sessionId,\n opts.userId,\n opts.login,\n opts.displayName,\n opts.accessToken,\n opts.refreshToken,\n opts.tokenExpiresAt,\n now,\n now,\n ],\n );\n}\n\nexport async function getDashboardSession(sessionId: string) {\n const res = await sqlite.execute(\"SELECT * FROM dashboard_sessions WHERE session_id = ?\", [sessionId]);\n return res.rows.length ? res.rows[0] : null;\n}\n\n/** Called after a token refresh so the next request reuses the new access\n * token instead of refreshing again. */\nexport async function updateDashboardSessionToken(\n sessionId: string,\n accessToken: string,\n refreshToken: string | null,\n tokenExpiresAt: number,\n) {\n await sqlite.execute(\n \"UPDATE dashboard_sessions SET access_token = ?, refresh_token = ?, token_expires_at = ?, last_seen_at = ? WHERE session_id = ?\",\n [accessToken, refreshToken, tokenExpiresAt, Date.now(), sessionId],\n );\n}\n\nexport async function deleteDashboardSession(sessionId: string) {\n await sqlite.execute(\"DELETE FROM dashboard_sessions WHERE session_id = ?\", [sessionId]);\n}\n\n/** Per-channel cooldown gate for chronicle quotes, mirrors\n * checkGoodnightCooldown: returns false (and leaves the timestamp alone) if\n * still cooling down, otherwise stamps \"now\" and returns true. */\nexport async function checkChronicleCooldown(broadcasterId: string, cooldownMs: number) {\n const now = Date.now();\n const res = await sqlite.execute(\"SELECT last_at FROM chronicle_cooldowns WHERE broadcaster_id = ?\", [broadcasterId]);\n const last = Number(res.rows[0]?.last_at ?? 0);\n if (now - last < cooldownMs) return false;\n await sqlite.execute(\"INSERT OR REPLACE INTO chronicle_cooldowns (broadcaster_id,last_at) VALUES (?,?)\", [broadcasterId, now]);\n return true;\n}\n\n/** Increments the running count of chat messages seen since the chronicle's\n * last quote in this channel — every message counts, including bot\n * accounts, so a bot-heavy but otherwise quiet channel still builds up\n * enough activity for a quote to eventually fire (bots just never get\n * selected as the one quoted). Returns the updated count. */\nexport async function bumpChronicleMessageCount(broadcasterId: string): Promise {\n await sqlite.execute(\n \"INSERT OR IGNORE INTO chronicle_activity (broadcaster_id, message_count) VALUES (?, 0)\",\n [broadcasterId],\n );\n await sqlite.execute(\n \"UPDATE chronicle_activity SET message_count = message_count + 1 WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n const res = await sqlite.execute(\"SELECT message_count FROM chronicle_activity WHERE broadcaster_id = ?\", [broadcasterId]);\n return Number(res.rows[0]?.message_count ?? 0);\n}\n\n/** Resets a channel's chronicle message-activity count to 0, called right\n * after a quote actually posts. */\nexport async function resetChronicleMessageCount(broadcasterId: string) {\n await sqlite.execute(\"UPDATE chronicle_activity SET message_count = 0 WHERE broadcaster_id = ?\", [broadcasterId]);\n}\n\n/** Channels whose merchant is enabled, due for a post, connected, not\n * operator-blocked, and not otherwise disabled via !dndbot off. */\nexport async function getDueMerchantChannels(now: number): Promise {\n const res = await sqlite.execute(\n `SELECT m.broadcaster_id AS broadcaster_id\n FROM merchant_settings m\n JOIN broadcasters b ON b.broadcaster_id = m.broadcaster_id AND b.connected = 1\n LEFT JOIN channel_settings cs ON cs.broadcaster_id = m.broadcaster_id\n LEFT JOIN channel_blocks cb ON cb.broadcaster_id = m.broadcaster_id\n WHERE m.enabled = 1\n AND m.next_post_at IS NOT NULL AND m.next_post_at <= ?\n AND cb.broadcaster_id IS NULL\n AND (cs.enabled IS NULL OR cs.enabled = 1)`,\n [now],\n );\n return res.rows.map((r: any) => String(r.broadcaster_id));\n}\n\nexport async function rescheduleMerchant(broadcasterId: string, nextPostAt: number) {\n await sqlite.execute(\n \"UPDATE merchant_settings SET next_post_at = ?, updated_at = ? WHERE broadcaster_id = ?\",\n [nextPostAt, Date.now(), broadcasterId],\n );\n}\n\n/** Records the outcome of one merchant.cron.ts tick. `errorDetail` should be\n * the most recent failure's message, or null if the tick had no failures —\n * on a clean tick the previously-recorded error (if any) is preserved so a\n * status check still shows the last time something actually went wrong. */\nexport async function recordMerchantCronRun(\n now: number,\n channelsDue: number,\n postsOk: number,\n postsFailed: number,\n errorDetail: string | null,\n) {\n await sqlite.execute(\n `INSERT OR REPLACE INTO merchant_cron_status\n (id, last_run_at, last_channels_due, last_posts_ok, last_posts_failed,\n last_error, last_error_at, last_success_at,\n total_runs, total_posts_ok, total_posts_failed)\n VALUES (\n 1, ?, ?, ?, ?,\n CASE WHEN ? > 0 THEN ? ELSE (SELECT last_error FROM merchant_cron_status WHERE id = 1) END,\n CASE WHEN ? > 0 THEN ? ELSE (SELECT last_error_at FROM merchant_cron_status WHERE id = 1) END,\n CASE WHEN ? > 0 THEN ? ELSE (SELECT last_success_at FROM merchant_cron_status WHERE id = 1) END,\n COALESCE((SELECT total_runs FROM merchant_cron_status WHERE id = 1), 0) + 1,\n COALESCE((SELECT total_posts_ok FROM merchant_cron_status WHERE id = 1), 0) + ?,\n COALESCE((SELECT total_posts_failed FROM merchant_cron_status WHERE id = 1), 0) + ?\n )`,\n [\n now, channelsDue, postsOk, postsFailed,\n postsFailed, errorDetail ? errorDetail.slice(0, 300) : null,\n postsFailed, now,\n postsOk, now,\n postsOk, postsFailed,\n ],\n );\n}\n\nexport async function getMerchantCronStatus() {\n const res = await sqlite.execute(\"SELECT * FROM merchant_cron_status WHERE id = 1\");\n return res.rows[0] ?? null;\n}\n\n/** Per-channel merchant diagnostic view: settings joined with connection,\n * block, and bot-enable state, so an operator can see at a glance *why* a\n * given channel's merchant isn't posting (never turned on, channel\n * disconnected, blocked, bot disabled, or just not due yet). Ordered by\n * next_post_at so the soonest-due channels surface first. */\nexport async function getMerchantOverview() {\n const res = await sqlite.execute(\n `SELECT\n m.broadcaster_id AS broadcaster_id,\n b.login AS login,\n b.display_name AS display_name,\n m.enabled AS merchant_enabled,\n m.next_post_at AS next_post_at,\n m.updated_at AS merchant_updated_at,\n b.connected AS connected,\n CASE WHEN cb.broadcaster_id IS NULL THEN 0 ELSE 1 END AS blocked,\n cb.reason AS block_reason,\n COALESCE(cs.enabled, 1) AS bot_enabled\n FROM merchant_settings m\n LEFT JOIN broadcasters b ON b.broadcaster_id = m.broadcaster_id\n LEFT JOIN channel_blocks cb ON cb.broadcaster_id = m.broadcaster_id\n LEFT JOIN channel_settings cs ON cs.broadcaster_id = m.broadcaster_id\n ORDER BY (m.next_post_at IS NULL), m.next_post_at ASC`,\n );\n return res.rows;\n}\n\n/** Recent monitor_events, optionally filtered to kinds starting with a\n * prefix (e.g. \"merchant\" to see only merchant-related entries). */\nexport async function getMonitorEvents(kindPrefix?: string, limit = 50) {\n const cappedLimit = Math.min(Math.max(Math.floor(limit) || 50, 1), 200);\n if (kindPrefix) {\n const res = await sqlite.execute(\n \"SELECT kind, detail, created_at FROM monitor_events WHERE kind LIKE ? ORDER BY id DESC LIMIT ?\",\n [`${kindPrefix}%`, cappedLimit],\n );\n return res.rows;\n }\n const res = await sqlite.execute(\n \"SELECT kind, detail, created_at FROM monitor_events ORDER BY id DESC LIMIT ?\",\n [cappedLimit],\n );\n return res.rows;\n}\n\nexport async function getDuel(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM duels WHERE broadcaster_id = ? AND active = 1\", [broadcasterId]);\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function getMonsterDuel(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM monster_duels WHERE broadcaster_id = ? AND active = 1\", [\n broadcasterId,\n ]);\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function getParty(broadcasterId: string, partyName: string) {\n const res = await sqlite.execute(\"SELECT * FROM parties WHERE broadcaster_id = ? AND party_name = ?\", [\n broadcasterId,\n partyName.toLowerCase(),\n ]);\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function getPartyMembers(broadcasterId: string, partyName: string) {\n const res = await sqlite.execute(\n \"SELECT username FROM party_members WHERE broadcaster_id = ? AND party_name = ? ORDER BY joined_at ASC\",\n [broadcasterId, partyName.toLowerCase()],\n );\n return res.rows.map((r: any) => String(r.username));\n}\n\n// A party invite must be explicitly accepted by the target before they're\n// added to party_members — see !party invite / accept / decline.\nexport async function createPartyInvite(\n broadcasterId: string,\n partyName: string,\n target: string,\n inviter: string,\n) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO party_invites (broadcaster_id,party_name,target,inviter,created_at) VALUES (?,?,?,?,?)\",\n [broadcasterId, partyName, target, inviter, Date.now()],\n );\n}\n\nexport async function getPartyInvites(broadcasterId: string, target: string) {\n const res = await sqlite.execute(\n \"SELECT * FROM party_invites WHERE broadcaster_id = ? AND target = ? ORDER BY created_at DESC\",\n [broadcasterId, target],\n );\n return res.rows;\n}\n\nexport async function getPartyInvite(broadcasterId: string, target: string, partyName: string) {\n const res = await sqlite.execute(\n \"SELECT * FROM party_invites WHERE broadcaster_id = ? AND target = ? AND party_name = ?\",\n [broadcasterId, target, partyName],\n );\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function deletePartyInvite(broadcasterId: string, partyName: string, target: string) {\n await sqlite.execute(\"DELETE FROM party_invites WHERE broadcaster_id = ? AND party_name = ? AND target = ?\", [\n broadcasterId,\n partyName,\n target,\n ]);\n}\n\nexport async function getPartyDuel(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM party_duels WHERE broadcaster_id = ? AND active = 1\", [\n broadcasterId,\n ]);\n if (!res.rows.length) return null;\n const r = res.rows[0];\n return {\n ...r,\n current_index: Number(r.current_index),\n challenger_members: JSON.parse(r.challenger_members || \"[]\"),\n defender_members: JSON.parse(r.defender_members || \"[]\"),\n challenger_hp: JSON.parse(r.challenger_hp || \"{}\"),\n defender_hp: JSON.parse(r.defender_hp || \"{}\"),\n };\n}\n\nexport async function getEncounter(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM encounters WHERE broadcaster_id = ?\", [broadcasterId]);\n if (!res.rows.length) return null;\n const r = res.rows[0];\n return {\n broadcasterId,\n round: Number(r.round),\n currentIndex: Number(r.current_index),\n active: Boolean(r.active),\n entries: JSON.parse(r.entries || \"[]\") as Array<{ name: string; initiative: number; dex?: number; rolled?: boolean }>,\n };\n}\n\nexport async function saveEncounter(e: any) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO encounters (broadcaster_id,round,current_index,active,entries,updated_at) VALUES (?,?,?,?,?,?)\",\n [e.broadcasterId, e.round, e.currentIndex, e.active ? 1 : 0, JSON.stringify(e.entries), Date.now()],\n );\n}\n\nexport async function recordActivity(username: string, broadcasterId: string, action: string, detail: string) {\n await sqlite.execute(\n \"INSERT INTO activity_logs (username,broadcaster_id,action,detail,created_at) VALUES (?,?,?,?,?)\",\n [username, broadcasterId, action.slice(0, 40), detail.replace(/\\s+/g, \" \").trim().slice(0, 220), Date.now()],\n );\n // Retain at most 5,000 rows per channel, plus a hard 90-day privacy window.\n await sqlite.execute(\n `DELETE FROM activity_logs\n WHERE created_at < ?\n OR (broadcaster_id = ? AND id NOT IN (SELECT id FROM activity_logs WHERE broadcaster_id = ? ORDER BY id DESC LIMIT 5000))`,\n [Date.now() - 90 * 24 * 60 * 60 * 1000, broadcasterId, broadcasterId],\n );\n}\n\nexport async function getRecentLogs(broadcasterId?: string, limit = 200) {\n const safeLimit = Math.max(1, Math.min(500, Math.floor(limit)));\n const query = broadcasterId\n ? `SELECT username,broadcaster_id,action,detail,created_at FROM activity_logs WHERE broadcaster_id = ? ORDER BY id DESC LIMIT ${safeLimit}`\n : `SELECT username,broadcaster_id,action,detail,created_at FROM activity_logs ORDER BY id DESC LIMIT ${safeLimit}`;\n const res = await sqlite.execute(query, broadcasterId ? [broadcasterId] : []);\n return res.rows;\n}\n\n/** Self-healing safety net for schema drift: ensureTables() already runs a\n * best-effort ALTER TABLE ADD COLUMN for columns added after a table\n * originally shipped (see the monster_duels/player_hp comment above), but\n * that migration hasn't proven 100% reliable in practice — a write\n * referencing the column can still occasionally hit \"no such column\" (seen\n * with monster_duels/player_hp: the bot goes silent mid-duel with an\n * unhandled_error instead of replying). Rather than track down exactly why\n * that particular ALTER isn't always landing in time, this wraps the\n * fragile write itself: run it, and if it fails specifically because the\n * named column is missing, add the column right here and retry once before\n * giving up. Cheap, idempotent, and fixes the symptom regardless of cause. */\nexport async function withColumnHeal(\n table: string,\n column: string,\n columnDef: string,\n fn: () => Promise,\n): Promise {\n try {\n return await fn();\n } catch (e) {\n if (!String(e).includes(`no such column: ${column}`)) throw e;\n try {\n await sqlite.execute(`ALTER TABLE ${table} ADD COLUMN ${column} ${columnDef}`);\n } catch (_) {\n /* lost a race with another request adding it concurrently — fine,\n fn() below will succeed either way, or throw its real error. */\n }\n return await fn();\n }\n}\n\n/**\n * Distinct usernames who've used a bot command recently in this channel,\n * most-recently-active first. Powers !oracle's random-chatter pick — reuses\n * the existing activity_logs table rather than requiring a live Twitch\n * chatters-list API call (which would need a new OAuth scope + re-auth).\n */\nexport async function getRecentChatters(broadcasterId: string, limit = 50) {\n const safeLimit = Math.max(1, Math.min(200, Math.floor(limit)));\n const res = await sqlite.execute(\n `SELECT username, MAX(created_at) AS last_seen\n FROM (SELECT username, created_at FROM activity_logs WHERE broadcaster_id = ? ORDER BY id DESC LIMIT 500) AS recent\n GROUP BY username\n ORDER BY last_seen DESC\n LIMIT ${safeLimit}`,\n [broadcasterId],\n );\n return res.rows.map((r: any) => String(r.username));\n}\n\nexport { sqlite };\n\nexport async function queueEventSubCancellation(subscriptionId: string, broadcasterId: string, error: string) {\n if (!subscriptionId) return;\n await sqlite.execute(\n `INSERT OR REPLACE INTO pending_eventsub_cancellations (subscription_id,broadcaster_id,attempts,last_error,updated_at)\n VALUES (?, ?, COALESCE((SELECT attempts FROM pending_eventsub_cancellations WHERE subscription_id = ?), 0) + 1, ?, ?)`,\n [subscriptionId, broadcasterId, subscriptionId, error.slice(0, 500), Date.now()],\n );\n}\n\nexport async function getPendingEventSubCancellations(limit = 5) {\n const safeLimit = Math.max(1, Math.min(20, Math.floor(limit)));\n const res = await sqlite.execute(`SELECT * FROM pending_eventsub_cancellations ORDER BY updated_at ASC LIMIT ${safeLimit}`);\n return res.rows;\n}\n\nexport async function clearPendingEventSubCancellation(subscriptionId: string) {\n await sqlite.execute(\"DELETE FROM pending_eventsub_cancellations WHERE subscription_id = ?\", [subscriptionId]);\n}\n\nexport async function claimEventSubMessage(messageId: string, now = Date.now()) {\n if (!messageId) return false;\n try {\n await sqlite.execute(\"INSERT INTO eventsub_messages (message_id,received_at) VALUES (?,?)\", [messageId, now]);\n await sqlite.execute(\"DELETE FROM eventsub_messages WHERE received_at < ?\", [now - 24 * 60 * 60 * 1000]);\n return true;\n } catch (_) {\n return false;\n }\n}\n\nexport async function checkCommandRateLimit(broadcasterId: string, username: string, cooldownMs = 1200) {\n const now = Date.now();\n const res = await sqlite.execute(\"SELECT last_at FROM command_rate_limits WHERE broadcaster_id = ? AND username = ?\", [broadcasterId, username]);\n const last = Number(res.rows[0]?.last_at ?? 0);\n if (now - last < cooldownMs) return false;\n await sqlite.execute(\"INSERT OR REPLACE INTO command_rate_limits (broadcaster_id,username,last_at) VALUES (?,?,?)\", [broadcasterId, username, now]);\n await sqlite.execute(\"DELETE FROM command_rate_limits WHERE last_at < ?\", [now - 10 * 60 * 1000]);\n return true;\n}\n\n// Per-channel cooldown so a wave of \"goodnight\"s from many chatters only\n// gets one bot reply instead of one per person.\nexport async function checkGoodnightCooldown(broadcasterId: string, cooldownMs = 300_000) {\n const now = Date.now();\n const res = await sqlite.execute(\"SELECT last_at FROM goodnight_cooldowns WHERE broadcaster_id = ?\", [broadcasterId]);\n const last = Number(res.rows[0]?.last_at ?? 0);\n if (now - last < cooldownMs) return false;\n await sqlite.execute(\"INSERT OR REPLACE INTO goodnight_cooldowns (broadcaster_id,last_at) VALUES (?,?)\", [broadcasterId, now]);\n return true;\n}\n\nexport async function recordMonitorEvent(kind: string, detail: string) {\n await sqlite.execute(\"INSERT INTO monitor_events (kind,detail,created_at) VALUES (?,?,?)\", [kind.slice(0,80), detail.slice(0,500), Date.now()]);\n await sqlite.execute(\"DELETE FROM monitor_events WHERE id NOT IN (SELECT id FROM monitor_events ORDER BY id DESC LIMIT 1000)\");\n}\n\nexport async function getChannelCounts(broadcasterId: string) {\n const [p, c, l] = await Promise.all([\n sqlite.execute(\"SELECT COUNT(*) AS count FROM parties WHERE broadcaster_id = ?\", [broadcasterId]),\n sqlite.execute(\"SELECT COUNT(*) AS count FROM channel_characters WHERE broadcaster_id = ?\", [broadcasterId]),\n sqlite.execute(\"SELECT COUNT(*) AS count FROM activity_logs WHERE broadcaster_id = ?\", [broadcasterId]),\n ]);\n return { parties: Number(p.rows[0]?.count ?? 0), characters: Number(c.rows[0]?.count ?? 0), logs: Number(l.rows[0]?.count ?? 0) };\n}\n\n// ── Maps ──\n\nexport type MapRow = {\n broadcaster_id: string;\n map_name: string;\n width: number;\n height: number;\n default_terrain: string;\n created_by: string | null;\n created_at: number;\n updated_at: number;\n};\n\nexport type MapToken = {\n username: string;\n display_name: string | null;\n x: number;\n y: number;\n};\n\nexport async function getMap(broadcasterId: string, mapName: string): Promise {\n const res = await sqlite.execute(\"SELECT * FROM maps WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n if (!res.rows.length) return null;\n const r: any = res.rows[0];\n return {\n broadcaster_id: r.broadcaster_id,\n map_name: r.map_name,\n width: Number(r.width),\n height: Number(r.height),\n default_terrain: r.default_terrain,\n created_by: r.created_by,\n created_at: Number(r.created_at),\n updated_at: Number(r.updated_at),\n };\n}\n\nexport async function listMaps(broadcasterId: string): Promise {\n const res = await sqlite.execute(\"SELECT * FROM maps WHERE broadcaster_id = ? ORDER BY map_name ASC\", [broadcasterId]);\n return res.rows.map((r: any) => ({\n broadcaster_id: r.broadcaster_id,\n map_name: r.map_name,\n width: Number(r.width),\n height: Number(r.height),\n default_terrain: r.default_terrain,\n created_by: r.created_by,\n created_at: Number(r.created_at),\n updated_at: Number(r.updated_at),\n }));\n}\n\nexport async function createMap(\n broadcasterId: string,\n mapName: string,\n width: number,\n height: number,\n createdBy: string,\n) {\n const maxMaps = Math.max(1, Number(Deno.env.get(\"MAX_MAPS_PER_CHANNEL\") ?? \"25\"));\n const count = await sqlite.execute(\"SELECT COUNT(*) AS count FROM maps WHERE broadcaster_id = ?\", [broadcasterId]);\n if (Number(count.rows[0]?.count ?? 0) >= maxMaps) throw new Error(`Channel map cap reached (${maxMaps}).`);\n const now = Date.now();\n await sqlite.execute(\n \"INSERT INTO maps (broadcaster_id,map_name,width,height,default_terrain,created_by,created_at,updated_at) VALUES (?,?,?,?,?,?,?,?)\",\n [broadcasterId, mapName, width, height, \"grass\", createdBy, now, now],\n );\n}\n\nexport async function deleteMap(broadcasterId: string, mapName: string) {\n await sqlite.execute(\"DELETE FROM maps WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n await sqlite.execute(\"DELETE FROM map_cells WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n await sqlite.execute(\"DELETE FROM map_tokens WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n}\n\nasync function touchMap(broadcasterId: string, mapName: string) {\n await sqlite.execute(\"UPDATE maps SET updated_at = ? WHERE broadcaster_id = ? AND map_name = ?\", [Date.now(), broadcasterId, mapName]);\n}\n\nexport async function getMapCells(broadcasterId: string, mapName: string): Promise> {\n const res = await sqlite.execute(\"SELECT x,y,terrain FROM map_cells WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n const out: Record = {};\n for (const r of res.rows as any[]) out[`${r.x},${r.y}`] = r.terrain;\n return out;\n}\n\nexport async function setMapCell(broadcasterId: string, mapName: string, x: number, y: number, terrain: string) {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO map_cells (broadcaster_id,map_name,x,y,terrain) VALUES (?,?,?,?,?)\",\n [broadcasterId, mapName, x, y, terrain],\n );\n await touchMap(broadcasterId, mapName);\n}\n\nexport async function fillMap(broadcasterId: string, mapName: string, terrain: string) {\n await sqlite.execute(\"DELETE FROM map_cells WHERE broadcaster_id = ? AND map_name = ?\", [broadcasterId, mapName]);\n await sqlite.execute(\"UPDATE maps SET default_terrain = ?, updated_at = ? WHERE broadcaster_id = ? AND map_name = ?\", [\n terrain,\n Date.now(),\n broadcasterId,\n mapName,\n ]);\n}\n\nexport async function getMapTokens(broadcasterId: string, mapName: string): Promise {\n const res = await sqlite.execute(\n \"SELECT username,display_name,x,y FROM map_tokens WHERE broadcaster_id = ? AND map_name = ?\",\n [broadcasterId, mapName],\n );\n return (res.rows as any[]).map((r) => ({ username: r.username, display_name: r.display_name, x: Number(r.x), y: Number(r.y) }));\n}\n\nexport async function getMapToken(broadcasterId: string, mapName: string, username: string): Promise {\n const res = await sqlite.execute(\n \"SELECT username,display_name,x,y FROM map_tokens WHERE broadcaster_id = ? AND map_name = ? AND username = ?\",\n [broadcasterId, mapName, username],\n );\n if (!res.rows.length) return null;\n const r: any = res.rows[0];\n return { username: r.username, display_name: r.display_name, x: Number(r.x), y: Number(r.y) };\n}\n\nexport async function findTokenAt(broadcasterId: string, mapName: string, x: number, y: number): Promise {\n const res = await sqlite.execute(\n \"SELECT username,display_name,x,y FROM map_tokens WHERE broadcaster_id = ? AND map_name = ? AND x = ? AND y = ?\",\n [broadcasterId, mapName, x, y],\n );\n if (!res.rows.length) return null;\n const r: any = res.rows[0];\n return { username: r.username, display_name: r.display_name, x: Number(r.x), y: Number(r.y) };\n}\n\nexport async function upsertMapToken(\n broadcasterId: string,\n mapName: string,\n username: string,\n displayName: string,\n x: number,\n y: number,\n) {\n const now = Date.now();\n await sqlite.execute(\n \"INSERT OR REPLACE INTO map_tokens (broadcaster_id,map_name,username,display_name,x,y,placed_at,updated_at) VALUES (?,?,?,?,?,?,?,?)\",\n [broadcasterId, mapName, username, displayName, x, y, now, now],\n );\n await touchMap(broadcasterId, mapName);\n}\n\nexport async function removeMapToken(broadcasterId: string, mapName: string, username: string) {\n await sqlite.execute(\"DELETE FROM map_tokens WHERE broadcaster_id = ? AND map_name = ? AND username = ?\", [broadcasterId, mapName, username]);\n await touchMap(broadcasterId, mapName);\n}\n\n// ── Custom commands & triggers ──\n\nexport async function countCustomCommands(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT COUNT(*) AS count FROM custom_commands WHERE broadcaster_id = ?\", [broadcasterId]);\n return Number(res.rows[0]?.count ?? 0);\n}\n\nexport async function getCustomCommand(broadcasterId: string, name: string) {\n const res = await sqlite.execute(\"SELECT * FROM custom_commands WHERE broadcaster_id = ? AND name = ?\", [broadcasterId, name]);\n return res.rows.length ? res.rows[0] : null;\n}\n\nexport async function listCustomCommands(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT name, uses FROM custom_commands WHERE broadcaster_id = ? ORDER BY name ASC\", [broadcasterId]);\n return res.rows;\n}\n\nexport async function addCustomCommand(broadcasterId: string, name: string, response: string, createdBy: string) {\n if (await getCustomCommand(broadcasterId, name)) return { ok: false as const, error: \"exists\" as const };\n const max = Math.max(1, Number(Deno.env.get(\"MAX_CUSTOM_COMMANDS_PER_CHANNEL\") ?? \"100\"));\n if ((await countCustomCommands(broadcasterId)) >= max) return { ok: false as const, error: \"cap\" as const, max };\n const now = Date.now();\n await sqlite.execute(\n \"INSERT INTO custom_commands (broadcaster_id,name,response,created_by,created_at,updated_at,uses,cooldown_ms,last_used_at) VALUES (?,?,?,?,?,?,0,?,0)\",\n [broadcasterId, name, response, createdBy, now, now, DEFAULT_CUSTOM_COMMAND_COOLDOWN_MS],\n );\n return { ok: true as const };\n}\n\nexport async function editCustomCommand(broadcasterId: string, name: string, response: string) {\n if (!(await getCustomCommand(broadcasterId, name))) return false;\n await sqlite.execute(\n \"UPDATE custom_commands SET response = ?, updated_at = ? WHERE broadcaster_id = ? AND name = ?\",\n [response, Date.now(), broadcasterId, name],\n );\n return true;\n}\n\nexport async function deleteCustomCommand(broadcasterId: string, name: string) {\n if (!(await getCustomCommand(broadcasterId, name))) return false;\n await sqlite.execute(\"DELETE FROM custom_commands WHERE broadcaster_id = ? AND name = ?\", [broadcasterId, name]);\n return true;\n}\n\nexport async function setCustomCommandCooldown(broadcasterId: string, name: string, cooldownMs: number) {\n if (!(await getCustomCommand(broadcasterId, name))) return false;\n await sqlite.execute(\n \"UPDATE custom_commands SET cooldown_ms = ?, updated_at = ? WHERE broadcaster_id = ? AND name = ?\",\n [cooldownMs, Date.now(), broadcasterId, name],\n );\n return true;\n}\n\n/** Atomically checks cooldown and (if clear) records a use. Returns null if the command doesn't exist. */\nexport async function useCustomCommand(broadcasterId: string, name: string) {\n const row = await getCustomCommand(broadcasterId, name);\n if (!row) return null;\n const now = Date.now();\n const cooldownMs = Number(row.cooldown_ms ?? 0);\n const lastUsedAt = Number(row.last_used_at ?? 0);\n if (cooldownMs > 0 && now - lastUsedAt < cooldownMs) return { row, onCooldown: true as const };\n await sqlite.execute(\n \"UPDATE custom_commands SET uses = uses + 1, last_used_at = ? WHERE broadcaster_id = ? AND name = ?\",\n [now, broadcasterId, name],\n );\n return { row: { ...row, uses: Number(row.uses ?? 0) + 1 }, onCooldown: false as const };\n}\n\nexport async function countCustomTriggers(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT COUNT(*) AS count FROM custom_triggers WHERE broadcaster_id = ?\", [broadcasterId]);\n return Number(res.rows[0]?.count ?? 0);\n}\n\nexport async function getCustomTrigger(broadcasterId: string, keyword: string) {\n const res = await sqlite.execute(\"SELECT * FROM custom_triggers WHERE broadcaster_id = ? AND keyword = ?\", [broadcasterId, keyword]);\n return res.rows.length ? res.rows[0] : null;\n}\n\n// Every plain chat message is matched against this list (see\n// handleTriggerMatch in customcommands.ts), so it's kept small per channel\n// and cached only for the duration of a single request.\nexport async function listCustomTriggers(broadcasterId: string) {\n const res = await sqlite.execute(\"SELECT * FROM custom_triggers WHERE broadcaster_id = ? ORDER BY created_at ASC\", [broadcasterId]);\n return res.rows;\n}\n\nexport async function addCustomTrigger(broadcasterId: string, keyword: string, response: string, createdBy: string) {\n if (await getCustomTrigger(broadcasterId, keyword)) return { ok: false as const, error: \"exists\" as const };\n const max = Math.max(1, Number(Deno.env.get(\"MAX_CUSTOM_TRIGGERS_PER_CHANNEL\") ?? \"50\"));\n if ((await countCustomTriggers(broadcasterId)) >= max) return { ok: false as const, error: \"cap\" as const, max };\n const now = Date.now();\n await sqlite.execute(\n \"INSERT INTO custom_triggers (broadcaster_id,keyword,response,created_by,created_at,updated_at,uses,cooldown_ms,last_used_at) VALUES (?,?,?,?,?,?,0,?,0)\",\n [broadcasterId, keyword, response, createdBy, now, now, DEFAULT_CUSTOM_TRIGGER_COOLDOWN_MS],\n );\n return { ok: true as const };\n}\n\nexport async function deleteCustomTrigger(broadcasterId: string, keyword: string) {\n if (!(await getCustomTrigger(broadcasterId, keyword))) return false;\n await sqlite.execute(\"DELETE FROM custom_triggers WHERE broadcaster_id = ? AND keyword = ?\", [broadcasterId, keyword]);\n return true;\n}\n\nexport async function setCustomTriggerCooldown(broadcasterId: string, keyword: string, cooldownMs: number) {\n if (!(await getCustomTrigger(broadcasterId, keyword))) return false;\n await sqlite.execute(\n \"UPDATE custom_triggers SET cooldown_ms = ?, updated_at = ? WHERE broadcaster_id = ? AND keyword = ?\",\n [cooldownMs, Date.now(), broadcasterId, keyword],\n );\n return true;\n}\n\nexport async function markCustomTriggerUsed(broadcasterId: string, keyword: string) {\n await sqlite.execute(\n \"UPDATE custom_triggers SET uses = uses + 1, last_used_at = ? WHERE broadcaster_id = ? AND keyword = ?\",\n [Date.now(), broadcasterId, keyword],\n );\n}\n","createdAt",["D",1789092272973],"branchVersion","branchId","05246ac8-a272-4b74-b48a-34d91555f75d","id","20e82baa-ad9c-41ac-a8e5-4d2d285f6a79","dnd-twitch-bot",["D",1787995257440],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","cc37ba10-6e6d-4af6-a801-9955c92d23c4","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a04ba1-c79f-7319-b4f2-7c4f3772837b","tursoName","20e82baaad9c41aca8e54d2d285f6a79","tursoHostname","20e82baaad9c41aca8e54d2d285f6a79-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789500119686],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",512,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","StonedSheamus","handle","displayName","Shea Stolp","avatar","https://lh3.googleusercontent.com/a/ACg8ocIWmQgR3gyoMMicg2zCAoN1c7i36qX5mf9gRIdIXm8F2mo-ig=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":456,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":457,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":458,"_82":459,"_84":460,"_86":25},"tree",[342,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367],"files",[342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367],"counts",{"_331":61,"_332":273,"_333":61,"_334":335,"_336":337},"contents",[129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":324,"_32":325,"_30":326,"_156":-5,"_41":42,"_40":327,"_158":124,"_38":328,"_13":61,"_33":329,"_35":-5,"_24":25,"_162":-5,"_27":330},{"_43":318,"_32":319,"_30":320,"_156":-5,"_41":42,"_40":273,"_158":124,"_38":321,"_13":61,"_33":20,"_35":322,"_24":25,"_162":-5,"_27":323},{"_43":312,"_32":313,"_30":314,"_156":-5,"_41":42,"_40":207,"_158":25,"_38":315,"_13":61,"_33":20,"_35":316,"_24":25,"_162":-5,"_27":317},{"_43":304,"_32":305,"_30":306,"_156":-5,"_41":42,"_40":307,"_158":25,"_38":308,"_13":309,"_33":20,"_35":310,"_24":25,"_162":-5,"_27":311},{"_43":297,"_32":298,"_30":299,"_156":-5,"_41":42,"_40":300,"_158":124,"_38":301,"_13":169,"_33":34,"_35":302,"_24":25,"_162":-5,"_27":303},{"_43":290,"_32":291,"_30":292,"_156":-5,"_41":42,"_40":293,"_158":124,"_38":294,"_13":239,"_33":34,"_35":295,"_24":25,"_162":-5,"_27":296},{"_43":283,"_32":284,"_30":285,"_156":-5,"_41":42,"_40":286,"_158":124,"_38":287,"_13":239,"_33":34,"_35":288,"_24":25,"_162":-5,"_27":289},{"_43":276,"_32":277,"_30":278,"_156":-5,"_41":42,"_40":279,"_158":124,"_38":280,"_13":233,"_33":34,"_35":281,"_24":25,"_162":-5,"_27":282},{"_43":268,"_32":269,"_30":270,"_156":-5,"_41":42,"_40":271,"_158":25,"_38":272,"_13":273,"_33":34,"_35":274,"_24":25,"_162":-5,"_27":275},{"_43":261,"_32":262,"_30":263,"_156":-5,"_41":42,"_40":264,"_158":25,"_38":265,"_13":177,"_33":34,"_35":266,"_24":25,"_162":-5,"_27":267},{"_43":254,"_32":255,"_30":256,"_156":-5,"_41":42,"_40":257,"_158":25,"_38":258,"_13":207,"_33":34,"_35":259,"_24":25,"_162":-5,"_27":260},{"_43":247,"_32":248,"_30":249,"_156":-5,"_41":42,"_40":250,"_158":25,"_38":251,"_13":169,"_33":34,"_35":252,"_24":25,"_162":-5,"_27":253},{"_43":243,"_32":28,"_30":31,"_156":-5,"_41":42,"_40":14,"_158":25,"_38":244,"_13":245,"_33":34,"_35":37,"_24":25,"_162":-5,"_27":246},{"_43":236,"_32":237,"_30":238,"_156":-5,"_41":42,"_40":239,"_158":124,"_38":240,"_13":61,"_33":20,"_35":241,"_24":25,"_162":-5,"_27":242},{"_43":228,"_32":229,"_30":230,"_156":-5,"_41":42,"_40":231,"_158":25,"_38":232,"_13":233,"_33":34,"_35":234,"_24":25,"_162":-5,"_27":235},{"_43":218,"_32":219,"_30":220,"_156":-5,"_41":42,"_40":221,"_158":25,"_38":222,"_13":223,"_33":224,"_35":225,"_24":25,"_162":226,"_27":227},{"_43":211,"_32":212,"_30":213,"_156":-5,"_41":42,"_40":214,"_158":124,"_38":215,"_13":207,"_33":34,"_35":216,"_24":25,"_162":-5,"_27":217},{"_43":202,"_32":203,"_30":204,"_156":-5,"_41":42,"_40":205,"_158":25,"_38":206,"_13":207,"_33":208,"_35":209,"_24":25,"_162":-5,"_27":210},{"_43":195,"_32":196,"_30":197,"_156":-5,"_41":42,"_40":198,"_158":124,"_38":199,"_13":61,"_33":34,"_35":200,"_24":25,"_162":-5,"_27":201},{"_43":188,"_32":189,"_30":190,"_156":-5,"_41":42,"_40":191,"_158":124,"_38":192,"_13":61,"_33":34,"_35":193,"_24":25,"_162":-5,"_27":194},{"_43":180,"_32":181,"_30":182,"_156":-5,"_41":42,"_40":183,"_158":25,"_38":184,"_13":185,"_33":34,"_35":186,"_24":25,"_162":-5,"_27":187},{"_43":172,"_32":173,"_30":174,"_156":-5,"_41":42,"_40":175,"_158":25,"_38":176,"_13":177,"_33":34,"_35":178,"_24":25,"_162":-5,"_27":179},{"_43":164,"_32":165,"_30":166,"_156":-5,"_41":42,"_40":167,"_158":124,"_38":168,"_13":169,"_33":34,"_35":170,"_24":25,"_162":-5,"_27":171},{"_43":153,"_32":154,"_30":155,"_156":-5,"_41":42,"_40":157,"_158":25,"_38":159,"_13":160,"_33":34,"_35":161,"_24":25,"_162":-5,"_27":163},"9e2450e5-38c3-41e1-929f-f29fdd062aba","utils.ts","7c7a4070-a4d9-11f1-90df-1607ee4eb77e","parentId",349,"latest",["D",1789090459133],17,"// Pure helpers and small shared utilities\n\nimport type { Ability, Character } from \"./types.ts\";\nimport { abilityNames, abilityAliases, abilityFullNames, skillAbilities, knownBotAccounts } from \"./data.ts\";\n\nexport const pick = (items: T[]): T => items[Math.floor(Math.random() * items.length)];\n\nexport const modifier = (score: number) => Math.floor((score - 10) / 2);\n\nexport function rollStat() {\n const d = Array.from({ length: 4 }, () => 1 + Math.floor(Math.random() * 6)).sort((a, b) => b - a);\n return d[0] + d[1] + d[2];\n}\n\nexport function formatRaceName(race: string, subrace: string | null) {\n if (!subrace) return race.trim();\n const nr = race.trim().toLowerCase();\n const ns = subrace.trim().toLowerCase();\n return ns === nr || ns.endsWith(` ${nr}`) ? subrace.trim() : `${subrace.trim()} ${race.trim()}`;\n}\n\nexport function escapeHtml(value: string) {\n return value.replace(/[&<>'\"]/g, (c) => ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", \"'\": \"'\", '\"': \""\" }[c]!));\n}\n\nexport function formatStatLine(c: Character) {\n return `Lv${c.level} XP ${c.xp ?? 0} | ${abilityNames\n .map((a) => `${a} ${c.scores[a]}(${modifier(c.scores[a]) >= 0 ? \"+\" : \"\"}${modifier(c.scores[a])})`)\n .join(\" \")} | HP ${c.hpCurrent}/${c.hpMax} | Speed ${c.speed}ft | Prof +${c.proficiency}`;\n}\n\nexport function duelNarration(stage: string) {\n const lines: Record = {\n challenge: [\n \"The arena gates swing open.\",\n \"The gauntlet has been thrown.\",\n \"Fate calls for a showdown.\",\n \"A challenge echoes through the tavern.\",\n \"The bards ready their instruments—this could be a good one.\",\n \"Steel is drawn before a word is spoken.\",\n \"The crowd senses blood in the air.\",\n \"A dare no adventurer could refuse.\",\n \"The dice are already whispering about this one.\",\n \"Someone just signed up for a legendary tale.\",\n \"The tavern falls silent, waiting.\",\n \"A rivalry is about to be settled the old-fashioned way.\",\n \"The DM reaches for the initiative tracker.\",\n \"Honor, glory, and bragging rights are on the line.\",\n \"The challenge horn sounds across the guild hall.\",\n \"Two adventurers, one arena, zero mercy.\",\n \"The gauntlet lands with a satisfying thud.\",\n \"A duel is declared, and the crowd gathers 'round.\",\n \"The stakes have been set—glory or the ground.\",\n \"Fate shuffles its deck for this one.\",\n ],\n accept: [\n \"The crowd roars—the duel is on.\",\n \"Steel meets destiny.\",\n \"The initiative gods have been consulted.\",\n \"Acceptance granted—may the bones favor the bold.\",\n \"The gauntlet is picked up without hesitation.\",\n \"Both sides square off beneath torchlight.\",\n \"The bard starts composing before the first swing.\",\n \"A nod, a grip on the hilt, and it begins.\",\n \"The tavern clears a space for the coming chaos.\",\n \"Challenge accepted—the dice are drawn.\",\n \"The arena gates seal shut behind them.\",\n \"No turning back now; the die is cast.\",\n \"Two hearts race to the same drumbeat.\",\n \"The DM smiles—always a bad sign.\",\n \"Weapons are drawn, and so is everyone's attention.\",\n \"The duel begins under a watchful moon.\",\n \"Fate nods its approval.\",\n \"The crowd chants for first blood.\",\n \"Initiative rolled, tension rising.\",\n \"The challenge is met in full.\",\n ],\n decline: [\n \"The challenge fades into the tavern gossip.\",\n \"Wisdom wins this round.\",\n \"The duel is postponed by fate.\",\n \"Discretion proves the better part of valor.\",\n \"The gauntlet is left lying in the dirt.\",\n \"A tactical retreat, disguised as good sense.\",\n \"The bard shrugs and writes a different song.\",\n \"Not every quest needs to be accepted.\",\n \"The crowd grumbles but respects the choice.\",\n \"Sometimes the wisest roll is walking away.\",\n \"The challenge is filed under 'maybe later.'\",\n \"Even heroes pick their battles.\",\n \"The arena stays quiet a little longer.\",\n \"A polite decline, sword still sheathed.\",\n \"The duel dissolves back into idle chatter.\",\n \"Better a live coward than a dead hero, some say.\",\n \"The gauntlet is returned, unthrown.\",\n \"The DM shrugs and moves the plot along.\",\n \"Peace prevails, for now.\",\n \"The tavern returns to its usual roar.\",\n ],\n hit: [\n \"A clean strike finds its mark.\",\n \"That hit had advantage from destiny.\",\n \"The dice have chosen violence.\",\n \"Steel sings true.\",\n \"A textbook strike, straight from the manual.\",\n \"The blade finds its mark without mercy.\",\n \"That connected with authority.\",\n \"A solid hit—the crowd cheers.\",\n \"The attack lands clean and true.\",\n \"Fortune favors the aim this time.\",\n \"The strike lands with a satisfying crunch.\",\n \"A well-placed hit, worthy of a bard's verse.\",\n \"The blow connects, no saving throw in sight.\",\n \"That's going straight into the campaign log.\",\n \"A precise, punishing hit.\",\n \"The attack roll clears the armor class with room to spare.\",\n \"Contact made—and it hurt.\",\n \"The strike lands like it was scripted.\",\n \"A hit worthy of a highlight reel.\",\n \"The dice roll high, and the blade follows through.\",\n ],\n miss: [\n \"The attack misses wide; the boots remain unharmed.\",\n \"The blade finds only air.\",\n \"The dice requested a dramatic near miss.\",\n \"A swing and a whiff.\",\n \"The attack sails past, dramatically unthreatening.\",\n \"Armor class wins this exchange.\",\n \"The strike goes wide, to the crowd's disappointment.\",\n \"That one's going in the blooper reel.\",\n \"A valiant effort, poorly aimed.\",\n \"The dice roll low, and the blow follows suit.\",\n \"The attack misses by the length of a goblin's nose.\",\n \"Nothing but air and bruised pride.\",\n \"The blade whistles past, missing entirely.\",\n \"A near miss, emphasis on the miss.\",\n \"The strike lands nowhere useful.\",\n \"Fortune looks away for this swing.\",\n \"The attack fumbles its footing.\",\n \"A miss so clean it's almost impressive.\",\n \"The blow glances off nothing at all.\",\n \"That roll needed a little more luck.\",\n ],\n critical: [\n \"A critical hit! The bards are taking notes.\",\n \"Natural twenty—legendary timing.\",\n \"The D20 of Fate has opened the vault.\",\n \"A critical strike worthy of legend.\",\n \"The crowd loses its collective mind.\",\n \"That's a nat 20 if there ever was one.\",\n \"Critical! Somewhere, a bard just found their next verse.\",\n \"The dice have crowned a champion—for this round.\",\n \"A perfect strike, straight out of a campaign highlight.\",\n \"The heavens themselves seem to approve of that roll.\",\n \"Critical hit! The dungeon master allows a dramatic pause.\",\n \"That roll belongs in the guild's hall of fame.\",\n \"A devastating critical—someone's taking damage rolls twice.\",\n \"The natural 20 gods have smiled upon this strike.\",\n \"Critical! Even the monster looks impressed.\",\n \"A flawless strike for the ages.\",\n \"The dice landed on legendary.\",\n \"That's the kind of hit sequels are made of.\",\n \"Critical success—roll for damage, roll for glory.\",\n \"The stars aligned for that swing.\",\n ],\n defeat: [\n \"A character falls, but the story continues.\",\n \"The HP bar has entered the underworld.\",\n \"A dramatic collapse worthy of the final act.\",\n \"Zero HP, maximum drama.\",\n \"The fallen adventurer earns a moment of respectful silence.\",\n \"Down, but the campaign marches on.\",\n \"A defeat worthy of its own tragic ballad.\",\n \"The dice were not merciful this time.\",\n \"The battlefield claims another combatant.\",\n \"A hard-fought loss, and a story for the tavern.\",\n \"The final blow lands, and the duel ends.\",\n \"Down goes the challenger—someone alert the healer.\",\n \"The HP counter hits zero with theatrical timing.\",\n \"A noble defeat, recorded in the guild log.\",\n \"The fight ends, one combatant left standing.\",\n \"The loser limps off to nurse their pride.\",\n \"That's a wipe—time to regroup at camp.\",\n \"The dice have spoken, and the answer was defeat.\",\n \"A fall worthy of the campaign's next flashback.\",\n \"The duel closes with one combatant down for the count.\",\n ],\n victory: [\n \"Victory belongs to the last character standing.\",\n \"The winner claims the tavern bragging rights.\",\n \"The campaign chronicle gains a new legend.\",\n \"Victory! The bards are already rehearsing.\",\n \"The guild hall erupts in cheers.\",\n \"A win worthy of its own chapter.\",\n \"The victor raises their weapon to a roaring crowd.\",\n \"Glory secured, one HP bar at a time.\",\n \"The champion stands, the dust settles.\",\n \"A hard-won victory, exactly the kind bards love.\",\n \"The dice crowned a winner tonight.\",\n \"Victory earned—the tavern's buying the next round.\",\n \"The last one standing takes the spoils.\",\n \"A triumphant finish worthy of the campaign log.\",\n \"The winner's name goes up on the guild board.\",\n \"Another legend added to the chronicle.\",\n \"The battle ends, and glory is claimed.\",\n \"Victory! Somewhere, a bard just got a new song idea.\",\n \"The champion emerges, battered but triumphant.\",\n \"The dust clears, and one hero remains.\",\n ],\n };\n const pool = lines[stage] ?? lines.hit;\n return pool[Math.floor(Math.random() * pool.length)];\n}\n\nexport function combatStats(c: Character) {\n const ability = Math.max(c.scores.STR, c.scores.DEX);\n const mod = modifier(ability);\n return { attack: 10 + mod + c.proficiency, mod, die: 8 };\n}\n\nexport function isBotAccount(username: string, userId: string, botUserId: string) {\n const normalized = username.toLowerCase();\n const configured = (Deno.env.get(\"BOT_USERNAMES\") ?? \"\")\n .split(\",\")\n .map((x) => x.trim().toLowerCase())\n .filter(Boolean);\n return (\n userId === botUserId ||\n knownBotAccounts.has(normalized) ||\n configured.includes(normalized) ||\n normalized.endsWith(\"bot\")\n );\n}\n\nexport function hasModeratorBadge(event: any) {\n const badges = [...(event?.badges ?? []), ...(event?.source_badges ?? [])];\n return badges.some((badge: any) => badge.set_id === \"moderator\" || badge.set_id === \"broadcaster\");\n}\n\nexport type CheckKind =\n | { type: \"save\"; ability: Ability; label: string }\n | { type: \"skill\"; ability: Ability; label: string };\n\n/**\n * Resolve chat input like \"dex\", \"dexterity\", or \"stealth\" to a saving-throw\n * ability or a skill (and its governing ability). Returns null for anything\n * that isn't a recognized ability/skill name (e.g. a dice expression).\n */\nexport function resolveCheckKind(input: string): CheckKind | null {\n const key = input.trim().toLowerCase();\n if (!key) return null;\n\n const ability = abilityAliases[key];\n if (ability) {\n return { type: \"save\", ability, label: `${abilityFullNames[ability]} Saving Throw` };\n }\n\n const collapsed = key.replace(/\\s+/g, \"\");\n const skillEntry = Object.entries(skillAbilities).find(([name]) => name.replace(/\\s+/g, \"\") === collapsed);\n if (skillEntry) {\n const [name, skillAbility] = skillEntry;\n const label = name\n .split(\" \")\n .map((word, i) => (i > 0 && word === \"of\" ? word : word.charAt(0).toUpperCase() + word.slice(1)))\n .join(\" \");\n return { type: \"skill\", ability: skillAbility, label: `${label} Check` };\n }\n\n return null;\n}\n\nexport function rollDice(input = \"1d20\", customLabel?: string) {\n const expression = input.trim() || \"1d20\";\n const m = expression.match(/^(\\d+)d(\\d+)([+-]\\d+)?$/i);\n if (!m) return null;\n const n = +m[1],\n sides = +m[2],\n mod = m[3] ? +m[3] : 0;\n if (n > 100 || sides > 1000) return null;\n const rolls = Array.from({ length: n }, () => 1 + Math.floor(Math.random() * sides));\n const rawTotal = rolls.reduce((a, b) => a + b, 0);\n const total = rawTotal + mod;\n const label = customLabel ?? (expression.toLowerCase() === \"1d20\" ? \"D20 of Fate\" : \"Dice roll\");\n const rawD20 = n === 1 && sides === 20 ? rolls[0] : null;\n const puns =\n rawD20 === 20\n ? [\n \"Natural 20! The bards are already writing the song.\",\n \"Critical success! Even the dice wanted to be legendary.\",\n \"The gods have stamped this roll approved.\",\n \"A natural 20—today, the dungeon fears you.\",\n \"Fate has opened the treasure chest of victory.\",\n \"Nat 20! Somewhere, a DM sighs and adjusts the encounter.\",\n \"The dice rolled a max and immediately regretted nothing.\",\n \"A perfect roll, straight from the vault of legends.\",\n \"Natural 20—roll for damage, roll for glory.\",\n \"The universe itself cast Bless on this roll.\",\n \"That's a nat 20, framed and hung in the guild hall.\",\n \"Twenty out of twenty—the dice have no notes.\",\n \"A roll so good it should require a saving throw to believe.\",\n \"Natural 20! The crit fairy has visited.\",\n \"The d20 landed face-up and smug about it.\",\n \"A flawless roll worthy of its own campaign arc.\",\n \"Nat 20—even the monsters are taking notes.\",\n \"The dice rolled max and struck a pose.\",\n \"That's the kind of roll adventurers dream about.\",\n \"Natural 20! Somewhere, a bard grabs their lute.\",\n ]\n : rawD20 === 1\n ? [\n \"Natural 1! The floor wins this round.\",\n \"Critical fumble! Somewhere, a goblin just gained confidence.\",\n \"The dice have requested a short rest.\",\n \"A natural 1—excellent roleplay opportunity incoming.\",\n \"Fate rolled a banana peel under your boots.\",\n \"Nat 1—the DM is already smiling.\",\n \"The d20 rolled over and played dead.\",\n \"A critical fumble worthy of the blooper reel.\",\n \"That roll owes the party an apology.\",\n \"Natural 1! Even the mimics are laughing.\",\n \"The dice just cast Fumble on themselves.\",\n \"A one, a shrug, and a very awkward silence.\",\n \"The floor has never looked so inviting.\",\n \"Nat 1—time to check the fumble table.\",\n \"That's going straight into the tavern's blooper reel.\",\n \"The d20 chose chaos, and chaos chose you.\",\n \"A critical whiff for the ages.\",\n \"Natural 1! The goblins are taking notes for once.\",\n \"The dice tripped over their own pips.\",\n \"That roll just volunteered for a plot twist.\",\n ]\n : total >= 17\n ? [\n \"That roll arrived wearing a hero's cape.\",\n \"The adventure is leaning dramatically in your favor.\",\n \"Even the dungeon master raised an eyebrow at that one.\",\n \"A mighty swing of the fate hammer.\",\n \"The prophecy is looking unusually promising.\",\n \"That's a roll worth bragging about at camp.\",\n \"The dice are clearly rooting for you tonight.\",\n \"A strong roll, straight out of a highlight reel.\",\n \"Fortune favors the bold, and apparently you too.\",\n \"The stars aligned nicely for that one.\",\n \"That roll deserves its own toast at the tavern.\",\n \"A hearty result—the bards approve.\",\n \"The dice rolled high and struck a heroic pose.\",\n \"That's the kind of roll legends are built on.\",\n \"A confident roll, worthy of the front lines.\",\n \"The dungeon's odds just got a little worse.\",\n \"That roll practically glows with good fortune.\",\n \"A strong showing—the party's counting on more of these.\",\n \"The dice decided to be generous today.\",\n \"A roll fit for a chosen one.\",\n ]\n : total <= 4\n ? [\n \"That roll took a wrong turn at the tavern.\",\n \"The dungeon master is trying very hard not to smile.\",\n \"Fate has assigned you a side quest.\",\n \"The dice are demanding better snacks.\",\n \"That result has strong mimic-energy.\",\n \"The dice rolled low and immediately apologized.\",\n \"That's a roll better left out of the campaign log.\",\n \"A rough one—even the goblins felt bad.\",\n \"The dice seem to be having an off night.\",\n \"That roll wandered off the beaten path.\",\n \"A humble result, character-building at best.\",\n \"The dungeon's odds just got a little better.\",\n \"That roll needs a long rest and a pep talk.\",\n \"Not every roll can be legendary, apparently.\",\n \"The dice rolled low and hid behind the DM screen.\",\n \"A roll destined for the blooper reel.\",\n \"That result has 'try again' written all over it.\",\n \"The prophecy did not see that one coming, unfortunately.\",\n \"A roll that even the party's cleric can't fix.\",\n \"That's the kind of roll bards leave out of the song.\",\n ]\n : [\n \"Fate has spoken—no rerolling destiny.\",\n \"The dungeon master may now pretend this was planned.\",\n \"That roll wandered in from a side quest.\",\n \"Somewhere, a bard is composing a song about this.\",\n \"Your modifiers are doing the heavy lifting.\",\n \"The goblins are taking notes.\",\n \"The prophecy remains open.\",\n \"Fate rolled over and asked for advantage.\",\n \"The initiative order has noticed you.\",\n \"A perfectly serviceable bit of adventuring.\",\n \"The dice have offered a plot twist.\",\n \"The tavern is buying the next round.\",\n \"The campaign continues, one roll at a time.\",\n \"A solidly average result—the dungeon shrugs.\",\n \"The dice landed right in the middle of the story.\",\n \"Not legendary, not disastrous—just adventuring.\",\n \"The DM nods and moves the story along.\",\n \"A roll that keeps the plot moving forward.\",\n \"The party's chronicler notes it and carries on.\",\n \"That's a roll fit for a Tuesday quest.\",\n ];\n const pun = puns[Math.floor(Math.random() * puns.length)];\n return `🎲 ${label}: ${expression} → [${rolls.join(\", \")}]${mod ? (mod > 0 ? `+${mod}` : mod) : \"\"} = ${total}. ${pun}`;\n}\n\n// Yes/No fate questions, e.g. \"!roll is enya going to die this time?\" — a\n// separate flavor pool from the dice puns above since these need to echo\n// the asker's question back into a verdict rather than a roll total.\nconst FATE_YES: Array<(q: string) => string> = [\n (q) => `🎲 Natural 20! The fates favor a YES on \"${q}\"`,\n (q) => `📜 You cast Augury and receive a weal omen — YES, regarding \"${q}\"`,\n (q) => `🔮 The crystal ball clears... it shows YES for \"${q}\"`,\n (q) => `⚖️ The DM rolls behind the screen, smirks, and says YES to \"${q}\"`,\n (q) => `🃏 You draw from the Deck of Many Things: the Sun. YES — \"${q}\" comes to pass`,\n (q) => `👁️ The beholder's central eye blinks in approval: YES on \"${q}\"`,\n (q) => `✨ The bones fall in a favorable pattern. YES, so it is written — \"${q}\"`,\n (q) => `🗡️ Even a rogue with disadvantage nails this one. YES to \"${q}\"`,\n (q) => `🌟 The Bag of Holding produces exactly what's needed. YES on \"${q}\"`,\n (q) => `🐉 Even the dragon nods in approval. YES to \"${q}\"`,\n (q) => `📯 The horn of victory sounds. YES, regarding \"${q}\"`,\n (q) => `🍀 A stroke of adventurer's luck says YES to \"${q}\"`,\n (q) => `🧙 The wizard's crystal reveals a bright future. YES for \"${q}\"`,\n (q) => `⚔️ The blade hums with approval. YES to \"${q}\"`,\n (q) => `🕊️ A paladin's oath affirms it. YES on \"${q}\"`,\n (q) => `🎯 A natural bullseye of fate. YES, regarding \"${q}\"`,\n (q) => `🏰 The castle gates open wide. YES to \"${q}\"`,\n (q) => `🌕 The full moon favors bold choices. YES on \"${q}\"`,\n (q) => `📖 The tome of fate flips open to a golden page. YES for \"${q}\"`,\n (q) => `🔥 The campfire crackles in agreement. YES to \"${q}\"`,\n];\n\nconst FATE_NO: Array<(q: string) => string> = [\n (q) => `💀 Natural 1! Critical fumble — the answer is NO on \"${q}\"`,\n (q) => `📜 Augury returns a woe omen. NO, regarding \"${q}\"`,\n (q) => `🔮 The crystal ball clouds over... NO for \"${q}\"`,\n (q) => `⚖️ The DM shakes their head slowly. NO to \"${q}\"`,\n (q) => `🃏 You draw from the Deck of Many Things: the Void. NO — \"${q}\" will not come to pass`,\n (q) => `👁️ The beholder's central eye narrows: NO on \"${q}\"`,\n (q) => `✨ The bones scatter unfavorably. NO, so it is written — \"${q}\"`,\n (q) => `🛡️ Even a paladin's Lay on Hands can't save this one. NO to \"${q}\"`,\n (q) => `🕳️ The trapdoor springs early. NO on \"${q}\"`,\n (q) => `🐍 The yuan-ti hisses in disapproval. NO to \"${q}\"`,\n (q) => `⛈️ A storm rolls in over the plan. NO, regarding \"${q}\"`,\n (q) => `🗿 The ancient statue's eyes stay cold. NO for \"${q}\"`,\n (q) => `🦴 The bone dice clatter to a stop, unfavorable. NO to \"${q}\"`,\n (q) => `🕯️ The candle gutters out. NO on \"${q}\"`,\n (q) => `🐺 The wolves howl a warning. NO to \"${q}\"`,\n (q) => `🏹 The arrow falls short of its mark. NO for \"${q}\"`,\n (q) => `🌑 The new moon offers no light on this one. NO for \"${q}\"`,\n (q) => `🧪 The potion fizzles instead of glowing. NO to \"${q}\"`,\n (q) => `⚰️ The crypt door stays sealed. NO, regarding \"${q}\"`,\n (q) => `🐀 Even the rats scurry away from this. NO on \"${q}\"`,\n];\n\nconst MAX_FATE_QUESTION_LEN = 200;\n\n/** A 50/50 D&D-flavored yes/no verdict for a chat-supplied question. */\nexport function rollFate(question: string): string {\n const q = question.trim();\n const displayQuestion = q.length > MAX_FATE_QUESTION_LEN ? q.slice(0, MAX_FATE_QUESTION_LEN) + \"…\" : q;\n const pool = Math.random() < 0.5 ? FATE_YES : FATE_NO;\n const flavor = pool[Math.floor(Math.random() * pool.length)];\n return flavor(displayQuestion);\n}\n\n// !oracle — like !roll's fate verdict, but instead of YES/NO the\n// \"answer\" is a randomly-chosen recent chatter's name. The pool of eligible\n// names is supplied by the caller (see getRecentChatters in db.ts); this\n// function only owns the flavor text around whichever name it's given.\nconst ORACLE_LINES: Array<(q: string, name: string) => string> = [\n (q, name) => `🔮 The crystal ball swirls and resolves into a face: @${name}, regarding \"${q}\"`,\n (q, name) => `📜 You cast Augury. The vision names @${name} for \"${q}\"`,\n (q, name) => `🎴 The Deck of Many Things turns up a familiar face: @${name}, on \"${q}\"`,\n (q, name) => `👁️ The beholder's central eye fixes on @${name} for \"${q}\"`,\n (q, name) => `✨ The bones scatter and spell out a name: @${name}, regarding \"${q}\"`,\n (q, name) => `🕯️ The candle's smoke curls into the shape of @${name} for \"${q}\"`,\n (q, name) => `🗿 The ancient statue's eyes swivel and lock onto @${name} for \"${q}\"`,\n (q, name) => `🐉 The dragon exhales a name on the wind: @${name}, on \"${q}\"`,\n (q, name) => `🧙 The wizard's crystal reveals @${name} at the heart of it — \"${q}\"`,\n (q, name) => `📯 The horn sounds, summoning @${name} forth for \"${q}\"`,\n (q, name) => `🌕 By the light of the full moon, @${name} is named for \"${q}\"`,\n (q, name) => `🍀 Fate's coin lands heads-up on @${name} for \"${q}\"`,\n (q, name) => `⚖️ The DM consults the notes behind the screen and points at @${name} for \"${q}\"`,\n (q, name) => `🔥 The campfire pops and sends a spark toward @${name} — \"${q}\"`,\n (q, name) => `🕊️ A raven circles the tavern and lands on @${name}'s shoulder for \"${q}\"`,\n (q, name) => `🧿 The rune stones fall into the shape of a name: @${name}, on \"${q}\"`,\n (q, name) => `⚔️ The blade points itself, unbidden, toward @${name} for \"${q}\"`,\n (q, name) => `🃏 The tarot reveals The Adventurer: @${name}, regarding \"${q}\"`,\n (q, name) => `🏰 The castle gates swing open before @${name} for \"${q}\"`,\n (q, name) => `🐺 The wolves howl a name into the night: @${name}, on \"${q}\"`,\n (q, name) => `🌟 The stars align and trace out @${name} for \"${q}\"`,\n (q, name) => `📖 The tome of fate flips open to a page bearing @${name}'s name — \"${q}\"`,\n];\n\nconst MAX_ORACLE_QUESTION_LEN = 200;\n\n/** Names a random recent chatter as the \"answer\" to a chat-supplied question. */\nexport function rollOracle(question: string, chatterName: string): string {\n const q = question.trim();\n const displayQuestion = q.length > MAX_ORACLE_QUESTION_LEN ? q.slice(0, MAX_ORACLE_QUESTION_LEN) + \"…\" : q;\n const flavor = pick(ORACLE_LINES);\n return flavor(displayQuestion, chatterName);\n}\n\n// !hug — an undocumented, purely warm/supportive command. No dice, no\n// mechanics, no game state. Kept out of !dndbothelp and the guide on\n// purpose (like !connections) so it stays a small, genuine gesture rather\n// than a \"feature\" people grind or spam for a reaction.\nconst HUG_LINES: string[] = [\n \"Even legendary heroes need a long rest sometimes.\",\n \"You've survived every encounter so far — that's a flawless record.\",\n \"No saving throw needed here, just take the hug.\",\n \"Every campaign has a slow chapter. This is yours, and that's okay.\",\n \"You don't have to roll for initiative on the hard days.\",\n \"The party's got your back, no matter your HP.\",\n \"Short rests count too — you don't have to be at full HP to keep going.\",\n \"You've got more allies in this world than you know.\",\n \"Even the mightiest paladin needs someone to lean on sometimes.\",\n \"This one's on the house — no Charisma check required.\",\n \"You're further into the story than you think, and it's a good one.\",\n \"The guild remembers you, even on your quiet days.\",\n \"You don't need a critical hit to be doing great.\",\n \"Rest here a while. The dungeon can wait.\",\n \"You're allowed to hand off the torch for a bit.\",\n \"Whatever today's encounter was, you're still standing.\",\n \"Small victories still go in the campaign log.\",\n \"You're not fighting this one alone.\",\n \"Take the inspiration point — you've earned it.\",\n \"However this chapter reads, you're the hero of it.\",\n];\n\n/** A gentle, sincere hug — optionally directed at another chatter. */\nexport function rollHug(display: string, target?: string | null): string {\n const line = pick(HUG_LINES);\n return target\n ? `🤗 @${display} wraps @${target} in a warm hug. \"${line}\"`\n : `🤗 The guild wraps @${display} in a warm hug. \"${line}\"`;\n}\n\n// Auto thank-you for new and renewed Twitch subscriptions — see main.ts's\n// EventSub handling for \"channel.subscribe\" / \"channel.subscription.message\".\nconst SUB_TIER_NAMES: Record = {\n \"1000\": \"Tier 1\",\n \"2000\": \"Tier 2\",\n \"3000\": \"Tier 3\",\n Prime: \"Prime\",\n};\n\nfunction subTierLabel(tier?: string | null): string {\n if (!tier) return \"\";\n const label = SUB_TIER_NAMES[tier];\n return label ? ` (${label})` : \"\";\n}\n\nconst NEW_SUB_LINES: Array<(name: string, tier: string) => string> = [\n (name, tier) => `⚔️ @${name} has sworn fealty to the guild${tier}! Welcome to the ranks, adventurer — may your rolls be ever favorable.`,\n (name, tier) => `📜 A new name is inked into the guild roster: @${name}${tier}. The hall is a little brighter for it.`,\n (name, tier) => `🛡️ @${name} raises the guild banner for the first time${tier}. Glory and good company await.`,\n (name, tier) => `🎲 @${name} has joined the party${tier}! Grab a seat by the fire — the story's better with you in it.`,\n (name, tier) => `🏰 The gates open for a new adventurer: welcome, @${name}${tier}. Here's to the campaign ahead.`,\n (name, tier) => `✨ @${name} takes up the guild's oath${tier}. May your natural 20s find you often.`,\n (name, tier) => `🗡️ @${name} draws their blade and joins the guild${tier}. The campaign just got more interesting.`,\n (name, tier) => `🍺 @${name} bellies up to the guild tavern for the first time${tier}. First round's on the house.`,\n (name, tier) => `📯 A horn sounds as @${name} enters the guild${tier}. Adventure awaits.`,\n (name, tier) => `🌟 @${name} rolls a natural 20 on their first appearance${tier}. Welcome to the guild!`,\n (name, tier) => `🗺️ @${name} unrolls their map and joins the guild's quest${tier}. Onward!`,\n (name, tier) => `🏹 @${name} nocks an arrow and signs the guild ledger${tier}. Glad to have you.`,\n (name, tier) => `🔮 The seer foresaw this: @${name} joins the guild${tier}.`,\n (name, tier) => `🛶 @${name} arrives by longship, ready to adventure${tier}. Welcome aboard.`,\n (name, tier) => `📚 @${name} adds their name to the guild's grand tome${tier}. Let the story begin.`,\n (name, tier) => `🕯️ A candle is lit in the guild hall for @${name}${tier}. Welcome, adventurer.`,\n (name, tier) => `⚡ @${name} crashes into the guild hall like a lightning bolt${tier}. Let's see what you've got.`,\n (name, tier) => `🐉 @${name} tames the guild dragon on day one${tier}. Bold start.`,\n (name, tier) => `🎻 The bard strikes up a welcome tune for @${name}${tier}.`,\n (name, tier) => `🧭 @${name}'s compass points straight to the guild${tier}. Glad you found us.`,\n];\n\nconst RESUB_LINES: Array<(name: string, months: number, tier: string) => string> = [\n (name, months, tier) => `🔥 @${name} renews their pact with the guild${tier} — ${months} month${months === 1 ? \"\" : \"s\"} strong and still adventuring.`,\n (name, months, tier) => `📖 Another chapter for @${name}${tier}: ${months} month${months === 1 ? \"\" : \"s\"} in the guild, and the story keeps going.`,\n (name, months, tier) => `🛡️ @${name} re-ups their oath to the guild${tier} — ${months} month${months === 1 ? \"\" : \"s\"} of loyalty, and counting.`,\n (name, months, tier) => `🎉 @${name} has stuck with the guild for ${months} month${months === 1 ? \"\" : \"s\"}${tier}. That's a real friendship roll, not just a lucky one.`,\n (name, months, tier) => `⚔️ ${months} month${months === 1 ? \"\" : \"s\"} deep and @${name} is still here${tier} — the guild remembers its own.`,\n (name, months, tier) => `🏰 @${name} returns to the guild hall for month ${months}${tier}. The torches burn a little brighter.`,\n (name, months, tier) => `🗡️ @${name} re-forges their bond with the guild${tier} — ${months} month${months === 1 ? \"\" : \"s\"} and counting.`,\n (name, months, tier) => `📯 The horn sounds again for @${name}${tier}, marking ${months} month${months === 1 ? \"\" : \"s\"} of loyalty.`,\n (name, months, tier) => `🌟 @${name} levels up their guild membership to month ${months}${tier}. Still adventuring strong.`,\n (name, months, tier) => `🍻 @${name} raises a mug for ${months} month${months === 1 ? \"\" : \"s\"} in the guild${tier}. Cheers to the streak.`,\n (name, months, tier) => `📖 Chapter ${months} of @${name}'s guild saga begins${tier}. The story's far from over.`,\n (name, months, tier) => `🛡️ @${name}'s loyalty holds firm at ${months} month${months === 1 ? \"\" : \"s\"}${tier} — a shield wall of dedication.`,\n (name, months, tier) => `🔥 @${name} keeps the campfire burning for month ${months}${tier}. Glad you're still here.`,\n (name, months, tier) => `🗺️ @${name} marks another ${months} month${months === 1 ? \"\" : \"s\"} on the guild map${tier}. Onward, together.`,\n (name, months, tier) => `⚔️ @${name} re-swears the oath for month ${months}${tier}. The guild salutes you.`,\n (name, months, tier) => `🎲 @${name} rolls another month of loyalty (${months} total)${tier} — no natural 1 in sight.`,\n (name, months, tier) => `🏹 @${name} keeps their aim true after ${months} month${months === 1 ? \"\" : \"s\"} with the guild${tier}.`,\n (name, months, tier) => `🕯️ Another candle lit for @${name}'s month ${months}${tier} in the guild.`,\n (name, months, tier) => `🐉 @${name} has outlasted more dragons than most after ${months} month${months === 1 ? \"\" : \"s\"}${tier}.`,\n (name, months, tier) => `📜 The guild scribe adds another entry for @${name} — ${months} month${months === 1 ? \"\" : \"s\"} strong${tier}.`,\n];\n\n/** Thank-you for a brand-new subscription (channel.subscribe). */\nexport function rollNewSubThankYou(displayName: string, tier?: string | null): string {\n return pick(NEW_SUB_LINES)(displayName, subTierLabel(tier));\n}\n\n/** Thank-you for a renewed/resub with a shared message (channel.subscription.message). */\nexport function rollResubThankYou(displayName: string, months: number, tier?: string | null): string {\n const safeMonths = Number.isFinite(months) && months > 0 ? Math.floor(months) : 1;\n return pick(RESUB_LINES)(displayName, safeMonths, subTierLabel(tier));\n}\n\nconst GIFT_SUB_LINES: Array<(name: string, count: number, tier: string) => string> = [\n (name, count, tier) => `🎁 @${name} just gifted ${count} membership${count === 1 ? \"\" : \"s\"} to the guild${tier}! A round of applause for the guild's newest patron of generosity.`,\n (name, count, tier) => `💰 @${name} paid ${count} adventurer${count === 1 ? \"'s\" : \"s'\"} way into the guild${tier}. That's the kind of coin a bard writes songs about.`,\n (name, count, tier) => `✨ @${name} sponsored ${count} new guild membership${count === 1 ? \"\" : \"s\"}${tier} — true guild patronage.`,\n (name, count, tier) => `🛡️ @${name} covered the guild dues for ${count} adventurer${count === 1 ? \"\" : \"s\"}${tier}. The hall remembers acts like this.`,\n (name, count, tier) => `🏹 @${name} fires off ${count} gifted membership${count === 1 ? \"\" : \"s\"}${tier} like a volley of goodwill.`,\n (name, count, tier) => `🌟 @${name} casts Mass Generosity, hitting ${count} lucky adventurer${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `🍻 @${name} buys a round of guild memberships for ${count} adventurer${count === 1 ? \"\" : \"s\"}${tier}. Cheers all around!`,\n (name, count, tier) => `📯 @${name} sounds the horn of generosity, gifting ${count} membership${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `🗝️ @${name} unlocks the guild gates for ${count} new adventurer${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `🎁 @${name}'s Bag of Holding turns out to be full of gifted membership${count === 1 ? \"\" : \"s\"} (${count})${tier}.`,\n (name, count, tier) => `🐉 @${name} raids their own hoard to gift ${count} membership${count === 1 ? \"\" : \"s\"}${tier}. Legendary generosity.`,\n (name, count, tier) => `🛡️ @${name} shields ${count} adventurer${count === 1 ? \"\" : \"s\"} with a gifted membership${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `📜 @${name}'s name goes down in the guild's Book of Generous Deeds for ${count} gift${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `✨ @${name} sprinkles ${count} membership${count === 1 ? \"\" : \"s\"} across the guild like a Bless spell${tier}.`,\n (name, count, tier) => `🏰 @${name} throws open the guild doors for ${count} new adventurer${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `🍀 @${name} shares their luck with ${count} fellow adventurer${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `🔥 @${name} lights the way for ${count} new guild member${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `🎻 The bards write a tune about @${name}'s ${count}-membership gift${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `🗺️ @${name} charts a path into the guild for ${count} adventurer${count === 1 ? \"\" : \"s\"}${tier}.`,\n (name, count, tier) => `⚔️ @${name} arms ${count} new adventurer${count === 1 ? \"\" : \"s\"} with a guild membership${tier}. Well met!`,\n];\n\nconst ANON_GIFT_SUB_LINES: Array<(count: number, tier: string) => string> = [\n (count, tier) => `🎁 A mysterious benefactor just gifted ${count} membership${count === 1 ? \"\" : \"s\"} to the guild${tier}, no name given. The guild thanks you all the same.`,\n (count, tier) => `💰 An anonymous patron paid the guild dues for ${count} adventurer${count === 1 ? \"\" : \"s\"}${tier}. Whoever you are — well met.`,\n (count, tier) => `🕶️ A hooded figure gifts ${count} membership${count === 1 ? \"\" : \"s\"}${tier} and vanishes into the crowd.`,\n (count, tier) => `🧙 An unseen wizard casts a gift of ${count} membership${count === 1 ? \"\" : \"s\"}${tier} and disappears in a puff of smoke.`,\n (count, tier) => `🌙 Under cover of night, someone gifts ${count} membership${count === 1 ? \"\" : \"s\"}${tier}. The guild bows to the shadows.`,\n (count, tier) => `🎭 A masked benefactor leaves ${count} gifted membership${count === 1 ? \"\" : \"s\"}${tier} at the guild door.`,\n (count, tier) => `🐦 A raven delivers ${count} gifted membership${count === 1 ? \"\" : \"s\"}${tier}, sender unknown.`,\n (count, tier) => `✨ A flash of unseen magic grants ${count} membership${count === 1 ? \"\" : \"s\"}${tier}. No name, just generosity.`,\n (count, tier) => `🗝️ Someone slips ${count} membership key${count === 1 ? \"\" : \"s\"}${tier} under the guild door and disappears.`,\n (count, tier) => `🕵️ A rogue in the shadows gifts ${count} membership${count === 1 ? \"\" : \"s\"}${tier} without leaving a trace.`,\n (count, tier) => `📜 An unsigned scroll grants ${count} adventurer${count === 1 ? \"\" : \"s\"} guild membership${tier}.`,\n (count, tier) => `🌫️ A mist rolls through the guild hall, leaving behind ${count} gifted membership${count === 1 ? \"\" : \"s\"}${tier}.`,\n (count, tier) => `🦉 A familiar drops off ${count} gifted membership${count === 1 ? \"\" : \"s\"}${tier} and flies away.`,\n (count, tier) => `🕯️ A single candle burns beside ${count} anonymous gift${count === 1 ? \"\" : \"s\"}${tier}. No name attached.`,\n (count, tier) => `🎁 ${count} membership${count === 1 ? \"\" : \"s\"}${tier} appear, gift-wrapped, with no card in sight.`,\n (count, tier) => `🐉 A hoard's worth of generosity funds ${count} membership${count === 1 ? \"\" : \"s\"}${tier}, courtesy of persons unknown.`,\n (count, tier) => `🌟 A shooting star grants ${count} membership${count === 1 ? \"\" : \"s\"}${tier} — anonymously, as shooting stars do.`,\n (count, tier) => `🛡️ An unnamed champion shields ${count} adventurer${count === 1 ? \"\" : \"s\"} with a gifted membership${tier}.`,\n (count, tier) => `🗿 An ancient statue seems to wink as ${count} gifted membership${count === 1 ? \"\" : \"s\"}${tier} appear.`,\n (count, tier) => `🍀 Fortune smiles, unnamed, granting ${count} membership${count === 1 ? \"\" : \"s\"}${tier}.`,\n];\n\nconst GIFTED_WELCOME_LINES: Array<(name: string, tier: string) => string> = [\n (name, tier) => `🎁 @${name} joins the guild courtesy of a fellow adventurer's generosity${tier}. Welcome to the ranks — your gear's already paid for.`,\n (name, tier) => `⚔️ @${name} has been sponsored into the guild${tier}! Someone believed you belonged here — now go prove them right.`,\n (name, tier) => `📜 @${name}'s name goes on the roster, gifted by a guildmate${tier}. Welcome aboard.`,\n (name, tier) => `🎁 @${name} unwraps a guild membership${tier} they didn't even have to earn. Lucky adventurer.`,\n (name, tier) => `🛡️ @${name} enters the guild shielded by someone else's generosity${tier}. Make it count.`,\n (name, tier) => `🌟 @${name} arrives with a gifted membership in hand${tier} — someone believes in you.`,\n (name, tier) => `🍀 @${name}'s luck just leveled up with a gifted guild spot${tier}.`,\n (name, tier) => `🗺️ @${name} starts their journey with the guild, courtesy of a generous ally${tier}.`,\n (name, tier) => `🏰 The gates open for @${name}, gifted entry and all${tier}. Welcome home.`,\n (name, tier) => `🎻 A tune plays as @${name} steps in on someone else's coin${tier}. Enjoy the show.`,\n (name, tier) => `🕯️ A candle is lit for @${name}'s gifted arrival${tier}. Welcome to the guild.`,\n (name, tier) => `📯 The horn sounds for @${name}, sponsored into the ranks${tier}.`,\n (name, tier) => `🐉 @${name} rides in on someone else's generosity${tier}, dragon-scale luck included.`,\n (name, tier) => `⚔️ @${name} joins the ranks, gear paid for, glory still to be earned${tier}.`,\n (name, tier) => `🔥 @${name}'s guild membership was lit by another's kindness${tier}. Pass it on.`,\n (name, tier) => `🧙 A wizard's generosity conjures @${name} straight into the guild${tier}.`,\n (name, tier) => `🏹 @${name} joins the ranks, quiver full and dues already paid${tier}.`,\n (name, tier) => `📖 A new chapter opens for @${name}, gifted by a fellow adventurer${tier}.`,\n (name, tier) => `🎲 @${name} rolls into the guild on someone else's natural 20 of kindness${tier}.`,\n (name, tier) => `🌙 Under the guild's banner, @${name} arrives — gifted, welcomed, ready${tier}.`,\n];\n\n/** Thank-you for a gift-sub batch (channel.subscription.gift). Pass name=null for anonymous gifts. */\nexport function rollGiftSubThankYou(gifterName: string | null, count: number, tier?: string | null): string {\n const safeCount = Number.isFinite(count) && count > 0 ? Math.floor(count) : 1;\n return gifterName\n ? pick(GIFT_SUB_LINES)(gifterName, safeCount, subTierLabel(tier))\n : pick(ANON_GIFT_SUB_LINES)(safeCount, subTierLabel(tier));\n}\n\n/** Welcome for the recipient of a gifted sub (channel.subscribe with is_gift=true). */\nexport function rollGiftedSubWelcome(recipientName: string, tier?: string | null): string {\n return pick(GIFTED_WELCOME_LINES)(recipientName, subTierLabel(tier));\n}\n\n// Auto thank-you for incoming raids (channel.raid) — see main.ts's EventSub\n// handling. \"party\" is a pre-formatted phrase (e.g. \"12 adventurers\") so\n// each line can drop it in without every line re-deriving pluralization.\nfunction raidPartyPhrase(viewers: number): string {\n const safe = Number.isFinite(viewers) && viewers > 0 ? Math.floor(viewers) : 0;\n return safe > 0 ? `${safe} adventurer${safe === 1 ? \"\" : \"s\"}` : \"a band of fellow adventurers\";\n}\n\nconst RAID_LINES: Array<(name: string, party: string) => string> = [\n (name, party) => `🐺 @${name} leads a raiding party of ${party} into the guild hall! Welcome, raiders — grab a seat by the fire.`,\n (name, party) => `⚔️ @${name} crests the hill with ${party} at their back! The guild throws open its gates.`,\n (name, party) => `📯 A horn sounds — @${name} arrives with ${party}, ready to join the campaign.`,\n (name, party) => `🛡️ @${name} marches ${party} straight into the guild hall. Reinforcements have arrived!`,\n (name, party) => `🏰 The gates swing wide for @${name} and ${party} riding in behind them.`,\n (name, party) => `🎲 @${name} rolls in with ${party} — a natural 20 for guild morale.`,\n (name, party) => `🗺️ @${name} charts a course straight to the guild, bringing ${party} along for the ride.`,\n (name, party) => `🔥 The campfire grows bigger — @${name} and ${party} have joined the circle.`,\n (name, party) => `🐉 @${name} arrives like a dragon's hoard of goodwill, bringing ${party} with them.`,\n (name, party) => `🍻 @${name} and ${party} storm the tavern doors. First round's on the house!`,\n (name, party) => `📜 The guild scribe adds a new entry: @${name} raids in with ${party} at their side.`,\n (name, party) => `🌟 @${name} lights up the guild hall, ${party} in tow. Welcome, everyone!`,\n (name, party) => `🧭 @${name}'s compass points true — ${party} follow them straight into the guild.`,\n (name, party) => `🏹 @${name} leads ${party} over the ridge and into the guild's welcoming arms.`,\n (name, party) => `⚡ @${name} crashes the guild hall with ${party} — what an entrance!`,\n (name, party) => `🎻 The bards strike up a welcome tune for @${name} and the ${party} riding with them.`,\n (name, party) => `🛶 @${name} sails in with ${party}, ready to dock at the guild hall.`,\n (name, party) => `🕯️ New torches are lit for @${name} and ${party} joining the hall.`,\n (name, party) => `🌙 Under a banner held high, @${name} rides in with ${party}.`,\n (name, party) => `🐎 @${name} gallops in at the head of ${party}. The guild welcomes every one of you.`,\n];\n\n/** Thank-you for an incoming raid (channel.raid). */\nexport function rollRaidThankYou(raiderName: string, viewers: number): string {\n return pick(RAID_LINES)(raiderName, raidPartyPhrase(viewers));\n}\n\n// Matches \"goodnight\"-style chat messages so the bot can send off adventurers\n// for the night. Word-boundary-wrapped (not anchored to the start), so it\n// fires anywhere in the message — e.g. \"ok chat, gnight!\" or \"that's it for\n// me, good night everyone\" — while still avoiding false hits inside unrelated\n// words like \"midnight\", \"tonight\", \"nightmare\", or \"knight\".\nconst NIGHT = \"(?:n(?:ight|ite))\";\nconst GOODNIGHT_REGEX = new RegExp(\n `\\\\b(?:gn+|g['’]?n?${NIGHT}|good\\\\s*${NIGHT}|nighty\\\\s*${NIGHT}|${NIGHT}\\\\s*${NIGHT}|sleep\\\\s*tight)\\\\b`,\n \"i\",\n);\n\nexport function isGoodnightMessage(message: string): boolean {\n return GOODNIGHT_REGEX.test(message.trim());\n}\n\nconst GOODNIGHT_REPLIES = [\n (n: string) => `Rest well, @${n}! 🌙 May your dreams be free of goblins.`,\n (n: string) => `Goodnight, @${n}! The guild hall banks its fires — safe travels to the Land of Nod. 💤`,\n (n: string) => `Sleep tight, @${n}! A long rest restores HP *and* spell slots. 🛌`,\n (n: string) => `Farewell for now, @${n}! May you wake with advantage on tomorrow's rolls. ✨`,\n (n: string) => `🌜 Sweet dreams, @${n}! May no owlbear disturb your rest.`,\n (n: string) => `🛏️ Off to bed, @${n}? Even legends need their eight hours.`,\n (n: string) => `🌙 Goodnight, @${n}! The watch is set — sleep easy.`,\n (n: string) => `💤 Long rest initiated for @${n}. See you after the next dawn.`,\n (n: string) => `✨ Sleep well, @${n} — may your dreams roll nothing but natural 20s.`,\n (n: string) => `🏕️ Camp's set, @${n}. Rest up for tomorrow's adventure.`,\n (n: string) => `🌌 The stars watch over you tonight, @${n}. Goodnight!`,\n (n: string) => `🦉 The owls take the next watch, @${n}. Rest easy.`,\n (n: string) => `🕯️ The torches dim for the night, @${n}. Sleep well.`,\n (n: string) => `🐉 Even dragons need their sleep, @${n}. Goodnight!`,\n (n: string) => `📖 The chronicle pauses here, @${n}. Same time next session?`,\n (n: string) => `🛡️ Shields down, @${n} — time to rest.`,\n (n: string) => `🌠 May a shooting star bless your dreams, @${n}. Goodnight!`,\n (n: string) => `🍃 The wind carries you off to sleep, @${n}. Rest well.`,\n (n: string) => `🧝 Even the elves need their trance sometimes, @${n}. Goodnight!`,\n (n: string) => `🌒 Until next session, @${n}. Sleep tight, adventurer.`,\n];\n\nexport function goodnightReply(display: string): string {\n const pick = GOODNIGHT_REPLIES[Math.floor(Math.random() * GOODNIGHT_REPLIES.length)];\n return pick(display);\n}\n\nexport function compactText(value: unknown, max = 240) {\n return String(value ?? \"\")\n .replace(/\\s+/g, \" \")\n .replace(/<[^>]+>/g, \"\")\n .trim()\n .slice(0, max);\n}\n\nexport function splitChatMessage(text: string, max = 300) {\n const parts: string[] = [];\n let remaining = text.trim();\n while (remaining.length > max) {\n let cut = remaining.lastIndexOf(\" \", max);\n if (cut < 1) cut = max;\n parts.push(remaining.slice(0, cut).trim());\n remaining = remaining.slice(cut).trim();\n }\n if (remaining) parts.push(remaining);\n return parts;\n}\n\nexport function firstAlive(members: string[], hp: Record) {\n return members.findIndex((name) => Number(hp[name]) > 0);\n}\n\nexport function logRowText(r: any) {\n return `${new Date(Number(r.created_at)).toISOString()} | @${r.username} | ${r.action} | ${r.detail}`;\n}\n","label",[154],"ed31c04a-20e0-4fa9-8ed8-16350f65e9da","types.ts","760b7a24-a4d9-11f1-9139-1607ee4eb77e",266,["D",1788580993350],9,"// Shared type definitions for GuildScribe\n\nexport type Ability = \"STR\" | \"DEX\" | \"CON\" | \"INT\" | \"WIS\" | \"CHA\";\n\nexport type Race = {\n subraces: string[];\n bonuses: Partial>;\n speed: number;\n traits: string[];\n};\n\nexport type ClassData = {\n priority: Ability[];\n savingThrows: Ability[];\n hitDie: number;\n calling: string;\n};\n\nexport type Character = {\n username: string;\n race: string;\n subrace: string | null;\n cls: string;\n level: number;\n xp: number;\n scores: Record;\n speed: number;\n hpMax: number;\n hpCurrent: number;\n proficiency: number;\n traits: string[];\n spells: string[];\n items: string[];\n feats: string[];\n abilities: string[];\n};\n\nexport type CreationSession = {\n broadcasterId: string;\n username: string;\n step: string;\n race?: string | null;\n subrace?: string | null;\n cls?: string | null;\n scores?: number[] | Record | null;\n // BG3-flavored creation only (!bg3) — unused by the standard !newchar wizard.\n subclass?: string | null;\n background?: string | null;\n alignment?: string | null;\n hook?: string | null;\n};\n",[165],"4d2e5091-6404-4540-a8ea-0031945582b4","twitch.ts","9c5a8652-a4d9-11f1-b87e-1607ee4eb77e",328,["D",1789001992717],15,"// Twitch API helpers (tokens, chat, EventSub)\n\nimport { MAX_LOOKUP_MESSAGE_LENGTH } from \"./data.ts\";\nimport { splitChatMessage } from \"./utils.ts\";\n\nexport const env = (name: string) => {\n const value = Deno.env.get(name);\n if (!value) throw new Error(`Missing environment variable: ${name}`);\n return value;\n};\n\nconst CHAT_MAX = Math.min(MAX_LOOKUP_MESSAGE_LENGTH, 480);\n// Rules need more parts than other lookups; spells use sendSpellSections separately.\nconst MAX_PARTS = 5;\nconst PART_DELAY_MS = 450;\n// Twitch chat-send limits are shared by the bot account. Keep a conservative\n// global queue by default; operators can lower this after Twitch grants the\n// appropriate bot rate limit/verification.\nconst GLOBAL_CHAT_MIN_INTERVAL_MS = Math.max(50, Number(Deno.env.get(\"CHAT_GLOBAL_MIN_INTERVAL_MS\") ?? \"1600\"));\nlet nextChatSendAt = 0;\n\nasync function waitForGlobalChatSlot() {\n const now = Date.now();\n const wait = Math.max(0, nextChatSendAt - now);\n nextChatSendAt = Math.max(now, nextChatSendAt) + GLOBAL_CHAT_MIN_INTERVAL_MS;\n if (wait) await sleep(wait);\n}\n\nfunction sleep(ms: number) {\n return new Promise((resolve) => setTimeout(resolve, ms));\n}\n\n/** Cap + truncate parts so multi-message lookups always finish. */\nfunction prepareParts(text: string, maxLen = CHAT_MAX, maxParts = MAX_PARTS): string[] {\n let parts = splitChatMessage(text, maxLen).map((p) => p.slice(0, maxLen));\n if (parts.length > maxParts) {\n parts = parts.slice(0, maxParts);\n const last = parts[parts.length - 1];\n parts[parts.length - 1] = last.slice(0, Math.max(0, maxLen - 12)).trimEnd() + \" …(cut)\";\n }\n return parts.filter((p) => p.length > 0);\n}\n\n/** Keep URL on the first chat part so it is never dropped. */\nfunction preferLinkInFirstPart(parts: string[]): string[] {\n if (parts.length <= 1) return parts;\n const linkMatch = parts.join(\" \").match(/https?:\\/\\/[^\\s|]+/);\n if (!linkMatch) return parts;\n const link = linkMatch[0];\n if (parts[0].includes(link)) return parts;\n const prefix = `🔗 ${link} | `;\n let first = prefix + parts[0].replace(/🔗\\s*https?:\\/\\/[^\\s|]+\\s*\\|\\s*/g, \"\");\n if (first.length > CHAT_MAX) first = first.slice(0, CHAT_MAX - 1) + \"…\";\n const rest = parts\n .slice(1)\n .map((p) => p.replace(link, \"\").replace(/\\s*\\|\\s*$/g, \"\").trim())\n .filter(Boolean);\n return [first, ...rest];\n}\n\nexport async function sendChatMessage(text: string, broadcasterId: string) {\n const message = text.slice(0, 500);\n if (!message.trim()) return true;\n try {\n await waitForGlobalChatSlot();\n const send = async (token: string) =>\n fetch(\"https://api.twitch.tv/helix/chat/messages\", {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${token}`,\n \"Client-Id\": env(\"TWITCH_CLIENT_ID\"),\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n broadcaster_id: broadcasterId,\n sender_id: env(\"TWITCH_BOT_ID\"),\n message,\n }),\n });\n\n let res = await send(await getAppToken());\n if (res.status === 401) {\n // Cached token was rejected (expired/revoked) — drop it and get a fresh one, once.\n invalidateAppToken();\n await waitForGlobalChatSlot();\n res = await send(await getAppToken());\n }\n if (!res.ok && res.status !== 429) {\n console.error(`Twitch chat send failed: ${res.status}`);\n }\n // Brief backoff on rate limit so following parts can still send\n if (res.status === 429) {\n await sleep(1100);\n return false;\n }\n return res.ok;\n } catch (err) {\n console.error(\"sendChatMessage failed\", err);\n return false;\n }\n}\n\nexport async function sendChatMessages(\n text: string,\n broadcasterId: string,\n opts?: { maxParts?: number },\n) {\n const maxParts = opts?.maxParts ?? MAX_PARTS;\n let parts = prepareParts(text, CHAT_MAX, maxParts);\n parts = preferLinkInFirstPart(parts);\n for (let i = 0; i < parts.length; i++) {\n const ok = await sendChatMessage(parts[i], broadcasterId);\n if (!ok && i < parts.length - 1) {\n await sleep(700);\n await sendChatMessage(parts[i], broadcasterId);\n }\n if (i < parts.length - 1) await sleep(PART_DELAY_MS);\n }\n}\n\nexport async function sendSpellSections(sections: string[], display: string, broadcasterId: string) {\n // Flatten sections into a limited stream of chat parts (avoid dropping mid-spell)\n const combined: string[] = [];\n for (const section of sections) {\n combined.push(...prepareParts(`@${display} ${section}`, CHAT_MAX, 3));\n }\n const parts = combined.slice(0, MAX_PARTS);\n if (combined.length > MAX_PARTS && parts.length) {\n parts[parts.length - 1] =\n parts[parts.length - 1].slice(0, Math.max(0, CHAT_MAX - 12)).trimEnd() + \" …(cut)\";\n }\n for (let i = 0; i < parts.length; i++) {\n await sendChatMessage(parts[i], broadcasterId);\n if (i < parts.length - 1) await sleep(PART_DELAY_MS);\n }\n}\n\n// App access tokens (client_credentials) are valid for ~hours, not one request —\n// cache and reuse instead of re-fetching one from Twitch on every chat send.\nlet cachedAppToken: { token: string; expiresAt: number } | null = null;\n\nexport function invalidateAppToken() {\n cachedAppToken = null;\n}\n\nexport async function getAppToken() {\n if (cachedAppToken && Date.now() < cachedAppToken.expiresAt) {\n return cachedAppToken.token;\n }\n const body = new URLSearchParams({\n client_id: env(\"TWITCH_CLIENT_ID\"),\n client_secret: env(\"TWITCH_CLIENT_SECRET\"),\n grant_type: \"client_credentials\",\n });\n const res = await fetch(\"https://id.twitch.tv/oauth2/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body,\n });\n if (!res.ok) throw new Error(`App token failed: ${res.status} ${await res.text()}`);\n const data = await res.json();\n const expiresInMs = Number(data.expires_in ?? 0) * 1000;\n // Refresh a minute early so we never send a request with a token that\n // expires mid-flight.\n cachedAppToken = {\n token: data.access_token as string,\n expiresAt: Date.now() + Math.max(0, expiresInMs - 60_000),\n };\n return cachedAppToken.token;\n}\n\nexport async function exchangeCode(code: string, redirectUri: string) {\n const body = new URLSearchParams({\n client_id: env(\"TWITCH_CLIENT_ID\"),\n client_secret: env(\"TWITCH_CLIENT_SECRET\"),\n code,\n grant_type: \"authorization_code\",\n redirect_uri: redirectUri,\n });\n const res = await fetch(\"https://id.twitch.tv/oauth2/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body,\n });\n if (!res.ok) throw new Error(`OAuth exchange failed: ${res.status} ${await res.text()}`);\n return await res.json();\n}\n\n// Used to keep a /dashboard login session alive past its ~4h access token\n// without asking the viewer to sign in again — refresh_token grant per\n// Twitch's OAuth docs. Twitch rotates the refresh token on every use, so\n// callers must persist the new one, not just the new access token.\nexport async function refreshUserToken(refreshToken: string) {\n const body = new URLSearchParams({\n client_id: env(\"TWITCH_CLIENT_ID\"),\n client_secret: env(\"TWITCH_CLIENT_SECRET\"),\n grant_type: \"refresh_token\",\n refresh_token: refreshToken,\n });\n const res = await fetch(\"https://id.twitch.tv/oauth2/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body,\n });\n if (!res.ok) throw new Error(`Token refresh failed: ${res.status} ${await res.text()}`);\n return await res.json();\n}\n\n/** Identifies the viewer behind a user access token — used right after the\n * /dashboard OAuth exchange to learn who just logged in. Works with any\n * valid user token; no extra scope required. */\nexport async function getSelfUser(userToken: string) {\n const res = await fetch(\"https://api.twitch.tv/helix/users\", {\n headers: {\n Authorization: `Bearer ${userToken}`,\n \"Client-Id\": env(\"TWITCH_CLIENT_ID\"),\n },\n });\n if (!res.ok) throw new Error(`Could not identify user: ${res.status} ${await res.text()}`);\n const data = await res.json();\n return data.data[0];\n}\n\n/** Every channel a Twitch user currently moderates (requires the\n * user:read:moderated_channels scope on their token) — does NOT include a\n * channel they broadcast themselves; callers should check that separately.\n * Paginated, capped at 500 channels as a sane ceiling for a single viewer. */\nexport async function getModeratedChannelIds(userToken: string, userId: string): Promise {\n const ids: string[] = [];\n let cursor: string | undefined;\n do {\n const params = new URLSearchParams({ user_id: userId, first: \"100\" });\n if (cursor) params.set(\"after\", cursor);\n const res = await fetch(`https://api.twitch.tv/helix/moderation/channels?${params.toString()}`, {\n headers: {\n Authorization: `Bearer ${userToken}`,\n \"Client-Id\": env(\"TWITCH_CLIENT_ID\"),\n },\n });\n if (!res.ok) throw new Error(`Get Moderated Channels failed: ${res.status} ${await res.text()}`);\n const data = await res.json();\n for (const row of data.data ?? []) ids.push(String(row.broadcaster_id));\n cursor = data.pagination?.cursor || undefined;\n } while (cursor && ids.length < 500);\n return ids;\n}\n\nasync function createEventSubSubscription(\n type: string,\n version: string,\n condition: Record,\n callbackUrl: string,\n) {\n const appToken = await getAppToken();\n const res = await fetch(\"https://api.twitch.tv/helix/eventsub/subscriptions\", {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${appToken}`,\n \"Client-Id\": env(\"TWITCH_CLIENT_ID\"),\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n type,\n version,\n condition,\n transport: {\n method: \"webhook\",\n callback: callbackUrl,\n secret: env(\"EVENTSUB_SECRET\"),\n },\n }),\n });\n const text = await res.text();\n if (!res.ok) throw new Error(`EventSub subscription failed (${type}): ${res.status} ${text}`);\n return JSON.parse(text).data[0];\n}\n\nexport async function createChatSubscription(broadcasterId: string, callbackUrl: string) {\n return createEventSubSubscription(\n \"channel.chat.message\",\n \"1\",\n { broadcaster_user_id: broadcasterId, user_id: env(\"TWITCH_BOT_ID\") },\n callbackUrl,\n );\n}\n\n// New subscriptions (channel.subscribe) and renewals shared with a message\n// in chat (channel.subscription.message) — used to power the D&D-themed\n// !hug-style auto thank-you. Both require the broadcaster to have granted\n// the \"channel:read:subscriptions\" scope during OAuth; older connections\n// made before that scope was requested will need to reconnect for these to\n// take effect. Best-effort: callers should not fail the whole connect flow\n// if these throw (e.g. scope not yet granted).\nexport async function createSubEventSubscriptions(broadcasterId: string, callbackUrl: string) {\n const [newSub, resub, gift] = await Promise.all([\n createEventSubSubscription(\"channel.subscribe\", \"1\", { broadcaster_user_id: broadcasterId }, callbackUrl),\n createEventSubSubscription(\"channel.subscription.message\", \"1\", { broadcaster_user_id: broadcasterId }, callbackUrl),\n createEventSubSubscription(\"channel.subscription.gift\", \"1\", { broadcaster_user_id: broadcasterId }, callbackUrl),\n ]);\n return { newSub, resub, gift };\n}\n\n// Incoming raids — powers the automatic D&D-themed raid thank-you. Unlike\n// the subscribe/resub/gift events above, channel.raid with a\n// to_broadcaster_user_id condition needs no extra OAuth scope (it's public\n// EventSub data), so this should reliably succeed for every connected\n// channel. Still created as its own best-effort call in main.ts so a hiccup\n// here never blocks the core chat connection.\nexport async function createRaidEventSubscription(broadcasterId: string, callbackUrl: string) {\n return createEventSubSubscription(\n \"channel.raid\",\n \"1\",\n { to_broadcaster_user_id: broadcasterId },\n callbackUrl,\n );\n}\n\nexport async function deleteEventSubSubscription(subscriptionId: string) {\n if (!subscriptionId) return true;\n const appToken = await getAppToken();\n const res = await fetch(`https://api.twitch.tv/helix/eventsub/subscriptions?id=${encodeURIComponent(subscriptionId)}`, {\n method: \"DELETE\",\n headers: { Authorization: `Bearer ${appToken}`, \"Client-Id\": env(\"TWITCH_CLIENT_ID\") },\n });\n if (res.status === 404) return true;\n if (!res.ok) throw new Error(`EventSub deletion failed: ${res.status} ${await res.text()}`);\n return true;\n}\n\n/** Constant-time string compare — doesn't branch/short-circuit on content,\n * only on length (which isn't secret), so it doesn't leak how many leading\n * characters of the signature matched via response timing. */\nfunction timingSafeEqual(a: string, b: string): boolean {\n if (a.length !== b.length) return false;\n let diff = 0;\n for (let i = 0; i < a.length; i++) {\n diff |= a.charCodeAt(i) ^ b.charCodeAt(i);\n }\n return diff === 0;\n}\n\nexport async function verifyEventSub(req: Request, rawBody: string) {\n const id = req.headers.get(\"Twitch-Eventsub-Message-Id\") ?? \"\";\n const timestamp = req.headers.get(\"Twitch-Eventsub-Message-Timestamp\") ?? \"\";\n const received = req.headers.get(\"Twitch-Eventsub-Message-Signature\") ?? \"\";\n if (!id || !timestamp || !received) return false;\n const receivedAt = Date.parse(timestamp);\n if (!Number.isFinite(receivedAt) || Math.abs(Date.now() - receivedAt) > 10 * 60 * 1000) return false;\n const key = await crypto.subtle.importKey(\n \"raw\",\n new TextEncoder().encode(env(\"EVENTSUB_SECRET\")),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const signature = new Uint8Array(\n await crypto.subtle.sign(\"HMAC\", key, new TextEncoder().encode(id + timestamp + rawBody)),\n );\n const hex = [...signature].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n const expected = `sha256=${hex}`;\n return timingSafeEqual(expected, received);\n}\n",[173],"da2b24dc-e109-46d5-abcf-e2c9c06b4287","pages.ts","a605108c-a4d9-11f1-a673-1607ee4eb77e",346,["D",1789090458915],38,"// HTML page rendering for the web UI\n\nimport type { Character } from \"./types.ts\";\nimport { abilityNames } from \"./data.ts\";\nimport { modifier, formatRaceName, escapeHtml } from \"./utils.ts\";\nimport type { MapRow, MapToken } from \"./db.ts\";\nimport { MAP_TEMPLATES, TERRAINS, tokenColor } from \"./maps.ts\";\n\nexport function page(title: string, body: string) {\n return new Response(\n `${title}${body}`,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n}\n\nexport function renderCharacterPage(c: Character) {\n const statLine = abilityNames\n .map(\n (a) =>\n `

${a} ${c.scores[a]} (${modifier(c.scores[a]) >= 0 ? \"+\" : \"\"}${modifier(c.scores[a])})

`,\n )\n .join(\"\");\n return `${escapeHtml(c.username)}'s Character

${escapeHtml(c.username)}

Level ${c.level} ${escapeHtml(formatRaceName(c.race, c.subrace))} ${escapeHtml(c.cls)}

HP: ${c.hpCurrent}/${c.hpMax} | Speed: ${c.speed} ft | Proficiency: +${c.proficiency}

${statLine}

Traits: ${c.traits.map(escapeHtml).join(\", \")}

`;\n}\n\n// Not currently wired to any route — the activity log is only exposed via\n// the in-chat !logs command, which is scoped to one channel and restricted\n// to that channel's broadcaster/moderators. Kept here in case an\n// authenticated (per-channel, per-steward) web view is added later; do not\n// route this to a public GET endpoint without adding auth + per-channel scoping.\nexport function renderLogsPage(rows: any[]) {\n const lines = rows\n .map(\n (r: any) =>\n `${escapeHtml(new Date(Number(r.created_at)).toLocaleString())}${escapeHtml(r.username || \"unknown\")}${escapeHtml(r.broadcaster_id || \"\")}${escapeHtml(r.action || \"\")}${escapeHtml(r.detail || \"\")}`,\n )\n .join(\"\");\n return `

GuildScribe Activity Logs

Recent bot activity with timestamps, Twitch usernames, channels, and command details.

Back to guide · Bot home

${lines || ``}

Timestamp	Username	Channel ID	Action	Details
No activity recorded yet.

`;\n}\n\nfunction renderMapTemplateList(): string {\n return Object.values(MAP_TEMPLATES)\n .map(\n (t) =>\n `

${escapeHtml(t.name)} — ${escapeHtml(t.label)} (${t.width}x${t.height}): ${escapeHtml(t.description)}

`,\n )\n .join(\"\");\n}\n\nexport function renderGuidePage() {\n return `

Guild hall · D&D 5e

GuildScribe Codex

Welcome to the guild hall. Herein lie the rites of character, company, dice, duels, and the archives of the SRD.

Raise your banner Support the Guild Privacy Terms

Entering the hall: Grant the scribes a voice with /mod GuildScribeBot, then use !help for the welcome guide or !dndbothelp to browse this reference from chat.

Adventurer’s parchment

Create and view

!newchar

Start a guided chat wizard. Reply with !answer <choice> to select a race, subrace, class, and ability scores. Use !cancel to abandon the wizard mid-way.

!bg3

Rolls a random Baldur's Gate 3 style race and class, then lets you assign ability scores under BG3 point-buy rules (base 8, cap 15, 27-point budget) with !answer <STR> <DEX> <CON> <INT> <WIS> <CHA>. Confirm with !answer yes to save it as your character and get a link to its page. Use !cancel to abandon.

!createchar

Immediately create a level 1 character.

!createchar @username

Broadcaster/moderator only: create a level 1 character for someone else, such as for a viewer who can't chat directly.

!char!char @username

Display your current character summary, or view another player’s saved character.

You keep exactly one active character and one saved backup per channel. If you already have an active character, !createchar, !newchar, and !bg3 will warn you and ask you to confirm with !answer yes before overwriting it.

Manage progress

!levelup!levelup +2!levelup -1

Adjust levels from 1 through 20. HP maximum, current HP, and proficiency are recalculated.

!hp +5!hp -3

Adjust current HP within the character’s valid range.

Save and restore

!savechar!loadchar!resetchar

Save a backup, restore the latest backup, or reset your character.

Fate’s dice

!d20!d20 @username!roll!r

Call upon the D20 of Fate. Use !d20 @username to roll for another adventurer.

!roll NdS[+/-M]

Roll a custom dice expression, such as !roll 1d20+5, !roll 2d6, or !roll 4d8-2.

!roll @username [NdS[+/-M]]

Roll on behalf of someone else in chat, such as !roll @friend or !roll @friend 2d6+3. Anyone can do this.

!roll dex!roll strength

Ability saving throw. Uses your saved character's ability modifier, plus proficiency if your class is proficient in that save. Works with abbreviations (str, dex, con, int, wis, cha) or full names.

!roll stealth!roll animal handling

Skill check. Uses your saved character's modifier for that skill's governing ability. Add @username to roll using someone else's saved character, e.g. !roll @friend perception.

!roll <question>?

Consult fate for a yes-or-no verdict, delivered with a random D&D-flavored omen (natural 20s, Augury, a beholder's judgment, the Deck of Many Things, and more). Example: !roll is enya going to die this time?

!oracle <question>

The oracle answers by naming a random recently-active chatter instead of yes/no, e.g. !oracle who should stream next? Draws from chatters who've used a bot command recently in this channel.

Baldur's Gate 3

Roll a character (saved)

!bg3

Rolls a random BG3-style race and class, then lets you assign ability scores under BG3 point-buy rules (base 8, cap 15, 27-point budget) with !answer <STR> <DEX> <CON> <INT> <WIS> <CHA>. Confirm with !answer yes to save it as your character and get a link to its page — see Adventurer's parchment for the rest of the character commands.

Roll a character (flavor only)

!bg3roll

Rolls a full BG3-flavored character in one line: race (with subrace where BG3 has one, like High Elf or Lolth-Sworn Drow), class and subclass, background, alignment, a BG3-style 27-point point-buy ability spread weighted toward the class's primary stat, and a one-line origin hook straight off the Nautiloid.

Companion & origin

!bg3companion

Rolls which BG3 companion you're traveling with — their role, a one-line personality blurb, and an iconic line.

!bg3origin

Casts you as one of the six canonical BG3 Origin Characters — or the Dark Urge — for this run, with their signature hook.

Loot & camp

!bg3loot

Rolls a random magic item drop with a BG3-style rarity tier, from Common up through Legendary.

!bg3camp

Rolls a random camp-night vignette featuring one of the companions.

Knowledgebase

!bg3lookup <name>

Searches a hand-curated Baldur's Gate 3 knowledgebase — companions, origins, classes, races, locations, factions, deities, notable villains, and legendary items — and returns a short blurb with a link to bg3.wiki. Examples: !bg3lookup astarion, !bg3lookup moonrise towers.

!bg3lookup <category> <name>

Narrow the search to one category, e.g. !bg3lookup faction zhentarim or !bg3lookup location grymforge. A bare !bg3lookup lists all recognized categories.

!bg3roll, !bg3companion, !bg3origin, !bg3loot, and !bg3camp are flavor rolls only — they print straight to chat and aren't saved, and none of them touch your !createchar/!char sheet. !bg3 is different — it saves a real character (see the parchment section above). !bg3lookup is also different: it's a reference lookup against the static knowledgebase above, not a roll, so the same query always returns the same entry.

Guild archives

Consult the SRD archives by name. Optional +N upcasts a spell or adds an item attack/damage bonus. Incomplete commands (e.g. bare !rules) return usage tips.

Spells, classes & rules

!rules <topic>!rule <topic>

Summarize a rule (up to 3 messages) with a public link. Examples: !rules magic, !rules combat, !rule advantage.

!spell <spell> [+N]

Shows level, school, casting details, range, duration, components, damage dice, damage type, save, area, classes, and higher-level scaling.

!class <class> [+N]

Shows Hit Die, saving throws, and proficiencies.

!feat <feat> [+N]

Shows prerequisites and the feat description.

Equipment and abilities

!item <item> [+N]

Shows weapon damage, type, range, weight, cost, armor class, properties, and modifier.

!ability <ability> [+N]

Shows the ability score, related skills, and description.

Races

!race <race> [+N]

Shows ability bonuses, speed, size, languages, and racial traits.

!subrace <subrace> [+N]

Shows subrace bonuses, parent race, speed, languages, and traits.

Arena, wilds & the company

A moderator or the broadcaster starts and manages the encounter; any adventurer can roll their own initiative once it's started. Duels and hunts are open to any adventurer with a saved character.

!turn start!turn roll!turn add <name> <initiative>!turn show!turn next!turn prev!turn remove <name>!turn end

!turn start opens the roll window; players call !turn roll to roll 1d20 plus their character's DEX modifier for initiative (each player rolls once per encounter). Moderators can still !turn add monsters, NPCs, or manual scores. The tracker stores one encounter per connected channel, sorts combatants from highest to lowest initiative, shows the active combatant with an arrow, and advances the round automatically.

Parties

!party create <name>!party join <name>!party invite @user [name]!party accept [name]!party decline [name]!party list [name]

!party list shows each of your companies with leader and members. An invite only adds someone once they !party accept it — the party name is optional if they only have one pending invite.

!party leave <name>!party disband <name>

Create a party (you become leader and member), invite friends, and list rosters. Party name is optional on invite if you only belong to one party.

Player duels & hunts

Auto challenges resolve when accepted. Classic modes use turn-based attack. Solo !dndduel fights a level-scaled monster (auto); !dndduel monster is classic. Party hunts fight a shared monster and award XP on victory. PvP gives no XP. A pending challenge (accept/decline) expires after 5 minutes if unanswered. Any active classic duel — 1v1, party vs. party, or a hunt — auto-forfeits to the non-idle side after 10 minutes of inactivity, so a duel left mid-fight overnight won't block that channel's dueling next stream.

Custom commands & triggers

Broadcasters and moderators can add their own commands and passive keyword auto-responses right from chat — no code required. These share the !dndbot word used for bot settings below, but different subcommands, so nothing collides. list is open to everyone; the rest are mod/broadcaster only.

!dndbot add <name> <response>!dndbot edit <name> <response>!dndbot remove <name>!dndbot cooldown <name> <seconds>!dndbot list

Creates !<name> as a new chat command. Built-in command names can't be used or overridden.

!trigger add <keyword> <response>!trigger remove <keyword>!trigger cooldown <keyword> <seconds>!trigger list

Fires the response automatically whenever <keyword> appears in chat (no ! needed to trigger it) — wrap multi-word keywords in quotes, e.g. !trigger add \"good luck\" May the dice favor you!

Responses can use {user}, {target} (first @mention, commands only), {count} (times used), and {random:a|b|c} to pick one option at random. Each channel has a cap on the number of custom commands/triggers and a default cooldown to prevent spam.

Battle maps

Create & view

!map create <name> [WxH] [template]

Mod/broadcaster only. Makes a new grid map (default 10x8, up to 20x20), starting as all grass — or stamped with a template's terrain if you name one, e.g. !map create tav1 tavern or !map create tav1 14x10 tavern.

!map list!map view <name>

List every map in the channel, or post a link to one — the map page is a live, auto-refreshing visual grid.

!map delete <name>!map remove <name>

Mod/broadcaster only. Deletes the map along with its terrain and every character token on it — this can't be undone.

Templates

!map templates

Lists every ready-made layout you can stamp onto a new map with !map create <name> [WxH] <template>. A template sets its own default size (overridable) and pre-paints walls, doors, hazards, and features — a starting point you can still touch up with !map paint/!map fill afterward.

${renderMapTemplateList()}

Edit the terrain

!map terrains

Lists every terrain type (grass, forest, water, sand, mountain, road, floor, wall, door, trap, lava, void) — some, like water/wall/mountain/lava/void, block tokens from standing there.

!map fill <name> <terrain>

Mod/broadcaster only. Resets the whole grid to one terrain.

!map paint <name> <x> <y> <terrain>

Mod/broadcaster only. Sets a single cell, e.g. !map paint dungeon1 4 2 wall. Coordinates start at (1,1) in the top-left.

Place & move characters

!map addchar <name> [x y]

Puts your saved character on the map, at the coordinates you give or the first free cell otherwise.

!map addchar <name> @user [x y]

Mod/broadcaster only: place someone else's character.

!map move <name> <x> <y>!map move <name> @user <x> <y>

Move a token; the second form (moving someone else) is mod/broadcaster only.

!map removechar <name> [@user]

Take a character off the map.

Map creation, terrain painting, and moving someone else's token are restricted to the broadcaster/moderators, the same as the rest of the guild's shared state; everyone can place and move their own character.

Onboarding and support

In chat

!help

Welcome to the guild hall and a path to begin your legend.

!guide!link

Post the Guild Codex URL in chat.

!dndbothelp

List codex chapters.

Expand one of: !dndbothelp dice, !dndbothelp character, !dndbothelp party, !dndbothelp combat, !dndbothelp lookup, !dndbothelp settings.

Connect and support

Use the onboarding page to connect a Twitch channel. After connecting, run /mod GuildScribeBot in that channel.

Already connected? Reconnect your channel any time to grant newly requested permissions as GuildScribe gains features — safe to run repeatedly, and won't duplicate or lose your existing data.

Support the project through the donations page.

Moderators can review recent activity for their channel with !logs in chat.

Guild stewards (mod/broadcaster)

!dndbot on!dndbot off!dndbot status!dndbot leave!dndbot leave purge

Enable/disable the bot. The broadcaster can disconnect with !dndbot leave; add purge to delete channel data.

!market on!market off!market status

Off by default. Toggles a threadbare open-stall merchant who drops by the channel every so often (interval randomized per channel) with a one-line D&D-flavored sales pitch for some cheap, secondhand good. Purely flavor — no coin, inventory, or character state involved. status is open to everyone; on/off are mod/broadcaster only.

GuildScribe provides reference and gameplay utilities. Always verify rules, character choices, and wallet details before acting.

`;\n}\n\n// ── Battle maps ──\n\nexport function renderMapPage(map: MapRow, cells: Record, tokens: MapToken[], baseUrl: string) {\n const cellPx = map.width > 16 || map.height > 16 ? 28 : 36;\n const byCell = new Map(tokens.map((t) => [`${t.x},${t.y}`, t]));\n let gridCells = \"\";\n for (let y = 1; y <= map.height; y++) {\n for (let x = 1; x <= map.width; x++) {\n const terrain = cells[`${x},${y}`] ?? map.default_terrain;\n const info = TERRAINS[terrain] ?? TERRAINS.grass;\n const token = byCell.get(`${x},${y}`);\n const initials = token ? escapeHtml((token.display_name || token.username).slice(0, 2).toUpperCase()) : \"\";\n const tokenHtml = token\n ? `

${initials}

`\n : \"\";\n gridCells += `

${tokenHtml}

`;\n }\n }\n const legend = Object.entries(TERRAINS)\n .map(([k, v]) => `${escapeHtml(v.label)}${v.blocksMovement ? \" 🚫\" : \"\"}`)\n .join(\"\");\n const roster = tokens.length\n ? `

${escapeHtml(t.display_name || t.username)} — (${t.x},${t.y})

`\n : `

No characters placed yet. In chat: !map addchar ${escapeHtml(map.map_name)}

`;\n return `${escapeHtml(map.map_name)} — GuildScribe Map

← All maps

🗺️ ${escapeHtml(map.map_name)}

${map.width}×${map.height} — updated ${escapeHtml(new Date(map.updated_at).toLocaleString())}. This page auto-refreshes every 15s.

${gridCells}

${legend}

Characters on this map

${roster}

Edit from Twitch chat: !map paint ${escapeHtml(map.map_name)} x y terrain · !map addchar ${escapeHtml(map.map_name)} · !map move ${escapeHtml(map.map_name)} x y · !map removechar ${escapeHtml(map.map_name)} · full list: !dndbothelp maps

`;\n}\n\nexport function renderMapListPage(maps: MapRow[], broadcasterId: string, baseUrl: string) {\n const items = maps.length\n ? `

${escapeHtml(m.map_name)} (${m.width}×${m.height})

`\n : `

No maps yet. In chat, a moderator can start one with !map create <name> [WxH].

`;\n return `Maps — GuildScribe

🗺️ Maps in this channel

${items}

See !dndbothelp maps in chat for the full command list.

`;\n}\n",[181],"828d1af9-78d8-4258-a869-7f569ff6bfd5","oracle.ts","e8331594-ad80-11f1-855e-1607ee4eb77e",344,["D",1789090458805],"// !oracle — like !roll's fate verdict (see utils.ts rollFate),\n// but instead of a YES/NO the \"answer\" is a randomly-chosen recent chatter.\n//\n// !oracle anyone — e.g. !oracle who should stream next?\n//\n// The chatter pool comes from activity_logs (people who've used a bot\n// command recently in this channel — see getRecentChatters in db.ts), not a\n// live Twitch chatters-list call, so this needs no new OAuth scope and no\n// re-auth for existing connected channels.\n\nimport { sendChatMessage } from \"./twitch.ts\";\nimport { getRecentChatters } from \"./db.ts\";\nimport { rollOracle } from \"./utils.ts\";\n\nconst MIN_QUESTION_LEN = 2;\n\nexport async function handleOracleCommand(\n chatMessage: string,\n chatter: string,\n display: string,\n broadcasterId: string,\n): Promise {\n const match = chatMessage.match(/^!oracle(?:\\s+([\\s\\S]+))?$/i);\n if (!match) return false;\n\n const question = (match[1] ?? \"\").trim();\n if (question.length < MIN_QUESTION_LEN) {\n await sendChatMessage(`@${display} ask the oracle something, e.g. !oracle who should stream next?`, broadcasterId);\n return true;\n }\n\n // Recently-active chatters, most-recent first; the asker themselves is a\n // fair pick too (they're part of \"recent chatters\"), so no self-exclusion.\n // A DB hiccup here falls back to the asker rather than going silent — a\n // Twitch command should always say *something* back.\n let pool: string[] = [];\n try {\n pool = await getRecentChatters(broadcasterId, 50);\n } catch (e) {\n console.error(\"getRecentChatters failed\", e);\n pool = [chatter];\n }\n if (pool.length === 0) {\n await sendChatMessage(\n `@${display} the oracle is silent — no chatters have stirred yet in this channel.`,\n broadcasterId,\n );\n return true;\n }\n\n const chosen = pool[Math.floor(Math.random() * pool.length)];\n await sendChatMessage(`@${display} ${rollOracle(question, chosen)}`, broadcasterId);\n return true;\n}\n",[189],"f259971c-e80d-42e4-bc88-57840ed139be","merchant.ts","cc75f16a-a979-11f1-8338-1607ee4eb77e",287,["D",1788647599816],"// The open-stall merchant — a threadbare traveling peddler who periodically\n// sets up shop in the market square and hawks a random, humble bit of\n// D&D-flavored goods. Off by default per channel; toggled with !market.\n//\n// Posting is driven by merchant.cron.ts, which polls merchant_settings for\n// channels that are due (see db.ts's getDueMerchantChannels). Interval\n// randomization lives here so both the toggle command (first post) and the\n// cron (every post after) reschedule the same way.\n\nimport { isMerchantEnabled, setMerchantEnabled } from \"./db.ts\";\nimport { sendChatMessage } from \"./twitch.ts\";\nimport { pick } from \"./utils.ts\";\n\nconst MIN_INTERVAL_MINUTES = Math.max(5, Number(Deno.env.get(\"MERCHANT_MIN_INTERVAL_MINUTES\") ?? \"25\"));\nconst MAX_INTERVAL_MINUTES = Math.max(MIN_INTERVAL_MINUTES, Number(Deno.env.get(\"MERCHANT_MAX_INTERVAL_MINUTES\") ?? \"60\"));\n\n/** A fresh randomized gap (ms) until the merchant's next ad, per channel. */\nexport function randomMerchantIntervalMs(): number {\n const minMs = MIN_INTERVAL_MINUTES * 60_000;\n const maxMs = MAX_INTERVAL_MINUTES * 60_000;\n return minMs + Math.floor(Math.random() * (maxMs - minMs + 1));\n}\n\n// A different threadbare peddler each time — this is a traveling open stall,\n// not a single recurring shopkeeper.\nconst MERCHANT_NAMES: string[] = [\n \"Wobble\",\n \"Pruneface Yorik\",\n \"Tansy Ninefingers\",\n \"Bregga Stumpteeth\",\n \"Old Corrin\",\n \"Widow Hesk\",\n \"Tam Pockets\",\n \"Fenwick Loose-Coin\",\n \"Marda the Reformed Cutpurse\",\n \"Grithnall the Threadbare\",\n \"Squint\",\n \"Nan Gullyfoot\",\n \"Ossop the Unlucky\",\n \"Beren Halfcoat\",\n \"Ivy Scraptongue\",\n \"Doras Milkbeard\",\n \"Kettle\",\n \"Ruel Tinkpocket\",\n \"Sella Windrags\",\n \"Podge Ashborn\",\n \"Uther Nine-Debts\",\n];\n\n// Scene-setting openers. Each is a function of the merchant's name so the\n// same line never reads twice the same way in a row.\nconst MERCHANT_INTROS: Array<(name: string) => string> = [\n (name) => `${name} unrolls a threadbare blanket in the market square and calls out to passersby.`,\n (name) => `A modest stall creaks open as ${name} arranges a few sorry-looking wares.`,\n (name) => `${name} waves down the crowd from behind an upturned crate.`,\n (name) => `From a stall held together with string and hope, ${name} shouts over the market din.`,\n (name) => `${name} counts the coins in an otherwise empty pouch, then brightens as adventurers pass by.`,\n (name) => `A patched tarp flaps over ${name}'s corner of the market — business as usual.`,\n (name) => `${name} dusts off the one good item on the table and grins hopefully.`,\n (name) => `The market square gains one more voice as ${name} sets up shop between the baker and the tanner.`,\n (name) => `${name} leans on a wobbly table and clears their throat for the day's pitch.`,\n (name) => `A hand-lettered sign reading \"HONEST GOODS (MOSTLY)\" hangs crooked over ${name}'s stall.`,\n (name) => `${name} nudges a stray chicken off the merchandise before the crowd arrives.`,\n (name) => `Between two grander stalls, ${name} makes do with a barrel and a prayer.`,\n (name) => `${name} rings a cracked bell to announce the stall is, once again, open for business.`,\n (name) => `A patched umbrella shades ${name}'s wares from the midday sun — most of them, anyway.`,\n (name) => `${name} straightens a lopsided display and calls out with practiced optimism.`,\n (name) => `Coins jingle — just one or two — in ${name}'s apron as the stall opens.`,\n (name) => `${name} has set up shop again, same corner, same crate, same hopeful smile.`,\n (name) => `A modest banner (really just a dyed sack) marks ${name}'s stall in the square.`,\n (name) => `${name} waves an adventurer over before the competition can.`,\n (name) => `The smell of yesterday's stew clings to ${name}'s stall as the day's goods go on display.`,\n (name) => `${name} arranges the wares by \"most impressive\" first, \"please just buy something\" last.`,\n];\n\ninterface MerchantItem {\n desc: string;\n price: string;\n}\n\n// Cheap, secondhand, unmistakably D&D-flavored goods — nothing a wealthy\n// merchant would bother stocking.\nconst MERCHANT_ITEMS: MerchantItem[] = [\n { desc: \"a dented tin flask that swears it once held dragon's-breath brandy\", price: \"3 copper\" },\n { desc: \"a bundle of chalk sticks for warding sigils, mostly unbroken\", price: \"2 copper\" },\n { desc: \"one (1) lucky rabbit's foot, still faintly twitching\", price: \"5 copper\" },\n { desc: \"a cracked scrying mirror that only ever shows yesterday\", price: \"1 silver\" },\n { desc: \"a moth-eaten cloak that almost passes for 'mysterious'\", price: \"4 copper\" },\n { desc: \"a coil of rope, guaranteed to hold at least one goblin\", price: \"6 copper\" },\n { desc: \"a jar of pickled owlbear whiskers (for luck, allegedly)\", price: \"8 copper\" },\n { desc: \"a half-melted candle that burns a suspicious shade of blue\", price: \"1 copper\" },\n { desc: \"a set of loaded dice, badly loaded — they just roll off the table\", price: \"2 copper\" },\n { desc: \"a rusty holy symbol of a god nobody quite remembers anymore\", price: \"3 copper\" },\n { desc: \"a whittled wooden dagger, purely for show — please don't stab anyone\", price: \"1 copper\" },\n { desc: \"a satchel of trail rations that are 'mostly' still rations\", price: \"5 copper\" },\n { desc: \"a single boot, left foot, very fine make\", price: \"2 copper\" },\n { desc: \"a vial of river water that 'might' be enchanted\", price: \"4 copper\" },\n { desc: \"a scorched spellbook page with half a fireball recipe on it\", price: \"7 copper\" },\n { desc: \"a tarnished brass compass that always points toward the nearest tavern\", price: \"3 copper\" },\n { desc: \"a sack of glass beads, sold in good faith as 'gnomish gemstones'\", price: \"6 copper\" },\n { desc: \"a patchwork healer's kit missing only the important bits\", price: \"9 copper\" },\n { desc: \"a caged cricket claimed to grant wishes if fed enough\", price: \"2 copper\" },\n { desc: \"a hand-me-down shield, already dented — someone else did the work for you\", price: \"1 silver 2 copper\" },\n { desc: \"a coil of faintly glowing string, source unknown, no refunds\", price: \"5 copper\" },\n { desc: \"a stack of 'authentic' dragon scales (dyed lizard, don't tell anyone)\", price: \"4 copper\" },\n];\n\n// Self-deprecating, humble-peddler closing lines — the merchant is not\n// wealthy, and knows it.\nconst MERCHANT_CLOSERS: string[] = [\n \"Barely a profit in it, but a sale's a sale.\",\n \"Haggle if you must — there's a family of stirges to feed.\",\n \"No refunds. No guarantees. Mostly no regrets.\",\n \"Buy two and get a compliment thrown in, free of charge.\",\n \"It's not much, but it's honest work. Mostly.\",\n \"Coin now, questions later.\",\n \"Would charge more if anyone actually thought it was worth more.\",\n \"Every copper helps keep this stall standing another day.\",\n \"Guaranteed authentic, or at least authentically old.\",\n \"First to haggle gets a suspicious wink, free of charge.\",\n \"Trade accepted. Chickens, mostly.\",\n \"Sold worse for more before, so this one's a bargain, really.\",\n \"Buyer beware, seller broke.\",\n \"One copper off if you laugh at the jokes.\",\n \"The stall roof leaks, but the prices don't.\",\n \"Not much to look at, but neither is the merchant, and they get by.\",\n \"Consider it an investment in someone else's bad decisions.\",\n \"Happy to wrap it, if old newspaper doesn't offend.\",\n \"Money's money, even when it's mostly copper.\",\n \"Step lively — the town guard doesn't love where this cart is parked.\",\n \"A deal like this doesn't come around twice. Mostly because there was only one.\",\n \"Not a fortune to be made here, just enough for supper.\",\n];\n\n/** One full merchant sales-pitch ad, ready to post to chat. */\nexport function generateMerchantAd(): string {\n const name = pick(MERCHANT_NAMES);\n const intro = pick(MERCHANT_INTROS)(name);\n const item = pick(MERCHANT_ITEMS);\n const closer = pick(MERCHANT_CLOSERS);\n return `🛒 ${intro} Today's find: ${item.desc} — ${item.price}. ${closer}`;\n}\n\n/** Handles !market on | off | status. Returns true if the message matched. */\nexport async function handleMerchantCommand(\n chatMessage: string,\n display: string,\n broadcasterId: string,\n isModerator: boolean,\n): Promise {\n const match = chatMessage.trim().match(/^!market\\s+(on|off|status)$/i);\n if (!match) return false;\n const action = match[1].toLowerCase();\n\n if (action === \"status\") {\n const enabled = await isMerchantEnabled(broadcasterId);\n await sendChatMessage(\n `@${display} The open-stall merchant is currently ${\n enabled ? \"hawking wares in this channel\" : \"packed up and gone from this channel\"\n }. Toggle with !market on or !market off (mod only).`,\n broadcasterId,\n );\n return true;\n }\n\n if (!isModerator) {\n await sendChatMessage(\n `@${display} only the broadcaster or a moderator can toggle the market stall.`,\n broadcasterId,\n );\n return true;\n }\n\n const enabled = action === \"on\";\n await setMerchantEnabled(broadcasterId, enabled, enabled ? Date.now() + randomMerchantIntervalMs() : null);\n await sendChatMessage(\n enabled\n ? `@${display} A threadbare peddler has claimed a corner of the market square and will drop by every so often with a sales pitch — small goods, smaller prices, no guild coin required.`\n : `@${display} The market stall has packed up and left this channel. Fewer bargains, but also fewer suspicious dice.`,\n broadcasterId,\n );\n return true;\n}\n",[196],"bfccf284-cbd7-44ff-9f6d-48afabbe8031","merchant.cron.ts","cbaad778-a979-11f1-80cf-1607ee4eb77e",315,["D",1788911482386],2,"interval","// GuildScribe — open-stall merchant, periodic posting.\n// Val Town CRON TRIGGER. Set the schedule in the Val Town UI; every 5-10\n// minutes is a good tick rate. The actual per-channel posting cadence is\n// randomized (see MERCHANT_MIN/MAX_INTERVAL_MINUTES in merchant.ts) and\n// tracked per-broadcaster in the merchant_settings table via next_post_at,\n// so a frequent tick here just checks who's due rather than posting on\n// every run.\n//\n// Every tick's outcome (channels due, posts sent, posts failed, last error)\n// is written to merchant_cron_status via recordMerchantCronRun, readable at\n// GET /admin/merchant/status (see main.ts) without needing to dig through\n// Val Town's run history or the raw monitor_events table.\n\nimport {\n ensureTables,\n getDueMerchantChannels,\n recordMerchantCronRun,\n recordMonitorEvent,\n rescheduleMerchant,\n} from \"./db.ts\";\nimport { sendChatMessage } from \"./twitch.ts\";\nimport { generateMerchantAd, randomMerchantIntervalMs } from \"./merchant.ts\";\n\nexport default async function () {\n await ensureTables();\n const now = Date.now();\n const due = await getDueMerchantChannels(now);\n\n let postsOk = 0;\n let postsFailed = 0;\n let lastError: string | null = null;\n\n for (const broadcasterId of due) {\n try {\n await sendChatMessage(generateMerchantAd(), broadcasterId);\n postsOk++;\n } catch (e) {\n postsFailed++;\n lastError = `${broadcasterId}: ${String(e)}`;\n // console.error (not console.log) so it's visible in Val Town's run\n // history at a glance, in addition to the persisted DB record below.\n console.error(\n `GuildScribe merchant cron: failed to post to ${broadcasterId}:`,\n e,\n );\n await recordMonitorEvent(\"merchant_post_error\", lastError);\n }\n // Always reschedule, even on a send failure, so one bad channel can't\n // wedge the cron into retrying it every tick forever.\n try {\n await rescheduleMerchant(broadcasterId, now + randomMerchantIntervalMs());\n } catch (e) {\n // Rescheduling is what prevents a retry storm, so a failure here is\n // worth its own alarm even if the post itself succeeded.\n const detail = `${broadcasterId}: ${String(e)}`;\n console.error(\n `GuildScribe merchant cron: failed to reschedule ${broadcasterId}:`,\n e,\n );\n await recordMonitorEvent(\"merchant_reschedule_error\", detail);\n postsFailed++;\n lastError = detail;\n }\n }\n\n await recordMerchantCronRun(now, due.length, postsOk, postsFailed, lastError);\n\n const summary =\n `GuildScribe merchant cron: ${due.length} channel(s) due, ${postsOk} posted, ${postsFailed} failed`;\n if (postsFailed > 0) {\n console.error(summary);\n } else {\n console.log(summary);\n }\n}",[203],"46a39247-7fc6-491f-88ab-87159927b1ec","maps.ts","a4656b02-a743-11f1-b2a7-1607ee4eb77e",238,["D",1788488650689],"// GuildScribe — battle maps\n//\n// Chat commands create/edit maps and place character tokens on them; a\n// public, read-only web page (see pages.ts / main.ts route \"/map\") renders\n// the grid visually. Editing (creating a map, painting terrain, deleting a\n// map, and moving someone else's token) stays behind Twitch chat identity\n// (chatterId, verified by EventSub) rather than an open web form — that\n// matches how every other piece of shared channel state in this bot\n// (parties, duels, the initiative tracker) is only ever mutated through an\n// authenticated chat command, never through an unauthenticated web request.\n\nimport { sendChatMessage } from \"./twitch.ts\";\nimport {\n createMap,\n deleteMap,\n fillMap,\n findTokenAt,\n getCharacter,\n getMap,\n getMapCells,\n getMapToken,\n getMapTokens,\n listMaps,\n removeMapToken,\n setMapCell,\n upsertMapToken,\n} from \"./db.ts\";\n\n// ── Map templates ──\n//\n// Publicly listable (!map templates), publicly usable (!map create \n// [WxH]

${escapeHtml(c.username)}

GuildScribe Activity Logs

GuildScribe Codex

Adventurer’s parchment

Create and view

Manage progress

Save and restore

Fate’s dice

Baldur's Gate 3

Roll a character (saved)

Roll a character (flavor only)

Companion & origin

Loot & camp

Knowledgebase

Guild archives

Spells, classes & rules

Equipment and abilities

Races

Arena, wilds & the company

Parties

Player duels & hunts

Custom commands & triggers

Battle maps

Create & view

Templates

Edit the terrain

Place & move characters

Onboarding and support

In chat

Connect and support

Guild stewards (mod/broadcaster)

🗺️ ${escapeHtml(map.map_name)}

Characters on this map

🗺️ Maps in this channel

GuildScribe Privacy Policy

How it is used

Retention

Deletion

GuildScribe Terms of Service

GuildScribe Codex

Support the Guild

Ethereum (ETH)

Bitcoin (BTC)

Connection cancelled

The Guild renews your banner

The Guild accepts your banner

Connection failed

Sign-in cancelled

Sign-in failed

GuildScribe

Hi

Diff · v352