[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_453":454,"_455":456},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_337":-5,"_20":338,"_22":339,"_340":341,"_342":343,"_26":344,"_24":345,"_346":347,"_348":349,"_350":51,"_351":352,"_353":71,"_354":-5,"_355":-5,"_356":357},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5,"_31":32,"_33":34,"_35":-5},"handle","saltmine","name","win-wall","branchName","main","version","path","frontend/index.html","project",{"_36":289,"_13":14,"_38":290,"_49":-5,"_291":51,"_52":53,"_292":53,"_293":294,"_295":-5,"_296":297,"_298":89,"_299":71,"_300":-5,"_301":-5,"_302":110,"_56":303,"_304":305,"_306":307,"_308":309,"_310":-5,"_311":312,"_313":312,"_314":315,"_316":315,"_317":315,"_318":312,"_319":312,"_320":321,"_322":323,"_324":325,"_50":51},"tree",[81,82,83,84,85,86],"file",{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":72,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_18":79},"contents",[],"upstream",{"_36":37,"_38":39,"_40":41,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"pull","ahead",24,"behind",3,"envVars","id","961078ea-f528-11ef-aa68-569c3dd06744","createdAt",["D",1740674013689],"updatedAt",["D",1785420707976],"projectId","96102714-f528-11ef-aa68-569c3dd06744",91,"forkedBranchId","forkedBranchVersion","lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","deletedAt","isOwned",false,"privacy","public","userHandle","templates","orgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","react-hono-starter","c3f42714-39b2-11f1-bce1-42b51c65c3df","index.html","fileId","019d9721-9e2a-7242-a257-c26e1cb41fa6","parentId","019d9721-9e2a-7242-a257-cae5df2ff1b8","branchId","a4af7710-39b1-11f1-84e8-42b51c65c3df","branchVersion",20,"latest",true,["D",1776357537924],2,"fileType","content","\n\n \n \n \n Win Wall\n \n \n \n \n

\n \n \n \n","deleted","label",[80,61],"frontend",{"_36":273,"_13":274,"_62":275,"_64":-5,"_66":67,"_68":276,"_70":71,"_38":277,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":278,"_18":279},{"_36":258,"_13":259,"_62":260,"_64":-5,"_66":67,"_68":34,"_70":71,"_38":261,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":262,"_18":263},{"_36":124,"_13":80,"_62":65,"_64":-5,"_66":67,"_68":102,"_70":71,"_38":125,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":126,"_18":127},{"_36":106,"_13":107,"_62":108,"_64":-5,"_66":67,"_68":73,"_70":71,"_38":109,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":112,"_18":113},{"_36":97,"_13":98,"_62":99,"_64":-5,"_66":67,"_68":100,"_70":71,"_38":101,"_17":102,"_74":24,"_75":103,"_77":51,"_78":-5,"_94":104,"_18":105},{"_36":87,"_13":88,"_62":89,"_64":-5,"_66":67,"_68":90,"_70":71,"_38":91,"_17":34,"_74":92,"_75":93,"_77":51,"_78":-5,"_94":95,"_18":96},"061faedc-39b4-11f1-a35c-42b51c65c3df","index.ts","019d9721-9e2a-7242-a257-d05dd14e0950",25,["D",1776358078298],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { lastlogin } from \"https://esm.town/v/stevekrouse/lastlogin_safe\";\nimport { Hono } from \"npm:hono\";\nimport testimonialApi from \"./api/testimonials.ts\";\n\nconst ALLOWED_EMAILS = [\n \"steve@val.town\",\n \"jpwilson90@gmail.com\",\n];\n\nconst app = new Hono();\n\n// Serve pages\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/submit\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/admin\", () => serveFile(\"/frontend/index.html\"));\n\n// Auth status endpoint — returns the logged-in email (or null)\napp.get(\"/api/auth/me\", (c) => {\n const email = c.req.header(\"X-LastLogin-Email\") || null;\n const authorized = email ? ALLOWED_EMAILS.includes(email) : false;\n return c.json({ email, authorized });\n});\n\n// Public API routes (no auth needed)\napp.get(\"/api/testimonials/approved\", async (c) => {\n const { getApprovedTestimonials } = await import(\"./database/queries.ts\");\n const testimonials = await getApprovedTestimonials();\n return c.json(testimonials);\n});\n\napp.post(\"/api/testimonials\", async (c) => {\n const { createTestimonial } = await import(\"./database/queries.ts\");\n const body = await c.req.json();\n const { author_name, content } = body;\n if (!author_name?.trim() || !content?.trim()) {\n return c.json({ error: \"Name and testimonial text are required\" }, 400);\n }\n if (content.trim().length > 500) {\n return c.json({ error: \"Testimonial must be 500 characters or fewer\" }, 400);\n }\n const testimonial = await createTestimonial(author_name.trim(), content.trim());\n return c.json(testimonial, 201);\n});\n\n// Admin API routes — require auth\napp.use(\"/api/testimonials/all\", async (c, next) => {\n const email = c.req.header(\"X-LastLogin-Email\");\n if (!email || !ALLOWED_EMAILS.includes(email)) {\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n await next();\n});\n\napp.use(\"/api/testimonials/pending\", async (c, next) => {\n const email = c.req.header(\"X-LastLogin-Email\");\n if (!email || !ALLOWED_EMAILS.includes(email)) {\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n await next();\n});\n\napp.use(\"/api/testimonials/:id/*\", async (c, next) => {\n if (c.req.method === \"POST\" || c.req.method === \"DELETE\") {\n const email = c.req.header(\"X-LastLogin-Email\");\n if (!email || !ALLOWED_EMAILS.includes(email)) {\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n }\n await next();\n});\n\n// Mount the testimonial API for the remaining routes\napp.route(\"/api/testimonials\", testimonialApi);\n\n// Serve all frontend files (JS, CSS, etc.)\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\n// Wrap with lastlogin — it adds X-LastLogin-Email header if user has a session,\n// but doesn't force login. Only /auth/* routes trigger the login flow.\nexport default lastlogin(app.fetch);\n","children",[],[88],"cb6df4c0-39b2-11f1-bce1-42b51c65c3df","README.md","019d9721-9e2a-7242-a257-ce28489f7d98",21,["D",1776357550499],1,"# 🏆 Win Wall\n\nA wall of testimonials / wins. People can submit testimonials, an admin can approve or reject them, and approved ones appear on the public wall.\n\n## Pages\n\n- **`/`** — Public win wall showing approved testimonials\n- **`/submit`** — Form for anyone to submit a testimonial\n- **`/admin`** — Admin panel to approve, reject, or delete testimonials\n\n## Architecture\n\n```mermaid\ngraph TD\n A[index.ts - Hono Server] --> B[API Routes]\n A --> C[Frontend SPA]\n B --> D[database/queries.ts]\n D --> E[(SQLite)]\n C --> F[WallPage]\n C --> G[SubmitPage]\n C --> H[AdminPage]\n F --> I[TestimonialCard]\n H --> J[AdminCard]\n```\n\n## Project Structure\n\n```\nindex.ts — Hono HTTP server (entrypoint)\napi/\n testimonials.ts — REST API routes\ndatabase/\n queries.ts — SQLite query functions\nshared/\n types.ts — TypeScript types shared between frontend & backend\nfrontend/\n index.html — HTML shell\n index.tsx — React entry point\n api.ts — Client-side API helpers\n hooks/\n useRoute.ts — Simple client-side router hook\n components/\n App.tsx — Root component with routing\n Nav.tsx — Navigation bar\n TestimonialCard.tsx — Card for the public wall\n AdminCard.tsx — Card with approve/reject/delete actions\n pages/\n WallPage.tsx — Public testimonials wall\n SubmitPage.tsx — Submission form\n AdminPage.tsx — Admin management panel\n```\n",[],[98],"692dbe62-39b2-11f1-99b3-42b51c65c3df","shared","692dbf16-39b2-11f1-99b3-42b51c65c3df",["D",1776357385665],0,"directory",[114],[107],{"_36":115,"_13":116,"_62":117,"_64":108,"_66":67,"_68":118,"_70":71,"_38":119,"_17":110,"_74":120,"_75":121,"_77":51,"_78":-5,"_94":122,"_18":123},"6c7dc35a-39b2-11f1-a6f1-42b51c65c3df","types.ts","6c7dc40e-39b2-11f1-a6f1-42b51c65c3df",4,["D",1776357391208],"script","export interface Testimonial {\n id: number;\n author_name: string;\n content: string;\n status: \"pending\" | \"approved\" | \"rejected\";\n created_at: string;\n approved_at: string | null;\n}\n\nexport interface SubmitTestimonialRequest {\n author_name: string;\n content: string;\n}\n",[],[107,116],"a4d9f774-39b1-11f1-84e8-42b51c65c3df",["D",1776357055926],[128,129,130,131,132,133,134],[80],{"_36":208,"_13":209,"_62":210,"_64":65,"_66":67,"_68":102,"_70":71,"_38":211,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":212,"_18":213},{"_36":193,"_13":194,"_62":195,"_64":65,"_66":67,"_68":196,"_70":71,"_38":197,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":198,"_18":199},{"_36":160,"_13":161,"_62":162,"_64":65,"_66":67,"_68":163,"_70":71,"_38":164,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":165,"_18":166},{"_36":152,"_13":153,"_62":154,"_64":65,"_66":67,"_68":155,"_70":71,"_38":156,"_17":102,"_74":120,"_75":157,"_77":51,"_78":-5,"_94":158,"_18":159},{"_36":145,"_13":146,"_62":147,"_64":65,"_66":67,"_68":102,"_70":71,"_38":148,"_17":110,"_74":24,"_75":149,"_77":51,"_78":-5,"_94":150,"_18":151},{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":142,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_94":143,"_18":144},{"_36":135,"_13":136,"_62":137,"_64":65,"_66":67,"_68":102,"_70":71,"_38":138,"_17":110,"_74":120,"_75":139,"_77":51,"_78":-5,"_94":140,"_18":141},"a4b605a8-39b1-11f1-84e8-42b51c65c3df","index.tsx","019d9721-9e2a-7242-a257-c737246aa74a",["D",1776357055926],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[80,136],["D",1776357537924],[],[80,61],"a4b5f9c8-39b1-11f1-84e8-42b51c65c3df","favicon.svg","019d9721-9e2a-7242-a257-bf26622e28b1",["D",1776357055926],"\n",[],[80,146],"93fa841c-39b3-11f1-86dc-42b51c65c3df","api.ts","862b0f6a-39b2-11f1-bce1-42b51c65c3df",23,["D",1776357886966],"import type { Testimonial, SubmitTestimonialRequest } from \"../shared/types.ts\";\n\nexport async function fetchAuthMe(): Promise<{ email: string | null; authorized: boolean }> {\n const res = await fetch(\"/api/auth/me\");\n return res.json();\n}\n\nexport async function fetchApproved(): Promise {\n const res = await fetch(\"/api/testimonials/approved\");\n return res.json();\n}\n\nexport async function fetchAll(): Promise {\n const res = await fetch(\"/api/testimonials/all\");\n return res.json();\n}\n\nexport async function fetchPending(): Promise {\n const res = await fetch(\"/api/testimonials/pending\");\n return res.json();\n}\n\nexport async function submitTestimonial(data: SubmitTestimonialRequest): Promise {\n const res = await fetch(\"/api/testimonials\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(data),\n });\n if (!res.ok) {\n const err = await res.json();\n throw new Error(err.error || \"Failed to submit\");\n }\n return res.json();\n}\n\nexport async function approveTestimonial(id: number): Promise {\n const res = await fetch(`/api/testimonials/${id}/approve`, { method: \"POST\" });\n return res.json();\n}\n\nexport async function rejectTestimonial(id: number): Promise {\n const res = await fetch(`/api/testimonials/${id}/reject`, { method: \"POST\" });\n return res.json();\n}\n\nexport async function deleteTestimonial(id: number): Promise {\n await fetch(`/api/testimonials/${id}`, { method: \"DELETE\" });\n}\n",[],[80,153],"80838628-39b2-11f1-ad0c-42b51c65c3df","pages","808386c8-39b2-11f1-ad0c-42b51c65c3df",9,["D",1776357424788],[167,168,169],[80,161],{"_36":186,"_13":187,"_62":188,"_64":162,"_66":67,"_68":32,"_70":71,"_38":189,"_17":102,"_74":120,"_75":190,"_77":51,"_78":-5,"_94":191,"_18":192},{"_36":178,"_13":179,"_62":180,"_64":162,"_66":67,"_68":181,"_70":71,"_38":182,"_17":110,"_74":120,"_75":183,"_77":51,"_78":-5,"_94":184,"_18":185},{"_36":170,"_13":171,"_62":172,"_64":162,"_66":67,"_68":173,"_70":71,"_38":174,"_17":110,"_74":120,"_75":175,"_77":51,"_78":-5,"_94":176,"_18":177},"93564c68-39b2-11f1-bce1-42b51c65c3df","WallPage.tsx","93564d4e-39b2-11f1-bce1-42b51c65c3df",14,["D",1776357456398],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { fetchApproved } from \"../api.ts\";\nimport { TestimonialCard } from \"../components/TestimonialCard.tsx\";\nimport type { Testimonial } from \"../../shared/types.ts\";\n\nexport function WallPage() {\n const [testimonials, setTestimonials] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n fetchApproved()\n .then(setTestimonials)\n .finally(() => setLoading(false));\n }, []);\n\n return (\n

🏆 Win Wall

Real wins from real people

\n\n {loading ? (\n

\n ) : testimonials.length === 0 ? (\n

No testimonials yet.

Be the first to share a win!

\n ) : (\n

\n {testimonials.map((t) => (\n \n ))}\n

\n )}\n

\n );\n}\n",[],[80,161,171],"a03634ac-39b2-11f1-9973-42b51c65c3df","SubmitPage.tsx","a0363556-39b2-11f1-9973-42b51c65c3df",16,["D",1776357477978],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { submitTestimonial } from \"../api.ts\";\n\ninterface Props {\n onNavigate: (path: string) => void;\n}\n\nexport function SubmitPage({ onNavigate }: Props) {\n const [authorName, setAuthorName] = useState(\"\");\n const [content, setContent] = useState(\"\");\n const [submitting, setSubmitting] = useState(false);\n const [success, setSuccess] = useState(false);\n const [error, setError] = useState(\"\");\n\n const charCount = content.length;\n const maxChars = 500;\n\n async function handleSubmit(e: Event) {\n e.preventDefault();\n setError(\"\");\n setSubmitting(true);\n\n try {\n await submitTestimonial({ author_name: authorName, content });\n setSuccess(true);\n setAuthorName(\"\");\n setContent(\"\");\n } catch (err: any) {\n setError(err.message);\n } finally {\n setSubmitting(false);\n }\n }\n\n if (success) {\n return (\n

