[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_333":334,"_335":336},"routes/_app.x.$handle.$name",{"_96":95,"_31":43,"_105":86,"_26":51,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":122,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",161,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","bg3.ts","latestPath","fileId","2b7b4992-a5bc-11f1-bb83-1607ee4eb77e","name","fileType","script","content","// Baldur's Gate 3 flavored random character roll — !bg3roll\n//\n// Standalone generator: no DB, no external lookups. Produces a BG3-style\n// race/subrace, class/subclass, background, alignment, a 27-point BG3-style\n// point buy (base 8, cap 15, weighted toward the class's primary ability),\n// and a one-line flavor hook, formatted as a single chat message.\n\nimport type { Ability } from \"./types.ts\";\nimport { pick, modifier } from \"./utils.ts\";\n\ninterface Bg3RaceEntry {\n name: string;\n subraces?: string[];\n}\n\nconst BG3_RACES: Bg3RaceEntry[] = [\n { name: \"Human\" },\n { name: \"Githyanki\" },\n { name: \"Half-Orc\" },\n { name: \"Elf\", subraces: [\"High Elf\", \"Wood Elf\"] },\n { name: \"Drow\", subraces: [\"Lolth-Sworn\", \"Seldarine\"] },\n { name: \"Half-Elf\", subraces: [\"High Half-Elf\", \"Wood Half-Elf\", \"Drow Half-Elf\"] },\n { name: \"Dwarf\", subraces: [\"Gold Dwarf\", \"Shield Dwarf\"] },\n { name: \"Halfling\", subraces: [\"Lightfoot\", \"Strongheart\"] },\n { name: \"Gnome\", subraces: [\"Forest Gnome\", \"Rock Gnome\", \"Deep Gnome\"] },\n { name: \"Tiefling\", subraces: [\"Asmodeus\", \"Mephistopheles\", \"Zariel\"] },\n { name: \"Dragonborn\" },\n];\n\ninterface Bg3ClassEntry {\n name: string;\n primaryAbility: Ability;\n subclasses: string[];\n}\n\nconst BG3_CLASSES: Bg3ClassEntry[] = [\n { name: \"Barbarian\", primaryAbility: \"STR\", subclasses: [\"Berserker\", \"Wildheart\", \"Wild Magic\"] },\n { name: \"Bard\", primaryAbility: \"CHA\", subclasses: [\"College of Lore\", \"College of Valour\", \"College of Swords\"] },\n { name: \"Cleric\", primaryAbility: \"WIS\", subclasses: [\"Life Domain\", \"Light Domain\", \"Trickery Domain\", \"War Domain\"] },\n { name: \"Druid\", primaryAbility: \"WIS\", subclasses: [\"Circle of the Land\", \"Circle of the Moon\", \"Circle of the Spores\"] },\n { name: \"Fighter\", primaryAbility: \"STR\", subclasses: [\"Champion\", \"Battle Master\", \"Eldritch Knight\"] },\n { name: \"Monk\", primaryAbility: \"DEX\", subclasses: [\"Way of the Open Hand\", \"Way of Shadow\", \"Way of the Four Elements\"] },\n { name: \"Paladin\", primaryAbility: \"STR\", subclasses: [\"Oath of Devotion\", \"Oath of the Ancients\", \"Oath of Vengeance\"] },\n { name: \"Ranger\", primaryAbility: \"DEX\", subclasses: [\"Hunter\", \"Beast Master\", \"Gloom Stalker\"] },\n { name: \"Rogue\", primaryAbility: \"DEX\", subclasses: [\"Thief\", \"Assassin\", \"Arcane Trickster\"] },\n { name: \"Sorcerer\", primaryAbility: \"CHA\", subclasses: [\"Draconic Bloodline\", \"Wild Magic\", \"Storm Sorcery\"] },\n { name: \"Warlock\", primaryAbility: \"CHA\", subclasses: [\"The Fiend\", \"The Great Old One\", \"The Archfey\"] },\n {\n name: \"Wizard\",\n primaryAbility: \"INT\",\n subclasses: [\"Abjuration\", \"Conjuration\", \"Divination\", \"Enchantment\", \"Evocation\", \"Illusion\", \"Necromancy\", \"Transmutation\"],\n },\n];\n\nconst BG3_BACKGROUNDS = [\n \"Acolyte\", \"Charlatan\", \"Criminal\", \"Entertainer\", \"Folk Hero\",\n \"Guild Artisan\", \"Noble\", \"Outlander\", \"Sage\", \"Soldier\", \"Urchin\",\n];\n\nconst BG3_ALIGNMENTS = [\n \"Lawful Good\", \"Neutral Good\", \"Chaotic Good\",\n \"Lawful Neutral\", \"True Neutral\", \"Chaotic Neutral\",\n \"Lawful Evil\", \"Neutral Evil\", \"Chaotic Evil\",\n];\n\nconst BG3_FLAVOR_HOOKS = [\n \"Woke up on the Nautiloid with no memory of how they got there.\",\n \"Fled their homeland one step ahead of a bounty they never explained.\",\n \"Answered a job posting nailed to a tavern door in Baldur's Gate.\",\n \"Was cast out by their circle for reasons they still won't discuss.\",\n \"Owes a debt to someone in the Absolute's camp — and hasn't paid it.\",\n \"Followed a dream that led straight into a mind flayer ship.\",\n \"Was traveling to Baldur's Gate for entirely unrelated reasons.\",\n \"Lost a bet that ended with them on the wrong ship at the wrong time.\",\n \"Is hunting something — or someone — that slipped into the Sword Coast.\",\n \"Has a tadpole in their skull and increasingly fewer qualms about using it.\",\n];\n\nconst ABILITIES: Ability[] = [\"STR\", \"DEX\", \"CON\", \"INT\", \"WIS\", \"CHA\"];\n\n// Standard 5e/BG3 point-buy cost table: base score 8, cap 15, budget 27.\nconst POINT_BUY_COST: Record = {\n 8: 0, 9: 1, 10: 2, 11: 3, 12: 4, 13: 5, 14: 7, 15: 9,\n};\n\nfunction randInt(min: number, max: number): number {\n return Math.floor(Math.random() * (max - min + 1)) + min;\n}\n\n// Spends the 27-point budget across six abilities, biased toward the\n// class's primary ability (and a little toward CON) so the result reads\n// like a build a player might actually pick rather than pure noise.\nfunction rollPointBuyScores(primary: Ability): Record {\n const scores = { STR: 8, DEX: 8, CON: 8, INT: 8, WIS: 8, CHA: 8 } as Record;\n let budget = 27;\n\n const pool: Ability[] = [];\n for (const a of ABILITIES) {\n const weight = a === primary ? 4 : a === \"CON\" ? 2 : 1;\n for (let i = 0; i < weight; i++) pool.push(a);\n }\n for (let i = pool.length - 1; i > 0; i--) {\n const j = randInt(0, i);\n [pool[i], pool[j]] = [pool[j], pool[i]];\n }\n\n let idx = 0;\n let stall = 0;\n while (budget > 0 && stall < 200) {\n const ability = pool[idx % pool.length];\n idx++;\n const next = scores[ability] + 1;\n if (next > 15) {\n stall++;\n continue;\n }\n const cost = POINT_BUY_COST[next] - POINT_BUY_COST[scores[ability]];\n if (cost <= budget) {\n scores[ability] = next;\n budget -= cost;\n stall = 0;\n } else {\n stall++;\n }\n }\n return scores;\n}\n\n/** Rolls a full BG3-flavored character and formats it as one chat message. */\nexport function rollBG3Character(display: string): string {\n const raceEntry = pick(BG3_RACES);\n const race = raceEntry.subraces ? `${pick(raceEntry.subraces)} ${raceEntry.name}` : raceEntry.name;\n\n const classEntry = pick(BG3_CLASSES);\n const subclass = pick(classEntry.subclasses);\n const background = pick(BG3_BACKGROUNDS);\n const alignment = pick(BG3_ALIGNMENTS);\n const hook = pick(BG3_FLAVOR_HOOKS);\n const scores = rollPointBuyScores(classEntry.primaryAbility);\n\n const statLine = ABILITIES.map((a) => {\n const mod = modifier(scores[a]);\n return `${a} ${scores[a]}(${mod >= 0 ? \"+\" : \"\"}${mod})`;\n }).join(\" \");\n\n return (\n `@${display} 🎲 ${race} ${classEntry.name} (${subclass}) | ${background}, ${alignment} | ` +\n `${statLine} | ${hook}`\n );\n}\n","createdAt",["D",1788236302556],"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",1789587078639],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":53,"_101":102,"_103":24},"branch",{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"isOwned",523,"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",{"_41":42,"_31":43,"_36":328,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":329,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":330,"_80":331,"_82":332,"_84":24},"tree",[267,268,269,270,271,272,273,274,275,276,277,278,279,280,281],"files",[267,268,269,270,271,272,273,274,275,276,277,278,279,280,281],"counts",{"_256":59,"_257":252,"_258":59,"_259":260,"_261":262},"contents",[127,128,129,130,131,132,133,134,135,136,137,138,139,140,141],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_41":249,"_31":250,"_29":251,"_145":-5,"_39":40,"_38":252,"_147":122,"_36":253,"_13":59,"_32":20,"_34":254,"_23":24,"_151":-5,"_26":255},{"_41":242,"_31":243,"_29":244,"_145":-5,"_39":40,"_38":245,"_147":24,"_36":246,"_13":59,"_32":20,"_34":247,"_23":24,"_151":-5,"_26":248},{"_41":234,"_31":235,"_29":236,"_145":-5,"_39":40,"_38":237,"_147":24,"_36":238,"_13":239,"_32":20,"_34":240,"_23":24,"_151":-5,"_26":241},{"_41":231,"_31":27,"_29":30,"_145":-5,"_39":40,"_38":14,"_147":24,"_36":232,"_13":59,"_32":33,"_34":35,"_23":24,"_151":-5,"_26":233},{"_41":224,"_31":225,"_29":226,"_145":-5,"_39":40,"_38":227,"_147":24,"_36":228,"_13":158,"_32":33,"_34":229,"_23":24,"_151":-5,"_26":230},{"_41":216,"_31":217,"_29":218,"_145":-5,"_39":40,"_38":219,"_147":24,"_36":220,"_13":221,"_32":33,"_34":222,"_23":24,"_151":-5,"_26":223},{"_41":208,"_31":209,"_29":210,"_145":-5,"_39":40,"_38":211,"_147":24,"_36":212,"_13":213,"_32":33,"_34":214,"_23":24,"_151":-5,"_26":215},{"_41":201,"_31":202,"_29":203,"_145":-5,"_39":40,"_38":204,"_147":24,"_36":205,"_13":166,"_32":33,"_34":206,"_23":24,"_151":-5,"_26":207},{"_41":195,"_31":196,"_29":197,"_145":-5,"_39":40,"_38":158,"_147":122,"_36":198,"_13":59,"_32":20,"_34":199,"_23":24,"_151":-5,"_26":200},{"_41":187,"_31":188,"_29":189,"_145":-5,"_39":40,"_38":190,"_147":24,"_36":191,"_13":192,"_32":33,"_34":193,"_23":24,"_151":-5,"_26":194},{"_41":177,"_31":178,"_29":179,"_145":-5,"_39":40,"_38":180,"_147":24,"_36":181,"_13":182,"_32":183,"_34":184,"_23":24,"_151":185,"_26":186},{"_41":169,"_31":170,"_29":171,"_145":-5,"_39":40,"_38":172,"_147":24,"_36":173,"_13":174,"_32":33,"_34":175,"_23":24,"_151":-5,"_26":176},{"_41":161,"_31":162,"_29":163,"_145":-5,"_39":40,"_38":164,"_147":24,"_36":165,"_13":166,"_32":33,"_34":167,"_23":24,"_151":-5,"_26":168},{"_41":153,"_31":154,"_29":155,"_145":-5,"_39":40,"_38":156,"_147":24,"_36":157,"_13":158,"_32":33,"_34":159,"_23":24,"_151":-5,"_26":160},{"_41":142,"_31":143,"_29":144,"_145":-5,"_39":40,"_38":146,"_147":24,"_36":148,"_13":149,"_32":33,"_34":150,"_23":24,"_151":-5,"_26":152},"274f0195-1ab1-44b3-b996-e6963a0f0a46","utils.ts","7c7a4070-a4d9-11f1-90df-1607ee4eb77e","parentId",156,"latest",["D",1788232351805],5,"// 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: [\"The arena gates swing open.\", \"The gauntlet has been thrown.\", \"Fate calls for a showdown.\"],\n accept: [\"The crowd roars—the duel is on.\", \"Steel meets destiny.\", \"The initiative gods have been consulted.\"],\n decline: [\"The challenge fades into the tavern gossip.\", \"Wisdom wins this round.\", \"The duel is postponed by fate.\"],\n hit: [\"A clean strike finds its mark.\", \"That hit had advantage from destiny.\", \"The dice have chosen violence.\"],\n miss: [\"The attack misses wide; the boots remain unharmed.\", \"The blade finds only air.\", \"The dice requested a dramatic near miss.\"],\n critical: [\"A critical hit! The bards are taking notes.\", \"Natural twenty—legendary timing.\", \"The D20 of Fate has opened the vault.\"],\n defeat: [\"A character falls, but the story continues.\", \"The HP bar has entered the underworld.\", \"A dramatic collapse worthy of the final act.\"],\n victory: [\"Victory belongs to the last character standing.\", \"The winner claims the tavern bragging rights.\", \"The campaign chronicle gains a new legend.\"],\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 ]\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 ]\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 ]\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 ]\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 ];\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];\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];\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\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",[143],"19d4707b-d06d-4622-b4c8-555f2bc51e74","types.ts","760b7a24-a4d9-11f1-9139-1607ee4eb77e",146,["D",1788184662810],4,"// 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[] | null;\n};\n",[154],"c90bb3c1-94e6-44ee-aac7-c5411b5203d1","twitch.ts","9c5a8652-a4d9-11f1-b87e-1607ee4eb77e",144,["D",1788184662636],7,"// 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\nexport async function createChatSubscription(broadcasterId: string, callbackUrl: string) {\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: \"channel.chat.message\",\n version: \"1\",\n condition: {\n broadcaster_user_id: broadcasterId,\n user_id: env(\"TWITCH_BOT_ID\"),\n },\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: ${res.status} ${text}`);\n return JSON.parse(text).data[0];\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",[162],"945fca4c-50a2-4920-9381-d8bf1e3bfd22","pages.ts","a605108c-a4d9-11f1-a673-1607ee4eb77e",158,["D",1788232351779],11,"// 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\";\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\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.

!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.

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?

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

The initiative tracker is restricted to the broadcaster or a moderator. Duels and hunts are open to any adventurer with a saved character.

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

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.

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.

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.

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

`;\n}\n",[170],"22c8ec73-6797-4aaf-9672-0d2514a1ff8a","main.ts","6b349c48-a4d9-11f1-b9f9-1607ee4eb77e",159,["D",1788236302493],18,"http","// GuildScribe — Twitch D&D bot entry point\n// Val Town / Deno HTTP handler\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nimport {\n ensureTables,\n getCharacter,\n saveCharacter,\n adjustHp,\n backupCharacter,\n loadBackup,\n resetCharacter,\n getConnections,\n isChannelEnabled,\n setChannelEnabled,\n recordActivity,\n getRecentLogs,\n getBroadcaster,\n markBroadcasterDisconnected,\n disconnectBroadcasterData,\n purgeChannelData,\n isChannelBlocked,\n blockChannel,\n unblockChannel,\n recordMonitorEvent,\n checkCommandRateLimit,\n claimEventSubMessage,\n queueEventSubCancellation,\n getPendingEventSubCancellations,\n clearPendingEventSubCancellation,\n} from \"./db.ts\";\nimport {\n generateCharacter,\n handleCreationCommand,\n adjustLevel,\n} from \"./characters.ts\";\nimport {\n handleDuelCommand,\n handleMonsterDuelCommand,\n handlePartyCommand,\n handlePartyDuelCommand,\n handleInitiativeCommand,\n} from \"./combat.ts\";\nimport { lookup5e, formatSpellSections, formatLookup } from \"./lookups.ts\";\nimport {\n env,\n sendChatMessage,\n sendChatMessages,\n sendSpellSections,\n exchangeCode,\n createChatSubscription,\n verifyEventSub,\n deleteEventSubSubscription,\n} from \"./twitch.ts\";\nimport {\n formatRaceName,\n formatStatLine,\n escapeHtml,\n rollDice,\n rollFate,\n resolveCheckKind,\n modifier,\n isBotAccount,\n hasModeratorBadge,\n logRowText,\n} from \"./utils.ts\";\nimport { classes } from \"./data.ts\";\nimport { page, renderCharacterPage, renderGuidePage } from \"./pages.ts\";\nimport { rollBG3Character } from \"./bg3.ts\";\n\n// Public HTTP trigger URL for this val (used for guide links in chat).\n// OAuth redirects and character page links still use the request origin dynamically.\nconst PUBLIC_BASE_URL = Deno.env.get(\"PUBLIC_BASE_URL\") ?? \"https://StonedSheamus--6b349c48a4d911f1b9f91607ee4eb77e.web.val.run\";\n\n// Durable per-channel/user throttling is stored in SQLite so it survives restarts\n// and remains consistent if the deployment scales beyond one warm instance.\nconst COMMAND_COOLDOWN_MS = Math.max(250, Number(Deno.env.get(\"COMMAND_COOLDOWN_MS\") ?? \"1200\"));\n\nasync function retryPendingEventSubCancellations() {\n const pending = await getPendingEventSubCancellations(5);\n for (const row of pending) {\n try {\n await deleteEventSubSubscription(String(row.subscription_id));\n await clearPendingEventSubCancellation(String(row.subscription_id));\n await recordMonitorEvent(\"eventsub_delete_retry_ok\", `${row.broadcaster_id}:${row.subscription_id}`);\n } catch (e) {\n await queueEventSubCancellation(String(row.subscription_id), String(row.broadcaster_id), String(e));\n await recordMonitorEvent(\"eventsub_delete_retry_error\", `${row.broadcaster_id}:${String(e)}`);\n }\n }\n}\n\nasync function sendWelcomeMessage(display: string, broadcasterId: string) {\n await sendChatMessages(\n `@${display} Welcome to the Guild Hall, adventurer! 📜 Create your legend with !createchar or !newchar, check your parchment with !char, gather a company with !party create , and consult the archives with !dndbothelp. Full guild codex: ${PUBLIC_BASE_URL}/guide`,\n broadcasterId,\n );\n}\n\nasync function handleRequest(req: Request): Promise {\n await ensureTables();\n const url = new URL(req.url);\n const path = url.pathname;\n\n // ── Static / GET routes ──\n // NOTE: activity logs are intentionally NOT exposed as a public web route.\n // They contain per-channel usernames and command text; the only way to see\n // them is the in-chat `!logs` command, which is restricted to the\n // broadcaster/moderators of that specific channel (see below).\n if (req.method === \"GET\" && path === \"/healthz\") {\n try {\n try { await retryPendingEventSubCancellations(); } catch (e) { await recordMonitorEvent(\"eventsub_retry_loop_error\", String(e)); }\n await sqlite.execute(\"SELECT 1\");\n return new Response(JSON.stringify({ ok: true, service: \"GuildScribe\", time: new Date().toISOString() }), {\n headers: { \"Content-Type\": \"application/json\", \"Cache-Control\": \"no-store\" },\n });\n } catch (e) {\n await recordMonitorEvent(\"health_error\", String(e));\n return new Response(JSON.stringify({ ok: false }), { status: 503, headers: { \"Content-Type\": \"application/json\", \"Cache-Control\": \"no-store\" } });\n }\n }\n if (req.method === \"GET\" && path === \"/privacy\") {\n return page(\"GuildScribe Privacy Policy\", `

GuildScribe Privacy Policy

GuildScribe receives Twitch usernames/user IDs, channel IDs, command text, character/party/gameplay data, and basic connection/subscription state when a channel connects the bot.

How it is used

Data is used only to operate the Twitch bot, keep characters and parties working, troubleshoot abuse/errors, and provide channel activity logs to that channel's broadcaster/moderators.

Retention

Activity logs are kept for up to 90 days and are capped at 5,000 rows per channel. Character and party data remains while a channel uses GuildScribe unless the channel requests deletion. OAuth state records expire after 10 minutes. Connection records are removed when a channel disconnects.

Deletion

The connected broadcaster can use !dndbot leave purge to disconnect and request deletion of that channel's stored characters, parties, logs, and gameplay state. For other deletion requests, contact ${escapeHtml(Deno.env.get(\"SUPPORT_URL\") ?? \"the project operator through the support link on the home page\")}.

Return to GuildScribe

`);\n }\n if (req.method === \"GET\" && (path === \"/terms\" || path === \"/tos\")) {\n return page(\"GuildScribe Terms of Service\", `

GuildScribe Terms of Service

GuildScribe is a fan-made Twitch utility for D&D-style character and chat gameplay. Use it lawfully and respectfully, and follow Twitch's rules and the streamer/channel's rules.

Do not use the bot to harass, spam, abuse, evade moderation, or interfere with other users. Channel owners are responsible for deciding whether the bot is appropriate for their community.

The service may be changed, limited, suspended, or removed at any time. Gameplay data and generated results are not guaranteed to be preserved.

Report abuse or request account/channel assistance through the support contact on the home page.

Return to GuildScribe

`);\n }\n if (req.method === \"GET\" && (path === \"/guide\" || path === \"/commands\")) {\n return page(\n \"GuildScribe Codex\",\n `

GuildScribe Codex

The guild’s book of rites — every command for adventurers at the table.

${renderGuidePage()}`,\n );\n }\n if (req.method === \"GET\" && (path === \"/donate\" || path === \"/donations\")) {\n return page(\n \"Support the Guild\",\n `

Support the Guild

If GuildScribe has served your campaign, you can leave a tribute so the scribes may keep the halls open.

Ethereum (ETH)

0x422413678AdFC67d3d9AB545FE4e1ec1D00197fd

Send ETH on the Ethereum network. Verify the address and network in your wallet before confirming.

Bitcoin (BTC)

3JYo1Vwyh6aQENzXoi16rA9mXZuZQVL1rN

Send BTC on the Bitcoin network. Verify the address carefully before confirming.

Return to the Guild Hall

`,\n );\n }\n\n if (req.method === \"GET\" && path === \"/callback\") {\n const error = url.searchParams.get(\"error\");\n if (error) {\n return page(\n \"Twitch connection cancelled\",\n `

Connection cancelled

