[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_94":93,"_32":35,"_103":84,"_27":52,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":120,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":35,"_38":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","c68606fc-6c32-11f1-8a6d-1607ee4eb77e","name","fileType","http","content","// ============================================================\n// In Other Words — Content Store (Val.town HTTP val + SQLite)\n// ============================================================\n// Holds curated public-domain passages, serves them to the game,\n// and provides stats, a catalog page, and exports. Curation (the\n// cron that fetches & extracts new passages) is a SEPARATE val that\n// POSTs to /add here — kept apart so this store stays simple & stable.\n//\n// SETUP:\n// 1. val.town -> New -> HTTP val -> paste this file.\n// 2. Add an Environment Variable / Secret named ADMIN_TOKEN (any random\n// string). The curation val and the \"remove\" button use it.\n// 3. Save. You get a URL like https://--.web.val.run\n// /passages -> JSON the game reads\n// /stats -> counts by region / author / tier\n// /catalog -> a live Library page (bookmark this)\n// /export.json, /export.csv -> full repository download\n// /add (POST, X-Admin-Token) -> curation inserts here\n// /remove?id=… (POST, X-Admin-Token) -> prune a dud\n// /feedback (POST, public) -> stores a message and emails the owner\n// /feedback-list?token=… -> review 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 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\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}\n// std/sqlite returns { columns: string[], rows: any[][] } — map rows to objects\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 // ---- Reads ----\n // /passages -> the whole growing set\n // /passages?random=80 -> a light random rotation (what the game requests each session)\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 // /passage?id=… -> one exact passage by ID (used by shared deep-links so they always resolve)\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 }

Auto-grown from public-domain sources. Use the export buttons for the full text of every passage.

\n`;\n return new Response(page, {\n headers: { ...CORS, \"Content-Type\": \"text/html\" },\n });\n }\n\n // ---- Feedback ----\n // POST /feedback (public): store the message and email it to the val owner.\n // The destination address lives in the Val Town account, never in the website code.\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 try to email even if storage hiccups */ }\n try {\n await email({\n subject: \"In Other Words — feedback\" + (name ? ` from ${name}` : \"\"),\n text:\n `New feedback from playinotherwords.com\\n\\n${message}\\n\\n— — —\\nName: ${\n name || \"(not given)\"\n }\\nReply email: ${mail || \"(not given)\"}\\nPage: ${\n page || \"(unknown)\"\n }\\nTime: ${when}`,\n });\n } catch {\n /* email best-effort; the message is already stored and retrievable via /feedback-list */\n }\n return json({ ok: true });\n }\n\n // GET /feedback-list (admin): review everything that's come in.\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 // ---- Writes (token-protected) ----\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 // /wipe?source=gb -> clear auto-curated rows (id prefix) so the improved cron can refill cleanly.\n // /wipe?all=1 -> clear everything. Token-protected.\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 \"/export.json\",\n \"/export.csv\",\n \"/feedback\",\n \"/add\",\n \"/remove\",\n \"/wipe\",\n ],\n }, 404);\n}","https://www.adweek.com/social-marketing/pinterest-shoppable-ctv-series-turns-pins-into-purchases-on-roku/","createdAt",["D",1781976976848],"branchVersion","branchId","81e4b803-d670-4946-8ed7-9a1fb1c399f5","id","b1696bb9-5d73-4235-9499-6fbc7cc0bd5b",["D",1781910075952],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","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",{"_94":93,"_102":98},"org",{"_94":93,"_95":96,"_97":98,"_18":54,"_99":100,"_101":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":35,"_92":93},"isOwned",7,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","dominod10462","handle","displayName","Malik Ducard","avatar","https://lh3.googleusercontent.com/a/ACg8ocItvou6DeBgsc17TMlT-ZKWGuYbbXAMf5IMeKd22qu2Sidx1ulwJQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":35,"_38":149,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":150,"_78":151,"_80":152,"_82":25},"tree",[144],"files",[144],"counts",{"_133":60,"_134":135,"_136":60,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"b04e75c7-e472-4940-9fd1-1ce758cf36b9","parentId","latest",["D",1781976976848],5,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":135,"_143":60},"connections",{"_141":60,"_142":60},"count","unfilledCount","emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":145,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1781976976848],"children",[],[28],["D",1781910075952],{"_94":93,"_102":98},{"_94":93,"_95":96,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":35,"_92":93},"ctx",{"_76":-5,"_122":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":120,"_195":-5,"_196":-7,"_197":-7,"_198":60,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":84,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"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 · v6