[{"_1":2,"_240":-5,"_241":-5},"loaderData",{"_3":4,"_93":94,"_203":204},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":-5,"_32":33,"_34":22,"_35":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e9e636d7b466d0cb012ac9b89f74068c1d9c5525","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":22,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":22,"_92":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":22,"_21":22,"_84":74,"_85":86,"_87":74,"_88":47,"_89":22,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_95":96,"_97":98,"_99":45,"_100":101,"_102":-7,"_103":104,"_154":155,"_176":177,"_178":179,"_191":192,"_193":194,"_197":-5,"_198":-5,"_199":22,"_200":22,"_201":202},"handle","kliv","name","tee42sqq3ff8v144e8s2et1t63s1s3032t","branchName","path","fuf50v1055v1764vvt97s914se1q9vs7v1.ts","version","project",{"_105":106,"_97":98,"_107":108,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":-5,"_120":33,"_16":121,"_122":-5,"_123":-5,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_141":142,"_153":22},"id","f942e68c-0116-11f1-a9da-42dde27851f2","createdAt",["D",1770133360798],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","0199d9f9-8fb9-705d-a1be-150ee5ea0145","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","0199d9f9-8fb9-705d-a1be-18ed6d1d02d7","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_134":135},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","org",{"_95":96,"_138":135,"_14":115,"_139":140},"avatar","tier","free","branch",{"_102":143,"_97":45,"_105":144,"_145":106,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":98,"_152":96},4,"f94326ba-0116-11f1-a9da-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[156],{"_105":157,"_97":101,"_158":159,"_160":-5,"_161":144,"_162":143,"_163":164,"_107":165,"_102":166,"_167":168,"_169":170,"_171":22,"_172":-5,"_173":174,"_100":175},"97d97fc0-0119-11f1-b157-42dde27851f2","fileId","f955761c-0116-11f1-a9da-42dde27851f2","parentId","branchId","branchVersion","latest",true,["D",1770134485842],3,"fileType","http","content","import { connect } from \"npm:@tursodatabase/serverless\";\n\nfunction generateCode() {\n const chars = \"ABCDEFGHJKLMNPQRSTUVWXYZ23456789\";\n let code = \"\";\n for (let i = 0; i < 6; i++) code += chars[Math.floor(Math.random() * chars.length)];\n return code;\n}\n\nfunction generateId() {\n return crypto.randomUUID();\n}\n\nfunction shuffleArray(arr) {\n const a = [...arr];\n for (let i = a.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [a[i], a[j]] = [a[j], a[i]];\n }\n return a;\n}\n\nfunction assignRoles(playerCount, botCount = 0) {\n let mafiaCount = 1;\n if (playerCount >= 7) mafiaCount = 2;\n if (playerCount >= 10) mafiaCount = 3;\n if (botCount > 0 && playerCount >= 5) mafiaCount = Math.max(1, Math.floor(playerCount / 4));\n\n const roles = [];\n for (let i = 0; i < mafiaCount; i++) roles.push(\"mafia\");\n roles.push(\"doctor\");\n roles.push(\"detective\");\n while (roles.length < playerCount) roles.push(\"villager\");\n return shuffleArray(roles);\n}\n\nconst BOT_NAMES = [\n \"Alex\", \"Blake\", \"Casey\", \"Drew\", \"Ellis\", \"Finley\", \"Gray\", \"Harper\", \n \"Indigo\", \"Jordan\", \"Kai\", \"Logan\", \"Morgan\", \"Nico\", \"Ocean\", \"Piper\",\n \"Quinn\", \"Ray\", \"Sage\", \"Taylor\", \"Vale\", \"Winter\", \"Zion\", \"Avery\"\n];\n\nfunction generateBotNames(count, existingNames) {\n const available = BOT_NAMES.filter(n => !existingNames.includes(n));\n return shuffleArray(available).slice(0, count);\n}\n\nfunction getBotVote(playerNames, botRole, mafiaPlayers) {\n if (playerNames.length === 0) return null;\n \n const nonMafiaTargets = playerNames.filter(n => !mafiaPlayers.includes(n));\n const targets = botRole === \"mafia\" ? nonMafiaTargets : playerNames;\n \n if (targets.length === 0) return null;\n \n if (Math.random() < 0.2) return \"skip\";\n \n const targetIndex = Math.floor(Math.random() * targets.length);\n return targets[targetIndex];\n}\n\nfunction getBotNightAction(alivePlayers, botRole, mafiaPlayers) {\n if (alivePlayers.length === 0) return null;\n \n const nonMafiaTargets = alivePlayers.filter(p => !mafiaPlayers.includes(p.player_name));\n const targets = botRole === \"mafia\" ? nonMafiaTargets : alivePlayers;\n \n if (targets.length === 0) return null;\n \n const targetIndex = Math.floor(Math.random() * targets.length);\n return targets[targetIndex].player_name;\n}\n\nfunction getBotMessage(botRole) {\n if (Math.random() > 0.3) return null;\n \n const villagerMessages = [\n \"I'm just a simple villager, honest!\",\n \"I hope the doctor saves someone tonight!\",\n \"Who do y'all think the mafia is?\",\n \"This is getting intense!\",\n \"I have no leads, sadly.\",\n \"Let's work together!\",\n \"I'm feeling nervous now...\",\n \"Why is everyone so quiet today?\",\n \"Something doesn't feel right.\",\n \"Let's not rush to conclusions.\",\n ];\n \n const mafiaMessages = [\n \"I think we need to watch someone...\",\n \"Those are good points about someone.\",\n \"I'm confused about what to think.\",\n \"We need to find a real lead.\",\n \"I don't suspect certain people, they seem genuine.\",\n ];\n \n const messages = botRole === \"mafia\" ? mafiaMessages : villagerMessages;\n return messages[Math.floor(Math.random() * messages.length)];\n}\n\n// Helper function to process bot actions inline\nasync function processBotActions(conn, game_id, phase, game_current_round, now, createdBy) {\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n const botPlayers = players.filter(p => p.session_id.startsWith(\"bot-\") && p.is_alive);\n \n if (botPlayers.length === 0) return;\n \n const mafiaPlayers = players.filter(p => p.role === \"mafia\").map(p => p.player_name);\n const alivePlayers = players.filter(p => p.is_alive && p.player_name);\n const alivePlayerNames = alivePlayers.map(p => p.player_name);\n\n if (phase === \"night\") {\n for (const bot of botPlayers) {\n if (![\"mafia\", \"doctor\", \"detective\"].includes(bot.role)) continue;\n \n const target = getBotNightAction(alivePlayers, bot.role, mafiaPlayers);\n \n await conn.prepare(\"DELETE FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\").run([game_id, game_current_round, bot.player_name]);\n \n if (target) {\n const actionType = bot.role === \"mafia\" ? \"kill\" : bot.role;\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game_current_round, bot.player_name, actionType, target, createdBy, now, now]);\n }\n }\n } else if (phase === \"day\") {\n for (const bot of botPlayers) {\n const message = getBotMessage(bot.role);\n if (message) {\n await conn.prepare(\n \"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, 'public', ?, ?, ?, ?)\"\n ).run([game_id, bot.player_name, message, game_current_round, createdBy, now, now]);\n }\n }\n } else if (phase === \"voting\") {\n for (const bot of botPlayers) {\n const targets = alivePlayerNames.filter(n => n !== bot.player_name);\n const target = getBotVote(targets, bot.role, mafiaPlayers);\n \n if (target) {\n await conn.prepare(\n \"INSERT INTO game_votes (game_id, round_num, voter_name, target_name, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game_current_round, bot.player_name, target, createdBy, now, now]);\n }\n }\n }\n}\n\nexport default async function(req) {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n const now = Math.floor(Date.now() / 1000);\n const createdBy = req.headers.get(\"x-user-uuid\") || \"anonymous\";\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204 });\n }\n\n const body = await req.json();\n const { action } = body;\n\n try {\n // CREATE GAME\n if (action === \"create_game\") {\n const { player_name, with_bots, bot_count } = body;\n if (!player_name) return Response.json({ error: \"Player name required\" }, { status: 400 });\n\n const game_code = generateCode();\n const gm_secret = generateId();\n const session_id = generateId();\n const hasBots = with_bots === true || bot_count > 0;\n const numBots = bot_count || 0;\n\n const gameStmt = conn.prepare(\n \"INSERT INTO games (game_code, status, phase, current_round, gm_secret, _created_by, _created_at, _updated_at) VALUES (?, 'waiting', 'lobby', 0, ?, ?, ?, ?)\"\n );\n await gameStmt.run([game_code, gm_secret, createdBy, now, now]);\n\n const gameRow = await conn.prepare(\"SELECT _row_id FROM games WHERE game_code = ?\").get([game_code]);\n\n const playerStmt = conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_by, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 1, ?, ?, ?)\"\n );\n await playerStmt.run([gameRow._row_id, player_name, session_id, createdBy, now, now]);\n\n if (hasBots && numBots > 0) {\n const botNames = generateBotNames(numBots, [player_name]);\n for (let i = 0; i < botNames.length; i++) {\n await conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_by, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 0, ?, ?, ?)\"\n ).run([gameRow._row_id, botNames[i], `bot-${gameRow._row_id}-${i}`, createdBy, now, now]);\n }\n }\n\n return Response.json({\n success: true,\n game_code,\n gm_secret,\n session_id,\n game_id: gameRow._row_id,\n has_bots: hasBots\n });\n }\n\n // JOIN GAME\n if (action === \"join_game\") {\n const { game_code, player_name } = body;\n if (!game_code || !player_name) return Response.json({ error: \"Game code and player name required\" }, { status: 400 });\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE game_code = ?\").get([game_code]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.status !== \"waiting\") return Response.json({ error: \"Game already started\" }, { status: 400 });\n\n const existing = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND player_name = ?\").get([game._row_id, player_name]);\n if (existing) return Response.json({ error: \"Name already taken in this game\" }, { status: 400 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game._row_id]);\n if (players.length >= game.max_players) return Response.json({ error: \"Game is full\" }, { status: 400 });\n\n const session_id = generateId();\n await conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_by, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 0, ?, ?, ?)\"\n ).run([game._row_id, player_name, session_id, createdBy, now, now]);\n\n return Response.json({\n success: true,\n session_id,\n game_id: game._row_id,\n game_code: game.game_code\n });\n }\n\n // START GAME\n if (action === \"start_game\") {\n const { game_id, gm_secret } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.gm_secret !== gm_secret) return Response.json({ error: \"Not authorized\" }, { status: 403 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n if (players.length < 4) return Response.json({ error: \"Need at least 4 players (including bots)\" }, { status: 400 });\n\n const roles = assignRoles(players.length);\n const botPlayers = players.filter(p => p.session_id.startsWith(\"bot-\"));\n\n const batch = [];\n players.forEach((p, i) => {\n batch.push(\n conn.prepare(\"UPDATE game_players SET role = ?, _updated_at = ? WHERE _row_id = ?\").bind([roles[i], now, p._row_id])\n );\n });\n\n batch.push(\n conn.prepare(\"UPDATE games SET status = 'in_progress', phase = 'night', current_round = 1, _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', 'The game has begun! Night falls over the village... The Mafia awakens.', 'system', 1, ?, ?, ?)\").bind([game_id, createdBy, now, now])\n );\n\n await conn.batch(batch);\n\n if (botPlayers.length > 0) {\n await processBotActions(conn, game_id, \"night\", 1, now, createdBy);\n }\n\n return Response.json({ success: true });\n }\n\n // GET STATE\n if (action === \"get_state\") {\n const { game_id, session_id } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n\n const players = await conn.prepare(\"SELECT _row_id, game_id, player_name, role, is_alive, session_id, is_gm FROM game_players WHERE game_id = ?\").all([game_id]);\n const me = players.find(p => p.session_id === session_id);\n if (!me) return Response.json({ error: \"Player not in game\" }, { status: 403 });\n\n let messages = [];\n if (me.role === \"mafia\" || me.is_gm === 1) {\n messages = await conn.prepare(\n \"SELECT * FROM game_messages WHERE game_id = ? ORDER BY _created_at ASC\"\n ).all([game_id]);\n } else {\n messages = await conn.prepare(\n \"SELECT * FROM game_messages WHERE game_id = ? AND channel != 'mafia' ORDER BY _created_at ASC\"\n ).all([game_id]);\n }\n\n const votes = await conn.prepare(\n \"SELECT * FROM game_votes WHERE game_id = ? AND round_num = ?\"\n ).all([game_id, game.current_round]);\n\n let actions = [];\n if (me.is_gm === 1) {\n actions = await conn.prepare(\n \"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ?\"\n ).all([game_id, game.current_round]);\n } else {\n actions = await conn.prepare(\n \"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\"\n ).all([game_id, game.current_round, me.player_name]);\n }\n\n const sanitizedPlayers = players.map(p => ({\n player_name: p.player_name,\n is_alive: p.is_alive,\n is_gm: p.is_gm,\n is_bot: p.session_id.startsWith(\"bot-\"),\n role: (p.session_id === session_id || me.is_gm === 1 || !p.is_alive || p.session_id.startsWith(\"bot-\")) ? p.role : \"unknown\"\n }));\n\n return Response.json({\n game: {\n game_code: game.game_code,\n status: game.status,\n phase: game.phase,\n current_round: game.current_round,\n winner: game.winner\n },\n players: sanitizedPlayers,\n me: {\n player_name: me.player_name,\n role: me.role,\n is_alive: me.is_alive,\n is_gm: me.is_gm\n },\n messages,\n votes,\n actions\n });\n }\n\n // SEND MESSAGE\n if (action === \"send_message\") {\n const { game_id, session_id, message, channel } = body;\n if (!message || !message.trim()) return Response.json({ error: \"Message required\" }, { status: 400 });\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.status !== \"in_progress\") return Response.json({ error: \"Game not active\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player) return Response.json({ error: \"Not in game\" }, { status: 403 });\n\n let msgChannel = channel || \"public\";\n if (msgChannel === \"mafia\" && player.role !== \"mafia\") {\n return Response.json({ error: \"Only mafia can use this channel\" }, { status: 403 });\n }\n\n if (!player.is_alive && msgChannel !== \"dead\") {\n msgChannel = \"dead\";\n }\n\n await conn.prepare(\n \"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, player.player_name, message.trim(), msgChannel, game.current_round, createdBy, now, now]);\n\n return Response.json({ success: true });\n }\n\n // SUBMIT VOTE\n if (action === \"submit_vote\") {\n const { game_id, session_id, target_name } = body;\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.phase !== \"voting\") return Response.json({ error: \"Not in voting phase\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player || !player.is_alive) return Response.json({ error: \"Cannot vote\" }, { status: 403 });\n\n await conn.prepare(\"DELETE FROM game_votes WHERE game_id = ? AND round_num = ? AND voter_name = ?\").run([game_id, game.current_round, player.player_name]);\n\n if (target_name && target_name !== \"skip\") {\n await conn.prepare(\n \"INSERT INTO game_votes (game_id, round_num, voter_name, target_name, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, player.player_name, target_name, createdBy, now, now]);\n }\n\n return Response.json({ success: true });\n }\n\n // SUBMIT NIGHT ACTION\n if (action === \"submit_action\") {\n const { game_id, session_id, target_name } = body;\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.phase !== \"night\") return Response.json({ error: \"Not night phase\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player || !player.is_alive) return Response.json({ error: \"Cannot act\" }, { status: 403 });\n\n let actionType = \"\";\n if (player.role === \"mafia\") actionType = \"kill\";\n else if (player.role === \"doctor\") actionType = \"heal\";\n else if (player.role === \"detective\") actionType = \"investigate\";\n else return Response.json({ error: \"No night action available\" }, { status: 400 });\n\n await conn.prepare(\"DELETE FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\").run([game_id, game.current_round, player.player_name]);\n\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_by, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, player.player_name, actionType, target_name, createdBy, now, now]);\n\n if (actionType === \"investigate\") {\n const target = await conn.prepare(\"SELECT role FROM game_players WHERE game_id = ? AND player_name = ?\").get([game_id, target_name]);\n const isMafia = target && target.role === \"mafia\";\n return Response.json({ success: true, investigation: isMafia ? \"suspicious\" : \"innocent\" });\n }\n\n return Response.json({ success: true });\n }\n\n // BOT ACTIONS\n if (action === \"bot_actions\") {\n const { game_id, phase } = body;\n \n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.status !== \"in_progress\") return Response.json({ error: \"Game not active\" }, { status: 400 });\n\n await processBotActions(conn, game_id, phase, game.current_round, now, createdBy);\n\n return Response.json({ success: true });\n }\n\n // ADVANCE PHASE (GM only)\n if (action === \"advance_phase\") {\n const { game_id, gm_secret } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.gm_secret !== gm_secret) return Response.json({ error: \"Not authorized\" }, { status: 403 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n const alivePlayers = players.filter(p => p.is_alive);\n const batch = [];\n let nextPhase = \"\";\n let newRound = game.current_round;\n\n if (game.phase === \"night\") {\n const actions = await conn.prepare(\"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ?\").all([game_id, game.current_round]);\n \n const kills = actions.filter(a => a.action_type === \"kill\");\n const heals = actions.filter(a => a.action_type === \"heal\");\n \n const killVotes = {};\n kills.forEach(k => { killVotes[k.target_name] = (killVotes[k.target_name] || 0) + 1; });\n \n let killTarget = null;\n let maxVotes = 0;\n for (const [name, count] of Object.entries(killVotes)) {\n if (count > maxVotes) { maxVotes = count; killTarget = name; }\n }\n\n const healed = heals.map(h => h.target_name);\n let killMessage = \"\";\n\n if (killTarget && !healed.includes(killTarget)) {\n const killed = players.find(p => p.player_name === killTarget);\n batch.push(\n conn.prepare(\"UPDATE game_players SET is_alive = 0, _updated_at = ? WHERE game_id = ? AND player_name = ?\").bind([now, game_id, killTarget])\n );\n killMessage = `☀️ Dawn breaks... ${killTarget} was found dead. They were a ${killed?.role || \"villager\"}.`;\n } else if (killTarget && healed.includes(killTarget)) {\n killMessage = \"☀️ Dawn breaks... The Doctor saved someone during the night! No one died.\";\n } else {\n killMessage = \"☀️ Dawn breaks... The night was peaceful. No one died.\";\n }\n\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', ?, 'system', ?, ?, ?, ?)\").bind([game_id, killMessage, game.current_round, createdBy, now, now])\n );\n\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'day', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n nextPhase = \"day\";\n\n const aliveAfter = killTarget && !healed.includes(killTarget)\n ? alivePlayers.filter(p => p.player_name !== killTarget)\n : alivePlayers;\n \n const aliveMafia = aliveAfter.filter(p => p.role === \"mafia\").length;\n const aliveVillage = aliveAfter.filter(p => p.role !== \"mafia\").length;\n\n if (aliveMafia === 0) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'village', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', '🎉 The Village wins! All mafia members have been eliminated!', 'system', ?, ?, ?, ?)\").bind([game_id, game.current_round, createdBy, now, now]));\n nextPhase = \"gameover\";\n } else if (aliveMafia >= aliveVillage) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'mafia', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', '💀 The Mafia wins! They have taken over the village!', 'system', ?, ?, ?, ?)\").bind([game_id, game.current_round, createdBy, now, now]));\n nextPhase = \"gameover\";\n }\n\n } else if (game.phase === \"day\") {\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'voting', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', '🗳️ Time to vote! Choose who you think is Mafia, or vote to skip.', 'system', ?, ?, ?, ?)\").bind([game_id, game.current_round, createdBy, now, now])\n );\n nextPhase = \"voting\";\n\n } else if (game.phase === \"voting\") {\n const votes = await conn.prepare(\"SELECT * FROM game_votes WHERE game_id = ? AND round_num = ?\").all([game_id, game.current_round]);\n \n const voteCounts = {};\n votes.forEach(v => { voteCounts[v.target_name] = (voteCounts[v.target_name] || 0) + 1; });\n \n let eliminatedName = null;\n let maxVoteCount = 0;\n let tie = false;\n for (const [name, count] of Object.entries(voteCounts)) {\n if (count > maxVoteCount) { maxVoteCount = count; eliminatedName = name; tie = false; }\n else if (count === maxVoteCount) { tie = true; }\n }\n\n if (eliminatedName && !tie && maxVoteCount > 1) {\n const eliminated = players.find(p => p.player_name === eliminatedName);\n batch.push(\n conn.prepare(\"UPDATE game_players SET is_alive = 0, _updated_at = ? WHERE game_id = ? AND player_name = ?\").bind([now, game_id, eliminatedName])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', ?, 'system', ?, ?, ?, ?)\").bind([game_id, `⚖️ The village has spoken! ${eliminatedName} has been eliminated. They were a ${eliminated?.role || \"villager\"}.`, game.current_round, createdBy, now, now])\n );\n\n const aliveAfterVote = alivePlayers.filter(p => p.player_name !== eliminatedName);\n const aliveMafia = aliveAfterVote.filter(p => p.role === \"mafia\").length;\n const aliveVillageCount = aliveAfterVote.filter(p => p.role !== \"mafia\").length;\n\n if (aliveMafia === 0) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'village', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', '🎉 The Village wins! All mafia members have been eliminated!', 'system', ?, ?, ?, ?)\").bind([game_id, game.current_round, createdBy, now, now]));\n nextPhase = \"gameover\";\n } else if (aliveMafia >= aliveVillageCount) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'mafia', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', '💀 The Mafia wins! They have taken over the village!', 'system', ?, ?, ?, ?)\").bind([game_id, game.current_round, createdBy, now, now]));\n nextPhase = \"gameover\";\n }\n } else {\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', '🤷 No consensus reached. No one was eliminated.', 'system', ?, ?, ?, ?)\").bind([game_id, game.current_round, createdBy, now, now])\n );\n }\n\n newRound = game.current_round + 1;\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'night', current_round = ?, _updated_at = ? WHERE _row_id = ?\").bind([newRound, now, game_id])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_by, _created_at, _updated_at) VALUES (?, '🎭 System', '🌙 Night falls once again... The Mafia awakens.', 'system', ?, ?, ?, ?)\").bind([game_id, newRound, createdBy, now, now])\n );\n nextPhase = \"night\";\n }\n\n if (batch.length > 0) await conn.batch(batch);\n \n if (nextPhase && nextPhase !== \"gameover\") {\n await processBotActions(conn, game_id, nextPhase, newRound, now, createdBy);\n }\n\n return Response.json({ success: true });\n }\n\n return Response.json({ error: \"Unknown action\" }, { status: 400 });\n } catch (err) {\n console.error(\"Game engine error:\", err);\n return Response.json({ error: err.message || \"Internal error\" }, { status: 500 });\n }\n}","deleted","label","children",[],[101],"files",[156],"counts",{"_180":33,"_181":182,"_183":33,"_184":185,"_188":189},"pulls","branches",1,"forks","envVars",{"_186":33,"_187":33},"count","emptyCount","connections",{"_186":33,"_190":33},"unfilledCount","contents",[],"file",{"_105":157,"_161":144,"_158":159,"_97":101,"_169":170,"_167":168,"_102":166,"_160":-5,"_107":195,"_162":143,"_172":-5,"_100":196},["D",1770134485842],[101],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_95":96,"_97":98,"_99":45,"_100":101,"_103":205,"_193":210,"_213":214,"_230":231,"_237":-7,"_238":33,"_239":22},{"_105":106,"_97":98,"_107":206,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":-5,"_120":33,"_16":121,"_122":-5,"_123":-5,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":207,"_136":208,"_141":209,"_153":22},["D",1770133360798],{"_95":96,"_134":135},{"_95":96,"_138":135,"_14":115,"_139":140},{"_102":143,"_97":45,"_105":144,"_145":106,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":98,"_152":96},{"_105":157,"_97":101,"_158":159,"_160":-5,"_161":144,"_162":143,"_163":164,"_107":211,"_102":166,"_167":168,"_169":170,"_171":22,"_172":-5,"_100":212},["D",1770134485842],[101],"history",[215,217,222,226],{"_105":157,"_161":144,"_158":159,"_97":101,"_169":170,"_167":168,"_102":166,"_160":-5,"_107":216,"_162":143,"_172":-5},["D",1770134485842],{"_105":218,"_161":144,"_158":159,"_97":101,"_169":219,"_167":168,"_102":220,"_160":-5,"_107":221,"_162":166,"_172":-5},"79011fcc-0119-11f1-9401-42dde27851f2","import { connect } from \"npm:@tursodatabase/serverless\";\n\nfunction generateCode() {\n const chars = \"ABCDEFGHJKLMNPQRSTUVWXYZ23456789\";\n let code = \"\";\n for (let i = 0; i < 6; i++) code += chars[Math.floor(Math.random() * chars.length)];\n return code;\n}\n\nfunction generateId() {\n return crypto.randomUUID();\n}\n\nfunction shuffleArray(arr) {\n const a = [...arr];\n for (let i = a.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [a[i], a[j]] = [a[j], a[i]];\n }\n return a;\n}\n\nfunction assignRoles(playerCount, botCount = 0) {\n let mafiaCount = 1;\n if (playerCount >= 7) mafiaCount = 2;\n if (playerCount >= 10) mafiaCount = 3;\n if (botCount > 0 && playerCount >= 5) mafiaCount = Math.max(1, Math.floor(playerCount / 4));\n\n const roles = [];\n for (let i = 0; i < mafiaCount; i++) roles.push(\"mafia\");\n roles.push(\"doctor\");\n roles.push(\"detective\");\n while (roles.length < playerCount) roles.push(\"villager\");\n return shuffleArray(roles);\n}\n\nconst BOT_NAMES = [\n \"Alex\", \"Blake\", \"Casey\", \"Drew\", \"Ellis\", \"Finley\", \"Gray\", \"Harper\", \n \"Indigo\", \"Jordan\", \"Kai\", \"Logan\", \"Morgan\", \"Nico\", \"Ocean\", \"Piper\",\n \"Quinn\", \"Ray\", \"Sage\", \"Taylor\", \"Vale\", \"Winter\", \"Zion\", \"Avery\"\n];\n\nfunction generateBotNames(count, existingNames) {\n const available = BOT_NAMES.filter(n => !existingNames.includes(n));\n return shuffleArray(available).slice(0, count);\n}\n\nfunction getBotVote(playerNames, botRole, mafiaPlayers, previousVotes) {\n if (playerNames.length === 0) return null;\n \n const nonMafiaTargets = playerNames.filter(n => !mafiaPlayers.includes(n));\n const targets = botRole === \"mafia\" ? nonMafiaTargets : playerNames;\n \n if (targets.length === 0) return null;\n \n if (Math.random() < 0.2) return \"skip\";\n \n const random = Math.random();\n const targetIndex = Math.floor(random * targets.length);\n return targets[targetIndex];\n}\n\nfunction getBotNightAction(alivePlayers, botRole, mafiaPlayers) {\n if (alivePlayers.length === 0) return null;\n \n const nonMafiaTargets = alivePlayers.filter(p => !mafiaPlayers.includes(p.player_name));\n const targets = botRole === \"mafia\" ? nonMafiaTargets : alivePlayers;\n \n if (targets.length === 0) return null;\n \n const random = Math.random();\n const targetIndex = Math.floor(random * targets.length);\n return targets[targetIndex].player_name;\n}\n\nfunction getBotMessage(phase, botRole, botName, round) {\n if (Math.random() > 0.3) return null;\n \n const suspiciousMessages = [\n \"I think someone is acting strange...\",\n \"Why is everyone so quiet today?\",\n \"I'm suspicious of someone, just trying to observe.\",\n \"We need to be careful with our votes!\",\n \"Something doesn't feel right.\",\n \"Let's not rush to conclusions.\",\n \"I've been watching the votes...\",\n ];\n \n const villagerMessages = [\n \"I'm just a simple villager, honest!\",\n \"I hope the doctor saves someone tonight!\",\n \"Who do y'all think the mafia is?\",\n \"This is getting intense!\",\n \"I have no leads, sadly.\",\n \"Let's work together!\",\n \"I'm feeling nervous now...\",\n ];\n \n const mafiaMessages = [\n \"I think it might be someone...\",\n \"Those are good points about someone.\",\n \"I'm confused about what to think.\",\n \"We need to find a real lead.\",\n \"I don't suspect certain people, they seem genuine.\",\n ];\n \n const messages = botRole === \"mafia\" ? mafiaMessages : villagerMessages;\n return messages[Math.floor(Math.random() * messages.length)];\n}\n\nexport default async function(req) {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n const now = Math.floor(Date.now() / 1000);\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204 });\n }\n\n const body = await req.json();\n const { action } = body;\n\n try {\n // CREATE GAME\n if (action === \"create_game\") {\n const { player_name, with_bots, bot_count } = body;\n if (!player_name) return Response.json({ error: \"Player name required\" }, { status: 400 });\n\n const game_code = generateCode();\n const gm_secret = generateId();\n const session_id = generateId();\n const hasBots = with_bots === true || bot_count > 0;\n const numBots = bot_count || 0;\n\n const gameStmt = conn.prepare(\n \"INSERT INTO games (game_code, status, phase, current_round, gm_secret, _created_at, _updated_at) VALUES (?, 'waiting', 'lobby', 0, ?, ?, ?)\"\n );\n await gameStmt.run([game_code, gm_secret, now, now]);\n\n const gameRow = await conn.prepare(\"SELECT _row_id FROM games WHERE game_code = ?\").get([game_code]);\n\n const playerStmt = conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 1, ?, ?)\"\n );\n await playerStmt.run([gameRow._row_id, player_name, session_id, now, now]);\n\n // Create bot players if requested\n if (hasBots && numBots > 0) {\n const botNames = generateBotNames(numBots, [player_name]);\n for (let i = 0; i < botNames.length; i++) {\n await conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 0, ?, ?)\"\n ).run([gameRow._row_id, botNames[i], `bot-${gameRow._row_id}-${i}`, now, now]);\n }\n }\n\n return Response.json({\n success: true,\n game_code,\n gm_secret,\n session_id,\n game_id: gameRow._row_id,\n has_bots: hasBots\n });\n }\n\n // JOIN GAME\n if (action === \"join_game\") {\n const { game_code, player_name } = body;\n if (!game_code || !player_name) return Response.json({ error: \"Game code and player name required\" }, { status: 400 });\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE game_code = ?\").get([game_code.toUpperCase()]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.status !== \"waiting\") return Response.json({ error: \"Game already started\" }, { status: 400 });\n\n const existing = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND player_name = ?\").get([game._row_id, player_name]);\n if (existing) return Response.json({ error: \"Name already taken in this game\" }, { status: 400 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game._row_id]);\n if (players.length >= game.max_players) return Response.json({ error: \"Game is full\" }, { status: 400 });\n\n const session_id = generateId();\n await conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 0, ?, ?)\"\n ).run([game._row_id, player_name, session_id, now, now]);\n\n return Response.json({\n success: true,\n session_id,\n game_id: game._row_id,\n game_code: game.game_code\n });\n }\n\n // START GAME\n if (action === \"start_game\") {\n const { game_id, gm_secret } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.gm_secret !== gm_secret) return Response.json({ error: \"Not authorized\" }, { status: 403 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n if (players.length < 4) return Response.json({ error: \"Need at least 4 players (including bots)\" }, { status: 400 });\n\n const roles = assignRoles(players.length);\n \n const botPlayers = players.filter(p => p.session_id.startsWith(\"bot-\"));\n\n const batch = [];\n players.forEach((p, i) => {\n batch.push(\n conn.prepare(\"UPDATE game_players SET role = ?, _updated_at = ? WHERE _row_id = ?\").bind([roles[i], now, p._row_id])\n );\n });\n\n batch.push(\n conn.prepare(\"UPDATE games SET status = 'in_progress', phase = 'night', current_round = 1, _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', 'The game has begun! Night falls over the village... The Mafia awakens.', 'system', 1, ?, ?)\").bind([game_id, now, now])\n );\n\n await conn.batch(batch);\n\n // Have bots submit night actions immediately during bot games\n if (botPlayers.length > 0) {\n const mafiaPlayers = players.filter(p => p.role === \"mafia\").map(p => p.player_name);\n \n for (const bot of botPlayers) {\n if (!bot.is_alive || bot.role === \"villager\") continue;\n \n const alivePlayers = players.filter(p => p.is_alive && p.player_name !== bot.player_name);\n const target = getBotNightAction(alivePlayers, bot.role, mafiaPlayers);\n \n if (target && [\"mafia\", \"doctor\", \"detective\"].includes(bot.role)) {\n const actionType = bot.role === \"mafia\" ? \"kill\" : bot.role;\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, 1, bot.player_name, actionType, target, now, now]);\n }\n }\n }\n\n return Response.json({ success: true });\n }\n\n // GET_GAME_STATE\n if (action === \"get_state\") {\n const { game_id, session_id } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n\n const players = await conn.prepare(\"SELECT _row_id, game_id, player_name, role, is_alive, session_id, is_gm FROM game_players WHERE game_id = ?\").all([game_id]);\n const me = players.find(p => p.session_id === session_id);\n if (!me) return Response.json({ error: \"Player not in game\" }, { status: 403 });\n\n let messages = [];\n if (me.role === \"mafia\" || me.is_gm === 1) {\n messages = await conn.prepare(\n \"SELECT * FROM game_messages WHERE game_id = ? ORDER BY _created_at ASC\"\n ).all([game_id]);\n } else {\n messages = await conn.prepare(\n \"SELECT * FROM game_messages WHERE game_id = ? AND channel != 'mafia' ORDER BY _created_at ASC\"\n ).all([game_id]);\n }\n\n const votes = await conn.prepare(\n \"SELECT * FROM game_votes WHERE game_id = ? AND round_num = ?\"\n ).all([game_id, game.current_round]);\n\n let actions = [];\n if (me.is_gm === 1) {\n actions = await conn.prepare(\n \"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ?\"\n ).all([game_id, game.current_round]);\n } else {\n actions = await conn.prepare(\n \"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\"\n ).all([game_id, game.current_round, me.player_name]);\n }\n\n const sanitizedPlayers = players.map(p => ({\n player_name: p.player_name,\n is_alive: p.is_alive,\n is_gm: p.is_gm,\n is_bot: p.session_id.startsWith(\"bot-\"),\n role: (p.session_id === session_id || me.is_gm === 1 || !p.is_alive || p.session_id.startsWith(\"bot-\")) ? p.role : \"unknown\"\n }));\n\n return Response.json({\n game: {\n game_code: game.game_code,\n status: game.status,\n phase: game.phase,\n current_round: game.current_round,\n winner: game.winner\n },\n players: sanitizedPlayers,\n me: {\n player_name: me.player_name,\n role: me.role,\n is_alive: me.is_alive,\n is_gm: me.is_gm\n },\n messages,\n votes,\n actions\n });\n }\n\n // SEND MESSAGE\n if (action === \"send_message\") {\n const { game_id, session_id, message, channel } = body;\n if (!message || !message.trim()) return Response.json({ error: \"Message required\" }, { status: 400 });\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.status !== \"in_progress\") return Response.json({ error: \"Game not active\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player) return Response.json({ error: \"Not in game\" }, { status: 403 });\n\n let msgChannel = channel || \"public\";\n if (msgChannel === \"mafia\" && player.role !== \"mafia\") {\n return Response.json({ error: \"Only mafia can use this channel\" }, { status: 403 });\n }\n\n if (!player.is_alive && msgChannel !== \"dead\") {\n msgChannel = \"dead\";\n }\n\n await conn.prepare(\n \"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, player.player_name, message.trim(), msgChannel, game.current_round, now, now]);\n\n return Response.json({ success: true });\n }\n\n // SUBMIT VOTE\n if (action === \"submit_vote\") {\n const { game_id, session_id, target_name } = body;\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.phase !== \"voting\") return Response.json({ error: \"Not in voting phase\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player || !player.is_alive) return Response.json({ error: \"Cannot vote\" }, { status: 403 });\n\n await conn.prepare(\"DELETE FROM game_votes WHERE game_id = ? AND round_num = ? AND voter_name = ?\").run([game_id, game.current_round, player.player_name]);\n\n if (target_name && target_name !== \"skip\") {\n await conn.prepare(\n \"INSERT INTO game_votes (game_id, round_num, voter_name, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, player.player_name, target_name, now, now]);\n }\n\n return Response.json({ success: true });\n }\n\n // SUBMIT NIGHT ACTION\n if (action === \"submit_action\") {\n const { game_id, session_id, target_name } = body;\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.phase !== \"night\") return Response.json({ error: \"Not night phase\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player || !player.is_alive) return Response.json({ error: \"Cannot act\" }, { status: 403 });\n\n let actionType = \"\";\n if (player.role === \"mafia\") actionType = \"kill\";\n else if (player.role === \"doctor\") actionType = \"heal\";\n else if (player.role === \"detective\") actionType = \"investigate\";\n else return Response.json({ error: \"No night action available\" }, { status: 400 });\n\n await conn.prepare(\"DELETE FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\").run([game_id, game.current_round, player.player_name]);\n\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, player.player_name, actionType, target_name, now, now]);\n\n if (actionType === \"investigate\") {\n const target = await conn.prepare(\"SELECT role FROM game_players WHERE game_id = ? AND player_name = ?\").get([game_id, target_name]);\n const isMafia = target && target.role === \"mafia\";\n return Response.json({ success: true, investigation: isMafia ? \"suspicious\" : \"innocent\" });\n }\n\n return Response.json({ success: true });\n }\n\n // BOT ACTIONS\n if (action === \"bot_actions\") {\n const { game_id, phase } = body;\n \n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.status !== \"in_progress\") return Response.json({ error: \"Game not active\" }, { status: 400 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n const botPlayers = players.filter(p => p.session_id.startsWith(\"bot-\") && p.is_alive);\n \n if (botPlayers.length === 0) return Response.json({ success: true, bot_actions_count: 0 });\n\n const mafiaPlayers = players.filter(p => p.role === \"mafia\").map(p => p.player_name);\n const alivePlayers = players.filter(p => p.is_alive && p.player_name);\n const alivePlayerNames = alivePlayers.map(p => p.player_name);\n\n if (phase === \"night\") {\n // Bots submit night actions\n for (const bot of botPlayers) {\n if (![\"mafia\", \"doctor\", \"detective\"].includes(bot.role)) continue;\n \n const target = getBotNightAction(alivePlayers, bot.role, mafiaPlayers);\n \n // Remove existing action\n await conn.prepare(\"DELETE FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\").run([game_id, game.current_round, bot.player_name]);\n \n if (target) {\n const actionType = bot.role === \"mafia\" ? \"kill\" : bot.role;\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, bot.player_name, actionType, target, now, now]);\n }\n }\n } else if (phase === \"day\") {\n // Bots send chat messages during day\n for (const bot of botPlayers) {\n const message = getBotMessage(\"day\", bot.role, bot.player_name, game.current_round);\n if (message) {\n await conn.prepare(\n \"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, ?, ?, 'public', ?, ?, ?)\"\n ).run([game_id, bot.player_name, message, game.current_round, now, now]);\n }\n }\n } else if (phase === \"voting\") {\n // Bots vote\n for (const bot of botPlayers) {\n const targets = alivePlayerNames.filter(n => n !== bot.player_name);\n const target = getBotVote(targets, bot.role, mafiaPlayers, new Map());\n \n if (target) {\n await conn.prepare(\n \"INSERT INTO game_votes (game_id, round_num, voter_name, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n .bind([game_id, game.current_round, bot.player_name, target, now, now])\n );\n }\n }\n }\n\n return Response.json({ success: true, bot_actions_count: botPlayers.length });\n }\n\n // ADVANCE PHASE (GM only)\n if (action === \"advance_phase\") {\n const { game_id, gm_secret } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.gm_secret !== gm_secret) return Response.json({ error: \"Not authorized\" }, { status: 403 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n const alivePlayers = players.filter(p => p.is_alive);\n const batch = [];\n let nextPhase = \"\";\n\n if (game.phase === \"night\") {\n // Process night actions\n const actions = await conn.prepare(\"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ?\").all([game_id, game.current_round]);\n \n const kills = actions.filter(a => a.action_type === \"kill\");\n const heals = actions.filter(a => a.action_type === \"heal\");\n \n const killVotes = {};\n kills.forEach(k => { killVotes[k.target_name] = (killVotes[k.target_name] || 0) + 1; });\n \n let killTarget = null;\n let maxVotes = 0;\n for (const [name, count] of Object.entries(killVotes)) {\n if (count > maxVotes) { maxVotes = count; killTarget = name; }\n }\n\n const healed = heals.map(h => h.target_name);\n let killMessage = \"\";\n\n if (killTarget && !healed.includes(killTarget)) {\n const killed = players.find(p => p.player_name === killTarget);\n batch.push(\n conn.prepare(\"UPDATE game_players SET is_alive = 0, _updated_at = ? WHERE game_id = ? AND player_name = ?\").bind([now, game_id, killTarget])\n );\n killMessage = `☀️ Dawn breaks... ${killTarget} was found dead. They were a ${killed?.role || \"villager\"}.`;\n } else if (killTarget && healed.includes(killTarget)) {\n killMessage = \"☀️ Dawn breaks... The Doctor saved someone during the night! No one died.\";\n } else {\n killMessage = \"☀️ Dawn breaks... The night was peaceful. No one died.\";\n }\n\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', ?, 'system', ?, ?, ?)\").bind([game_id, killMessage, game.current_round, now, now])\n );\n\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'day', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n nextPhase = \"day\";\n\n const aliveAfter = killTarget && !healed.includes(killTarget)\n ? alivePlayers.filter(p => p.player_name !== killTarget)\n : alivePlayers;\n \n const aliveMafia = aliveAfter.filter(p => p.role === \"mafia\").length;\n const aliveVillage = aliveAfter.filter(p => p.role !== \"mafia\").length;\n\n if (aliveMafia === 0) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'village', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🎉 The Village wins! All mafia members have been eliminated!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n nextPhase = \"gameover\";\n } else if (aliveMafia >= aliveVillage) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'mafia', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '💀 The Mafia wins! They have taken over the village!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n nextPhase = \"gameover\";\n }\n\n } else if (game.phase === \"day\") {\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'voting', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🗳️ Time to vote! Choose who you think is Mafia, or vote to skip.', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now])\n );\n nextPhase = \"voting\";\n\n } else if (game.phase === \"voting\") {\n const votes = await conn.prepare(\"SELECT * FROM game_votes WHERE game_id = ? AND round_num = ?\").all([game_id, game.current_round]);\n \n const voteCounts = {};\n votes.forEach(v => { voteCounts[v.target_name] = (voteCounts[v.target_name] || 0) + 1; });\n \n let eliminatedName = null;\n let maxVoteCount = 0;\n let tie = false;\n for (const [name, count] of Object.entries(voteCounts)) {\n if (count > maxVoteCount) { maxVoteCount = count; eliminatedName = name; tie = false; }\n else if (count === maxVoteCount) { tie = true; }\n }\n\n if (eliminatedName && !tie && maxVoteCount > 1) {\n const eliminated = players.find(p => p.player_name === eliminatedName);\n batch.push(\n conn.prepare(\"UPDATE game_players SET is_alive = 0, _updated_at = ? WHERE game_id = ? AND player_name = ?\").bind([now, game_id, eliminatedName])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', ?, 'system', ?, ?, ?)\").bind([game_id, `⚖️ The village has spoken! ${eliminatedName} has been eliminated. They were a ${eliminated?.role || \"villager\"}.`, game.current_round, now, now])\n );\n\n const aliveAfterVote = alivePlayers.filter(p => p.player_name !== eliminatedName);\n const aliveMafia = aliveAfterVote.filter(p => p.role === \"mafia\").length;\n const aliveVillageCount = aliveAfterVote.filter(p => p.role !== \"mafia\").length;\n\n if (aliveMafia === 0) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'village', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🎉 The Village wins! All mafia members have been eliminated!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n nextPhase = \"gameover\";\n } else if (aliveMafia >= aliveVillageCount) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'mafia', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '💀 The Mafia wins! They have taken over the village!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n nextPhase = \"gameover\";\n }\n } else {\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🤷 No consensus reached. No one was eliminated.', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now])\n );\n }\n\n const newRound = game.current_round + 1;\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'night', current_round = ?, _updated_at = ? WHERE _row_id = ?\").bind([newRound, now, game_id])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🌙 Night falls once again... The Mafia awakens.', 'system', ?, ?, ?)\").bind([game_id, newRound, now, now])\n );\n nextPhase = \"night\";\n }\n\n if (batch.length > 0) await conn.batch(batch);\n \n // Trigger bot actions for the new phase\n if (nextPhase && nextPhase !== \"gameover\") {\n try {\n await functions.post(\"game-engine\", { action: \"bot_actions\", game_id, phase: nextPhase });\n } catch (err) {\n console.error(\"Bot actions error:\", err);\n }\n }\n\n return Response.json({ success: true });\n }\n\n return Response.json({ error: \"Unknown action\" }, { status: 400 });\n } catch (err) {\n console.error(\"Game engine error:\", err);\n return Response.json({ error: err.message || \"Internal error\" }, { status: 500 });\n }\n}",2,["D",1770134434100],{"_105":223,"_161":144,"_158":159,"_97":101,"_169":224,"_167":168,"_102":182,"_160":-5,"_107":225,"_162":220,"_172":-5},"b6036ee4-0118-11f1-8442-42dde27851f2","import { connect } from \"npm:@tursodatabase/serverless\";\n\nfunction generateCode() {\n const chars = \"ABCDEFGHJKLMNPQRSTUVWXYZ23456789\";\n let code = \"\";\n for (let i = 0; i < 6; i++) code += chars[Math.floor(Math.random() * chars.length)];\n return code;\n}\n\nfunction generateId() {\n return crypto.randomUUID();\n}\n\nfunction shuffleArray(arr: any[]) {\n const a = [...arr];\n for (let i = a.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [a[i], a[j]] = [a[j], a[i]];\n }\n return a;\n}\n\nfunction assignRoles(playerCount: number, botCount: number = 0) {\n let mafiaCount = 1;\n if (playerCount >= 7) mafiaCount = 2;\n if (playerCount >= 10) mafiaCount = 3;\n if (botCount > 0 && playerCount >= 5) mafiaCount = Math.max(1, Math.floor(playerCount / 4));\n\n const roles: string[] = [];\n for (let i = 0; i < mafiaCount; i++) roles.push(\"mafia\");\n roles.push(\"doctor\");\n roles.push(\"detective\");\n while (roles.length < playerCount) roles.push(\"villager\");\n return shuffleArray(roles);\n}\n\nconst BOT_NAMES = [\n \"Alex\", \"Blake\", \"Casey\", \"Drew\", \"Ellis\", \"Finley\", \"Gray\", \"Harper\", \n \"Indigo\", \"Jordan\", \"Kai\", \"Logan\", \"Morgan\", \"Nico\", \"Ocean\", \"Piper\",\n \"Quinn\", \"Ray\", \"Sage\", \"Taylor\", \"Vale\", \"Winter\", \"Zion\", \"Avery\"\n];\n\nfunction generateBotNames(count: number, existingNames: string[]) {\n const available = BOT_NAMES.filter(n => !existingNames.includes(n));\n return shuffleArray(available).slice(0, count);\n}\n\n// Bot behavior patterns\nfunction getBotVote(playerNames: string[], botRole: string, mafiaPlayers: string[], previousVotes: Map): string | null {\n if (playerNames.length === 0) return null;\n \n // Filter out mafia teammates for voting\n const nonMafiaTargets = playerNames.filter(n => !mafiaPlayers.includes(n));\n const targets = botRole === \"mafia\" ? nonMafiaTargets : playerNames;\n \n if (targets.length === 0) return null;\n \n // 20% chance to skip vote\n if (Math.random() < 0.2) return \"skip\";\n \n // Bot personality weights\n const random = Math.random();\n const targetIndex = Math.floor(random * targets.length);\n return targets[targetIndex];\n}\n\nfunction getBotNightAction(alivePlayers: any[], botRole: string, mafiaPlayers: string[]): string | null {\n if (alivePlayers.length === 0) return null;\n \n const nonMafiaTargets = alivePlayers.filter(p => !mafiaPlayers.includes(p.player_name));\n const targets = botRole === \"mafia\" ? nonMafiaTargets : alivePlayers;\n \n if (targets.length === 0) return null;\n \n const random = Math.random();\n const targetIndex = Math.floor(random * targets.length);\n return targets[targetIndex].player_name;\n}\n\nfunction getBotMessage(phase: string, botRole: string, botName: string, round: number): string | null {\n // Only 30% chance for bots to say something to avoid spam\n if (Math.random() > 0.3) return null;\n \n const suspiciousMessages = [\n \"I think {player} is acting strange...\",\n \"Why is everyone so quiet today?\",\n \"I'm suspicious of someone, just trying to observe.\",\n \"We need to be careful with our votes!\",\n \"Something doesn't feel right.\",\n \"Let's not rush to conclusions.\",\n \"I've been watching the votes...\",\n ];\n \n const villagerMessages = [\n \"I'm just a simple villager, honest!\",\n \"I hope the doctor saves someone tonight!\",\n \"Who do y'all think the mafia is?\",\n \"This is getting intense!\",\n \"I have no leads, sadly.\",\n \"Let's work together!\",\n \"I'm feeling nervous now...\",\n ];\n \n const mafiaMessages = [\n \"I think it might be {target}...\",\n \"Those are good points about {target}.\",\n \"I'm confused about what to think.\",\n \"We need to find a real lead.\",\n \"I don't suspect {teammate}, they seem genuine.\",\n ];\n \n const messages = botRole === \"mafia\" ? mafiaMessages : villagerMessages;\n return messages[Math.floor(Math.random() * messages.length)]\n .replace(\"{player}\", PLAYER_PLACEHOLDER)\n .replace(\"{target}\", PLAYER_PLACEHOLDER)\n .replace(\"{teammate}\", PLAYER_PLACEHOLDER);\n}\n\nconst PLAYER_PLACEHOLDER = \"someone\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n const now = Math.floor(Date.now() / 1000);\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204 });\n }\n\n const body = await req.json();\n const { action } = body;\n\n try {\n // CREATE GAME\n if (action === \"create_game\") {\n const { player_name, with_bots, bot_count } = body;\n if (!player_name) return Response.json({ error: \"Player name required\" }, { status: 400 });\n\n const game_code = generateCode();\n const gm_secret = generateId();\n const session_id = generateId();\n const hasBots = with_bots === true || bot_count > 0;\n const numBots = bot_count || 0;\n\n const gameStmt = conn.prepare(\n \"INSERT INTO games (game_code, status, phase, current_round, gm_secret, _created_at, _updated_at) VALUES (?, 'waiting', 'lobby', 0, ?, ?, ?)\"\n );\n await gameStmt.run([game_code, gm_secret, now, now]);\n\n const gameRow = await conn.prepare(\"SELECT _row_id FROM games WHERE game_code = ?\").get([game_code]);\n\n const playerStmt = conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 1, ?, ?)\"\n );\n await playerStmt.run([gameRow._row_id, playerName, session_id, now, now]);\n\n // Create bot players if requested\n if (hasBots && numBots > 0) {\n const botNames = generateBotNames(numBots, [playerName]);\n for (let i = 0; i < botNames.length; i++) {\n await conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 0, ?, ?)\"\n ).run([gameRow._row_id, botNames[i], `bot-${gameRow._row_id}-${i}`, now, now]);\n }\n }\n\n return Response.json({\n success: true,\n game_code,\n gm_secret,\n session_id,\n game_id: gameRow._row_id,\n has_bots: hasBots\n });\n }\n\n // JOIN GAME\n if (action === \"join_game\") {\n const { game_code, player_name } = body;\n if (!game_code || !player_name) return Response.json({ error: \"Game code and player name required\" }, { status: 400 });\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE game_code = ?\").get([game_code.toUpperCase()]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.status !== \"waiting\") return Response.json({ error: \"Game already started\" }, { status: 400 });\n\n const existing = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND player_name = ?\").get([game._row_id, player_name]);\n if (existing) return Response.json({ error: \"Name already taken in this game\" }, { status: 400 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game._row_id]);\n if (players.length >= game.max_players) return Response.json({ error: \"Game is full\" }, { status: 400 });\n\n const session_id = generateId();\n await conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 0, ?, ?)\"\n ).run([game._row_id, player_name, session_id, now, now]);\n\n return Response.json({\n success: true,\n session_id,\n game_id: game._row_id,\n game_code: game.game_code\n });\n }\n\n // START GAME\n if (action === \"start_game\") {\n const { game_id, gm_secret } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.gm_secret !== gm_secret) return Response.json({ error: \"Not authorized\" }, { status: 403 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n if (players.length < 4) return Response.json({ error: \"Need at least 4 players (including bots)\" }, { status: 400 });\n\n const roles = assignRoles(players.length);\n \n const botPlayers = players.filter((p: any) => p.session_id.startsWith(\"bot-\"));\n\n const batch: any[] = [];\n players.forEach((p: any, i: number) => {\n batch.push(\n conn.prepare(\"UPDATE game_players SET role = ?, _updated_at = ? WHERE _row_id = ?\").bind([roles[i], now, p._row_id])\n );\n });\n\n batch.push(\n conn.prepare(\"UPDATE games SET status = 'in_progress', phase = 'night', current_round = 1, _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', 'The game has begun! Night falls over the village... The Mafia awakens.', 'system', 1, ?, ?)\").bind([game_id, now, now])\n );\n\n await conn.batch(batch);\n\n // Have bots submit night actions immediately during bot games\n if (botPlayers.length > 0) {\n const mafiaPlayers = players.filter((p: any) => p.role === \"mafia\").map((p: any) => p.player_name);\n \n for (const bot of botPlayers) {\n if (!bot.is_alive || bot.role === \"villager\") continue;\n \n const alivePlayers = players.filter((p: any) => p.is_alive && p.player_name !== bot.player_name);\n const target = getBotNightAction(alivePlayers, bot.role, mafiaPlayers);\n \n if (target && [\"mafia\", \"doctor\", \"detective\"].includes(bot.role)) {\n const actionType = bot.role === \"mafia\" ? \"kill\" : bot.role;\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, 1, bot.player_name, actionType, target, now, now]);\n }\n }\n }\n\n return Response.json({ success: true });\n }\n\n // GET GAME STATE\n if (action === \"get_state\") {\n const { game_id, session_id } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n\n const players = await conn.prepare(\"SELECT _row_id, game_id, player_name, role, is_alive, session_id, is_gm FROM game_players WHERE game_id = ?\").all([game_id]);\n const me = players.find((p: any) => p.session_id === session_id);\n if (!me) return Response.json({ error: \"Player not in game\" }, { status: 403 });\n\n let messages: any[] = [];\n if (me.role === \"mafia\" || me.is_gm === 1) {\n messages = await conn.prepare(\n \"SELECT * FROM game_messages WHERE game_id = ? ORDER BY _created_at ASC\"\n ).all([game_id]);\n } else {\n messages = await conn.prepare(\n \"SELECT * FROM game_messages WHERE game_id = ? AND channel != 'mafia' ORDER BY _created_at ASC\"\n ).all([game_id]);\n }\n\n const votes: any[] = await conn.prepare(\n \"SELECT * FROM game_votes WHERE game_id = ? AND round_num = ?\"\n ).all([game_id, game.current_round]);\n\n let actions: any[] = [];\n if (me.is_gm === 1) {\n actions = await conn.prepare(\n \"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ?\"\n ).all([game_id, game.current_round]);\n } else {\n actions = await conn.prepare(\n \"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\"\n ).all([game_id, game.current_round, me.player_name]);\n }\n\n const sanitizedPlayers = players.map((p: any) => ({\n player_name: p.player_name,\n is_alive: p.is_alive,\n is_gm: p.is_gm,\n is_bot: p.session_id.startsWith(\"bot-\"),\n role: (p.session_id === session_id || me.is_gm === 1 || !p.is_alive || p.session_id.startsWith(\"bot-\")) ? p.role : \"unknown\"\n }));\n\n return Response.json({\n game: {\n game_code: game.game_code,\n status: game.status,\n phase: game.phase,\n current_round: game.current_round,\n winner: game.winner\n },\n players: sanitizedPlayers,\n me: {\n player_name: me.player_name,\n role: me.role,\n is_alive: me.is_alive,\n is_gm: me.is_gm\n },\n messages,\n votes,\n actions\n });\n }\n\n // SEND MESSAGE\n if (action === \"send_message\") {\n const { game_id, session_id, message, channel } = body;\n if (!message || !message.trim()) return Response.json({ error: \"Message required\" }, { status: 400 });\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.status !== \"in_progress\") return Response.json({ error: \"Game not active\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player) return Response.json({ error: \"Not in game\" }, { status: 403 });\n\n let msgChannel = channel || \"public\";\n if (msgChannel === \"mafia\" && player.role !== \"mafia\") {\n return Response.json({ error: \"Only mafia can use this channel\" }, { status: 403 });\n }\n\n if (!player.is_alive && msgChannel !== \"dead\") {\n msgChannel = \"dead\";\n }\n\n await conn.prepare(\n \"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, player.player_name, message.trim(), msgChannel, game.current_round, now, now]);\n\n return Response.json({ success: true });\n }\n\n // SUBMIT VOTE\n if (action === \"submit_vote\") {\n const { game_id, session_id, target_name } = body;\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.phase !== \"voting\") return Response.json({ error: \"Not in voting phase\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player || !player.is_alive) return Response.json({ error: \"Cannot vote\" }, { status: 403 });\n\n await conn.prepare(\"DELETE FROM game_votes WHERE game_id = ? AND round_num = ? AND voter_name = ?\").run([game_id, game.current_round, player.player_name]);\n\n if (target_name && target_name !== \"skip\") {\n await conn.prepare(\n \"INSERT INTO game_votes (game_id, round_num, voter_name, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, player.player_name, target_name, now, now]);\n }\n\n return Response.json({ success: true });\n }\n\n // SUBMIT NIGHT ACTION\n if (action === \"submit_action\") {\n const { game_id, session_id, target_name } = body;\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.phase !== \"night\") return Response.json({ error: \"Not night phase\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player || !player.is_alive) return Response.json({ error: \"Cannot act\" }, { status: 403 });\n\n let actionType = \"\";\n if (player.role === \"mafia\") actionType = \"kill\";\n else if (player.role === \"doctor\") actionType = \"heal\";\n else if (player.role === \"detective\") actionType = \"investigate\";\n else return Response.json({ error: \"No night action available\" }, { status: 400 });\n\n await conn.prepare(\"DELETE FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\").run([game_id, game.current_round, player.player_name]);\n\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, player.player_name, actionType, target_name, now, now]);\n\n if (actionType === \"investigate\") {\n const target = await conn.prepare(\"SELECT role FROM game_players WHERE game_id = ? AND player_name = ?\").get([game_id, target_name]);\n const isMafia = target && target.role === \"mafia\";\n return Response.json({ success: true, investigation: isMafia ? \"suspicious\" : \"innocent\" });\n }\n\n return Response.json({ success: true });\n }\n\n // BOT ACTIONS (auto-called on phase transitions)\n if (action === \"bot_actions\") {\n const { game_id, phase } = body;\n \n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.status !== \"in_progress\") return Response.json({ error: \"Game not active\" }, { status: 400 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n const botPlayers = players.filter((p: any) => p.session_id.startsWith(\"bot-\") && p.is_alive);\n \n if (botPlayers.length === 0) return Response.json({ success: true, bot_actions_count: 0 });\n\n const mafiaPlayers = players.filter((p: any) => p.role === \"mafia\").map((p: any) => p.player_name);\n const alivePlayers = players.filter((p: any) => p.is_alive && p.player_name);\n const alivePlayerNames = alivePlayers.map((p: any) => p.player_name);\n\n if (phase === \"night\") {\n // Bots submit night actions\n for (const bot of botPlayers) {\n if (![\"mafia\", \"doctor\", \"detective\"].includes(bot.role)) continue;\n \n const target = getBotNightAction(alivePlayers, bot.role, mafiaPlayers);\n \n // Remove existing action\n await conn.prepare(\"DELETE FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\").run([game_id, game.current_round, bot.player_name]);\n \n if (target) {\n const actionType = bot.role === \"mafia\" ? \"kill\" : bot.role;\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, bot.player_name, actionType, target, now, now]);\n }\n }\n } else if (phase === \"day\") {\n // Bots send chat messages during day\n for (const bot of botPlayers) {\n const message = getBotMessage(\"day\", bot.role, bot.player_name, game.current_round);\n if (message) {\n await conn.prepare(\n \"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, ?, ?, 'public', ?, ?, ?)\"\n ).run([game_id, bot.player_name, message, game.current_round, now, now]);\n }\n }\n } else if (phase === \"voting\") {\n // Bots vote\n for (const bot of botPlayers) {\n const targets = alivePlayerNames.filter(n => n !== bot.player_name);\n const target = getBotVote(targets, bot.role, mafiaPlayers, new Map());\n \n if (target) {\n await conn.prepare(\n \"INSERT INTO game_votes (game_id, round_num, voter_name, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n .bind([game_id, game.current_round, bot.player_name, target, now, now])\n );\n }\n }\n }\n\n return Response.json({ success: true, bot_actions_count: botPlayers.length });\n }\n\n // ADVANCE PHASE (GM only)\n if (action === \"advance_phase\") {\n const { game_id, gm_secret } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.gm_secret !== gm_secret) return Response.json({ error: \"Not authorized\" }, { status: 403 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n const alivePlayers = players.filter((p: any) => p.is_alive);\n const batch: any[] = [];\n let nextPhase = \"\";\n\n if (game.phase === \"night\") {\n // Process night actions\n const actions = await conn.prepare(\"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ?\").all([game_id, game.current_round]);\n \n const kills = actions.filter((a: any) => a.action_type === \"kill\");\n const heals = actions.filter((a: any) => a.action_type === \"heal\");\n \n const killVotes: Record = {};\n kills.forEach((k: any) => { killVotes[k.target_name] = (killVotes[k.target_name] || 0) + 1; });\n \n let killTarget: string | null = null;\n let maxVotes = 0;\n for (const [name, count] of Object.entries(killVotes)) {\n if (count > maxVotes) { maxVotes = count; killTarget = name; }\n }\n\n const healed = heals.map((h: any) => h.target_name);\n let killMessage = \"\";\n\n if (killTarget && !healed.includes(killTarget)) {\n const killed = players.find((p: any) => p.player_name === killTarget);\n batch.push(\n conn.prepare(\"UPDATE game_players SET is_alive = 0, _updated_at = ? WHERE game_id = ? AND player_name = ?\").bind([now, game_id, killTarget])\n );\n killMessage = `☀️ Dawn breaks... ${killTarget} was found dead. They were a ${killed?.role || \"villager\"}.`;\n } else if (killTarget && healed.includes(killTarget)) {\n killMessage = \"☀️ Dawn breaks... The Doctor saved someone during the night! No one died.\";\n } else {\n killMessage = \"☀️ Dawn breaks... The night was peaceful. No one died.\";\n }\n\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', ?, 'system', ?, ?, ?)\").bind([game_id, killMessage, game.current_round, now, now])\n );\n\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'day', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n nextPhase = \"day\";\n\n const aliveAfter = killTarget && !healed.includes(killTarget)\n ? alivePlayers.filter((p: any) => p.player_name !== killTarget)\n : alivePlayers;\n \n const aliveMafia = aliveAfter.filter((p: any) => p.role === \"mafia\").length;\n const aliveVillage = aliveAfter.filter((p: any) => p.role !== \"mafia\").length;\n\n if (aliveMafia === 0) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'village', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🎉 The Village wins! All mafia members have been eliminated!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n nextPhase = \"gameover\";\n } else if (aliveMafia >= aliveVillage) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'mafia', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '💀 The Mafia wins! They have taken over the village!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n nextPhase = \"gameover\";\n }\n\n } else if (game.phase === \"day\") {\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'voting', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🗳️ Time to vote! Choose who you think is Mafia, or vote to skip.', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now])\n );\n nextPhase = \"voting\";\n\n } else if (game.phase === \"voting\") {\n const votes = await conn.prepare(\"SELECT * FROM game_votes WHERE game_id = ? AND round_num = ?\").all([game_id, game.current_round]);\n \n const voteCounts: Record = {};\n votes.forEach((v: any) => { voteCounts[v.target_name] = (voteCounts[v.target_name] || 0) + 1; });\n \n let eliminatedName: string | null = null;\n let maxVoteCount = 0;\n let tie = false;\n for (const [name, count] of Object.entries(voteCounts)) {\n if (count > maxVoteCount) { maxVoteCount = count; eliminatedName = name; tie = false; }\n else if (count === maxVoteCount) { tie = true; }\n }\n\n if (eliminatedName && !tie && maxVoteCount > 1) {\n const eliminated = players.find((p: any) => p.player_name === eliminatedName);\n batch.push(\n conn.prepare(\"UPDATE game_players SET is_alive = 0, _updated_at = ? WHERE game_id = ? AND player_name = ?\").bind([now, game_id, eliminatedName])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', ?, 'system', ?, ?, ?)\").bind([game_id, `⚖️ The village has spoken! ${eliminatedName} has been eliminated. They were a ${eliminated?.role || \"villager\"}.`, game.current_round, now, now])\n );\n\n const aliveAfterVote = alivePlayers.filter((p: any) => p.player_name !== eliminatedName);\n const aliveMafia = aliveAfterVote.filter((p: any) => p.role === \"mafia\").length;\n const aliveVillageCount = aliveAfterVote.filter((p: any) => p.role !== \"mafia\").length;\n\n if (aliveMafia === 0) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'village', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🎉 The Village wins! All mafia members have been eliminated!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n nextPhase = \"gameover\";\n } else if (aliveMafia >= aliveVillageCount) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'mafia', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '💀 The Mafia wins! They have taken over the village!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n nextPhase = \"gameover\";\n }\n } else {\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🤷 No consensus reached. No one was eliminated.', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now])\n );\n }\n\n const newRound = game.current_round + 1;\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'night', current_round = ?, _updated_at = ? WHERE _row_id = ?\").bind([newRound, now, game_id])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🌙 Night falls once again... The Mafia awakens.', 'system', ?, ?, ?)\").bind([game_id, newRound, now, now])\n );\n nextPhase = \"night\";\n }\n\n if (batch.length > 0) await conn.batch(batch);\n \n // Trigger bot actions for the new phase\n if (nextPhase && nextPhase !== \"gameover\") {\n try {\n await this(new Request(new URL(req.url), {\n method: \"POST\",\n headers: req.headers,\n body: JSON.stringify({ action: \"bot_actions\", game_id, phase: nextPhase })\n }));\n } catch (err) {\n console.error(\"Bot actions error:\", err);\n }\n }\n\n return Response.json({ success: true });\n }\n\n return Response.json({ error: \"Unknown action\" }, { status: 400 });\n } catch (err: unknown) {\n console.error(\"Game engine error:\", err);\n return Response.json({ error: err instanceof Error ? err.message : \"Internal error\" }, { status: 500 });\n }\n}",["D",1770134106952],{"_105":227,"_161":144,"_158":159,"_97":101,"_169":228,"_167":168,"_102":33,"_160":-5,"_107":229,"_162":182,"_172":-5},"f955750e-0116-11f1-a9da-42dde27851f2","\nimport { connect } from \"npm:@tursodatabase/serverless\";\n\nfunction generateCode() {\n const chars = \"ABCDEFGHJKLMNPQRSTUVWXYZ23456789\";\n let code = \"\";\n for (let i = 0; i < 6; i++) code += chars[Math.floor(Math.random() * chars.length)];\n return code;\n}\n\nfunction generateId() {\n return crypto.randomUUID();\n}\n\nfunction shuffleArray(arr) {\n const a = [...arr];\n for (let i = a.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [a[i], a[j]] = [a[j], a[i]];\n }\n return a;\n}\n\nfunction assignRoles(playerCount) {\n let mafiaCount = 1;\n if (playerCount >= 7) mafiaCount = 2;\n if (playerCount >= 10) mafiaCount = 3;\n\n const roles = [];\n for (let i = 0; i < mafiaCount; i++) roles.push(\"mafia\");\n roles.push(\"doctor\");\n roles.push(\"detective\");\n while (roles.length < playerCount) roles.push(\"villager\");\n return shuffleArray(roles);\n}\n\nexport default async function(req) {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n const now = Math.floor(Date.now() / 1000);\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204 });\n }\n\n const body = await req.json();\n const { action } = body;\n\n try {\n // CREATE GAME\n if (action === \"create_game\") {\n const { player_name } = body;\n if (!player_name) return Response.json({ error: \"Player name required\" }, { status: 400 });\n\n const game_code = generateCode();\n const gm_secret = generateId();\n const session_id = generateId();\n\n const gameStmt = conn.prepare(\n \"INSERT INTO games (game_code, status, phase, current_round, gm_secret, _created_at, _updated_at) VALUES (?, 'waiting', 'lobby', 0, ?, ?, ?)\"\n );\n await gameStmt.run([game_code, gm_secret, now, now]);\n\n const gameRow = await conn.prepare(\"SELECT _row_id FROM games WHERE game_code = ?\").get([game_code]);\n\n const playerStmt = conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 1, ?, ?)\"\n );\n await playerStmt.run([gameRow._row_id, player_name, session_id, now, now]);\n\n return Response.json({\n success: true,\n game_code,\n gm_secret,\n session_id,\n game_id: gameRow._row_id\n });\n }\n\n // JOIN GAME\n if (action === \"join_game\") {\n const { game_code, player_name } = body;\n if (!game_code || !player_name) return Response.json({ error: \"Game code and player name required\" }, { status: 400 });\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE game_code = ?\").get([game_code.toUpperCase()]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.status !== \"waiting\") return Response.json({ error: \"Game already started\" }, { status: 400 });\n\n const existing = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND player_name = ?\").get([game._row_id, player_name]);\n if (existing) return Response.json({ error: \"Name already taken in this game\" }, { status: 400 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game._row_id]);\n if (players.length >= game.max_players) return Response.json({ error: \"Game is full\" }, { status: 400 });\n\n const session_id = generateId();\n await conn.prepare(\n \"INSERT INTO game_players (game_id, player_name, role, is_alive, session_id, is_gm, _created_at, _updated_at) VALUES (?, ?, 'unassigned', 1, ?, 0, ?, ?)\"\n ).run([game._row_id, player_name, session_id, now, now]);\n\n return Response.json({\n success: true,\n session_id,\n game_id: game._row_id,\n game_code: game.game_code\n });\n }\n\n // START GAME\n if (action === \"start_game\") {\n const { game_id, gm_secret } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.gm_secret !== gm_secret) return Response.json({ error: \"Not authorized\" }, { status: 403 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n if (players.length < 4) return Response.json({ error: \"Need at least 4 players\" }, { status: 400 });\n\n const roles = assignRoles(players.length);\n\n const batch = [];\n players.forEach((p, i) => {\n batch.push(\n conn.prepare(\"UPDATE game_players SET role = ?, _updated_at = ? WHERE _row_id = ?\").bind([roles[i], now, p._row_id])\n );\n });\n\n batch.push(\n conn.prepare(\"UPDATE games SET status = 'in_progress', phase = 'night', current_round = 1, _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', 'The game has begun! Night falls over the village... The Mafia awakens.', 'system', 1, ?, ?)\").bind([game_id, now, now])\n );\n\n await conn.batch(batch);\n\n return Response.json({ success: true });\n }\n\n // GET GAME STATE\n if (action === \"get_state\") {\n const { game_id, session_id } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n\n const players = await conn.prepare(\"SELECT _row_id, game_id, player_name, role, is_alive, session_id, is_gm FROM game_players WHERE game_id = ?\").all([game_id]);\n const me = players.find(p => p.session_id === session_id);\n if (!me) return Response.json({ error: \"Player not in game\" }, { status: 403 });\n\n // Get messages visible to this player\n let messages;\n if (me.role === \"mafia\" || me.is_gm) {\n messages = await conn.prepare(\n \"SELECT * FROM game_messages WHERE game_id = ? ORDER BY _created_at ASC\"\n ).all([game_id]);\n } else {\n messages = await conn.prepare(\n \"SELECT * FROM game_messages WHERE game_id = ? AND channel != 'mafia' ORDER BY _created_at ASC\"\n ).all([game_id]);\n }\n\n // Get votes for current round\n const votes = await conn.prepare(\n \"SELECT * FROM game_votes WHERE game_id = ? AND round_num = ?\"\n ).all([game_id, game.current_round]);\n\n // Get actions for current round (only show own actions unless GM)\n let actions;\n if (me.is_gm) {\n actions = await conn.prepare(\n \"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ?\"\n ).all([game_id, game.current_round]);\n } else {\n actions = await conn.prepare(\n \"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\"\n ).all([game_id, game.current_round, me.player_name]);\n }\n\n // Hide roles from non-GM players (only show own role + dead players' roles)\n const sanitizedPlayers = players.map(p => ({\n player_name: p.player_name,\n is_alive: p.is_alive,\n is_gm: p.is_gm,\n role: (p.session_id === session_id || me.is_gm || !p.is_alive) ? p.role : \"unknown\"\n }));\n\n return Response.json({\n game: {\n game_code: game.game_code,\n status: game.status,\n phase: game.phase,\n current_round: game.current_round,\n winner: game.winner\n },\n players: sanitizedPlayers,\n me: {\n player_name: me.player_name,\n role: me.role,\n is_alive: me.is_alive,\n is_gm: me.is_gm\n },\n messages,\n votes,\n actions\n });\n }\n\n // SEND MESSAGE\n if (action === \"send_message\") {\n const { game_id, session_id, message, channel } = body;\n if (!message || !message.trim()) return Response.json({ error: \"Message required\" }, { status: 400 });\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.status !== \"in_progress\") return Response.json({ error: \"Game not active\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player) return Response.json({ error: \"Not in game\" }, { status: 403 });\n\n // Validate channel\n let msgChannel = channel || \"public\";\n if (msgChannel === \"mafia\" && player.role !== \"mafia\") {\n return Response.json({ error: \"Only mafia can use this channel\" }, { status: 403 });\n }\n\n // Dead players can only send to dead channel\n if (!player.is_alive && msgChannel !== \"dead\") {\n msgChannel = \"dead\";\n }\n\n await conn.prepare(\n \"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, player.player_name, message.trim(), msgChannel, game.current_round, now, now]);\n\n return Response.json({ success: true });\n }\n\n // SUBMIT VOTE\n if (action === \"submit_vote\") {\n const { game_id, session_id, target_name } = body;\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.phase !== \"voting\") return Response.json({ error: \"Not in voting phase\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player || !player.is_alive) return Response.json({ error: \"Cannot vote\" }, { status: 403 });\n\n // Remove existing vote\n await conn.prepare(\"DELETE FROM game_votes WHERE game_id = ? AND round_num = ? AND voter_name = ?\").run([game_id, game.current_round, player.player_name]);\n\n if (target_name && target_name !== \"skip\") {\n await conn.prepare(\n \"INSERT INTO game_votes (game_id, round_num, voter_name, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, player.player_name, target_name, now, now]);\n }\n\n return Response.json({ success: true });\n }\n\n // SUBMIT NIGHT ACTION\n if (action === \"submit_action\") {\n const { game_id, session_id, target_name } = body;\n\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game || game.phase !== \"night\") return Response.json({ error: \"Not night phase\" }, { status: 400 });\n\n const player = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ? AND session_id = ?\").get([game_id, session_id]);\n if (!player || !player.is_alive) return Response.json({ error: \"Cannot act\" }, { status: 403 });\n\n let actionType = \"\";\n if (player.role === \"mafia\") actionType = \"kill\";\n else if (player.role === \"doctor\") actionType = \"heal\";\n else if (player.role === \"detective\") actionType = \"investigate\";\n else return Response.json({ error: \"No night action available\" }, { status: 400 });\n\n // Remove existing action\n await conn.prepare(\"DELETE FROM game_actions WHERE game_id = ? AND round_num = ? AND actor_name = ?\").run([game_id, game.current_round, player.player_name]);\n\n await conn.prepare(\n \"INSERT INTO game_actions (game_id, round_num, actor_name, action_type, target_name, _created_at, _updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)\"\n ).run([game_id, game.current_round, player.player_name, actionType, target_name, now, now]);\n\n // If detective, return investigation result\n if (actionType === \"investigate\") {\n const target = await conn.prepare(\"SELECT role FROM game_players WHERE game_id = ? AND player_name = ?\").get([game_id, target_name]);\n const isMafia = target && target.role === \"mafia\";\n return Response.json({ success: true, investigation: isMafia ? \"suspicious\" : \"innocent\" });\n }\n\n return Response.json({ success: true });\n }\n\n // ADVANCE PHASE (GM only)\n if (action === \"advance_phase\") {\n const { game_id, gm_secret } = body;\n const game = await conn.prepare(\"SELECT * FROM games WHERE _row_id = ?\").get([game_id]);\n if (!game) return Response.json({ error: \"Game not found\" }, { status: 404 });\n if (game.gm_secret !== gm_secret) return Response.json({ error: \"Not authorized\" }, { status: 403 });\n\n const players = await conn.prepare(\"SELECT * FROM game_players WHERE game_id = ?\").all([game_id]);\n const alivePlayers = players.filter(p => p.is_alive);\n const batch = [];\n\n if (game.phase === \"night\") {\n // Process night actions\n const actions = await conn.prepare(\"SELECT * FROM game_actions WHERE game_id = ? AND round_num = ?\").all([game_id, game.current_round]);\n \n const kills = actions.filter(a => a.action_type === \"kill\");\n const heals = actions.filter(a => a.action_type === \"heal\");\n \n // Find most voted kill target (mafia consensus)\n const killVotes = {};\n kills.forEach(k => { killVotes[k.target_name] = (killVotes[k.target_name] || 0) + 1; });\n let killTarget = null;\n let maxVotes = 0;\n for (const [name, count] of Object.entries(killVotes)) {\n if (count > maxVotes) { maxVotes = count; killTarget = name; }\n }\n\n // Check if doctor saved\n const healed = heals.map(h => h.target_name);\n let killMessage = \"\";\n\n if (killTarget && !healed.includes(killTarget)) {\n batch.push(\n conn.prepare(\"UPDATE game_players SET is_alive = 0, _updated_at = ? WHERE game_id = ? AND player_name = ?\").bind([now, game_id, killTarget])\n );\n killMessage = `☀️ Dawn breaks... ${killTarget} was found dead. They were a ${players.find(p => p.player_name === killTarget)?.role || \"villager\"}.`;\n } else if (killTarget && healed.includes(killTarget)) {\n killMessage = \"☀️ Dawn breaks... The Doctor saved someone during the night! No one died.\";\n } else {\n killMessage = \"☀️ Dawn breaks... The night was peaceful. No one died.\";\n }\n\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', ?, 'system', ?, ?, ?)\").bind([game_id, killMessage, game.current_round, now, now])\n );\n\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'day', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n\n // Check win condition\n const aliveAfter = killTarget && !healed.includes(killTarget)\n ? alivePlayers.filter(p => p.player_name !== killTarget)\n : alivePlayers;\n \n const aliveMafia = aliveAfter.filter(p => p.role === \"mafia\").length;\n const aliveVillage = aliveAfter.filter(p => p.role !== \"mafia\").length;\n\n if (aliveMafia === 0) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'village', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🎉 The Village wins! All mafia members have been eliminated!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n } else if (aliveMafia >= aliveVillage) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'mafia', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '💀 The Mafia wins! They have taken over the village!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n }\n\n } else if (game.phase === \"day\") {\n // Move to voting\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'voting', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🗳️ Time to vote! Choose who you think is Mafia, or vote to skip.', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now])\n );\n\n } else if (game.phase === \"voting\") {\n // Process votes\n const votes = await conn.prepare(\"SELECT * FROM game_votes WHERE game_id = ? AND round_num = ?\").all([game_id, game.current_round]);\n \n const voteCounts = {};\n votes.forEach(v => { voteCounts[v.target_name] = (voteCounts[v.target_name] || 0) + 1; });\n \n let eliminatedName = null;\n let maxVoteCount = 0;\n let tie = false;\n for (const [name, count] of Object.entries(voteCounts)) {\n if (count > maxVoteCount) { maxVoteCount = count; eliminatedName = name; tie = false; }\n else if (count === maxVoteCount) { tie = true; }\n }\n\n if (eliminatedName && !tie && maxVoteCount > 1) {\n const eliminated = players.find(p => p.player_name === eliminatedName);\n batch.push(\n conn.prepare(\"UPDATE game_players SET is_alive = 0, _updated_at = ? WHERE game_id = ? AND player_name = ?\").bind([now, game_id, eliminatedName])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', ?, 'system', ?, ?, ?)\").bind([game_id, `⚖️ The village has spoken! ${eliminatedName} has been eliminated. They were a ${eliminated?.role || \"villager\"}.`, game.current_round, now, now])\n );\n\n // Check win condition\n const aliveAfterVote = alivePlayers.filter(p => p.player_name !== eliminatedName);\n const aliveMafia = aliveAfterVote.filter(p => p.role === \"mafia\").length;\n const aliveVillageCount = aliveAfterVote.filter(p => p.role !== \"mafia\").length;\n\n if (aliveMafia === 0) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'village', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🎉 The Village wins! All mafia members have been eliminated!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n } else if (aliveMafia >= aliveVillageCount) {\n batch.push(conn.prepare(\"UPDATE games SET status = 'finished', winner = 'mafia', _updated_at = ? WHERE _row_id = ?\").bind([now, game_id]));\n batch.push(conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '💀 The Mafia wins! They have taken over the village!', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now]));\n }\n } else {\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🤷 No consensus reached. No one was eliminated.', 'system', ?, ?, ?)\").bind([game_id, game.current_round, now, now])\n );\n }\n\n // Advance to night\n const newRound = game.current_round + 1;\n batch.push(\n conn.prepare(\"UPDATE games SET phase = 'night', current_round = ?, _updated_at = ? WHERE _row_id = ?\").bind([newRound, now, game_id])\n );\n batch.push(\n conn.prepare(\"INSERT INTO game_messages (game_id, sender_name, message, channel, round_num, _created_at, _updated_at) VALUES (?, '🎭 System', '🌙 Night falls once again... The Mafia awakens.', 'system', ?, ?, ?)\").bind([game_id, newRound, now, now])\n );\n }\n\n if (batch.length > 0) await conn.batch(batch);\n return Response.json({ success: true });\n }\n\n return Response.json({ error: \"Unknown action\" }, { status: 400 });\n } catch (err) {\n console.error(\"Game engine error:\", err);\n return Response.json({ error: err.message || \"Internal error\" }, { status: 500 });\n }\n}\n",["D",1770133360916],"versions",[232,234,235,236],{"_193":215,"_233":217},"previous",{"_193":217,"_233":222},{"_193":222,"_233":226},{"_193":226,"_233":-5},"versionNumber","page","hasNext","actionData","errors"]

kliv

tee42sqq3ff8v144e8s2et1t63s1s3032t

History for fuf50v1055v1764vvt97s914se1q9vs7v1.ts