[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_159":160,"_161":162},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_120":-5,"_20":121,"_22":122,"_123":124,"_125":126,"_25":127,"_24":-5,"_128":-5,"_129":-5,"_130":53,"_131":132,"_133":53,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","shauryakatial","name","discord-team-validator","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":82,"_83":84,"_85":86,"_87":-5,"_88":89,"_90":89,"_91":92,"_93":92,"_94":92,"_95":89,"_96":89,"_97":98,"_99":100,"_101":102,"_103":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","154ea6c8-e6a5-430d-8385-1f59b355a120","main.ts","fileId","90300836-85a6-11f1-93cb-1607ee4eb77e","parentId","branchId","eb7aafc6-ebf1-4df8-9895-d59666e81dd0","branchVersion",12,"latest",true,"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",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1784714761954],"children",[],[35],"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",0,"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,"_119":115},"org",{"_11":12,"_112":113,"_114":115,"_71":72,"_116":117,"_118":53},"branch",{"_17":42,"_13":16,"_33":40,"_104":61,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":-5,"_110":14,"_111":12},"isOwned","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",{"_33":61,"_13":14,"_45":154,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":82,"_83":84,"_85":155,"_87":-5,"_88":89,"_90":89,"_91":92,"_93":92,"_94":92,"_95":89,"_96":89,"_97":156,"_99":157,"_101":158,"_103":53},[151],"files",[151],"counts",{"_140":78,"_141":142,"_143":78,"_31":144,"_145":146},[138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":139},[35],"pulls","branches",1,"forks",{"_147":149,"_150":78},"connections",{"_147":78,"_148":78},"count","unfilledCount",2,"emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":152,"_18":153},[],[35],["D",1784708575632],["D",1789494036282],{"_11":12,"_119":115},{"_11":12,"_112":113,"_114":115,"_71":72,"_116":117,"_118":53},{"_17":42,"_13":16,"_33":40,"_104":61,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":-5,"_110":14,"_111":12},"ctx",{"_97":-5,"_135":192,"_193":194,"_195":196,"_197":53,"_198":53,"_199":53,"_200":44,"_201":-5,"_202":-7,"_203":-7,"_204":78,"_205":53,"_206":53,"_207":-5,"_208":53,"_209":53,"_210":53,"_211":-5},"ENV",{"_163":164,"_165":166,"_167":16,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191},"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"]

Code