[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_150":151,"_152":153},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_86":68,"_87":88,"_66":-7,"_89":-5,"_13":90,"_91":92,"_11":93,"_94":95,"_96":97,"_98":-5,"_99":-5,"_100":-5,"_101":26,"_102":103,"_104":26,"_105":-5,"_106":-5,"_107":108},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":-5,"_36":26,"_37":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":-5,"_50":51,"_52":51,"_53":54,"_55":54,"_56":54,"_57":51,"_58":51,"_59":60,"_61":62,"_63":64,"_65":26},"query","handle","shauryakatial","id","21d67685-0a3f-4072-b766-ce6bd50f9df3","name","discord-team-validator","createdAt",["D",1784708575632],"deletedAt","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",{"_16":17,"_85":81},"org",{"_16":17,"_78":79,"_80":81,"_33":34,"_82":83,"_84":26},"branch",{"_66":67,"_20":68,"_18":69,"_70":19,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":-5,"_76":21,"_77":17},"isOwned","version",12,"main","eb7aafc6-ebf1-4df8-9895-d59666e81dd0","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","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":145,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":-5,"_36":26,"_37":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":146,"_49":-5,"_50":51,"_52":51,"_53":54,"_55":54,"_56":54,"_57":51,"_58":51,"_59":147,"_61":148,"_63":149,"_65":26},"tree",[140],[140],"counts",{"_128":40,"_129":130,"_131":40,"_132":133,"_134":135},"contents",[109],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_18":110,"_20":111,"_112":113,"_114":-5,"_115":69,"_116":67,"_117":118,"_22":119,"_66":120,"_121":122,"_123":124,"_125":26,"_126":-5,"_87":127},"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",[111],"pulls","branches",1,"forks","envVars",{"_136":138,"_139":40},"connections",{"_136":40,"_137":40},"count","unfilledCount",2,"emptyCount",{"_18":110,"_20":111,"_112":113,"_114":-5,"_115":69,"_116":67,"_117":118,"_22":141,"_66":120,"_121":122,"_123":124,"_125":26,"_126":-5,"_142":143,"_87":144},["D",1784714761954],"children",[],[111],["D",1784708575632],["D",1789494036282],{"_16":17,"_85":81},{"_16":17,"_78":79,"_80":81,"_33":34,"_82":83,"_84":26},{"_66":67,"_20":68,"_18":69,"_70":19,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":-5,"_76":21,"_77":17},"ctx",{"_59":-5,"_106":183,"_184":185,"_186":187,"_188":26,"_189":26,"_190":26,"_191":118,"_192":-5,"_193":-7,"_194":-7,"_195":40,"_196":26,"_197":26,"_198":-5,"_199":26,"_200":26,"_201":26,"_202":-5},"ENV",{"_154":155,"_156":157,"_158":68,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182},"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"]

Search