Hi ${name}! Pick a difficulty:

\n \n
\n \n `;\n}\n\nasync function getStats(name: string): Promise {\n const rows = await sqlite.execute({\n sql: `\n SELECT\n difficulty,\n COUNT(*) as games,\n SUM(won) as wins,\n ROUND(AVG(CASE WHEN won=1 THEN attempts END), 1) as avg_attempts_to_win\n FROM game_results\n WHERE name = ?\n GROUP BY difficulty\n ORDER BY CASE difficulty WHEN 'easy' THEN 1 WHEN 'hard' THEN 2 WHEN 'extreme' THEN 3 END\n `,\n args: [name],\n });\n\n if (rows.rows.length === 0) {\n return `

No games played yet, ${name}!

`;\n }\n\n const tableRows = rows.rows.map((r) => {\n const d = DIFFICULTIES[r.difficulty as Difficulty];\n const winRate = Math.round((Number(r.wins) / Number(r.games)) * 100);\n const avg = r.avg_attempts_to_win ?? \"—\";\n const lastCol = r.difficulty === \"extreme\"\n ? `—
(always 1)`\n : `${avg}`;\n return `\n \n ${d.emoji} ${d.label}\n ${r.games}\n ${r.wins}\n ${winRate}%\n ${lastCol}\n \n `;\n }).join(\"\");\n\n return `\n \n \n \n \n \n \n \n \n \n \n \n ${tableRows}\n \n

Difficulty	Games	Wins	Win %	Avg attempts to win

* Extreme always requires exactly 1 attempt to win, so avg is not shown.

\n `;\n}\n\nfunction endButtons(name: string, difficulty: Difficulty): string {\n return `\n

\n \n \n \n

\n `;\n}\n\nexport default async function (req: Request): Promise {\n if (req.method === \"POST\") {\n const form = await req.formData();\n const step = form.get(\"step\") as string;\n\n // Step 1: Name submitted → pick difficulty\n if (step === \"name\") {\n const name = (form.get(\"name\") as string)?.trim() || \"Player\";\n return new Response(\n renderPage(name, difficultyPicker(name)),\n { headers: { \"Content-Type\": \"text/html\" } }\n );\n }\n\n // Stats page\n if (step === \"stats\") {\n const name = form.get(\"name\") as string;\n const stats = await getStats(name);\n return new Response(\n renderPage(name, `\n

📊 ${name}'s Stats

\n ${stats}\n
\n \n `),\n { headers: { \"Content-Type\": \"text/html\" } }\n );\n }\n\n // Replay same difficulty\n if (step === \"replay\") {\n const name = form.get(\"name\") as string;\n const difficulty = (form.get(\"difficulty\") as Difficulty) ?? \"easy\";\n const secret = Math.floor(Math.random() * 10) + 1;\n return new Response(\n renderPage(name, guessForm(name, secret, 1, \"\", difficulty)),\n { headers: { \"Content-Type\": \"text/html\" } }\n );\n }\n\n // Step 2: Difficulty chosen → start game\n if (step === \"difficulty\") {\n const name = form.get(\"name\") as string;\n const difficulty = (form.get(\"difficulty\") as Difficulty) ?? \"easy\";\n const secret = Math.floor(Math.random() * 10) + 1;\n return new Response(\n renderPage(name, guessForm(name, secret, 1, \"\", difficulty)),\n { headers: { \"Content-Type\": \"text/html\" } }\n );\n }\n\n // Step 3: A guess was submitted\n if (step === \"guess\") {\n const name = form.get(\"name\") as string;\n const secret = Number(form.get(\"secret\"));\n const guess = Number(form.get(\"guess\"));\n const attempt = Number(form.get(\"attempt\"));\n const difficulty = (form.get(\"difficulty\") as Difficulty) ?? \"easy\";\n const { maxAttempts, emoji } = DIFFICULTIES[difficulty];\n\n if (guess === secret) {\n await sqlite.execute({\n sql: `INSERT INTO game_results (name, difficulty, won, attempts, played_at) VALUES (?, ?, 1, ?, ?)`,\n args: [name, difficulty, attempt, new Date().toISOString()],\n });\n return new Response(\n renderPage(name, `\n

🎉 Yes, ${name}! The number was ${secret}!

You got it on attempt ${attempt} of ${maxAttempts}! ${emoji}

\n ${endButtons(name, difficulty)}\n `),\n { headers: { \"Content-Type\": \"text/html\" } }\n );\n }\n\n const hint = guess < secret ? \"📈 Higher!\" : \"📉 Lower!\";\n\n if (attempt >= maxAttempts) {\n await sqlite.execute({\n sql: `INSERT INTO game_results (name, difficulty, won, attempts, played_at) VALUES (?, ?, 0, ?, ?)`,\n args: [name, difficulty, attempt, new Date().toISOString()],\n });\n return new Response(\n renderPage(name, `\n

❌ Out of guesses, ${name}!

The number was ${secret}.

\n ${endButtons(name, difficulty)}\n `),\n { headers: { \"Content-Type\": \"text/html\" } }\n );\n }\n\n return new Response(\n renderPage(name, guessForm(name, secret, attempt + 1, hint, difficulty)),\n { headers: { \"Content-Type\": \"text/html\" } }\n );\n }\n }\n\n // Step 0: Ask for name\n return new Response(\n renderPage(\"\", `\n

What's your name?

\n \n `),\n { headers: { \"Content-Type\": \"text/html\" } }\n );\n}\n\nfunction guessForm(name: string, secret: number, attempt: number, hint: string, difficulty: Difficulty): string {\n const { maxAttempts, emoji, label } = DIFFICULTIES[difficulty];\n const attemptsLeft = maxAttempts - attempt + 1;\n return `\n ${hint ? `

${hint}

` : \"\"}\n

Guess a number between 1 and 10

${emoji} ${label} — Attempt ${attempt} of ${maxAttempts} (${attemptsLeft} left)

\n \n `;\n}\n\nfunction renderPage(name: string, body: string): string {\n return `\n\n\n Number Guessing Game\n \n\n\n

🔢 Guess the Number

\n ${name ? `

Playing as: ${name}

` : \"\"}\n ${body}\n\n`;\n}\n","deleted","label",[102],"permalink","https://www.val.town/x/Heliopolis10E00/untitled-1129/code/main.ts","extension","actionData","errors"]