${innerHtml}

`,\n false,\n );\n}\n\nfunction buildBarSegments(rows: any[], byField: \"creator\" | \"description\") {\n const map = new Map();\n for (const r of rows) map.set(r[byField], (map.get(r[byField]) || 0) + 1);\n return Array.from(map.entries())\n .sort((a, b) => b[1] - a[1])\n .map(([k, v]) => ({ key: k, label: k, value: v }));\n}\n\nfunction buildPercentBars(\n segments: { key: string; label: string; value: number }[],\n) {\n const total = segments.reduce((s, x) => s + x.value, 0) || 1;\n return segments\n .map((seg, i) => {\n const percent = Math.round((seg.value / total) * 100);\n const color = CHART_COLORS[i % CHART_COLORS.length];\n return `

\n ${escapeHtml(seg.label)}\n ${seg.value} · ${percent}%\n

`;\n })\n .join(\"\");\n}\n\nasync function renderStatsPage(me: string, key: string, debug: boolean) {\n const litAllRes = await sqlite.execute(\n `SELECT * FROM ${STARS_TABLE} WHERE status = 'lit'`,\n );\n const litAll = litAllRes.rows as any[];\n const personSegments = buildBarSegments(litAll, \"creator\");\n const typeSegments = buildBarSegments(litAll, \"description\");\n\n return simplePage(\n \"Stats\",\n `\n

Stats

Share of verified stars, by person and by goal.

By person

\n ${\n litAll.length\n ? buildPercentBars(personSegments)\n : `

No stars lit yet.

`\n }\n

By goal

\n ${\n litAll.length\n ? buildPercentBars(typeSegments)\n : `

No stars lit yet.

`\n }\n

