[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_321":322,"_323":324},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":59,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",30,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","c82af890-8e94-11f0-8b25-0224a6c84d84","name","queries.ts","fileType","script","content","// Database query functions\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport type { Game, PieceType, Player, Piece, Turn, Move } from \"../../shared/types.ts\";\n\n// Game queries\nexport async function createGame(game: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO games (id, name, rules, manager_id, include_previous_move) \n VALUES (?, ?, ?, ?, ?)`,\n [game.id, game.name, game.rules, game.manager_id, game.include_previous_move]\n );\n}\n\nexport async function getGame(gameId: string): Promise {\n console.log(\"Querying for game ID:\", gameId);\n const result = await sqlite.execute(\n `SELECT * FROM games WHERE id = ?`,\n [gameId]\n );\n console.log(\"Query result:\", result);\n return result.length > 0 ? result[0] as Game : null;\n}\n\nexport async function updateGameSettings(gameId: string, includePreviousMove: boolean): Promise {\n await sqlite.execute(\n `UPDATE games SET include_previous_move = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [includePreviousMove, gameId]\n );\n}\n\nexport async function gameExists(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM games WHERE id = ? LIMIT 1`,\n [gameId]\n );\n return result.length > 0;\n}\n\n// Piece type queries\nexport async function createPieceType(pieceType: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO piece_types (game_id, name, description) VALUES (?, ?, ?) RETURNING id`,\n [pieceType.game_id, pieceType.name, pieceType.description]\n );\n return result[0].id as number;\n}\n\nexport async function getPieceTypes(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM piece_types WHERE game_id = ? ORDER BY created_at`,\n [gameId]\n );\n return result as PieceType[];\n}\n\nexport async function getPieceType(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM piece_types WHERE id = ?`,\n [id]\n );\n return result.length > 0 ? result[0] as PieceType : null;\n}\n\n// Player queries\nexport async function createPlayer(player: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO players (game_id, username) VALUES (?, ?)`,\n [player.game_id, player.username]\n );\n}\n\nexport async function getPlayers(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM players WHERE game_id = ? ORDER BY joined_at`,\n [gameId]\n );\n return result as Player[];\n}\n\nexport async function playerExists(gameId: string, username: string): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM players WHERE game_id = ? AND username = ? LIMIT 1`,\n [gameId, username]\n );\n return result.length > 0;\n}\n\n// Piece queries\nexport async function createPiece(piece: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO pieces (game_id, player_username, piece_type_id, instructions, last_move) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [piece.game_id, piece.player_username, piece.piece_type_id, piece.instructions, piece.last_move]\n );\n return result[0].id as number;\n}\n\nexport async function getPieces(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM pieces WHERE game_id = ? ORDER BY created_at`,\n [gameId]\n );\n return result as Piece[];\n}\n\nexport async function getPlayerPieces(gameId: string, username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM pieces WHERE game_id = ? AND player_username = ? ORDER BY created_at`,\n [gameId, username]\n );\n return result as Piece[];\n}\n\nexport async function updatePieceInstructions(pieceId: number, instructions: string): Promise {\n await sqlite.execute(\n `UPDATE pieces SET instructions = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [instructions, pieceId]\n );\n}\n\nexport async function updatePieceLastMove(pieceId: number, lastMove: string): Promise {\n await sqlite.execute(\n `UPDATE pieces SET last_move = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [lastMove, pieceId]\n );\n}\n\n// Turn queries\nexport async function createTurn(turn: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO turns (game_id, initiated_by, photo_url, snapshot_data, status) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [turn.game_id, turn.initiated_by, turn.photo_url, turn.snapshot_data, turn.status]\n );\n return result[0].id as number;\n}\n\nexport async function updateTurnStatus(turnId: number, status: string): Promise {\n const completedAt = status === 'completed' ? 'CURRENT_TIMESTAMP' : 'NULL';\n await sqlite.execute(\n `UPDATE turns SET status = ?, completed_at = ${completedAt} WHERE id = ?`,\n [status, turnId]\n );\n}\n\nexport async function getLatestTurn(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM turns WHERE game_id = ? ORDER BY created_at DESC LIMIT 1`,\n [gameId]\n );\n return result.length > 0 ? result[0] as Turn : null;\n}\n\n// Move queries\nexport async function createMove(move: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO moves (turn_id, piece_id, thinking_process, final_move, status, error_message) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING id`,\n [move.turn_id, move.piece_id, move.thinking_process, move.final_move, move.status, move.error_message]\n );\n return result[0].id as number;\n}\n\nexport async function updateMove(moveId: number, thinkingProcess: string, finalMove: string, status: string, errorMessage?: string): Promise {\n await sqlite.execute(\n `UPDATE moves SET thinking_process = ?, final_move = ?, status = ?, error_message = ?, completed_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [thinkingProcess, finalMove, status, errorMessage || null, moveId]\n );\n}\n\nexport async function getTurnMoves(turnId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM moves WHERE turn_id = ? ORDER BY created_at`,\n [turnId]\n );\n return result as Move[];\n}\n\n// Complex queries for game state\nexport async function getGameSnapshot(gameId: string): Promise {\n const game = await getGame(gameId);\n const pieceTypes = await getPieceTypes(gameId);\n const pieces = await getPieces(gameId);\n \n return {\n game,\n pieceTypes,\n pieces\n };\n}\n\nexport async function getPieceWithTypeInfo(pieceId: number): Promise {\n const result = await sqlite.execute(`\n SELECT \n p.*,\n pt.name as piece_type_name,\n pt.description as piece_type_description\n FROM pieces p\n JOIN piece_types pt ON p.piece_type_id = pt.id\n WHERE p.id = ?\n `, [pieceId]);\n \n return result.length > 0 ? result[0] : null;\n}","// Database query functions\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport type { Game, PieceType, Player, Piece, Turn, Move } from \"../../shared/types.ts\";\n\n// Game queries\nexport async function createGame(game: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO games (id, name, rules, manager_id, include_previous_move) \n VALUES (?, ?, ?, ?, ?)`,\n [game.id, game.name, game.rules, game.manager_id, game.include_previous_move]\n );\n}\n\nexport async function getGame(gameId: string): Promise {\n console.log(\"Querying for game ID:\", gameId);\n const result = await sqlite.execute(\n `SELECT * FROM games WHERE id = ?`,\n [gameId]\n );\n console.log(\"Query result:\", result);\n return result.rows && result.rows.length > 0 ? result.rows[0] as Game : null;\n}\n\nexport async function updateGameSettings(gameId: string, includePreviousMove: boolean): Promise {\n await sqlite.execute(\n `UPDATE games SET include_previous_move = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [includePreviousMove, gameId]\n );\n}\n\nexport async function gameExists(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM games WHERE id = ? LIMIT 1`,\n [gameId]\n );\n return result.length > 0;\n}\n\n// Piece type queries\nexport async function createPieceType(pieceType: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO piece_types (game_id, name, description) VALUES (?, ?, ?) RETURNING id`,\n [pieceType.game_id, pieceType.name, pieceType.description]\n );\n return result[0].id as number;\n}\n\nexport async function getPieceTypes(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM piece_types WHERE game_id = ? ORDER BY created_at`,\n [gameId]\n );\n return result as PieceType[];\n}\n\nexport async function getPieceType(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM piece_types WHERE id = ?`,\n [id]\n );\n return result.length > 0 ? result[0] as PieceType : null;\n}\n\n// Player queries\nexport async function createPlayer(player: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO players (game_id, username) VALUES (?, ?)`,\n [player.game_id, player.username]\n );\n}\n\nexport async function getPlayers(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM players WHERE game_id = ? ORDER BY joined_at`,\n [gameId]\n );\n return result as Player[];\n}\n\nexport async function playerExists(gameId: string, username: string): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM players WHERE game_id = ? AND username = ? LIMIT 1`,\n [gameId, username]\n );\n return result.length > 0;\n}\n\n// Piece queries\nexport async function createPiece(piece: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO pieces (game_id, player_username, piece_type_id, instructions, last_move) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [piece.game_id, piece.player_username, piece.piece_type_id, piece.instructions, piece.last_move]\n );\n return result[0].id as number;\n}\n\nexport async function getPieces(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM pieces WHERE game_id = ? ORDER BY created_at`,\n [gameId]\n );\n return result as Piece[];\n}\n\nexport async function getPlayerPieces(gameId: string, username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM pieces WHERE game_id = ? AND player_username = ? ORDER BY created_at`,\n [gameId, username]\n );\n return result as Piece[];\n}\n\nexport async function updatePieceInstructions(pieceId: number, instructions: string): Promise {\n await sqlite.execute(\n `UPDATE pieces SET instructions = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [instructions, pieceId]\n );\n}\n\nexport async function updatePieceLastMove(pieceId: number, lastMove: string): Promise {\n await sqlite.execute(\n `UPDATE pieces SET last_move = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [lastMove, pieceId]\n );\n}\n\n// Turn queries\nexport async function createTurn(turn: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO turns (game_id, initiated_by, photo_url, snapshot_data, status) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [turn.game_id, turn.initiated_by, turn.photo_url, turn.snapshot_data, turn.status]\n );\n return result[0].id as number;\n}\n\nexport async function updateTurnStatus(turnId: number, status: string): Promise {\n const completedAt = status === 'completed' ? 'CURRENT_TIMESTAMP' : 'NULL';\n await sqlite.execute(\n `UPDATE turns SET status = ?, completed_at = ${completedAt} WHERE id = ?`,\n [status, turnId]\n );\n}\n\nexport async function getLatestTurn(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM turns WHERE game_id = ? ORDER BY created_at DESC LIMIT 1`,\n [gameId]\n );\n return result.length > 0 ? result[0] as Turn : null;\n}\n\n// Move queries\nexport async function createMove(move: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO moves (turn_id, piece_id, thinking_process, final_move, status, error_message) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING id`,\n [move.turn_id, move.piece_id, move.thinking_process, move.final_move, move.status, move.error_message]\n );\n return result[0].id as number;\n}\n\nexport async function updateMove(moveId: number, thinkingProcess: string, finalMove: string, status: string, errorMessage?: string): Promise {\n await sqlite.execute(\n `UPDATE moves SET thinking_process = ?, final_move = ?, status = ?, error_message = ?, completed_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [thinkingProcess, finalMove, status, errorMessage || null, moveId]\n );\n}\n\nexport async function getTurnMoves(turnId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM moves WHERE turn_id = ? ORDER BY created_at`,\n [turnId]\n );\n return result as Move[];\n}\n\n// Complex queries for game state\nexport async function getGameSnapshot(gameId: string): Promise {\n const game = await getGame(gameId);\n const pieceTypes = await getPieceTypes(gameId);\n const pieces = await getPieces(gameId);\n \n return {\n game,\n pieceTypes,\n pieces\n };\n}\n\nexport async function getPieceWithTypeInfo(pieceId: number): Promise {\n const result = await sqlite.execute(`\n SELECT \n p.*,\n pt.name as piece_type_name,\n pt.description as piece_type_description\n FROM pieces p\n JOIN piece_types pt ON p.piece_type_id = pt.id\n WHERE p.id = ?\n `, [pieceId]);\n \n return result.length > 0 ? result[0] : null;\n}","createdAt",["D",1757543691712],"branchVersion","branchId","968f510e-8e8b-11f0-ac0b-0224a6c84d84","id","968ee85e-8e8b-11f0-ac0b-0224a6c84d84","cogs-clippies-1",["D",1757539062598],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","53f045b0-fcaa-11ef-9928-c9aafb5d50fa","pinnedFileId","ce62fa3c-8e94-11f0-867f-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","658b7c0d-aded-45be-b139-8952d52d1479","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"isOwned",44,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","malcolmocean","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydTRFSlhQcUNYWnZFTjJHNURLendoUzgwbGwifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":317,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":318,"_81":319,"_83":320,"_85":25},"tree",[180,189,194,197,198],"files",[180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198],"counts",{"_169":63,"_170":171,"_172":63,"_173":174,"_175":176},"contents",[127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":163,"_32":164,"_30":165,"_135":-5,"_42":43,"_41":166,"_137":59,"_39":167,"_13":63,"_34":155,"_36":-5,"_24":25,"_142":-5,"_27":168},{"_44":157,"_32":158,"_30":159,"_135":-5,"_42":43,"_41":160,"_137":59,"_39":161,"_13":63,"_34":155,"_36":-5,"_24":25,"_142":-5,"_27":162},{"_44":150,"_32":151,"_30":152,"_135":-5,"_42":43,"_41":153,"_137":59,"_39":154,"_13":63,"_34":155,"_36":-5,"_24":25,"_142":-5,"_27":156},{"_44":144,"_32":145,"_30":146,"_135":-5,"_42":43,"_41":139,"_137":59,"_39":147,"_13":63,"_34":20,"_36":148,"_24":25,"_142":-5,"_27":149},{"_44":132,"_32":133,"_30":134,"_135":-5,"_42":43,"_41":136,"_137":59,"_39":138,"_13":139,"_34":140,"_36":141,"_24":25,"_142":-5,"_27":143},"7c1baaa2-8e95-11f0-a589-0224a6c84d84","main.ts","9691d78a-8e8b-11f0-ac0b-0224a6c84d84","parentId",18,"latest",["D",1757543313176],2,"http","// Redirect to backend\nexport default function(req: Request) {\n return new Response(null, {\n status: 302,\n headers: {\n Location: \"/backend/index.ts\" + (new URL(req.url).pathname === \"/\" ? \"\" : new URL(req.url).pathname + new URL(req.url).search)\n }\n });\n}","label",[133],"9d5d00e0-8e94-11f0-938c-0224a6c84d84","README.md","9d5d018a-8e94-11f0-938c-0224a6c84d84",["D",1757542939483],"# LLM Board Game Server\n\nA game-agnostic server that enables LLM-controlled pieces to play physical board games based on photos of the game state.\n\n## Features\n\n- **Game Management**: Create games with custom rules and piece types\n- **Multi-Player Support**: Multiple human players can join and control pieces\n- **LLM Integration**: Each piece is controlled by an independent LLM call\n- **Real-time Updates**: WebSocket-based live updates as moves are generated\n- **Photo-based State**: Uses multimodal LLMs to analyze board photos\n- **Human Arbitration**: No rule enforcement - humans resolve conflicts\n\n## Architecture\n\n### Backend (`/backend/`)\n- **Hono API server** with WebSocket support\n- **SQLite database** for game state persistence\n- **OpenAI Vision API** integration for board analysis\n- **Parallel LLM processing** for simultaneous piece moves\n\n### Frontend (`/frontend/`)\n- **Game creation and management** interface\n- **Player join and piece control** pages\n- **Real-time move display** with WebSocket updates\n- **Photo upload and turn processing**\n\n### Shared (`/shared/`)\n- **TypeScript types** for game data structures\n- **Utility functions** for ID generation and validation\n\n## URL Structure\n\n- `/` - Homepage with game creation\n- `/game/:gameid` - Join game page\n- `/game/:gameid/manage/:managerid` - Game management interface\n- `/game/:gameid/play/:username` - Player interface\n- `/game/:gameid/clone` - Clone game with same rules\n\n## Game Flow\n\n1. **Game Creation**: Manager sets up game rules and piece types\n2. **Player Join**: Players join with unique usernames\n3. **Piece Assignment**: Players create and configure their pieces\n4. **Turn Processing**: Photo upload triggers parallel LLM calls\n5. **Move Display**: Results stream in real-time via WebSockets\n6. **Human Arbitration**: Players interpret and apply moves manually\n\n## Technical Details\n\n- **Game IDs**: 5-character case-insensitive unique identifiers\n- **No Authentication**: Designed for small playtesting events\n- **Stateless LLMs**: Each turn uses only current board photo\n- **Conflict Resolution**: Handled entirely by human players\n- **Real-time Updates**: WebSocket-based live move streaming",[145],"a7c9feac-8e94-11f0-b86b-0224a6c84d84","shared","69da698d-0574-4adb-baa5-14fa8661c4d4",3,["D",1757542956972],"directory",[151],"144565bc-8e95-11f0-a049-0224a6c84d84","frontend","be3a9d17-844f-450e-a12d-1475c9b5a755",11,["D",1757543138975],[158],"b601e0de-8e94-11f0-9139-0224a6c84d84","backend","7eff5c05-c3d1-4053-9fd9-4417307376da",5,["D",1757542980823],[164],"pulls","branches",1,"forks","envVars",{"_177":63,"_179":63},"connections",{"_177":63,"_178":63},"count","unfilledCount","emptyCount",{"_44":163,"_32":164,"_30":165,"_135":-5,"_42":43,"_41":166,"_137":59,"_39":314,"_13":63,"_34":155,"_36":-5,"_24":25,"_142":-5,"_200":315,"_27":316},{"_44":310,"_32":302,"_30":298,"_135":165,"_42":43,"_41":166,"_137":59,"_39":311,"_13":63,"_34":155,"_36":-5,"_24":25,"_142":-5,"_200":312,"_27":313},{"_44":303,"_32":304,"_30":305,"_135":298,"_42":43,"_41":166,"_137":59,"_39":306,"_13":63,"_34":35,"_36":307,"_24":25,"_142":-5,"_200":308,"_27":309},{"_44":297,"_32":33,"_30":31,"_135":298,"_42":43,"_41":14,"_137":25,"_39":299,"_13":139,"_34":35,"_36":38,"_24":25,"_142":-5,"_200":300,"_27":301},{"_44":292,"_32":274,"_30":268,"_135":165,"_42":43,"_41":293,"_137":59,"_39":294,"_13":63,"_34":155,"_36":-5,"_24":25,"_142":-5,"_200":295,"_27":296},{"_44":283,"_32":284,"_30":285,"_135":268,"_42":43,"_41":286,"_137":59,"_39":287,"_13":288,"_34":35,"_36":289,"_24":25,"_142":-5,"_200":290,"_27":291},{"_44":275,"_32":276,"_30":277,"_135":268,"_42":43,"_41":278,"_137":59,"_39":279,"_13":63,"_34":35,"_36":280,"_24":25,"_142":-5,"_200":281,"_27":282},{"_44":265,"_32":266,"_30":267,"_135":268,"_42":43,"_41":269,"_137":25,"_39":270,"_13":63,"_34":35,"_36":271,"_24":25,"_142":-5,"_200":272,"_27":273},{"_44":258,"_32":259,"_30":57,"_135":165,"_42":43,"_41":260,"_137":59,"_39":261,"_13":166,"_34":140,"_36":262,"_24":25,"_142":-5,"_200":263,"_27":264},{"_44":157,"_32":158,"_30":159,"_135":-5,"_42":43,"_41":160,"_137":59,"_39":255,"_13":63,"_34":155,"_36":-5,"_24":25,"_142":-5,"_200":256,"_27":257},{"_44":248,"_32":249,"_30":250,"_135":159,"_42":43,"_41":160,"_137":25,"_39":251,"_13":63,"_34":20,"_36":252,"_24":25,"_142":-5,"_200":253,"_27":254},{"_44":240,"_32":241,"_30":242,"_135":159,"_42":43,"_41":243,"_137":59,"_39":244,"_13":63,"_34":20,"_36":245,"_24":25,"_142":-5,"_200":246,"_27":247},{"_44":232,"_32":233,"_30":234,"_135":159,"_42":43,"_41":235,"_137":59,"_39":236,"_13":63,"_34":20,"_36":237,"_24":25,"_142":-5,"_200":238,"_27":239},{"_44":224,"_32":225,"_30":226,"_135":159,"_42":43,"_41":227,"_137":59,"_39":228,"_13":63,"_34":20,"_36":229,"_24":25,"_142":-5,"_200":230,"_27":231},{"_44":150,"_32":151,"_30":152,"_135":-5,"_42":43,"_41":153,"_137":59,"_39":221,"_13":63,"_34":155,"_36":-5,"_24":25,"_142":-5,"_200":222,"_27":223},{"_44":214,"_32":215,"_30":216,"_135":152,"_42":43,"_41":153,"_137":59,"_39":217,"_13":63,"_34":35,"_36":218,"_24":25,"_142":-5,"_200":219,"_27":220},{"_44":206,"_32":207,"_30":208,"_135":152,"_42":43,"_41":209,"_137":59,"_39":210,"_13":63,"_34":35,"_36":211,"_24":25,"_142":-5,"_200":212,"_27":213},{"_44":144,"_32":145,"_30":146,"_135":-5,"_42":43,"_41":139,"_137":59,"_39":203,"_13":63,"_34":20,"_36":148,"_24":25,"_142":-5,"_200":204,"_27":205},{"_44":132,"_32":133,"_30":134,"_135":-5,"_42":43,"_41":136,"_137":59,"_39":199,"_13":139,"_34":140,"_36":141,"_24":25,"_142":-5,"_200":201,"_27":202},["D",1757543313176],"children",[],[133],["D",1757542939483],[],[145],"ae080e58-8e94-11f0-ae4a-0224a6c84d84","utils.ts","ae080f16-8e94-11f0-ae4a-0224a6c84d84",4,["D",1757542967448],"// Shared utility functions\n\n/**\n * Generate a random 5-character case-insensitive ID\n */\nexport function generateGameId(): string {\n const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';\n let result = '';\n for (let i = 0; i < 5; i++) {\n result += chars.charAt(Math.floor(Math.random() * chars.length));\n }\n return result;\n}\n\n/**\n * Validate username format (alphanumeric, no spaces)\n */\nexport function isValidUsername(username: string): boolean {\n return /^[a-zA-Z0-9]+$/.test(username) && username.length > 0 && username.length <= 20;\n}\n\n/**\n * Validate game ID format (5 characters, alphanumeric)\n */\nexport function isValidGameId(gameId: string): boolean {\n return /^[A-Z0-9]{5}$/i.test(gameId);\n}\n\n/**\n * Normalize game ID to uppercase\n */\nexport function normalizeGameId(gameId: string): string {\n return gameId.toUpperCase();\n}\n\n/**\n * Extract move description from LLM response\n */\nexport function extractMoveFromResponse(response: string): { thinking: string; move: string } {\n const moveMatch = response.match(/MOVE:\\s*(.+?)(?:\\n|$)/i);\n \n if (moveMatch) {\n const moveIndex = response.toLowerCase().indexOf('move:');\n const thinking = response.substring(0, moveIndex).trim();\n const move = moveMatch[1].trim();\n return { thinking, move };\n }\n \n // Fallback if no MOVE: found\n return {\n thinking: response,\n move: \"No specific move described\"\n };\n}\n\n/**\n * Create LLM prompt from context\n */\nexport function createLLMPrompt(context: any): string {\n let prompt = `You are playing as an autonomous piece in a board game. The rules of the board game are:\n> ${context.game_rules}\n\nYour piece is ${context.piece_name} and the description of your piece is:\n> ${context.piece_description}`;\n\n if (context.player_instructions) {\n prompt += `\\n\\nYour human player has given you these instructions:\n> ${context.player_instructions}`;\n }\n\n if (context.previous_move) {\n prompt += `\\n\\nYour previous move was:\n> ${context.previous_move}`;\n }\n\n prompt += `\\n\\nAttached is a photo of the board state.\n\nThink out loud as much as you want, then output MOVE: [description of all behavior your piece will perform this turn]`;\n\n return prompt;\n}",[],[151,207],"a7c9eff2-8e94-11f0-b86b-0224a6c84d84","types.ts","a7c9f0ba-8e94-11f0-b86b-0224a6c84d84",["D",1757542956972],"// Shared TypeScript types for the LLM Board Game Server\n\nexport interface Game {\n id: string; // 5-character case-insensitive ID\n name: string;\n rules: string;\n manager_id: string; // 5-character manager ID for /manage/ access\n include_previous_move: boolean; // Setting for piece memory\n created_at: string;\n updated_at: string;\n}\n\nexport interface PieceType {\n id: number;\n game_id: string;\n name: string; // e.g., \"red pawn\", \"black disc\"\n description: string; // Natural language description of abilities/personality\n created_at: string;\n}\n\nexport interface Player {\n id: number;\n game_id: string;\n username: string; // Alphanumeric, no spaces, unique per game\n joined_at: string;\n}\n\nexport interface Piece {\n id: number;\n game_id: string;\n player_username: string;\n piece_type_id: number;\n instructions: string; // Player's persistent instructions for this piece\n last_move: string | null; // Last successfully executed move (for memory)\n created_at: string;\n updated_at: string;\n}\n\nexport interface Turn {\n id: number;\n game_id: string;\n initiated_by: string; // Username who started the turn\n photo_url: string; // URL to uploaded photo\n snapshot_data: string; // JSON snapshot of game state at turn start\n status: 'processing' | 'completed' | 'error';\n created_at: string;\n completed_at: string | null;\n}\n\nexport interface Move {\n id: number;\n turn_id: number;\n piece_id: number;\n thinking_process: string; // LLM's \"think out loud\" portion\n final_move: string; // The MOVE: description\n status: 'pending' | 'completed' | 'error';\n error_message: string | null;\n created_at: string;\n completed_at: string | null;\n}\n\n// WebSocket message types\nexport interface WSMessage {\n type: 'move_update' | 'turn_started' | 'turn_completed' | 'error';\n data: any;\n}\n\nexport interface MoveUpdate {\n piece_id: number;\n piece_name: string;\n player_username: string;\n thinking_process: string;\n final_move: string;\n status: 'completed' | 'error';\n error_message?: string;\n}\n\n// API request/response types\nexport interface CreateGameRequest {\n game_name: string;\n game_rules: string;\n}\n\nexport interface CreateGameResponse {\n game_id: string;\n manager_id: string;\n game_url: string;\n manage_url: string;\n}\n\nexport interface CreatePieceTypeRequest {\n piece_name: string;\n piece_description: string;\n}\n\nexport interface JoinGameRequest {\n username: string;\n}\n\nexport interface CreatePieceRequest {\n piece_type_id: number;\n instructions: string;\n}\n\nexport interface UpdateInstructionsRequest {\n piece_id: number;\n instructions: string;\n}\n\nexport interface StartTurnRequest {\n photo: File | string; // File upload or base64 string\n}\n\n// LLM prompt context\nexport interface LLMPromptContext {\n game_rules: string;\n piece_name: string;\n piece_description: string;\n player_instructions: string;\n previous_move?: string; // Only included if include_previous_move is true\n photo_url: string;\n}",[],[151,215],["D",1757542956972],[195,196],[151],"725949b6-8e95-11f0-9301-0224a6c84d84","play.html","72594a56-8e95-11f0-9301-0224a6c84d84",14,["D",1757543296802],"\n\n\n \n \n Play Game - LLM Board Game Server\n \n \n\n\n

🎮 Playing Game

\n \n

\n Player: | \n Game ID: \n

\n\n

\n \n

🎭 My Pieces

\n \n

\n\n

\n \n

\n\n \n

Add New Piece

\n \n

\n\n \n

📸 Take Turn

\n \n \n\n

\n Processing turn...\n

\n\n \n

🤖 Latest Moves

\n \n

\n\n

📋

No moves yet. Take a photo to start!

\n\n \n

\n Connecting...\n

\n\n \n

Edit Instructions

\n \n

\n\n \n\n",[],[158,225],"40daa11e-8e95-11f0-8c91-0224a6c84d84","manage.html","40daa1be-8e95-11f0-8c91-0224a6c84d84",13,["D",1757543213773],"\n\n\n \n \n Manage Game - LLM Board Game Server\n \n \n\n\n

🎮 Game Manager

\n \n

\n Game ID: \n

\n\n \n

⚙️ Game Settings

\n \n

\n Include Previous Move Context\n

When enabled, pieces remember their last move

\n \n \n

\n \n

\n\n \n

📋 Game Rules

\n\n \n

🎭 Piece Types

\n \n

\n\n

\n \n

\n\n \n

Add New Piece Type

\n \n

\n\n \n

👥 Players

\n \n

\n\n \n

🔗 Quick Links

\n Join Game URL\n

\n \n \n

\n Clone Game\n \n

\n\n \n\n",[],[158,233],"224f28d2-8e95-11f0-815f-0224a6c84d84","join.html","224f2990-8e95-11f0-815f-0224a6c84d84",12,["D",1757543162530],"\n\n\n \n \n Join Game - LLM Board Game Server\n \n \n\n\n

Join Game

\n Game: \n

\n ID: \n

\n\n

Game Rules:

\n\n \n\n

🎉 Successfully Joined!

You can now play the game at:

\n \n

\n\n

\n ← Back to Home\n

\n\n

Current Players

Loading players...

\n\n \n\n",[],[158,241],"14453fe2-8e95-11f0-a049-0224a6c84d84","index.html","144540d2-8e95-11f0-a049-0224a6c84d84",["D",1757543138975],"\n\n\n \n \n LLM Board Game Server\n \n \n\n\n

🎲 LLM Board Game Server

Let AI pieces play your physical board games

\n\n

How It Works

📋

1. Create Game

Set up rules and define piece types with unique personalities

📸

2. Take Photos

Upload board state photos to trigger AI moves

🤖

3. AI Plays

Each piece thinks independently and suggests moves

\n\n

Create New Game

\n \n \n\n

🎉 Game Created!

\n Game ID: \n

\n Join URL: \n \n

\n Manage URL: \n \n

\n \n \n

\n\n

Join Existing Game

\n \n

\n\n \n\n",[],[158,249],["D",1757543138975],[190,191,192,193],[158],"8f1c278a-8e95-11f0-bea3-0224a6c84d84","index.ts",21,["D",1757543345056],"// Main backend server using Hono\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { gameRoutes } from \"./routes/game.ts\";\nimport { apiRoutes } from \"./routes/api.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Initialize database\nawait runMigrations();\n\n// API routes\napp.route(\"/api\", apiRoutes);\n\n// Game routes\napp.route(\"/game\", gameRoutes);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Homepage\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// 404 handler\napp.notFound(c => {\n return c.text(\"Not Found\", 404);\n});\n\nexport default app.fetch; // This is the entry point for HTTP vals",[],[164,259],"01a17ee6-8e95-11f0-8806-0224a6c84d84","websocket.ts","01a17f9a-8e95-11f0-8806-0224a6c84d84","76fcd33f-1c2f-46c2-b40d-80ecd71d4993",10,["D",1757543107697],"// WebSocket handling for real-time updates\n\nimport type { WSContext } from \"https://esm.sh/hono@3.11.7/adapter\";\nimport type { WSMessage } from \"../../shared/types.ts\";\nimport { normalizeGameId } from \"../../shared/utils.ts\";\n\n// Store active WebSocket connections by game ID\nconst gameConnections = new Map>();\n\nexport function wsHandler(c: any) {\n return {\n onOpen(evt: any, ws: WSContext) {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n \n if (!gameConnections.has(gameId)) {\n gameConnections.set(gameId, new Set());\n }\n \n gameConnections.get(gameId)!.add(ws);\n console.log(`WebSocket connected to game ${gameId}`);\n },\n\n onMessage(evt: any, ws: WSContext) {\n // Handle incoming messages if needed\n console.log(\"WebSocket message received:\", evt.data);\n },\n\n onClose(evt: any, ws: WSContext) {\n // Remove connection from all games\n for (const [gameId, connections] of gameConnections.entries()) {\n if (connections.has(ws)) {\n connections.delete(ws);\n console.log(`WebSocket disconnected from game ${gameId}`);\n \n // Clean up empty game connection sets\n if (connections.size === 0) {\n gameConnections.delete(gameId);\n }\n break;\n }\n }\n },\n\n onError(evt: any, ws: WSContext) {\n console.error(\"WebSocket error:\", evt);\n }\n };\n}\n\n// Broadcast message to all connections in a game\nexport function broadcastToGame(gameId: string, message: WSMessage) {\n const normalizedGameId = normalizeGameId(gameId);\n const connections = gameConnections.get(normalizedGameId);\n \n if (!connections || connections.size === 0) {\n return;\n }\n\n const messageStr = JSON.stringify(message);\n const deadConnections = new Set();\n\n for (const ws of connections) {\n try {\n ws.send(messageStr);\n } catch (error) {\n console.error(\"Error sending WebSocket message:\", error);\n deadConnections.add(ws);\n }\n }\n\n // Clean up dead connections\n for (const deadWs of deadConnections) {\n connections.delete(deadWs);\n }\n\n // Clean up empty game connection sets\n if (connections.size === 0) {\n gameConnections.delete(normalizedGameId);\n }\n}\n\n// Get connection count for a game\nexport function getGameConnectionCount(gameId: string): number {\n const normalizedGameId = normalizeGameId(gameId);\n return gameConnections.get(normalizedGameId)?.size || 0;\n}",[],[164,274,266],"routes","faacff48-8e94-11f0-970e-0224a6c84d84","game.ts","faad0010-8e94-11f0-970e-0224a6c84d84",9,["D",1757543096036],"// Game page routes\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport * as db from \"../database/queries.ts\";\nimport { normalizeGameId } from \"../../shared/utils.ts\";\n\nconst app = new Hono();\n\n// Join game page\napp.get(\"/:gameId\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const game = await db.getGame(gameId);\n \n if (!game) {\n return c.html(`\n \n Game Not Found\n \n

Game Not Found

The game \"${gameId}\" does not exist.

\n ← Back to Home\n \n \n `, 404);\n }\n\n let html = await readFile(\"/frontend/join.html\", import.meta.url);\n \n // Inject game data\n const gameData = {\n id: gameId,\n name: game.name,\n rules: game.rules\n };\n \n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error loading join page:\", error);\n return c.text(\"Internal Server Error\", 500);\n }\n});\n\n// Game management page\napp.get(\"/:gameId/manage/:managerId\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const managerId = c.req.param(\"managerId\");\n \n const game = await db.getGame(gameId);\n \n if (!game) {\n return c.html(`\n \n Game Not Found\n \n

Game Not Found

The game \"${gameId}\" does not exist.

\n ← Back to Home\n \n \n `, 404);\n }\n\n if (game.manager_id !== managerId) {\n return c.html(`\n \n Unauthorized\n \n

Unauthorized

Invalid manager ID for this game.

\n ← Join Game Instead\n \n \n `, 403);\n }\n\n let html = await readFile(\"/frontend/manage.html\", import.meta.url);\n \n // Get full game data\n const pieceTypes = await db.getPieceTypes(gameId);\n const players = await db.getPlayers(gameId);\n \n const gameData = {\n game,\n pieceTypes,\n players,\n managerId\n };\n \n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error loading manage page:\", error);\n return c.text(\"Internal Server Error\", 500);\n }\n});\n\n// Player game page\napp.get(\"/:gameId/play/:username\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const username = c.req.param(\"username\");\n \n const game = await db.getGame(gameId);\n \n if (!game) {\n return c.html(`\n \n Game Not Found\n \n

Game Not Found

The game \"${gameId}\" does not exist.

\n ← Back to Home\n \n \n `, 404);\n }\n\n if (!await db.playerExists(gameId, username)) {\n return c.html(`\n \n Player Not Found\n \n

Player Not Found

Player \"${username}\" is not registered for this game.

\n ← Join Game\n \n \n `, 404);\n }\n\n let html = await readFile(\"/frontend/play.html\", import.meta.url);\n \n // Get game data\n const pieceTypes = await db.getPieceTypes(gameId);\n const pieces = await db.getPlayerPieces(gameId, username);\n const latestTurn = await db.getLatestTurn(gameId);\n \n let latestMoves = [];\n if (latestTurn) {\n const moves = await db.getTurnMoves(latestTurn.id);\n latestMoves = await Promise.all(moves.map(async move => {\n const pieceInfo = await db.getPieceWithTypeInfo(move.piece_id);\n return {\n ...move,\n piece_name: pieceInfo?.piece_type_name || \"Unknown\",\n player_username: pieceInfo?.player_username || \"Unknown\"\n };\n }));\n }\n \n const gameData = {\n game,\n pieceTypes,\n pieces,\n username,\n latestTurn,\n latestMoves\n };\n \n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error loading play page:\", error);\n return c.text(\"Internal Server Error\", 500);\n }\n});\n\n// Clone game redirect\napp.get(\"/:gameId/clone\", async c => {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n return c.redirect(`/api/games/${gameId}/clone`, 302);\n});\n\nexport { app as gameRoutes };",[],[164,274,276],"c1e36f02-8e95-11f0-b0da-0224a6c84d84","api.ts","ee6df8f4-8e94-11f0-ab07-0224a6c84d84",28,["D",1757543430239],7,"// API routes for game management\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport * as db from \"../database/queries.ts\";\nimport { generateGameId, isValidUsername, normalizeGameId, extractMoveFromResponse, createLLMPrompt } from \"../../shared/utils.ts\";\nimport type { CreateGameRequest, CreateGameResponse, CreatePieceTypeRequest, JoinGameRequest, CreatePieceRequest, UpdateInstructionsRequest } from \"../../shared/types.ts\";\n\nconst app = new Hono();\nconst openai = new OpenAI();\n\n// Create new game\napp.post(\"/games\", async c => {\n try {\n const { game_name, game_rules }: CreateGameRequest = await c.req.json();\n \n if (!game_name || !game_rules) {\n return c.json({ error: \"Game name and rules are required\" }, 400);\n }\n\n // Generate unique game ID\n let gameId: string;\n do {\n gameId = generateGameId();\n } while (await db.gameExists(gameId));\n\n const managerId = generateGameId();\n\n await db.createGame({\n id: gameId,\n name: game_name,\n rules: game_rules,\n manager_id: managerId,\n include_previous_move: false\n });\n\n const response: CreateGameResponse = {\n game_id: gameId,\n manager_id: managerId,\n game_url: `/game/${gameId}`,\n manage_url: `/game/${gameId}/manage/${managerId}`\n };\n\n return c.json(response);\n } catch (error) {\n console.error(\"Error creating game:\", error);\n return c.json({ error: \"Failed to create game\" }, 500);\n }\n});\n\n// Clone existing game\napp.post(\"/games/:gameId/clone\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const existingGame = await db.getGame(gameId);\n \n if (!existingGame) {\n return c.json({ error: \"Game not found\" }, 404);\n }\n\n // Generate new IDs\n let newGameId: string;\n do {\n newGameId = generateGameId();\n } while (await db.gameExists(newGameId));\n\n const newManagerId = generateGameId();\n\n // Create new game with same rules\n await db.createGame({\n id: newGameId,\n name: `${existingGame.name} (Clone)`,\n rules: existingGame.rules,\n manager_id: newManagerId,\n include_previous_move: existingGame.include_previous_move\n });\n\n // Copy piece types\n const pieceTypes = await db.getPieceTypes(gameId);\n for (const pieceType of pieceTypes) {\n await db.createPieceType({\n game_id: newGameId,\n name: pieceType.name,\n description: pieceType.description\n });\n }\n\n const response: CreateGameResponse = {\n game_id: newGameId,\n manager_id: newManagerId,\n game_url: `/game/${newGameId}`,\n manage_url: `/game/${newGameId}/manage/${newManagerId}`\n };\n\n return c.json(response);\n } catch (error) {\n console.error(\"Error cloning game:\", error);\n return c.json({ error: \"Failed to clone game\" }, 500);\n }\n});\n\n// Get game info\napp.get(\"/games/:gameId\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n console.log(\"Looking for game:\", gameId);\n \n const game = await db.getGame(gameId);\n console.log(\"Found game:\", game);\n \n if (!game) {\n return c.json({ error: \"Game not found\" }, 404);\n }\n\n const pieceTypes = await db.getPieceTypes(gameId);\n const players = await db.getPlayers(gameId);\n\n return c.json({\n game,\n pieceTypes,\n players\n });\n } catch (error) {\n console.error(\"Error getting game:\", error);\n return c.json({ error: \"Failed to get game\" }, 500);\n }\n});\n\n// Create piece type\napp.post(\"/games/:gameId/piece-types\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const { piece_name, piece_description }: CreatePieceTypeRequest = await c.req.json();\n \n if (!piece_name || !piece_description) {\n return c.json({ error: \"Piece name and description are required\" }, 400);\n }\n\n const game = await db.getGame(gameId);\n if (!game) {\n return c.json({ error: \"Game not found\" }, 404);\n }\n\n const pieceTypeId = await db.createPieceType({\n game_id: gameId,\n name: piece_name,\n description: piece_description\n });\n\n return c.json({ id: pieceTypeId });\n } catch (error) {\n console.error(\"Error creating piece type:\", error);\n return c.json({ error: \"Failed to create piece type\" }, 500);\n }\n});\n\n// Join game\napp.post(\"/games/:gameId/join\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const { username }: JoinGameRequest = await c.req.json();\n \n if (!isValidUsername(username)) {\n return c.json({ error: \"Invalid username. Use alphanumeric characters only, no spaces.\" }, 400);\n }\n\n const game = await db.getGame(gameId);\n if (!game) {\n return c.json({ error: \"Game not found\" }, 404);\n }\n\n if (await db.playerExists(gameId, username)) {\n return c.json({ error: \"Username already taken in this game\" }, 409);\n }\n\n await db.createPlayer({\n game_id: gameId,\n username: username\n });\n\n return c.json({ success: true, play_url: `/game/${gameId}/play/${username}` });\n } catch (error) {\n console.error(\"Error joining game:\", error);\n return c.json({ error: \"Failed to join game\" }, 500);\n }\n});\n\n// Get player's pieces\napp.get(\"/games/:gameId/players/:username/pieces\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const username = c.req.param(\"username\");\n \n if (!await db.playerExists(gameId, username)) {\n return c.json({ error: \"Player not found\" }, 404);\n }\n\n const pieces = await db.getPlayerPieces(gameId, username);\n const pieceTypes = await db.getPieceTypes(gameId);\n \n // Enrich pieces with type information\n const enrichedPieces = pieces.map(piece => {\n const pieceType = pieceTypes.find(pt => pt.id === piece.piece_type_id);\n return {\n ...piece,\n piece_type_name: pieceType?.name || \"Unknown\",\n piece_type_description: pieceType?.description || \"\"\n };\n });\n\n return c.json(enrichedPieces);\n } catch (error) {\n console.error(\"Error getting player pieces:\", error);\n return c.json({ error: \"Failed to get pieces\" }, 500);\n }\n});\n\n// Create piece\napp.post(\"/games/:gameId/players/:username/pieces\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const username = c.req.param(\"username\");\n const { piece_type_id, instructions }: CreatePieceRequest = await c.req.json();\n \n if (!await db.playerExists(gameId, username)) {\n return c.json({ error: \"Player not found\" }, 404);\n }\n\n const pieceType = await db.getPieceType(piece_type_id);\n if (!pieceType || pieceType.game_id !== gameId) {\n return c.json({ error: \"Invalid piece type\" }, 400);\n }\n\n const pieceId = await db.createPiece({\n game_id: gameId,\n player_username: username,\n piece_type_id: piece_type_id,\n instructions: instructions || \"\",\n last_move: null\n });\n\n return c.json({ id: pieceId });\n } catch (error) {\n console.error(\"Error creating piece:\", error);\n return c.json({ error: \"Failed to create piece\" }, 500);\n }\n});\n\n// Update piece instructions\napp.put(\"/games/:gameId/pieces/:pieceId/instructions\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const pieceId = parseInt(c.req.param(\"pieceId\"));\n const { instructions }: UpdateInstructionsRequest = await c.req.json();\n \n await db.updatePieceInstructions(pieceId, instructions || \"\");\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error updating instructions:\", error);\n return c.json({ error: \"Failed to update instructions\" }, 500);\n }\n});\n\n// Start turn (photo upload and LLM processing)\napp.post(\"/games/:gameId/turns\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const initiatedBy = c.req.header(\"X-Username\") || \"unknown\";\n \n const formData = await c.req.formData();\n const photoFile = formData.get(\"photo\") as File;\n \n if (!photoFile) {\n return c.json({ error: \"Photo is required\" }, 400);\n }\n\n // Store photo in blob storage\n const photoKey = `game_${gameId}_turn_${Date.now()}`;\n const photoBuffer = await photoFile.arrayBuffer();\n const photoBase64 = btoa(String.fromCharCode(...new Uint8Array(photoBuffer)));\n await blob.setJSON(photoKey, { \n data: photoBase64, \n type: photoFile.type,\n name: photoFile.name \n });\n\n // Create snapshot of current game state\n const snapshot = await db.getGameSnapshot(gameId);\n \n // Create turn record\n const turnId = await db.createTurn({\n game_id: gameId,\n initiated_by: initiatedBy,\n photo_url: photoKey,\n snapshot_data: JSON.stringify(snapshot),\n status: 'processing'\n });\n\n // Broadcast turn started (placeholder for now)\n console.log(`Turn ${turnId} started by ${initiatedBy}`);\n\n // Process all pieces in parallel\n processTurnAsync(turnId, gameId, photoKey, snapshot);\n\n return c.json({ turn_id: turnId });\n } catch (error) {\n console.error(\"Error starting turn:\", error);\n return c.json({ error: \"Failed to start turn\" }, 500);\n }\n});\n\n// Get latest turn moves\napp.get(\"/games/:gameId/latest-moves\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const latestTurn = await db.getLatestTurn(gameId);\n \n if (!latestTurn) {\n return c.json({ moves: [] });\n }\n\n const moves = await db.getTurnMoves(latestTurn.id);\n \n // Enrich moves with piece information\n const enrichedMoves = await Promise.all(moves.map(async move => {\n const pieceInfo = await db.getPieceWithTypeInfo(move.piece_id);\n return {\n ...move,\n piece_name: pieceInfo?.piece_type_name || \"Unknown\",\n player_username: pieceInfo?.player_username || \"Unknown\"\n };\n }));\n\n return c.json({ \n turn: latestTurn,\n moves: enrichedMoves \n });\n } catch (error) {\n console.error(\"Error getting latest moves:\", error);\n return c.json({ error: \"Failed to get moves\" }, 500);\n }\n});\n\n// Update game settings (manager only)\napp.put(\"/games/:gameId/settings\", async c => {\n try {\n const gameId = normalizeGameId(c.req.param(\"gameId\"));\n const managerId = c.req.header(\"X-Manager-Id\");\n const { include_previous_move } = await c.req.json();\n \n const game = await db.getGame(gameId);\n if (!game) {\n return c.json({ error: \"Game not found\" }, 404);\n }\n\n if (game.manager_id !== managerId) {\n return c.json({ error: \"Unauthorized\" }, 403);\n }\n\n await db.updateGameSettings(gameId, include_previous_move);\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error updating settings:\", error);\n return c.json({ error: \"Failed to update settings\" }, 500);\n }\n});\n\n// Async function to process turn\nasync function processTurnAsync(turnId: number, gameId: string, photoKey: string, snapshot: any) {\n try {\n const pieces = snapshot.pieces;\n const game = snapshot.game;\n \n // Get photo data\n const photoData = await blob.getJSON(photoKey);\n const photoBase64 = `data:${photoData.type};base64,${photoData.data}`;\n\n // Create moves for all pieces\n const movePromises = pieces.map(async (piece: any) => {\n const moveId = await db.createMove({\n turn_id: turnId,\n piece_id: piece.id,\n thinking_process: \"\",\n final_move: \"\",\n status: 'pending',\n error_message: null\n });\n\n return processPieceMove(moveId, piece, game, photoBase64, snapshot);\n });\n\n // Wait for all moves to complete\n await Promise.all(movePromises);\n\n // Update turn status\n await db.updateTurnStatus(turnId, 'completed');\n \n // Log completion\n console.log(`Turn ${turnId} completed`);\n\n } catch (error) {\n console.error(\"Error processing turn:\", error);\n await db.updateTurnStatus(turnId, 'error');\n }\n}\n\n// Process individual piece move\nasync function processPieceMove(moveId: number, piece: any, game: any, photoBase64: string, snapshot: any) {\n try {\n // Find piece type info\n const pieceType = snapshot.pieceTypes.find((pt: any) => pt.id === piece.piece_type_id);\n \n // Create LLM prompt context\n const context = {\n game_rules: game.rules,\n piece_name: pieceType?.name || \"Unknown Piece\",\n piece_description: pieceType?.description || \"\",\n player_instructions: piece.instructions || \"\",\n photo_url: photoBase64\n };\n\n // Add previous move if setting is enabled\n if (game.include_previous_move && piece.last_move) {\n context.previous_move = piece.last_move;\n }\n\n const prompt = createLLMPrompt(context);\n\n // Call OpenAI Vision API\n const completion = await openai.chat.completions.create({\n model: \"gpt-4o\",\n messages: [\n {\n role: \"user\",\n content: [\n { type: \"text\", text: prompt },\n { \n type: \"image_url\", \n image_url: { url: photoBase64 }\n }\n ]\n }\n ],\n max_tokens: 500\n });\n\n const response = completion.choices[0]?.message?.content || \"No response generated\";\n const { thinking, move } = extractMoveFromResponse(response);\n\n // Update move in database\n await db.updateMove(moveId, thinking, move, 'completed');\n\n // Update piece's last move if setting is enabled\n if (game.include_previous_move) {\n await db.updatePieceLastMove(piece.id, move);\n }\n\n // Log move update\n console.log(`Move completed for piece ${piece.id}: ${move}`);\n\n } catch (error) {\n console.error(`Error processing piece ${piece.id}:`, error);\n \n await db.updateMove(moveId, \"\", \"\", 'error', error.message);\n }\n}\n\nexport { app as apiRoutes };",[],[164,274,284],"ee6e1564-8e94-11f0-ab07-0224a6c84d84",8,["D",1757543075489],[185,186,187],[164,274],"5dbaf300-8e96-11f0-afc6-0224a6c84d84","f9e21dfc-0457-4939-8ae2-29354305b557",["D",1757543691712],[],[164,302,33],"database","b601d526-8e94-11f0-9139-0224a6c84d84","migrations.ts","b601d5da-8e94-11f0-9139-0224a6c84d84",["D",1757542980823],"// Database schema migrations for LLM Board Game Server\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nexport async function runMigrations() {\n // Games table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS games (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n rules TEXT NOT NULL,\n manager_id TEXT NOT NULL,\n include_previous_move BOOLEAN DEFAULT FALSE,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Piece types table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS piece_types (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (game_id) REFERENCES games (id) ON DELETE CASCADE\n )\n `);\n\n // Players table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS players (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n username TEXT NOT NULL,\n joined_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (game_id) REFERENCES games (id) ON DELETE CASCADE,\n UNIQUE (game_id, username)\n )\n `);\n\n // Pieces table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS pieces (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n player_username TEXT NOT NULL,\n piece_type_id INTEGER NOT NULL,\n instructions TEXT DEFAULT '',\n last_move TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (game_id) REFERENCES games (id) ON DELETE CASCADE,\n FOREIGN KEY (piece_type_id) REFERENCES piece_types (id) ON DELETE CASCADE,\n FOREIGN KEY (game_id, player_username) REFERENCES players (game_id, username) ON DELETE CASCADE\n )\n `);\n\n // Turns table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS turns (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n initiated_by TEXT NOT NULL,\n photo_url TEXT NOT NULL,\n snapshot_data TEXT NOT NULL,\n status TEXT DEFAULT 'processing',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n completed_at DATETIME,\n FOREIGN KEY (game_id) REFERENCES games (id) ON DELETE CASCADE\n )\n `);\n\n // Moves table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS moves (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n turn_id INTEGER NOT NULL,\n piece_id INTEGER NOT NULL,\n thinking_process TEXT DEFAULT '',\n final_move TEXT DEFAULT '',\n status TEXT DEFAULT 'pending',\n error_message TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n completed_at DATETIME,\n FOREIGN KEY (turn_id) REFERENCES turns (id) ON DELETE CASCADE,\n FOREIGN KEY (piece_id) REFERENCES pieces (id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_games_id ON games (id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_piece_types_game_id ON piece_types (game_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_players_game_id ON players (game_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_pieces_game_id ON pieces (game_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_pieces_player ON pieces (game_id, player_username)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_turns_game_id ON turns (game_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_moves_turn_id ON moves (turn_id)`);\n\n console.log(\"Database migrations completed successfully\");\n}",[],[164,302,304],"b601e264-8e94-11f0-9139-0224a6c84d84",["D",1757542980823],[182,183],[164,302],["D",1757542980823],[181,184,188],[164],["D",1757539062598],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":354,"_355":356,"_357":358,"_359":25,"_360":25,"_361":25,"_362":59,"_363":-5,"_364":-7,"_365":-7,"_366":63,"_367":25,"_368":25,"_369":-5,"_370":25,"_371":25,"_372":25,"_373":-5},"ENV",{"_325":326,"_327":328,"_329":87,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

Diff · v30