[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_155":156,"_157":158},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_91":-7,"_92":93,"_29":-7,"_94":-5,"_15":95,"_96":97,"_98":99,"_100":101,"_102":103,"_104":-5,"_105":-5,"_106":-5,"_107":38,"_108":109,"_110":38,"_111":-5,"_112":-5,"_113":114},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","shauryakatial","name","discord-team-validator","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":38,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":-5,"_62":63,"_64":63,"_65":66,"_67":66,"_68":66,"_69":63,"_70":63,"_71":72,"_73":74,"_75":76,"_77":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","eb7aafc6-ebf1-4df8-9895-d59666e81dd0","createdAt",["D",1784708575638],"updatedAt",["D",1784714761954],"main","projectId","21d67685-0a3f-4072-b766-ce6bd50f9df3","version",12,"forkedBranchId","forkedBranchVersion","lockfileKey","1784714762188-esm.town_v_shauryakatial_discord-team-validator@12-main","deletedAt",["D",1784708575632],"legacyEnvVars",false,"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,"_90":86},"org",{"_11":12,"_83":84,"_85":86,"_45":46,"_87":88,"_89":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","shaurya katial","avatar","https://lh3.googleusercontent.com/a/ACg8ocLHLIb7h4_jOpcTO169ktoCBLo06LhJg0Us6UbXZ-rhLRs1dIkZ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_20":28,"_13":14,"_22":150,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":38,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":56,"_57":58,"_59":151,"_61":-5,"_62":63,"_64":63,"_65":66,"_67":66,"_68":66,"_69":63,"_70":63,"_71":152,"_73":153,"_75":154,"_77":38},"tree",[145],"files",[145],"counts",{"_134":52,"_17":135,"_136":52,"_137":138,"_139":140},"contents",[115],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_20":116,"_13":117,"_118":119,"_120":-5,"_121":21,"_122":30,"_123":124,"_22":125,"_29":126,"_127":128,"_129":130,"_131":38,"_132":-5,"_92":133},"154ea6c8-e6a5-430d-8385-1f59b355a120","main.ts","fileId","90300836-85a6-11f1-93cb-1607ee4eb77e","parentId","branchId","branchVersion","latest",true,["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",[117],"pulls",1,"forks","envVars",{"_141":143,"_144":52},"connections",{"_141":52,"_142":52},"count","unfilledCount",2,"emptyCount",{"_20":116,"_13":117,"_118":119,"_120":-5,"_121":21,"_122":30,"_123":124,"_22":146,"_29":126,"_127":128,"_129":130,"_131":38,"_132":-5,"_147":148,"_92":149},["D",1784714761954],"children",[],[117],["D",1784708575632],["D",1789494036282],{"_11":12,"_90":86},{"_11":12,"_83":84,"_85":86,"_45":46,"_87":88,"_89":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"ctx",{"_71":-5,"_112":188,"_189":190,"_191":192,"_193":38,"_194":38,"_195":38,"_196":124,"_197":-5,"_198":-7,"_199":-7,"_200":52,"_201":38,"_202":38,"_203":-5,"_204":38,"_205":38,"_206":38,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":26,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"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"]

Branches1

Branches
1