\n \n `,\n );\n}\n\nasync function renderSkyPage(\n me: string,\n key: string,\n pickingStarId: string | null,\n debug: boolean,\n) {\n const pendingRes = await sqlite.execute(\n `SELECT * FROM ${STARS_TABLE} WHERE verifier = ? AND status = 'pending' ORDER BY submitted_at ASC`,\n [me],\n );\n const pendingItems = pendingRes.rows as any[];\n const pendingCount = pendingItems.length;\n\n const myUnlitRes = await sqlite.execute(\n `SELECT * FROM ${STARS_TABLE} WHERE creator = ? AND status = 'unlit' ORDER BY created_at ASC`,\n [me],\n );\n const myUnlit = myUnlitRes.rows as any[];\n\n const epoch = await getCurrentEpoch();\n // Every pending/lit star, from every epoch ever — discovered\n // constellations stay visible in the sky permanently, not just in the\n // Collection tab.\n const currentRes = await sqlite.execute(\n `SELECT * FROM ${STARS_TABLE} WHERE status IN ('pending','lit')`,\n );\n const currentStars = currentRes.rows as any[];\n const occupied = new Map();\n for (const s of currentStars) occupied.set(`${s.cell_x},${s.cell_y}`, s);\n\n const litAllRes = await sqlite.execute(\n `SELECT * FROM ${STARS_TABLE} WHERE status = 'lit'`,\n );\n const litAll = litAllRes.rows as any[];\n\n const discoveredEpochsRes = await sqlite.execute(\n `SELECT * FROM ${EPOCHS_TABLE} WHERE discovered_at IS NOT NULL`,\n );\n const discoveredEpochs = discoveredEpochsRes.rows as any[];\n const discoveredCount = { cnt: discoveredEpochs.length };\n\n // Grid + occupied stars.\n const cellW = VIEWBOX_W / GRID_COLS;\n const cellH = VIEWBOX_H / GRID_ROWS;\n const hiddenCellsForDebug: { x: number; y: number }[] = debug\n ? JSON.parse(epoch.hidden_cells)\n : [];\n const hiddenSetForDebug = new Set(\n hiddenCellsForDebug.map((c) => `${c.x},${c.y}`),\n );\n\n // Which cells belong to a bright/\"main\" star — checked against every\n // epoch (the current hunt included), so a main star shows big the moment\n // it's individually verified, not only once the whole shape is found.\n const mainCellSet = new Set();\n for (const ep of [epoch, ...discoveredEpochs]) {\n const template = TEMPLATES.find((t) => t.key === ep.template_key);\n if (!template) continue;\n const cells: { x: number; y: number }[] = JSON.parse(ep.hidden_cells);\n template.points.forEach((p, i) => {\n if (p.main && cells[i]) mainCellSet.add(`${cells[i].x},${cells[i].y}`);\n });\n }\n\n // Every cell belonging to a fully-completed constellation — these glow\n // noticeably brighter than an ordinary stray star.\n const discoveredMemberSet = new Set();\n for (const ep of discoveredEpochs) {\n const cells: { x: number; y: number }[] = JSON.parse(ep.hidden_cells);\n for (const c of cells) discoveredMemberSet.add(`${c.x},${c.y}`);\n }\n\n // Connecting lines only for shapes that are actually complete.\n let linesHtml = \"\";\n for (const ep of discoveredEpochs) {\n const template = TEMPLATES.find((t) => t.key === ep.template_key);\n if (!template) continue;\n const cells: { x: number; y: number }[] = JSON.parse(ep.hidden_cells);\n linesHtml += template.edges\n .filter(([a, b]) => cells[a] && cells[b])\n .map(([a, b]) => {\n const p1 = cells[a];\n const p2 = cells[b];\n const x1 = p1.x * cellW + cellW / 2;\n const y1 = p1.y * cellH + cellH / 2;\n const x2 = p2.x * cellW + cellW / 2;\n const y2 = p2.y * cellH + cellH / 2;\n return ``;\n })\n .join(\"\");\n }\n\n let cellsHtml = \"\";\n for (let gy = 0; gy < GRID_ROWS; gy++) {\n for (let gx = 0; gx < GRID_COLS; gx++) {\n const cx = gx * cellW + cellW / 2;\n const cy = gy * cellH + cellH / 2;\n const isHidden = debug && hiddenSetForDebug.has(`${gx},${gy}`);\n if (isHidden) {\n cellsHtml +=\n ``;\n }\n const occ = occupied.get(`${gx},${gy}`);\n if (occ) {\n const isMain = mainCellSet.has(`${gx},${gy}`);\n const isCompleted = discoveredMemberSet.has(`${gx},${gy}`);\n const info = `${occ.creator} — ${occ.description} (#${\n occ.star_order + 1\n } of ${occ.target_count}) — verifier ${occ.verifier}${\n occ.status === \"lit\"\n ? \", lit \" + formatDate(occ.lit_at)\n : \", submitted \" + formatDate(occ.submitted_at)\n }`;\n if (occ.status === \"lit\") {\n // Stable per-star jitter (same star always renders the same size)\n // so the sky reads as naturally varied rather than uniform.\n const jitter = sizeJitter(occ.id);\n const completedBoost = isCompleted ? 1.35 : 1;\n const haloR = (isMain ? 14 : 10) * jitter * completedBoost;\n const coreR = (isMain ? 8.2 : 5.8) * jitter * completedBoost;\n const glow1 = isCompleted\n ? \"0 0 7px rgba(245,230,184,1)\"\n : \"0 0 5px rgba(245,230,184,0.95)\";\n const glow2 = isCompleted\n ? \"0 0 16px rgba(245,230,184,0.75)\"\n : \"0 0 10px rgba(245,230,184,0.55)\";\n cellsHtml +=\n `` +\n ``;\n } else {\n const clickable = occ.verifier === me;\n cellsHtml += ``;\n }\n } else if (pickingStarId) {\n cellsHtml +=\n ``;\n cellsHtml +=\n ``;\n } else {\n cellsHtml +=\n ``;\n }\n }\n }\n // Lines render first so stars draw on top of them.\n cellsHtml = linesHtml + cellsHtml;\n\n const detailBlocks: string[] = [];\n for (const s of currentStars) {\n if (s.status === \"lit\") {\n detailBlocks.push(`\n

${escapeHtml(s.creator)} — ${\n escapeHtml(s.description)\n }

#${\n s.star_order + 1\n } of ${s.target_count} · verified ${formatDate(s.lit_at)}

\n \n

`);\n } else if (s.verifier === me) {\n detailBlocks.push(`\n

${escapeHtml(s.creator)} — ${\n escapeHtml(s.description)\n }

#${\n s.star_order + 1\n } of ${s.target_count} · submitted ${formatDate(s.submitted_at)}

\n ${\n s.photo_data\n ? `

`\n : `

No photo attached.

`\n }\n \n \n \n

`);\n }\n }\n\n // Placement confirmation panel (shown after picking a cell).\n const placeConfirmHtml = pickingStarId\n ? `\n

Place your star here

\n \n \n

`\n : \"\";\n\n // Locked (pending queue) panel.\n const lockedHtml = pendingCount > 0\n ? `\n

Clear your queue first

${pendingCount} thing${\n pendingCount === 1 ? \"\" : \"s\"\n } waiting on your verification.

\n ${\n pendingItems\n .map(\n (s) => `\n

${escapeHtml(s.creator)} — ${escapeHtml(s.description)}

\n ${\n s.photo_data\n ? `

`\n : \"\"\n }\n \n \n

`,\n )\n .join(\"\")\n }\n \n

`\n : \"\";\n\n // \"Place a star\" picker list (your unlit commitment slots).\n const pastGoals = await sqlite.execute(\n `SELECT DISTINCT description FROM ${STARS_TABLE} WHERE creator = ? ORDER BY created_at DESC LIMIT 25`,\n [me],\n );\n const pastVerifiers = await sqlite.execute(\n `SELECT DISTINCT verifier FROM ${STARS_TABLE} WHERE creator = ? ORDER BY created_at DESC LIMIT 25`,\n [me],\n );\n const goalOptions = (pastGoals.rows as any[]).map((r) =>\n ``\n ).join(\"\");\n const verifierOptions = (pastVerifiers.rows as any[]).map((r) =>\n ``\n ).join(\"\");\n\n // One row per commitment — the earliest still-open slot for it — rather\n // than a separate row for every remaining instance.\n const nextSlotByCommitment = new Map();\n for (const s of myUnlit) {\n const existing = nextSlotByCommitment.get(s.commitment_id);\n if (!existing || s.star_order < existing.star_order) {\n nextSlotByCommitment.set(s.commitment_id, s);\n }\n }\n const nextSlots = Array.from(nextSlotByCommitment.values()).sort((a, b) =>\n a.created_at < b.created_at ? -1 : 1\n );\n\n const placePickerHtml = `\n

Place a star

\n ${\n nextSlots.length\n ? nextSlots\n .map(\n (s) =>\n `

\n \n

`,\n )\n .join(\"\")\n : `

No slots ready to place yet — create a commitment below.

`\n }\n \n

`;\n\n const createHtml = `\n

New commitment

\n \n \n

`;\n\n const personSegments = buildBarSegments(litAll, \"creator\");\n const typeSegments = buildBarSegments(litAll, \"description\");\n\n const personChips = personSegments\n .map((seg, i) =>\n `${escapeHtml(seg.label)} · ${seg.value}`\n )\n .join(\"\");\n const typeChips = typeSegments\n .map((seg, i) =>\n `${escapeHtml(seg.label)} · ${seg.value}`\n )\n .join(\"\");\n\n const body = `\n

\n \n\n \n\n

\n \n

\n\n

\n ${personChips || `No stars lit yet`}\n ${typeChips ? `·${typeChips}` : \"\"}\n

\n\n

\n ${detailBlocks.join(\"\")}\n ${placeConfirmHtml}\n ${lockedHtml}\n ${placePickerHtml}\n ${createHtml}\n\n \n `;\n\n return shellPage(\"Habit Sky\", body, true);\n}\n\nasync function renderCollectionPage(me: string, key: string, debug: boolean) {\n const countsRes = await sqlite.execute(\n `SELECT template_key, COUNT(*) as cnt, MAX(discovered_at) as latest\n FROM ${EPOCHS_TABLE} WHERE discovered_at IS NOT NULL GROUP BY template_key`,\n );\n const countMap = new Map();\n for (const r of countsRes.rows as any[]) {\n countMap.set(r.template_key, { cnt: Number(r.cnt), latest: r.latest });\n }\n\n // The universe of constellations is fixed — always show all templates, locked\n // until found at least once. Unlocking is global: if any player discovers\n // a constellation, it unlocks for everyone viewing the collection.\n const html = TEMPLATES.map((template) => {\n const found = countMap.get(template.key);\n const scale = 30;\n const xs = template.points.map((p) => p.x);\n const ys = template.points.map((p) => p.y);\n const minX = Math.min(...xs);\n const minY = Math.min(...ys);\n const maxX = Math.max(...xs);\n const maxY = Math.max(...ys);\n const pad = 15;\n const vbW = (maxX - minX + pad * 2) * (scale / 100);\n const vbH = (maxY - minY + pad * 2) * (scale / 100);\n const pts = template.points.map((p) => ({\n x: (p.x - minX + pad) * (scale / 100),\n y: (p.y - minY + pad) * (scale / 100),\n }));\n\n if (!found) {\n // Locked: a dim silhouette, no glow, no reveal of when/how it was found.\n const linesHtml = template.edges\n .map(([a, b]) =>\n ``\n )\n .join(\"\");\n const dotsHtml = pts\n .map((p, i) => {\n const r = template.points[i]?.main ? 4.8 : 3.1;\n return ``;\n })\n .join(\"\");\n return `\n

\n 🔒\n

${\n escapeHtml(template.name)\n }

To be discovered

\n \n

`;\n }\n\n const linesHtml = template.edges\n .map(([a, b]) =>\n ``\n )\n .join(\"\");\n const dotsHtml = pts\n .map((p, i) => {\n const isMain = !!template.points[i]?.main;\n const haloR = isMain ? 10 : 7;\n const coreR = isMain ? 6 : 4.2;\n return ``;\n })\n .join(\"\");\n return `\n

\n ${\n found.cnt > 1\n ? `×${found.cnt}`\n : \"\"\n }\n

${\n escapeHtml(template.name)\n }

${\n found.cnt > 1 ? `Found ${found.cnt} times · most recently` : \"Found\"\n } ${formatDate(found.latest)}

\n \n

`;\n }).join(\"\");\n\n return simplePage(\n \"Universe\",\n `\n \n

Universe

Tapestry of jointly discovered constellations

${html}

\n \n `,\n );\n}\n\nasync function renderPreviewPage(me: string, key: string, debug: boolean) {\n const previewCols = 11;\n const previewRows = 8;\n const previewW = 330;\n const previewH = 240;\n const cellW = previewW / previewCols;\n const cellH = previewH / previewRows;\n\n function templateToPreviewCells(\n template: Template,\n ): { x: number; y: number }[] {\n const boxW = 9;\n const boxH = 7;\n const offsetX = 1;\n const offsetY = 0;\n const cells = template.points.map((p) => ({\n x: offsetX + Math.round((p.x / 100) * (boxW - 1)),\n y: offsetY + Math.round((p.y / 100) * (boxH - 1)),\n }));\n const seen = new Set();\n for (const c of cells) {\n let key = `${c.x},${c.y}`;\n while (seen.has(key)) {\n c.x = Math.min(previewCols - 1, c.x + 1);\n key = `${c.x},${c.y}`;\n }\n seen.add(key);\n }\n return cells;\n }\n\n const cards = TEMPLATES.map((template) => {\n const cells = templateToPreviewCells(template);\n const linesHtml = template.edges\n .filter(([a, b]) => cells[a] && cells[b])\n .map(([a, b]) => {\n const p1 = cells[a];\n const p2 = cells[b];\n const x1 = p1.x * cellW + cellW / 2;\n const y1 = p1.y * cellH + cellH / 2;\n const x2 = p2.x * cellW + cellW / 2;\n const y2 = p2.y * cellH + cellH / 2;\n return ``;\n })\n .join(\"\");\n const starsHtml = cells\n .map((c, i) => {\n const isMain = !!template.points[i]?.main;\n const x = c.x * cellW + cellW / 2;\n const y = c.y * cellH + cellH / 2;\n const haloR = isMain ? 12 : 8;\n const coreR = isMain ? 7 : 4.8;\n return ``;\n })\n .join(\"\");\n const gridDots = Array.from({ length: previewRows }).map((_, gy) =>\n Array.from({ length: previewCols }).map((__, gx) => {\n const x = gx * cellW + cellW / 2;\n const y = gy * cellH + cellH / 2;\n return ``;\n }).join(\"\")\n ).join(\"\");\n return `\n

${\n escapeHtml(template.name)\n }

\n \n

`;\n }).join(\"\");\n\n return simplePage(\n \"Constellation Preview\",\n `\n \n

Constellation Preview

All templates shown as fully unlocked, final lit shapes in grid placement.

${cards}

\n \n `,\n );\n}\n\nexport default async function (req: Request): Promise {\n await ensureTables();\n const url = new URL(req.url);\n const path = url.pathname;\n const me = (url.searchParams.get(\"me\") || \"\").trim();\n const key = (url.searchParams.get(\"key\") || \"\").trim();\n const pick = (url.searchParams.get(\"pick\") || \"\").trim() || null;\n const debug = url.searchParams.get(\"debug\") === \"1\";\n\n // Static PWA assets — must stay reachable even with APP_SECRET set,\n // since the OS install flow won't carry the key along.\n if (path === \"/manifest.json\" && req.method === \"GET\") {\n const manifest = {\n name: \"Habit Sky\",\n short_name: \"Habit Sky\",\n start_url: url.origin + \"/\" + qs(me, key),\n display: \"standalone\",\n background_color: \"#0B0F22\",\n theme_color: \"#0B0F22\",\n icons: [\n { src: \"/icon.svg\", sizes: \"192x192\", type: \"image/svg+xml\" },\n { src: \"/icon.svg\", sizes: \"512x512\", type: \"image/svg+xml\" },\n ],\n };\n return new Response(JSON.stringify(manifest), {\n headers: { \"content-type\": \"application/manifest+json\" },\n });\n }\n\n if (path === \"/icon.svg\" && req.method === \"GET\") {\n const icon = ``;\n return new Response(icon, { headers: { \"content-type\": \"image/svg+xml\" } });\n }\n\n const requiredSecret = Deno.env.get(\"APP_SECRET\");\n if (requiredSecret && key !== requiredSecret) {\n return new Response(\n simplePage(\n \"Locked\",\n `

Locked

This link needs a valid key.

`,\n ),\n { status: 401, headers: { \"content-type\": \"text/html\" } },\n );\n }\n\n if (path === \"/\" && req.method === \"GET\") {\n if (!me) {\n return new Response(\n simplePage(\n \"Habit Sky\",\n `

Habit Sky

Open this link with your name, e.g. ?me=Sahana

\n `,\n ),\n { headers: { \"content-type\": \"text/html\" } },\n );\n }\n return new Response(await renderSkyPage(me, key, pick, debug), {\n headers: { \"content-type\": \"text/html\" },\n });\n }\n\n if (path === \"/collection\" && req.method === \"GET\") {\n if (!me) {\n return Response.redirect(url.origin + \"/\" + qs(\"\", key, debug), 302);\n }\n return new Response(await renderCollectionPage(me, key, debug), {\n headers: { \"content-type\": \"text/html\" },\n });\n }\n\n if (path === \"/preview\" && req.method === \"GET\") {\n if (!me) {\n return Response.redirect(url.origin + \"/\" + qs(\"\", key, debug), 302);\n }\n if (!debug) {\n return Response.redirect(url.origin + \"/\" + qs(me, key, debug), 302);\n }\n return new Response(await renderPreviewPage(me, key, debug), {\n headers: { \"content-type\": \"text/html\" },\n });\n }\n\n if (path === \"/stats\" && req.method === \"GET\") {\n if (!me) {\n return Response.redirect(url.origin + \"/\" + qs(\"\", key, debug), 302);\n }\n return new Response(await renderStatsPage(me, key, debug), {\n headers: { \"content-type\": \"text/html\" },\n });\n }\n\n if (path === \"/api/commitments\" && req.method === \"POST\") {\n const form = await req.formData();\n const description = String(form.get(\"description\") || \"\").trim();\n const verifier = String(form.get(\"verifier\") || \"\").trim();\n const targetCount = Math.max(\n 1,\n Math.min(\n 30,\n Number.parseInt(String(form.get(\"target_count\") || \"0\"), 10) || 0,\n ),\n );\n if (!description || !verifier || !me || targetCount < 1) {\n return new Response(\"Missing or invalid fields\", { status: 400 });\n }\n const pendingRes = await sqlite.execute(\n `SELECT COUNT(*) as cnt FROM ${STARS_TABLE} WHERE verifier = ? AND status = 'pending'`,\n [me],\n );\n if (Number((pendingRes.rows[0] as any)?.cnt || 0) > 0) {\n return new Response(\n simplePage(\n \"Verify first\",\n `

Verify first

Clear what's waiting on your verification before starting a new commitment.

`,\n ),\n { status: 409, headers: { \"content-type\": \"text/html\" } },\n );\n }\n const commitmentId = uid();\n const now = new Date().toISOString();\n for (let i = 0; i < targetCount; i++) {\n await sqlite.execute(\n `INSERT INTO ${STARS_TABLE} (id, commitment_id, creator, verifier, description, target_count, star_order, status, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, 'unlit', ?)`,\n [uid(), commitmentId, me, verifier, description, targetCount, i, now],\n );\n }\n return Response.redirect(url.origin + \"/\" + qs(me, key, debug), 303);\n }\n\n const submitMatch = path.match(/^\\/api\\/stars\\/([\\w-]+)\\/submit$/);\n if (submitMatch && req.method === \"POST\") {\n const starId = submitMatch[1];\n const form = await req.formData();\n const cellX = Number.parseInt(String(form.get(\"cell_x\") || \"\"), 10);\n const cellY = Number.parseInt(String(form.get(\"cell_y\") || \"\"), 10);\n const photoData = String(form.get(\"photo_data\") || \"\").trim() || null;\n\n const existing = await sqlite.execute(\n `SELECT * FROM ${STARS_TABLE} WHERE id = ?`,\n [starId],\n );\n const star = existing.rows[0] as any;\n if (!star || star.creator !== me) {\n return new Response(\"Not authorized\", { status: 403 });\n }\n if (star.status !== \"unlit\") {\n return new Response(\"Not available\", { status: 400 });\n }\n if (Number.isNaN(cellX) || Number.isNaN(cellY)) {\n return new Response(\"Missing cell\", { status: 400 });\n }\n\n const pendingRes = await sqlite.execute(\n `SELECT COUNT(*) as cnt FROM ${STARS_TABLE} WHERE verifier = ? AND status = 'pending'`,\n [me],\n );\n if (Number((pendingRes.rows[0] as any)?.cnt || 0) > 0) {\n return new Response(\n simplePage(\n \"Verify first\",\n `

Verify first

Clear your queue before placing a new star.

`,\n ),\n { status: 409, headers: { \"content-type\": \"text/html\" } },\n );\n }\n\n const epoch = await getCurrentEpoch();\n const occupiedCheck = await sqlite.execute(\n `SELECT id FROM ${STARS_TABLE} WHERE cell_x = ? AND cell_y = ? AND status IN ('pending','lit')`,\n [cellX, cellY],\n );\n if (occupiedCheck.rows.length > 0) {\n return new Response(\n simplePage(\n \"Spot taken\",\n `

That spot's taken

Someone just claimed it. Pick another.

`,\n ),\n { status: 409, headers: { \"content-type\": \"text/html\" } },\n );\n }\n\n await sqlite.execute(\n `UPDATE ${STARS_TABLE} SET status = 'pending', epoch_id = ?, cell_x = ?, cell_y = ?, submitted_at = ?, photo_data = ? WHERE id = ?`,\n [epoch.id, cellX, cellY, new Date().toISOString(), photoData, starId],\n );\n return Response.redirect(url.origin + \"/\" + qs(me, key, debug), 303);\n }\n\n const verifyMatch = path.match(/^\\/api\\/stars\\/([\\w-]+)\\/verify$/);\n if (verifyMatch && req.method === \"POST\") {\n const starId = verifyMatch[1];\n const form = await req.formData();\n const decision = String(form.get(\"decision\") || \"\");\n\n const existing = await sqlite.execute(\n `SELECT * FROM ${STARS_TABLE} WHERE id = ?`,\n [starId],\n );\n const star = existing.rows[0] as any;\n if (!star || star.verifier !== me) {\n return new Response(\"Not authorized\", { status: 403 });\n }\n if (star.status !== \"pending\") {\n return new Response(\"Not awaiting verification\", { status: 400 });\n }\n\n if (decision === \"approve\") {\n await sqlite.execute(\n `UPDATE ${STARS_TABLE} SET status = 'lit', lit_at = ?, photo_data = NULL WHERE id = ?`,\n [\n new Date().toISOString(),\n starId,\n ],\n );\n if (star.epoch_id) await checkDiscovery(star.epoch_id);\n } else {\n await sqlite.execute(\n `UPDATE ${STARS_TABLE} SET status = 'unlit', epoch_id = NULL, cell_x = NULL, cell_y = NULL, submitted_at = NULL, photo_data = NULL WHERE id = ?`,\n [starId],\n );\n }\n return Response.redirect(url.origin + \"/\" + qs(me, key, debug), 303);\n }\n\n return new Response(\"Not found\", { status: 404 });\n}","deleted","label","habitsky",[113],"520cb78a-7742-43ba-90e1-a851d9164661","habit-garden.ts",25,["D",1784511190886],12,"/**\n * Habit Garden — One-screen garden interface\n * --------------------------------------------\n * Paste this whole file into a new HTTP val on val.town, deploy it,\n * then share the URL with a friend like:\n *\n * https://yourname-habitgarden.val.run/?me=You&key=YOUR_SECRET\n * https://yourname-habitgarden.val.run/?me=Friend&key=YOUR_SECRET\n *\n * The garden IS the app — no separate tabs:\n * - Click an empty plot to plant a new goal there.\n * - New goals appear dulled/grayed until verified.\n * - Click a dulled plot that's yours to verify → approve/reject inline.\n * - Click a dulled plot that's not yours to verify → see who it's\n * waiting on.\n * - Click a bloomed (verified) plot → see who/what/when. If you planted\n * it, you can also change its flower color/icon right there.\n * - You can't plant a new goal while anything is waiting on your own\n * verification — empty plots lock until you clear your queue.\n * - Rejected goals free their plot back up for someone else to use.\n *\n * Photos are optional at creation time and wiped from storage the moment\n * a goal is verified or rejected — nothing lingers.\n *\n * SHARED SECRET SETUP (do this before sharing the link):\n * 1. On val.town, open this val → sidebar → Environment Variables.\n * 2. Add a variable named APP_SECRET with any password-like value you pick.\n * 3. Every URL you share must include &key=that-same-value, or requests\n * are rejected with 401. Links inside the app carry the key forward\n * automatically once you're in.\n * 4. If you don't set APP_SECRET at all, the key check is skipped —\n * handy for your first local test, but do set it before sending\n * the link to friends.\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TABLE = \"habit_garden_goals_v1\";\n\nconst FLOWER_COLORS: { key: string; label: string; hex: string }[] = [\n { key: \"blush\", label: \"Blush\", hex: \"#D8A499\" },\n { key: \"clay\", label: \"Clay\", hex: \"#C88B6B\" },\n { key: \"amber\", label: \"Amber\", hex: \"#D9A441\" },\n { key: \"plum\", label: \"Plum\", hex: \"#9B7AA0\" },\n { key: \"sky\", label: \"Sky\", hex: \"#8AB0C6\" },\n { key: \"gold\", label: \"Gold\", hex: \"#E0BD4A\" },\n { key: \"coral\", label: \"Coral\", hex: \"#D98166\" },\n { key: \"sage\", label: \"Sage\", hex: \"#A8BE95\" },\n { key: \"berry\", label: \"Berry\", hex: \"#B0678A\" },\n];\nconst DEFAULT_FLOWER_KEY = \"blush\";\n\nconst CHART_COLORS = [\n \"#28372B\",\n \"#D8A499\",\n \"#C9A227\",\n \"#6C90A8\",\n \"#7A5C7E\",\n \"#8FA37E\",\n \"#C8674A\",\n \"#D9A441\",\n \"#C88B6B\",\n \"#8E4B62\",\n];\n\nconst MIN_SLOTS = 24;\nconst BUFFER_SLOTS = 8;\n\nasync function ensureTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE} (\n id TEXT PRIMARY KEY,\n creator TEXT NOT NULL,\n verifier TEXT NOT NULL,\n description TEXT NOT NULL,\n flower_emoji TEXT NOT NULL DEFAULT 'blush',\n status TEXT NOT NULL DEFAULT 'submitted',\n photo_data TEXT,\n plot_index INTEGER,\n created_at TEXT NOT NULL,\n verified_at TEXT\n )\n `);\n for (\n const stmt of [\n `ALTER TABLE ${TABLE} ADD COLUMN flower_emoji TEXT NOT NULL DEFAULT 'blush'`,\n `ALTER TABLE ${TABLE} ADD COLUMN photo_data TEXT`,\n `ALTER TABLE ${TABLE} ADD COLUMN plot_index INTEGER`,\n ]\n ) {\n try {\n await sqlite.execute(stmt);\n } catch {\n // Column already exists — fine, ignore.\n }\n }\n try {\n const needsBackfill = await sqlite.execute(\n `SELECT COUNT(*) as cnt FROM ${TABLE} WHERE plot_index IS NULL AND status != 'rejected'`,\n );\n const cnt = Number((needsBackfill.rows[0] as any)?.cnt || 0);\n if (cnt > 0) {\n const maxRow = await sqlite.execute(\n `SELECT MAX(plot_index) as m FROM ${TABLE}`,\n );\n let nextIdx = ((maxRow.rows[0] as any)?.m ?? -1) + 1;\n const toAssign = await sqlite.execute(\n `SELECT id FROM ${TABLE} WHERE plot_index IS NULL AND status != 'rejected' ORDER BY created_at ASC`,\n );\n for (const r of toAssign.rows as any[]) {\n await sqlite.execute(\n `UPDATE ${TABLE} SET plot_index = ? WHERE id = ?`,\n [nextIdx, r.id],\n );\n nextIdx++;\n }\n }\n } catch {\n // best effort — not fatal if this doesn't fully succeed\n }\n}\n\nfunction uid() {\n return crypto.randomUUID();\n}\n\nfunction qs(me: string, key: string) {\n const params = new URLSearchParams({ me });\n if (key) params.set(\"key\", key);\n return `?${params.toString()}`;\n}\n\nfunction escapeHtml(s: string) {\n return s\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\");\n}\n\nfunction jsonForScript(value: unknown) {\n return JSON.stringify(value).replace(/ f.key === key);\n return found\n ? found.hex\n : FLOWER_COLORS.find((f) => f.key === DEFAULT_FLOWER_KEY)!.hex;\n}\n\nfunction flowerHtml(value: string, sizePx: number, dulled: boolean) {\n const dulledStyle = dulled ? \"filter:grayscale(1) opacity(0.55);\" : \"\";\n if (value && value.startsWith(\"data:\")) {\n return `

`;\n }\n const hex = flowerColorHex(value);\n return ``;\n}\n\n// Reusable flower color picker (dropdown + custom upload + live preview).\n// Multiple can exist on one page — JS wires them up generically via the\n// .flower-picker / .flower-select / .flower-file / .flower-hidden classes.\nfunction flowerPickerHtml(inputName: string, currentValue: string) {\n const optionsHtml = FLOWER_COLORS\n .map((f) =>\n ``\n )\n .join(\"\");\n return `\n

\n \n

Or upload your own small flower icon.

\n \n

\n `;\n}\n\nconst PARCHMENT_TEXTURE =\n \"data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='140' height='140'%3E\" +\n \"%3Cfilter id='n'%3E%3CfeTurbulence type='fractalNoise' baseFrequency='0.85' numOctaves='2' stitchTiles='stitch'/%3E\" +\n \"%3CfeColorMatrix type='matrix' values='0 0 0 0 0.16 0 0 0 0 0.14 0 0 0 0 0.11 0 0 0 0.05 0'/%3E%3C/filter%3E\" +\n \"%3Crect width='100%25' height='100%25' filter='url(%23n)'/%3E%3C/svg%3E\";\n\nfunction page(title: string, body: string) {\n return `\n\n\n\n\n${escapeHtml(title)}\n\n\n\n\n\n\n${body}\n\n`;\n}\n\nfunction buildBarChart(\n idPrefix: string,\n segments: { key: string; label: string; value: number }[],\n) {\n const total = segments.reduce((s, x) => s + x.value, 0) || 1;\n return segments\n .map((seg, i) => {\n const percent = Math.round((seg.value / total) * 100);\n const color = CHART_COLORS[i % CHART_COLORS.length];\n return `

${\n escapeHtml(seg.label)\n }${percent}%

`;\n })\n .join(\"\");\n}\n\n// --- The one-screen garden ---\n\nasync function renderMainPage(me: string, key: string) {\n const pendingRes = await sqlite.execute(\n `SELECT * FROM ${TABLE} WHERE verifier = ? AND status = 'submitted' ORDER BY created_at ASC`,\n [me],\n );\n const pendingItems = pendingRes.rows as any[];\n const pendingCount = pendingItems.length;\n\n const occupantsRes = await sqlite.execute(\n `SELECT * FROM ${TABLE} WHERE status IN ('submitted','verified') ORDER BY plot_index ASC`,\n );\n const occupants = occupantsRes.rows as any[];\n const occupantMap = new Map();\n let maxIndex = -1;\n for (const g of occupants) {\n if (g.plot_index !== null && g.plot_index !== undefined) {\n occupantMap.set(Number(g.plot_index), g);\n maxIndex = Math.max(maxIndex, Number(g.plot_index));\n }\n }\n const usedSlots = maxIndex + 1;\n const totalSlots = Math.max(MIN_SLOTS, usedSlots + BUFFER_SLOTS);\n\n const pastGoals = await sqlite.execute(\n `SELECT description, flower_emoji, MAX(created_at) as last_used\n FROM ${TABLE} WHERE creator = ? GROUP BY description ORDER BY last_used DESC LIMIT 25`,\n [me],\n );\n const pastVerifiers = await sqlite.execute(\n `SELECT verifier, MAX(created_at) as last_used\n FROM ${TABLE} WHERE creator = ? GROUP BY verifier ORDER BY last_used DESC LIMIT 25`,\n [me],\n );\n const goalSelectOptions = (pastGoals.rows as any[])\n .map((r) =>\n ``\n )\n .join(\"\");\n const verifierSelectOptions = (pastVerifiers.rows as any[])\n .map((r) =>\n ``\n )\n .join(\"\");\n const descToEmoji = Object.fromEntries(\n (pastGoals.rows as any[]).map((\n r,\n ) => [r.description, r.flower_emoji || DEFAULT_FLOWER_KEY]),\n );\n\n // Build the grid.\n let gridHtml = \"\";\n for (let i = 0; i < totalSlots; i++) {\n const occ = occupantMap.get(i);\n if (occ) {\n const isBloomed = occ.status === \"verified\";\n const cls = isBloomed ? \"plot bloomed\" : \"plot dulled\";\n gridHtml +=\n ``;\n } else if (pendingCount > 0) {\n gridHtml +=\n ``;\n } else {\n gridHtml +=\n ``;\n }\n }\n\n // Build detail blocks for every occupant.\n let detailsHtml = \"\";\n for (const occ of occupants) {\n const isBloomed = occ.status === \"verified\";\n if (isBloomed) {\n const isMine = occ.creator === me;\n detailsHtml += `\n

${escapeHtml(occ.creator)} — ${\n escapeHtml(occ.description)\n }

Verified ${formatDate(occ.verified_at)}

\n ${\n isMine\n ? ``\n : \"\"\n }\n \n

`;\n } else if (occ.verifier === me) {\n detailsHtml += `\n

${escapeHtml(occ.creator)} — ${\n escapeHtml(occ.description)\n }

Waiting on your verification, planted ${\n formatDate(occ.created_at)\n }.

\n ${\n occ.photo_data\n ? `

`\n : `

No photo attached.

`\n }\n

\n \n \n

\n \n

`;\n } else {\n detailsHtml += `\n

${escapeHtml(occ.creator)} — ${\n escapeHtml(occ.description)\n }

Waiting on ${\n escapeHtml(occ.verifier)\n } to verify. Planted ${formatDate(occ.created_at)}.

\n \n

`;\n }\n }\n\n if (pendingCount > 0) {\n const pendingListHtml = pendingItems\n .map(\n (g) => `\n

${\n flowerHtml(g.flower_emoji, 24, true)\n }${escapeHtml(g.creator)} — ${\n escapeHtml(g.description)\n }

\n ${\n g.photo_data\n ? `

`\n : `

No photo attached.

`\n }\n

\n \n \n

`,\n )\n .join(\"\");\n detailsHtml += `\n

Clear your queue first

You can't plant a new goal until you've verified or rejected everything waiting on you.

\n ${pendingListHtml}\n \n

`;\n }\n\n detailsHtml += `\n

Plant a goal

\n \n \n

`;\n\n const verifiedRows = occupants.filter((g) => g.status === \"verified\");\n const byPerson = new Map();\n const byType = new Map();\n for (const g of verifiedRows) {\n byPerson.set(g.creator, (byPerson.get(g.creator) || 0) + 1);\n byType.set(g.description, (byType.get(g.description) || 0) + 1);\n }\n const personSegments = Array.from(byPerson.entries())\n .sort((a, b) => b[1] - a[1])\n .map(([k, v]) => ({ key: k, label: k, value: v }));\n const typeSegments = Array.from(byType.entries())\n .sort((a, b) => b[1] - a[1])\n .map(([k, v]) => ({ key: k, label: k, value: v }));\n\n const chartsHtml = verifiedRows.length\n ? `\n

By person

\n ${buildBarChart(\"person\", personSegments)}\n

By goal type

\n ${buildBarChart(\"desc\", typeSegments)}\n

\n `\n : `

Bars will appear once flowers have bloomed.

`;\n\n return page(\n \"Habit Garden\",\n `\n

Habit Garden

Signed in as ${\n escapeHtml(me)\n }${\n pendingCount > 0 ? ` · ${pendingCount} waiting on your verification` : \"\"\n }

\n\n

${gridHtml}

\n\n ${detailsHtml}\n\n

Contributions

\n ${chartsHtml}\n

\n\n \n `,\n );\n}\n\nexport default async function (req: Request): Promise {\n await ensureTable();\n const url = new URL(req.url);\n const path = url.pathname;\n const me = (url.searchParams.get(\"me\") || \"\").trim();\n const key = (url.searchParams.get(\"key\") || \"\").trim();\n\n const requiredSecret = Deno.env.get(\"APP_SECRET\");\n if (requiredSecret && key !== requiredSecret) {\n return new Response(\n page(\n \"Locked\",\n `

Locked

This link needs a valid key. Ask whoever set up the app for the shared link.

`,\n ),\n { status: 401, headers: { \"content-type\": \"text/html\" } },\n );\n }\n\n if ((path === \"/garden\" || path === \"/verify\") && req.method === \"GET\") {\n return Response.redirect(url.origin + \"/\" + qs(me, key), 302);\n }\n\n if (path === \"/\" && req.method === \"GET\") {\n if (!me) {\n return new Response(\n page(\n \"Habit Garden\",\n `

Habit Garden

Open this link with your name, e.g. ?me=Sahana

\n `,\n ),\n { headers: { \"content-type\": \"text/html\" } },\n );\n }\n return new Response(await renderMainPage(me, key), {\n headers: { \"content-type\": \"text/html\" },\n });\n }\n\n if (path === \"/api/goals\" && req.method === \"POST\") {\n const form = await req.formData();\n const description = String(form.get(\"description\") || \"\").trim();\n const verifier = String(form.get(\"verifier\") || \"\").trim();\n const flowerEmoji =\n String(form.get(\"flower_emoji\") || DEFAULT_FLOWER_KEY).trim() ||\n DEFAULT_FLOWER_KEY;\n const photoData = String(form.get(\"photo_data\") || \"\").trim() || null;\n const plotIndexRaw = String(form.get(\"plot_index\") || \"\").trim();\n const plotIndex = Number.parseInt(plotIndexRaw, 10);\n\n if (\n !description || !verifier || !me || Number.isNaN(plotIndex) ||\n plotIndex < 0\n ) {\n return new Response(\"Missing or invalid fields\", { status: 400 });\n }\n\n const pendingToVerify = await sqlite.execute(\n `SELECT COUNT(*) as cnt FROM ${TABLE} WHERE verifier = ? AND status = 'submitted'`,\n [me],\n );\n const pendingCount = Number((pendingToVerify.rows[0] as any)?.cnt || 0);\n if (pendingCount > 0) {\n return new Response(\n page(\n \"Verify first\",\n `

Verify first

You have ${pendingCount} thing${\n pendingCount === 1 ? \"\" : \"s\"\n } waiting on your verification. Clear those before planting a new goal.

\n `,\n ),\n { status: 409, headers: { \"content-type\": \"text/html\" } },\n );\n }\n\n const occupied = await sqlite.execute(\n `SELECT id FROM ${TABLE} WHERE plot_index = ? AND status IN ('submitted','verified')`,\n [plotIndex],\n );\n if (occupied.rows.length > 0) {\n return new Response(\n page(\n \"Spot taken\",\n `

That spot's taken

Someone just planted there. Head back and pick another spot.

\n `,\n ),\n { status: 409, headers: { \"content-type\": \"text/html\" } },\n );\n }\n\n await sqlite.execute(\n `INSERT INTO ${TABLE} (id, creator, verifier, description, flower_emoji, status, photo_data, plot_index, created_at)\n VALUES (?, ?, ?, ?, ?, 'submitted', ?, ?, ?)`,\n [\n uid(),\n me,\n verifier,\n description,\n flowerEmoji,\n photoData,\n plotIndex,\n new Date().toISOString(),\n ],\n );\n return Response.redirect(url.origin + \"/\" + qs(me, key), 303);\n }\n\n const verifyMatch = path.match(/^\\/api\\/goals\\/([\\w-]+)\\/verify$/);\n if (verifyMatch && req.method === \"POST\") {\n const goalId = verifyMatch[1];\n const form = await req.formData();\n const decision = String(form.get(\"decision\") || \"\");\n\n const existing = await sqlite.execute(\n `SELECT * FROM ${TABLE} WHERE id = ?`,\n [goalId],\n );\n const goal = existing.rows[0] as any;\n if (!goal || goal.verifier !== me) {\n return new Response(\"Not authorized to verify this goal\", {\n status: 403,\n });\n }\n if (goal.status !== \"submitted\") {\n return new Response(\"Goal is not awaiting verification\", { status: 400 });\n }\n\n const newStatus = decision === \"approve\" ? \"verified\" : \"rejected\";\n await sqlite.execute(\n `UPDATE ${TABLE} SET status = ?, verified_at = ?, photo_data = NULL WHERE id = ?`,\n [newStatus, new Date().toISOString(), goalId],\n );\n return Response.redirect(url.origin + \"/\" + qs(me, key), 303);\n }\n\n // Let the original creator restyle a flower after it's already bloomed.\n const flowerMatch = path.match(/^\\/api\\/goals\\/([\\w-]+)\\/flower$/);\n if (flowerMatch && req.method === \"POST\") {\n const goalId = flowerMatch[1];\n const form = await req.formData();\n const flowerEmoji = String(form.get(\"flower_emoji\") || \"\").trim();\n\n const existing = await sqlite.execute(\n `SELECT * FROM ${TABLE} WHERE id = ?`,\n [goalId],\n );\n const goal = existing.rows[0] as any;\n if (!goal || goal.creator !== me) {\n return new Response(\"Not authorized to edit this goal's flower\", {\n status: 403,\n });\n }\n if (goal.status !== \"verified\") {\n return new Response(\"Only verified goals can have their flower changed\", {\n status: 400,\n });\n }\n if (!flowerEmoji) {\n return new Response(\"Missing flower value\", { status: 400 });\n }\n\n await sqlite.execute(`UPDATE ${TABLE} SET flower_emoji = ? WHERE id = ?`, [\n flowerEmoji,\n goalId,\n ]);\n return Response.redirect(url.origin + \"/\" + qs(me, key), 303);\n }\n\n return new Response(\"Not found\", { status: 404 });\n}","habitgarden",[131],"pulls","branches",1,"forks","envVars",{"_146":140,"_148":42},"connections",{"_146":42,"_147":42},"count","unfilledCount","emptyCount",{"_18":130,"_20":131,"_114":36,"_116":-5,"_117":71,"_118":132,"_119":38,"_22":155,"_68":134,"_122":123,"_124":135,"_126":26,"_127":136,"_152":156,"_89":157},{"_18":112,"_20":113,"_114":115,"_116":-5,"_117":71,"_118":69,"_119":38,"_22":151,"_68":121,"_122":123,"_124":125,"_126":26,"_127":128,"_152":153,"_89":154},["D",1784560428480],"children",[],[113],["D",1784511190886],[],[131],["D",1784490986084],["D",1789559472742],{"_16":17,"_87":83},{"_16":17,"_80":81,"_82":83,"_33":34,"_84":85,"_86":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"ctx",{"_61":-5,"_107":196,"_197":198,"_199":200,"_201":26,"_202":26,"_203":26,"_204":38,"_205":-5,"_206":-7,"_207":-7,"_208":42,"_209":26,"_210":26,"_211":-5,"_212":26,"_213":26,"_214":26,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":70,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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"]

Stats

By person

By goal

Habit Sky${\n discoveredCount?.cnt > 0 ? ` · ${discoveredCount.cnt} found` : \"\"\n }${debug ? ` · DEBUG` : \"\"}

Universe

Constellation Preview

Locked

Habit Sky

Verify first

Verify first

That spot's taken

By person

By goal type

Habit Garden

Contributions

Locked

Habit Garden

Verify first

That spot's taken