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}","label",[64],"pulls","branches","forks","envVars",{"_199":40,"_201":20},"connections",{"_199":20,"_200":20},"count","unfilledCount","emptyCount",{"_33":185,"_13":64,"_62":63,"_43":-5,"_35":36,"_186":109,"_187":179,"_37":203,"_39":102,"_65":85,"_14":189,"_67":24,"_190":-5,"_204":205,"_162":206},["D",1781977599176],"children",[],[64],["D",1781910075952],{"_11":12,"_161":70},{"_11":12,"_156":157,"_69":70,"_25":68,"_158":159,"_160":24},{"_39":109,"_13":16,"_33":36,"_148":114,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":14,"_155":12},"ctx",{"_51":-5,"_181":244,"_245":246,"_247":248,"_249":24,"_250":24,"_251":24,"_252":179,"_253":-5,"_254":-7,"_255":-7,"_256":20,"_257":24,"_258":24,"_259":-5,"_260":24,"_261":24,"_262":24,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":16,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"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"]

History