${escapeHtml(url.searchParams.get(\"error_description\") ?? error)}

`,\n );\n }\n const code = url.searchParams.get(\"code\");\n const state = url.searchParams.get(\"state\");\n if (!code || !state) return new Response(\"Missing OAuth code or state\", { status: 400 });\n const check = await sqlite.execute(\"SELECT * FROM oauth_states WHERE state = ? AND expires_at > ?\", [\n state,\n Date.now(),\n ]);\n if (!check.rows.length) return new Response(\"Invalid or expired OAuth state\", { status: 400 });\n await sqlite.execute(\"DELETE FROM oauth_states WHERE state = ?\", [state]);\n try {\n const token = await exchangeCode(code, `${url.origin}/callback`);\n const userRes = await fetch(\"https://api.twitch.tv/helix/users\", {\n headers: {\n Authorization: `Bearer ${token.access_token}`,\n \"Client-Id\": env(\"TWITCH_CLIENT_ID\"),\n },\n });\n if (!userRes.ok) throw new Error(`Could not identify broadcaster: ${userRes.status}`);\n const user = (await userRes.json()).data[0];\n const sub = await createChatSubscription(user.id, url.origin);\n await sqlite.execute(\n \"INSERT OR REPLACE INTO broadcasters (broadcaster_id,login,display_name,subscription_id,connected_at,connected,disconnected_at,disconnect_reason) VALUES (?,?,?,?,?,?,?,?)\",\n [user.id, user.login, user.display_name, sub.id, Date.now(), 1, null, null],\n );\n return page(\n \"Twitch connected\",\n `

The Guild accepts your banner

${escapeHtml(user.display_name)} is now connected to GuildScribe. The scribes will answer in that channel once the EventSub rite is complete.

Important: In Twitch chat, run /mod GuildScribeBot so the guild can hear and answer reliably.

Open the Guild Codex

`,\n );\n } catch (e) {\n console.error(e);\n return page(\"Connection failed\", `

Connection failed

GuildScribe could not complete the Twitch connection. Please try again or use the support link on the home page.

`);\n }\n }\n\n if (req.method === \"GET\") {\n const username = url.searchParams.get(\"user\");\n const channelId = url.searchParams.get(\"channel\");\n if (!username && !channelId) {\n const state = crypto.randomUUID();\n await sqlite.execute(\"INSERT INTO oauth_states (state,expires_at) VALUES (?,?)\", [\n state,\n Date.now() + 10 * 60 * 1000,\n ]);\n const auth = new URL(\"https://id.twitch.tv/oauth2/authorize\");\n auth.search = new URLSearchParams({\n client_id: env(\"TWITCH_CLIENT_ID\"),\n redirect_uri: `${url.origin}/callback`,\n response_type: \"code\",\n scope: \"channel:bot\",\n state,\n }).toString();\n return page(\n \"D&D Twitch Bot\",\n `

GuildScribe

A D&D guild hall for Twitch — characters, dice, duels, and the codex of rules.

Raise the Guild Banner in My Channel

After joining: mod the bot with /mod GuildScribeBot so the scribes can speak.

Open the Guild Codex · Support the Guild${Deno.env.get(\"SUPPORT_URL\") ? ` · Support / Contact` : \"\"}

`,\n );\n }\n if (!username) return new Response(\"Missing character user.\", { status: 400 });\n if (!channelId || !/^\\d+$/.test(channelId)) return new Response(\"Missing or invalid channel.\", { status: 400 });\n const broadcaster = await getBroadcaster(channelId);\n if (!broadcaster || Number(broadcaster.connected) !== 1) return new Response(\"Character page unavailable for this channel.\", { status: 404 });\n const c = await getCharacter(username.toLowerCase(), channelId);\n if (!c) return new Response(\"No character found for that user in this channel.\", { status: 404 });\n return new Response(renderCharacterPage(c), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n if (req.method === \"POST\" && path.startsWith(\"/admin/channels/\")) {\n const secret = Deno.env.get(\"ADMIN_API_SECRET\");\n const auth = req.headers.get(\"Authorization\") ?? \"\";\n if (!secret || secret.length < 32 || auth !== `Bearer ${secret}`) return new Response(\"Unauthorized\", { status: 401, headers: { \"Cache-Control\": \"no-store\" } });\n const match = path.match(/^\\/admin\\/channels\\/(\\d+)\\/(disable|enable)$/);\n if (!match) return new Response(\"Not found\", { status: 404 });\n const broadcasterId = match[1];\n if (match[2] === \"disable\") {\n await blockChannel(broadcasterId, \"operator override\");\n await recordMonitorEvent(\"operator_disable\", broadcasterId);\n return new Response(JSON.stringify({ ok: true, broadcaster_id: broadcasterId, blocked: true }), { headers: { \"Content-Type\": \"application/json\", \"Cache-Control\": \"no-store\" } });\n }\n await unblockChannel(broadcasterId);\n await recordMonitorEvent(\"operator_enable\", broadcasterId);\n return new Response(JSON.stringify({ ok: true, broadcaster_id: broadcasterId, blocked: false }), { headers: { \"Content-Type\": \"application/json\", \"Cache-Control\": \"no-store\" } });\n }\n\n if (req.method !== \"POST\") return new Response(\"OK\");\n\n // ── EventSub webhook ──\n const rawBody = await req.text();\n if (!(await verifyEventSub(req, rawBody))) return new Response(\"Invalid signature\", { status: 403 });\n const messageId = req.headers.get(\"Twitch-Eventsub-Message-Id\") ?? \"\";\n if (!(await claimEventSubMessage(messageId))) return new Response(\"OK\");\n const messageType = req.headers.get(\"Twitch-Eventsub-Message-Type\");\n const body = JSON.parse(rawBody);\n\n if (messageType === \"webhook_callback_verification\") {\n return new Response(body.challenge, { headers: { \"Content-Type\": \"text/plain\" } });\n }\n\n if (messageType === \"notification\") {\n const chatMessage: string = body.event?.message?.text ?? \"\";\n const chatter: string = body.event?.chatter_user_login ?? \"\";\n const display: string = body.event?.chatter_user_name ?? chatter;\n const chatterId: string = body.event?.chatter_user_id ?? \"\";\n const moderatorId: string = body.event?.moderator_user_id ?? \"\";\n const eventBroadcasterId: string = body.event?.broadcaster_user_id ?? \"\";\n const broadcasterId: string = eventBroadcasterId;\n const isModerator =\n chatterId === broadcasterId ||\n chatterId === eventBroadcasterId ||\n chatterId === moderatorId ||\n hasModeratorBadge(body.event);\n const baseUrl = url.origin;\n\n if (isBotAccount(chatter, chatterId, env(\"TWITCH_BOT_ID\"))) return new Response(\"OK\");\n\n // Only process events for an actively connected broadcaster. This makes a\n // stale EventSub subscription harmless after disconnect/offboarding.\n const connection = await getBroadcaster(broadcasterId);\n if (!connection || Number(connection.connected) !== 1) return new Response(\"OK\");\n\n // Operator blocklist always wins.\n if (await isChannelBlocked(broadcasterId)) return new Response(\"OK\");\n\n // Broadcaster-only disconnect/offboarding. `purge` additionally deletes channel data.\n const leaveMatch = chatMessage.trim().match(/^!dndbot\\s+leave(?:\\s+(purge))?$/i);\n if (leaveMatch) {\n if (chatterId !== broadcasterId && chatterId !== eventBroadcasterId) {\n await sendChatMessage(`@${display} only the broadcaster can disconnect GuildScribe.`, broadcasterId);\n return new Response(\"OK\");\n }\n const purge = Boolean(leaveMatch[1]);\n const connection = await getBroadcaster(broadcasterId);\n try {\n if (connection?.subscription_id) await deleteEventSubSubscription(String(connection.subscription_id));\n } catch (e) {\n await queueEventSubCancellation(String(connection.subscription_id), broadcasterId, String(e));\n await recordMonitorEvent(\"eventsub_delete_error\", `${broadcasterId}: cancellation queued for retry`);\n }\n await sendChatMessage(`@${display} GuildScribe is disconnecting from this channel${purge ? \" and purging its stored guild data\" : \"\"}.`, broadcasterId);\n if (purge) await purgeChannelData(broadcasterId);\n else await disconnectBroadcasterData(broadcasterId, false);\n return new Response(\"OK\");\n }\n\n // Channel enable/disable toggle\n const botToggle = chatMessage.trim().match(/^!dndbot\\s+(on|off|status)$/i);\n if (botToggle) {\n if (!isModerator) {\n await sendChatMessage(\n `@${display} only the broadcaster or a moderator can change the bot setting.`,\n broadcasterId,\n );\n } else if (botToggle[1].toLowerCase() === \"status\") {\n await sendChatMessage(\n `@${display} The guild hall is currently ${(await isChannelEnabled(broadcasterId)) ? \"open\" : \"closed\"} in this channel.`,\n broadcasterId,\n );\n } else {\n const enabled = botToggle[1].toLowerCase() === \"on\";\n await setChannelEnabled(broadcasterId, enabled);\n await sendChatMessage(\n `@${display} The guild hall is now ${enabled ? \"open\" : \"closed\"} in this channel. ${enabled ? \"Adventurers may petition the scribes.\" : \"The doors are barred until a steward reopens them.\"}`,\n broadcasterId,\n );\n }\n return new Response(\"OK\");\n }\n\n if (!(await isChannelEnabled(broadcasterId))) return new Response(\"OK\");\n\n if (chatMessage.startsWith(\"!\")) {\n // Throttle non-mod command spam before it reaches any handler or the DB.\n if (!isModerator && !(await checkCommandRateLimit(broadcasterId, chatter, COMMAND_COOLDOWN_MS))) return new Response(\"OK\");\n await recordActivity(chatter, broadcasterId, chatMessage.split(/\\s+/)[0].toLowerCase(), chatMessage);\n }\n\n // Command handlers (return true if handled)\n if (await handleCreationCommand(chatter, display, broadcasterId, chatMessage)) return new Response(\"OK\");\n if (await handleInitiativeCommand(chatMessage, broadcasterId, display, isModerator)) return new Response(\"OK\");\n if (await handlePartyCommand(chatMessage, chatter, display, broadcasterId)) return new Response(\"OK\");\n if (await handlePartyDuelCommand(chatMessage, chatter, display, broadcasterId)) return new Response(\"OK\");\n // Monster first: only claims exact \"!dndduel\" / \"!dndduel attack\" / \"!dndduel monster …\"\n // so player-vs-player \"!dndduel @user\" still falls through to handleDuelCommand.\n if (await handleMonsterDuelCommand(chatMessage, chatter, display, broadcasterId)) return new Response(\"OK\");\n if (await handleDuelCommand(chatMessage, chatter, display, broadcasterId)) return new Response(\"OK\");\n\n if (chatMessage === \"!logs\") {\n if (!isModerator) {\n await sendChatMessage(`@${display} only the broadcaster or a moderator can use !logs.`, broadcasterId);\n } else {\n const logs = await getRecentLogs(broadcasterId, 8);\n await sendChatMessages(\n logs.length\n ? `@${display} Recent activity: ${logs.reverse().map(logRowText).join(\" || \")}`\n : `@${display} no activity has been logged yet.`,\n broadcasterId,\n );\n }\n } else if (chatMessage === \"!connections\") {\n if (!isModerator) {\n await sendChatMessage(\n `@${display} only the broadcaster or a moderator can use !connections.`,\n broadcasterId,\n );\n } else {\n const names = await getConnections();\n await sendChatMessages(\n `@${display} Connected channels (${names.length}): ${names.length ? names.join(\", \") : \"none\"}`,\n broadcasterId,\n );\n }\n } else if (chatMessage === \"!help\") {\n await sendWelcomeMessage(display, broadcasterId);\n } else if (chatMessage === \"!link\" || chatMessage === \"!guide\") {\n await sendChatMessage(\n `@${display} 📜 Guild Codex (full command guide): ${PUBLIC_BASE_URL}/guide`,\n broadcasterId,\n );\n } else if (/^!dndbothelp(?:\\s+\\w+)?$/i.test(chatMessage)) {\n const category = chatMessage.split(/\\s+/)[1]?.toLowerCase();\n const help =\n category === \"dice\"\n ? \"🎲 Fate's dice: !d20 | !d20 @user | !roll | !r | !roll NdS[+/-M] (e.g. !roll 2d6+3) | !roll @user [NdS[+/-M]] | !roll saving throw (e.g. !roll dex) | !roll check (e.g. !roll stealth) — uses your saved character | !roll ? for a D&D-flavored yes/no verdict (e.g. !roll is enya going to die this time?) | !bg3roll for a random Baldur's Gate 3 style character\"\n : category === \"settings\"\n ? \"🏛️ Guild stewards (mod/broadcaster): !dndbot on | !dndbot off | !dndbot status | !dndbot leave [purge] | !help | !guide | !link\"\n : category === \"character\"\n ? \"⚔️ Adventurer's parchment: !createchar | !createchar @user (mod) | !newchar | !answer | !cancel | !char | !char @user | !levelup [+/-N] | !hp [+/-N] | !savechar | !loadchar | !resetchar\"\n : category === \"party\"\n ? \"🛡️ Guild company: !party create | !party join | !party invite @user [name] | !party accept/decline [name] | !party list [name] (roster + members) | !party leave | !party disband \"\n : category === \"combat\"\n ? \"⚔️ Arena & wilds: !dndduel @user (auto) | !dndduel classic @user | !dndduel accept/decline/attack/status/end | !dndduel (auto monster) | !dndduel monster (classic) | !dndduel party A B | !dndduel party classic A B | !dndduel party accept/decline/attack/status/end | !dndduel party hunt | !dndduel party hunt classic | !dndduel party hunt attack/status/end | !turn start | !turn add | !turn show | !turn next | !turn prev | !turn remove | !turn end\"\n : category === \"lookup\"\n ? \"📚 Guild archives: !spell [+N] | !item [+N] | !class | !feat | !ability | !race | !subrace | !rule | !rules (e.g. !spell fireball, !rules magic)\"\n : `📜 Guild Codex chapters: dice | character | party | combat | lookup | settings. Example: !dndbothelp party — full book: ${PUBLIC_BASE_URL}/guide`;\n await sendChatMessages(`@${display} ${help}`, broadcasterId);\n } else if (/^!levelup(?:\\s+([+-]\\d+))?$/i.test(chatMessage)) {\n const match = chatMessage.match(/^!levelup(?:\\s+([+-]\\d+))?$/i)!;\n const delta = match[1] ? Number.parseInt(match[1], 10) : 1;\n const result = await adjustLevel(chatter, delta, broadcasterId);\n if (\"error\" in result) {\n const errorText =\n result.error === \"no character\"\n ? \"you don't have a character yet — try !createchar\"\n : result.error === \"max level\"\n ? \"you're already level 20\"\n : result.error === \"min level\"\n ? \"you're already level 1\"\n : \"use !levelup, !levelup +2, or !levelup -1\";\n await sendChatMessage(`@${display} ${errorText}`, broadcasterId);\n } else {\n const direction = result.delta > 0 ? \"advanced\" : \"reduced\";\n const hpChange = result.hpGain >= 0 ? `HP +${result.hpGain}` : `HP ${result.hpGain}`;\n await sendChatMessage(\n `@${display} level ${direction} from ${result.oldLevel} to ${result.c.level}; ${hpChange}, HP ${result.c.hpCurrent}/${result.c.hpMax}, Prof +${result.c.proficiency}.${result.asi}`,\n broadcasterId,\n );\n }\n } else if (/^!(spell|item|class|feat|ability|race|subrace|rule|rules)(?:\\s+.*)?$/i.test(chatMessage)) {\n const match = chatMessage.match(\n /^!(spell|item|class|feat|ability|race|subrace|rule|rules)(?:\\s+(.+?))?(?:\\s+\\+(\\d+))?$/i,\n )!;\n const kind = match[1].toLowerCase();\n const query = (match[2] ?? \"\").trim();\n const bonus = match[3] ? Math.min(20, Number.parseInt(match[3], 10)) : null;\n\n // Incomplete command — suggest syntax + examples\n if (!query) {\n const usage: Record = {\n spell: \"Usage: !spell [+N]. Example: !spell fireball or !spell cure wounds +1\",\n item: \"Usage: !item [+N]. Example: !item longsword or !item longsword +1\",\n class: \"Usage: !class . Example: !class wizard\",\n feat: \"Usage: !feat . Example: !feat alert\",\n ability: \"Usage: !ability . Example: !ability strength or !ability dex\",\n race: \"Usage: !race . Example: !race elf\",\n subrace: \"Usage: !subrace . Example: !subrace high elf\",\n rule: \"Usage: !rule . Example: !rule advantage or !rule casting a spell\",\n rules: \"Usage: !rules . Example: !rules magic or !rules combat\",\n };\n await sendChatMessage(`@${display} ${usage[kind] ?? `Usage: !${kind} `}`, broadcasterId);\n } else {\n const data = await lookup5e(kind, query);\n if (data && kind === \"spell\") {\n await sendSpellSections(formatSpellSections(data, bonus), display, broadcasterId);\n } else {\n const isRule = kind === \"rule\" || kind === \"rules\";\n await sendChatMessages(\n data\n ? `@${display} ${formatLookup(kind, data, bonus)}`\n : `@${display} couldn't find that ${kind}. Try e.g. !spell fireball, !item longsword, or !rule advantage`,\n broadcasterId,\n isRule ? { maxParts: 3 } : undefined,\n );\n }\n }\n } else if (/^!(?:roll|r|d20)(?:\\s+.*)?$/i.test(chatMessage)) {\n // Support: !d20 | !d20 @user | !roll | !roll @user 2d6+3 | !r 4d8\n // | !roll dex (saving throw) | !roll stealth (skill check) — both pull\n // the modifier from the roller's (or @target's) saved character.\n let rest = chatMessage.replace(/^!(?:roll|r|d20)\\s*/i, \"\").trim();\n let rollTarget: string | null = null;\n const targetMatch = rest.match(/^@(\\S+)\\s*(.*)$/);\n if (targetMatch) {\n rollTarget = targetMatch[1].replace(/[,:]+$/, \"\");\n rest = targetMatch[2].trim();\n }\n\n const checkKind = rest ? resolveCheckKind(rest) : null;\n\n // Fate question: \"!roll is enya going to die this time?\" — only once rest\n // has already failed to resolve as a saving throw/skill check, isn't\n // targeted at another user (that path stays reserved for dice rolls),\n // and reads like a question rather than a mistyped ability/dice\n // expression (contains a space, or ends in \"?\").\n const isFateQuestion =\n !checkKind && !rollTarget && !!rest && !/^\\d+d\\d+([+-]\\d+)?$/i.test(rest) && (/\\s/.test(rest) || /\\?$/.test(rest));\n\n if (isFateQuestion) {\n await sendChatMessage(`@${display} ${rollFate(rest)}`, broadcasterId);\n } else {\n let expression: string;\n let label: string | undefined;\n let checkOwnerMissing: string | null = null;\n\n if (checkKind) {\n const owner = (rollTarget || chatter).toLowerCase();\n const c = await getCharacter(owner, broadcasterId);\n if (!c) {\n checkOwnerMissing = owner;\n expression = \"1d20\";\n } else {\n const abilityMod = modifier(c.scores[checkKind.ability]);\n const proficient = checkKind.type === \"save\" && classes[c.cls].savingThrows.includes(checkKind.ability);\n const total = abilityMod + (proficient ? c.proficiency : 0);\n expression = `1d20${total === 0 ? \"\" : total > 0 ? `+${total}` : `${total}`}`;\n label = checkKind.label;\n }\n } else {\n expression = rest || \"1d20\";\n }\n\n if (checkOwnerMissing) {\n await sendChatMessage(\n checkOwnerMissing === chatter\n ? `@${display} you don't have a character yet — try !createchar`\n : `@${display} @${checkOwnerMissing} doesn't have a character yet.`,\n broadcasterId,\n );\n } else {\n const result = rollDice(expression, label);\n if (!result) {\n await sendChatMessage(\n `@${display} that's not a valid roll — try !roll, !r, !d20, !roll 2d6+3, !roll dex, !roll stealth, or !roll ?`,\n broadcasterId,\n );\n } else if (rollTarget) {\n await sendChatMessage(`@${display} rolled for @${rollTarget}: ${result}`, broadcasterId);\n } else {\n await sendChatMessage(`@${display} ${result}`, broadcasterId);\n }\n }\n }\n } else if (chatMessage === \"!bg3roll\") {\n await sendChatMessage(rollBG3Character(display), broadcasterId);\n } else if (/^!createchar(?:\\s+@?\\S+)?$/i.test(chatMessage)) {\n const createMatch = chatMessage.match(/^!createchar(?:\\s+@?(\\S+))?$/i)!;\n const createTarget = createMatch[1] ? createMatch[1].toLowerCase() : null;\n if (createTarget && createTarget !== chatter && !isModerator) {\n await sendChatMessage(\n `@${display} only the broadcaster or a moderator can create a character for someone else.`,\n broadcasterId,\n );\n } else {\n const targetUser = createTarget || chatter;\n const c = generateCharacter(targetUser);\n await saveCharacter(c, broadcasterId);\n const forSomeoneElse = targetUser !== chatter;\n await sendChatMessage(\n `@${display} created a level 1 ${formatRaceName(c.race, c.subrace)} ${c.cls}${forSomeoneElse ? ` for @${targetUser}` : \"\"}! ${formatStatLine(c)} — ${baseUrl}/?user=${targetUser}`,\n broadcasterId,\n );\n }\n } else if (/^!char(?:\\s+@?\\S+)?$/i.test(chatMessage)) {\n const charMatch = chatMessage.match(/^!char(?:\\s+@?(\\S+))?$/i)!;\n const targetUser = charMatch[1] ? charMatch[1].toLowerCase().replace(/[,:]+$/, \"\") : chatter;\n const c = await getCharacter(targetUser, broadcasterId);\n if (c) {\n const label = targetUser === chatter ? \"\" : `@${targetUser} `;\n await sendChatMessage(\n `@${display} ${label}${formatRaceName(c.race, c.subrace)} ${c.cls} — ${formatStatLine(c)} — ${baseUrl}/?user=${targetUser}`,\n broadcasterId,\n );\n } else {\n await sendChatMessage(\n targetUser === chatter\n ? `@${display} you don't have a character yet — try !createchar`\n : `@${display} @${targetUser} doesn't have a character yet.`,\n broadcasterId,\n );\n }\n } else if (chatMessage.startsWith(\"!hp \")) {\n const delta = Number.parseInt(chatMessage.slice(4).trim());\n if (Number.isNaN(delta)) {\n await sendChatMessage(`@${display} use !hp +5 or !hp -3`, broadcasterId);\n } else {\n const c = await adjustHp(chatter, delta, broadcasterId);\n await sendChatMessage(\n c\n ? `@${display} HP: ${c.hpCurrent}/${c.hpMax}`\n : `@${display} you don't have a character yet — try !createchar`,\n broadcasterId,\n );\n }\n } else if (chatMessage === \"!savechar\") {\n await sendChatMessage(\n (await backupCharacter(chatter, broadcasterId))\n ? `@${display} character saved!`\n : `@${display} no character to save — try !createchar`,\n broadcasterId,\n );\n } else if (chatMessage === \"!loadchar\") {\n const c = await loadBackup(chatter, broadcasterId);\n await sendChatMessage(\n c\n ? `@${display} character loaded! ${formatStatLine(c)} — ${baseUrl}/?user=${chatter}`\n : `@${display} no saved backup found — try !savechar first`,\n broadcasterId,\n );\n } else if (chatMessage === \"!resetchar\") {\n await resetCharacter(chatter, broadcasterId);\n await sendChatMessage(\n `@${display} character reset — use !createchar to roll a new one`,\n broadcasterId,\n );\n }\n }\n\n if (messageType === \"revocation\") {\n const broadcasterId = String(body.subscription?.condition?.broadcaster_user_id ?? \"\");\n const subscriptionId = String(body.subscription?.id ?? \"\");\n if (broadcasterId) {\n await markBroadcasterDisconnected(broadcasterId, String(body.subscription?.status ?? \"revoked\"), subscriptionId);\n await recordMonitorEvent(\"eventsub_revocation\", `${broadcasterId}:${subscriptionId}`);\n }\n }\n return new Response(\"OK\");\n}\n\n// TWITCH_BOT_ID must be the numeric Twitch user ID belonging to TWITCH_BOT_TOKEN.\n\n\nexport default async function (req: Request): Promise {\n try {\n return await handleRequest(req);\n } catch (e) {\n try { await recordMonitorEvent(\"unhandled_error\", String(e)); } catch (_) {}\n console.error(\"GuildScribe request failed\", e);\n return new Response(\"Internal server error\", { status: 500 });\n }\n}\n","guildscribe",[178],"fd8172aa-e835-4847-a515-4a4d323af28b","lookups.ts","8e4689c6-a4d9-11f1-8724-1607ee4eb77e",132,["D",1788147804734],9,"// D&D 5e API lookups and formatting\n\nimport { lookupResources } from \"./data.ts\";\nimport { compactText } from \"./utils.ts\";\n\n/**\n * Public reference links for chat.\n * Avoid 5thsrd.org — it often shows \"Access Denied\" (403) to normal browsers.\n */\nexport function lookupLink(kind: string, data: any): string {\n const index = String(data?.index ?? data?.name ?? \"\")\n .toLowerCase()\n .trim()\n .replace(/['’]/g, \"\")\n .replace(/[^a-z0-9]+/g, \"-\")\n .replace(/^-+|-+$/g, \"\");\n const nameQ = encodeURIComponent(String(data?.name ?? index));\n\n // Hardcoded Free Rules chapter URLs (e.g. /sources/dnd/free-rules/combat) have started\n // returning 403s as D&D Beyond has restructured that section. The public search URL\n // below doesn't require login and hasn't shown the same 403 gate, so use it for everything.\n if (kind === \"rule\" || kind === \"rules\") {\n return `https://www.dndbeyond.com/search?q=${nameQ}`;\n }\n if (kind === \"spell\") return `https://www.dndbeyond.com/spells/${index}`;\n if (kind === \"item\") return `https://www.dndbeyond.com/equipment/${index}`;\n if (kind === \"class\") return `https://www.dndbeyond.com/classes/${index}`;\n if (kind === \"feat\") return `https://www.dndbeyond.com/feats/${index}`;\n if (kind === \"race\") return `https://www.dndbeyond.com/races/${index}`;\n if (kind === \"subrace\") return `https://www.dndbeyond.com/search?q=${nameQ}`;\n if (kind === \"ability\") return `https://www.dndbeyond.com/search?q=${nameQ}`;\n return `https://www.dndbeyond.com/search?q=${nameQ}`;\n}\n\nfunction withLink(kind: string, data: any, text: string): string {\n const link = lookupLink(kind, data);\n // Put the link first so it's always visible even if chat truncates/splits the message\n if (text.includes(link)) return text;\n return `🔗 ${link} | ${text}`;\n}\n\nasync function fetchFromResource(resource: string, lookupQuery: string): Promise {\n const normalized = lookupQuery\n .toLowerCase()\n .trim()\n .replace(/[^a-z0-9]+/g, \" \")\n .replace(/\\s+/g, \" \");\n const slug = normalized.replace(/ /g, \"-\");\n const base = `https://www.dnd5eapi.co/api/2014/${resource}`;\n for (const candidate of [slug, normalized.replace(/ /g, \"-\")]) {\n const direct = await fetch(`${base}/${encodeURIComponent(candidate)}`);\n if (direct.ok) return await direct.json();\n }\n const res = await fetch(base);\n if (!res.ok) return null;\n const list = (await res.json()).results ?? [];\n const comparable = (value: string) => value.toLowerCase().replace(/[^a-z0-9]/g, \"\");\n const wanted = comparable(lookupQuery);\n const found =\n list.find((x: any) => comparable(x.name) === wanted) ??\n list.find((x: any) => comparable(x.name).includes(wanted) || wanted.includes(comparable(x.name)));\n if (!found) return null;\n const detail = await fetch(`https://www.dnd5eapi.co${found.url}`);\n return detail.ok ? await detail.json() : null;\n}\n\nexport async function lookup5e(kind: string, query: string): Promise {\n const resource = lookupResources[kind];\n if (!resource || !query || query.length > 60) return null;\n const abilityAliases: Record = {\n strength: \"str\",\n dexterity: \"dex\",\n constitution: \"con\",\n intelligence: \"int\",\n wisdom: \"wis\",\n charisma: \"cha\",\n };\n const lookupQuery = kind === \"ability\" ? (abilityAliases[query.toLowerCase().trim()] ?? query) : query;\n\n // Rules: aliases + sections + chapters; expand chapter subsections for fuller answers\n if (kind === \"rule\" || kind === \"rules\") {\n const aliases: Record = {\n magic: \"spellcasting\",\n spells: \"spellcasting\",\n spell: \"what-is-a-spell\",\n casting: \"casting-a-spell\",\n concentration: \"casting-a-spell\",\n combat: \"combat\",\n attack: \"making-an-attack\",\n attacks: \"making-an-attack\",\n cover: \"cover\",\n advantage: \"advantage-and-disadvantage\",\n disadvantage: \"advantage-and-disadvantage\",\n rest: \"resting\",\n resting: \"resting\",\n death: \"damage-and-healing\",\n healing: \"damage-and-healing\",\n damage: \"damage-and-healing\",\n movement: \"movement\",\n initiative: \"the-order-of-combat\",\n surprise: \"the-order-of-combat\",\n };\n const q = lookupQuery.toLowerCase().trim();\n const aliased = aliases[q] ?? lookupQuery;\n\n let section = await fetchFromResource(\"rule-sections\", aliased);\n if (!section) section = await fetchFromResource(\"rule-sections\", lookupQuery);\n if (section) return { ...section, _kind: \"rule-section\" };\n\n let chapter = await fetchFromResource(\"rules\", aliased);\n if (!chapter) chapter = await fetchFromResource(\"rules\", lookupQuery);\n if (chapter) {\n const subs = Array.isArray(chapter.subsections) ? chapter.subsections.slice(0, 4) : [];\n const expanded: string[] = [];\n for (const sub of subs) {\n try {\n const res = await fetch(`https://www.dnd5eapi.co${sub.url}`);\n if (res.ok) {\n const detail = await res.json();\n const d = String(detail.desc ?? \"\").replace(/#{1,6}\\s*/g, \"\").replace(/\\s+/g, \" \").trim();\n if (d) expanded.push(`${detail.name}: ${d.slice(0, 700)}`);\n }\n } catch (_) {\n /* ignore */\n }\n }\n return { ...chapter, _kind: \"rule-chapter\", _expanded: expanded };\n }\n return null;\n }\n\n return fetchFromResource(resource, lookupQuery);\n}\n\nexport function formatSpellSections(data: any, bonus: number | null = null) {\n const upcast = bonus && bonus > 0 ? bonus : 0;\n const baseSlot = data.level + upcast;\n const slotDamage = data.damage?.damage_at_slot_level?.[String(baseSlot)];\n const damage = data.damage\n ? `${data.damage.damage_type?.name ?? \"Damage\"} ${\n slotDamage\n ? `at slot ${baseSlot}: ${slotDamage}`\n : Object.entries(data.damage.damage_at_slot_level ?? {})\n .map(([level, dice]) => `L${level}:${dice}`)\n .join(\"/\")\n }`\n : \"no direct damage\";\n const dc = data.dc ? `${data.dc.dc_type?.name ?? \"save\"} save (${data.dc.dc_success ?? \"normal\"})` : \"no save\";\n const area = data.area_of_effect\n ? `${data.area_of_effect.size}-ft ${data.area_of_effect.type}`\n : \"not listed\";\n const components = (data.components ?? []).join(\"\") || \"none\";\n const material = data.material ? `; material: ${compactText(data.material, 80)}` : \"\";\n const classes =\n compactText((data.classes ?? []).map((x: any) => x.name).join(\", \"), 100) || \"none listed\";\n const higher = data.higher_level?.length ? compactText(data.higher_level[0], 180) : \"none\";\n const link = lookupLink(\"spell\", data);\n return [\n `🔗 ${link} | ${data.name} Lv${data.level}${upcast ? ` (upcast +${upcast}, slot ${baseSlot})` : \"\"} ${data.school?.name ?? \"magic\"} | Cast: ${data.casting_time} | Range: ${data.range} | Duration: ${data.duration}${data.concentration ? \" (concentration)\" : \"\"}`,\n `Components: ${components}${material} | Damage: ${damage} | Save: ${dc} | Area: ${area}`,\n `Classes: ${classes} | Higher levels: ${higher}`,\n ];\n}\n\nexport function formatLookup(kind: string, data: any, bonus: number | null = null) {\n const name = data.name;\n const bonusText = bonus !== null ? `modifier +${bonus}; ` : \"\";\n if (kind === \"item\") {\n const damage = data.damage\n ? `${data.damage.damage_dice ?? \"?\"} ${data.damage.damage_type?.name ?? \"damage\"}`\n : \"no weapon damage\";\n const range =\n data.range?.normal != null\n ? data.range.long != null\n ? `${data.range.normal}-${data.range.long} ft`\n : `${data.range.normal} ft`\n : \"melee\";\n const props = compactText((data.properties ?? []).map((x: any) => x.name).join(\", \"), 90);\n const ac = data.armor_category\n ? `AC ${data.armor_class?.base ?? \"?\"}${data.armor_class?.dex_bonus ? \"+ Dex\" : \"\"}`\n : \"\";\n const itemParts = [\n `${bonusText}${bonus !== null ? `attack/damage +${bonus}` : \"\"}`,\n damage,\n `range ${range}`,\n ac,\n `weight ${data.weight ?? \"?\"} lb`,\n `cost ${data.cost?.quantity ?? \"?\"} ${data.cost?.unit ?? \"gp\"}`,\n `properties ${props || \"none\"}`,\n ].filter((part) => part.trim());\n return withLink(kind, data, `${name}: ${itemParts.join(\"; \")}`);\n }\n if (kind === \"class\") {\n const saves = (data.saving_throws ?? []).map((x: any) => x.name).join(\", \") || \"none listed\";\n const profs = compactText((data.proficiencies ?? []).map((x: any) => x.name).join(\", \"), 140);\n return withLink(\n kind,\n data,\n `${name}: ${bonusText}Hit Die d${data.hit_die}; saves ${saves}; proficiencies ${profs || \"none listed\"}`,\n );\n }\n if (kind === \"feat\") {\n const prereq =\n (data.prerequisites ?? [])\n .map((x: any) => `${x.ability_score?.name ?? \"ability\"} ${x.minimum_score ?? \"?\"}`)\n .join(\", \") || \"none listed\";\n return withLink(\n kind,\n data,\n `${name}: ${bonusText}prerequisite ${prereq}; ${compactText((data.desc ?? []).join(\" \"), 220)}`,\n );\n }\n if (kind === \"ability\") {\n const skills = compactText((data.skills ?? []).map((x: any) => x.name).join(\", \"), 100);\n return withLink(\n kind,\n data,\n `${name}: ${bonusText}score ${data.full_name ?? name}; skills ${skills || \"none listed\"}; ${compactText((data.desc ?? []).join(\" \"), 180)}`,\n );\n }\n if (kind === \"race\" || kind === \"subrace\") {\n const bonuses =\n (data.ability_bonuses ?? [])\n .map(\n (b: any) =>\n `${b.ability_score?.name ?? b.ability_score?.index?.toUpperCase() ?? \"ability\"} +${b.bonus}`,\n )\n .join(\", \") || \"none listed\";\n const traits = compactText((data.traits ?? data.racial_traits ?? []).map((x: any) => x.name).join(\", \"));\n const languages = compactText((data.languages ?? []).map((x: any) => x.name).join(\", \"), 80);\n const parent = data.race?.name ? `; parent race ${data.race.name}` : \"\";\n return withLink(\n kind,\n data,\n `${name}: ${bonusText}bonuses ${bonuses}; speed ${data.speed ?? \"?\"} ft; size ${data.size ?? \"?\"}${parent}; languages ${languages || \"not listed\"}; traits ${traits || \"none listed\"}`,\n );\n }\n if (kind === \"rule\" || kind === \"rules\") {\n // Cap for 3 chat messages (~480 each, leave room for @user in outer send)\n const MAX_RULE_CHARS = 1200;\n const rawDesc = Array.isArray(data.desc) ? data.desc.join(\" \") : String(data.desc ?? \"\");\n const cleaned = rawDesc\n .replace(/\\|/g, \" \")\n .replace(/#{1,6}\\s*/g, \"\")\n .replace(/\\n+/g, \" \")\n .replace(/\\s+/g, \" \")\n .trim();\n\n const link = lookupLink(kind, data);\n if (Array.isArray(data._expanded) && data._expanded.length) {\n const intro = cleaned.slice(0, 200);\n const body = data._expanded.join(\" || \");\n return `🔗 ${link} | ${name}: ${intro} || ${body}`.slice(0, MAX_RULE_CHARS);\n }\n\n const body = cleaned.slice(0, MAX_RULE_CHARS - 80);\n const subsections = Array.isArray(data.subsections)\n ? data.subsections.map((s: any) => s.name).join(\", \")\n : \"\";\n const subNote = subsections ? ` | Related: ${subsections}` : \"\";\n return `🔗 ${link} | ${name}: ${body || \"no description\"}${subNote}`.slice(0, MAX_RULE_CHARS);\n }\n return withLink(kind, data, name);\n}\n",[188],"0db2918d-b81c-4003-a453-320a66075935","deno.json","2c8aa57e-a3c0-11f1-9adc-1607ee4eb77e",["D",1788018120139],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[196],"509680ea-ea2f-4126-93ba-c03026db5fde","db.ts","82592d08-a4d9-11f1-854e-1607ee4eb77e",142,["D",1788184662449],"// SQLite persistence layer\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Character } from \"./types.ts\";\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\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 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(`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(\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 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 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 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 };\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,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 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\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 \"channel_characters\",\n \"characters\",\n \"character_backups\",\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 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 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 }>,\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\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\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",[202],"602078b2-e767-4ad9-9f28-7c8e55824164","data.ts","799fb39e-a4d9-11f1-8231-1607ee4eb77e",154,["D",1788231134123],8,"// Static D&D 5e (2014) baseline data\n\nimport type { Ability, ClassData, Race } from \"./types.ts\";\n\nexport const races: Record = {\n Human: {\n subraces: [\"Standard\", \"Variant\"],\n bonuses: { STR: 1, DEX: 1, CON: 1, INT: 1, WIS: 1, CHA: 1 },\n speed: 30,\n traits: [\"Extra Language\"],\n },\n Elf: {\n subraces: [\"High Elf\", \"Wood Elf\", \"Drow\"],\n bonuses: { DEX: 2 },\n speed: 30,\n traits: [\"Darkvision\", \"Keen Senses\", \"Fey Ancestry\", \"Trance\"],\n },\n Dwarf: {\n subraces: [\"Hill Dwarf\", \"Mountain Dwarf\"],\n bonuses: { CON: 2 },\n speed: 25,\n traits: [\"Darkvision\", \"Dwarven Resilience\", \"Dwarven Combat Training\"],\n },\n Halfling: {\n subraces: [\"Lightfoot\", \"Stout\"],\n bonuses: { DEX: 2 },\n speed: 25,\n traits: [\"Lucky\", \"Brave\", \"Halfling Nimbleness\"],\n },\n Dragonborn: {\n subraces: [],\n bonuses: { STR: 2, CHA: 1 },\n speed: 30,\n traits: [\"Draconic Ancestry\", \"Breath Weapon\", \"Damage Resistance\"],\n },\n Gnome: {\n subraces: [\"Forest Gnome\", \"Rock Gnome\"],\n bonuses: { INT: 2 },\n speed: 25,\n traits: [\"Darkvision\", \"Gnome Cunning\"],\n },\n \"Half-Elf\": {\n subraces: [],\n bonuses: { CHA: 2 },\n speed: 30,\n traits: [\"Darkvision\", \"Fey Ancestry\", \"Skill Versatility\"],\n },\n \"Half-Orc\": {\n subraces: [],\n bonuses: { STR: 2, CON: 1 },\n speed: 30,\n traits: [\"Darkvision\", \"Relentless Endurance\", \"Savage Attacks\"],\n },\n Tiefling: {\n subraces: [\"Asmodeus\", \"Baalzebul\", \"Dispater\", \"Mammon\", \"Mephistopheles\"],\n bonuses: { INT: 1, CHA: 2 },\n speed: 30,\n traits: [\"Darkvision\", \"Hellish Resistance\", \"Infernal Legacy\"],\n },\n};\n\nexport const subraceBonuses: Record>> =\n {\n \"High Elf\": { INT: 1 },\n \"Wood Elf\": { WIS: 1 },\n Drow: { CHA: 1 },\n \"Hill Dwarf\": { WIS: 1 },\n \"Mountain Dwarf\": { STR: 2 },\n Lightfoot: { CHA: 1 },\n Stout: { CON: 1 },\n \"Forest Gnome\": { DEX: 1 },\n \"Rock Gnome\": { CON: 1 },\n };\n\nexport const classes: Record = {\n Barbarian: {\n priority: [\"STR\", \"CON\", \"DEX\", \"WIS\", \"CHA\", \"INT\"],\n savingThrows: [\"STR\", \"CON\"],\n hitDie: 12,\n calling: \"a fury-wreathed reaver\",\n },\n Fighter: {\n priority: [\"STR\", \"CON\", \"DEX\", \"WIS\", \"CHA\", \"INT\"],\n savingThrows: [\"STR\", \"CON\"],\n hitDie: 10,\n calling: \"a battle-tested champion\",\n },\n Paladin: {\n priority: [\"STR\", \"CHA\", \"CON\", \"WIS\", \"DEX\", \"INT\"],\n savingThrows: [\"WIS\", \"CHA\"],\n hitDie: 10,\n calling: \"a sworn guardian of a sacred oath\",\n },\n Ranger: {\n priority: [\"DEX\", \"WIS\", \"CON\", \"STR\", \"CHA\", \"INT\"],\n savingThrows: [\"STR\", \"DEX\"],\n hitDie: 10,\n calling: \"a tireless warden of the wild\",\n },\n Rogue: {\n priority: [\"DEX\", \"INT\", \"CON\", \"WIS\", \"CHA\", \"STR\"],\n savingThrows: [\"DEX\", \"INT\"],\n hitDie: 8,\n calling: \"a shadow-swift opportunist\",\n },\n Monk: {\n priority: [\"DEX\", \"WIS\", \"CON\", \"STR\", \"INT\", \"CHA\"],\n savingThrows: [\"STR\", \"DEX\"],\n hitDie: 8,\n calling: \"a disciplined master of body and spirit\",\n },\n Bard: {\n priority: [\"CHA\", \"DEX\", \"CON\", \"WIS\", \"INT\", \"STR\"],\n savingThrows: [\"DEX\", \"CHA\"],\n hitDie: 8,\n calling: \"a silver-tongued keeper of legends\",\n },\n Sorcerer: {\n priority: [\"CHA\", \"CON\", \"DEX\", \"WIS\", \"INT\", \"STR\"],\n savingThrows: [\"CON\", \"CHA\"],\n hitDie: 6,\n calling: \"a spellcaster born with dangerous power\",\n },\n Warlock: {\n priority: [\"CHA\", \"CON\", \"DEX\", \"WIS\", \"INT\", \"STR\"],\n savingThrows: [\"WIS\", \"CHA\"],\n hitDie: 8,\n calling: \"a pact-bound seeker of forbidden secrets\",\n },\n Cleric: {\n priority: [\"WIS\", \"STR\", \"CON\", \"CHA\", \"DEX\", \"INT\"],\n savingThrows: [\"WIS\", \"CHA\"],\n hitDie: 8,\n calling: \"a divine vessel carrying a god's will\",\n },\n Druid: {\n priority: [\"WIS\", \"CON\", \"DEX\", \"INT\", \"CHA\", \"STR\"],\n savingThrows: [\"INT\", \"WIS\"],\n hitDie: 8,\n calling: \"a shape-shifting voice of the wild\",\n },\n Wizard: {\n priority: [\"INT\", \"CON\", \"DEX\", \"WIS\", \"CHA\", \"STR\"],\n savingThrows: [\"INT\", \"WIS\"],\n hitDie: 6,\n calling: \"a scholar who bends reality through study\",\n },\n};\n\nexport const abilityNames: Ability[] = [\n \"STR\",\n \"DEX\",\n \"CON\",\n \"INT\",\n \"WIS\",\n \"CHA\",\n];\n\nexport const abilityFullNames: Record = {\n STR: \"Strength\",\n DEX: \"Dexterity\",\n CON: \"Constitution\",\n INT: \"Intelligence\",\n WIS: \"Wisdom\",\n CHA: \"Charisma\",\n};\n\n/** Chat-friendly aliases (abbreviation or full name) that resolve to a saving throw ability. */\nexport const abilityAliases: Record = {\n str: \"STR\",\n strength: \"STR\",\n dex: \"DEX\",\n dexterity: \"DEX\",\n con: \"CON\",\n constitution: \"CON\",\n int: \"INT\",\n intelligence: \"INT\",\n wis: \"WIS\",\n wisdom: \"WIS\",\n cha: \"CHA\",\n charisma: \"CHA\",\n};\n\n/** Standard 5e skills and the ability score each is checked against. */\nexport const skillAbilities: Record = {\n acrobatics: \"DEX\",\n \"animal handling\": \"WIS\",\n arcana: \"INT\",\n athletics: \"STR\",\n deception: \"CHA\",\n history: \"INT\",\n insight: \"WIS\",\n intimidation: \"CHA\",\n investigation: \"INT\",\n medicine: \"WIS\",\n nature: \"INT\",\n perception: \"WIS\",\n performance: \"CHA\",\n persuasion: \"CHA\",\n religion: \"INT\",\n \"sleight of hand\": \"DEX\",\n stealth: \"DEX\",\n survival: \"WIS\",\n};\n\n/** Solo monsters with numeric CR for level banding. */\nexport type SoloMonster = {\n name: string;\n cr: string;\n crValue: number;\n ac: number;\n hp: number;\n attack: number;\n die: number;\n bonus: number;\n};\n\nexport const SOLO_MONSTERS: SoloMonster[] = [\n // CR 1/8 – 1/4 (levels ~1)\n {\n name: \"Giant Rat\",\n cr: \"1/8\",\n crValue: 0.125,\n ac: 12,\n hp: 7,\n attack: 4,\n die: 4,\n bonus: 2,\n },\n {\n name: \"Stirge\",\n cr: \"1/8\",\n crValue: 0.125,\n ac: 14,\n hp: 2,\n attack: 5,\n die: 4,\n bonus: 3,\n },\n {\n name: \"Kobold Skirmisher\",\n cr: \"1/8\",\n crValue: 0.125,\n ac: 12,\n hp: 5,\n attack: 4,\n die: 4,\n bonus: 2,\n },\n {\n name: \"Goblin Scavenger\",\n cr: \"1/4\",\n crValue: 0.25,\n ac: 15,\n hp: 7,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Skeleton Guard\",\n cr: \"1/4\",\n crValue: 0.25,\n ac: 13,\n hp: 13,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Zombie Shambler\",\n cr: \"1/4\",\n crValue: 0.25,\n ac: 8,\n hp: 22,\n attack: 3,\n die: 6,\n bonus: 1,\n },\n {\n name: \"Wolf\",\n cr: \"1/4\",\n crValue: 0.25,\n ac: 13,\n hp: 11,\n attack: 4,\n die: 4,\n bonus: 2,\n },\n {\n name: \"Drow Scout\",\n cr: \"1/4\",\n crValue: 0.25,\n ac: 15,\n hp: 13,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n // CR 1/2\n {\n name: \"Wolf Pack Scout\",\n cr: \"1/2\",\n crValue: 0.5,\n ac: 13,\n hp: 18,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Shadow\",\n cr: \"1/2\",\n crValue: 0.5,\n ac: 12,\n hp: 16,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Cockatrice\",\n cr: \"1/2\",\n crValue: 0.5,\n ac: 11,\n hp: 27,\n attack: 3,\n die: 4,\n bonus: 1,\n },\n {\n name: \"Gnoll Hunter\",\n cr: \"1/2\",\n crValue: 0.5,\n ac: 15,\n hp: 22,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Orc Raider\",\n cr: \"1/2\",\n crValue: 0.5,\n ac: 13,\n hp: 15,\n attack: 5,\n die: 8,\n bonus: 3,\n },\n {\n name: \"Thug\",\n cr: \"1/2\",\n crValue: 0.5,\n ac: 11,\n hp: 32,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n // CR 1\n {\n name: \"Dire Wolf\",\n cr: \"1\",\n crValue: 1,\n ac: 14,\n hp: 37,\n attack: 5,\n die: 6,\n bonus: 3,\n },\n {\n name: \"Harpy\",\n cr: \"1\",\n crValue: 1,\n ac: 11,\n hp: 38,\n attack: 3,\n die: 6,\n bonus: 1,\n },\n {\n name: \"Imp\",\n cr: \"1\",\n crValue: 1,\n ac: 13,\n hp: 10,\n attack: 5,\n die: 4,\n bonus: 3,\n },\n {\n name: \"Quasit\",\n cr: \"1\",\n crValue: 1,\n ac: 13,\n hp: 7,\n attack: 4,\n die: 4,\n bonus: 3,\n },\n {\n name: \"Specter\",\n cr: \"1\",\n crValue: 1,\n ac: 12,\n hp: 22,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Bugbear\",\n cr: \"1\",\n crValue: 1,\n ac: 16,\n hp: 27,\n attack: 4,\n die: 8,\n bonus: 2,\n },\n {\n name: \"Giant Spider\",\n cr: \"1\",\n crValue: 1,\n ac: 14,\n hp: 26,\n attack: 5,\n die: 8,\n bonus: 3,\n },\n {\n name: \"Yuan-ti Pureblood\",\n cr: \"1\",\n crValue: 1,\n ac: 11,\n hp: 40,\n attack: 3,\n die: 6,\n bonus: 1,\n },\n // CR 2\n {\n name: \"Ogre Brute\",\n cr: \"2\",\n crValue: 2,\n ac: 11,\n hp: 59,\n attack: 6,\n die: 10,\n bonus: 4,\n },\n {\n name: \"Gargoyle\",\n cr: \"2\",\n crValue: 2,\n ac: 15,\n hp: 52,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Gelatinous Cube\",\n cr: \"2\",\n crValue: 2,\n ac: 6,\n hp: 84,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Gibbering Mouther\",\n cr: \"2\",\n crValue: 2,\n ac: 9,\n hp: 67,\n attack: 2,\n die: 6,\n bonus: 0,\n },\n {\n name: \"Grick\",\n cr: \"2\",\n crValue: 2,\n ac: 14,\n hp: 54,\n attack: 4,\n die: 8,\n bonus: 2,\n },\n {\n name: \"Mimic\",\n cr: \"2\",\n crValue: 2,\n ac: 12,\n hp: 58,\n attack: 5,\n die: 8,\n bonus: 3,\n },\n {\n name: \"Will-o'-Wisp\",\n cr: \"2\",\n crValue: 2,\n ac: 19,\n hp: 22,\n attack: 4,\n die: 8,\n bonus: 0,\n },\n {\n name: \"Ettercap\",\n cr: \"2\",\n crValue: 2,\n ac: 13,\n hp: 44,\n attack: 4,\n die: 8,\n bonus: 2,\n },\n // CR 3\n {\n name: \"Owlbear\",\n cr: \"3\",\n crValue: 3,\n ac: 13,\n hp: 59,\n attack: 7,\n die: 10,\n bonus: 4,\n },\n {\n name: \"Manticore\",\n cr: \"3\",\n crValue: 3,\n ac: 14,\n hp: 68,\n attack: 5,\n die: 6,\n bonus: 3,\n },\n {\n name: \"Minotaur\",\n cr: \"3\",\n crValue: 3,\n ac: 14,\n hp: 76,\n attack: 6,\n die: 12,\n bonus: 4,\n },\n {\n name: \"Phase Spider\",\n cr: \"3\",\n crValue: 3,\n ac: 13,\n hp: 32,\n attack: 4,\n die: 10,\n bonus: 2,\n },\n {\n name: \"Werewolf\",\n cr: \"3\",\n crValue: 3,\n ac: 12,\n hp: 58,\n attack: 4,\n die: 8,\n bonus: 2,\n },\n {\n name: \"Wight\",\n cr: \"3\",\n crValue: 3,\n ac: 14,\n hp: 45,\n attack: 4,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Basilisk\",\n cr: \"3\",\n crValue: 3,\n ac: 15,\n hp: 52,\n attack: 5,\n die: 6,\n bonus: 3,\n },\n {\n name: \"Displacer Beast\",\n cr: \"3\",\n crValue: 3,\n ac: 13,\n hp: 85,\n attack: 6,\n die: 6,\n bonus: 4,\n },\n // CR 4\n {\n name: \"Ettin\",\n cr: \"4\",\n crValue: 4,\n ac: 12,\n hp: 85,\n attack: 7,\n die: 8,\n bonus: 5,\n },\n {\n name: \"Black Pudding\",\n cr: \"4\",\n crValue: 4,\n ac: 7,\n hp: 85,\n attack: 5,\n die: 6,\n bonus: 3,\n },\n {\n name: \"Couatl\",\n cr: \"4\",\n crValue: 4,\n ac: 16,\n hp: 97,\n attack: 8,\n die: 6,\n bonus: 5,\n },\n {\n name: \"Elephant\",\n cr: \"4\",\n crValue: 4,\n ac: 12,\n hp: 76,\n attack: 8,\n die: 8,\n bonus: 5,\n },\n {\n name: \"Ghost\",\n cr: \"4\",\n crValue: 4,\n ac: 11,\n hp: 45,\n attack: 5,\n die: 6,\n bonus: 3,\n },\n {\n name: \"Lamia\",\n cr: \"4\",\n crValue: 4,\n ac: 13,\n hp: 97,\n attack: 5,\n die: 10,\n bonus: 3,\n },\n {\n name: \"Red Dragon Wyrmling\",\n cr: \"4\",\n crValue: 4,\n ac: 17,\n hp: 75,\n attack: 6,\n die: 10,\n bonus: 4,\n },\n {\n name: \"Succubus\",\n cr: \"4\",\n crValue: 4,\n ac: 15,\n hp: 66,\n attack: 5,\n die: 6,\n bonus: 3,\n },\n // CR 5\n {\n name: \"Troll\",\n cr: \"5\",\n crValue: 5,\n ac: 15,\n hp: 84,\n attack: 7,\n die: 6,\n bonus: 4,\n },\n {\n name: \"Young Dragon\",\n cr: \"5\",\n crValue: 5,\n ac: 17,\n hp: 75,\n attack: 7,\n die: 10,\n bonus: 4,\n },\n {\n name: \"Bulette\",\n cr: \"5\",\n crValue: 5,\n ac: 17,\n hp: 94,\n attack: 7,\n die: 12,\n bonus: 4,\n },\n {\n name: \"Elemental Earth\",\n cr: \"5\",\n crValue: 5,\n ac: 17,\n hp: 126,\n attack: 8,\n die: 8,\n bonus: 5,\n },\n {\n name: \"Flesh Golem\",\n cr: \"5\",\n crValue: 5,\n ac: 9,\n hp: 93,\n attack: 7,\n die: 8,\n bonus: 4,\n },\n {\n name: \"Hill Giant Scout\",\n cr: \"5\",\n crValue: 5,\n ac: 13,\n hp: 105,\n attack: 8,\n die: 10,\n bonus: 5,\n },\n {\n name: \"Night Hag\",\n cr: \"5\",\n crValue: 5,\n ac: 17,\n hp: 112,\n attack: 7,\n die: 8,\n bonus: 4,\n },\n {\n name: \"Shambling Mound\",\n cr: \"5\",\n crValue: 5,\n ac: 15,\n hp: 136,\n attack: 7,\n die: 8,\n bonus: 4,\n },\n {\n name: \"Unicorn\",\n cr: \"5\",\n crValue: 5,\n ac: 12,\n hp: 67,\n attack: 7,\n die: 8,\n bonus: 4,\n },\n {\n name: \"Vampire Spawn\",\n cr: \"5\",\n crValue: 5,\n ac: 15,\n hp: 82,\n attack: 6,\n die: 6,\n bonus: 3,\n },\n // CR 6\n {\n name: \"Hill Giant\",\n cr: \"6\",\n crValue: 6,\n ac: 13,\n hp: 105,\n attack: 8,\n die: 10,\n bonus: 5,\n },\n {\n name: \"Mammoth\",\n cr: \"6\",\n crValue: 6,\n ac: 13,\n hp: 126,\n attack: 10,\n die: 10,\n bonus: 7,\n },\n {\n name: \"Medusa\",\n cr: \"6\",\n crValue: 6,\n ac: 15,\n hp: 127,\n attack: 5,\n die: 6,\n bonus: 2,\n },\n {\n name: \"Cyclops\",\n cr: \"6\",\n crValue: 6,\n ac: 14,\n hp: 138,\n attack: 9,\n die: 10,\n bonus: 6,\n },\n {\n name: \"Wyvern\",\n cr: \"6\",\n crValue: 6,\n ac: 13,\n hp: 110,\n attack: 7,\n die: 6,\n bonus: 4,\n },\n {\n name: \"Young White Dragon\",\n cr: \"6\",\n crValue: 6,\n ac: 17,\n hp: 133,\n attack: 7,\n die: 10,\n bonus: 4,\n },\n // CR 7\n {\n name: \"Chimera\",\n cr: \"7\",\n crValue: 7,\n ac: 14,\n hp: 114,\n attack: 8,\n die: 10,\n bonus: 4,\n },\n {\n name: \"Giant Ape\",\n cr: \"7\",\n crValue: 7,\n ac: 12,\n hp: 157,\n attack: 9,\n die: 10,\n bonus: 6,\n },\n {\n name: \"Oni\",\n cr: \"7\",\n crValue: 7,\n ac: 16,\n hp: 110,\n attack: 7,\n die: 8,\n bonus: 4,\n },\n {\n name: \"Shield Guardian\",\n cr: \"7\",\n crValue: 7,\n ac: 17,\n hp: 142,\n attack: 7,\n die: 6,\n bonus: 4,\n },\n {\n name: \"Stone Giant\",\n cr: \"7\",\n crValue: 7,\n ac: 17,\n hp: 126,\n attack: 9,\n die: 8,\n bonus: 6,\n },\n {\n name: \"Young Black Dragon\",\n cr: \"7\",\n crValue: 7,\n ac: 18,\n hp: 127,\n attack: 7,\n die: 10,\n bonus: 4,\n },\n // CR 8\n {\n name: \"Frost Giant\",\n cr: \"8\",\n crValue: 8,\n ac: 15,\n hp: 138,\n attack: 9,\n die: 12,\n bonus: 6,\n },\n {\n name: \"Fomorian\",\n cr: \"8\",\n crValue: 8,\n ac: 14,\n hp: 149,\n attack: 9,\n die: 8,\n bonus: 6,\n },\n {\n name: \"Hydra (young)\",\n cr: \"8\",\n crValue: 8,\n ac: 15,\n hp: 172,\n attack: 8,\n die: 10,\n bonus: 5,\n },\n {\n name: \"Tyrannosaurus Rex\",\n cr: \"8\",\n crValue: 8,\n ac: 13,\n hp: 136,\n attack: 10,\n die: 12,\n bonus: 7,\n },\n {\n name: \"Young Green Dragon\",\n cr: \"8\",\n crValue: 8,\n ac: 18,\n hp: 136,\n attack: 7,\n die: 10,\n bonus: 4,\n },\n {\n name: \"Mind Flayer\",\n cr: \"8\",\n crValue: 8,\n ac: 15,\n hp: 71,\n attack: 7,\n die: 10,\n bonus: 4,\n },\n // CR 9\n {\n name: \"Fire Giant\",\n cr: \"9\",\n crValue: 9,\n ac: 18,\n hp: 162,\n attack: 10,\n die: 10,\n bonus: 7,\n },\n {\n name: \"Cloud Giant\",\n cr: \"9\",\n crValue: 9,\n ac: 14,\n hp: 200,\n attack: 12,\n die: 12,\n bonus: 8,\n },\n {\n name: \"Glabrezu\",\n cr: \"9\",\n crValue: 9,\n ac: 17,\n hp: 157,\n attack: 10,\n die: 10,\n bonus: 6,\n },\n {\n name: \"Young Blue Dragon\",\n cr: \"9\",\n crValue: 9,\n ac: 18,\n hp: 152,\n attack: 9,\n die: 10,\n bonus: 5,\n },\n {\n name: \"Treant\",\n cr: \"9\",\n crValue: 9,\n ac: 16,\n hp: 138,\n attack: 10,\n die: 10,\n bonus: 6,\n },\n // CR 10\n {\n name: \"Stone Golem\",\n cr: \"10\",\n crValue: 10,\n ac: 17,\n hp: 178,\n attack: 10,\n die: 10,\n bonus: 6,\n },\n {\n name: \"Aboleth\",\n cr: \"10\",\n crValue: 10,\n ac: 17,\n hp: 135,\n attack: 9,\n die: 6,\n bonus: 5,\n },\n {\n name: \"Deva\",\n cr: \"10\",\n crValue: 10,\n ac: 17,\n hp: 136,\n attack: 8,\n die: 6,\n bonus: 4,\n },\n {\n name: \"Guardian Naga\",\n cr: \"10\",\n crValue: 10,\n ac: 18,\n hp: 127,\n attack: 8,\n die: 8,\n bonus: 4,\n },\n {\n name: \"Young Red Dragon\",\n cr: \"10\",\n crValue: 10,\n ac: 18,\n hp: 178,\n attack: 10,\n die: 10,\n bonus: 6,\n },\n {\n name: \"Death Slaad\",\n cr: \"10\",\n crValue: 10,\n ac: 18,\n hp: 170,\n attack: 9,\n die: 10,\n bonus: 5,\n },\n // CR 11\n {\n name: \"Behir\",\n cr: \"11\",\n crValue: 11,\n ac: 17,\n hp: 168,\n attack: 10,\n die: 10,\n bonus: 6,\n },\n {\n name: \"Horned Devil\",\n cr: \"11\",\n crValue: 11,\n ac: 18,\n hp: 178,\n attack: 10,\n die: 10,\n bonus: 6,\n },\n {\n name: \"Remorhaz\",\n cr: \"11\",\n crValue: 11,\n ac: 17,\n hp: 195,\n attack: 11,\n die: 10,\n bonus: 7,\n },\n {\n name: \"Roc\",\n cr: \"11\",\n crValue: 11,\n ac: 15,\n hp: 248,\n attack: 13,\n die: 10,\n bonus: 9,\n },\n {\n name: \"Efreeti\",\n cr: \"11\",\n crValue: 11,\n ac: 17,\n hp: 200,\n attack: 10,\n die: 10,\n bonus: 6,\n },\n // CR 12\n {\n name: \"Adult Dragon Wyrmling-Guard\",\n cr: \"12\",\n crValue: 12,\n ac: 18,\n hp: 200,\n attack: 11,\n die: 12,\n bonus: 7,\n },\n {\n name: \"Archmage Shade\",\n cr: \"12\",\n crValue: 12,\n ac: 15,\n hp: 99,\n attack: 6,\n die: 8,\n bonus: 2,\n },\n {\n name: \"Erinyes\",\n cr: \"12\",\n crValue: 12,\n ac: 18,\n hp: 153,\n attack: 8,\n die: 8,\n bonus: 4,\n },\n {\n name: \"Kraken Spawn\",\n cr: \"12\",\n crValue: 12,\n ac: 16,\n hp: 230,\n attack: 12,\n die: 10,\n bonus: 8,\n },\n {\n name: \"Purple Worm Juvenile\",\n cr: \"12\",\n crValue: 12,\n ac: 18,\n hp: 220,\n attack: 12,\n die: 12,\n bonus: 8,\n },\n];\n\n/**\n * Pick a monster appropriate for the player's level.\n * Tuned so solo heroes win often at low level, but face a genuinely losable\n * fight at high level — not a guaranteed win.\n */\nexport function pickMonsterForLevel(level: number): SoloMonster {\n const lv = Math.max(1, Math.min(20, Math.floor(level || 1)));\n // Softer curve than true 5e deadly encounters — stream-friendly.\n // L1 → ~0.25–0.5 | L4 → ~1 | L8 → ~2 | L12 → ~3.5 | L20 → ~5.5\n const targetCr = Math.max(0.125, Math.min(10, (lv + 1) / 4));\n const minCr = 0.125;\n const maxCr = Math.min(12, targetCr * 1.25 + 0.25);\n\n let pool = SOLO_MONSTERS.filter((m) =>\n m.crValue >= minCr && m.crValue <= maxCr\n );\n if (!pool.length) {\n pool = [...SOLO_MONSTERS]\n .sort((a, b) =>\n Math.abs(a.crValue - targetCr) - Math.abs(b.crValue - targetCr)\n )\n .slice(0, 5);\n }\n\n // Weight toward monsters at or below target CR (easier wins more often).\n const weights = pool.map((m) => {\n if (m.crValue <= targetCr) return 3;\n if (m.crValue <= targetCr * 1.15) return 1.2;\n return 0.4;\n });\n const totalW = weights.reduce((a, b) => a + b, 0);\n let roll = Math.random() * totalW;\n let base = pool[0];\n for (let i = 0; i < pool.length; i++) {\n roll -= weights[i];\n if (roll <= 0) {\n base = pool[i];\n break;\n }\n }\n\n // Player-favoring scale — but the growth now tracks how much the PLAYER's\n // own combat math grows with level (proficiency feeds both their to-hit\n // and their AC in combat.ts; their ability modifier is fixed at creation\n // and doesn't grow further). The old flat multipliers here (attack *0.9 +\n // (lv-1)*0.08, ac capped at 18) grew far slower than the player's\n // proficiency, so by roughly level 5 the character's to-hit and AC had\n // already outpaced them — solo duels simulated out to a ~99–100% player\n // win rate from level 5 through 20, i.e. functionally unloseable despite\n // the table picking higher-CR monsters at higher levels. `growth` ramps\n // smoothly from 0 at level 1 to 1 at level 20 so early fights stay\n // forgiving while high-level ones are a real, losable fight (~90% win\n // rate at L1 tapering to ~65% at L20 in simulation).\n const growth = (lv - 1) / 19; // 0 at L1 → 1 at L20\n const hpScale = 0.8 + growth * 0.5; // ~0.80–1.30\n return {\n ...base,\n hp: Math.max(6, Math.round(base.hp * hpScale)),\n attack: Math.max(2, Math.round(base.attack * 1.1 + growth * 7.5)),\n bonus: Math.max(0, Math.round(base.bonus * 1.1 + growth * 4.2)),\n ac: Math.min(24, Math.max(10, Math.round(base.ac + 2.5 + growth * 9))),\n };\n}\n\nexport const knownBotAccounts = new Set([\n \"nightbot\",\n \"streamelements\",\n \"streamlabs\",\n \"moobot\",\n \"fossabot\",\n \"wizebot\",\n \"deepbot\",\n \"coebot\",\n \"ankhbot\",\n]);\n\nexport const lookupResources: Record = {\n spell: \"spells\",\n item: \"equipment\",\n class: \"classes\",\n feat: \"feats\",\n ability: \"ability-scores\",\n race: \"races\",\n subrace: \"subraces\",\n rule: \"rule-sections\",\n rules: \"rule-sections\",\n};\n\nexport const MAX_LOOKUP_MESSAGE_LENGTH = 300;",[209],"9aa6ae9c-68c8-4e5f-97d1-a7c12979e3c9","combat.ts","8de9ca4c-a4d9-11f1-a925-1607ee4eb77e",153,["D",1788230468281],10,"// Duels, party combat, monster duels, and initiative tracker\n\nimport { pickMonsterForLevel } from \"./data.ts\";\nimport { combatStats, duelNarration, firstAlive } from \"./utils.ts\";\nimport {\n createPartyInvite,\n deletePartyInvite,\n getCharacter,\n getDuel,\n getEncounter,\n getMonsterDuel,\n getParty,\n getPartyDuel,\n getPartyInvite,\n getPartyInvites,\n getPartyMembers,\n getPartyMonsterDuel,\n saveEncounter,\n sqlite,\n} from \"./db.ts\";\nimport { sendChatMessage, sendChatMessages } from \"./twitch.ts\";\nimport { awardMonsterXp } from \"./characters.ts\";\n\n// Target win rate for the challenger in auto solo monster duels (bare\n// !dndduel). Chosen once per fight before simulating; the sim below is\n// nudged onto that outcome afterward so the rate holds regardless of which\n// monster/stat matchup got picked for that fight. Does not affect classic\n// (turn-based) monster duels, PvP duels (!dndduel @user), or party hunts.\nconst AUTO_DUEL_PLAYER_WIN_RATE = 0.6;\n\nexport async function duelSummary(d: any) {\n const a = await getCharacter(d.challenger, d.broadcaster_id);\n const b = await getCharacter(d.defender, d.broadcaster_id);\n return `Duel: ${d.challenger} ${d.challenger_hp}/${\n a?.hpMax ?? \"?\"\n } HP vs ${d.defender} ${d.defender_hp}/${\n b?.hpMax ?? \"?\"\n } HP. Turn: ${d.current_turn}.`;\n}\n\n/** Simulate one attack; mutates hp map. Returns a short log line. */\nfunction simulateAttack(\n attackerName: string,\n defenderName: string,\n attacker: { proficiency: number; scores: Record },\n defender: { proficiency: number; scores: Record },\n hp: Record,\n): string {\n const stats = combatStats(attacker as any);\n const targetStats = combatStats(defender as any);\n const roll = 1 + Math.floor(Math.random() * 20);\n const total = roll + stats.mod + attacker.proficiency;\n const critical = roll === 20;\n const hit = critical || (roll !== 1 && total >= targetStats.attack);\n const dice = critical\n ? 1 + Math.floor(Math.random() * stats.die) +\n (1 + Math.floor(Math.random() * stats.die))\n : 1 + Math.floor(Math.random() * stats.die);\n const damage = hit ? Math.max(1, dice + stats.mod) : 0;\n if (hit) hp[defenderName] = Math.max(0, (hp[defenderName] ?? 0) - damage);\n if (critical) {\n return `${attackerName} CRIT ${damage}→${defenderName}(${\n hp[defenderName]\n }HP)`;\n }\n if (hit) {\n return `${attackerName} hit ${damage}→${defenderName}(${\n hp[defenderName]\n }HP)`;\n }\n return `${attackerName} miss`;\n}\n\n/** Auto-resolve a 1v1 duel. Returns chat-ready summary lines. */\nfunction resolvePlayerDuel(\n aName: string,\n bName: string,\n aChar: any,\n bChar: any,\n): { winner: string; log: string; rounds: number } {\n const hp: Record = {\n [aName]: aChar.hpMax,\n [bName]: bChar.hpMax,\n };\n const maxRounds = 40;\n const highlights: string[] = [];\n let rounds = 0;\n let turn = aName;\n while (hp[aName] > 0 && hp[bName] > 0 && rounds < maxRounds) {\n rounds++;\n const attackerName = turn;\n const defenderName = turn === aName ? bName : aName;\n const attacker = turn === aName ? aChar : bChar;\n const defender = turn === aName ? bChar : aChar;\n const line = simulateAttack(\n attackerName,\n defenderName,\n attacker,\n defender,\n hp,\n );\n // Keep crits, finishing blows, and a sample of early hits\n if (\n line.includes(\"CRIT\") || hp[defenderName] <= 0 || highlights.length < 6\n ) {\n highlights.push(line);\n }\n turn = defenderName;\n }\n const winner = hp[aName] > 0 ? aName : bName;\n const log = [\n `${aName} ${aChar.hpMax}HP vs ${bName} ${bChar.hpMax}HP — auto-resolved in ${rounds} swings.`,\n highlights.join(\" · \"),\n `${winner} wins! ${duelNarration(\"victory\")} Final: ${aName} ${\n hp[aName]\n }HP, ${bName} ${hp[bName]}HP.`,\n ].join(\" \");\n return { winner, log, rounds };\n}\n\nexport async function handleDuelCommand(\n chatMessage: string,\n username: string,\n display: string,\n broadcasterId: string,\n) {\n if (!/^!dndduel(?:\\s|$)/i.test(chatMessage)) return false;\n const parts = chatMessage.trim().split(/\\s+/);\n const action = (parts[1] ?? \"status\").toLowerCase();\n const active = await getDuel(broadcasterId);\n\n if (action === \"accept\" || action === \"decline\") {\n const res = await sqlite.execute(\n \"SELECT challenger, defender, mode FROM duel_challenges WHERE broadcaster_id = ? AND defender = ? ORDER BY created_at DESC LIMIT 1\",\n [broadcasterId, username],\n );\n if (!res.rows.length) {\n await sendChatMessage(\n `@${display} you have no pending duel challenge.`,\n broadcasterId,\n );\n return true;\n }\n const challenge = res.rows[0];\n const mode = String(challenge.mode || \"auto\").toLowerCase() === \"classic\"\n ? \"classic\"\n : \"auto\";\n await sqlite.execute(\n \"DELETE FROM duel_challenges WHERE broadcaster_id = ? AND defender = ?\",\n [\n broadcasterId,\n username,\n ],\n );\n if (action === \"decline\") {\n await sendChatMessage(\n `@${display} duel declined. ${duelNarration(\"decline\")}`,\n broadcasterId,\n );\n return true;\n }\n const challenger = await getCharacter(challenge.challenger, broadcasterId);\n const defender = await getCharacter(username, broadcasterId);\n if (!challenger || !defender) {\n await sendChatMessage(\n `@${display} both players need saved characters before dueling.`,\n broadcasterId,\n );\n return true;\n }\n if (mode === \"classic\") {\n // Turn-based: store active duel; players use !dndduel attack.\n await sqlite.execute(\n \"INSERT OR REPLACE INTO duels (broadcaster_id,challenger,defender,current_turn,challenger_hp,defender_hp,active,updated_at) VALUES (?,?,?,?,?,?,1,?)\",\n [\n broadcasterId,\n challenge.challenger,\n username,\n challenge.challenger,\n challenger.hpMax,\n defender.hpMax,\n Date.now(),\n ],\n );\n await sendChatMessage(\n `@${display} accepted classic duel! ${challenge.challenger} goes first. ${\n duelNarration(\"accept\")\n } Use !dndduel attack on your turn, or !dndduel status / !dndduel end.`,\n broadcasterId,\n );\n return true;\n }\n // Auto-resolve mode\n await sqlite.execute(\"DELETE FROM duels WHERE broadcaster_id = ?\", [\n broadcasterId,\n ]);\n const result = resolvePlayerDuel(\n String(challenge.challenger),\n username,\n challenger,\n defender,\n );\n await sendChatMessages(\n `@${display} accepted! ${duelNarration(\"accept\")} ${result.log}`,\n broadcasterId,\n );\n return true;\n }\n\n if (action === \"end\" || action === \"cancel\") {\n if (\n active && (active.challenger === username || active.defender === username)\n ) {\n await sqlite.execute(\"DELETE FROM duels WHERE broadcaster_id = ?\", [\n broadcasterId,\n ]);\n await sendChatMessage(`@${display} duel ended.`, broadcasterId);\n } else {\n await sendChatMessage(`@${display} no duel to end.`, broadcasterId);\n }\n return true;\n }\n\n if (action === \"status\" || action === \"show\") {\n await sendChatMessage(\n active\n ? `@${display} ${await duelSummary(active)}`\n : `@${display} no active duel. Challenge someone with !dndduel @username.`,\n broadcasterId,\n );\n return true;\n }\n\n if (action === \"attack\") {\n if (!active) {\n await sendChatMessage(\n `@${display} no active duel. Challenge someone with !dndduel @username.`,\n broadcasterId,\n );\n return true;\n }\n if (active.current_turn !== username) {\n await sendChatMessage(\n `@${display} it is ${active.current_turn}'s turn.`,\n broadcasterId,\n );\n return true;\n }\n const attacker = await getCharacter(username, broadcasterId);\n const targetName = active.challenger === username\n ? active.defender\n : active.challenger;\n const target = await getCharacter(targetName, broadcasterId);\n if (!attacker || !target) {\n await sendChatMessage(\n `@${display} both duel characters must still exist.`,\n broadcasterId,\n );\n return true;\n }\n const stats = combatStats(attacker);\n const targetStats = combatStats(target);\n const roll = 1 + Math.floor(Math.random() * 20);\n const total = roll + stats.mod + attacker.proficiency;\n const critical = roll === 20;\n const hit = critical || (roll !== 1 && total >= targetStats.attack);\n const dice = critical\n ? 1 + Math.floor(Math.random() * stats.die) +\n (1 + Math.floor(Math.random() * stats.die))\n : 1 + Math.floor(Math.random() * stats.die);\n const damage = hit ? Math.max(1, dice + stats.mod) : 0;\n if (active.challenger === username) {\n active.defender_hp = Math.max(0, active.defender_hp - damage);\n } else active.challenger_hp = Math.max(0, active.challenger_hp - damage);\n const defeated = active.challenger_hp <= 0 || active.defender_hp <= 0;\n const result = `${username} rolled ${roll}${\n critical ? \" CRITICAL\" : \"\"\n } + ${\n stats.mod + attacker.proficiency\n } = ${total} vs AC ${targetStats.attack}: ${\n hit ? `hit for ${damage} damage` : \"miss\"\n }. ${duelNarration(critical ? \"critical\" : hit ? \"hit\" : \"miss\")}`;\n if (defeated) {\n const winner = active.challenger_hp > 0\n ? active.challenger\n : active.defender;\n await sqlite.execute(\"DELETE FROM duels WHERE broadcaster_id = ?\", [\n broadcasterId,\n ]);\n await sendChatMessage(\n `@${display} ${result} ${winner} wins the duel! ${\n duelNarration(\"victory\")\n }`,\n broadcasterId,\n );\n } else {\n active.current_turn = targetName;\n await sqlite.execute(\n \"UPDATE duels SET current_turn = ?, challenger_hp = ?, defender_hp = ?, updated_at = ? WHERE broadcaster_id = ?\",\n [\n active.current_turn,\n active.challenger_hp,\n active.defender_hp,\n Date.now(),\n broadcasterId,\n ],\n );\n await sendChatMessages(\n `@${display} ${result} ${await duelSummary(active)}`,\n broadcasterId,\n );\n }\n return true;\n }\n\n // Challenge: !dndduel @user (auto) | !dndduel classic @user | !dndduel turn @user\n let mode: \"auto\" | \"classic\" = \"auto\";\n let targetRaw = \"\";\n if (action === \"classic\" || action === \"turn\" || action === \"manual\") {\n mode = \"classic\";\n targetRaw = parts.slice(2).join(\" \");\n } else if (action === \"auto\" || action === \"quick\") {\n mode = \"auto\";\n targetRaw = parts.slice(2).join(\" \");\n } else {\n // Bare \"!dndduel @user\" — default auto\n targetRaw = parts.slice(1).join(\" \");\n }\n const targetName = targetRaw.replace(/^@/, \"\").toLowerCase().replace(\n /[,:]+$/,\n \"\",\n );\n if (\n !targetName ||\n [\n \"party\",\n \"monster\",\n \"accept\",\n \"decline\",\n \"attack\",\n \"status\",\n \"show\",\n \"end\",\n \"cancel\",\n ].includes(targetName)\n ) {\n await sendChatMessage(\n `@${display} Duels: !dndduel @user (auto) | !dndduel classic @user (turn-based) | !dndduel accept | !dndduel decline | !dndduel attack | !dndduel status | !dndduel end`,\n broadcasterId,\n );\n return true;\n }\n if (active) {\n await sendChatMessage(\n `@${display} a classic duel is already active in this channel. Finish it or !dndduel end.`,\n broadcasterId,\n );\n return true;\n }\n const target = await getCharacter(targetName, broadcasterId);\n const own = await getCharacter(username, broadcasterId);\n if (!own || !target) {\n await sendChatMessage(\n `@${display} both players need saved characters before issuing a challenge.`,\n broadcasterId,\n );\n return true;\n }\n if (targetName === username.toLowerCase()) {\n await sendChatMessage(\n `@${display} you cannot duel yourself.`,\n broadcasterId,\n );\n return true;\n }\n await sqlite.execute(\n \"INSERT OR REPLACE INTO duel_challenges (broadcaster_id,challenger,defender,created_at,mode) VALUES (?,?,?,?,?)\",\n [broadcasterId, username, targetName, Date.now(), mode],\n );\n if (mode === \"classic\") {\n await sendChatMessage(\n `@${display} challenged @${targetName} to a classic turn-based duel! ${\n duelNarration(\"challenge\")\n } @${targetName}, type !dndduel accept or !dndduel decline.`,\n broadcasterId,\n );\n } else {\n await sendChatMessage(\n `@${display} challenged @${targetName} to a quick auto-duel! ${\n duelNarration(\"challenge\")\n } @${targetName}, type !dndduel accept or !dndduel decline.`,\n broadcasterId,\n );\n }\n return true;\n}\n\nexport async function monsterDuelText(d: any) {\n return `${d.player} vs ${d.monster_name} (CR ${d.monster_cr}) — Player HP ${\n d.player_hp ?? \"?\"\n }; Monster HP ${d.monster_hp}/${d.monster_hp_max}; AC ${d.monster_ac}; turn: ${d.current_turn}.`;\n}\n\nexport async function handleMonsterDuelCommand(\n chatMessage: string,\n username: string,\n display: string,\n broadcasterId: string,\n) {\n const normalized = chatMessage.trim().toLowerCase();\n if (\n !(\n normalized === \"!dndduel\" ||\n normalized === \"!dndduel attack\" ||\n normalized === \"!dndduel monster\" ||\n normalized === \"!dndduel monster classic\" ||\n normalized === \"!dndduel monster attack\" ||\n normalized === \"!dndduel monster status\" ||\n normalized === \"!dndduel monster end\"\n )\n ) {\n return false;\n }\n\n let active = await getMonsterDuel(broadcasterId);\n\n if (\n normalized === \"!dndduel monster status\" ||\n normalized === \"!dndduel monster end\" ||\n normalized === \"!dndduel monster attack\"\n ) {\n if (!active || active.player !== username) {\n await sendChatMessage(\n `@${display} you do not have an active monster duel.`,\n broadcasterId,\n );\n return true;\n }\n if (normalized.endsWith(\"status\")) {\n await sendChatMessage(\n `@${display} ${await monsterDuelText(active)}`,\n broadcasterId,\n );\n return true;\n }\n if (normalized.endsWith(\"end\")) {\n await sqlite.execute(\n \"DELETE FROM monster_duels WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n await sendChatMessage(\n `@${display} the monster duel ends. The dungeon master calls it a tactical retreat.`,\n broadcasterId,\n );\n return true;\n }\n }\n\n // Classic turn-based monster: !dndduel monster [classic]\n if (\n normalized === \"!dndduel monster\" ||\n normalized === \"!dndduel monster classic\"\n ) {\n if (active && active.player === username) {\n await sendChatMessage(\n `@${display} ${await monsterDuelText(active)} Use !dndduel attack.`,\n broadcasterId,\n );\n return true;\n }\n const c = await getCharacter(username, broadcasterId);\n if (!c) {\n await sendChatMessage(\n `@${display} create a character first with !createchar, then !dndduel monster.`,\n broadcasterId,\n );\n return true;\n }\n const monster = pickMonsterForLevel(c.level);\n await sqlite.execute(\n \"INSERT OR REPLACE INTO monster_duels (broadcaster_id,player,monster_name,monster_cr,monster_ac,monster_hp,monster_hp_max,monster_attack,monster_damage_die,monster_damage_bonus,current_turn,active,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)\",\n [\n broadcasterId,\n username,\n monster.name,\n monster.cr,\n monster.ac,\n monster.hp,\n monster.hp,\n monster.attack,\n monster.die,\n monster.bonus,\n \"player\",\n 1,\n Date.now(),\n ],\n );\n await sendChatMessage(\n `@${display} classic monster fight! ${monster.name} (CR ${monster.cr}) AC ${monster.ac}, HP ${monster.hp}. Your HP: ${c.hpMax}. ${\n duelNarration(\"challenge\")\n } Use !dndduel attack.`,\n broadcasterId,\n );\n return true;\n }\n\n // Auto monster: bare !dndduel\n if (normalized === \"!dndduel\") {\n const c = await getCharacter(username, broadcasterId);\n if (!c) {\n await sendChatMessage(\n `@${display} create a character first with !createchar, then challenge the wilds with !dndduel.`,\n broadcasterId,\n );\n return true;\n }\n const monster = pickMonsterForLevel(c.level);\n let playerHp = c.hpMax;\n let monsterHp = monster.hp;\n const pStats = combatStats(c);\n // Slightly forgiving AC for stream pacing\n const playerAc = 11 + pStats.mod + c.proficiency;\n const highlights: string[] = [];\n let swings = 0;\n const maxSwings = 40;\n const dmgDie = 10; // heroes hit a bit harder vs monsters than PvP d8\n\n // Decide the outcome up front so the win rate is exact regardless of the\n // specific monster/stat matchup; the rolls below still drive the blow-by-\n // blow narration.\n const playerShouldWin = Math.random() < AUTO_DUEL_PLAYER_WIN_RATE;\n\n while (playerHp > 0 && monsterHp > 0 && swings < maxSwings) {\n swings++;\n const roll = 1 + Math.floor(Math.random() * 20);\n const total = roll + pStats.mod + c.proficiency + 1; // +1 to-hit bias\n const critical = roll === 20;\n const hit = critical || (roll !== 1 && total >= monster.ac);\n const dice = critical\n ? 1 + Math.floor(Math.random() * dmgDie) + 1 +\n Math.floor(Math.random() * dmgDie)\n : 1 + Math.floor(Math.random() * dmgDie);\n const damage = hit ? Math.max(1, dice + pStats.mod + 1) : 0;\n if (hit) monsterHp = Math.max(0, monsterHp - damage);\n if (critical || monsterHp <= 0 || highlights.length < 4) {\n highlights.push(\n hit\n ? `${username}${\n critical ? \" CRIT\" : \"\"\n } ${damage}→${monster.name}(${monsterHp})`\n : `${username} miss`,\n );\n }\n if (monsterHp <= 0) break;\n const mRoll = 1 + Math.floor(Math.random() * 20);\n const mTotal = mRoll + monster.attack;\n const mHit = mRoll !== 1 && (mRoll === 20 || mTotal >= playerAc);\n const mDice = 1 + Math.floor(Math.random() * monster.die);\n const mDamage = mHit ? Math.max(1, mDice + monster.bonus) : 0;\n if (mHit) playerHp = Math.max(0, playerHp - mDamage);\n if (mRoll === 20 || playerHp <= 0 || highlights.length < 8) {\n highlights.push(\n mHit\n ? `${monster.name} ${mDamage}→${username}(${playerHp})`\n : `${monster.name} miss`,\n );\n }\n }\n\n // If the natural rolls didn't land on the chosen outcome (mutual\n // knockout, or the fight timed out at maxSwings without a clean winner),\n // resolve the last exchange in the chosen winner's favor so the target\n // win rate actually holds over many duels.\n const playerNaturallyWon = monsterHp <= 0 && playerHp > 0;\n if (playerShouldWin !== playerNaturallyWon) {\n if (playerShouldWin) {\n monsterHp = 0;\n if (playerHp <= 0) playerHp = Math.max(1, Math.floor(c.hpMax * 0.15));\n highlights.push(\n `${username} turns the tide with a decisive final blow→${monster.name}(0)`,\n );\n } else {\n playerHp = 0;\n if (monsterHp <= 0) {\n monsterHp = Math.max(1, Math.floor(monster.hp * 0.15));\n }\n highlights.push(\n `${monster.name} turns the tide with a decisive final blow→${username}(0)`,\n );\n }\n }\n\n await sqlite.execute(\"DELETE FROM monster_duels WHERE broadcaster_id = ?\", [\n broadcasterId,\n ]);\n const won = monsterHp <= 0 && playerHp > 0;\n let xpNote = \"\";\n if (won) {\n const xp = await awardMonsterXp(username, monster.cr, broadcasterId);\n if (xp) {\n xpNote = ` +${xp.gained} XP (total ${xp.total})${\n xp.leveledTo ? ` — leveled to ${xp.leveledTo}!` : \"\"\n }`;\n }\n }\n await sendChatMessages(\n `@${display} the D20 of Fate summons a ${monster.name} (CR ${monster.cr}, AC ${monster.ac}, HP ${monster.hp})! ${\n duelNarration(\"challenge\")\n } Auto-resolved (${swings} exchanges): ${highlights.join(\" · \")} — ${\n won\n ? `${username} defeats ${monster.name}! ${\n duelNarration(\"victory\")\n }${xpNote}`\n : `${monster.name} wins. ${duelNarration(\"defeat\")}`\n } Final HP: you ${playerHp}/${c.hpMax}, ${monster.name} ${monsterHp}/${monster.hp}.`,\n broadcasterId,\n );\n return true;\n }\n\n if (\n (normalized === \"!dndduel attack\" ||\n normalized === \"!dndduel monster attack\") &&\n active &&\n active.player === username\n ) {\n if (active.current_turn !== \"player\") {\n await sendChatMessage(\n `@${display} the monster is still acting.`,\n broadcasterId,\n );\n return true;\n }\n const player = await getCharacter(username, broadcasterId);\n if (!player) {\n await sendChatMessage(\n `@${display} your character no longer exists.`,\n broadcasterId,\n );\n return true;\n }\n const pStats = combatStats(player);\n const playerHp = Number(active.player_hp ?? player.hpMax);\n const roll = 1 + Math.floor(Math.random() * 20);\n const toHitBonus = pStats.mod + player.proficiency + 1;\n const total = roll + toHitBonus;\n const critical = roll === 20;\n const hit = critical || (roll !== 1 && total >= Number(active.monster_ac));\n const dmgDie = 10;\n const dice = critical\n ? 1 + Math.floor(Math.random() * dmgDie) + 1 +\n Math.floor(Math.random() * dmgDie)\n : 1 + Math.floor(Math.random() * dmgDie);\n const damage = hit ? Math.max(1, dice + pStats.mod + 1) : 0;\n active.monster_hp = Math.max(0, Number(active.monster_hp) - damage);\n const playerResult =\n `${username} attacks ${active.monster_name}: d20 ${roll}${\n critical ? \" CRITICAL\" : \"\"\n } + ${toHitBonus} = ${total} vs AC ${active.monster_ac}; ${\n hit ? `hit for ${damage} damage` : \"miss\"\n }. ${duelNarration(critical ? \"critical\" : hit ? \"hit\" : \"miss\")}`;\n if (active.monster_hp <= 0) {\n await sqlite.execute(\n \"DELETE FROM monster_duels WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n const xp = await awardMonsterXp(\n username,\n String(active.monster_cr ?? \"1\"),\n broadcasterId,\n );\n const xpNote = xp\n ? ` +${xp.gained} XP (total ${xp.total})${\n xp.leveledTo ? ` — leveled to ${xp.leveledTo}!` : \"\"\n }`\n : \"\";\n await sendChatMessage(\n `@${display} ${playerResult} ${active.monster_name} is defeated! ${\n duelNarration(\"victory\")\n }${xpNote}`,\n broadcasterId,\n );\n return true;\n }\n const monsterRoll = 1 + Math.floor(Math.random() * 20);\n const monsterTotal = monsterRoll + Number(active.monster_attack);\n const playerAc = 11 + pStats.mod + player.proficiency;\n const monsterHit = monsterRoll !== 1 &&\n (monsterRoll === 20 || monsterTotal >= playerAc);\n const monsterDice = 1 +\n Math.floor(Math.random() * Number(active.monster_damage_die));\n const monsterDamage = monsterHit\n ? Math.max(1, monsterDice + Number(active.monster_damage_bonus))\n : 0;\n const nextPlayerHp = Math.max(0, playerHp - monsterDamage);\n active.player_hp = nextPlayerHp;\n const monsterResult =\n `${active.monster_name} retaliates: d20 ${monsterRoll} + ${active.monster_attack} = ${monsterTotal} vs AC ${playerAc}; ${\n monsterHit ? `hit for ${monsterDamage} damage` : \"miss\"\n }. ${duelNarration(monsterHit ? \"hit\" : \"miss\")}`;\n if (nextPlayerHp <= 0) {\n await sqlite.execute(\n \"DELETE FROM monster_duels WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n await sendChatMessages(\n `@${display} ${playerResult} ${monsterResult} ${\n duelNarration(\"defeat\")\n } ${active.monster_name} wins this encounter.`,\n broadcasterId,\n );\n } else {\n await sqlite.execute(\n \"UPDATE monster_duels SET player_hp = ?, monster_hp = ?, current_turn = ?, updated_at = ? WHERE broadcaster_id = ?\",\n [nextPlayerHp, active.monster_hp, \"player\", Date.now(), broadcasterId],\n );\n await sendChatMessages(\n `@${display} ${playerResult} ${monsterResult} ${await monsterDuelText({\n ...active,\n player_hp: nextPlayerHp,\n })}`,\n broadcasterId,\n );\n }\n return true;\n }\n\n return false;\n}\n\nexport async function partySummary(broadcasterId: string, partyName: string) {\n const party = await getParty(broadcasterId, partyName);\n if (!party) return `party ${partyName} was not found`;\n const members = await getPartyMembers(broadcasterId, partyName);\n return `${party.party_name} (leader ${party.owner}): ${\n members.length ? members.join(\", \") : \"no members\"\n }`;\n}\n\nexport async function handlePartyCommand(\n chatMessage: string,\n username: string,\n display: string,\n broadcasterId: string,\n) {\n if (!/^!party(?:\\s|$)/i.test(chatMessage)) return false;\n // Twitch logins are case-insensitive; always normalize for storage/lookup.\n const me = username.toLowerCase();\n const parts = chatMessage.trim().split(/\\s+/);\n const action = (parts[1] ?? \"list\").toLowerCase();\n const sanitizeParty = (raw: string) =>\n (raw ?? \"\").replace(/^@/, \"\").toLowerCase().replace(/[^a-z0-9_-]/g, \"\");\n const name = sanitizeParty(parts[2] ?? \"\");\n\n if (action === \"create\") {\n if (!name) {\n await sendChatMessage(\n `@${display} use !party create .`,\n broadcasterId,\n );\n return true;\n }\n if (await getParty(broadcasterId, name)) {\n await sendChatMessage(\n `@${display} that party already exists.`,\n broadcasterId,\n );\n return true;\n }\n // Creator is always owner AND a member so they can invite immediately.\n await sqlite.execute(\n \"INSERT INTO parties (broadcaster_id,party_name,owner,created_at) VALUES (?,?,?,?)\",\n [broadcasterId, name, me, Date.now()],\n );\n await sqlite.execute(\n \"INSERT OR IGNORE INTO party_members (broadcaster_id,party_name,username,joined_at) VALUES (?,?,?,?)\",\n [broadcasterId, name, me, Date.now()],\n );\n await sendChatMessage(\n `@${display} party ${name} created. You are the leader and a member. Invite with !party invite @user ${name}`,\n broadcasterId,\n );\n return true;\n }\n\n if (action === \"join\") {\n const party = await getParty(broadcasterId, name);\n if (!party) {\n await sendChatMessage(\n `@${display} party ${name} was not found.`,\n broadcasterId,\n );\n } else if (!(await getCharacter(me, broadcasterId))) {\n await sendChatMessage(\n `@${display} create a character before joining a party.`,\n broadcasterId,\n );\n } else {\n await sqlite.execute(\n \"INSERT OR IGNORE INTO party_members (broadcaster_id,party_name,username,joined_at) VALUES (?,?,?,?)\",\n [broadcasterId, name, me, Date.now()],\n );\n await sendChatMessage(`@${display} joined party ${name}.`, broadcasterId);\n }\n return true;\n }\n\n if (action === \"leave\") {\n if (!name) {\n await sendChatMessage(\n `@${display} use !party leave .`,\n broadcasterId,\n );\n return true;\n }\n const party = await getParty(broadcasterId, name);\n if (!party) {\n await sendChatMessage(\n `@${display} party ${name} was not found.`,\n broadcasterId,\n );\n } else if (String(party.owner).toLowerCase() === me) {\n await sendChatMessage(\n `@${display} leaders must use !party disband ${name}.`,\n broadcasterId,\n );\n } else {\n await sqlite.execute(\n \"DELETE FROM party_members WHERE broadcaster_id = ? AND party_name = ? AND username = ?\",\n [broadcasterId, name, me],\n );\n await sendChatMessage(`@${display} left party ${name}.`, broadcasterId);\n }\n return true;\n }\n\n if (action === \"invite\") {\n const target = (parts[2] ?? \"\").replace(/^@/, \"\").toLowerCase().replace(\n /[,:]+$/,\n \"\",\n );\n let partyName = sanitizeParty(parts[3] ?? \"\");\n\n // If party name omitted, use a party this user owns (or is the only member of).\n if (target && !partyName) {\n const owned = await sqlite.execute(\n \"SELECT party_name FROM parties WHERE broadcaster_id = ? AND lower(owner) = ? ORDER BY created_at ASC\",\n [broadcasterId, me],\n );\n if (owned.rows.length === 1) {\n partyName = String(owned.rows[0].party_name);\n } else {\n const membership = await sqlite.execute(\n \"SELECT party_name FROM party_members WHERE broadcaster_id = ? AND lower(username) = ? ORDER BY party_name\",\n [broadcasterId, me],\n );\n if (membership.rows.length === 1) {\n partyName = String(membership.rows[0].party_name);\n }\n }\n }\n\n if (!target || !partyName) {\n await sendChatMessage(\n `@${display} use !party invite @user (party name optional if you only lead/belong to one party).`,\n broadcasterId,\n );\n return true;\n }\n\n const party = await getParty(broadcasterId, partyName);\n if (!party) {\n await sendChatMessage(\n `@${display} party ${partyName} was not found.`,\n broadcasterId,\n );\n return true;\n }\n\n // Repair: if this user is the owner but missing from members, add them.\n const ownerName = String(party.owner).toLowerCase();\n if (ownerName === me) {\n await sqlite.execute(\n \"INSERT OR IGNORE INTO party_members (broadcaster_id,party_name,username,joined_at) VALUES (?,?,?,?)\",\n [broadcasterId, partyName, me, Date.now()],\n );\n }\n\n const members = (await getPartyMembers(broadcasterId, partyName)).map((m) =>\n m.toLowerCase()\n );\n const isOwner = ownerName === me;\n const isMember = members.includes(me);\n if (!isOwner && !isMember) {\n await sendChatMessage(\n `@${display} only a party member or the leader can invite someone to that party.`,\n broadcasterId,\n );\n return true;\n }\n if (target === me) {\n await sendChatMessage(\n `@${display} you are already in party ${partyName}.`,\n broadcasterId,\n );\n return true;\n }\n if (!(await getCharacter(target, broadcasterId))) {\n await sendChatMessage(\n `@${display} that player needs a saved character first.`,\n broadcasterId,\n );\n return true;\n }\n // Require the invitee's consent — don't add them straight to the roster.\n await createPartyInvite(broadcasterId, partyName, target, me);\n await sendChatMessage(\n `@${display} invited @${target} to party ${partyName}. @${target}: reply !party accept${\n partyName ? ` ${partyName}` : \"\"\n } or !party decline${partyName ? ` ${partyName}` : \"\"}.`,\n broadcasterId,\n );\n return true;\n }\n\n if (action === \"accept\" || action === \"decline\") {\n let partyName = sanitizeParty(parts[2] ?? \"\");\n if (!partyName) {\n const invites = await getPartyInvites(broadcasterId, me);\n if (invites.length === 1) {\n partyName = String(invites[0].party_name);\n } else if (invites.length > 1) {\n await sendChatMessage(\n `@${display} you have pending invites to: ${\n invites.map((i: any) => i.party_name).join(\", \")\n }. Use !party ${action} .`,\n broadcasterId,\n );\n return true;\n }\n }\n if (!partyName) {\n await sendChatMessage(\n `@${display} you have no pending party invites.`,\n broadcasterId,\n );\n return true;\n }\n const invite = await getPartyInvite(broadcasterId, me, partyName);\n if (!invite) {\n await sendChatMessage(\n `@${display} you have no pending invite to party ${partyName}.`,\n broadcasterId,\n );\n return true;\n }\n await deletePartyInvite(broadcasterId, partyName, me);\n if (action === \"decline\") {\n await sendChatMessage(\n `@${display} declined the invite to party ${partyName}.`,\n broadcasterId,\n );\n return true;\n }\n const party = await getParty(broadcasterId, partyName);\n if (!party) {\n await sendChatMessage(\n `@${display} party ${partyName} no longer exists.`,\n broadcasterId,\n );\n return true;\n }\n await sqlite.execute(\n \"INSERT OR IGNORE INTO party_members (broadcaster_id,party_name,username,joined_at) VALUES (?,?,?,?)\",\n [broadcasterId, partyName, me, Date.now()],\n );\n await sendChatMessage(\n `@${display} joined party ${partyName}.`,\n broadcasterId,\n );\n return true;\n }\n\n if (action === \"disband\") {\n const party = await getParty(broadcasterId, name);\n if (!party) {\n await sendChatMessage(\n `@${display} party ${name} was not found.`,\n broadcasterId,\n );\n } else if (String(party.owner).toLowerCase() !== me) {\n await sendChatMessage(\n `@${display} only the party leader can disband that party.`,\n broadcasterId,\n );\n } else {\n await sqlite.execute(\n \"DELETE FROM party_members WHERE broadcaster_id = ? AND party_name = ?\",\n [\n broadcasterId,\n name,\n ],\n );\n await sqlite.execute(\n \"DELETE FROM parties WHERE broadcaster_id = ? AND party_name = ?\",\n [\n broadcasterId,\n name,\n ],\n );\n await sendChatMessage(\n `@${display} party ${name} disbanded.`,\n broadcasterId,\n );\n }\n return true;\n }\n\n if (action === \"list\" || action === \"show\") {\n if (name) {\n await sendChatMessages(\n `@${display} ${await partySummary(broadcasterId, name)}.`,\n broadcasterId,\n );\n } else {\n const res = await sqlite.execute(\n \"SELECT party_name FROM party_members WHERE broadcaster_id = ? AND lower(username) = ? ORDER BY party_name\",\n [broadcasterId, me],\n );\n if (!res.rows.length) {\n await sendChatMessage(\n `@${display} you are not in any parties. Create one with !party create .`,\n broadcasterId,\n );\n } else {\n const summaries: string[] = [];\n for (const row of res.rows) {\n summaries.push(\n await partySummary(broadcasterId, String(row.party_name)),\n );\n }\n await sendChatMessages(\n `@${display} your parties — ${summaries.join(\" | \")}`,\n broadcasterId,\n );\n }\n }\n return true;\n }\n\n await sendChatMessage(\n `@${display} Party: !party create | !party join | !party invite @user | !party accept/decline [name] | !party list [name] | !party leave | !party disband .`,\n broadcasterId,\n );\n return true;\n}\n\nexport async function partyDuelText(d: any) {\n const left = d.challenger_members.map((n: string) =>\n `${n} ${d.challenger_hp[n] ?? 0} HP`\n ).join(\", \");\n const right = d.defender_members.map((n: string) =>\n `${n} ${d.defender_hp[n] ?? 0} HP`\n ).join(\", \");\n const active = d.current_side === \"challenger\"\n ? d.challenger_members[d.current_index]\n : d.defender_members[d.current_index];\n return `Party duel ${d.challenger_party} [${left}] vs ${d.defender_party} [${right}]. Turn: ${\n active ?? \"none\"\n }.`;\n}\n\nexport async function handlePartyDuelCommand(\n chatMessage: string,\n username: string,\n display: string,\n broadcasterId: string,\n) {\n if (!/^!dndduel\\s+party(?:\\s|$)/i.test(chatMessage)) return false;\n const parts = chatMessage.trim().split(/\\s+/);\n const sub = (parts[2] ?? \"\").toLowerCase();\n let active = await getPartyDuel(broadcasterId);\n const me = username.toLowerCase();\n\n // ── Party vs monster (hunt): party fights one scaled monster together ──\n // !dndduel party hunt → auto\n // !dndduel party hunt classic → turn-based\n // !dndduel party hunt attack|status|end\n if (sub === \"hunt\") {\n const huntAction = (parts[3] ?? \"\").toLowerCase();\n const partyHunt = await getPartyMonsterDuel(broadcasterId);\n\n if (huntAction === \"status\" || huntAction === \"show\") {\n if (!partyHunt) {\n await sendChatMessage(\n `@${display} no active party hunt. Start with !dndduel party hunt .`,\n broadcasterId,\n );\n return true;\n }\n const roster = partyHunt.members\n .map((n: string) => `${n} ${partyHunt.member_hp[n] ?? 0}HP`)\n .join(\", \");\n const turn = partyHunt.members[partyHunt.current_index] ?? \"?\";\n await sendChatMessage(\n `@${display} Party hunt ${partyHunt.party_name} vs ${partyHunt.monster_name} (CR ${partyHunt.monster_cr}) HP ${partyHunt.monster_hp}/${partyHunt.monster_hp_max} AC ${partyHunt.monster_ac}. Party: [${roster}]. Turn: ${turn}.`,\n broadcasterId,\n );\n return true;\n }\n\n if (huntAction === \"end\" || huntAction === \"cancel\") {\n if (!partyHunt) {\n await sendChatMessage(\n `@${display} no active party hunt.`,\n broadcasterId,\n );\n return true;\n }\n if (!partyHunt.members.map((m: string) => m.toLowerCase()).includes(me)) {\n await sendChatMessage(\n `@${display} only a hunting party member can end this hunt.`,\n broadcasterId,\n );\n return true;\n }\n await sqlite.execute(\n \"DELETE FROM party_monster_duels WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n await sendChatMessage(\n `@${display} party hunt ended. The party retreats.`,\n broadcasterId,\n );\n return true;\n }\n\n if (huntAction === \"attack\") {\n if (!partyHunt) {\n await sendChatMessage(\n `@${display} no active party hunt. Start with !dndduel party hunt classic .`,\n broadcasterId,\n );\n return true;\n }\n const attackerName = partyHunt.members[partyHunt.current_index];\n if (!attackerName || attackerName.toLowerCase() !== me) {\n await sendChatMessage(\n `@${display} it is ${attackerName ?? \"someone else\"}'s turn.`,\n broadcasterId,\n );\n return true;\n }\n if ((partyHunt.member_hp[attackerName] ?? 0) <= 0) {\n await sendChatMessage(\n `@${display} you are down and cannot attack.`,\n broadcasterId,\n );\n return true;\n }\n const attacker = await getCharacter(attackerName, broadcasterId);\n if (!attacker) {\n await sendChatMessage(\n `@${display} your character no longer exists.`,\n broadcasterId,\n );\n return true;\n }\n const stats = combatStats(attacker);\n const roll = 1 + Math.floor(Math.random() * 20);\n const total = roll + stats.mod + attacker.proficiency;\n const critical = roll === 20;\n const hit = critical ||\n (roll !== 1 && total >= Number(partyHunt.monster_ac));\n const dice = critical\n ? 1 + Math.floor(Math.random() * 8) + 1 + Math.floor(Math.random() * 8)\n : 1 + Math.floor(Math.random() * 8);\n const damage = hit ? Math.max(1, dice + stats.mod) : 0;\n partyHunt.monster_hp = Math.max(0, Number(partyHunt.monster_hp) - damage);\n const playerResult =\n `${attackerName} attacks ${partyHunt.monster_name}: d20 ${roll}${\n critical ? \" CRITICAL\" : \"\"\n } + ${\n stats.mod + attacker.proficiency\n } = ${total} vs AC ${partyHunt.monster_ac}; ${\n hit ? `hit for ${damage}` : \"miss\"\n }. ${duelNarration(critical ? \"critical\" : hit ? \"hit\" : \"miss\")}`;\n\n if (partyHunt.monster_hp <= 0) {\n await sqlite.execute(\n \"DELETE FROM party_monster_duels WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n const xpNotes: string[] = [];\n for (const n of partyHunt.members) {\n if ((partyHunt.member_hp[n] ?? 0) > 0) {\n const xp = await awardMonsterXp(\n n,\n String(partyHunt.monster_cr),\n broadcasterId,\n );\n if (xp) xpNotes.push(`${n}+${xp.gained}`);\n }\n }\n await sendChatMessages(\n `@${display} ${playerResult} ${partyHunt.monster_name} falls! ${\n duelNarration(\"victory\")\n } XP: ${xpNotes.join(\", \") || \"none\"}.`,\n broadcasterId,\n );\n return true;\n }\n\n // Monster strikes a random living party member after each player attack\n const living = partyHunt.members.filter((n: string) =>\n (partyHunt.member_hp[n] ?? 0) > 0\n );\n const targetName = living[Math.floor(Math.random() * living.length)] ??\n attackerName;\n const targetChar = await getCharacter(targetName, broadcasterId);\n const tStats = targetChar\n ? combatStats(targetChar)\n : { mod: 0, attack: 10 };\n const playerAc = 10 + tStats.mod + (targetChar?.proficiency ?? 2);\n const mRoll = 1 + Math.floor(Math.random() * 20);\n const mTotal = mRoll + Number(partyHunt.monster_attack);\n const mHit = mRoll !== 1 && (mRoll === 20 || mTotal >= playerAc);\n const mDice = 1 +\n Math.floor(Math.random() * Number(partyHunt.monster_damage_die));\n const mDamage = mHit\n ? Math.max(1, mDice + Number(partyHunt.monster_damage_bonus))\n : 0;\n if (mHit) {\n partyHunt.member_hp[targetName] = Math.max(\n 0,\n (partyHunt.member_hp[targetName] ?? 0) - mDamage,\n );\n }\n const monsterResult =\n `${partyHunt.monster_name} strikes ${targetName}: d20 ${mRoll} + ${partyHunt.monster_attack} = ${mTotal} vs AC ${playerAc}; ${\n mHit ? `hit for ${mDamage}` : \"miss\"\n }.`;\n\n const stillAlive = partyHunt.members.some((n: string) =>\n (partyHunt.member_hp[n] ?? 0) > 0\n );\n if (!stillAlive) {\n await sqlite.execute(\n \"DELETE FROM party_monster_duels WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n await sendChatMessages(\n `@${display} ${playerResult} ${monsterResult} ${\n duelNarration(\"defeat\")\n } The party is wiped.`,\n broadcasterId,\n );\n return true;\n }\n\n // Advance to next living member\n let idx = partyHunt.current_index;\n for (let i = 0; i < partyHunt.members.length; i++) {\n idx = (idx + 1) % partyHunt.members.length;\n if ((partyHunt.member_hp[partyHunt.members[idx]] ?? 0) > 0) break;\n }\n partyHunt.current_index = idx;\n await sqlite.execute(\n \"UPDATE party_monster_duels SET member_hp = ?, monster_hp = ?, current_index = ?, updated_at = ? WHERE broadcaster_id = ?\",\n [\n JSON.stringify(partyHunt.member_hp),\n partyHunt.monster_hp,\n partyHunt.current_index,\n Date.now(),\n broadcasterId,\n ],\n );\n const roster = partyHunt.members.map((n: string) =>\n `${n} ${partyHunt.member_hp[n]}HP`\n ).join(\", \");\n await sendChatMessages(\n `@${display} ${playerResult} ${monsterResult} Monster HP ${partyHunt.monster_hp}/${partyHunt.monster_hp_max}. Party: [${roster}]. Next: ${\n partyHunt.members[partyHunt.current_index]\n }.`,\n broadcasterId,\n );\n return true;\n }\n\n // Start hunt: !dndduel party hunt [classic] \n let classic = false;\n let partyName = \"\";\n if (\n huntAction === \"classic\" || huntAction === \"turn\" ||\n huntAction === \"manual\"\n ) {\n classic = true;\n partyName = (parts[4] ?? \"\").toLowerCase().replace(/[^a-z0-9_-]/g, \"\");\n } else {\n partyName = huntAction.replace(/[^a-z0-9_-]/g, \"\");\n }\n if (!partyName) {\n await sendChatMessage(\n `@${display} Party hunt: !dndduel party hunt (auto) | !dndduel party hunt classic | !dndduel party hunt attack | status | end`,\n broadcasterId,\n );\n return true;\n }\n if (partyHunt) {\n await sendChatMessage(\n `@${display} a party hunt is already active. Use !dndduel party hunt status or end.`,\n broadcasterId,\n );\n return true;\n }\n const party = await getParty(broadcasterId, partyName);\n const members = await getPartyMembers(broadcasterId, partyName);\n if (!party || !members.length) {\n await sendChatMessage(\n `@${display} party ${partyName} was not found or has no members.`,\n broadcasterId,\n );\n return true;\n }\n if (\n String(party.owner).toLowerCase() !== me &&\n !members.map((m) => m.toLowerCase()).includes(me)\n ) {\n await sendChatMessage(\n `@${display} only a party member can start a hunt for that party.`,\n broadcasterId,\n );\n return true;\n }\n\n const chars: Record = {};\n const memberHp: Record = {};\n let levelSum = 0;\n for (const n of members) {\n const c = await getCharacter(n, broadcasterId);\n if (c) {\n chars[n] = c;\n memberHp[n] = c.hpMax;\n levelSum += c.level;\n }\n }\n const livingMembers = members.filter((n) => chars[n]);\n if (livingMembers.length < 1) {\n await sendChatMessage(\n `@${display} at least one party member needs a saved character.`,\n broadcasterId,\n );\n return true;\n }\n const avgLevel = Math.max(1, Math.round(levelSum / livingMembers.length));\n // Scale monster gently for group size (still player-favored).\n const monster = pickMonsterForLevel(avgLevel);\n const sizeScale = 0.5 + livingMembers.length * 0.22; // 1p~0.72, 2p~0.94, 3p~1.16\n monster.hp = Math.max(10, Math.round(monster.hp * sizeScale));\n monster.attack = Math.max(\n 2,\n monster.attack + Math.floor((livingMembers.length - 1) / 3),\n );\n\n if (!classic) {\n // Auto-resolve: each living member attacks, then monster hits a random member\n let monsterHp = monster.hp;\n const hp = { ...memberHp };\n const highlights: string[] = [];\n let swings = 0;\n const maxSwings = 100;\n while (\n monsterHp > 0 && livingMembers.some((n) => hp[n] > 0) &&\n swings < maxSwings\n ) {\n swings++;\n for (const n of livingMembers) {\n if (hp[n] <= 0 || monsterHp <= 0) continue;\n const stats = combatStats(chars[n]);\n const roll = 1 + Math.floor(Math.random() * 20);\n const total = roll + stats.mod + chars[n].proficiency;\n const critical = roll === 20;\n const hit = critical || (roll !== 1 && total >= monster.ac);\n const dice = critical\n ? 1 + Math.floor(Math.random() * 8) + 1 +\n Math.floor(Math.random() * 8)\n : 1 + Math.floor(Math.random() * 8);\n const damage = hit ? Math.max(1, dice + stats.mod) : 0;\n if (hit) monsterHp = Math.max(0, monsterHp - damage);\n if (critical || monsterHp <= 0 || highlights.length < 10) {\n highlights.push(\n hit ? `${n}${critical ? \" CRIT\" : \"\"} ${damage}` : `${n} miss`,\n );\n }\n }\n if (monsterHp <= 0) break;\n const living = livingMembers.filter((n) => hp[n] > 0);\n if (!living.length) break;\n const victim = living[Math.floor(Math.random() * living.length)];\n const vStats = combatStats(chars[victim]);\n const playerAc = 10 + vStats.mod + chars[victim].proficiency;\n const mRoll = 1 + Math.floor(Math.random() * 20);\n const mTotal = mRoll + monster.attack;\n const mHit = mRoll !== 1 && (mRoll === 20 || mTotal >= playerAc);\n const mDice = 1 + Math.floor(Math.random() * monster.die);\n const mDamage = mHit ? Math.max(1, mDice + monster.bonus) : 0;\n if (mHit) hp[victim] = Math.max(0, hp[victim] - mDamage);\n if (mRoll === 20 || hp[victim] <= 0 || highlights.length < 14) {\n highlights.push(\n mHit\n ? `${monster.name}→${victim} ${mDamage}`\n : `${monster.name} miss`,\n );\n }\n }\n const partyWon = monsterHp <= 0 && livingMembers.some((n) => hp[n] > 0);\n const xpNotes: string[] = [];\n if (partyWon) {\n for (const n of livingMembers) {\n if (hp[n] > 0) {\n const xp = await awardMonsterXp(n, monster.cr, broadcasterId);\n if (xp) {\n xpNotes.push(\n `${n}+${xp.gained}${xp.leveledTo ? `→Lv${xp.leveledTo}` : \"\"}`,\n );\n }\n }\n }\n }\n const roster = livingMembers.map((n) => `${n}:${hp[n]}`).join(\", \");\n await sendChatMessages(\n `@${display} party ${partyName} hunts a ${monster.name} (CR ${monster.cr}, AC ${monster.ac}, HP ${monster.hp})! ${\n duelNarration(\"challenge\")\n } Auto (${swings} rounds): ${highlights.join(\" · \")} — ${\n partyWon\n ? `Victory! ${duelNarration(\"victory\")} XP: ${xpNotes.join(\", \")}`\n : `Defeat. ${duelNarration(\"defeat\")}`\n } Final party HP [${roster}]; monster ${monsterHp}/${monster.hp}.`,\n broadcasterId,\n );\n return true;\n }\n\n // Classic party hunt\n await sqlite.execute(\n \"INSERT OR REPLACE INTO party_monster_duels (broadcaster_id,party_name,members,member_hp,current_index,monster_name,monster_cr,monster_ac,monster_hp,monster_hp_max,monster_attack,monster_damage_die,monster_damage_bonus,active,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,1,?)\",\n [\n broadcasterId,\n partyName,\n JSON.stringify(livingMembers),\n JSON.stringify(\n Object.fromEntries(livingMembers.map((n) => [n, memberHp[n]])),\n ),\n 0,\n monster.name,\n monster.cr,\n monster.ac,\n monster.hp,\n monster.hp,\n monster.attack,\n monster.die,\n monster.bonus,\n Date.now(),\n ],\n );\n await sendChatMessage(\n `@${display} classic party hunt! ${partyName} vs ${monster.name} (CR ${monster.cr}) AC ${monster.ac}, HP ${monster.hp}. ${\n livingMembers[0]\n } goes first. ${\n duelNarration(\"challenge\")\n } Use !dndduel party hunt attack.`,\n broadcasterId,\n );\n return true;\n }\n\n if (sub === \"accept\" || sub === \"decline\") {\n const res = await sqlite.execute(\n \"SELECT * FROM party_duel_challenges WHERE broadcaster_id = ? AND defender_owner = ? ORDER BY created_at DESC LIMIT 1\",\n [broadcasterId, username],\n );\n if (!res.rows.length) {\n await sendChatMessage(\n `@${display} no party duel challenge is waiting for you.`,\n broadcasterId,\n );\n return true;\n }\n const challenge = res.rows[0];\n const mode = String(challenge.mode || \"auto\").toLowerCase() === \"classic\"\n ? \"classic\"\n : \"auto\";\n await sqlite.execute(\n \"DELETE FROM party_duel_challenges WHERE broadcaster_id = ? AND defender_owner = ?\",\n [\n broadcasterId,\n username,\n ],\n );\n if (sub === \"decline\") {\n await sendChatMessage(\n `@${display} party duel declined. ${duelNarration(\"decline\")}`,\n broadcasterId,\n );\n return true;\n }\n const attackers = await getPartyMembers(\n broadcasterId,\n challenge.challenger_party,\n );\n const defenders = await getPartyMembers(\n broadcasterId,\n challenge.defender_party,\n );\n const aChars: Record = {};\n const dChars: Record = {};\n const aHp: Record = {};\n const dHp: Record = {};\n for (const n of attackers) {\n const c = await getCharacter(n, broadcasterId);\n if (c) {\n aChars[n] = c;\n aHp[n] = c.hpMax;\n }\n }\n for (const n of defenders) {\n const c = await getCharacter(n, broadcasterId);\n if (c) {\n dChars[n] = c;\n dHp[n] = c.hpMax;\n }\n }\n if (\n !attackers.length ||\n !defenders.length ||\n Object.keys(aHp).length !== attackers.length ||\n Object.keys(dHp).length !== defenders.length\n ) {\n await sendChatMessage(\n `@${display} both parties need at least one member with a saved character.`,\n broadcasterId,\n );\n return true;\n }\n\n if (mode === \"classic\") {\n await sqlite.execute(\n \"INSERT OR REPLACE INTO party_duels (broadcaster_id,challenger_party,defender_party,current_side,current_index,challenger_members,defender_members,challenger_hp,defender_hp,active,updated_at) VALUES (?,?,?,?,?,?,?,?,?,1,?)\",\n [\n broadcasterId,\n challenge.challenger_party,\n challenge.defender_party,\n \"challenger\",\n 0,\n JSON.stringify(attackers),\n JSON.stringify(defenders),\n JSON.stringify(aHp),\n JSON.stringify(dHp),\n Date.now(),\n ],\n );\n await sendChatMessage(\n `@${display} classic party duel accepted! ${challenge.challenger_party} goes first. ${\n duelNarration(\"accept\")\n } Use !dndduel party attack [@target].`,\n broadcasterId,\n );\n return true;\n }\n\n // Auto-resolve party duel\n const highlights: string[] = [];\n let side: \"challenger\" | \"defender\" = \"challenger\";\n let swings = 0;\n const maxSwings = 80;\n while (\n attackers.some((n) => aHp[n] > 0) &&\n defenders.some((n) => dHp[n] > 0) &&\n swings < maxSwings\n ) {\n swings++;\n const atkMembers = side === \"challenger\" ? attackers : defenders;\n const atkHp = side === \"challenger\" ? aHp : dHp;\n const atkChars = side === \"challenger\" ? aChars : dChars;\n const defMembers = side === \"challenger\" ? defenders : attackers;\n const defHp = side === \"challenger\" ? dHp : aHp;\n const defChars = side === \"challenger\" ? dChars : aChars;\n const attackerName = atkMembers.find((n) => atkHp[n] > 0);\n const defenderName = defMembers.find((n) => defHp[n] > 0);\n if (!attackerName || !defenderName) break;\n const line = simulateAttack(\n attackerName,\n defenderName,\n atkChars[attackerName],\n defChars[defenderName],\n defHp,\n );\n if (\n line.includes(\"CRIT\") || defHp[defenderName] <= 0 ||\n highlights.length < 8\n ) {\n highlights.push(line);\n }\n side = side === \"challenger\" ? \"defender\" : \"challenger\";\n }\n const challengerAlive = attackers.some((n) => aHp[n] > 0);\n const winnerParty = challengerAlive\n ? challenge.challenger_party\n : challenge.defender_party;\n const left = attackers.map((n) => `${n}:${aHp[n]}`).join(\",\");\n const right = defenders.map((n) => `${n}:${dHp[n]}`).join(\",\");\n await sqlite.execute(\"DELETE FROM party_duels WHERE broadcaster_id = ?\", [\n broadcasterId,\n ]);\n await sendChatMessages(\n `@${display} party duel accepted! ${\n duelNarration(\"accept\")\n } ${challenge.challenger_party} vs ${challenge.defender_party} auto-resolved (${swings} swings). ${\n highlights.join(\" · \")\n } — ${winnerParty} wins! ${\n duelNarration(\"victory\")\n } HP [${left}] vs [${right}]`,\n broadcasterId,\n );\n return true;\n }\n\n if (sub === \"status\" || sub === \"show\") {\n active = active ?? null;\n await sendChatMessage(\n active\n ? `@${display} ${await partyDuelText(active)}`\n : `@${display} no active party duel.`,\n broadcasterId,\n );\n return true;\n }\n\n if (sub === \"end\") {\n if (!active) {\n await sendChatMessage(`@${display} no active party duel.`, broadcasterId);\n } else {\n const all = [...active.challenger_members, ...active.defender_members];\n const member = all.includes(username);\n const ownerA =\n (await getParty(broadcasterId, active.challenger_party))?.owner ===\n username;\n const ownerB =\n (await getParty(broadcasterId, active.defender_party))?.owner ===\n username;\n if (!member && !ownerA && !ownerB) {\n await sendChatMessage(\n `@${display} only a party member or leader can end this duel.`,\n broadcasterId,\n );\n } else {\n await sqlite.execute(\n \"DELETE FROM party_duels WHERE broadcaster_id = ?\",\n [broadcasterId],\n );\n await sendChatMessage(`@${display} party duel ended.`, broadcasterId);\n }\n }\n return true;\n }\n\n if (sub === \"attack\") {\n if (!active) {\n await sendChatMessage(`@${display} no active party duel.`, broadcasterId);\n return true;\n }\n const members = active.current_side === \"challenger\"\n ? active.challenger_members\n : active.defender_members;\n const ownHp = active.current_side === \"challenger\"\n ? active.challenger_hp\n : active.defender_hp;\n const enemyMembers = active.current_side === \"challenger\"\n ? active.defender_members\n : active.challenger_members;\n const enemyHp = active.current_side === \"challenger\"\n ? active.defender_hp\n : active.challenger_hp;\n const attackerName = members[active.current_index];\n if (attackerName !== username) {\n await sendChatMessage(\n `@${display} it is ${attackerName}'s turn.`,\n broadcasterId,\n );\n return true;\n }\n const attacker = await getCharacter(attackerName, broadcasterId);\n const targetQuery = parts[3]?.replace(/^@/, \"\").toLowerCase();\n const targetName =\n targetQuery && enemyMembers.includes(targetQuery) &&\n enemyHp[targetQuery] > 0\n ? targetQuery\n : enemyMembers.find((n: string) => enemyHp[n] > 0);\n const target = targetName\n ? await getCharacter(targetName, broadcasterId)\n : null;\n if (!attacker || !target || !targetName) {\n await sendChatMessage(\n `@${display} no living target remains.`,\n broadcasterId,\n );\n return true;\n }\n const stats = combatStats(attacker);\n const targetStats = combatStats(target);\n const roll = 1 + Math.floor(Math.random() * 20);\n const total = roll + stats.mod + attacker.proficiency;\n const critical = roll === 20;\n const hit = critical || (roll !== 1 && total >= targetStats.attack);\n const dice = critical\n ? 1 + Math.floor(Math.random() * 8) + (1 + Math.floor(Math.random() * 8))\n : 1 + Math.floor(Math.random() * 8);\n const damage = hit ? Math.max(1, dice + stats.mod) : 0;\n enemyHp[targetName] = Math.max(0, enemyHp[targetName] - damage);\n const result = `${attackerName} rolled ${roll}${\n critical ? \" CRITICAL\" : \"\"\n } + ${\n stats.mod + attacker.proficiency\n } = ${total} vs AC ${targetStats.attack}: ${\n hit ? `hit ${targetName} for ${damage} damage` : \"miss\"\n }. ${duelNarration(critical ? \"critical\" : hit ? \"hit\" : \"miss\")}`;\n const defeated = enemyMembers.every((n: string) => Number(enemyHp[n]) <= 0);\n if (defeated) {\n const winner = active.current_side === \"challenger\"\n ? active.challenger_party\n : active.defender_party;\n await sqlite.execute(\"DELETE FROM party_duels WHERE broadcaster_id = ?\", [\n broadcasterId,\n ]);\n await sendChatMessage(\n `@${display} ${result} ${winner} wins the party duel! ${\n duelNarration(\"victory\")\n }`,\n broadcasterId,\n );\n } else {\n const nextSide = active.current_side === \"challenger\"\n ? \"defender\"\n : \"challenger\";\n const nextMembers = nextSide === \"challenger\"\n ? active.challenger_members\n : active.defender_members;\n const nextHp = nextSide === \"challenger\"\n ? active.challenger_hp\n : active.defender_hp;\n active.current_side = nextSide;\n active.current_index = firstAlive(nextMembers, nextHp);\n await sqlite.execute(\n \"UPDATE party_duels SET current_side = ?, current_index = ?, challenger_hp = ?, defender_hp = ?, updated_at = ? WHERE broadcaster_id = ?\",\n [\n active.current_side,\n active.current_index,\n JSON.stringify(active.challenger_hp),\n JSON.stringify(active.defender_hp),\n Date.now(),\n broadcasterId,\n ],\n );\n await sendChatMessages(\n `@${display} ${result} ${await partyDuelText(active)}`,\n broadcasterId,\n );\n }\n return true;\n }\n\n // Challenge: !dndduel party (auto)\n // !dndduel party classic (turn-based)\n let partyMode: \"auto\" | \"classic\" = \"auto\";\n let challengerParty = \"\";\n let defenderParty = \"\";\n const p2 = (parts[2] ?? \"\").toLowerCase();\n const p3 = (parts[3] ?? \"\").toLowerCase();\n const p4 = (parts[4] ?? \"\").toLowerCase();\n if (p2 === \"classic\" || p2 === \"turn\" || p2 === \"manual\") {\n partyMode = \"classic\";\n challengerParty = p3;\n defenderParty = p4;\n } else if (p2 === \"auto\" || p2 === \"quick\") {\n partyMode = \"auto\";\n challengerParty = p3;\n defenderParty = p4;\n } else {\n challengerParty = p2;\n defenderParty = p3;\n }\n if (!challengerParty || !defenderParty) {\n await sendChatMessage(\n `@${display} Party duels: !dndduel party (auto) | !dndduel party classic (turn-based) | !dndduel party accept | !dndduel party decline`,\n broadcasterId,\n );\n return true;\n }\n if (active) {\n await sendChatMessage(\n `@${display} a classic party duel is already active in this channel.`,\n broadcasterId,\n );\n return true;\n }\n const ownParty = await getParty(broadcasterId, challengerParty);\n const targetParty = await getParty(broadcasterId, defenderParty);\n const ownMembers = ownParty\n ? await getPartyMembers(broadcasterId, challengerParty)\n : [];\n if (\n !ownParty || !targetParty ||\n String(ownParty.owner).toLowerCase() !== username.toLowerCase() ||\n !ownMembers.length\n ) {\n await sendChatMessage(\n `@${display} you must lead a non-empty party, and both parties must exist.`,\n broadcasterId,\n );\n return true;\n }\n if (String(targetParty.owner).toLowerCase() === username.toLowerCase()) {\n await sendChatMessage(\n `@${display} you cannot challenge your own party.`,\n broadcasterId,\n );\n return true;\n }\n await sqlite.execute(\n \"INSERT OR REPLACE INTO party_duel_challenges (broadcaster_id,challenger_party,defender_party,challenger_owner,defender_owner,created_at,mode) VALUES (?,?,?,?,?,?,?)\",\n [\n broadcasterId,\n challengerParty,\n defenderParty,\n username,\n targetParty.owner,\n Date.now(),\n partyMode,\n ],\n );\n await sendChatMessage(\n `@${display} party ${challengerParty} challenged party ${defenderParty} to a ${\n partyMode === \"classic\" ? \"classic turn-based\" : \"quick auto\"\n } duel! ${\n duelNarration(\"challenge\")\n } @${targetParty.owner}, use !dndduel party accept or !dndduel party decline.`,\n broadcasterId,\n );\n return true;\n}\n\nexport function encounterText(e: any) {\n const order = e.entries\n .map((x: any, i: number) =>\n `${\n i === e.currentIndex && e.active ? \"▶\" : \"•\"\n } ${x.name} ${x.initiative}`\n )\n .join(\" | \");\n return `Initiative R${e.round}: ${order || \"no combatants\"}`;\n}\n\nexport async function handleInitiativeCommand(\n chatMessage: string,\n broadcasterId: string,\n display: string,\n isModerator: boolean,\n) {\n if (!chatMessage.toLowerCase().startsWith(\"!turn\")) return false;\n if (!isModerator) {\n await sendChatMessage(\n `@${display} only the broadcaster or a moderator can manage initiative.`,\n broadcasterId,\n );\n return true;\n }\n const parts = chatMessage.trim().split(/\\s+/);\n const action = (parts[1] ?? \"show\").toLowerCase();\n let e = await getEncounter(broadcasterId);\n\n if (action === \"start\") {\n e = { broadcasterId, round: 1, currentIndex: 0, active: true, entries: [] };\n await saveEncounter(e);\n await sendChatMessage(\n `@${display} combat started. Add combatants with !turn add .`,\n broadcasterId,\n );\n return true;\n }\n\n if (action === \"end\" || action === \"clear\") {\n if (e) {\n await sqlite.execute(\"DELETE FROM encounters WHERE broadcaster_id = ?\", [\n broadcasterId,\n ]);\n }\n await sendChatMessage(\n `@${display} combat ended and initiative cleared.`,\n broadcasterId,\n );\n return true;\n }\n\n if (!e || !e.active) {\n await sendChatMessage(\n `@${display} no active encounter. Start one with !turn start.`,\n broadcasterId,\n );\n return true;\n }\n\n if (action === \"add\") {\n const match = chatMessage.match(/^!turn\\s+add\\s+(.+?)\\s+(\\d+)$/i);\n const initiative = match ? Number(match[2]) : NaN;\n if (\n !match || !Number.isInteger(initiative) || initiative < 0 ||\n initiative > 50\n ) {\n await sendChatMessage(\n `@${display} use !turn add , such as !turn add Goblin 15.`,\n broadcasterId,\n );\n return true;\n }\n const name = match[1].replace(/^@/, \"\").trim();\n const existing = e.entries.find((x: any) =>\n x.name.toLowerCase() === name.toLowerCase()\n );\n if (existing) existing.initiative = initiative;\n else e.entries.push({ name, initiative });\n e.entries.sort((a: any, b: any) => b.initiative - a.initiative);\n e.currentIndex = 0;\n await saveEncounter(e);\n await sendChatMessages(`@${display} ${encounterText(e)}`, broadcasterId);\n return true;\n }\n\n if (action === \"remove\") {\n const name = parts.slice(2).join(\" \").replace(/^@/, \"\");\n e.entries = e.entries.filter((x: any) =>\n x.name.toLowerCase() !== name.toLowerCase()\n );\n e.currentIndex = Math.min(\n e.currentIndex,\n Math.max(0, e.entries.length - 1),\n );\n await saveEncounter(e);\n await sendChatMessages(`@${display} ${encounterText(e)}`, broadcasterId);\n return true;\n }\n\n if (action === \"next\" || action === \"prev\") {\n if (!e.entries.length) {\n await sendChatMessage(\n `@${display} add combatants first with !turn add .`,\n broadcasterId,\n );\n return true;\n }\n const step = action === \"next\" ? 1 : -1;\n const nextIndex = e.currentIndex + step;\n if (nextIndex >= e.entries.length) {\n e.currentIndex = 0;\n e.round += 1;\n } else if (nextIndex < 0) {\n e.currentIndex = e.entries.length - 1;\n e.round = Math.max(1, e.round - 1);\n } else e.currentIndex = nextIndex;\n await saveEncounter(e);\n await sendChatMessages(`@${display} ${encounterText(e)}`, broadcasterId);\n return true;\n }\n\n if (action === \"show\" || action === \"list\") {\n await sendChatMessages(`@${display} ${encounterText(e)}`, broadcasterId);\n return true;\n }\n\n await sendChatMessage(\n `@${display} Initiative: !turn start | !turn add | !turn show | !turn next | !turn prev | !turn remove | !turn end`,\n broadcasterId,\n );\n return true;\n}",[217],"71a6ebce-0d97-4f15-951c-51458684b72d","characters.ts","8571f1d2-a4d9-11f1-8da9-1607ee4eb77e",140,["D",1788184662317],"// Character generation, leveling, and guided creation wizard\n\nimport type { Ability, Character } from \"./types.ts\";\nimport { races, subraceBonuses, classes, abilityNames } from \"./data.ts\";\nimport {\n pick,\n modifier,\n rollStat,\n formatRaceName,\n formatStatLine,\n} from \"./utils.ts\";\nimport {\n getCharacter,\n saveCharacter,\n getCreationSession,\n saveCreationSession,\n clearCreationSession,\n} from \"./db.ts\";\nimport { sendChatMessage } from \"./twitch.ts\";\n\nexport function generateCharacter(username: string): Character {\n const race = pick(Object.keys(races));\n const cls = pick(Object.keys(classes));\n const raceData = races[race];\n const classData = classes[cls];\n const subrace = raceData.subraces.length ? pick(raceData.subraces) : null;\n const scores = Array.from({ length: 6 }, rollStat).sort((a, b) => b - a);\n const abilityScores = {} as Record;\n classData.priority.forEach((ability, i) => (abilityScores[ability] = scores[i]));\n const bonuses: Partial> = {\n ...raceData.bonuses,\n ...(subrace ? subraceBonuses[subrace] : {}),\n };\n if (race === \"Human\" && subrace === \"Variant\") {\n for (const a of abilityNames) delete bonuses[a];\n bonuses[classData.priority[0]] = 1;\n bonuses[classData.priority[1]] = 1;\n }\n if (race === \"Half-Elf\") {\n const choices = classData.priority.filter((a) => a !== \"CHA\").slice(0, 2);\n bonuses[choices[0]] = 1;\n bonuses[choices[1]] = 1;\n }\n for (const a of abilityNames) {\n abilityScores[a] = Math.min(20, abilityScores[a] + (bonuses[a] ?? 0));\n }\n const hpMax = Math.max(1, classData.hitDie + modifier(abilityScores.CON));\n return {\n username,\n race,\n subrace,\n cls,\n level: 1,\n xp: 0,\n scores: abilityScores,\n speed: raceData.speed,\n hpMax,\n hpCurrent: hpMax,\n proficiency: 2,\n traits: raceData.traits,\n spells: [],\n items: [],\n feats: [],\n abilities: [],\n };\n}\n\nexport function customCharacterFromSession(s: any): Character {\n const raceData = races[s.race];\n const bonuses: Partial> = {\n ...raceData.bonuses,\n ...(s.subrace ? subraceBonuses[s.subrace] ?? {} : {}),\n };\n const scores = {} as Record;\n const rolled = s.scores as number[];\n classes[s.cls].priority.forEach((a: Ability, i: number) => {\n scores[a] = Math.min(20, rolled[i] + (bonuses[a] ?? 0));\n });\n const hp = Math.max(1, classes[s.cls].hitDie + modifier(scores.CON));\n return {\n username: s.username,\n race: s.race,\n subrace: s.subrace || null,\n cls: s.cls,\n level: 1,\n xp: 0,\n scores,\n speed: raceData.speed,\n hpMax: hp,\n hpCurrent: hp,\n proficiency: 2,\n traits: raceData.traits,\n spells: [],\n items: [],\n feats: [],\n abilities: [],\n };\n}\n\n/** 5e-style XP for common solo-monster CRs used by the bot. */\nexport function xpForMonsterCr(cr: string): number {\n const table: Record = {\n \"0\": 10,\n \"1/8\": 25,\n \"1/4\": 50,\n \"1/2\": 100,\n \"1\": 200,\n \"2\": 450,\n \"3\": 700,\n \"4\": 1100,\n \"5\": 1800,\n \"6\": 2300,\n \"7\": 2900,\n \"8\": 3900,\n \"9\": 5000,\n \"10\": 5900,\n \"11\": 7200,\n \"12\": 8400,\n };\n return table[String(cr).trim()] ?? 100;\n}\n\n/**\n * Award XP for defeating a monster (never for PvP).\n * Optionally auto-levels when XP crosses 5e thresholds.\n */\nexport async function awardMonsterXp(\n username: string,\n cr: string,\n broadcasterId?: string,\n): Promise<{ gained: number; total: number; leveledTo?: number } | null> {\n const c = await getCharacter(username, broadcasterId);\n if (!c) return null;\n const gained = xpForMonsterCr(cr);\n c.xp = (c.xp ?? 0) + gained;\n\n // 5e cumulative XP thresholds (levels 1–12 enough for bot content)\n const thresholds = [0, 300, 900, 2700, 6500, 14000, 23000, 34000, 48000, 64000, 85000, 100000];\n let newLevel = c.level;\n for (let lv = thresholds.length; lv >= 1; lv--) {\n if (c.xp >= thresholds[lv - 1]) {\n newLevel = Math.min(20, lv);\n break;\n }\n }\n let leveledTo: number | undefined;\n if (newLevel > c.level) {\n const classData = classes[c.cls];\n const perLevelHp = Math.max(1, Math.floor(classData.hitDie / 2) + 1 + modifier(c.scores.CON));\n const baseHp = Math.max(1, classData.hitDie + modifier(c.scores.CON));\n const oldHpMax = c.hpMax;\n c.level = newLevel;\n c.hpMax = baseHp + (newLevel - 1) * perLevelHp;\n c.hpCurrent = Math.max(0, Math.min(c.hpMax, c.hpCurrent + (c.hpMax - oldHpMax)));\n c.proficiency = Math.floor((newLevel - 1) / 4) + 2;\n leveledTo = newLevel;\n }\n await saveCharacter(c, broadcasterId);\n return { gained, total: c.xp, leveledTo };\n}\n\nexport async function adjustLevel(username: string, delta: number, broadcasterId?: string) {\n const c = await getCharacter(username, broadcasterId);\n if (!c) return { error: \"no character\" as const };\n if (!Number.isInteger(delta) || delta === 0) return { error: \"invalid amount\" as const };\n const oldLevel = c.level;\n const newLevel = Math.max(1, Math.min(20, oldLevel + delta));\n if (newLevel === oldLevel) {\n return { error: delta > 0 ? (\"max level\" as const) : (\"min level\" as const) };\n }\n const classData = classes[c.cls];\n const perLevelHp = Math.max(1, Math.floor(classData.hitDie / 2) + 1 + modifier(c.scores.CON));\n const baseHp = Math.max(1, classData.hitDie + modifier(c.scores.CON));\n const oldHpMax = c.hpMax;\n c.level = newLevel;\n c.hpMax = baseHp + (newLevel - 1) * perLevelHp;\n c.hpCurrent = Math.max(0, Math.min(c.hpMax, c.hpCurrent + (c.hpMax - oldHpMax)));\n c.proficiency = Math.floor((newLevel - 1) / 4) + 2;\n await saveCharacter(c, broadcasterId);\n const asi = [4, 8, 12, 16, 19].includes(newLevel) ? \" Ability Score Improvement/feat available.\" : \"\";\n return { c, oldLevel, delta: newLevel - oldLevel, hpGain: c.hpMax - oldHpMax, asi };\n}\n\nexport async function handleCreationCommand(\n username: string,\n display: string,\n broadcasterId: string,\n chatMessage: string,\n) {\n if (chatMessage === \"!newchar\") {\n await saveCreationSession({ username, step: \"race\" }, broadcasterId);\n await sendChatMessage(\n `@${display} New character started. Choose a race: ${Object.keys(races).join(\", \")}. Reply !answer . Type !cancel to stop.`,\n broadcasterId,\n );\n return true;\n }\n if (chatMessage === \"!cancel\") {\n const active = await getCreationSession(username, broadcasterId);\n if (!active) return false;\n await clearCreationSession(username, broadcasterId);\n await sendChatMessage(`@${display} Character creation cancelled.`, broadcasterId);\n return true;\n }\n if (!chatMessage.startsWith(\"!answer \")) return false;\n const s = await getCreationSession(username, broadcasterId);\n if (!s) return false;\n const answer = chatMessage.slice(8).trim();\n\n if (s.step === \"race\") {\n const race = Object.keys(races).find((x) => x.toLowerCase() === answer.toLowerCase());\n if (!race) {\n await sendChatMessage(`@${display} Choose a race from: ${Object.keys(races).join(\", \")}.`, broadcasterId);\n return true;\n }\n s.race = race;\n if (races[race].subraces.length) {\n s.step = \"subrace\";\n await saveCreationSession(s, broadcasterId);\n await sendChatMessage(\n `@${display} Choose a ${race} subrace: ${races[race].subraces.join(\", \")}. Reply !answer .`,\n broadcasterId,\n );\n } else {\n s.step = \"class\";\n await saveCreationSession(s, broadcasterId);\n await sendChatMessage(\n `@${display} Choose a class: ${Object.keys(classes).join(\", \")}. Reply !answer .`,\n broadcasterId,\n );\n }\n return true;\n }\n\n if (s.step === \"subrace\") {\n const subrace = races[s.race].subraces.find((x) => x.toLowerCase() === answer.toLowerCase());\n if (!subrace) {\n await sendChatMessage(\n `@${display} Choose a subrace from: ${races[s.race].subraces.join(\", \")}.`,\n broadcasterId,\n );\n return true;\n }\n s.subrace = subrace;\n s.step = \"class\";\n await saveCreationSession(s, broadcasterId);\n await sendChatMessage(\n `@${display} Choose a class: ${Object.keys(classes).join(\", \")}. Reply !answer .`,\n broadcasterId,\n );\n return true;\n }\n\n if (s.step === \"class\") {\n const cls = Object.keys(classes).find((x) => x.toLowerCase() === answer.toLowerCase());\n if (!cls) {\n await sendChatMessage(`@${display} Choose a class from: ${Object.keys(classes).join(\", \")}.`, broadcasterId);\n return true;\n }\n s.cls = cls;\n s.step = \"scores\";\n await saveCreationSession(s, broadcasterId);\n await sendChatMessage(\n `@${display} Enter 6 scores in order of importance, or use standard: !answer 15 14 13 12 10 8. ${cls} priority: ${classes[cls].priority.join(\", \")}.`,\n broadcasterId,\n );\n return true;\n }\n\n if (s.step === \"scores\") {\n const scores =\n answer.toLowerCase() === \"standard\"\n ? [15, 14, 13, 12, 10, 8]\n : answer.split(/[ ,]+/).map(Number);\n if (scores.length !== 6 || scores.some((n: number) => !Number.isInteger(n) || n < 3 || n > 18)) {\n await sendChatMessage(\n `@${display} Enter exactly 6 whole-number scores from 3 to 18, such as !answer 15 14 13 12 10 8.`,\n broadcasterId,\n );\n return true;\n }\n s.scores = scores;\n s.step = \"confirm\";\n await saveCreationSession(s, broadcasterId);\n const preview = customCharacterFromSession(s);\n await sendChatMessage(\n `@${display} Confirm: level 1 ${formatRaceName(preview.race, preview.subrace)} ${preview.cls}, ${formatStatLine(preview)}. Reply !answer yes to save or !answer no to restart.`,\n broadcasterId,\n );\n return true;\n }\n\n if (s.step === \"confirm\") {\n if (answer.toLowerCase() === \"yes\") {\n const c = customCharacterFromSession(s);\n await saveCharacter(c, broadcasterId);\n await clearCreationSession(username, broadcasterId);\n await sendChatMessage(\n `@${display} Character saved! Use !char, !levelup, !savechar, and !loadchar.`,\n broadcasterId,\n );\n } else if (answer.toLowerCase() === \"no\") {\n await clearCreationSession(username, broadcasterId);\n await sendChatMessage(`@${display} Character discarded. Start again with !newchar.`, broadcasterId);\n } else {\n await sendChatMessage(`@${display} Reply !answer yes to save or !answer no to discard.`, broadcasterId);\n }\n return true;\n }\n\n return false;\n}\n",[225],"2721ecad-7b79-4736-9362-509271a599a8",["D",1788236302556],[27],"b1187970-0901-41b1-b4ed-906e59a04cd3","README.md","a9ce1e16-a4d9-11f1-939e-1607ee4eb77e",160,["D",1788236302497],13,"# GuildScribe — Guild Hall for Twitch D&D\n\n**GuildScribe** is a Dungeons & Dragons 5e (2014 SRD-style) **guild hall** that lives in Twitch chat. \nAdventurers create characters, form companies, consult the archives, roll fate’s dice, duel in the arena, and hunt monsters in the wilds.\n\nRuns on **Val Town** (Deno) with **SQLite** persistence and Twitch **EventSub** + Helix chat.\n\n**Live codex (command guide):** set `PUBLIC_BASE_URL` in `main.ts`, then open `{PUBLIC_BASE_URL}/guide` \nChat: `!guide` or `!link` posts that same URL.\n\n---\n\n## Features at a glance\n\n| Pillar | What the guild offers |\n|--------|------------------------|\n| **Parchment** | Characters with level, XP, HP, race/class, save/load |\n| **Company** | Parties with invite, roster (members listed), disband |\n| **Archives** | Spells, items, classes, feats, races, **rules** (+ public links) |\n| **Fate’s dice** | `!d20`, `!roll`, roll for another adventurer, `!bg3roll` for a BG3-style character |\n| **Arena & wilds** | Auto/classic PvP, solo monsters, party duels, **party hunts** |\n| **XP** | From **monster** victories only (not PvP) |\n| **Stewards** | Channel on/off, disconnect/purge, in-chat activity logs, OAuth connect |\n\n---\n\n## Module map\n\n| File | Role |\n|------|------|\n| **main.ts** | HTTP entry, OAuth, EventSub, **command router** — Val Town HTTP trigger |\n| **types.ts** | Shared types |\n| **data.ts** | Races, classes, level-scaled monsters, lookup map |\n| **utils.ts** | Dice, formatting, narration |\n| **db.ts** | SQLite schema + persistence |\n| **characters.ts** | Generation, XP, leveling, `!newchar` wizard |\n| **bg3.ts** | `!bg3roll` — standalone Baldur's Gate 3 style character roll (no DB) |\n| **combat.ts** | Duels, parties, hunts, initiative |\n| **lookups.ts** | dnd5eapi + formatting + reference links |\n| **twitch.ts** | Tokens, multi-part chat send |\n| **pages.ts** | Guild Codex HTML, logs, character sheet UI |\n| **README.md** | This document |\n\n---\n\n## Setup (Val Town)\n\n1. Upload all modules into one Val project.\n2. Point the **HTTP trigger** at **`main.ts`**.\n3. Environment variables:\n\n| Variable | Purpose |\n|----------|---------|\n| `TWITCH_CLIENT_ID` | Twitch app client ID |\n| `TWITCH_CLIENT_SECRET` | Twitch app secret |\n| `TWITCH_BOT_ID` | Bot account numeric user ID |\n| `EVENTSUB_SECRET` | EventSub signature secret |\n| `BOT_USERNAMES` | *(optional)* Extra bot logins to ignore |\n| `MAX_PARTIES_PER_CHANNEL` | *(optional)* Party cap per channel; default 50 |\n| `MAX_CHARACTERS_PER_CHANNEL` | *(optional)* Character cap per channel; default 500 |\n| `ADMIN_API_SECRET` | **Required for operator override**; secret bearer token for `/admin/channels//(disable|enable)` |\n| `SUPPORT_URL` | *(recommended)* Support/contact URL shown in the privacy policy and home page |\n| `PUBLIC_BASE_URL` | *(recommended)* Public HTTPS URL used in chat links; must match the deployed Val URL |\n| `COMMAND_COOLDOWN_MS` | *(optional)* Durable per-channel/user command cooldown; default 1200ms |\n| `CHAT_GLOBAL_MIN_INTERVAL_MS` | *(optional)* Global bot-account chat-send spacing; default 1600ms. Lower only after Twitch confirms the account's applicable limit/verification. |\n\n4. Twitch Developer Console → OAuth Redirect URL must be exactly: \n `https://.web.val.run/callback`\n5. Set `PUBLIC_BASE_URL` as an environment variable to your public HTTPS URL (used by `!guide` / `!link`).\n6. Open the Val URL → **Raise the Guild Banner** → authorize.\n7. In channel chat: `/mod YourBotName`\n\nDelete any old **`http.ts`** entry file after switching the trigger to `main.ts`.\n\n---\n\n## Chat commands (full index)\n\n### Guild hall & help\n| Command | Description |\n|---------|-------------|\n| `!help` | Guild hall welcome + path to begin |\n| `!guide` / `!link` | **Posts the Guild Codex URL** (`/guide`) |\n| `!dndbothelp` | Codex chapters: dice, character, party, combat, lookup, settings |\n| `!dndbothelp ` | Detailed syntax for that chapter |\n\n### Adventurer’s parchment (character)\n| Command | Description |\n|---------|-------------|\n| `!createchar` | Instant level 1 character |\n| `!createchar @user` | Create for another *(mod)* |\n| `!newchar` | Guided wizard |\n| `!answer ` | Wizard answer |\n| `!cancel` | Cancel wizard |\n| `!char` / `!char @user` | Sheet summary (level, **XP**, stats, HP) |\n| `!levelup` / `!levelup +/-N` | Adjust level |\n| `!hp` / `!hp +/-N` | Show or change HP |\n| `!savechar` / `!loadchar` / `!resetchar` | Backup / restore / reset |\n\n### Fate’s dice\n| Command | Description |\n|---------|-------------|\n| `!d20` | Roll a d20 |\n| `!d20 @user` | Roll for another adventurer |\n| `!roll` / `!r` | Default 1d20 |\n| `!roll 2d6+3` | Custom expression |\n| `!roll @user 4d8` | Roll for someone |\n| `!roll dex` / `!roll strength` | **Saving throw** — uses your saved character's ability modifier (+ proficiency if your class is proficient in that save) |\n| `!roll stealth` / `!roll animal handling` | **Skill check** — uses your saved character's modifier for that skill's ability |\n| `!roll @user dex` / `!roll @user stealth` | Saving throw / skill check using `@user`'s saved character instead of your own |\n| `!roll ?` | D&D-flavored yes/no fate verdict, e.g. `!roll is enya going to die this time?` |\n| `!bg3roll` | Random Baldur's Gate 3 style character: race/subrace, class/subclass, background, alignment, BG3-style point-buy scores, and an origin hook |\n\n### Guild archives (lookups)\n| Command | Example |\n|---------|---------|\n| `!spell [+N]` | `!spell fireball` |\n| `!item [+N]` | `!item longsword +1` |\n| `!class` / `!feat` / `!ability` / `!race` / `!subrace` | `!class wizard` |\n| `!rule` / `!rules ` | `!rules magic`, `!rule advantage` |\n\n- Bare commands (`!rules` alone) → usage + examples \n- Rules: up to **3** chat messages, **link first** in the response, always a D&D Beyond **search link** (hardcoded Free Rules chapter URLs were dropped — they'd started returning 403s) \n- Other lookups include reference links where applicable, also shown first in the response \n\n### Guild company (parties)\n| Command | Description |\n|---------|-------------|\n| `!party create ` | Found a company (you are leader **and** member) |\n| `!party join ` | Join |\n| `!party invite @user [name]` | Invite (name optional if you only have one party) |\n| `!party accept [name]` / `decline [name]` | Invited user answers (name optional if only one pending invite) |\n| `!party list` | **Your parties with leaders and members** |\n| `!party list ` | One company roster |\n| `!party leave ` | Leave |\n| `!party disband ` | Leader dissolves the company |\n\n### Arena & wilds (combat)\n| Command | Description |\n|---------|-------------|\n| `!dndduel @user` | Auto PvP challenge |\n| `!dndduel classic @user` | Turn-based PvP |\n| `!dndduel accept` / `decline` | Answer challenge |\n| `!dndduel attack` / `status` / `end` | Classic turn / status / end |\n| `!dndduel` | Auto **solo monster** (level-scaled) |\n| `!dndduel monster` | Classic solo monster |\n| `!dndduel party A B` | Auto party vs party |\n| `!dndduel party classic A B` | Classic party vs party |\n| `!dndduel party accept` / `decline` / `attack` / `status` / `end` | Party duel flow |\n| `!dndduel party hunt ` | Auto **company vs monster** |\n| `!dndduel party hunt classic ` | Classic hunt |\n| `!dndduel party hunt attack` / `status` / `end` | Hunt turns |\n| `!turn start` … `!turn end` | Initiative tracker *(mod)* |\n\n**XP** is granted only when a **monster** falls (solo or party hunt). PvP awards none.\n\n### Stewards (settings)\n| Command | Description |\n|---------|-------------|\n| `!dndbot on` / `off` / `status` | Open or close the guild hall in this channel *(mod)* |\n| `!dndbot leave` | Broadcaster-only: cancel EventSub and disconnect this channel |\n| `!dndbot leave purge` | Broadcaster-only: disconnect and purge this channel's stored characters/parties/logs/gameplay state |\n\n---\n\n## How the pieces link\n\n```\nChat !guide / !link ──► PUBLIC_BASE_URL/guide (Guild Codex web page)\nChat !dndbothelp ──► Same chapters as Codex + this README\nHome page ──► OAuth connect + link to Codex + Support the Guild\n!logs (chat only) ──► Activity scrolls, scoped to that channel, mods/broadcaster only\n!party list ──► Rosters used by !dndduel party / party hunt\n!createchar / !char ──► Required for duels, hunts, party invite targets\nMonster wins ──► XP on parchment (!char shows Lv + XP)\n```\n\n---\n\n## HTTP routes\n\n| Path | Purpose |\n|------|---------|\n| `GET /` | Guild hall — connect channel |\n| `GET /callback` | Twitch OAuth return |\n| `GET /guide` · `/commands` | **Guild Codex** |\n| `GET /donate` | Support the Guild |\n| `GET /privacy` | Privacy policy |\n| `GET /terms` · `/tos` | Short Terms of Service |\n| `GET /healthz` | Health check for uptime monitors |\n| `POST /admin/channels//disable` | Operator-only channel block |\n| `POST /admin/channels//enable` | Operator-only unblock |\n| `GET /?channel=&user=` | Channel-scoped character sheet |\n| `POST /` | EventSub (chat + webhooks) |\n\n---\n\n## XP & monsters\n\n- Start: level 1, 0 XP \n- Monster CR → XP; thresholds can auto-level \n- Monsters chosen by **level** (and party size on hunts), with win-friendly balance \n- Large solo roster across CR bands \n\n---\n\n## Pre-launch checklist\n\n### Code-side security\n\n- [x] OAuth state validation with 10-minute expiry and one-time consumption\n- [x] EventSub HMAC signature validation\n- [x] EventSub timestamp/replay protection\n- [x] Channel-scoped characters, backups, and creation sessions\n- [x] Channel-scoped activity-log retention (90 days / 5,000 rows)\n- [x] Broadcaster-only disconnect and purge\n- [x] EventSub cancellation retry queue\n- [x] Twitch-side revocation marks the broadcaster disconnected\n- [x] Operator blocklist with secret bearer authentication (32+ character secret required)\n- [x] SQL parameterization and HTML escaping for user-controlled values\n- [x] Durable per-channel/user command cooldown\n- [x] Global outbound chat queue for shared bot-account rate-limit protection\n- [x] Production error responses avoid returning raw exception details\n- [x] Chat command text is not written to application logs\n- [x] `/healthz` is cache-disabled and suitable for external monitoring\n\n### Operator-side launch requirements\n\n- [ ] Set production secrets/environment variables\n- [ ] Configure an external uptime monitor/alert destination\n- [ ] Set a real support URL\n- [ ] Set the exact public URL and Twitch OAuth redirect (`/callback`)\n- [ ] Complete Twitch's current bot verification/rate-limit process\n- [ ] Test `!dndbot leave` and `!dndbot leave purge` on a disposable channel\n- [ ] Test Twitch-side EventSub revocation\n- [ ] Test the operator disable/enable endpoints\n- [ ] Test two channels with the same viewer username and confirm characters/wizards remain isolated\n\n---\n\n## License / content\n\nMechanics and lookups use the **D&D 5e SRD** via public APIs and free reference sites. \nGuildScribe is a fan-made Twitch utility and is **not** affiliated with Wizards of the Coast or Twitch.\n\n\n## Launch / operations checklist\n\n- **Disconnect:** `!dndbot leave` is broadcaster-only, deletes the broadcaster connection record, and attempts to cancel its EventSub subscription. `!dndbot leave purge` additionally removes channel parties, logs, encounters, duel state, channel character associations, and characters/backups that are no longer associated with another channel.\n- **EventSub revocation:** Twitch revocations now mark the broadcaster disconnected, so `!connections` only reports live connections.\n- **Privacy/ToS:** `/privacy` and `/terms` are public and linked from the Codex. Activity logs are pruned per channel to 5,000 rows and 90 days.\n- **Operator override:** keep `ADMIN_API_SECRET` private. Use `POST /admin/channels//disable` with `Authorization: Bearer ` to block one channel without relying on Twitch roles.\n- **Per-channel caps:** set `MAX_PARTIES_PER_CHANNEL` and `MAX_CHARACTERS_PER_CHANNEL` as needed.\n- **Monitoring:** point an external uptime monitor at `/healthz`; application errors/revocations are also retained in a small internal `monitor_events` table.\n- **Support:** set `SUPPORT_URL` to the project's real support channel/email/form before launch.\n- **Twitch bot verification:** verification is a Twitch-side application process and cannot be completed from the code. Before multi-channel launch, apply in the Twitch Developer Console using the current Twitch developer requirements/rate limits. The codebase is now structured so the shared bot can be operated/limited safely while that process is pending.\n\n### Data ownership and security note\n\nCharacter records, backups, and creation sessions are now **tenant-scoped by `(broadcaster_id, username)`**. A viewer can have a separate character in every channel and cannot retrieve or modify another channel's character by changing a username. Existing legacy character tables are migrated into the channel-scoped schema using the historical `channel_characters` associations; unassociated legacy records are not exposed.\n\nEventSub webhook signatures are checked with HMAC, timestamps older than 10 minutes are rejected, and Twitch message IDs are de-duplicated for 24 hours to prevent replay processing. Chat commands use a durable SQLite per-channel/user cooldown, while outgoing chat sends use a global bot-account queue to reduce shared-account throttling risk.\n\nIf an EventSub cancellation fails during `!dndbot leave`, the subscription ID is retained in a minimal pending-cancellation queue and retried by `/healthz`; the broadcaster row and channel data can still be removed immediately.\n\nThe public character sheet is channel-scoped and requires a currently connected broadcaster: `/?channel=&user=` (without the space). This prevents the old global `?user=` route from crossing tenants.\n\n### Pre-public operational items\n\n- Set `ADMIN_API_SECRET` to a random value of at least 32 characters.\n- Set `SUPPORT_URL` to a real support destination.\n- Set `PUBLIC_BASE_URL` to the exact public HTTPS URL.\n- Configure an external uptime monitor against `/healthz`; the endpoint also retries transient EventSub cancellations.\n- Review the current Twitch developer/bot verification requirements and complete Twitch's verification process separately. Code cannot grant Twitch verification.\n- Keep the conservative `CHAT_GLOBAL_MIN_INTERVAL_MS=1600` until Twitch confirms the account's applicable chat rate limit; lower it only with that confirmation.\n",[235],"3093561c-20ac-43b7-8cb7-664f2c560131","AGENTS.md","2c7af9b2-a3c0-11f1-a077-1607ee4eb77e",2,["D",1788018120020],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider\n refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure\n about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious\n operations)\n- Follow modern ES6+ conventions and functional programming practices if\n possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst TABLE_NAME = \"todo_app_users_2\";\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [1],\n);\n```\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({\n subject: \"Hi\",\n text: \"Hi\",\n html: \"

Hi

\",\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport {\n parseProject,\n readFile,\n serveFile,\n} from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\"\nurls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's _extremely importing_ to note that `parseProject` and other\nStandard Library utilities ONLY RUN ON THE SERVER. If you need access to this\ndata on the client, run it in the server and pass it to the client by splicing\nit into the HTML page or by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use\n `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})`\n instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode\n symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use:\n `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys)\n unless otherwise specified\n- **View Source:** Add a view source link by importing & using\n `import.meta.url.replace(\"esm.sh\", \"val.town)\"` (or passing this data to the\n client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add\n `` to HTML to capture\n client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local\n resolution; Avoid catches that merely log or return 500s. Let errors bubble up\n with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but\n generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure\n compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer\n simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with\n `?deps=react@18.2.0,react-dom@18.2.0` and start the file with\n `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same\n version\n- **Styling:** Default to using TailwindCSS via\n `` unless otherwise\n specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project\n files:\n ```ts\n import {\n readFile,\n serveFile,\n } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to\n see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:**\n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of\n React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with\n `export default app.fetch // This is the entry point for HTTP vals`",[243],"722e7a17-a099-4f29-8e69-2679535add68",".vtignore","2c724ea2-a3c0-11f1-bf9f-1607ee4eb77e",1,["D",1788018119974],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[250],"pulls","branches","forks","envVars",{"_263":265,"_266":59},"connections",{"_263":59,"_264":59},"count","unfilledCount",6,"emptyCount",{"_41":249,"_31":250,"_29":251,"_145":-5,"_39":40,"_38":252,"_147":122,"_36":325,"_13":59,"_32":20,"_34":254,"_23":24,"_151":-5,"_283":326,"_26":327},{"_41":242,"_31":243,"_29":244,"_145":-5,"_39":40,"_38":245,"_147":24,"_36":322,"_13":59,"_32":20,"_34":247,"_23":24,"_151":-5,"_283":323,"_26":324},{"_41":234,"_31":235,"_29":236,"_145":-5,"_39":40,"_38":237,"_147":24,"_36":319,"_13":239,"_32":20,"_34":240,"_23":24,"_151":-5,"_283":320,"_26":321},{"_41":231,"_31":27,"_29":30,"_145":-5,"_39":40,"_38":14,"_147":24,"_36":316,"_13":59,"_32":33,"_34":35,"_23":24,"_151":-5,"_283":317,"_26":318},{"_41":224,"_31":225,"_29":226,"_145":-5,"_39":40,"_38":227,"_147":24,"_36":313,"_13":158,"_32":33,"_34":229,"_23":24,"_151":-5,"_283":314,"_26":315},{"_41":216,"_31":217,"_29":218,"_145":-5,"_39":40,"_38":219,"_147":24,"_36":310,"_13":221,"_32":33,"_34":222,"_23":24,"_151":-5,"_283":311,"_26":312},{"_41":208,"_31":209,"_29":210,"_145":-5,"_39":40,"_38":211,"_147":24,"_36":307,"_13":213,"_32":33,"_34":214,"_23":24,"_151":-5,"_283":308,"_26":309},{"_41":201,"_31":202,"_29":203,"_145":-5,"_39":40,"_38":204,"_147":24,"_36":304,"_13":166,"_32":33,"_34":206,"_23":24,"_151":-5,"_283":305,"_26":306},{"_41":195,"_31":196,"_29":197,"_145":-5,"_39":40,"_38":158,"_147":122,"_36":301,"_13":59,"_32":20,"_34":199,"_23":24,"_151":-5,"_283":302,"_26":303},{"_41":187,"_31":188,"_29":189,"_145":-5,"_39":40,"_38":190,"_147":24,"_36":298,"_13":192,"_32":33,"_34":193,"_23":24,"_151":-5,"_283":299,"_26":300},{"_41":177,"_31":178,"_29":179,"_145":-5,"_39":40,"_38":180,"_147":24,"_36":295,"_13":182,"_32":183,"_34":184,"_23":24,"_151":185,"_283":296,"_26":297},{"_41":169,"_31":170,"_29":171,"_145":-5,"_39":40,"_38":172,"_147":24,"_36":292,"_13":174,"_32":33,"_34":175,"_23":24,"_151":-5,"_283":293,"_26":294},{"_41":161,"_31":162,"_29":163,"_145":-5,"_39":40,"_38":164,"_147":24,"_36":289,"_13":166,"_32":33,"_34":167,"_23":24,"_151":-5,"_283":290,"_26":291},{"_41":153,"_31":154,"_29":155,"_145":-5,"_39":40,"_38":156,"_147":24,"_36":286,"_13":158,"_32":33,"_34":159,"_23":24,"_151":-5,"_283":287,"_26":288},{"_41":142,"_31":143,"_29":144,"_145":-5,"_39":40,"_38":146,"_147":24,"_36":282,"_13":149,"_32":33,"_34":150,"_23":24,"_151":-5,"_283":284,"_26":285},["D",1788232351805],"children",[],[143],["D",1788184662810],[],[154],["D",1788184662636],[],[162],["D",1788232351779],[],[170],["D",1788236302493],[],[178],["D",1788147804734],[],[188],["D",1788018120139],[],[196],["D",1788184662449],[],[202],["D",1788231134123],[],[209],["D",1788230468281],[],[217],["D",1788184662317],[],[225],["D",1788236302556],[],[27],["D",1788236302497],[],[235],["D",1788018120020],[],[243],["D",1788018119974],[],[250],["D",1787995257440],["D",1789587078639],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":53,"_101":102,"_103":24},{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"ctx",{"_78":-5,"_124":366,"_367":368,"_369":370,"_371":24,"_372":24,"_373":24,"_374":122,"_375":-5,"_376":-7,"_377":-7,"_378":59,"_379":24,"_380":24,"_381":-5,"_382":24,"_383":24,"_384":24,"_385":-5},"ENV",{"_337":338,"_339":340,"_341":86,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v161