[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_169":170,"_171":172},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_61":138,"_16":-7,"_139":-5,"_17":140,"_141":142,"_28":143,"_21":144,"_23":145,"_146":-5,"_147":-5,"_148":-5,"_149":36,"_150":151,"_152":36,"_153":-5,"_154":-5,"_155":156},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":-5,"_31":-5,"_32":-5,"_33":34,"_35":36,"_37":36},"handle","shauryakatial","name","discord-team-validator","branchName","version","project",{"_39":79,"_13":14,"_50":80,"_81":-5,"_82":36,"_83":84,"_85":84,"_86":87,"_88":-5,"_89":90,"_91":-5,"_92":36,"_93":-5,"_94":-5,"_95":67,"_96":97,"_98":99,"_100":101,"_102":103,"_104":-5,"_105":106,"_107":106,"_108":109,"_110":109,"_111":109,"_112":106,"_113":106,"_114":115,"_116":117,"_118":119,"_120":36},"tags",[],"counts",{"_66":67,"_68":69,"_70":67,"_71":72,"_73":74},"contents",[63],"readme","upstream","pull","files",[38],"preview","ahead","behind","showHomeCustomizationHint",true,"showHTTPPreviewSettingsHint",false,"hasHTTPFiles",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":51,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_59":60,"_61":62},"id","154ea6c8-e6a5-430d-8385-1f59b355a120","main.ts","fileId","90300836-85a6-11f1-93cb-1607ee4eb77e","parentId","branchId","eb7aafc6-ebf1-4df8-9895-d59666e81dd0","branchVersion",12,"latest","createdAt",["D",1784714761954],11,"fileType","interval","content","import { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst BOT_TOKEN = Deno.env.get(\"DISCORD_BOT_TOKEN\");\nconst CHANNEL_ID = Deno.env.get(\"DISCORD_CHANNEL_ID\");\nconst API = \"https://discord.com/api/v10\";\n\n// --- Database setup ---\n\nasync function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS teams (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n team_name TEXT NOT NULL UNIQUE,\n message_id TEXT NOT NULL,\n submitted_at TEXT NOT NULL\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS team_members (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n team_id INTEGER NOT NULL,\n user_id TEXT NOT NULL,\n FOREIGN KEY (team_id) REFERENCES teams(id)\n )\n `);\n}\n\n/** Check if a team name is already taken */\nasync function isDuplicateTeamName(teamName: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT 1 FROM teams WHERE LOWER(team_name) = LOWER(?) LIMIT 1\",\n args: [teamName.trim()],\n });\n return result.rows.length > 0;\n}\n\n/** Check if any user is already on another team.\n * Returns a map of userId -> teamName for users already on a team.\n */\nasync function findCrossTeamUsers(userIds: string[]): Promise> {\n const placeholders = userIds.map(() => \"?\").join(\", \");\n const result = await sqlite.execute({\n sql: `SELECT tm.user_id, t.team_name\n FROM team_members tm\n JOIN teams t ON tm.team_id = t.id\n WHERE tm.user_id IN (${placeholders})`,\n args: userIds,\n });\n const map = new Map();\n for (const row of result.rows) {\n map.set(row.user_id as string, row.team_name as string);\n }\n return map;\n}\n\n/** Store a valid team submission in the database */\nasync function storeTeam(teamName: string, userIds: string[], messageId: string) {\n const now = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO teams (team_name, message_id, submitted_at) VALUES (?, ?, ?)\",\n args: [teamName.trim(), messageId, now],\n });\n const teamId = result.lastInsertRowid;\n for (const userId of userIds) {\n await sqlite.execute({\n sql: \"INSERT INTO team_members (team_id, user_id) VALUES (?, ?)\",\n args: [teamId, userId],\n });\n }\n}\n\n// --- Validation ---\n\n/** A valid submission has exactly 5 lines:\n * line 1 — team name (any non-empty text)\n * lines 2-5 — four *unique* user mentions (<@id> or <@!id>)\n * Returns { valid: true, teamName, userIds } or { valid: false, reason }.\n */\nfunction validateFormat(content: string):\n | { valid: true; teamName: string; userIds: string[] }\n | { valid: false; reason: string }\n{\n const lines = content.trim().split(\"\\n\");\n\n if (lines.length !== 5) {\n return {\n valid: false,\n reason: `Expected exactly 5 lines but got ${lines.length}. Format: line 1 = team name, lines 2-5 = 4 unique user mentions.`,\n };\n }\n\n // Line 1 must be non-empty text (team name)\n const teamName = lines[0].trim();\n if (teamName.length === 0) {\n return { valid: false, reason: \"Line 1 (team name) is empty.\" };\n }\n\n // Lines 2-5 must each be a user mention\n const mentionRe = /^<@!?\\d+>$/;\n const ids: string[] = [];\n for (let i = 1; i <= 4; i++) {\n const line = lines[i].trim();\n if (!mentionRe.test(line)) {\n return {\n valid: false,\n reason: `Line ${i + 1} must be a user mention (like \\`@user\\`), but got: \"${line}\".`,\n };\n }\n ids.push(line.replace(/[<@!>]/g, \"\"));\n }\n\n // All four mentions must be unique within this message\n if (new Set(ids).size !== 4) {\n const dupes = ids.filter((id, i) => ids.indexOf(id) !== i);\n return {\n valid: false,\n reason: `All 4 user mentions must be unique. Duplicate user(s) detected: ${dupes.map((id) => `<@${id}>`).join(\", \")}.`,\n };\n }\n\n return { valid: true, teamName, userIds: ids };\n}\n\n/** Full validation: format + DB checks (duplicate team name, cross-team users) */\nasync function validateSubmission(\n content: string,\n messageId: string,\n): Promise<{ valid: true } | { valid: false; reason: string }> {\n // 1. Format check\n const formatResult = validateFormat(content);\n if (!formatResult.valid) return formatResult;\n\n const { teamName, userIds } = formatResult;\n\n // 2. Duplicate team name check\n if (await isDuplicateTeamName(teamName)) {\n return {\n valid: false,\n reason: `Team name \"**${teamName}**\" is already taken. Please choose a different name.`,\n };\n }\n\n // 3. Cross-team check — are any of these users already on another team?\n const crossTeamMap = await findCrossTeamUsers(userIds);\n if (crossTeamMap.size > 0) {\n const conflicts: string[] = [];\n for (const [userId, existingTeam] of crossTeamMap) {\n conflicts.push(`<@${userId}> is already on team \"**${existingTeam}**\"`);\n }\n return {\n valid: false,\n reason: `Cross-team conflict detected! ${conflicts.join(\"; \")}. Each player can only be on one team.`,\n };\n }\n\n // 4. All checks passed — store the team\n await storeTeam(teamName, userIds, messageId);\n\n return { valid: true };\n}\n\n// --- Discord API helpers ---\n\nasync function addReaction(messageId: string, emoji: string) {\n const res = await fetch(\n `${API}/channels/${CHANNEL_ID}/messages/${messageId}/reactions/${encodeURIComponent(emoji)}/@me`,\n { method: \"PUT\", headers: { Authorization: `Bot ${BOT_TOKEN}` } },\n );\n if (res.status === 429) {\n const body = await res.json();\n await new Promise((r) => setTimeout(r, (body.retry_after ?? 0.5) * 1000));\n const retry = await fetch(\n `${API}/channels/${CHANNEL_ID}/messages/${messageId}/reactions/${encodeURIComponent(emoji)}/@me`,\n { method: \"PUT\", headers: { Authorization: `Bot ${BOT_TOKEN}` } },\n );\n if (!retry.ok) console.error(`Reaction retry failed (${retry.status}): ${await retry.text()}`);\n } else if (!res.ok) {\n console.error(`Reaction failed (${res.status}): ${await res.text()}`);\n }\n await new Promise((r) => setTimeout(r, 250));\n}\n\nfunction looksLikeSubmission(content: string): boolean {\n const lines = content.trim().split(\"\\n\");\n if (lines.length < 2) return false;\n return /<@!?\\d+>/.test(content);\n}\n\nasync function sendReason(messageId: string, reason: string) {\n const res = await fetch(`${API}/channels/${CHANNEL_ID}/messages`, {\n method: \"POST\",\n headers: {\n Authorization: `Bot ${BOT_TOKEN}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n content: `❌ **Invalid submission!**\\n> ${reason}`,\n message_reference: { message_id: messageId },\n }),\n });\n if (res.status === 429) {\n const body = await res.json();\n await new Promise((r) => setTimeout(r, (body.retry_after ?? 0.5) * 1000));\n const retry = await fetch(`${API}/channels/${CHANNEL_ID}/messages`, {\n method: \"POST\",\n headers: {\n Authorization: `Bot ${BOT_TOKEN}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n content: `❌ **Invalid submission!**\\n> ${reason}`,\n message_reference: { message_id: messageId },\n }),\n });\n if (!retry.ok) console.error(`Send reason retry failed (${retry.status}): ${await retry.text()}`);\n } else if (!res.ok) {\n console.error(`Send reason failed (${res.status}): ${await res.text()}`);\n }\n await new Promise((r) => setTimeout(r, 250));\n}\n\n// --- Main ---\n\nexport default async function() {\n if (!BOT_TOKEN || !CHANNEL_ID) {\n console.error(\"Set DISCORD_BOT_TOKEN and DISCORD_CHANNEL_ID env vars!\");\n return;\n }\n\n await initDB();\n\n const lastId: string | null = await blob.getJSON(\"last_message_id\");\n\n const url =\n `${API}/channels/${CHANNEL_ID}/messages?limit=50` +\n (lastId ? `&after=${lastId}` : \"\");\n\n const res = await fetch(url, {\n headers: { Authorization: `Bot ${BOT_TOKEN}` },\n });\n const messages = await res.json();\n\n if (!Array.isArray(messages)) {\n console.error(\"Failed to fetch messages:\", JSON.stringify(messages));\n return;\n }\n\n for (const msg of messages.reverse()) {\n if (msg.author?.bot) continue;\n\n if (!looksLikeSubmission(msg.content)) {\n console.log(`Message ${msg.id}: skipped (not a submission attempt)`);\n continue;\n }\n\n const result = await validateSubmission(msg.content, msg.id);\n await addReaction(msg.id, result.valid ? \"✅\" : \"❌\");\n\n if (!result.valid) {\n await sendReason(msg.id, result.reason);\n }\n\n console.log(`Message ${msg.id}: ${result.valid ? \"✅\" : \"❌\"}${result.valid ? \"\" : ` — ${result.reason}`}`);\n }\n\n if (messages.length > 0) {\n await blob.setJSON(\"last_message_id\", messages[messages.length - 1].id);\n }\n\n console.log(`Processed ${messages.length} messages.`);\n}\n","deleted","label","children",[],"path",[41],{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":64,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_61":65},["D",1784714761954],[41],"pulls",0,"branches",1,"forks","envVars",{"_75":77,"_78":67},"connections",{"_75":67,"_76":67},"count","unfilledCount",2,"emptyCount","21d67685-0a3f-4072-b766-ce6bd50f9df3",["D",1784708575632],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Discord bot that validates team submission messages","imageUrl","userId","c8f14504-c2f3-4ee7-97c2-6df82c2b3e74","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f88e8-c55c-71f6-b830-25046ace892b","tursoName","21d676850a3f4072b766ce6bd50f9df3","tursoHostname","21d676850a3f4072b766ce6bd50f9df3-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789494036282],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_137":133},"org",{"_11":12,"_130":131,"_132":133,"_89":90,"_134":135,"_136":36},"branch",{"_16":48,"_13":121,"_39":46,"_122":79,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":14,"_129":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","shaurya katial","avatar","https://lh3.googleusercontent.com/a/ACg8ocLHLIb7h4_jOpcTO169ktoCBLo06LhJg0Us6UbXZ-rhLRs1dIkZ=s96-c","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_39":79,"_13":14,"_50":164,"_81":-5,"_82":36,"_83":84,"_85":84,"_86":87,"_88":-5,"_89":90,"_91":-5,"_92":36,"_93":-5,"_94":-5,"_95":67,"_96":97,"_98":99,"_100":101,"_102":165,"_104":-5,"_105":106,"_107":106,"_108":109,"_110":109,"_111":109,"_112":106,"_113":106,"_114":166,"_116":167,"_118":168,"_120":36},"tree",[161],[161],{"_66":67,"_68":69,"_70":67,"_71":159,"_73":160},[157],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":64,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_61":158},[41],{"_75":77,"_78":67},{"_75":67,"_76":67},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":51,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_59":162,"_61":163},[],[41],["D",1784708575632],["D",1789494036282],{"_11":12,"_137":133},{"_11":12,"_130":131,"_132":133,"_89":90,"_134":135,"_136":36},{"_16":48,"_13":121,"_39":46,"_122":79,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":14,"_129":12},"ctx",{"_114":-5,"_154":202,"_203":204,"_205":206,"_207":36,"_208":36,"_209":36,"_210":34,"_211":-5,"_212":-7,"_213":-7,"_214":67,"_215":36,"_216":36,"_217":-5,"_218":36,"_219":36,"_220":36,"_221":-5},"ENV",{"_173":174,"_175":176,"_177":121,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]