[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_222":223,"_224":225},"routes/_app.x.$handle.$name",{"_108":107,"_38":56,"_117":98,"_33":118,"_13":14,"_119":-5,"_11":120,"_121":122,"_123":124,"_125":126,"_127":128,"_27":-5,"_129":-5,"_130":-5,"_131":31,"_132":133,"_134":70,"_135":-5,"_136":-5,"_137":138},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_54":55,"_38":56,"_44":57,"_58":-5,"_59":31,"_60":61,"_62":61,"_63":64,"_65":-5,"_19":66,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":74,"_75":76,"_77":-5,"_78":-5,"_79":-5,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":91,"_92":93,"_94":95,"_96":31},"version",5,"changes",[25,26],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","9823b296-72ca-45be-a955-308c58b319c3","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_27":49,"_29":-7,"_30":31,"_32":31,"_33":50,"_35":50},{"_27":28,"_29":-7,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous","deleted",false,"deletedHere","path","database/schema.ts","latestPath","fileId","967831b8-3831-11f1-b0ca-42b51c65c3df","name","schema.ts","fileType","script","content","/**\n * Database schema and queries for the Emoji-Bewerbungssystem\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDatabase() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS emoji_roles (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n guild_id TEXT NOT NULL,\n emoji TEXT NOT NULL,\n role_id TEXT NOT NULL,\n role_name TEXT NOT NULL,\n label TEXT NOT NULL,\n description TEXT DEFAULT '',\n message_channel_id TEXT NOT NULL,\n request_channel_id TEXT NOT NULL,\n log_channel_id TEXT NOT NULL,\n setup_channel_id TEXT NOT NULL,\n apply_message_id TEXT DEFAULT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(guild_id, emoji)\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS applications (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n guild_id TEXT NOT NULL,\n user_id TEXT NOT NULL,\n emoji TEXT NOT NULL,\n role_id TEXT NOT NULL,\n status TEXT DEFAULT 'pending',\n admin_message_id TEXT DEFAULT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS guild_config (\n guild_id TEXT PRIMARY KEY,\n message_channel_id TEXT NOT NULL,\n request_channel_id TEXT NOT NULL,\n log_channel_id TEXT NOT NULL,\n setup_channel_id TEXT NOT NULL,\n apply_message_id TEXT DEFAULT NULL\n )`,\n args: [],\n },\n ]);\n}\n\n// Guild Config\nexport async function getGuildConfig(guildId: string) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM guild_config WHERE guild_id = ?\",\n args: [guildId],\n });\n return result.rows[0] || null;\n}\n\nexport async function setGuildConfig(\n guildId: string,\n messageChannelId: string,\n requestChannelId: string,\n logChannelId: string,\n setupChannelId: string,\n) {\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO guild_config \n (guild_id, message_channel_id, request_channel_id, log_channel_id, setup_channel_id) \n VALUES (?, ?, ?, ?, ?)`,\n args: [guildId, messageChannelId, requestChannelId, logChannelId, setupChannelId],\n });\n}\n\nexport async function setApplyMessageId(guildId: string, messageId: string) {\n await sqlite.execute({\n sql: \"UPDATE guild_config SET apply_message_id = ? WHERE guild_id = ?\",\n args: [messageId, guildId],\n });\n}\n\n// Emoji Roles\nexport async function addEmojiRole(\n guildId: string,\n emoji: string,\n roleId: string,\n roleName: string,\n label: string,\n description: string,\n config: any,\n) {\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO emoji_roles \n (guild_id, emoji, role_id, role_name, label, description, message_channel_id, request_channel_id, log_channel_id, setup_channel_id) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n guildId,\n emoji,\n roleId,\n roleName,\n label,\n description,\n config.message_channel_id,\n config.request_channel_id,\n config.log_channel_id,\n config.setup_channel_id,\n ],\n });\n}\n\nexport async function removeEmojiRole(guildId: string, emoji: string) {\n await sqlite.execute({\n sql: \"DELETE FROM emoji_roles WHERE guild_id = ? AND emoji = ?\",\n args: [guildId, emoji],\n });\n}\n\nexport async function getEmojiRoles(guildId: string) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM emoji_roles WHERE guild_id = ? ORDER BY created_at ASC\",\n args: [guildId],\n });\n return result.rows;\n}\n\nexport async function getEmojiRole(guildId: string, emoji: string) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM emoji_roles WHERE guild_id = ? AND emoji = ?\",\n args: [guildId, emoji],\n });\n return result.rows[0] || null;\n}\n\n// Applications\nexport async function createApplication(guildId: string, userId: string, emoji: string, roleId: string) {\n await sqlite.execute({\n sql: `INSERT INTO applications (guild_id, user_id, emoji, role_id, status) VALUES (?, ?, ?, ?, 'pending')`,\n args: [guildId, userId, emoji, roleId],\n });\n const result = await sqlite.execute({ sql: \"SELECT last_insert_rowid() as id\", args: [] });\n return result.rows[0];\n}\n\nexport async function updateApplicationStatus(id: number, status: string) {\n await sqlite.execute({\n sql: \"UPDATE applications SET status = ? WHERE id = ?\",\n args: [status, id],\n });\n}\n\nexport async function setApplicationAdminMessage(id: number, messageId: string) {\n await sqlite.execute({\n sql: \"UPDATE applications SET admin_message_id = ? WHERE id = ?\",\n args: [messageId, id],\n });\n}\n\nexport async function getApplicationById(id: number) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM applications WHERE id = ?\",\n args: [id],\n });\n return result.rows[0] || null;\n}\n\nexport async function getPendingApplication(guildId: string, userId: string, emoji: string) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM applications WHERE guild_id = ? AND user_id = ? AND emoji = ? AND status = 'pending'\",\n args: [guildId, userId, emoji],\n });\n return result.rows[0] || null;\n}\n","createdAt",["D",1776192105406],"branchVersion","branchId","73503406-3831-11f1-a548-42b51c65c3df",{"_36":51,"_38":50,"_40":52,"_42":-5,"_44":53,"_46":14,"_47":48,"_30":31},"database","8037ee09-94a8-4c55-885e-f98c41a82cbb","directory",["D",1776192105406],"id","734f95d2-3831-11f1-a548-42b51c65c3df","discord-emoji-apply-bot",["D",1776192046430],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Discord Bot: Emoji-Bewerbungssystem mit Admin-Panel","imageUrl","40d60734-a91c-4cc2-9305-b592a890bee5","pinnedFileId","7e90986a-3831-11f1-980a-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d8d4b-5635-76cf-ac0c-e26664ce89f6","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_108":107,"_116":112},"org",{"_108":107,"_109":110,"_111":112,"_19":-5,"_113":114,"_115":31},"branch",{"_13":97,"_38":98,"_54":48,"_99":55,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":56,"_106":107},"isOwned",25,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","CyberCore","handle","displayName","CyberCore ","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/87a0b6a2-3e42-41a1-3ec2-d561aa654100/square512?exp=1789559999&sig=be6fa84bf881246d94e07fcde5b4e33384988ae8bb5e68d331e54a87814ed07c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_54":55,"_38":56,"_44":218,"_58":-5,"_59":31,"_60":61,"_62":61,"_63":64,"_65":-5,"_19":66,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":74,"_75":76,"_77":-5,"_78":-5,"_79":-5,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":219,"_92":220,"_94":221,"_96":31},"tree",[179,181,184,185],"files",[179,180,181,182,183,184,185],"counts",{"_169":74,"_170":146,"_171":74,"_172":173,"_174":175},"contents",[139,140,141,142],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_54":166,"_38":50,"_36":51,"_145":-5,"_47":48,"_46":14,"_147":70,"_44":167,"_13":74,"_40":52,"_42":-5,"_30":31,"_151":-5,"_33":168},{"_54":160,"_38":161,"_36":162,"_145":-5,"_47":48,"_46":163,"_147":70,"_44":164,"_13":74,"_40":52,"_42":-5,"_30":31,"_151":-5,"_33":165},{"_54":153,"_38":154,"_36":155,"_145":-5,"_47":48,"_46":156,"_147":31,"_44":157,"_13":74,"_40":27,"_42":158,"_30":31,"_151":-5,"_33":159},{"_54":143,"_38":144,"_36":68,"_145":-5,"_47":48,"_46":146,"_147":70,"_44":148,"_13":74,"_40":149,"_42":150,"_30":31,"_151":-5,"_33":152},"7e9097b6-3831-11f1-980a-42b51c65c3df","main.ts","parentId",1,"latest",["D",1776192065301],"http","/**\n * Discord Emoji-Bewerbungssystem Bot\n * \n * Interactions Endpoint - Handles Discord slash commands and button interactions.\n * Set this URL as your bot's INTERACTIONS ENDPOINT URL in Discord Developer Portal.\n * \n * Required env vars:\n * - DISCORD_BOT_TOKEN\n * - DISCORD_PUBLIC_KEY\n * - DISCORD_APPLICATION_ID\n */\n\nimport { verifyDiscordRequest } from \"./discord/verify.ts\";\nimport { handleInteraction } from \"./discord/handler.ts\";\n\nexport default async function(req: Request): Promise {\n if (req.method === \"GET\") {\n return new Response(\"🤖 Discord Emoji-Bewerbungssystem Bot is running!\", {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n // Verify the request is from Discord\n const publicKey = Deno.env.get(\"DISCORD_PUBLIC_KEY\");\n if (!publicKey) {\n return new Response(\"Missing DISCORD_PUBLIC_KEY\", { status: 500 });\n }\n\n const body = await req.text();\n const signature = req.headers.get(\"x-signature-ed25519\");\n const timestamp = req.headers.get(\"x-signature-timestamp\");\n\n if (!signature || !timestamp) {\n return new Response(\"Missing signature headers\", { status: 401 });\n }\n\n const isValid = await verifyDiscordRequest(body, signature, timestamp, publicKey);\n if (!isValid) {\n return new Response(\"Invalid signature\", { status: 401 });\n }\n\n const interaction = JSON.parse(body);\n\n // PING - Discord verification\n if (interaction.type === 1) {\n return Response.json({ type: 1 });\n }\n\n // Handle slash commands (type 2), buttons (type 3), modals (type 5)\n return handleInteraction(interaction);\n}\n","label",[144],"8074ac66-3831-11f1-81ab-42b51c65c3df","README.md","8074ad38-3831-11f1-81ab-42b51c65c3df",2,["D",1776192068461],"# discord-emoji-apply-bot",[154],"82842c7a-3831-11f1-980a-42b51c65c3df","discord","edf9ef2f-dca3-4f2c-9269-8df6b96b33e2",3,["D",1776192071914],[161],"96784f2c-3831-11f1-b0ca-42b51c65c3df",["D",1776192105406],[50],"pulls","branches","forks","envVars",{"_176":74,"_178":74},"connections",{"_176":74,"_177":74},"count","unfilledCount","emptyCount",{"_54":166,"_38":50,"_36":51,"_145":-5,"_47":48,"_46":14,"_147":70,"_44":215,"_13":74,"_40":52,"_42":-5,"_30":31,"_151":-5,"_187":216,"_33":217},{"_54":211,"_38":39,"_36":37,"_145":51,"_47":48,"_46":14,"_147":31,"_44":212,"_13":74,"_40":41,"_42":43,"_30":31,"_151":-5,"_187":213,"_33":214},{"_54":160,"_38":161,"_36":162,"_145":-5,"_47":48,"_46":163,"_147":70,"_44":208,"_13":74,"_40":52,"_42":-5,"_30":31,"_151":-5,"_187":209,"_33":210},{"_54":200,"_38":201,"_36":202,"_145":162,"_47":48,"_46":203,"_147":31,"_44":204,"_13":74,"_40":41,"_42":205,"_30":31,"_151":-5,"_187":206,"_33":207},{"_54":193,"_38":194,"_36":195,"_145":162,"_47":48,"_46":163,"_147":70,"_44":196,"_13":74,"_40":41,"_42":197,"_30":31,"_151":-5,"_187":198,"_33":199},{"_54":153,"_38":154,"_36":155,"_145":-5,"_47":48,"_46":156,"_147":31,"_44":190,"_13":74,"_40":27,"_42":158,"_30":31,"_151":-5,"_187":191,"_33":192},{"_54":143,"_38":144,"_36":68,"_145":-5,"_47":48,"_46":146,"_147":70,"_44":186,"_13":74,"_40":149,"_42":150,"_30":31,"_151":-5,"_187":188,"_33":189},["D",1776192065301],"children",[],[144],["D",1776192068461],[],[154],"82841fa0-3831-11f1-980a-42b51c65c3df","verify.ts","8284204a-3831-11f1-980a-42b51c65c3df",["D",1776192071914],"/**\n * Verify Discord interaction requests using Ed25519 signatures\n */\n\nexport async function verifyDiscordRequest(\n body: string,\n signature: string,\n timestamp: string,\n publicKey: string,\n): Promise {\n try {\n const key = await crypto.subtle.importKey(\n \"raw\",\n hexToUint8Array(publicKey),\n { name: \"Ed25519\", namedCurve: \"Ed25519\" },\n false,\n [\"verify\"],\n );\n\n const encoder = new TextEncoder();\n const message = encoder.encode(timestamp + body);\n const sig = hexToUint8Array(signature);\n\n return await crypto.subtle.verify(\"Ed25519\", key, sig, message);\n } catch (e) {\n console.error(\"Verification error:\", e);\n return false;\n }\n}\n\nfunction hexToUint8Array(hex: string): Uint8Array {\n const bytes = new Uint8Array(hex.length / 2);\n for (let i = 0; i < hex.length; i += 2) {\n bytes[i / 2] = parseInt(hex.substring(i, i + 2), 16);\n }\n return bytes;\n}\n",[],[161,194],"8b37c958-3831-11f1-b0ca-42b51c65c3df","api.ts","8b37ca20-3831-11f1-b0ca-42b51c65c3df",4,["D",1776192086519],"/**\n * Discord REST API helper functions\n */\n\nconst DISCORD_API = \"https://discord.com/api/v10\";\n\nfunction getToken(): string {\n return Deno.env.get(\"DISCORD_BOT_TOKEN\") || \"\";\n}\n\nfunction headers(): HeadersInit {\n return {\n \"Authorization\": `Bot ${getToken()}`,\n \"Content-Type\": \"application/json\",\n };\n}\n\nexport async function sendMessage(channelId: string, data: any): Promise {\n const res = await fetch(`${DISCORD_API}/channels/${channelId}/messages`, {\n method: \"POST\",\n headers: headers(),\n body: JSON.stringify(data),\n });\n if (!res.ok) {\n const err = await res.text();\n console.error(`sendMessage error (${channelId}):`, err);\n throw new Error(`Discord API error: ${res.status} - ${err}`);\n }\n return res.json();\n}\n\nexport async function editMessage(channelId: string, messageId: string, data: any): Promise {\n const res = await fetch(`${DISCORD_API}/channels/${channelId}/messages/${messageId}`, {\n method: \"PATCH\",\n headers: headers(),\n body: JSON.stringify(data),\n });\n if (!res.ok) {\n const err = await res.text();\n console.error(`editMessage error:`, err);\n throw new Error(`Discord API error: ${res.status} - ${err}`);\n }\n return res.json();\n}\n\nexport async function addRole(guildId: string, userId: string, roleId: string): Promise {\n const res = await fetch(`${DISCORD_API}/guilds/${guildId}/members/${userId}/roles/${roleId}`, {\n method: \"PUT\",\n headers: headers(),\n });\n if (!res.ok) {\n const err = await res.text();\n console.error(`addRole error:`, err);\n throw new Error(`Discord API error: ${res.status} - ${err}`);\n }\n}\n\nexport async function getUser(userId: string): Promise {\n const res = await fetch(`${DISCORD_API}/users/${userId}`, {\n method: \"GET\",\n headers: headers(),\n });\n if (!res.ok) throw new Error(`Failed to get user: ${res.status}`);\n return res.json();\n}\n\nexport async function addReaction(channelId: string, messageId: string, emoji: string): Promise {\n const encoded = encodeURIComponent(emoji);\n const res = await fetch(\n `${DISCORD_API}/channels/${channelId}/messages/${messageId}/reactions/${encoded}/@me`,\n { method: \"PUT\", headers: headers() },\n );\n if (!res.ok) {\n const err = await res.text();\n console.error(`addReaction error:`, err);\n }\n}\n\nexport async function removeReaction(\n channelId: string,\n messageId: string,\n emoji: string,\n): Promise {\n const encoded = encodeURIComponent(emoji);\n const res = await fetch(\n `${DISCORD_API}/channels/${channelId}/messages/${messageId}/reactions/${encoded}/@me`,\n { method: \"DELETE\", headers: headers() },\n );\n if (!res.ok) {\n const err = await res.text();\n console.error(`removeReaction error:`, err);\n }\n}\n\nexport async function getGuildRoles(guildId: string): Promise {\n const res = await fetch(`${DISCORD_API}/guilds/${guildId}/roles`, {\n method: \"GET\",\n headers: headers(),\n });\n if (!res.ok) throw new Error(`Failed to get roles: ${res.status}`);\n return res.json();\n}\n\nexport async function followUpMessage(applicationId: string, interactionToken: string, data: any): Promise {\n const res = await fetch(`${DISCORD_API}/webhooks/${applicationId}/${interactionToken}`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(data),\n });\n if (!res.ok) {\n const err = await res.text();\n console.error(`followUp error:`, err);\n }\n return res;\n}\n",[],[161,201],["D",1776192071914],[182,183],[161],"967830e6-3831-11f1-b0ca-42b51c65c3df",["D",1776192105406],[],[50,39],["D",1776192105406],[180],[50],["D",1776192046430],{"_108":107,"_116":112},{"_108":107,"_109":110,"_111":112,"_19":-5,"_113":114,"_115":31},{"_13":97,"_38":98,"_54":48,"_99":55,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":56,"_106":107},"ctx",{"_90":-5,"_136":255,"_256":257,"_258":259,"_260":31,"_261":31,"_262":31,"_263":70,"_264":-5,"_265":-7,"_266":-7,"_267":74,"_268":31,"_269":31,"_270":-5,"_271":31,"_272":31,"_273":31,"_274":-5},"ENV",{"_226":227,"_228":229,"_230":98,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254},"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"]

Diff · v5