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.

`; }\r\nasync function getEncounter(broadcasterId: string) { const res = await sqlite.execute(\"SELECT * FROM encounters WHERE broadcaster_id = ?\", [broadcasterId]); if (!res.rows.length) return null; const r = res.rows[0]; return { broadcasterId, round: Number(r.round), currentIndex: Number(r.current_index), active: Boolean(r.active), entries: JSON.parse(r.entries || \"[]\") as Array<{ name: string; initiative: number }> }; }\r\nasync function saveEncounter(e: any) { await sqlite.execute(\"INSERT OR REPLACE INTO encounters (broadcaster_id,round,current_index,active,entries,updated_at) VALUES (?,?,?,?,?,?)\", [e.broadcasterId,e.round,e.currentIndex,e.active ? 1 : 0,JSON.stringify(e.entries),Date.now()]); }\r\nfunction encounterText(e: any) { const order = e.entries.map((x: any, i: number) => `${i === e.currentIndex && e.active ? \"▶\" : \"•\"} ${x.name} ${x.initiative}`).join(\" | \"); return `Initiative R${e.round}: ${order || \"no combatants\"}`; }\r\nasync function handleInitiativeCommand(chatMessage: string, broadcasterId: string, display: string, isModerator: boolean) { if (!chatMessage.toLowerCase().startsWith(\"!turn\")) return false; if (!isModerator) { await sendChatMessage(`@${display} only the broadcaster or a moderator can manage initiative.`, broadcasterId); return true; } const parts = chatMessage.trim().split(/\\s+/); const action = (parts[1] ?? \"show\").toLowerCase(); let e = await getEncounter(broadcasterId); if (action === \"start\") { e = { broadcasterId, round: 1, currentIndex: 0, active: true, entries: [] }; await saveEncounter(e); await sendChatMessage(`@${display} combat started. Add combatants with !turn add .`, broadcasterId); return true; } if (action === \"end\" || action === \"clear\") { if (e) await sqlite.execute(\"DELETE FROM encounters WHERE broadcaster_id = ?\", [broadcasterId]); await sendChatMessage(`@${display} combat ended and initiative cleared.`, broadcasterId); return true; } if (!e || !e.active) { await sendChatMessage(`@${display} no active encounter. Start one with !turn start.`, broadcasterId); return true; } if (action === \"add\") { const match = chatMessage.match(/^!turn\\s+add\\s+(.+?)\\s+(\\d+)$/i); const initiative = match ? Number(match[2]) : NaN; if (!match || !Number.isInteger(initiative) || initiative < 0 || initiative > 50) { await sendChatMessage(`@${display} use !turn add , such as !turn add Goblin 15.`, broadcasterId); return true; } const name = match[1].replace(/^@/, \"\").trim(); const existing = e.entries.find((x: any) => x.name.toLowerCase() === name.toLowerCase()); if (existing) existing.initiative = initiative; else e.entries.push({ name, initiative }); e.entries.sort((a: any, b: any) => b.initiative - a.initiative); e.currentIndex = 0; await saveEncounter(e); await sendChatMessages(`@${display} ${encounterText(e)}`, broadcasterId); return true; } if (action === \"remove\") { const name = parts.slice(2).join(\" \").replace(/^@/, \"\"); e.entries = e.entries.filter((x: any) => x.name.toLowerCase() !== name.toLowerCase()); e.currentIndex = Math.min(e.currentIndex, Math.max(0, e.entries.length - 1)); await saveEncounter(e); await sendChatMessages(`@${display} ${encounterText(e)}`, broadcasterId); return true; } if (action === \"next\" || action === \"prev\") { if (!e.entries.length) { await sendChatMessage(`@${display} add combatants first with !turn add .`, broadcasterId); return true; } const step = action === \"next\" ? 1 : -1; const nextIndex = e.currentIndex + step; if (nextIndex >= e.entries.length) { e.currentIndex = 0; e.round += 1; } else if (nextIndex < 0) { e.currentIndex = e.entries.length - 1; e.round = Math.max(1, e.round - 1); } else e.currentIndex = nextIndex; await saveEncounter(e); await sendChatMessages(`@${display} ${encounterText(e)}`, broadcasterId); return true; } if (action === \"show\" || action === \"list\") { await sendChatMessages(`@${display} ${encounterText(e)}`, broadcasterId); return true; } await sendChatMessage(`@${display} Initiative: !turn start | !turn add | !turn show | !turn next | !turn prev | !turn remove | !turn end`, broadcasterId); return true; }\r\nfunction customCharacterFromSession(s: any): Character { const raceData = races[s.race]; const bonuses: Partial> = { ...raceData.bonuses, ...(s.subrace ? subraceBonuses[s.subrace] ?? {} : {}) }; const scores = {} as Record; const rolled = s.scores as number[]; classes[s.cls].priority.forEach((a: Ability, i: number) => scores[a] = Math.min(20, rolled[i] + (bonuses[a] ?? 0))); const hp = Math.max(1, classes[s.cls].hitDie + modifier(scores.CON)); return { username: s.username, race: s.race, subrace: s.subrace || null, cls: s.cls, level: 1, scores, speed: raceData.speed, hpMax: hp, hpCurrent: hp, proficiency: 2, traits: raceData.traits, spells: [], items: [], feats: [], abilities: [] }; }\r\nasync function handleCreationCommand(username: string, display: string, broadcasterId: string, chatMessage: string) { if (chatMessage === \"!newchar\") { await saveCreationSession({ username, step: \"race\" }); await sendChatMessage(`@${display} New character started. Choose a race: ${Object.keys(races).join(\", \")}. Reply !answer . Type !cancel to stop.`, broadcasterId); return true; } if (chatMessage === \"!cancel\") { const active = await getCreationSession(username); if (!active) return false; await clearCreationSession(username); await sendChatMessage(`@${display} Character creation cancelled.`, broadcasterId); return true; } if (!chatMessage.startsWith(\"!answer \")) return false; const s = await getCreationSession(username); if (!s) return false; const answer = chatMessage.slice(8).trim(); if (s.step === \"race\") { const race = Object.keys(races).find((x) => x.toLowerCase() === answer.toLowerCase()); if (!race) { await sendChatMessage(`@${display} Choose a race from: ${Object.keys(races).join(\", \")}.`, broadcasterId); return true; } s.race = race; if (races[race].subraces.length) { s.step = \"subrace\"; await saveCreationSession(s); await sendChatMessage(`@${display} Choose a ${race} subrace: ${races[race].subraces.join(\", \")}. Reply !answer .`, broadcasterId); } else { s.step = \"class\"; await saveCreationSession(s); await sendChatMessage(`@${display} Choose a class: ${Object.keys(classes).join(\", \")}. Reply !answer .`, broadcasterId); } return true; } if (s.step === \"subrace\") { const subrace = races[s.race].subraces.find((x) => x.toLowerCase() === answer.toLowerCase()); if (!subrace) { await sendChatMessage(`@${display} Choose a subrace from: ${races[s.race].subraces.join(\", \")}.`, broadcasterId); return true; } s.subrace = subrace; s.step = \"class\"; await saveCreationSession(s); await sendChatMessage(`@${display} Choose a class: ${Object.keys(classes).join(\", \")}. Reply !answer .`, broadcasterId); return true; } if (s.step === \"class\") { const cls = Object.keys(classes).find((x) => x.toLowerCase() === answer.toLowerCase()); if (!cls) { await sendChatMessage(`@${display} Choose a class from: ${Object.keys(classes).join(\", \")}.`, broadcasterId); return true; } s.cls = cls; s.step = \"scores\"; await saveCreationSession(s); await sendChatMessage(`@${display} Enter 6 scores in order of importance, or use standard: !answer 15 14 13 12 10 8. ${cls} priority: ${classes[cls].priority.join(\", \")}.`, broadcasterId); return true; } if (s.step === \"scores\") { const scores = answer.toLowerCase() === \"standard\" ? [15,14,13,12,10,8] : answer.split(/[ ,]+/).map(Number); if (scores.length !== 6 || scores.some((n: number) => !Number.isInteger(n) || n < 3 || n > 18)) { await sendChatMessage(`@${display} Enter exactly 6 whole-number scores from 3 to 18, such as !answer 15 14 13 12 10 8.`, broadcasterId); return true; } s.scores = scores; s.step = \"confirm\"; await saveCreationSession(s); const preview = customCharacterFromSession(s); await sendChatMessage(`@${display} Confirm: level 1 ${formatRaceName(preview.race,preview.subrace)} ${preview.cls}, ${formatStatLine(preview)}. Reply !answer yes to save or !answer no to restart.`, broadcasterId); return true; } if (s.step === \"confirm\") { if (answer.toLowerCase() === \"yes\") { const c = customCharacterFromSession(s); await saveCharacter(c); await clearCreationSession(username); await sendChatMessage(`@${display} Character saved! Use !char, !levelup, !savechar, and !loadchar.`, broadcasterId); } else if (answer.toLowerCase() === \"no\") { await clearCreationSession(username); await sendChatMessage(`@${display} Character discarded. Start again with !newchar.`, broadcasterId); } else await sendChatMessage(`@${display} Reply !answer yes to save or !answer no to discard.`, broadcasterId); return true; } return false; }\r\nfunction rollDice(input = \"1d20\") { const expression = input.trim() || \"1d20\"; const m = expression.match(/^(\\d+)d(\\d+)([+-]\\d+)?$/i); if (!m) return null; const n = +m[1], sides = +m[2], mod = m[3] ? +m[3] : 0; if (n > 100 || sides > 1000) return null; const rolls = Array.from({ length: n }, () => 1 + Math.floor(Math.random() * sides)); const rawTotal = rolls.reduce((a, b) => a + b, 0); const total = rawTotal + mod; const label = expression.toLowerCase() === \"1d20\" ? \"D20 of Fate\" : \"Dice roll\"; const rawD20 = n === 1 && sides === 20 ? rolls[0] : null; const puns = rawD20 === 20 ? [\"Natural 20! The bards are already writing the song.\", \"Critical success! Even the dice wanted to be legendary.\", \"The gods have stamped this roll approved.\", \"A natural 20—today, the dungeon fears you.\", \"Fate has opened the treasure chest of victory.\"] : rawD20 === 1 ? [\"Natural 1! The floor wins this round.\", \"Critical fumble! Somewhere, a goblin just gained confidence.\", \"The dice have requested a short rest.\", \"A natural 1—excellent roleplay opportunity incoming.\", \"Fate rolled a banana peel under your boots.\"] : total >= 17 ? [\"That roll arrived wearing a hero’s cape.\", \"The adventure is leaning dramatically in your favor.\", \"Even the dungeon master raised an eyebrow at that one.\", \"A mighty swing of the fate hammer.\", \"The prophecy is looking unusually promising.\"] : total <= 4 ? [\"That roll took a wrong turn at the tavern.\", \"The dungeon master is trying very hard not to smile.\", \"Fate has assigned you a side quest.\", \"The dice are demanding better snacks.\", \"That result has strong mimic-energy.\"] : [\"Fate has spoken—no rerolling destiny.\", \"The dungeon master may now pretend this was planned.\", \"That roll wandered in from a side quest.\", \"Somewhere, a bard is composing a song about this.\", \"Your modifiers are doing the heavy lifting.\", \"The goblins are taking notes.\", \"The prophecy remains open.\", \"Fate rolled over and asked for advantage.\", \"The initiative order has noticed you.\", \"A perfectly serviceable bit of adventuring.\", \"The dice have offered a plot twist.\", \"The tavern is buying the next round.\"]; const pun = puns[Math.floor(Math.random() * puns.length)]; return `🎲 ${label}: ${expression} → [${rolls.join(\", \")}]${mod ? (mod > 0 ? `+${mod}` : mod) : \"\"} = ${total}. ${pun}`; }\r\nasync function adjustLevel(username: string, delta: number) { const c = await getCharacter(username); if (!c) return { error: \"no character\" as const }; if (!Number.isInteger(delta) || delta === 0) return { error: \"invalid amount\" as const }; const oldLevel = c.level; const newLevel = Math.max(1, Math.min(20, oldLevel + delta)); if (newLevel === oldLevel) return { error: delta > 0 ? \"max level\" as const : \"min level\" as const }; const classData = classes[c.cls]; const perLevelHp = Math.max(1, Math.floor(classData.hitDie / 2) + 1 + modifier(c.scores.CON)); const baseHp = Math.max(1, classData.hitDie + modifier(c.scores.CON)); const oldHpMax = c.hpMax; c.level = newLevel; c.hpMax = baseHp + (newLevel - 1) * perLevelHp; c.hpCurrent = Math.max(0, Math.min(c.hpMax, c.hpCurrent + (c.hpMax - oldHpMax))); c.proficiency = Math.floor((newLevel - 1) / 4) + 2; await saveCharacter(c); const asi = [4, 8, 12, 16, 19].includes(newLevel) ? \" Ability Score Improvement/feat available.\" : \"\"; return { c, oldLevel, delta: newLevel - oldLevel, hpGain: c.hpMax - oldHpMax, asi }; }\r\n\r\nconst lookupResources: Record = { spell: \"spells\", item: \"equipment\", class: \"classes\", feat: \"feats\", ability: \"ability-scores\", race: \"races\", subrace: \"subraces\" };\r\nfunction compactText(value: unknown, max = 240) { return String(value ?? \"\").replace(/\\s+/g, \" \").replace(/<[^>]+>/g, \"\").trim().slice(0, max); }\r\nasync function lookup5e(kind: string, query: string): Promise { const resource = lookupResources[kind]; if (!resource || !query || query.length > 60) return null; const abilityAliases: Record = { strength: \"str\", dexterity: \"dex\", constitution: \"con\", intelligence: \"int\", wisdom: \"wis\", charisma: \"cha\" }; const lookupQuery = kind === \"ability\" ? (abilityAliases[query.toLowerCase().trim()] ?? query) : query; const normalized = lookupQuery.toLowerCase().trim().replace(/[^a-z0-9]+/g, \" \").replace(/\\s+/g, \" \"); const slug = normalized.replace(/ /g, \"-\"); const base = `https://www.dnd5eapi.co/api/2014/${resource}`; for (const candidate of [slug, normalized.replace(/ /g, \"-\")]) { const direct = await fetch(`${base}/${encodeURIComponent(candidate)}`); if (direct.ok) return await direct.json(); } const res = await fetch(base); if (!res.ok) return null; const list = (await res.json()).results ?? []; const comparable = (value: string) => value.toLowerCase().replace(/[^a-z0-9]/g, \"\"); const wanted = comparable(lookupQuery); const found = list.find((x: any) => comparable(x.name) === wanted) ?? list.find((x: any) => comparable(x.name).includes(wanted) || wanted.includes(comparable(x.name))); if (!found) return null; const detail = await fetch(`https://www.dnd5eapi.co${found.url}`); return detail.ok ? await detail.json() : null; }\r\nfunction formatSpellSections(data: any, bonus: number | null = null) { const upcast = bonus && bonus > 0 ? bonus : 0; const baseSlot = data.level + upcast; const slotDamage = data.damage?.damage_at_slot_level?.[String(baseSlot)]; const damage = data.damage ? `${data.damage.damage_type?.name ?? \"Damage\"} ${slotDamage ? `at slot ${baseSlot}: ${slotDamage}` : Object.entries(data.damage.damage_at_slot_level ?? {}).map(([level, dice]) => `L${level}:${dice}`).join(\"/\")}` : \"no direct damage\"; const dc = data.dc ? `${data.dc.dc_type?.name ?? \"save\"} save (${data.dc.dc_success ?? \"normal\"})` : \"no save\"; const area = data.area_of_effect ? `${data.area_of_effect.size}-ft ${data.area_of_effect.type}` : \"not listed\"; const components = (data.components ?? []).join(\"\") || \"none\"; const material = data.material ? `; material: ${compactText(data.material, 80)}` : \"\"; const classes = compactText((data.classes ?? []).map((x: any) => x.name).join(\", \"), 100) || \"none listed\"; const higher = data.higher_level?.length ? compactText(data.higher_level[0], 180) : \"none\"; return [`${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)\" : \"\"}`, `Components: ${components}${material} | Damage: ${damage} | Save: ${dc} | Area: ${area}`, `Classes: ${classes} | Higher levels: ${higher}`]; }\r\nfunction formatLookup(kind: string, data: any, bonus: number | null = null) { const name = data.name; const bonusText = bonus !== null ? `modifier +${bonus}; ` : \"\"; if (kind === \"item\") { const damage = data.damage ? `${data.damage.damage_dice ?? \"?\"} ${data.damage.damage_type?.name ?? \"damage\"}` : \"no weapon damage\"; const range = data.range?.normal != null ? (data.range.long != null ? `${data.range.normal}-${data.range.long} ft` : `${data.range.normal} ft`) : \"melee\"; const props = compactText((data.properties ?? []).map((x: any) => x.name).join(\", \"), 90); const ac = data.armor_category ? `AC ${data.armor_class?.base ?? \"?\"}${data.armor_class?.dex_bonus ? \"+ Dex\" : \"\"}` : \"\"; const itemParts = [`${bonusText}${bonus !== null ? `attack/damage +${bonus}` : \"\"}`, damage, `range ${range}`, ac, `weight ${data.weight ?? \"?\"} lb`, `cost ${data.cost?.quantity ?? \"?\"} ${data.cost?.unit ?? \"gp\"}`, `properties ${props || \"none\"}`].filter((part) => part.trim()); return `${name}: ${itemParts.join(\"; \")}`; } if (kind === \"class\") { const saves = (data.saving_throws ?? []).map((x: any) => x.name).join(\", \") || \"none listed\"; const profs = compactText((data.proficiencies ?? []).map((x: any) => x.name).join(\", \"), 140); return `${name}: ${bonusText}Hit Die d${data.hit_die}; saves ${saves}; proficiencies ${profs || \"none listed\"}`; } if (kind === \"feat\") { const prereq = (data.prerequisites ?? []).map((x: any) => `${x.ability_score?.name ?? \"ability\"} ${x.minimum_score ?? \"?\"}`).join(\", \") || \"none listed\"; return `${name}: ${bonusText}prerequisite ${prereq}; ${compactText((data.desc ?? []).join(\" \"), 220)}`; } if (kind === \"ability\") { const skills = compactText((data.skills ?? []).map((x: any) => x.name).join(\", \"), 100); return `${name}: ${bonusText}score ${data.full_name ?? name}; skills ${skills || \"none listed\"}; ${compactText((data.desc ?? []).join(\" \"), 180)}`; } if (kind === \"race\" || kind === \"subrace\") { const bonuses = (data.ability_bonuses ?? []).map((b: any) => `${b.ability_score?.name ?? b.ability_score?.index?.toUpperCase() ?? \"ability\"} +${b.bonus}`).join(\", \") || \"none listed\"; const traits = compactText((data.traits ?? data.racial_traits ?? []).map((x: any) => x.name).join(\", \")); const languages = compactText((data.languages ?? []).map((x: any) => x.name).join(\", \"), 80); const parent = data.race?.name ? `; parent race ${data.race.name}` : \"\"; return `${name}: ${bonusText}bonuses ${bonuses}; speed ${data.speed ?? \"?\"} ft; size ${data.size ?? \"?\"}${parent}; languages ${languages || \"not listed\"}; traits ${traits || \"none listed\"}`; } return name; }\r\n\r\nconst env = (name: string) => { const value = Deno.env.get(name); if (!value) throw new Error(`Missing environment variable: ${name}`); return value; };\r\nasync function sendChatMessage(text: string, broadcasterId: string) { const res = await fetch(\"https://api.twitch.tv/helix/chat/messages\", { method: \"POST\", headers: { Authorization: `Bearer ${await getAppToken()}`, \"Client-Id\": env(\"TWITCH_CLIENT_ID\"), \"Content-Type\": \"application/json\" }, body: JSON.stringify({ broadcaster_id: broadcasterId, sender_id: env(\"TWITCH_BOT_ID\"), message: text, for_source_only: true }) }); console.log(`Send message response: ${res.status} ${await res.text()}`); }\r\nconst MAX_LOOKUP_MESSAGE_LENGTH = 300;\r\nfunction splitChatMessage(text: string, max = MAX_LOOKUP_MESSAGE_LENGTH) { const parts: string[] = []; let remaining = text.trim(); while (remaining.length > max) { let cut = remaining.lastIndexOf(\" \", max); if (cut < 1) cut = max; parts.push(remaining.slice(0, cut).trim()); remaining = remaining.slice(cut).trim(); } if (remaining) parts.push(remaining); return parts; }\r\nasync function sendChatMessages(text: string, broadcasterId: string) { const parts = splitChatMessage(text); for (const part of parts) { if (part.length > MAX_LOOKUP_MESSAGE_LENGTH) throw new Error(\"Chat message splitter produced an oversized message\"); await sendChatMessage(part, broadcasterId); } }\r\nasync function sendSpellSections(sections: string[], display: string, broadcasterId: string) { for (const section of sections) { const parts = splitChatMessage(`@${display} ${section}`); for (const part of parts) { if (part.length > MAX_LOOKUP_MESSAGE_LENGTH) throw new Error(\"Spell section exceeded safe chat length\"); await sendChatMessage(part, broadcasterId); } } }\r\nasync function getAppToken() { const body = new URLSearchParams({ client_id: env(\"TWITCH_CLIENT_ID\"), client_secret: env(\"TWITCH_CLIENT_SECRET\"), grant_type: \"client_credentials\" }); const res = await fetch(\"https://id.twitch.tv/oauth2/token\", { method: \"POST\", headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" }, body }); if (!res.ok) throw new Error(`App token failed: ${res.status} ${await res.text()}`); return (await res.json()).access_token as string; }\r\nasync function exchangeCode(code: string, redirectUri: string) { const body = new URLSearchParams({ client_id: env(\"TWITCH_CLIENT_ID\"), client_secret: env(\"TWITCH_CLIENT_SECRET\"), code, grant_type: \"authorization_code\", redirect_uri: redirectUri }); const res = await fetch(\"https://id.twitch.tv/oauth2/token\", { method: \"POST\", headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" }, body }); if (!res.ok) throw new Error(`OAuth exchange failed: ${res.status} ${await res.text()}`); return await res.json(); }\r\nasync function createChatSubscription(broadcasterId: string, callbackUrl: string) { const appToken = await getAppToken(); const res = await fetch(\"https://api.twitch.tv/helix/eventsub/subscriptions\", { method: \"POST\", headers: { Authorization: `Bearer ${appToken}`, \"Client-Id\": env(\"TWITCH_CLIENT_ID\"), \"Content-Type\": \"application/json\" }, body: JSON.stringify({ type: \"channel.chat.message\", version: \"1\", condition: { broadcaster_user_id: broadcasterId, user_id: env(\"TWITCH_BOT_ID\") }, transport: { method: \"webhook\", callback: callbackUrl, secret: env(\"EVENTSUB_SECRET\") } }) }); const text = await res.text(); if (!res.ok) throw new Error(`EventSub subscription failed: ${res.status} ${text}`); return JSON.parse(text).data[0]; }\r\n\r\nasync function verifyEventSub(req: Request, rawBody: string) { const id = req.headers.get(\"Twitch-Eventsub-Message-Id\") ?? \"\"; const timestamp = req.headers.get(\"Twitch-Eventsub-Message-Timestamp\") ?? \"\"; const received = req.headers.get(\"Twitch-Eventsub-Message-Signature\") ?? \"\"; const key = await crypto.subtle.importKey(\"raw\", new TextEncoder().encode(env(\"EVENTSUB_SECRET\")), { name: \"HMAC\", hash: \"SHA-256\" }, false, [\"sign\"]); const signature = new Uint8Array(await crypto.subtle.sign(\"HMAC\", key, new TextEncoder().encode(id + timestamp + rawBody))); const hex = [...signature].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\"); const expected = `sha256=${hex}`; return received.length === expected.length && [...expected].every((c, i) => c === received[i]); }\r\nfunction renderCharacterPage(c: Character) { const statLine = abilityNames.map((a) => `

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

`).join(\"\"); 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(\", \")}

`; }\r\nfunction page(title: string, body: string) { return new Response(`${title}${body}`, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } }); }\r\nfunction renderGuidePage() { return `

Twitch D&D bot

GuildScribe

Keep the table moving. A quick reference for character creation, D&D lookups, and live combat turns.

Connect a channel Support the bot

Getting started: Mod the bot in your channel with /mod GuildScribeBot, then use !help for the welcome guide or !dndbothelp to browse this reference from chat.

Character commands

Create and view

!newchar

Start a guided chat wizard. Reply with !answer <choice> to select a race, subrace, class, and ability scores.

!createchar

Immediately create a level 1 character.

!char

Display your current character summary.

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.

Dice

!roll!r!d20

All three commands roll the D20 of Fate by default.

!roll NdS[+/-M]

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

D&D lookups

Look up SRD information by name. Add an optional positive modifier to the search; for spells it represents an upcast amount, and for items it represents an attack/damage bonus.

Rules and magic

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

Combat turn tracker

Combat commands are restricted to the broadcaster or a moderator.

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

Onboarding and support

In chat

!help

Replay the three-step getting-started welcome message.

!dndbothelp

Show the command categories.

!link

Post the GuildScribe Bot Guide link in chat.

Show the command categories. Expand one with !dndbothelp character, !dndbothelp combat, !dndbothelp lookup, or !dndbothelp dice.

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 at /logs or use !logs in chat.

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

`; }\r\n\r\nexport default async function (req: Request): Promise {\r\n await ensureTables(); const url = new URL(req.url); const path = url.pathname;\r\n if (req.method === \"GET\" && (path === \"/logs\" || path === \"/activity\")) return page(\"GuildScribe Activity Logs\", renderLogsPage(await getRecentLogs()));\r\n if (req.method === \"GET\" && (path === \"/guide\" || path === \"/commands\")) return page(\"GuildScribe Bot Guide\", `

GuildScribe Bot Guide

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

Support the D&D Bot

If this bot has helped your campaign, you can support its continued development.

Ethereum (ETH)

0x422413678AdFC67d3d9AB545FE4e1ec1D00197fd

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

Bitcoin (BTC)

3JYo1Vwyh6aQENzXoi16rA9mXZuZQVL1rN

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

Back to the bot

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

Connection cancelled

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

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

Connected successfully

${escapeHtml(user.display_name)} is now connected. The bot can respond in that channel after the EventSub subscription is enabled.

Important: In your Twitch chat, run /mod GuildScribeBot so the bot can read and respond reliably.

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

Connection failed

${escapeHtml(String(e))}

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

D&D Twitch Bot

Connect your Twitch channel to enable the bot.

Add Bot to My Channel

Important: After connecting, mod the bot in your channel with /mod GuildScribeBot so it can read and respond reliably.

View all commands and bot info

Support the bot

`); } const c = await getCharacter(username); if (!c) return new Response(\"No character found for that user.\", { status: 404 }); return new Response(renderCharacterPage(c), { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } }); }\r\n if (req.method !== \"POST\") return new Response(\"OK\");\r\n const rawBody = await req.text(); if (!(await verifyEventSub(req, rawBody))) return new Response(\"Invalid signature\", { status: 403 }); const messageType = req.headers.get(\"Twitch-Eventsub-Message-Type\"); const body = JSON.parse(rawBody);\r\n if (messageType === \"webhook_callback_verification\") return new Response(body.challenge, { headers: { \"Content-Type\": \"text/plain\" } });\r\n if (messageType === \"notification\") { const chatMessage: string = body.event?.message?.text ?? \"\"; const chatter: string = body.event?.chatter_user_login ?? \"\"; const display: string = body.event?.chatter_user_name ?? chatter; const chatterId: string = body.event?.chatter_user_id ?? \"\"; const moderatorId: string = body.event?.moderator_user_id ?? \"\"; const eventBroadcasterId: string = body.event?.broadcaster_user_id ?? \"\"; const broadcasterId: string = body.event?.source_broadcaster_user_id ?? eventBroadcasterId; const isModerator = chatterId === broadcasterId || chatterId === eventBroadcasterId || chatterId === moderatorId || hasModeratorBadge(body.event); const baseUrl = url.origin; console.log(`[${broadcasterId}] ${chatter} said: ${chatMessage}`); if (isBotAccount(chatter, chatterId)) return new Response(\"OK\"); const botToggle = chatMessage.trim().match(/^!dndbot\\s+(on|off|status)$/i); if (botToggle) { if (!isModerator) await sendChatMessage(`@${display} only the broadcaster or a moderator can change the bot setting.`, broadcasterId); else if (botToggle[1].toLowerCase() === \"status\") await sendChatMessage(`@${display} GuildScribe is currently ${(await isChannelEnabled(broadcasterId)) ? \"on\" : \"off\"} in this channel.`, broadcasterId); else { const enabled = botToggle[1].toLowerCase() === \"on\"; await setChannelEnabled(broadcasterId, enabled); await sendChatMessage(`@${display} GuildScribe is now ${enabled ? \"on\" : \"off\"} in this channel.`, broadcasterId); } return new Response(\"OK\"); } if (!(await isChannelEnabled(broadcasterId))) return new Response(\"OK\"); if (chatMessage.startsWith(\"!\")) await recordActivity(chatter, broadcasterId, chatMessage.split(/\\s+/)[0].toLowerCase(), chatMessage); if (await handleCreationCommand(chatter, display, broadcasterId, chatMessage)) return new Response(\"OK\"); if (await handleInitiativeCommand(chatMessage, broadcasterId, display, isModerator)) return new Response(\"OK\");\r\n if (chatMessage === \"!logs\") { if (!isModerator) await sendChatMessage(`@${display} only the broadcaster or a moderator can use !logs.`, broadcasterId); else { const logs = await getRecentLogs(broadcasterId, 8); await sendChatMessages(logs.length ? `@${display} Recent activity: ${logs.reverse().map(logRowText).join(\" || \")}` : `@${display} no activity has been logged yet.`, broadcasterId); } }\r\n else if (chatMessage === \"!connections\") { if (!isModerator) await sendChatMessage(`@${display} only the broadcaster or a moderator can use !connections.`, broadcasterId); else { const names = await getConnections(); await sendChatMessages(`@${display} Connected channels (${names.length}): ${names.length ? names.join(\", \") : \"none\"}`, broadcasterId); } }\r\n else if (chatMessage === \"!help\") { await sendWelcomeMessage(display, broadcasterId); }\r\n else if (chatMessage === \"!link\") { await sendChatMessage(`@${display} GuildScribe Bot Guide https://bit.ly/4iClxxC`, broadcasterId); }\r\n else if (/^!dndbothelp(?:\\s+\\w+)?$/i.test(chatMessage)) { const category = chatMessage.split(/\\s+/)[1]?.toLowerCase(); const help = category === \"dice\" ? \"Dice: !roll | !r | !d20 (D20 of Fate) | !roll NdS[+/-M]\" : category === \"settings\" ? \"Settings (mod): !dndbot on | !dndbot off | !dndbot status\" : category === \"character\" ? \"Character: !newchar | !answer | !cancel | !createchar | !char | !levelup [+/-levels] | !hp [+/-amount] | !savechar | !loadchar | !resetchar\" : category === \"combat\" ? \"Combat: !turn start | !turn add | !turn show | !turn next | !turn prev | !turn remove | !turn end\" : category === \"lookup\" ? \"Lookups: !spell [spell] [+N] | !item [item] [+N] | !class [class] [+N] | !feat [feat] [+N] | !ability [ability] [+N] | !race [race] [+N] | !subrace [subrace] [+N]\" : `Categories: dice | character | combat | lookup | settings. Expand one with !dndbothelp .`; await sendChatMessages(`@${display} ${help}`, broadcasterId); }\r\n else if (/^!levelup(?:\\s+([+-]\\d+))?$/i.test(chatMessage)) { const match = chatMessage.match(/^!levelup(?:\\s+([+-]\\d+))?$/i)!; const delta = match[1] ? Number.parseInt(match[1], 10) : 1; const result = await adjustLevel(chatter, delta); if (\"error\" in result) { const errorText = result.error === \"no character\" ? \"you don't have a character yet — try !createchar\" : result.error === \"max level\" ? \"you're already level 20\" : result.error === \"min level\" ? \"you're already level 1\" : \"use !levelup, !levelup +2, or !levelup -1\"; await sendChatMessage(`@${display} ${errorText}`, broadcasterId); } else { const direction = result.delta > 0 ? \"advanced\" : \"reduced\"; const hpChange = result.hpGain >= 0 ? `HP +${result.hpGain}` : `HP ${result.hpGain}`; await sendChatMessage(`@${display} level ${direction} from ${result.oldLevel} to ${result.c.level}; ${hpChange}, HP ${result.c.hpCurrent}/${result.c.hpMax}, Prof +${result.c.proficiency}.${result.asi}`, broadcasterId); } }\r\n else if (/^!(spell|item|class|feat|ability|race|subrace)\\s+/i.test(chatMessage)) { const match = chatMessage.match(/^!(spell|item|class|feat|ability|race|subrace)\\s+(.+?)(?:\\s+\\+(\\d+))?$/i)!; const kind = match[1].toLowerCase(); const bonus = match[3] ? Math.min(20, Number.parseInt(match[3], 10)) : null; const data = await lookup5e(kind, match[2].trim()); if (data && kind === \"spell\") await sendSpellSections(formatSpellSections(data, bonus), display, broadcasterId); else await sendChatMessages(data ? `@${display} ${formatLookup(kind, data, bonus)}` : `@${display} couldn't find that ${kind}. Try an exact search, such as !spell fireball or !item longsword +1`, broadcasterId); }\r\n else if (/^!(?:roll|r)(?:\\s+.*)?$/i.test(chatMessage) || chatMessage.toLowerCase() === \"!d20\") { const expression = chatMessage.toLowerCase() === \"!d20\" ? \"1d20\" : chatMessage.replace(/^!(?:roll|r)\\s*/i, \"\").trim(); const result = rollDice(expression || \"1d20\"); await sendChatMessage(result ? `@${display} ${result}` : `@${display} that's not a valid roll — try !roll, !r, or !roll 2d6+3`, broadcasterId); }\r\n else if (chatMessage === \"!createchar\") { const c = generateCharacter(chatter); await saveCharacter(c); await sendChatMessage(`@${display} created a level 1 ${formatRaceName(c.race,c.subrace)} ${c.cls}! ${formatStatLine(c)} — ${baseUrl}/?user=${chatter}`, broadcasterId); }\r\n else if (chatMessage === \"!char\") { const c = await getCharacter(chatter); await sendChatMessage(c ? `@${display} ${formatRaceName(c.race,c.subrace)} ${c.cls} — ${formatStatLine(c)} — ${baseUrl}/?user=${chatter}` : `@${display} you don't have a character yet — try !createchar`, broadcasterId); }\r\n else if (chatMessage.startsWith(\"!hp \")) { const delta = Number.parseInt(chatMessage.slice(4).trim()); if (Number.isNaN(delta)) await sendChatMessage(`@${display} use !hp +5 or !hp -3`, broadcasterId); else { const c = await adjustHp(chatter, delta); await sendChatMessage(c ? `@${display} HP: ${c.hpCurrent}/${c.hpMax}` : `@${display} you don't have a character yet — try !createchar`, broadcasterId); } }\r\n else if (chatMessage === \"!savechar\") await sendChatMessage(await backupCharacter(chatter) ? `@${display} character saved!` : `@${display} no character to save — try !createchar`, broadcasterId);\r\n else if (chatMessage === \"!loadchar\") { const c = await loadBackup(chatter); await sendChatMessage(c ? `@${display} character loaded! ${formatStatLine(c)} — ${baseUrl}/?user=${chatter}` : `@${display} no saved backup found — try !savechar first`, broadcasterId); }\r\n else if (chatMessage === \"!resetchar\") { await resetCharacter(chatter); await sendChatMessage(`@${display} character reset — use !createchar to roll a new one`, broadcasterId); }\r\n }\r\n if (messageType === \"revocation\") console.log(\"Subscription revoked:\", body); return new Response(\"OK\");\r\n}\r\n\r\n// TWITCH_BOT_ID must be the numeric Twitch user ID belonging to TWITCH_BOT_TOKEN.\r\n",[168],"0db2918d-b81c-4003-a453-320a66075935","deno.json","2c8aa57e-a3c0-11f1-9adc-1607ee4eb77e",4,["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}",[177],"b30872ef-ae38-4887-bd63-5417a2faeb55","data.ts","799fb39e-a4d9-11f1-8231-1607ee4eb77e",57,["D",1788138940739],[184],"b61ed85b-9adc-4202-bbd1-9f210a68f519",["D",1788138962186],[28],"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`",[193],"722e7a17-a099-4f29-8e69-2679535add68",".vtignore","2c724ea2-a3c0-11f1-bf9f-1607ee4eb77e",["D",1788018119974],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[200],"pulls","branches","forks","envVars",{"_212":214,"_215":60},"connections",{"_212":60,"_213":60},"count","unfilledCount",6,"emptyCount",{"_43":199,"_32":200,"_30":201,"_141":-5,"_41":42,"_40":145,"_143":123,"_38":254,"_13":60,"_34":20,"_36":203,"_24":25,"_146":-5,"_227":255,"_27":256},{"_43":192,"_32":193,"_30":194,"_141":-5,"_41":42,"_40":195,"_143":25,"_38":251,"_13":60,"_34":20,"_36":197,"_24":25,"_146":-5,"_227":252,"_27":253},{"_43":189,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":25,"_38":248,"_13":145,"_34":35,"_36":37,"_24":25,"_146":-5,"_227":249,"_27":250},{"_43":183,"_32":184,"_30":185,"_141":-5,"_41":42,"_40":186,"_143":25,"_38":245,"_13":145,"_34":35,"_36":37,"_24":25,"_146":-5,"_227":246,"_27":247},{"_43":176,"_32":177,"_30":178,"_141":-5,"_41":42,"_40":179,"_143":123,"_38":242,"_13":60,"_34":20,"_36":181,"_24":25,"_146":-5,"_227":243,"_27":244},{"_43":167,"_32":168,"_30":169,"_141":-5,"_41":42,"_40":170,"_143":25,"_38":239,"_13":172,"_34":173,"_36":174,"_24":25,"_146":-5,"_227":240,"_27":241},{"_43":160,"_32":161,"_30":162,"_141":-5,"_41":42,"_40":163,"_143":25,"_38":236,"_13":145,"_34":35,"_36":37,"_24":25,"_146":165,"_227":237,"_27":238},{"_43":154,"_32":155,"_30":156,"_141":-5,"_41":42,"_40":157,"_143":25,"_38":233,"_13":60,"_34":35,"_36":37,"_24":25,"_146":-5,"_227":234,"_27":235},{"_43":148,"_32":149,"_30":150,"_141":-5,"_41":42,"_40":151,"_143":25,"_38":230,"_13":145,"_34":35,"_36":37,"_24":25,"_146":-5,"_227":231,"_27":232},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":25,"_38":226,"_13":145,"_34":35,"_36":37,"_24":25,"_146":-5,"_227":228,"_27":229},["D",1788138950181],"children",[],[139],["D",1788138936330],[],[149],["D",1788138952683],[],[155],["D",1788138928779],[],[161],["D",1788056960628],[],[168],["D",1788018120139],[],[177],["D",1788138940739],[],[184],["D",1788138962186],[],[28],["D",1788018120020],[],[193],["D",1788018119974],[],[200],["D",1787995257440],["D",1789587078639],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_125":295,"_296":297,"_298":299,"_300":25,"_301":25,"_302":25,"_303":123,"_304":-5,"_305":-7,"_306":-7,"_307":60,"_308":25,"_309":25,"_310":-5,"_311":25,"_312":25,"_313":25,"_314":-5},"ENV",{"_266":267,"_268":269,"_270":87,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294},"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 · v62