🧝 ${game.character.name}

❤️

${game.character.hp}/${game.character.maxHp}

💰

${game.character.gold} gold

⭐

Level ${game.character.level}

⚔️

${game.character.attack} ATK / ${game.character.defense} DEF

\n Round: ${game.roundNumber} | \n Poll Active: ${game.pollMessageId ? \"✅ Yes\" : \"❌ No\"} |\n Status: ${game.isActive ? \"🟢 Active\" : \"🔴 Ended\"}\n

\n ${game.lastOutcome ? `

📜 Last: ${game.lastOutcome}

` : \"\"}\n

`\n : `

\n No active game. Start one below!\n

`;\n\n return c.html(`\n\n\n \n \n ⚔️ Discord RPG Bot\n \n\n\n

\n ⚔️ Discord RPG Quest\n

A community-driven RPG where Discord polls decide the hero's fate!

\n\n ${characterHtml}\n\n \n

\n \n \n \n \n 📝 View Source\n \n

\n\n \n ${logHtml ? `\n

📜 Adventure Log

${logHtml}

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

🔧 How It Works

Start a Game — creates a hero and sends the first scenario poll to your Discord channel
Discord Poll — community members vote on what the hero should do (1 hour duration)
Auto-Check — every hour, a cron job reads the poll results
Resolve & Advance — the winning choice becomes the hero's action, stats update, next scenario is sent
Game Over — if HP hits 0, the hero dies! Start a new adventure!

\n Setup: Set these env vars in Val Town:
\n • DISCORD_WEBHOOK_URL — your channel's webhook URL
\n • DISCORD_BOT_TOKEN — bot token to read poll results
\n • DISCORD_CHANNEL_ID — the channel where polls are sent\n

\n\n

\n Built with Val Town ⚡\n

\n \n\n`);\n});\n\n// API Routes\napp.post(\"/api/new-game\", async (c) => {\n const body = await c.req.parseBody();\n const heroName = (body.heroName as string) || \"Aldric\";\n try {\n const result = await startNewGame(heroName);\n return c.redirect(\"/?msg=\" + encodeURIComponent(result));\n } catch (err) {\n return c.redirect(\"/?err=\" + encodeURIComponent(String(err)));\n }\n});\n\napp.post(\"/api/check-poll\", async (c) => {\n try {\n const result = await checkPollAndAdvance();\n return c.redirect(\"/?msg=\" + encodeURIComponent(result));\n } catch (err) {\n return c.redirect(\"/?err=\" + encodeURIComponent(String(err)));\n }\n});\n\napp.post(\"/api/next-scenario\", async (c) => {\n try {\n const result = await sendNextScenario();\n return c.redirect(\"/?msg=\" + encodeURIComponent(result));\n } catch (err) {\n return c.redirect(\"/?err=\" + encodeURIComponent(String(err)));\n }\n});\n\napp.get(\"/api/state\", async (c) => {\n await runMigrations();\n const game = await getActiveGame();\n return c.json({ game });\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default app.fetch;\n",[],[205],"737c290e-3ccc-11f1-bb2a-42b51c65c3df","README.md","737c29ea-3ccc-11f1-bb2a-42b51c65c3df",9,["D",1776698423361],"# ⚔️ Discord RPG Quest Bot\n\nA community-driven RPG game where **Discord polls** decide the hero's fate! Every hour, a new scenario appears in your Discord channel as a poll. The community votes on what the hero should do, and the winning choice becomes the next action in the story.\n\n## How It Works\n\n```mermaid\ngraph TD\n A[🎮 Start New Game] --> B[📨 Send Scenario Poll to Discord]\n B --> C[🗳️ Community Votes for 1 Hour]\n C --> D[⏰ Cron Job Checks Results]\n D --> E[📊 Read Poll Winner]\n E --> F[🎯 Apply Choice Effects]\n F --> G{❤️ Hero HP > 0?}\n G -->|Yes| B\n G -->|No| H[💀 Game Over!]\n```\n\n## Features\n\n- 🐉 **6 unique scenarios** with 4 choices each (dragon fights, haunted villages, wizard encounters, bandit ambushes, enchanted rivers, skeleton kings)\n- 🗳️ **Native Discord polls** — uses Discord's built-in poll feature, not reactions\n- ⏰ **Automatic progression** — hourly cron job reads results and advances the story\n- 📊 **Character stats** — HP, Gold, XP, Level with progression\n- 📜 **Adventure log** — full history of every round and outcome\n- 🌐 **Web dashboard** — view game state, start games, and manually trigger actions\n\n## Setup\n\n### 1. Create a Discord Webhook\n- Go to your Discord server → Channel Settings → Integrations → Webhooks\n- Create a webhook and copy the URL\n\n### 2. Create a Discord Bot (for reading poll results)\n- Go to [Discord Developer Portal](https://discord.com/developers/applications)\n- Create a new application → Bot → copy the token\n- Enable the bot in your server with `Read Message History` permission\n\n### 3. Set Environment Variables in Val Town\n| Variable | Description |\n|---|---|\n| `DISCORD_WEBHOOK_URL` | Your channel's webhook URL |\n| `DISCORD_BOT_TOKEN` | Bot token for reading poll results |\n| `DISCORD_CHANNEL_ID` | The channel ID where polls are sent |\n\n### 4. Start Playing!\n- Visit the web dashboard and click **🎮 New Game**\n- The bot sends a scenario + poll to Discord\n- Your community votes!\n- Every hour, results are checked and the story advances\n\n## Architecture\n\n| File | Purpose |\n|---|---|\n| `main.ts` | HTTP dashboard & API (Hono) |\n| `poll-checker.ts` | Hourly cron job to read polls & advance game |\n| `game/engine.ts` | Core game logic |\n| `discord/webhook.ts` | Discord webhook & API integration |\n| `shared/scenarios.ts` | RPG scenarios and character creation |\n| `shared/types.ts` | TypeScript types |\n| `database/migrations.ts` | SQLite schema |\n| `database/queries.ts` | Database operations |\n",[],[213],"07409874-3ccc-11f1-a775-42b51c65c3df","types.ts","07409982-3ccc-11f1-a775-42b51c65c3df","107f191a-e40d-4c02-8559-1b3141df7c96",["D",1776698241770],"// RPG Game Types\n\nexport interface Character {\n name: string;\n hp: number;\n maxHp: number;\n attack: number;\n defense: number;\n gold: number;\n level: number;\n xp: number;\n}\n\nexport interface Choice {\n emoji: string;\n text: string;\n outcome: string;\n hpChange: number;\n goldChange: number;\n xpChange: number;\n}\n\nexport interface Scenario {\n title: string;\n description: string;\n choices: Choice[];\n}\n\nexport interface GameState {\n id: number;\n character: Character;\n currentScenario: Scenario | null;\n pollMessageId: string | null;\n pollSentAt: string | null;\n lastOutcome: string | null;\n roundNumber: number;\n isActive: boolean;\n}\n",[],[228,221],"shared","27c2dc56-3ccc-11f1-855f-42b51c65c3df","scenarios.ts","27c2dcf6-3ccc-11f1-855f-42b51c65c3df",2,["D",1776698296314],"import type { Scenario } from \"./types.ts\";\n\n// Pool of scenarios the hero can encounter\nconst ALL_SCENARIOS: Scenario[] = [\n {\n title: \"🐉 A Dragon Blocks the Path\",\n description:\n \"A massive red dragon descends from the sky, its scales gleaming like molten lava. It eyes your hero hungrily. The ground trembles with each beat of its wings.\",\n choices: [\n {\n emoji: \"⚔️\",\n text: \"Charge and fight the dragon!\",\n outcome:\n \"Our hero charges bravely! The dragon breathes fire, but a well-timed dodge and a slash to its underbelly sends it retreating! Victory, but not without burns.\",\n hpChange: -15,\n goldChange: 50,\n xpChange: 40,\n },\n {\n emoji: \"🛡️\",\n text: \"Raise your shield and hold ground\",\n outcome:\n \"Our hero plants their feet and raises the shield. The dragon's fire washes over the enchanted metal. Frustrated, the dragon flies off, dropping some gold.\",\n hpChange: -5,\n goldChange: 20,\n xpChange: 15,\n },\n {\n emoji: \"🏃\",\n text: \"Flee into the nearby cave\",\n outcome:\n \"Our hero dives into a narrow cave! The dragon can't follow, but the cave is dark and something else lurks within...\",\n hpChange: 0,\n goldChange: 0,\n xpChange: 5,\n },\n {\n emoji: \"🎵\",\n text: \"Play a soothing melody on your lute\",\n outcome:\n \"Our hero pulls out a lute and plays a haunting melody. The dragon pauses, mesmerized... then curls up and falls asleep! Our hero tiptoes past and loots its hoard!\",\n hpChange: 0,\n goldChange: 80,\n xpChange: 30,\n },\n ],\n },\n {\n title: \"🏚️ The Abandoned Village\",\n description:\n \"Our hero stumbles upon a village shrouded in mist. The houses are empty, doors creaking in the wind. A faint glow emanates from the well in the center of town.\",\n choices: [\n {\n emoji: \"🔦\",\n text: \"Investigate the glowing well\",\n outcome:\n \"Peering into the well, our hero finds a trapped fairy! Freeing her grants a blessing of healing light. The fairy vanishes, but the warmth remains.\",\n hpChange: 25,\n goldChange: 10,\n xpChange: 20,\n },\n {\n emoji: \"🏠\",\n text: \"Search the houses for loot\",\n outcome:\n \"Our hero finds old supplies, some coins hidden under floorboards, and a dusty health potion. Not bad for an abandoned place!\",\n hpChange: 10,\n goldChange: 30,\n xpChange: 10,\n },\n {\n emoji: \"⚠️\",\n text: \"Set up camp and rest here\",\n outcome:\n \"The hero rests, but at midnight, ghost villagers appear! They're not hostile — they share tales of buried treasure nearby before fading at dawn.\",\n hpChange: 15,\n goldChange: 5,\n xpChange: 25,\n },\n {\n emoji: \"🚪\",\n text: \"Leave immediately — it's a trap!\",\n outcome:\n \"Smart move! As our hero backs away, the village shimmers and vanishes — a mirage set by a witch! Our hero narrowly avoids being trapped in an illusion forever.\",\n hpChange: 0,\n goldChange: 0,\n xpChange: 15,\n },\n ],\n },\n {\n title: \"🧙 A Mysterious Wizard Appears\",\n description:\n \"A wizard in a star-patterned robe materializes in a puff of purple smoke. 'I have three gifts,' he says, 'but only one shall you receive. Choose wisely, adventurer.'\",\n choices: [\n {\n emoji: \"💎\",\n text: \"Choose the sparkling gemstone\",\n outcome:\n \"The gemstone is worth a fortune! Our hero's purse swells with gold. The wizard nods approvingly and vanishes.\",\n hpChange: 0,\n goldChange: 100,\n xpChange: 10,\n },\n {\n emoji: \"📜\",\n text: \"Choose the ancient scroll\",\n outcome:\n \"The scroll contains forgotten battle techniques! Our hero's mind expands with ancient knowledge. The wizard smiles and fades away.\",\n hpChange: 0,\n goldChange: 0,\n xpChange: 60,\n },\n {\n emoji: \"🧪\",\n text: \"Choose the glowing potion\",\n outcome:\n \"The potion heals all wounds and grants temporary invincibility! Our hero feels reborn with energy!\",\n hpChange: 50,\n goldChange: 0,\n xpChange: 10,\n },\n {\n emoji: \"🃏\",\n text: \"Ask for all three (risky!)\",\n outcome:\n \"The wizard laughs! 'Greed has a price!' A bolt of lightning strikes, but amidst the chaos, our hero grabs two gifts before the wizard vanishes!\",\n hpChange: -20,\n goldChange: 50,\n xpChange: 30,\n },\n ],\n },\n {\n title: \"⚔️ Bandit Ambush!\",\n description:\n \"Three bandits leap from the bushes, weapons drawn! Their leader sneers, 'Your gold or your life, adventurer!' The forest goes quiet as tension fills the air.\",\n choices: [\n {\n emoji: \"💰\",\n text: \"Pay them off with gold\",\n outcome:\n \"Our hero tosses a bag of gold. The bandits scramble to collect it and disappear. Expensive, but no blood was shed.\",\n hpChange: 0,\n goldChange: -30,\n xpChange: 5,\n },\n {\n emoji: \"⚔️\",\n text: \"Fight all three bandits!\",\n outcome:\n \"A fierce battle! Our hero's blade dances through the air. Two bandits fall, and the third surrenders, offering their loot in exchange for mercy!\",\n hpChange: -20,\n goldChange: 45,\n xpChange: 35,\n },\n {\n emoji: \"🗣️\",\n text: \"Bluff — pretend to be a powerful mage\",\n outcome:\n \"Our hero raises a hand and shouts arcane-sounding nonsense! The bandits' eyes go wide with fear and they scatter into the woods!\",\n hpChange: 0,\n goldChange: 15,\n xpChange: 20,\n },\n {\n emoji: \"🤝\",\n text: \"Offer to team up for a bigger score\",\n outcome:\n \"The bandit leader is intrigued! Together they raid a merchant wagon, splitting the loot. Morally questionable, but profitable.\",\n hpChange: -5,\n goldChange: 60,\n xpChange: 15,\n },\n ],\n },\n {\n title: \"🌊 The Enchanted River\",\n description:\n \"Our hero reaches a shimmering river that flows with liquid silver. A sign reads: 'Drink and be changed forever.' Strange fish with human eyes watch from the water.\",\n choices: [\n {\n emoji: \"🥤\",\n text: \"Drink from the river\",\n outcome:\n \"The silver water tastes sweet! Our hero's body glows briefly — they feel stronger, faster, more alive! But a strange mark appears on their hand...\",\n hpChange: 20,\n goldChange: 0,\n xpChange: 25,\n },\n {\n emoji: \"🎣\",\n text: \"Try to catch the strange fish\",\n outcome:\n \"Our hero catches a fish that speaks! It offers a wish in exchange for freedom. Our hero wishes for gold — coins rain from the sky!\",\n hpChange: 0,\n goldChange: 70,\n xpChange: 15,\n },\n {\n emoji: \"🏊\",\n text: \"Swim across to the other side\",\n outcome:\n \"Halfway across, the current pulls our hero under! They surface on the other side, gasping but alive — and find a hidden treasure chest on the bank!\",\n hpChange: -10,\n goldChange: 40,\n xpChange: 20,\n },\n {\n emoji: \"🚶\",\n text: \"Follow the river upstream\",\n outcome:\n \"Following the river leads to its source: a peaceful crystal grotto! The magical energy here heals our hero completely. What a find!\",\n hpChange: 40,\n goldChange: 5,\n xpChange: 20,\n },\n ],\n },\n {\n title: \"💀 The Skeleton King's Tomb\",\n description:\n \"A massive stone door slides open, revealing a tomb bathed in eerie green light. On a throne of bones sits the Skeleton King, his eye sockets blazing with unholy fire.\",\n choices: [\n {\n emoji: \"⚔️\",\n text: \"Challenge the Skeleton King to combat!\",\n outcome:\n \"An epic duel! The Skeleton King fights with supernatural speed, but our hero shatters his crown — breaking the curse! The tomb crumbles, revealing treasure!\",\n hpChange: -25,\n goldChange: 80,\n xpChange: 50,\n },\n {\n emoji: \"🗣️\",\n text: \"Speak to him — ask his story\",\n outcome:\n \"The Skeleton King was once a noble ruler, cursed by a jealous sorcerer. Moved by his tale, our hero promises to find a cure. The King gifts an ancient amulet.\",\n hpChange: 0,\n goldChange: 30,\n xpChange: 35,\n },\n {\n emoji: \"🏃\",\n text: \"Grab treasure and run!\",\n outcome:\n \"Our hero snatches a golden chalice and sprints! The Skeleton King hurls a bone spear — it grazes our hero's leg! But the chalice is worth a fortune!\",\n hpChange: -15,\n goldChange: 60,\n xpChange: 10,\n },\n {\n emoji: \"🙏\",\n text: \"Bow in respect\",\n outcome:\n \"The Skeleton King is touched. 'Finally, one who shows respect.' He shares ancient combat wisdom and grants safe passage through the tomb's secret exit.\",\n hpChange: 10,\n goldChange: 15,\n xpChange: 40,\n },\n ],\n },\n];\n\n/** Pick a random scenario from the pool */\nexport function getRandomScenario(): Scenario {\n return ALL_SCENARIOS[Math.floor(Math.random() * ALL_SCENARIOS.length)];\n}\n\n/** Create a default starting character */\nexport function createCharacter(name: string): import(\"./types.ts\").Character {\n return {\n name,\n hp: 100,\n maxHp: 100,\n attack: 10,\n defense: 5,\n gold: 50,\n level: 1,\n xp: 0,\n };\n}\n",[],[228,230],"0740c86c-3ccc-11f1-a775-42b51c65c3df",["D",1776698241770],[189,190],[228],["D",1776708039246],[],[18,66],["D",1776698364619],[187],[18],"72712a34-3ce3-11f1-a3b6-42b51c65c3df","webhook.ts","44ea6326-3ccc-11f1-bb2a-42b51c65c3df","ea513f23-0278-42bd-a07d-eb6d7e907484",["D",1776708300001],"import type { Character, Scenario } from \"../shared/types.ts\";\n\nconst WEBHOOK_URL = Deno.env.get(\"DISCORD_WEBHOOK_URL\") || \"\";\nconst BOT_TOKEN = Deno.env.get(\"DISCORD_BOT_TOKEN\") || \"\";\n\n/**\n * Send a poll to Discord via webhook with the RPG scenario choices.\n * Discord webhooks support the `poll` field natively.\n * Returns the message ID (requires ?wait=true).\n */\nexport async function sendScenarioPoll(\n scenario: Scenario,\n character: Character,\n roundNumber: number,\n): Promise {\n if (!WEBHOOK_URL) {\n throw new Error(\"DISCORD_WEBHOOK_URL env var not set!\");\n }\n\n // Build the character status embed\n const embed = {\n title: `📖 Round ${roundNumber} — ${scenario.title}`,\n description: scenario.description,\n color: 0x7c3aed, // purple\n fields: [\n {\n name: \"🧝 Hero\",\n value: character.name,\n inline: true,\n },\n {\n name: \"❤️ HP\",\n value: `${character.hp}/${character.maxHp}`,\n inline: true,\n },\n {\n name: \"💰 Gold\",\n value: `${character.gold}`,\n inline: true,\n },\n {\n name: \"⭐ Level\",\n value: `${character.level} (${character.xp} XP)`,\n inline: true,\n },\n ],\n footer: {\n text:\n \"Vote in the poll below to decide the hero's next action! Poll ends in 1 hour.\",\n },\n };\n\n // Build the native Discord poll\n const poll = {\n question: {\n text: `What should ${character.name} do?`,\n },\n answers: scenario.choices.map((choice) => ({\n poll_media: {\n text: choice.text,\n emoji: { name: choice.emoji },\n },\n })),\n duration: 1, // 1 hour\n allow_multiselect: false,\n layout_type: 1, // DEFAULT\n };\n\n const response = await fetch(`${WEBHOOK_URL}?wait=true`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n username: \"⚔️ RPG Quest Master\",\n embeds: [embed],\n }),\n });\n\n if (!response.ok) {\n const text = await response.text();\n throw new Error(`Failed to send embed: ${response.status} ${text}`);\n }\n\n const embedMsg = await response.json();\n\n // Now send the poll as a separate message (webhooks can't combine embeds + polls)\n const pollResponse = await fetch(`${WEBHOOK_URL}?wait=true`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n username: \"⚔️ RPG Quest Master\",\n poll,\n }),\n });\n\n if (!pollResponse.ok) {\n const text = await pollResponse.text();\n throw new Error(`Failed to send poll: ${pollResponse.status} ${text}`);\n }\n\n const pollMsg = await pollResponse.json();\n return pollMsg.id;\n}\n\n/**\n * Fetch a message from Discord to read poll results.\n * This requires a Bot Token and the channel ID.\n * We extract the channel_id from the webhook URL or use env var.\n */\nexport async function getPollResults(\n channelId: string,\n messageId: string,\n): Promise<{ answerIndex: number; votes: number }[]> {\n if (!BOT_TOKEN) {\n throw new Error(\"DISCORD_BOT_TOKEN env var not set!\");\n }\n\n console.log(\"channelId:\", channelId);\n console.log(\"messageId:\", messageId);\n\n const response = await fetch(\n `https://discord.com/api/v10/channels/${channelId}/messages/${messageId}`,\n {\n headers: {\n Authorization: `Bot ${BOT_TOKEN}`,\n },\n },\n );\n\n if (!response.ok) {\n const text = await response.text();\n throw new Error(`Failed to fetch message: ${response.status} ${text}`);\n }\n\n const message = await response.json();\n\n console.log(\"message:\", message);\n\n if (!message.poll?.results?.answer_counts) {\n return [];\n }\n\n return message.poll.results.answer_counts.map(\n (ac: { id: number; count: number }) => ({\n answerIndex: ac.id - 1, // Discord uses 1-based IDs\n votes: ac.count,\n }),\n );\n}\n\n/**\n * Send the outcome message to Discord after poll resolves.\n */\nexport async function sendOutcomeMessage(\n outcome: string,\n character: Character,\n chosenAction: string,\n votes: number,\n roundNumber: number,\n): Promise {\n if (!WEBHOOK_URL) return;\n\n const embed = {\n title: `📜 Round ${roundNumber} Result`,\n description: outcome,\n color: 0x10b981, // green\n fields: [\n {\n name: \"🎯 Chosen Action\",\n value: chosenAction,\n inline: false,\n },\n {\n name: \"🗳️ Votes\",\n value: `${votes} vote(s)`,\n inline: true,\n },\n {\n name: \"❤️ HP\",\n value: `${character.hp}/${character.maxHp}`,\n inline: true,\n },\n {\n name: \"💰 Gold\",\n value: `${character.gold}`,\n inline: true,\n },\n {\n name: \"⭐ Level\",\n value: `${character.level} (${character.xp} XP)`,\n inline: true,\n },\n ],\n footer: {\n text: character.hp <= 0\n ? \"💀 THE HERO HAS FALLEN! Game Over.\"\n : \"Next round coming soon...\",\n },\n };\n\n await fetch(WEBHOOK_URL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n username: \"⚔️ RPG Quest Master\",\n embeds: [embed],\n }),\n });\n}",[],[255,248],"discord","44eab902-3ccc-11f1-bb2a-42b51c65c3df",5,["D",1776698345226],[185],[255],"367bba7e-3ccc-11f1-aba3-42b51c65c3df","queries.ts","367bbb3c-3ccc-11f1-aba3-42b51c65c3df","38229a05-fb1c-4e89-930b-effe06624a23",4,["D",1776698321016],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Character, GameState, Scenario } from \"../shared/types.ts\";\n\nexport async function getActiveGame(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM game_state WHERE is_active = 1 ORDER BY id DESC LIMIT 1\",\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0] as Record;\n return {\n id: row.id as number,\n character: JSON.parse(row.character_json as string),\n currentScenario: row.current_scenario_json\n ? JSON.parse(row.current_scenario_json as string)\n : null,\n pollMessageId: row.poll_message_id as string | null,\n pollSentAt: row.poll_sent_at as string | null,\n lastOutcome: row.last_outcome as string | null,\n roundNumber: row.round_number as number,\n isActive: (row.is_active as number) === 1,\n };\n}\n\nexport async function createGame(character: Character): Promise {\n const result = await sqlite.execute({\n sql:\n \"INSERT INTO game_state (character_json, round_number) VALUES (?, 0)\",\n args: [JSON.stringify(character)],\n });\n return result.lastInsertRowid as number;\n}\n\nexport async function updateGameScenario(\n gameId: number,\n scenario: Scenario,\n pollMessageId: string,\n) {\n await sqlite.execute({\n sql: `UPDATE game_state \n SET current_scenario_json = ?, poll_message_id = ?, poll_sent_at = datetime('now'),\n round_number = round_number + 1, updated_at = datetime('now')\n WHERE id = ?`,\n args: [JSON.stringify(scenario), pollMessageId, gameId],\n });\n}\n\nexport async function updateGameAfterPoll(\n gameId: number,\n character: Character,\n outcome: string,\n) {\n await sqlite.execute({\n sql: `UPDATE game_state \n SET character_json = ?, last_outcome = ?, \n current_scenario_json = NULL, poll_message_id = NULL, poll_sent_at = NULL,\n updated_at = datetime('now')\n WHERE id = ?`,\n args: [JSON.stringify(character), outcome, gameId],\n });\n}\n\nexport async function endGame(gameId: number) {\n await sqlite.execute({\n sql: \"UPDATE game_state SET is_active = 0, updated_at = datetime('now') WHERE id = ?\",\n args: [gameId],\n });\n}\n\nexport async function addGameLog(\n gameId: number,\n roundNumber: number,\n scenarioTitle: string,\n chosenAction: string,\n outcome: string,\n votes: number,\n) {\n await sqlite.execute({\n sql: `INSERT INTO game_log (game_id, round_number, scenario_title, chosen_action, outcome, votes)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [gameId, roundNumber, scenarioTitle, chosenAction, outcome, votes],\n });\n}\n\nexport async function getGameLog(gameId: number) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM game_log WHERE game_id = ? ORDER BY round_number ASC\",\n args: [gameId],\n });\n return result.rows as Record[];\n}\n\nexport async function getAllGames() {\n const result = await sqlite.execute(\n \"SELECT * FROM game_state ORDER BY id DESC LIMIT 20\",\n );\n return result.rows as Record[];\n}\n",[],[270,262],"database","2e9c68a8-3ccc-11f1-aba3-42b51c65c3df","migrations.ts","2e9c6948-3ccc-11f1-aba3-42b51c65c3df",["D",1776698307794],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS game_state (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n character_json TEXT NOT NULL,\n current_scenario_json TEXT,\n poll_message_id TEXT,\n poll_sent_at TEXT,\n last_outcome TEXT,\n round_number INTEGER NOT NULL DEFAULT 0,\n is_active INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS game_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id INTEGER NOT NULL,\n round_number INTEGER NOT NULL,\n scenario_title TEXT NOT NULL,\n chosen_action TEXT NOT NULL,\n outcome TEXT NOT NULL,\n votes INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n",[],[270,272],"2e9c7870-3ccc-11f1-aba3-42b51c65c3df",["D",1776698307794],[182,183],[270],["D",1776698221166],["D",1789506649022],{"_11":12,"_135":72},{"_11":12,"_131":-5,"_71":72,"_31":70,"_132":133,"_134":30},{"_40":122,"_13":16,"_34":37,"_123":84,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":-5,"_129":14,"_130":12},"ctx",{"_54":-5,"_154":320,"_321":322,"_323":324,"_325":30,"_326":30,"_327":30,"_328":24,"_329":-5,"_330":-7,"_331":-7,"_332":26,"_333":30,"_334":30,"_335":-5,"_336":30,"_337":30,"_338":30,"_339":-5},"ENV",{"_291":292,"_293":294,"_295":16,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319},"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"]

History · game