🎉

Thanks for sharing!

Your testimonial is pending review and will appear on the wall once approved.

\n setSuccess(false)}\n class=\"px-4 py-2 bg-indigo-600 text-white rounded-lg hover:bg-indigo-700 transition-colors text-sm font-medium\"\n >\n Submit another\n \n onNavigate(\"/\")}\n class=\"px-4 py-2 bg-gray-100 text-gray-700 rounded-lg hover:bg-gray-200 transition-colors text-sm font-medium\"\n >\n View the wall\n \n

\n );\n }\n\n return (\n

✍️ Share a Win

Tell us about something great that happened

\n\n

\n Your name\n setAuthorName(e.target.value)}\n placeholder=\"Jane Doe\"\n required\n class=\"w-full px-3 py-2 border border-gray-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-indigo-500 focus:border-transparent\"\n />\n

\n\n

\n Your win\n setContent(e.target.value)}\n placeholder=\"Tell us what happened...\"\n required\n rows={4}\n maxLength={maxChars}\n class=\"w-full px-3 py-2 border border-gray-300 rounded-lg text-sm focus:outline-none focus:ring-2 focus:ring-indigo-500 focus:border-transparent resize-none\"\n />\n

maxChars * 0.9 ? \"text-orange-500\" : \"text-gray-400\"}`}>\n {charCount}/{maxChars}\n

