[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":52,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","dominod10462","name","content","branchName","main","version","path","","project",{"_33":60,"_13":14,"_45":61,"_62":-5,"_63":52,"_64":65,"_66":65,"_67":19,"_68":-5,"_69":70,"_71":-5,"_72":52,"_73":-5,"_74":-5,"_75":76,"_77":78,"_79":-5,"_80":-5,"_81":-5,"_82":-5,"_83":84,"_85":84,"_86":87,"_88":87,"_89":87,"_90":84,"_91":84,"_92":93,"_94":95,"_96":97,"_98":52},"tree",[55],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_14":50,"_51":52,"_53":-5,"_18":54},"id","e5a5747d-3f10-4818-80ae-4915107314c0","main.ts","fileId","c68606fc-6c32-11f1-8a6d-1607ee4eb77e","parentId","branchId","81e4b803-d670-4946-8ed7-9a1fb1c399f5","branchVersion",7,"latest",true,"createdAt",["D",1781977599176],6,"fileType","http","// ============================================================\n// In Other Words — Content Store (Val.town HTTP val + SQLite)\n// ============================================================\n// Curated public-domain passages + Reading Room plays + feedback.\n// ------------------------------------------------------------\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nconst TABLE = \"iow_passages_v1\";\nconst FEEDBACK = \"iow_feedback_v1\";\nconst PLAYS = \"iow_plays_v1\";\nconst BLOCK = new Set([\n \"ASS\",\n \"FAG\",\n \"FUK\",\n \"FUC\",\n \"FCK\",\n \"CUM\",\n \"CUN\",\n \"CNT\",\n \"NIG\",\n \"SEX\",\n \"TIT\",\n \"TIS\",\n \"DIK\",\n \"DIC\",\n \"COK\",\n \"COC\",\n \"JIZ\",\n \"KKK\",\n \"FU\",\n \"WTF\",\n \"DIE\",\n \"GAS\",\n \"HOE\",\n \"SLT\",\n \"FAP\",\n \"XXX\",\n \"NAZ\",\n]);\nconst CORS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type, X-Admin-Token\",\n};\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id TEXT PRIMARY KEY,\n title TEXT, author TEXT, region TEXT, year TEXT,\n text TEXT, target INTEGER, tier TEXT,\n source TEXT, source_url TEXT, added_at TEXT\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${FEEDBACK} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT, email TEXT, message TEXT, page TEXT, created_at TEXT\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${PLAYS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n initials TEXT, passage_id TEXT, title TEXT, author TEXT, snippet TEXT, score INTEGER, created_at TEXT\n)`);\n\nfunction json(obj: unknown, status = 200): Response {\n return new Response(JSON.stringify(obj), {\n status,\n headers: { ...CORS, \"Content-Type\": \"application/json\" },\n });\n}\nfunction toObjects(res: any): any[] {\n const cols: string[] = res.columns || [];\n return (res.rows || []).map((r: any[]) =>\n Object.fromEntries(cols.map((c, i) => [c, r[i]]))\n );\n}\nasync function allRows(): Promise {\n const res = await sqlite.execute(\n `SELECT id,title,author,region,year,text,target,tier,source,source_url,added_at FROM ${TABLE} ORDER BY added_at DESC`,\n );\n return toObjects(res);\n}\nasync function count(): Promise {\n const res = await sqlite.execute(`SELECT COUNT(*) AS n FROM ${TABLE}`);\n return Number(toObjects(res)[0]?.n || 0);\n}\nfunction esc(s: string): string {\n return String(s ?? \"\").replace(\n /[&<>\"]/g,\n (c) => ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" }[c]!),\n );\n}\nfunction csvCell(s: unknown): string {\n const t = String(s ?? \"\");\n return /[\",\\n]/.test(t) ? '\"' + t.replace(/\"/g, '\"\"') + '\"' : t;\n}\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") return new Response(null, { headers: CORS });\n const url = new URL(req.url);\n const path = url.pathname.replace(/\\/+$/, \"\") || \"/\";\n const ADMIN = Deno.env.get(\"ADMIN_TOKEN\") || \"\";\n\n const PLAY_COLS = \"id,title,author,region,text,target,tier,source_url\";\n\n if (req.method === \"GET\" && (path === \"/\" || path === \"/passages\")) {\n const randomN = parseInt(url.searchParams.get(\"random\") || \"0\", 10);\n if (randomN > 0) {\n const res = await sqlite.execute({\n sql: `SELECT ${PLAY_COLS} FROM ${TABLE} ORDER BY RANDOM() LIMIT ?`,\n args: [randomN],\n });\n return json(toObjects(res));\n }\n const rows = await allRows();\n return json(\n rows.map((r) => ({\n id: r.id,\n title: r.title,\n author: r.author,\n region: r.region,\n text: r.text,\n target: r.target,\n tier: r.tier,\n source_url: r.source_url,\n })),\n );\n }\n\n if (req.method === \"GET\" && path === \"/passage\") {\n const id = url.searchParams.get(\"id\");\n if (!id) return json({ error: \"id required\" }, 400);\n const res = await sqlite.execute({\n sql: `SELECT ${PLAY_COLS} FROM ${TABLE} WHERE id = ?`,\n args: [id],\n });\n const o = toObjects(res)[0];\n return o ? json(o) : json({ error: \"not found\" }, 404);\n }\n\n if (req.method === \"GET\" && path === \"/stats\") {\n const rows = await allRows();\n const by = (key: string) => {\n const m: Record = {};\n for (const r of rows) {\n const k = r[key] || \"(unknown)\";\n m[k] = (m[k] || 0) + 1;\n }\n return m;\n };\n return json({\n total: rows.length,\n byRegion: by(\"region\"),\n byTier: by(\"tier\"),\n byAuthor: by(\"author\"),\n bySource: by(\"source\"),\n });\n }\n\n if (req.method === \"GET\" && path === \"/export.json\") {\n const rows = await allRows();\n return new Response(JSON.stringify(rows, null, 2), {\n headers: {\n ...CORS,\n \"Content-Type\": \"application/json\",\n \"Content-Disposition\":\n 'attachment; filename=\"in-other-words-library.json\"',\n },\n });\n }\n\n if (req.method === \"GET\" && path === \"/export.csv\") {\n const rows = await allRows();\n const cols = [\n \"id\",\n \"title\",\n \"author\",\n \"region\",\n \"year\",\n \"tier\",\n \"target\",\n \"text\",\n \"source\",\n \"source_url\",\n \"added_at\",\n ];\n const lines = [cols.join(\",\")];\n for (const r of rows) lines.push(cols.map((c) => csvCell(r[c])).join(\",\"));\n return new Response(lines.join(\"\\n\"), {\n headers: {\n ...CORS,\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\":\n 'attachment; filename=\"in-other-words-library.csv\"',\n },\n });\n }\n\n if (req.method === \"GET\" && path === \"/catalog\") {\n const rows = await allRows();\n const by = (key: string) => {\n const m: Record = {};\n for (const r of rows) {\n const k = r[key] || \"(unknown)\";\n m[k] = (m[k] || 0) + 1;\n }\n return Object.entries(m).sort((a, b) => b[1] - a[1]);\n };\n const region = by(\"region\"), tier = by(\"tier\");\n const authorsCount = new Set(rows.map((r) => r.author)).size;\n const page =\n `\nIn Other Words — Library\n

In Other Words — Library

${rows.length}

passages

${authorsCount}

distinct authors

${region.length}

regions

Export CSV Export JSON

By region

${\n region.map(([k, n]) => `${esc(k)} · ${n}`)\n .join(\"\")\n }

By tier

${\n tier.map(([k, n]) => `${esc(k)} · ${n}`).join(\n \"\",\n )\n }

All passages (${rows.length})

\n\n${\n rows.map((r) =>\n ``\n ).join(\"\")\n }\n

Title	Author	Region	Excerpt	Source
${esc(r.title)}	${esc(r.author)}	${\n esc(r.region)\n }	${esc((r.text \|\| \"\").slice(0, 90))}…	${\n r.source_url\n ? `link`\n : esc(r.source \|\| \"\")\n }

\n`;\n return new Response(page, {\n headers: { ...CORS, \"Content-Type\": \"text/html\" },\n });\n }\n\n if (req.method === \"POST\" && path === \"/feedback\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return json({ error: \"Invalid JSON\" }, 400);\n }\n const message = String(body?.message ?? \"\").slice(0, 4000).trim();\n if (message.length < 2) return json({ error: \"message required\" }, 400);\n const name = String(body?.name ?? \"\").slice(0, 200).trim();\n const mail = String(body?.email ?? \"\").slice(0, 200).trim();\n const page = String(body?.page ?? \"\").slice(0, 300).trim();\n const when = new Date().toISOString();\n try {\n await sqlite.execute({\n sql:\n `INSERT INTO ${FEEDBACK} (name,email,message,page,created_at) VALUES (?,?,?,?,?)`,\n args: [name, mail, message, page, when],\n });\n } catch { /* still email */ }\n try {\n await email({\n subject: \"In Other Words — feedback\" + (name ? ` from ${name}` : \"\"),\n text: `New feedback from playinotherwords.com\\n\\n${message}\\n\\nName: ${\n name || \"(none)\"\n }\\nReply: ${mail || \"(none)\"}\\nPage: ${page}\\nTime: ${when}`,\n });\n } catch { /* best effort */ }\n return json({ ok: true });\n }\n\n if (req.method === \"GET\" && path === \"/feedback-list\") {\n if (!ADMIN || url.searchParams.get(\"token\") !== ADMIN) {\n return json({ error: \"Unauthorized\" }, 401);\n }\n const res = await sqlite.execute(\n `SELECT id,name,email,message,page,created_at FROM ${FEEDBACK} ORDER BY id DESC`,\n );\n return json(toObjects(res));\n }\n\n if (req.method === \"POST\" && path === \"/play\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return json({ error: \"Invalid JSON\" }, 400);\n }\n const pid = String(body?.passage_id ?? \"\").slice(0, 80).trim();\n const title = String(body?.title ?? \"\").slice(0, 120).trim();\n if (!pid || !title) return json({ error: \"passage required\" }, 400);\n const author = String(body?.author ?? \"\").slice(0, 120).trim();\n const snippet = String(body?.snippet ?? \"\").slice(0, 140).trim();\n let score = Math.round(Number(body?.score));\n if (!Number.isFinite(score)) score = 0;\n score = Math.max(0, Math.min(100, score));\n let initials = String(body?.initials ?? \"\").toUpperCase().replace(\n /[^A-Z]/g,\n \"\",\n ).slice(0, 3);\n if (BLOCK.has(initials)) initials = \"\";\n await sqlite.execute({\n sql:\n `INSERT INTO ${PLAYS} (initials,passage_id,title,author,snippet,score,created_at) VALUES (?,?,?,?,?,?,?)`,\n args: [\n initials,\n pid,\n title,\n author,\n snippet,\n score,\n new Date().toISOString(),\n ],\n });\n return json({ ok: true });\n }\n\n if (req.method === \"GET\" && path === \"/plays\") {\n const lim = Math.min(\n 100,\n Math.max(1, parseInt(url.searchParams.get(\"limit\") || \"50\", 10)),\n );\n const res = await sqlite.execute({\n sql:\n `SELECT id,initials,passage_id,title,author,snippet,score,created_at FROM ${PLAYS} ORDER BY id DESC LIMIT ?`,\n args: [lim],\n });\n return json(toObjects(res));\n }\n\n if (req.method === \"POST\" && path === \"/play-remove\") {\n if (!ADMIN || req.headers.get(\"X-Admin-Token\") !== ADMIN) {\n return json({ error: \"Unauthorized\" }, 401);\n }\n const id = url.searchParams.get(\"id\");\n if (!id) return json({ error: \"id required\" }, 400);\n await sqlite.execute({\n sql: `DELETE FROM ${PLAYS} WHERE id = ?`,\n args: [id],\n });\n return json({ removed: id });\n }\n\n if (req.method === \"POST\" && path === \"/add\") {\n if (!ADMIN || req.headers.get(\"X-Admin-Token\") !== ADMIN) {\n return json({ error: \"Unauthorized\" }, 401);\n }\n let body: any;\n try {\n body = await req.json();\n } catch {\n return json({ error: \"Invalid JSON\" }, 400);\n }\n const items: any[] = Array.isArray(body)\n ? body\n : (Array.isArray(body?.items) ? body.items : [body]);\n let added = 0, skipped = 0;\n for (const it of items) {\n if (!it || !it.text || !it.title || !it.id) {\n skipped++;\n continue;\n }\n try {\n const r = await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO ${TABLE} (id,title,author,region,year,text,target,tier,source,source_url,added_at) VALUES (?,?,?,?,?,?,?,?,?,?,?)`,\n args: [\n it.id,\n it.title,\n it.author || \"\",\n it.region || \"Other\",\n String(it.year || \"\"),\n it.text,\n Number(\n it.target ||\n Math.max(\n 40,\n Math.round(it.text.replace(/\\s+/g, \" \").trim().length * 0.4),\n ),\n ),\n it.tier || \"Editor\",\n it.source || \"\",\n it.source_url || \"\",\n new Date().toISOString(),\n ],\n });\n if ((r as any).rowsAffected ? (r as any).rowsAffected > 0 : true) {\n added++;\n } else skipped++;\n } catch {\n skipped++;\n }\n }\n return json({ added, skipped, total: await count() });\n }\n\n if (req.method === \"POST\" && path === \"/remove\") {\n if (!ADMIN || req.headers.get(\"X-Admin-Token\") !== ADMIN) {\n return json({ error: \"Unauthorized\" }, 401);\n }\n const id = url.searchParams.get(\"id\");\n if (!id) return json({ error: \"id required\" }, 400);\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE} WHERE id = ?`,\n args: [id],\n });\n return json({ removed: id, total: await count() });\n }\n\n if (req.method === \"POST\" && path === \"/wipe\") {\n if (!ADMIN || req.headers.get(\"X-Admin-Token\") !== ADMIN) {\n return json({ error: \"Unauthorized\" }, 401);\n }\n if (url.searchParams.get(\"all\") === \"1\") {\n await sqlite.execute(`DELETE FROM ${TABLE}`);\n } else {\n const prefix = (url.searchParams.get(\"source\") || \"gb\") + \"-%\";\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE} WHERE id LIKE ?`,\n args: [prefix],\n });\n }\n return json({ wiped: true, total: await count() });\n }\n\n return json({\n error: \"Not found\",\n paths: [\n \"/passages\",\n \"/stats\",\n \"/catalog\",\n \"/feedback\",\n \"/play\",\n \"/plays\",\n \"/add\",\n \"/remove\",\n \"/wipe\",\n ],\n }, 404);\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":56,"_17":47,"_48":49,"_14":50,"_51":52,"_53":-5,"_57":58,"_18":59},["D",1781977599176],"children",[],[35],"b1696bb9-5d73-4235-9499-6fbc7cc0bd5b",["D",1781910075952],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","a58661b5-2c61-4cd7-8e13-28914b1114ce","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ed42c-83b9-71f3-ab21-0df0b7c40414","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":110},"org",{"_11":12,"_107":108,"_109":110,"_69":70,"_111":112,"_113":52},"branch",{"_17":42,"_13":16,"_33":40,"_99":60,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":14,"_106":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Malik Ducard","avatar","https://lh3.googleusercontent.com/a/ACg8ocItvou6DeBgsc17TMlT-ZKWGuYbbXAMf5IMeKd22qu2Sidx1ulwJQ=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":60,"_13":14,"_45":148,"_62":-5,"_63":52,"_64":65,"_66":65,"_67":19,"_68":-5,"_69":70,"_71":-5,"_72":52,"_73":-5,"_74":-5,"_75":76,"_77":78,"_79":-5,"_80":-5,"_81":-5,"_82":-5,"_83":84,"_85":84,"_86":87,"_88":87,"_89":87,"_90":84,"_91":84,"_92":149,"_94":150,"_96":151,"_98":52},[145],"files",[145],"counts",{"_135":76,"_136":137,"_138":76,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_14":50,"_51":52,"_53":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":137,"_144":76},"connections",{"_142":76,"_143":76},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":56,"_17":47,"_48":49,"_14":50,"_51":52,"_53":-5,"_57":146,"_18":147},[],[35],["D",1781910075952],{"_11":12,"_114":110},{"_11":12,"_107":108,"_109":110,"_69":70,"_111":112,"_113":52},{"_17":42,"_13":16,"_33":40,"_99":60,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":14,"_106":12},"ctx",{"_92":-5,"_130":185,"_186":187,"_188":189,"_190":52,"_191":52,"_192":52,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":76,"_198":52,"_199":52,"_200":-5,"_201":52,"_202":52,"_203":52,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Code