[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_102":103,"_104":105},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","conflux","name","confluxcon","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/conflux/confluxcon/code/main.ts","extension","id","a3923757-2d48-48dc-9f45-b2f4d7145252","fileId","a5831fa6-a744-11f1-a2db-1607ee4eb77e","parentId","branchId","a6081b17-be19-4cf0-a9cb-c22007b2eaa4","branchVersion",11,"latest",true,"createdAt",["D",1788894188413],"version",10,"fileType","http","content","/**\n * confluxcon — the backend, on Val Town.\n *\n * SETUP (once, about two minutes)\n * 1. val.town ▸ sign in with GitHub ▸ New ▸ HTTP val.\n * 2. Delete what's there, paste this whole file in. It saves as you type.\n * 3. Copy the val's URL (the .web.val.run one, top right).\n * 4. Hand that URL over; seeding happens over HTTP, no pasting.\n *\n * The database is Val Town's SQLite. Guests are rows; a save writes one row,\n * so two people RSVPing at the same moment can't overwrite each other.\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n/* Bumped whenever this file changes, so a plain GET on the val says which\n version is actually pasted in. */\nconst BUILD = \"2026-09-08 · trivia r4 (fixes Ask)\";\n\n/* Stamps older than this were guessed from a last-edit time, not recorded when\n someone actually answered. They are cleared once and never written again. */\nconst BACKFILL_CUTOFF = \"2026-09-04T06:44:21Z\";\n\nconst G = \"confluxcon_guests_v1\";\nconst S = \"confluxcon_sessions_v1\";\nconst L = \"confluxcon_log_v1\";\n\n/* trivia: a key/value state doc, the teams, the questions, the answers */\nconst T = \"confluxcon_trivia_v1\";\nconst TT = \"confluxcon_teams_v1\";\nconst TQ = \"confluxcon_tquestions_v1\";\nconst TA = \"confluxcon_tanswers_v1\";\n\nconst GCOLS = [\n \"ord\",\n \"slug\",\n \"first\",\n \"last\",\n \"password\",\n \"admin\",\n \"met\",\n \"org\",\n \"lane\",\n \"tier\",\n \"going\",\n \"prob\",\n \"arrive\",\n \"link\",\n \"run\",\n \"sessions\",\n \"namevote\",\n \"note\",\n \"msg\",\n \"pay\",\n \"seen\",\n \"updated\",\n \"rsvped\",\n \"diet\",\n \"team\",\n];\n\nconst WORDS =\n (\"bellwether cinder driftwood ember fathom girder hearth ingot jetty keystone \" +\n \"lodestar mantle nectar obelisk parapet quiver rampart sextant tallow undertow vellum \" +\n \"wainscot xenon yardarm zenith almanac bramble copse dovetail escarpment foxglove gantry \" +\n \"harrow inglenook kestrel limber mordant nutmeg oriel pallet quarry ridgeline\")\n .split(\" \");\n\n/* ---------- plumbing ------------------------------------------------------ */\n\nasync function init() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${G} (\n ord INTEGER, slug TEXT PRIMARY KEY, first TEXT, last TEXT, password TEXT,\n admin TEXT, met TEXT, org TEXT, lane TEXT, tier TEXT, going TEXT, prob TEXT,\n arrive TEXT, link TEXT, run TEXT, sessions TEXT, namevote TEXT,\n note TEXT, msg TEXT, pay TEXT, seen TEXT, updated TEXT)`);\n // Older tables predate these columns; adding one that exists throws, harmlessly.\n for (const col of [\"tier\", \"note\", \"msg\", \"pay\", \"rsvped\", \"diet\", \"team\"]) {\n try {\n await sqlite.execute(`ALTER TABLE ${G} ADD COLUMN ${col} TEXT`);\n } catch (_) {}\n }\n /* \"rsvped\" is when someone first answered, which is the order the guest wall\n reads in. Nobody who answered before the column existed has one, and the\n wall shows those people first, in the order the console lists them — a\n last-edit time was tried and it put people in the wrong order. Anything\n stamped before this build is one of those guesses, so it goes. */\n try {\n await sqlite.execute({\n sql: `UPDATE ${G} SET rsvped = '' WHERE rsvped <> '' AND rsvped < ?`,\n args: [BACKFILL_CUTOFF],\n });\n } catch (_) {}\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${S} (\n name TEXT PRIMARY KEY, by TEXT, host TEXT, descr TEXT, sched TEXT)`);\n // Same story as the guest table: older session tables predate these two.\n // \"descr\", not \"desc\" — DESC is a keyword SQLite won't take bare.\n for (const col of [\"descr\", \"sched\"]) {\n try {\n await sqlite.execute(`ALTER TABLE ${S} ADD COLUMN ${col} TEXT`);\n } catch (_) {}\n }\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${L} (\n id INTEGER PRIMARY KEY AUTOINCREMENT, at TEXT, who TEXT, what TEXT)`);\n\n /* Trivia. The state doc is key/value so one setting can be written without\n reading the rest back first. Everything else is a plain row per thing. */\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${T} (k TEXT PRIMARY KEY, v TEXT)`,\n );\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TT} (\n id TEXT PRIMARY KEY, name TEXT, captain TEXT, created TEXT)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TQ} (\n id TEXT PRIMARY KEY, rnd INTEGER, ord INTEGER, prompt TEXT, answer TEXT,\n points TEXT, state TEXT, note TEXT)`);\n /* Who wrote the question. Never leaves the host's own screen — one of the\n questions asks the room to guess, so this would give it away. */\n try {\n await sqlite.execute(`ALTER TABLE ${TQ} ADD COLUMN src TEXT`);\n } catch (_) {}\n /* One answer per team per question — the id is both together, so a second\n member of the same team overwrites rather than adding a second row. */\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TA} (\n id TEXT PRIMARY KEY, qid TEXT, team TEXT, text TEXT, by TEXT, at TEXT, mark TEXT)`);\n /* A typed-in number beats both the key and the tick, for the questions that\n pay per name, dock a point for a wrong guess, or go to whoever is nearest. */\n try {\n await sqlite.execute(`ALTER TABLE ${TA} ADD COLUMN score TEXT`);\n } catch (_) {}\n}\n\n/* ---------- the log -------------------------------------------------------\n Every write leaves one line behind, so the console can show what everyone\n has been doing. Read by the admin only; nothing here is shown to guests. */\n\nconst full = (g: any) => `${g.first || \"\"} ${g.last || \"\"}`.trim() || g.slug;\n\nasync function log(who: string, what: string) {\n if (!what) return;\n try {\n await sqlite.execute({\n sql: `INSERT INTO ${L} (at, who, what) VALUES (?, ?, ?)`,\n args: [new Date().toISOString(), clean(who, 60), clean(what, 400)],\n });\n } catch (_) { /* a log that fails must never fail the write it describes */ }\n}\n\nconst VISIT = \"opened the site\";\n\n/** Opening the site writes one line, not one per refresh. */\nasync function logVisit(who: string) {\n try {\n const res = await sqlite.execute({\n sql: `SELECT at, what FROM ${L} WHERE who = ? ORDER BY id DESC LIMIT 1`,\n args: [clean(who, 60)],\n });\n const last: any = (res.rows as any[][])[0];\n if (\n last && String(last[1]) === VISIT &&\n Date.now() - Date.parse(String(last[0])) < 30 * 60 * 1000\n ) return;\n } catch (_) {}\n await log(who, VISIT);\n}\n\n/** Values go in the log short, whatever their length in the sheet. */\nconst brief = (v: any) => {\n const t = String(v == null ? \"\" : v).replace(/\\s+/g, \" \").trim();\n return !t ? \"\\u2014\" : t.length > 44 ? t.slice(0, 43) + \"\\u2026\" : t;\n};\n\nfunction objs(res: any) {\n const cols = res.columns as string[];\n return (res.rows as any[][]).map((r) => {\n const o: any = {};\n cols.forEach((c, i) => {\n o[c] = r[i] === null ? \"\" : r[i];\n });\n return o;\n });\n}\n\nconst guests = async () =>\n objs(await sqlite.execute(`SELECT * FROM ${G} ORDER BY ord`));\nconst sessions = async () =>\n objs(await sqlite.execute(`SELECT * FROM ${S} ORDER BY rowid`));\n\nasync function setField(slug: string, col: string, value: any) {\n if (!GCOLS.includes(col)) return;\n await sqlite.execute({\n sql: `UPDATE ${G} SET ${col} = ? WHERE slug = ?`,\n args: [value, slug],\n });\n}\n\nconst clean = (v: any, max = 300) =>\n String(v == null ? \"\" : v).replace(/[\\r\\n\\t]+/g, \" \").trim().slice(0, max);\n\n/** Digits and one point, for a dollar figure. */\nconst money = (v: any) => {\n const t = String(v == null ? \"\" : v).replace(/[^0-9.]/g, \"\").slice(0, 9);\n return t === \"\" || isNaN(Number(t)) ? \"\" : String(Math.max(0, Number(t)));\n};\n\n/** Same as clean, but a message to the host is allowed its paragraphs. */\nconst cleanLines = (v: any, max = 2000) =>\n String(v == null ? \"\" : v).replace(/\\r/g, \"\").replace(/\\t/g, \" \")\n .replace(/\\n{3,}/g, \"\\n\\n\").trim().slice(0, max);\n\nconst num = (v: any) => {\n if (v === \"\" || v == null) return \"\";\n const n = Math.round(Number(v));\n return isNaN(n) ? \"\" : String(Math.max(0, Math.min(100, n)));\n};\n\nconst isYes = (v: any) => v === true || v === \"yes\";\n\n/* ---------- shaping ------------------------------------------------------- */\n\nfunction parseSessions(v: any) {\n try {\n return JSON.parse(v || \"{}\") || {};\n } catch {\n return {};\n }\n}\n\n/** What every signed-in guest may see about everyone else. No passwords. */\nfunction publicCard(g: any) {\n return {\n slug: g.slug,\n first: g.first,\n last: g.last,\n met: g.met,\n org: g.org,\n link: g.link,\n going: g.going,\n prob: g.prob === \"\" ? null : Number(g.prob),\n /* The board hides an answer from someone who turns up after the thing has\n finished, so every browser needs the arrival time to do that sum. */\n arrive: g.arrive || \"\",\n run: g.run,\n sessions: parseSessions(g.sessions),\n namevote: g.namevote || \"\",\n note: g.note || \"\",\n rsvped: g.rsvped || \"\",\n seen: isYes(g.seen),\n };\n}\n\n/** Everything, for the one admin. */\nfunction adminRow(g: any) {\n const c: any = publicCard(g);\n c.password = g.password;\n c.lane = g.lane || \"invited\";\n c.tier = g.tier == null ? \"\" : String(g.tier);\n c.msg = g.msg || \"\"; // never leaves adminRow\n c.pay = g.pay || \"\"; // nor does this\n c.diet = g.diet || \"\"; // nor does this\n c.order = Number(g.ord) || 0;\n c.admin = isYes(g.admin);\n return c;\n}\n\nasync function payload(me: any, all: any[], isAdmin: boolean) {\n /* Whoever put a session up may rewrite its details, and so may the host —\n which is what lets Jacob edit the four that were seeded with no owner. */\n const owns = (s: any) =>\n isAdmin || (!!s.by && String(s.by) === String(me.first));\n const sess = (await sessions()).map((s) => ({\n name: s.name,\n by: s.by,\n host: isYes(s.host),\n descr: s.descr || \"\", // shown to everyone\n sched: owns(s) ? (s.sched || \"\") : \"\", // only to whoever runs it\n mine: owns(s),\n }));\n const out: any = {\n ok: true,\n slug: me.slug,\n admin: isAdmin,\n me: adminRow(me),\n sessions: sess,\n guests: all.filter((g) => (g.lane || \"invited\") === \"invited\").map(\n publicCard,\n ),\n };\n if (isAdmin) {\n out.roster = [...all].sort((a, b) =>\n (Number(a.ord) || 0) - (Number(b.ord) || 0)\n ).map(adminRow);\n }\n /* Two values, so the browser knows whether to draw the trivia tab at all\n before it has polled for anything. */\n const st = await tstate();\n out.trivia = {\n phase: st.phase,\n visible: canSeeTrivia(st, me),\n title: st.title,\n };\n return out;\n}\n\nconst byPassword = (all: any[], pw: any) => {\n const p = String(pw || \"\").trim().toLowerCase();\n if (!p) return null;\n return all.find((g) => String(g.password || \"\").trim().toLowerCase() === p) ||\n null;\n};\n\n/* ---------- trivia --------------------------------------------------------\n A question, a team, a typed answer, right or wrong, one point unless said\n otherwise. Questions sit in numbered rounds; the host opens one at a time\n and closes it when the room has had long enough. Closing is what puts the\n points on the board, so nothing scores until the host says it does. */\n\nconst TSTATE_DEFAULTS: Record = {\n phase: \"off\", // off | teams | play | done\n visible: \"\", // \"yes\" once every guest may see the tab\n preview: \"\", // slugs who may see it before that — for trying it out\n active: \"\", // the question currently taking answers\n last: \"\", // the one most recently closed, for the reveal\n title: \"AI safety trivia\",\n};\n\nasync function tstate() {\n const rows = objs(await sqlite.execute(`SELECT k, v FROM ${T}`));\n const o: Record = { ...TSTATE_DEFAULTS };\n for (const r of rows) o[String(r.k)] = String(r.v ?? \"\");\n return o;\n}\n\nasync function tset(k: string, v: any) {\n await sqlite.execute({\n sql:\n `INSERT INTO ${T} (k, v) VALUES (?, ?) ON CONFLICT(k) DO UPDATE SET v = excluded.v`,\n args: [k, clean(v, 300)],\n });\n}\n\nconst teamsAll = async () =>\n objs(await sqlite.execute(`SELECT * FROM ${TT} ORDER BY created`));\nconst questAll = async () =>\n objs(await sqlite.execute(`SELECT * FROM ${TQ} ORDER BY rnd, ord`));\nconst answAll = async () => objs(await sqlite.execute(`SELECT * FROM ${TA}`));\n\n/* An id nobody has to type, short enough to read in a log line. */\nconst newId = (p: string) =>\n p + Date.now().toString(36).slice(-6) +\n Math.random().toString(36).slice(2, 5);\n\n/* Marking is generous about the things that are never the point: case,\n punctuation, accents, leading articles, doubled spaces. It is strict about\n everything else — the host has the last word on anything it gets wrong. */\nconst tnorm = (v: any) =>\n String(v == null ? \"\" : v)\n .toLowerCase().normalize(\"NFKD\").replace(/[\\u0300-\\u036f]/g, \"\")\n .replace(/[^a-z0-9 ]+/g, \" \")\n .replace(/\\b(the|a|an|of)\\b/g, \" \")\n .replace(/\\s+/g, \" \").trim();\n\n/** Everything the key will take, one per line or split on a pipe. */\nconst accepted = (q: any) =>\n String(q?.answer || \"\").split(/[\\n|]+/).map(tnorm).filter(Boolean);\n\n/** Right or wrong: the host's mark if there is one, otherwise the key. */\nfunction correct(q: any, a: any) {\n if (!a) return false;\n if (a.mark === \"yes\") return true;\n if (a.mark === \"no\") return false;\n const t = tnorm(a.text);\n return !!t && accepted(q).includes(t);\n}\n\nconst points = (q: any) => {\n const n = Number(q?.points);\n return isNaN(n) || n <= 0 ? 1 : Math.min(99, Math.round(n));\n};\n\n/* Half a point per surname, minus one for a wrong board member, three for the\n closest guess — none of that is right or wrong, so the host may type the\n number instead. Blank means work it out from the key. */\nconst hasScore = (a: any) =>\n a && String(a.score ?? \"\").trim() !== \"\" && !isNaN(Number(a.score));\n\n/** What one answer is worth. */\nfunction worth(q: any, a: any) {\n if (hasScore(a)) return Math.max(-99, Math.min(99, Number(a.score)));\n return correct(q, a) ? points(q) : 0;\n}\n\n/* Scores can be fractional now, so they are added up in tenths and put back\n afterwards — 0.1 + 0.2 is not 0.3 in floating point and a scoreboard that\n says 4.699999999999999 is not a scoreboard. */\nconst tidy = (n: number) => Math.round(n * 10) / 10;\n\n/** Round names live in the state doc under rnd:1, rnd:2, … */\nfunction roundsOf(st: Record, qs: any[]) {\n const ns = new Set();\n for (const k in st) if (/^rnd:\\d+$/.test(k)) ns.add(Number(k.slice(4)));\n for (const q of qs) ns.add(Number(q.rnd) || 1);\n if (!ns.size) ns.add(1);\n return [...ns].sort((a, b) => a - b)\n .map((n) => ({ n, name: st[\"rnd:\" + n] || `Round ${n}` }));\n}\n\n/** A question as a guest may see it — no key until the question is closed. */\nfunction askCard(q: any, reveal: boolean) {\n return {\n id: q.id,\n rnd: Number(q.rnd) || 1,\n ord: Number(q.ord) || 0,\n prompt: q.prompt || \"\",\n points: points(q),\n state: q.state || \"todo\",\n answer: reveal ? (q.answer || \"\") : \"\",\n note: reveal ? (q.note || \"\") : \"\",\n };\n}\n\n/* Who may see the tab at all: everyone once it is switched on, and before\n that only the accounts named for a preview. */\nconst previewers = (st: Record) =>\n new Set(\n String(st.preview || \"\").split(\",\").map((x) => x.trim()).filter(Boolean),\n );\n\nconst canSeeTrivia = (st: Record, me: any) =>\n isYes(me?.admin) || st.visible === \"yes\" ||\n previewers(st).has(String(me?.slug || \"\"));\n\nasync function triviaPayload(me: any, isAdmin: boolean) {\n const st = await tstate();\n const teams = await teamsAll();\n const qs = await questAll();\n const ans = await answAll();\n const all = await guests();\n\n const byQ: Record = {};\n for (const a of ans) (byQ[String(a.qid)] ||= []).push(a);\n const answerFor = (qid: string, team: string) =>\n (byQ[qid] || []).find((a) => String(a.team) === String(team));\n\n /* Only closed questions count, which is what makes \"close it\" the host's\n scoring gesture rather than a separate step to forget. */\n const scored = qs.filter((q) => q.state === \"done\");\n const table = teams.map((t) => {\n let score = 0, right = 0;\n for (const q of scored) {\n const a = answerFor(String(q.id), String(t.id));\n score += worth(q, a);\n if (worth(q, a) > 0) right++;\n }\n score = tidy(score);\n const members = all.filter((g) => String(g.team || \"\") === String(t.id));\n return {\n id: t.id,\n name: t.name || \"Unnamed team\",\n captain: t.captain || \"\",\n members: members.map((g) => ({ slug: g.slug, name: full(g) })),\n score,\n right,\n of: scored.length,\n };\n }).sort((a, b) => b.score - a.score || a.name.localeCompare(b.name));\n\n const mine = String(me?.team || \"\");\n const active =\n qs.find((q) => String(q.id) === st.active && q.state === \"open\") || null;\n\n const out: any = {\n ok: true,\n trivia: {\n phase: st.phase,\n /* What this viewer may see, which is not the same as the switch. */\n visible: canSeeTrivia(st, me),\n live: st.visible === \"yes\",\n title: st.title,\n rounds: roundsOf(st, qs),\n teams: table,\n team: mine,\n /* Guests get the open question with the key withheld, plus whatever\n their team has typed so far — every member sees the same box. */\n active: active ? askCard(active, false) : null,\n answer: active && mine\n ? ((a) =>\n a ? { text: a.text || \"\", by: a.by || \"\", at: a.at || \"\" } : null)(\n answerFor(String(active.id), mine),\n )\n : null,\n /* The one most recently closed, so the room can see what it should have\n said. Recorded when it closes, because the host does not always work\n straight down the list. */\n last: ((r) =>\n r\n ? {\n ...askCard(r, true),\n rows: teams.map((t) => {\n const a = answerFor(String(r.id), String(t.id));\n return {\n team: t.id,\n text: a?.text || \"\",\n right: worth(r, a) > 0,\n worth: tidy(worth(r, a)),\n };\n }),\n }\n : null)(\n scored.find((q) => String(q.id) === st.last) || [...scored].pop(),\n ),\n },\n };\n\n if (isAdmin) {\n out.trivia.questions = qs.map((q) => ({\n ...askCard(q, true),\n src: q.src || \"\",\n answers: teams.map((t) => {\n const a = answerFor(String(q.id), String(t.id));\n return {\n team: t.id,\n text: a?.text || \"\",\n by: a?.by || \"\",\n mark: a?.mark || \"\",\n right: correct(q, a),\n has: !!a,\n score: hasScore(a) ? String(Number(a.score)) : \"\",\n worth: tidy(worth(q, a)),\n };\n }),\n }));\n out.trivia.preview = [...previewers(st)]\n .map((sl) => {\n const g = all.find((x) => x.slug === sl);\n return g ? { slug: sl, name: full(g) } : null;\n })\n .filter(Boolean);\n out.trivia.roster = all\n .filter((g) =>\n (g.lane || \"invited\") === \"invited\" || (g.lane || \"\") === \"prospect\"\n )\n .map((g) => ({ slug: g.slug, name: full(g), lane: g.lane || \"invited\" }));\n out.trivia.unteamed = all\n .filter((g) =>\n (g.lane || \"invited\") === \"invited\" && !String(g.team || \"\")\n )\n .map((g) => ({ slug: g.slug, name: full(g) }));\n }\n return out;\n}\n\n/* ---------- entry point --------------------------------------------------- */\n\nconst HEADERS = {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Headers\": \"*\",\n \"Access-Control-Allow-Methods\": \"POST, GET, OPTIONS\",\n};\n\nconst json = (o: any) => new Response(JSON.stringify(o), { headers: HEADERS });\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") return new Response(null, { headers: HEADERS });\n await init();\n\n if (req.method !== \"POST\") {\n return json({ ok: true, hello: \"confluxcon\", build: BUILD });\n }\n\n let body: any = {};\n try {\n body = JSON.parse(await req.text() || \"{}\");\n } catch {\n return json({ ok: false, error: \"bad_json\" });\n }\n\n let all = await guests();\n\n /* Seeding. Open only while the table is empty; after that it takes the admin\n password and an explicit force, because it drops everything. */\n if (body.action === \"seed\") {\n const data = body.data || {};\n if (!data.guests?.length) return json({ ok: false, error: \"no_guests\" });\n if (all.length) {\n const who = byPassword(all, body.password);\n if (!who || !isYes(who.admin) || body.force !== true) {\n return json({ ok: false, error: \"already_seeded\" });\n }\n }\n await sqlite.execute(`DELETE FROM ${G}`);\n await sqlite.execute(`DELETE FROM ${S}`);\n for (const [i, g] of data.guests.entries()) {\n await sqlite.execute({\n sql:\n `INSERT INTO ${G} (ord,slug,first,last,password,admin,met,org,lane,tier,\n going,prob,arrive,link,run,sessions,namevote,note,msg,pay,seen,updated)\n VALUES (?,?,?,?,?,?,?,?,?,?,'','','',?,'','{}','','','','','','')`,\n args: [\n i + 1,\n g.slug,\n g.first,\n g.last,\n g.password,\n g.admin ? \"yes\" : \"\",\n g.met || \"\",\n g.org || \"\",\n g.lane || \"invited\",\n String(g.tier ?? \"\"),\n g.link || \"\",\n ],\n });\n }\n for (const n of (data.sessions || [])) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO ${S} (name,by,host) VALUES (?,'','')`,\n args: [n],\n });\n }\n return json({\n ok: true,\n seeded: data.guests.length,\n sessions: (data.sessions || []).length,\n });\n }\n\n const me0 = byPassword(all, body.password);\n if (!me0) return json({ ok: false, error: \"bad_password\" });\n const isAdmin = isYes(me0.admin);\n const slug = me0.slug;\n\n const reread = async () => {\n all = await guests();\n return all.find((g) => g.slug === slug);\n };\n\n switch (body.action) {\n case \"auth\":\n await logVisit(full(me0));\n return json(await payload(me0, all, isAdmin));\n\n /* a guest editing their own RSVP */\n case \"save\": {\n const p = body.patch || {};\n const fields: Record = {\n first: clean(p.first, 40),\n last: clean(p.last, 40),\n met: clean(p.met, 60),\n org: clean(p.org, 60),\n arrive: clean(p.arrive, 40),\n link: clean(p.link, 200),\n going: [\"yes\", \"likely\", \"maybe\", \"no\", \"\"].includes(p.going)\n ? p.going\n : me0.going,\n prob: num(p.prob),\n namevote: [\"confluxcon\", \"fluxcon\", \"\"].includes(p.namevote)\n ? p.namevote\n : me0.namevote,\n note: clean(p.note, 140),\n diet: clean(p.diet, 200),\n msg: cleanLines(p.msg, 2000),\n pay: money(p.pay),\n };\n const LABEL: Record = {\n first: \"first name\",\n last: \"last name\",\n met: \"how they know Jacob\",\n org: \"affiliation\",\n arrive: \"arrival\",\n link: \"link\",\n going: \"answer\",\n prob: \"probability\",\n namevote: \"name vote\",\n note: \"public comment\",\n diet: \"dietary restrictions\",\n msg: \"private note\",\n pay: \"willingness to pay\",\n };\n const changed: string[] = [];\n for (const k in fields) {\n if (String(me0[k] ?? \"\") === String(fields[k] ?? \"\")) continue;\n changed.push(\n `${LABEL[k] || k}: ${brief(me0[k])} \\u2192 ${brief(fields[k])}`,\n );\n }\n for (const k in fields) await setField(slug, k, fields[k]);\n if (p.sessions) {\n const was = parseSessions(me0.sessions);\n for (\n const k of new Set([...Object.keys(was), ...Object.keys(p.sessions)])\n ) {\n if (String(was[k] || \"\") === String(p.sessions[k] || \"\")) continue;\n changed.push(\n `${brief(k)}: ${brief(was[k])} \\u2192 ${brief(p.sessions[k])}`,\n );\n }\n await setField(\n slug,\n \"sessions\",\n JSON.stringify(p.sessions).slice(0, 4000),\n );\n }\n await log(full(me0), changed.join(\"; \"));\n await setField(slug, \"seen\", \"yes\");\n const now = new Date().toISOString();\n /* Stamped only as an answer first appears — going from nothing to\n something — never when an existing one is edited. Everyone who\n answered before the column existed stays unstamped for good, which is\n what keeps them in the console's order instead of leaping to the end\n the next time they touch their RSVP. */\n if (\n fields.going && !String(me0.going || \"\") && !String(me0.rsvped || \"\")\n ) {\n await setField(slug, \"rsvped\", now);\n }\n await setField(slug, \"updated\", now);\n const me = await reread();\n return json(await payload(me, all, isAdmin));\n }\n\n /* proposing a session — it joins the one shared list */\n case \"addSession\": {\n const name = clean(body.name, 60);\n if (!name) return json({ ok: false, error: \"no_name\" });\n const existing = await sessions();\n if (\n !existing.some((s) =>\n String(s.name).toLowerCase() === name.toLowerCase()\n )\n ) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO ${S} (name,by,host,descr,sched) VALUES (?,?,?,?,?)`,\n args: [\n name,\n me0.first,\n body.host ? \"yes\" : \"\",\n cleanLines(body.descr, 600),\n cleanLines(body.sched, 600),\n ],\n });\n await log(\n full(me0),\n `added the activity \\u201c${name}\\u201d${\n body.host ? \", and will run it\" : \"\"\n }`,\n );\n }\n return json(await payload(me0, all, isAdmin));\n }\n\n /* the blurb and the scheduling notes, after the fact */\n case \"editSession\": {\n const target = clean(body.name, 60).toLowerCase();\n const list = await sessions();\n const row = list.find((s) => String(s.name).toLowerCase() === target);\n if (!row) return json({ ok: false, error: \"no_session\" });\n const owns = isAdmin ||\n (!!row.by && String(row.by) === String(me0.first));\n if (!owns) return json({ ok: false, error: \"not_yours\" });\n for (const col of [\"descr\", \"sched\"]) {\n if (!(col in body)) continue;\n const value = cleanLines(body[col], 600);\n if (value === String(row[col] || \"\")) continue;\n await sqlite.execute({\n sql: `UPDATE ${S} SET ${col} = ? WHERE name = ?`,\n args: [value, row.name],\n });\n await log(\n full(me0),\n `${col === \"descr\" ? \"description\" : \"scheduling notes\"} for ` +\n `\\u201c${row.name}\\u201d: ${brief(row[col])} \\u2192 ${\n brief(value)\n }`,\n );\n }\n return json(await payload(me0, all, isAdmin));\n }\n\n case \"dropSession\": {\n const target = clean(body.name, 60).toLowerCase();\n const list = await sessions();\n const row = list.find((s) => String(s.name).toLowerCase() === target);\n if (row && (String(row.by || \"\") === String(me0.first) || isAdmin)) {\n await sqlite.execute({\n sql: `DELETE FROM ${S} WHERE name = ?`,\n args: [row.name],\n });\n await log(full(me0), `removed the activity \\u201c${row.name}\\u201d`);\n }\n return json(await payload(me0, all, isAdmin));\n }\n\n /* everything below here is Jacob only */\n case \"admin\": {\n if (!isAdmin) return json({ ok: false, error: \"not_admin\" });\n\n if (body.op === \"set\") {\n const g = all.find((x) => x.slug === body.slug);\n if (!g) return json({ ok: false, error: \"no_guest\" });\n let field = body.field === \"pw\" ? \"password\" : body.field;\n const allowed = [\n \"first\",\n \"last\",\n \"password\",\n \"met\",\n \"org\",\n \"lane\",\n \"tier\",\n \"going\",\n \"prob\",\n \"arrive\",\n \"link\",\n \"run\",\n \"namevote\",\n \"note\",\n \"msg\",\n \"pay\",\n ];\n if (!allowed.includes(field)) {\n return json({ ok: false, error: \"bad_field\" });\n }\n\n // A password names a person, so two guests may never share one.\n if (field === \"password\") {\n const want = clean(body.value, 60).toLowerCase();\n if (!want) return json({ ok: false, error: \"password_empty\" });\n if (\n all.some((x) =>\n x.slug !== g.slug &&\n String(x.password || \"\").trim().toLowerCase() === want\n )\n ) {\n return json({ ok: false, error: \"password_taken\" });\n }\n }\n // The console edits the long fields in a wrapping box now, so a note to\n // the host must not be flattened to one 200-character line on the way in.\n const value = field === \"prob\"\n ? num(body.value)\n : field === \"msg\"\n ? cleanLines(body.value, 2000)\n : clean(body.value, 200);\n if (value !== String(g[field] ?? \"\")) {\n await setField(g.slug, field, value);\n await log(\n full(me0),\n `set ${field} for ${full(g)}: ${brief(g[field])} \\u2192 ${\n brief(value)\n }`,\n );\n }\n }\n\n if (body.op === \"add\") {\n const nm = clean(body.name, 80);\n if (!nm) return json({ ok: false, error: \"no_name\" });\n const parts = nm.split(/\\s+/);\n const taken = new Set(all.map((x) => x.slug));\n const pwTaken = new Set(\n all.map((x) => String(x.password).toLowerCase()),\n );\n const maxOrder = all.reduce(\n (m, x) => Math.max(m, Number(x.ord) || 0),\n 0,\n );\n let s = parts[0].toLowerCase().replace(/[^a-z]/g, \"\");\n if (taken.has(s)) s = nm.toLowerCase().replace(/[^a-z]+/g, \"\");\n let n = 2;\n while (taken.has(s)) {\n s = parts[0].toLowerCase().replace(/[^a-z]/g, \"\") + n++;\n }\n const pw = WORDS.find((w) => !pwTaken.has(w)) ||\n \"spare\" + (all.length + 1);\n await sqlite.execute({\n sql:\n `INSERT INTO ${G} (ord,slug,first,last,password,admin,met,org,lane,tier,\n going,prob,arrive,link,run,sessions,namevote,note,msg,pay,seen,updated)\n VALUES (?,?,?,?,?,'',?,?,'prospect',?,'','','','','','{}','','','','','','')`,\n args: [\n maxOrder + 1,\n s,\n parts[0],\n parts.slice(1).join(\" \"),\n pw,\n clean(body.met, 60),\n clean(body.org, 60),\n clean(body.tier, 4),\n ],\n });\n await log(full(me0), `added ${nm} to the maybe pile`);\n }\n\n if (body.op === \"remove\") {\n const g = all.find((x) => x.slug === body.slug);\n if (!g) return json({ ok: false, error: \"no_guest\" });\n if (g.slug === slug) {\n return json({ ok: false, error: \"cannot_remove_self\" });\n }\n if (isYes(g.admin)) {\n return json({ ok: false, error: \"cannot_remove_admin\" });\n }\n await sqlite.execute({\n sql: `DELETE FROM ${G} WHERE slug = ?`,\n args: [g.slug],\n });\n await log(full(me0), `removed ${full(g)} from the list`);\n }\n\n if (body.op === \"move\") {\n const lane = all.filter((x) => (x.lane || \"invited\") === body.lane)\n .sort((a, b) => (Number(a.ord) || 0) - (Number(b.ord) || 0));\n const at = lane.findIndex((x) => x.slug === body.slug);\n const to = body.dir === \"up\" ? at - 1 : at + 1;\n if (at >= 0 && to >= 0 && to < lane.length) {\n const a = lane[at], b = lane[to];\n await setField(a.slug, \"ord\", Number(b.ord) || 0);\n await setField(b.slug, \"ord\", Number(a.ord) || 0);\n await log(\n full(me0),\n `moved ${full(a)} ${body.dir === \"up\" ? \"up\" : \"down\"} the list`,\n );\n }\n }\n\n const me = await reread();\n return json(await payload(me, all, isAdmin));\n }\n\n /* ---------- trivia, for everyone signed in ---------- */\n\n case \"trivia\":\n return json(await triviaPayload(me0, isAdmin));\n\n /* forming teams: start one and name it, or join one that exists */\n case \"triviaTeam\": {\n const st = await tstate();\n if (st.phase === \"off\" && !isAdmin) {\n return json({ ok: false, error: \"not_open\" });\n }\n const list = await teamsAll();\n const op = body.op;\n\n if (op === \"create\") {\n const name = clean(body.name, 40);\n if (!name) return json({ ok: false, error: \"no_name\" });\n if (list.some((t) => tnorm(t.name) === tnorm(name))) {\n return json({ ok: false, error: \"name_taken\" });\n }\n if (list.length >= 20) {\n return json({ ok: false, error: \"too_many_teams\" });\n }\n const id = newId(\"t\");\n await sqlite.execute({\n sql:\n `INSERT INTO ${TT} (id, name, captain, created) VALUES (?, ?, ?, ?)`,\n args: [id, name, slug, new Date().toISOString()],\n });\n await setField(slug, \"team\", id);\n await log(full(me0), `started the trivia team “${name}”`);\n }\n\n if (op === \"join\") {\n const t = list.find((x) => String(x.id) === String(body.id));\n if (!t) return json({ ok: false, error: \"no_team\" });\n await setField(slug, \"team\", t.id);\n await log(full(me0), `joined the trivia team “${t.name}”`);\n }\n\n if (op === \"leave\") {\n const t = list.find((x) => String(x.id) === String(me0.team || \"\"));\n await setField(slug, \"team\", \"\");\n if (t) await log(full(me0), `left the trivia team “${t.name}”`);\n }\n\n /* The captain owns the name. The host can fix any of them. */\n if (op === \"rename\") {\n const t = list.find((x) =>\n String(x.id) === String(body.id || me0.team || \"\")\n );\n if (!t) return json({ ok: false, error: \"no_team\" });\n if (!isAdmin && String(t.captain) !== slug) {\n return json({ ok: false, error: \"not_captain\" });\n }\n const name = clean(body.name, 40);\n if (!name) return json({ ok: false, error: \"no_name\" });\n if (list.some((x) => x.id !== t.id && tnorm(x.name) === tnorm(name))) {\n return json({ ok: false, error: \"name_taken\" });\n }\n await sqlite.execute({\n sql: `UPDATE ${TT} SET name = ? WHERE id = ?`,\n args: [name, t.id],\n });\n await log(\n full(me0),\n `renamed a trivia team: ${brief(t.name)} → ${brief(name)}`,\n );\n }\n\n const me = await reread();\n return json(await triviaPayload(me, isAdmin));\n }\n\n /* one answer per team — whoever types last speaks for the team */\n case \"triviaAnswer\": {\n const st = await tstate();\n if (st.phase !== \"play\") return json({ ok: false, error: \"not_playing\" });\n const team = String(me0.team || \"\");\n if (!team) return json({ ok: false, error: \"no_team\" });\n const qs = await questAll();\n const q = qs.find((x) => String(x.id) === String(body.qid));\n if (!q) return json({ ok: false, error: \"no_question\" });\n if (q.state !== \"open\" || String(q.id) !== st.active) {\n return json({ ok: false, error: \"closed\" });\n }\n const text = clean(body.text, 200);\n const id = `${q.id}::${team}`;\n await sqlite.execute({\n sql: `INSERT INTO ${TA} (id, qid, team, text, by, at, mark)\n VALUES (?, ?, ?, ?, ?, ?, '')\n ON CONFLICT(id) DO UPDATE SET text = excluded.text, by = excluded.by,\n at = excluded.at, mark = ''`,\n args: [id, q.id, team, text, full(me0), new Date().toISOString()],\n });\n const t = (await teamsAll()).find((x) => String(x.id) === team);\n await log(\n full(me0),\n `answered for ${brief(t?.name || \"a team\")}: ${brief(text)}`,\n );\n return json(await triviaPayload(me0, isAdmin));\n }\n\n /* ---------- trivia, host only ---------- */\n case \"triviaAdmin\": {\n if (!isAdmin) return json({ ok: false, error: \"not_admin\" });\n const op = String(body.op || \"\");\n /* An op this file has never heard of used to fall through every branch\n below and return a cheerful, empty success — which is exactly what an\n older copy of this file pasted into the val does when the page asks it\n for something new. Say so instead. */\n const OPS = [\n \"phase\",\n \"visible\",\n \"title\",\n \"preview\",\n \"roundName\",\n \"roundAdd\",\n \"roundDrop\",\n \"qAdd\",\n \"qBulk\",\n \"qSet\",\n \"qDrop\",\n \"qMove\",\n \"ask\",\n \"close\",\n \"reopen\",\n \"mark\",\n \"score\",\n \"teamDrop\",\n \"put\",\n \"import\",\n \"clearAnswers\",\n ];\n if (!OPS.includes(op)) {\n return json({ ok: false, error: \"unknown_op\", op, build: BUILD });\n }\n\n /* how far along the evening is, and whether guests can see any of it */\n if (op === \"phase\") {\n const v = [\"off\", \"teams\", \"play\", \"done\"].includes(body.value)\n ? body.value\n : \"off\";\n await tset(\"phase\", v);\n await log(full(me0), `trivia phase → ${v}`);\n }\n if (op === \"visible\") {\n await tset(\"visible\", body.value ? \"yes\" : \"\");\n await log(\n full(me0),\n `trivia is ${body.value ? \"visible to guests\" : \"hidden again\"}`,\n );\n }\n if (op === \"title\") {\n await tset(\"title\", clean(body.value, 60) || \"AI safety trivia\");\n }\n\n /* Letting one account in early, to walk through it as a guest would\n while the tab stays hidden from everybody else. */\n if (op === \"preview\") {\n const st = await tstate();\n const set = previewers(st);\n const who = clean(body.slug, 40);\n const g = all.find((x) => x.slug === who);\n if (!g) return json({ ok: false, error: \"no_guest\" });\n if (body.on) set.add(who);\n else set.delete(who);\n await tset(\"preview\", [...set].join(\",\"));\n await log(\n full(me0),\n `${body.on ? \"gave\" : \"took\"} ${full(g)} ` +\n `${body.on ? \"an early look at\" : \"off\"} the trivia tab`,\n );\n }\n\n /* rounds are numbered; only the name is stored */\n if (op === \"roundName\") {\n const n = Math.max(1, Math.min(99, Math.round(Number(body.n) || 1)));\n await tset(\"rnd:\" + n, clean(body.value, 60));\n }\n if (op === \"roundAdd\") {\n const st = await tstate();\n const qs = await questAll();\n const next = roundsOf(st, qs).reduce((m, r) => Math.max(m, r.n), 0) + 1;\n await tset(\"rnd:\" + next, clean(body.name, 60) || `Round ${next}`);\n }\n if (op === \"roundDrop\") {\n const n = Math.round(Number(body.n) || 0);\n const doomed = (await questAll()).filter((q) =>\n (Number(q.rnd) || 1) === n\n );\n for (const q of doomed) {\n await sqlite.execute({\n sql: `DELETE FROM ${TA} WHERE qid = ?`,\n args: [q.id],\n });\n }\n await sqlite.execute({\n sql: `DELETE FROM ${TQ} WHERE rnd = ?`,\n args: [n],\n });\n await sqlite.execute({\n sql: `DELETE FROM ${T} WHERE k = ?`,\n args: [\"rnd:\" + n],\n });\n await log(\n full(me0),\n `dropped trivia round ${n} and its ${doomed.length} question(s)`,\n );\n }\n\n /* the editor */\n if (op === \"qAdd\" || op === \"qBulk\") {\n const rnd = Math.max(1, Math.round(Number(body.rnd) || 1));\n const qs = await questAll();\n let ord = qs.filter((q) => (Number(q.rnd) || 1) === rnd)\n .reduce((m, q) => Math.max(m, Number(q.ord) || 0), 0);\n /* Bulk entry: one question per line, \"prompt | answer | also accepted\". */\n const lines = op === \"qBulk\"\n ? String(body.text || \"\").split(\"\\n\").map((l: string) => l.trim())\n .filter(Boolean)\n : [null];\n let n = 0;\n for (const line of lines) {\n const parts = line === null\n ? null\n : line.split(\"|\").map((x: string) => x.trim());\n const prompt = clean(parts ? parts[0] : body.prompt, 400);\n if (!prompt) continue;\n const answer = cleanLines(\n parts ? parts.slice(1).join(\"\\n\") : body.answer,\n 400,\n );\n await sqlite.execute({\n sql:\n `INSERT INTO ${TQ} (id, rnd, ord, prompt, answer, points, state, note)\n VALUES (?, ?, ?, ?, ?, ?, 'todo', ?)`,\n args: [\n newId(\"q\"),\n rnd,\n ++ord,\n prompt,\n answer,\n String(points({ points: parts ? 1 : body.points })),\n clean(body.note, 300),\n ],\n });\n n++;\n }\n await log(\n full(me0),\n `added ${n} trivia question${n === 1 ? \"\" : \"s\"} to round ${rnd}`,\n );\n }\n\n if (op === \"qSet\") {\n const field = String(body.field || \"\");\n if (\n ![\"prompt\", \"answer\", \"points\", \"note\", \"rnd\", \"src\"].includes(field)\n ) {\n return json({ ok: false, error: \"bad_field\" });\n }\n const value = field === \"answer\" || field === \"prompt\"\n ? cleanLines(body.value, 400)\n : field === \"points\"\n ? String(points({ points: body.value }))\n : field === \"rnd\"\n ? String(Math.max(1, Math.round(Number(body.value) || 1)))\n : clean(body.value, 300);\n await sqlite.execute({\n sql: `UPDATE ${TQ} SET ${field} = ? WHERE id = ?`,\n args: [value, body.id],\n });\n }\n\n if (op === \"qDrop\") {\n await sqlite.execute({\n sql: `DELETE FROM ${TA} WHERE qid = ?`,\n args: [body.id],\n });\n await sqlite.execute({\n sql: `DELETE FROM ${TQ} WHERE id = ?`,\n args: [body.id],\n });\n const st = await tstate();\n if (st.active === String(body.id)) await tset(\"active\", \"\");\n await log(full(me0), `deleted a trivia question`);\n }\n\n if (op === \"qMove\") {\n const qs = await questAll();\n const q = qs.find((x) => String(x.id) === String(body.id));\n if (q) {\n const lane = qs.filter((x) =>\n (Number(x.rnd) || 1) === (Number(q.rnd) || 1)\n );\n const at = lane.findIndex((x) => x.id === q.id);\n const to = body.dir === \"up\" ? at - 1 : at + 1;\n if (to >= 0 && to < lane.length) {\n const b = lane[to];\n await sqlite.execute({\n sql: `UPDATE ${TQ} SET ord = ? WHERE id = ?`,\n args: [Number(b.ord) || 0, q.id],\n });\n await sqlite.execute({\n sql: `UPDATE ${TQ} SET ord = ? WHERE id = ?`,\n args: [Number(q.ord) || 0, b.id],\n });\n }\n }\n }\n\n /* running it: ask one, close it, and closing is what scores it */\n if (op === \"ask\") {\n const qs = await questAll();\n const q = qs.find((x) => String(x.id) === String(body.id));\n if (!q) return json({ ok: false, error: \"no_question\" });\n /* args is not optional in the object form — Val Town rejects the\n statement outright without it. Pass a bare string or pass args. */\n await sqlite.execute(\n `UPDATE ${TQ} SET state = 'todo' WHERE state = 'open'`,\n );\n await sqlite.execute({\n sql: `UPDATE ${TQ} SET state = 'open' WHERE id = ?`,\n args: [q.id],\n });\n await tset(\"active\", String(q.id));\n await tset(\"phase\", \"play\");\n await log(full(me0), `asked: ${brief(q.prompt)}`);\n }\n if (op === \"close\") {\n const qs = await questAll();\n const q = qs.find((x) => String(x.id) === String(body.id));\n if (!q) return json({ ok: false, error: \"no_question\" });\n await sqlite.execute({\n sql: `UPDATE ${TQ} SET state = 'done' WHERE id = ?`,\n args: [q.id],\n });\n const st = await tstate();\n if (st.active === String(q.id)) await tset(\"active\", \"\");\n await tset(\"last\", String(q.id));\n await log(full(me0), `closed: ${brief(q.prompt)}`);\n }\n /* Back to unasked — the points come off the board with it. */\n if (op === \"reopen\") {\n await sqlite.execute({\n sql: `UPDATE ${TQ} SET state = 'todo' WHERE id = ?`,\n args: [body.id],\n });\n const st = await tstate();\n if (st.active === String(body.id)) await tset(\"active\", \"\");\n }\n\n /* the host's last word on any answer */\n if (op === \"mark\") {\n const value = [\"yes\", \"no\", \"\"].includes(body.value) ? body.value : \"\";\n const id = `${body.qid}::${body.team}`;\n await sqlite.execute({\n sql: `INSERT INTO ${TA} (id, qid, team, text, by, at, mark, score)\n VALUES (?, ?, ?, '', '', ?, ?, '')\n ON CONFLICT(id) DO UPDATE SET mark = excluded.mark, score = ''`,\n args: [id, body.qid, body.team, new Date().toISOString(), value],\n });\n await log(\n full(me0),\n `marked an answer ${\n value === \"yes\"\n ? \"right\"\n : value === \"no\"\n ? \"wrong\"\n : \"back to auto\"\n }`,\n );\n }\n\n /* Typing a number wins over both the key and the tick. */\n if (op === \"score\") {\n const raw = String(body.value ?? \"\").trim();\n const n = Number(raw);\n const value = raw === \"\" || isNaN(n)\n ? \"\"\n : String(Math.max(-99, Math.min(99, n)));\n const id = `${body.qid}::${body.team}`;\n await sqlite.execute({\n sql: `INSERT INTO ${TA} (id, qid, team, text, by, at, mark, score)\n VALUES (?, ?, ?, '', '', ?, '', ?)\n ON CONFLICT(id) DO UPDATE SET score = excluded.score, mark = ''`,\n args: [id, body.qid, body.team, new Date().toISOString(), value],\n });\n await log(\n full(me0),\n value === \"\"\n ? `put an answer back to automatic`\n : `scored an answer ${value}`,\n );\n }\n\n if (op === \"teamDrop\") {\n const t = (await teamsAll()).find((x) =>\n String(x.id) === String(body.id)\n );\n if (t) {\n for (\n const g of all.filter((g) => String(g.team || \"\") === String(t.id))\n ) {\n await setField(g.slug, \"team\", \"\");\n }\n await sqlite.execute({\n sql: `DELETE FROM ${TA} WHERE team = ?`,\n args: [t.id],\n });\n await sqlite.execute({\n sql: `DELETE FROM ${TT} WHERE id = ?`,\n args: [t.id],\n });\n await log(full(me0), `disbanded the trivia team “${t.name}”`);\n }\n }\n /* Moving someone by hand, for whoever never got round to picking. */\n if (op === \"put\") {\n const g = all.find((x) => x.slug === String(body.slug));\n if (!g) return json({ ok: false, error: \"no_guest\" });\n await setField(g.slug, \"team\", clean(body.team, 40));\n await log(full(me0), `put ${full(g)} on a trivia team`);\n }\n\n /* The whole set in one go, from build.py — the answers stay out of the\n repo, so they arrive over the wire instead. Refuses to run over a game\n already in progress unless told twice. */\n if (op === \"import\") {\n const qsNow = await questAll();\n const ansNow = await answAll();\n if ((qsNow.length || ansNow.length) && body.force !== true) {\n return json({\n ok: false,\n error: \"already_loaded\",\n questions: qsNow.length,\n answers: ansNow.length,\n });\n }\n await sqlite.execute(`DELETE FROM ${TA}`);\n await sqlite.execute(`DELETE FROM ${TQ}`);\n for (const k of Object.keys(await tstate())) {\n if (/^rnd:\\d+$/.test(k)) {\n await sqlite.execute({\n sql: `DELETE FROM ${T} WHERE k = ?`,\n args: [k],\n });\n }\n }\n await tset(\"active\", \"\");\n await tset(\"last\", \"\");\n for (const r of (body.rounds || [])) {\n await tset(\n \"rnd:\" + Math.max(1, Math.round(Number(r.n) || 1)),\n clean(r.name, 60),\n );\n }\n const ords: Record = {};\n let n = 0;\n for (const q of (body.questions || [])) {\n const rnd = Math.max(1, Math.round(Number(q.rnd) || 1));\n const prompt = cleanLines(q.prompt, 400);\n if (!prompt) continue;\n ords[rnd] = (ords[rnd] || 0) + 1;\n await sqlite.execute({\n sql:\n `INSERT INTO ${TQ} (id, rnd, ord, prompt, answer, points, state, note, src)\n VALUES (?, ?, ?, ?, ?, ?, 'todo', ?, ?)`,\n args: [\n newId(\"q\"),\n rnd,\n ords[rnd],\n prompt,\n cleanLines(q.answer, 400),\n String(points(q)),\n cleanLines(q.note, 400),\n clean(q.src, 20),\n ],\n });\n n++;\n }\n await log(full(me0), `loaded ${n} trivia questions`);\n const me2 = await reread();\n return json({ ...(await triviaPayload(me2, isAdmin)), loaded: n });\n }\n\n /* Wipes every typed answer but keeps the questions, for a second run. */\n if (op === \"clearAnswers\") {\n await sqlite.execute(`DELETE FROM ${TA}`);\n await sqlite.execute(`UPDATE ${TQ} SET state = 'todo'`);\n await tset(\"active\", \"\");\n await log(full(me0), `cleared every trivia answer`);\n }\n\n const me = await reread();\n return json(await triviaPayload(me, isAdmin));\n }\n\n /* what everyone has been doing — the console's live log */\n case \"log\": {\n if (!isAdmin) return json({ ok: false, error: \"not_admin\" });\n const res = await sqlite.execute(\n `SELECT id, at, who, what FROM ${L} ORDER BY id DESC LIMIT 200`,\n );\n return json({ ok: true, log: objs(res) });\n }\n }\n\n return json({ ok: false, error: \"unknown_action\" });\n}","deleted",false,"label",[14],"abc058ff-5274-489b-bdf8-c89a64220eee",["D",1788404870127],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","432168e9-61f0-48c7-837a-1d1b852d7edb","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a06537-b182-70ec-a8a7-a330bdc9abac","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_101":97},"org",{"_9":10,"_94":95,"_96":97,"_55":56,"_98":99,"_100":42},"branch",{"_35":30,"_11":85,"_22":28,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":12,"_93":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Jacob Cohen","avatar","https://avatars.githubusercontent.com/u/130943810?v=4","tier","free","canRestrictVals","profileImageUrl","ctx",{"_78":-5,"_135":136,"_137":138,"_139":140,"_141":42,"_142":42,"_143":42,"_144":32,"_145":-5,"_146":-7,"_147":-7,"_148":62,"_149":42,"_150":42,"_151":-5,"_152":42,"_153":42,"_154":42,"_155":-5},"ENV",{"_106":107,"_108":109,"_110":85,"_111":112,"_113":114,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]