\n\n {error && (\n

{error}

\n )}\n\n \n {submitting ? \"Submitting...\" : \"Submit Testimonial\"}\n \n \n

\n );\n}\n",[],[80,161,179],"a12681cc-39b3-11f1-82d2-42b51c65c3df","AdminPage.tsx","ac8c9b38-39b2-11f1-9525-42b51c65c3df",["D",1776357909064],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport {\n fetchAll,\n fetchAuthMe,\n approveTestimonial,\n rejectTestimonial,\n deleteTestimonial,\n} from \"../api.ts\";\nimport { AdminCard } from \"../components/AdminCard.tsx\";\nimport { LoginWithGoogleButton } from \"https://esm.town/v/stevekrouse/LoginWithGoogleButton\";\nimport type { Testimonial } from \"../../shared/types.ts\";\n\ntype Filter = \"all\" | \"pending\" | \"approved\" | \"rejected\";\n\nexport function AdminPage() {\n const [authState, setAuthState] = useState<{\n loading: boolean;\n email: string | null;\n authorized: boolean;\n }>({ loading: true, email: null, authorized: false });\n\n const [testimonials, setTestimonials] = useState([]);\n const [loading, setLoading] = useState(true);\n const [filter, setFilter] = useState(\"pending\");\n\n useEffect(() => {\n fetchAuthMe().then((data) => {\n setAuthState({ loading: false, email: data.email, authorized: data.authorized });\n });\n }, []);\n\n function loadTestimonials() {\n setLoading(true);\n fetchAll()\n .then(setTestimonials)\n .finally(() => setLoading(false));\n }\n\n useEffect(() => {\n if (authState.authorized) {\n loadTestimonials();\n }\n }, [authState.authorized]);\n\n async function handleApprove(id: number) {\n const updated = await approveTestimonial(id);\n setTestimonials((prev) => prev.map((t) => (t.id === id ? updated : t)));\n }\n\n async function handleReject(id: number) {\n const updated = await rejectTestimonial(id);\n setTestimonials((prev) => prev.map((t) => (t.id === id ? updated : t)));\n }\n\n async function handleDelete(id: number) {\n await deleteTestimonial(id);\n setTestimonials((prev) => prev.filter((t) => t.id !== id));\n }\n\n // Loading auth state\n if (authState.loading) {\n return

