${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",[119],"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",[137],"pulls",1,"forks","envVars",{"_151":145,"_153":54},"connections",{"_151":54,"_152":54},"count","unfilledCount","emptyCount",{"_20":136,"_13":137,"_120":48,"_122":-5,"_123":21,"_124":138,"_125":50,"_22":160,"_29":140,"_128":129,"_130":141,"_132":38,"_133":142,"_157":161,"_94":162},{"_20":118,"_13":119,"_120":121,"_122":-5,"_123":21,"_124":30,"_125":50,"_22":156,"_29":127,"_128":129,"_130":131,"_132":38,"_133":134,"_157":158,"_94":159},["D",1784560428480],"children",[],[119],["D",1784511190886],[],[137],["D",1784490986084],["D",1789472446807],{"_11":12,"_92":88},{"_11":12,"_85":86,"_87":88,"_45":46,"_89":90,"_91":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_80":-5,"_81":-5,"_82":-5,"_83":14,"_84":12},"ctx",{"_73":-5,"_113":201,"_202":203,"_204":205,"_206":38,"_207":38,"_208":38,"_209":50,"_210":-5,"_211":-7,"_212":-7,"_213":54,"_214":38,"_215":38,"_216":-5,"_217":38,"_218":38,"_219":38,"_220":-5},"ENV",{"_172":173,"_174":175,"_176":26,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200},"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",[],"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

Branches1

Branches
1