🧝 ${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",[],[204],"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",[],[212],"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",[],[227,220],"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",[],[227,229],"0740c86c-3ccc-11f1-a775-42b51c65c3df",["D",1776698241770],[188,189],[227],"d702e74a-3ce2-11f1-a3d9-42b51c65c3df","engine.ts","50799658-3ccc-11f1-a7a4-42b51c65c3df","06f891d0-5f7b-4a06-b3d4-7eb339d89c8e",10,["D",1776708039246],"import type { Character, Choice } from \"../shared/types.ts\";\nimport { createCharacter, getRandomScenario } from \"../shared/scenarios.ts\";\nimport {\n addGameLog,\n createGame,\n endGame,\n getActiveGame,\n updateGameAfterPoll,\n updateGameScenario,\n} from \"../database/queries.ts\";\nimport {\n getPollResults,\n sendOutcomeMessage,\n sendScenarioPoll,\n} from \"../discord/webhook.ts\";\nimport { runMigrations } from \"../database/migrations.ts\";\n\nconst CHANNEL_ID = Deno.env.get(\"DISCORD_CHANNEL_ID\") || \"\";\n\n/** Start a new game with a named hero */\nexport async function startNewGame(heroName: string): Promise {\n await runMigrations();\n\n // End any existing active game\n const existing = await getActiveGame();\n if (existing) {\n await endGame(existing.id);\n }\n\n const character = createCharacter(heroName);\n const gameId = await createGame(character);\n\n // Immediately send the first scenario\n const scenario = getRandomScenario();\n const pollMsgId = await sendScenarioPoll(scenario, character, 1);\n await updateGameScenario(gameId, scenario, pollMsgId);\n\n return `🎮 New game started! Hero \"${heroName}\" embarks on an adventure! Poll sent to Discord.`;\n}\n\n/** Check the current poll and advance the game */\nexport async function checkPollAndAdvance(): Promise {\n await runMigrations();\n\n const game = await getActiveGame();\n if (!game) return \"No active game found.\";\n if (!game.pollMessageId || !game.currentScenario) {\n return \"No active poll. Use the dashboard to send the next scenario.\";\n }\n\n if (!CHANNEL_ID) return \"DISCORD_CHANNEL_ID env var not set!\";\n\n // Fetch poll results\n const results = await getPollResults(CHANNEL_ID, game.pollMessageId);\n\n if (results.length === 0) {\n console.log(\"results:\", results);\n return \"Poll has no votes yet or hasn't expired_.\";\n }\n\n // Find the winning choice\n let maxVotes = 0;\n let winningIndex = 0;\n for (const r of results) {\n if (r.votes > maxVotes) {\n maxVotes = r.votes;\n winningIndex = r.answerIndex;\n }\n }\n\n // If no votes at all, pick randomly\n if (maxVotes === 0) {\n winningIndex = Math.floor(\n Math.random() * game.currentScenario.choices.length,\n );\n }\n\n const choice: Choice = game.currentScenario.choices[winningIndex];\n const character = { ...game.character };\n\n // Apply choice effects\n character.hp = Math.min(\n character.maxHp,\n Math.max(0, character.hp + choice.hpChange),\n );\n character.gold = Math.max(0, character.gold + choice.goldChange);\n character.xp += choice.xpChange;\n\n // Level up check\n const xpNeeded = character.level * 50;\n if (character.xp >= xpNeeded) {\n character.level++;\n character.xp -= xpNeeded;\n character.maxHp += 10;\n character.hp = Math.min(character.hp + 10, character.maxHp);\n character.attack += 2;\n character.defense += 1;\n }\n\n // Log this round\n await addGameLog(\n game.id,\n game.roundNumber,\n game.currentScenario.title,\n choice.text,\n choice.outcome,\n maxVotes,\n );\n\n // Update game state\n await updateGameAfterPoll(game.id, character, choice.outcome);\n\n // Send outcome to Discord\n await sendOutcomeMessage(\n choice.outcome,\n character,\n choice.text,\n maxVotes,\n game.roundNumber,\n );\n\n // Check for game over\n if (character.hp <= 0) {\n await endGame(game.id);\n return `💀 Game Over! ${character.name} has fallen at round ${game.roundNumber}.`;\n }\n\n return `✅ Round ${game.roundNumber} resolved! ${choice.text} won with ${maxVotes} votes. HP: ${character.hp}/${character.maxHp}`;\n}\n\n/** Send the next scenario poll for an active game */\nexport async function sendNextScenario(): Promise {\n await runMigrations();\n\n const game = await getActiveGame();\n if (!game) return \"No active game. Start a new one first!\";\n if (game.pollMessageId) {\n return \"A poll is already active! Wait for it to resolve.\";\n }\n if (game.character.hp <= 0) return \"The hero is dead! Start a new game.\";\n\n const scenario = getRandomScenario();\n const pollMsgId = await sendScenarioPoll(\n scenario,\n game.character,\n game.roundNumber + 1,\n );\n await updateGameScenario(game.id, scenario, pollMsgId);\n\n return `📨 New scenario sent: ${scenario.title}`;\n}",[],[249,241],"game","5079cbc8-3ccc-11f1-a7a4-42b51c65c3df",6,["D",1776698364619],[186],[249],["D",1776708300001],[],[18,66],["D",1776698345226],[184],[18],"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],[181,182],[270],["D",1776698221166],["D",1789506649022],{"_11":12,"_134":72},{"_11":12,"_130":-5,"_71":72,"_31":70,"_131":132,"_133":30},{"_40":75,"_13":16,"_34":37,"_122":84,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":14,"_129":12},"ctx",{"_54":-5,"_153":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","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · discord