;\n }\n\n // Not logged in — show Google login button\n if (!authState.email) {\n return (\n

🔒 Admin

\n \n

\n via{\" \"}\n \n LastLogin\n \n

\n );\n }\n\n // Logged in but not authorized\n if (!authState.authorized) {\n return (\n

🚫 Access Denied

\n Signed in as {authState.email}\n

You don't have permission to access this page.

\n \n Sign out\n \n

\n );\n }\n\n // Authorized — show admin panel\n const filtered = filter === \"all\" ? testimonials : testimonials.filter((t) => t.status === filter);\n\n const counts = {\n all: testimonials.length,\n pending: testimonials.filter((t) => t.status === \"pending\").length,\n approved: testimonials.filter((t) => t.status === \"approved\").length,\n rejected: testimonials.filter((t) => t.status === \"rejected\").length,\n };\n\n const filters: { key: Filter; label: string }[] = [\n { key: \"pending\", label: `Pending (${counts.pending})` },\n { key: \"approved\", label: `Approved (${counts.approved})` },\n { key: \"rejected\", label: `Rejected (${counts.rejected})` },\n { key: \"all\", label: `All (${counts.all})` },\n ];\n\n return (\n

🔒 Admin

\n Signed in as {authState.email}\n {\" · \"}\n Sign out\n

\n\n

\n {filters.map((f) => (\n setFilter(f.key)}\n class={`px-3 py-1.5 rounded-lg text-sm font-medium transition-colors ${\n filter === f.key\n ? \"bg-indigo-100 text-indigo-700\"\n : \"bg-gray-100 text-gray-600 hover:bg-gray-200\"\n }`}\n >\n {f.label}\n \n ))}\n

\n\n {loading ? (\n

\n ) : filtered.length === 0 ? (\n

No {filter === \"all\" ? \"\" : filter} testimonials

\n ) : (\n

\n {filtered.map((t) => (\n \n ))}\n

\n )}\n

\n );\n}\n",[],[80,161,187],"8e5ea41c-39b2-11f1-bce1-42b51c65c3df","hooks","154fda2d-9941-49f1-990f-5f8a0c9a6fd4",13,["D",1776357448062],[200],[80,194],{"_36":201,"_13":202,"_62":203,"_64":195,"_66":67,"_68":196,"_70":71,"_38":204,"_17":110,"_74":120,"_75":205,"_77":51,"_78":-5,"_94":206,"_18":207},"8e5e9710-39b2-11f1-bce1-42b51c65c3df","useRoute.ts","8e5e97b0-39b2-11f1-bce1-42b51c65c3df",["D",1776357448062],"import { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\n\nexport function useRoute() {\n const [path, setPath] = useState(window.location.pathname);\n\n useEffect(() => {\n const onPop = () => setPath(window.location.pathname);\n window.addEventListener(\"popstate\", onPop);\n return () => window.removeEventListener(\"popstate\", onPop);\n }, []);\n\n const navigate = useCallback((to: string) => {\n window.history.pushState(null, \"\", to);\n setPath(to);\n }, []);\n\n return { path, navigate };\n}\n",[],[80,194,202],"a4b5f70c-39b1-11f1-84e8-42b51c65c3df","components","019d9721-9e2a-7242-a257-bb21027d391b",["D",1776357055926],[214,215,216,217,218],[80,209],{"_36":250,"_13":251,"_62":252,"_64":210,"_66":67,"_68":253,"_70":71,"_38":254,"_17":110,"_74":120,"_75":255,"_77":51,"_78":-5,"_94":256,"_18":257},{"_36":242,"_13":243,"_62":244,"_64":210,"_66":67,"_68":245,"_70":71,"_38":246,"_17":102,"_74":120,"_75":247,"_77":51,"_78":-5,"_94":248,"_18":249},{"_36":235,"_13":236,"_62":237,"_64":210,"_66":67,"_68":102,"_70":71,"_38":238,"_17":110,"_74":120,"_75":239,"_77":51,"_78":-5,"_94":240,"_18":241},{"_36":227,"_13":228,"_62":229,"_64":210,"_66":67,"_68":230,"_70":71,"_38":231,"_17":110,"_74":120,"_75":232,"_77":51,"_78":-5,"_94":233,"_18":234},{"_36":219,"_13":220,"_62":221,"_64":210,"_66":67,"_68":222,"_70":71,"_38":223,"_17":110,"_74":120,"_75":224,"_77":51,"_78":-5,"_94":225,"_18":226},"87e3d5bc-39b2-11f1-afd0-42b51c65c3df","TestimonialCard.tsx","87e3d670-39b2-11f1-afd0-42b51c65c3df",11,["D",1776357437191],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport type { Testimonial } from \"../../shared/types.ts\";\n\ninterface Props {\n testimonial: Testimonial;\n}\n\nexport function TestimonialCard({ testimonial }: Props) {\n const date = new Date(testimonial.created_at).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n\n return (\n

\"{testimonial.content}\"

\n {testimonial.author_name}\n {date}\n

\n );\n}\n",[],[80,209,220],"8d072364-39b2-11f1-a6f1-42b51c65c3df","Nav.tsx","8d07242c-39b2-11f1-a6f1-42b51c65c3df",12,["D",1776357445813],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\ninterface Props {\n currentPath: string;\n onNavigate: (path: string) => void;\n}\n\nexport function Nav({ currentPath, onNavigate }: Props) {\n const links = [\n { path: \"/\", label: \"🏆 Win Wall\" },\n { path: \"/submit\", label: \"✍️ Submit\" },\n { path: \"/admin\", label: \"🔒 Admin\" },\n ];\n\n return (\n

\n {links.map((link) => (\n {\n e.preventDefault();\n onNavigate(link.path);\n }}\n class={`px-4 py-2 rounded-lg text-sm font-medium transition-colors ${\n currentPath === link.path\n ? \"bg-indigo-50 text-indigo-700\"\n : \"text-gray-600 hover:bg-gray-50 hover:text-gray-900\"\n }`}\n >\n {link.label}\n \n ))}\n

\n \n view source\n \n

\n );\n}\n",[],[80,209,228],"a4b5ef46-39b1-11f1-84e8-42b51c65c3df","Counter.tsx","019d9721-9e2a-7242-a257-b503c0040a2c",["D",1776357055926],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[80,209,236],"9517f2ae-39b2-11f1-9525-42b51c65c3df","App.tsx","019d9721-9e2a-7242-a257-b0d2f7557178",15,["D",1776357459318],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Nav } from \"./Nav.tsx\";\nimport { useRoute } from \"../hooks/useRoute.ts\";\nimport { WallPage } from \"../pages/WallPage.tsx\";\nimport { SubmitPage } from \"../pages/SubmitPage.tsx\";\nimport { AdminPage } from \"../pages/AdminPage.tsx\";\n\nexport function App() {\n const { path, navigate } = useRoute();\n\n let page;\n if (path === \"/submit\") {\n page = ;\n } else if (path === \"/admin\") {\n page = ;\n } else {\n page = ;\n }\n\n return (\n

\n );\n}\n",[],[80,209,243],"a4999836-39b2-11f1-bce1-42b51c65c3df","AdminCard.tsx","a4999926-39b2-11f1-bce1-42b51c65c3df",17,["D",1776357485289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport type { Testimonial } from \"../../shared/types.ts\";\n\ninterface Props {\n testimonial: Testimonial;\n onApprove: (id: number) => void;\n onReject: (id: number) => void;\n onDelete: (id: number) => void;\n}\n\nconst statusColors: Record = {\n pending: \"bg-yellow-100 text-yellow-800\",\n approved: \"bg-green-100 text-green-800\",\n rejected: \"bg-red-100 text-red-800\",\n};\n\nexport function AdminCard({ testimonial, onApprove, onReject, onDelete }: Props) {\n const date = new Date(testimonial.created_at).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n });\n\n return (\n

\n {testimonial.author_name}\n \n {testimonial.status}\n \n

\n\n

\"{testimonial.content}\"

\n\n

\n {date}\n

\n {testimonial.status !== \"approved\" && (\n onApprove(testimonial.id)}\n class=\"px-3 py-1 text-xs font-medium bg-green-50 text-green-700 rounded-lg hover:bg-green-100 transition-colors\"\n >\n ✓ Approve\n \n )}\n {testimonial.status !== \"rejected\" && (\n onReject(testimonial.id)}\n class=\"px-3 py-1 text-xs font-medium bg-orange-50 text-orange-700 rounded-lg hover:bg-orange-100 transition-colors\"\n >\n ✗ Reject\n \n )}\n onDelete(testimonial.id)}\n class=\"px-3 py-1 text-xs font-medium bg-red-50 text-red-700 rounded-lg hover:bg-red-100 transition-colors\"\n >\n 🗑 Delete\n \n

\n );\n}\n",[],[80,209,251],"696bec5a-39b2-11f1-99b3-42b51c65c3df","database","696bed18-39b2-11f1-99b3-42b51c65c3df",["D",1776357386070],[264],[259],{"_36":265,"_13":266,"_62":267,"_64":260,"_66":67,"_68":268,"_70":71,"_38":269,"_17":110,"_74":120,"_75":270,"_77":51,"_78":-5,"_94":271,"_18":272},"6fd727ee-39b2-11f1-a6f1-42b51c65c3df","queries.ts","6fd728c0-39b2-11f1-a6f1-42b51c65c3df",5,["D",1776357396838],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Testimonial } from \"../shared/types.ts\";\n\nexport async function getApprovedTestimonials(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM testimonials WHERE status = 'approved' ORDER BY approved_at DESC\",\n );\n return result.rows as unknown as Testimonial[];\n}\n\nexport async function getAllTestimonials(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM testimonials ORDER BY created_at DESC\",\n );\n return result.rows as unknown as Testimonial[];\n}\n\nexport async function getPendingTestimonials(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM testimonials WHERE status = 'pending' ORDER BY created_at DESC\",\n );\n return result.rows as unknown as Testimonial[];\n}\n\nexport async function createTestimonial(authorName: string, content: string): Promise {\n const result = await sqlite.execute({\n sql: \"INSERT INTO testimonials (author_name, content) VALUES (?, ?) RETURNING *\",\n args: [authorName, content],\n });\n return result.rows[0] as unknown as Testimonial;\n}\n\nexport async function approveTestimonial(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"UPDATE testimonials SET status = 'approved', approved_at = datetime('now') WHERE id = ? RETURNING *\",\n args: [id],\n });\n return (result.rows[0] as unknown as Testimonial) ?? null;\n}\n\nexport async function rejectTestimonial(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"UPDATE testimonials SET status = 'rejected' WHERE id = ? RETURNING *\",\n args: [id],\n });\n return (result.rows[0] as unknown as Testimonial) ?? null;\n}\n\nexport async function deleteTestimonial(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"DELETE FROM testimonials WHERE id = ?\",\n args: [id],\n });\n return result.rowsAffected > 0;\n}\n",[],[259,266],"733b9316-39b2-11f1-a6f1-42b51c65c3df","api","733b942e-39b2-11f1-a6f1-42b51c65c3df",6,["D",1776357402531],[280],[274],{"_36":281,"_13":282,"_62":283,"_64":275,"_66":67,"_68":284,"_70":71,"_38":285,"_17":110,"_74":120,"_75":286,"_77":51,"_78":-5,"_94":287,"_18":288},"790afd0e-39b2-11f1-9973-42b51c65c3df","testimonials.ts","790afdf4-39b2-11f1-9973-42b51c65c3df",7,["D",1776357412276],"import { Hono } from \"npm:hono\";\nimport {\n getApprovedTestimonials,\n getAllTestimonials,\n getPendingTestimonials,\n createTestimonial,\n approveTestimonial,\n rejectTestimonial,\n deleteTestimonial,\n} from \"../database/queries.ts\";\n\nconst api = new Hono();\n\n// Public: get approved testimonials for the wall\napi.get(\"/approved\", async (c) => {\n const testimonials = await getApprovedTestimonials();\n return c.json(testimonials);\n});\n\n// Admin: get all testimonials\napi.get(\"/all\", async (c) => {\n const testimonials = await getAllTestimonials();\n return c.json(testimonials);\n});\n\n// Admin: get pending testimonials\napi.get(\"/pending\", async (c) => {\n const testimonials = await getPendingTestimonials();\n return c.json(testimonials);\n});\n\n// Public: submit a new testimonial\napi.post(\"/\", async (c) => {\n const body = await c.req.json();\n const { author_name, content } = body;\n\n if (!author_name?.trim() || !content?.trim()) {\n return c.json({ error: \"Name and testimonial text are required\" }, 400);\n }\n\n if (content.trim().length > 500) {\n return c.json({ error: \"Testimonial must be 500 characters or fewer\" }, 400);\n }\n\n const testimonial = await createTestimonial(author_name.trim(), content.trim());\n return c.json(testimonial, 201);\n});\n\n// Admin: approve a testimonial\napi.post(\"/:id/approve\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const testimonial = await approveTestimonial(id);\n if (!testimonial) return c.json({ error: \"Not found\" }, 404);\n return c.json(testimonial);\n});\n\n// Admin: reject a testimonial\napi.post(\"/:id/reject\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const testimonial = await rejectTestimonial(id);\n if (!testimonial) return c.json({ error: \"Not found\" }, 404);\n return c.json(testimonial);\n});\n\n// Admin: delete a testimonial\napi.delete(\"/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const deleted = await deleteTestimonial(id);\n if (!deleted) return c.json({ error: \"Not found\" }, 404);\n return c.json({ ok: true });\n});\n\nexport default api;\n",[],[274,282],"a4a85c00-39b1-11f1-84e8-42b51c65c3df",["D",1776357055926],"legacyEnvVars","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","userId","f82d7dbb-2899-430f-8e34-4c8688c5bdad","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019d9718-b2f5-70df-aa7f-b4e7ee91e025","tursoName","a4a85c0039b111f184e842b51c65c3df","tursoHostname","a4a85c0039b111f184e842b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789506093912],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_336":332},"org",{"_11":12,"_330":-5,"_331":332,"_296":-5,"_333":334,"_335":71},"branch",{"_17":90,"_13":16,"_36":67,"_42":289,"_45":37,"_46":326,"_327":53,"_328":43,"_329":57,"_58":14,"_54":12},88,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/b87e7fbf-eb13-44a9-847a-14d2be1c5a00/square512?exp=1789563599&sig=89408fdeee757e6f15c164eae1950c8eb517a97fbd9664f807384dec016373c6","tier","business","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":289,"_13":14,"_38":448,"_49":-5,"_291":51,"_52":53,"_292":53,"_293":294,"_295":-5,"_296":297,"_298":89,"_299":71,"_300":-5,"_301":-5,"_302":110,"_56":303,"_304":305,"_306":307,"_308":449,"_310":-5,"_311":312,"_313":312,"_314":315,"_316":315,"_317":315,"_318":312,"_319":312,"_320":450,"_322":451,"_324":452,"_50":51},[373,375,377,394,396,397],"files",[373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397],"counts",{"_364":110,"_365":102,"_366":110,"_35":367,"_368":369},[],{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":72,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_18":363},"upstreamProject",{"_36":43,"_13":59,"_293":294,"_295":360,"_52":53,"_320":361},"upstreamBranch",{"_36":37,"_38":358,"_40":359,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],["D",1785420707976],"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789563599&sig=c3b06339283e4bc07165fa54c09036aa25cea7ac6108dec2f68b1acc60fad95f",{"_11":55,"_336":362},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789563599&sig=a969511699ef574c42d646a130422bcd8ffa020e1e59bd8fb5bde6db2cea72c1",[80,61],"pulls","branches","forks",{"_370":110,"_372":110},"connections",{"_370":110,"_371":110},"count","unfilledCount","emptyCount",{"_36":273,"_13":274,"_62":275,"_64":-5,"_66":67,"_68":276,"_70":71,"_38":277,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":446,"_18":447},{"_36":281,"_13":282,"_62":283,"_64":275,"_66":67,"_68":284,"_70":71,"_38":285,"_17":110,"_74":120,"_75":286,"_77":51,"_78":-5,"_94":444,"_18":445},{"_36":258,"_13":259,"_62":260,"_64":-5,"_66":67,"_68":34,"_70":71,"_38":261,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":442,"_18":443},{"_36":265,"_13":266,"_62":267,"_64":260,"_66":67,"_68":268,"_70":71,"_38":269,"_17":110,"_74":120,"_75":270,"_77":51,"_78":-5,"_94":440,"_18":441},{"_36":124,"_13":80,"_62":65,"_64":-5,"_66":67,"_68":102,"_70":71,"_38":125,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":438,"_18":439},{"_36":208,"_13":209,"_62":210,"_64":65,"_66":67,"_68":102,"_70":71,"_38":211,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":436,"_18":437},{"_36":250,"_13":251,"_62":252,"_64":210,"_66":67,"_68":253,"_70":71,"_38":254,"_17":110,"_74":120,"_75":255,"_77":51,"_78":-5,"_94":434,"_18":435},{"_36":242,"_13":243,"_62":244,"_64":210,"_66":67,"_68":245,"_70":71,"_38":246,"_17":102,"_74":120,"_75":247,"_77":51,"_78":-5,"_94":432,"_18":433},{"_36":235,"_13":236,"_62":237,"_64":210,"_66":67,"_68":102,"_70":71,"_38":238,"_17":110,"_74":120,"_75":239,"_77":51,"_78":-5,"_94":430,"_18":431},{"_36":227,"_13":228,"_62":229,"_64":210,"_66":67,"_68":230,"_70":71,"_38":231,"_17":110,"_74":120,"_75":232,"_77":51,"_78":-5,"_94":428,"_18":429},{"_36":219,"_13":220,"_62":221,"_64":210,"_66":67,"_68":222,"_70":71,"_38":223,"_17":110,"_74":120,"_75":224,"_77":51,"_78":-5,"_94":426,"_18":427},{"_36":193,"_13":194,"_62":195,"_64":65,"_66":67,"_68":196,"_70":71,"_38":197,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":424,"_18":425},{"_36":201,"_13":202,"_62":203,"_64":195,"_66":67,"_68":196,"_70":71,"_38":204,"_17":110,"_74":120,"_75":205,"_77":51,"_78":-5,"_94":422,"_18":423},{"_36":160,"_13":161,"_62":162,"_64":65,"_66":67,"_68":163,"_70":71,"_38":164,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":420,"_18":421},{"_36":186,"_13":187,"_62":188,"_64":162,"_66":67,"_68":32,"_70":71,"_38":189,"_17":102,"_74":120,"_75":190,"_77":51,"_78":-5,"_94":418,"_18":419},{"_36":178,"_13":179,"_62":180,"_64":162,"_66":67,"_68":181,"_70":71,"_38":182,"_17":110,"_74":120,"_75":183,"_77":51,"_78":-5,"_94":416,"_18":417},{"_36":170,"_13":171,"_62":172,"_64":162,"_66":67,"_68":173,"_70":71,"_38":174,"_17":110,"_74":120,"_75":175,"_77":51,"_78":-5,"_94":414,"_18":415},{"_36":152,"_13":153,"_62":154,"_64":65,"_66":67,"_68":155,"_70":71,"_38":156,"_17":102,"_74":120,"_75":157,"_77":51,"_78":-5,"_94":412,"_18":413},{"_36":145,"_13":146,"_62":147,"_64":65,"_66":67,"_68":102,"_70":71,"_38":148,"_17":110,"_74":24,"_75":149,"_77":51,"_78":-5,"_94":410,"_18":411},{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":142,"_17":73,"_74":24,"_75":76,"_77":51,"_78":-5,"_94":408,"_18":409},{"_36":135,"_13":136,"_62":137,"_64":65,"_66":67,"_68":102,"_70":71,"_38":138,"_17":110,"_74":120,"_75":139,"_77":51,"_78":-5,"_94":406,"_18":407},{"_36":106,"_13":107,"_62":108,"_64":-5,"_66":67,"_68":73,"_70":71,"_38":109,"_17":110,"_74":111,"_75":-5,"_77":51,"_78":-5,"_94":404,"_18":405},{"_36":115,"_13":116,"_62":117,"_64":108,"_66":67,"_68":118,"_70":71,"_38":119,"_17":110,"_74":120,"_75":121,"_77":51,"_78":-5,"_94":402,"_18":403},{"_36":97,"_13":98,"_62":99,"_64":-5,"_66":67,"_68":100,"_70":71,"_38":101,"_17":102,"_74":24,"_75":103,"_77":51,"_78":-5,"_94":400,"_18":401},{"_36":87,"_13":88,"_62":89,"_64":-5,"_66":67,"_68":90,"_70":71,"_38":91,"_17":34,"_74":92,"_75":93,"_77":51,"_78":-5,"_94":398,"_18":399},[],[88],[],[98],[],[107,116],[395],[107],[],[80,136],[],[80,61],[],[80,146],[],[80,153],[],[80,161,171],[],[80,161,179],[],[80,161,187],[387,388,389],[80,161],[],[80,194,202],[385],[80,194],[],[80,209,220],[],[80,209,228],[],[80,209,236],[],[80,209,243],[],[80,209,251],[379,380,381,382,383],[80,209],[378,384,386,390,391,392,393],[80],[],[259,266],[376],[259],[],[274,282],[374],[274],["D",1776357055926],["D",1789506093912],{"_11":12,"_336":332},{"_11":12,"_330":-5,"_331":332,"_296":-5,"_333":334,"_335":71},{"_17":90,"_13":16,"_36":67,"_42":289,"_45":37,"_46":326,"_327":53,"_328":43,"_329":57,"_58":14,"_54":12},"ctx",{"_320":-5,"_355":486,"_487":488,"_489":490,"_491":51,"_492":51,"_493":51,"_494":71,"_495":-5,"_496":-7,"_497":-7,"_498":110,"_499":51,"_500":51,"_501":-5,"_502":51,"_503":51,"_504":51,"_505":-5},"ENV",{"_457":458,"_459":460,"_461":16,"_462":463,"_464":465,"_466":467,"_468":469,"_470":471,"_472":473,"_474":475,"_476":477,"_478":479,"_480":481,"_482":483,"_484":485},"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"]