[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_231":232,"_233":234},"routes/_app.x.$handle.$name",{"_104":103,"_38":52,"_113":94,"_33":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":31,"_128":129,"_130":66,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_50":51,"_38":52,"_45":53,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":-5,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":31},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","561e7b96-e640-4c96-b6e3-271110bbbc1c","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":41,"_42":44,"_45":46,"_47":14,"_48":49,"_30":31},"previous",{"_36":37,"_38":39,"_40":41,"_42":43},"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","/**\n * Database schema, migrations and all queries for the Emoji-Bewerbungssystem\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ─── MIGRATIONS ─────────────────────────────────────────────────\nexport async function initDatabase() {\n await sqlite.batch([\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 },\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 },\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 reviewed_by TEXT DEFAULT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS bot_owners (\n user_id TEXT PRIMARY KEY,\n added_by TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS key_users (\n user_id TEXT PRIMARY KEY,\n guild_id TEXT DEFAULT NULL,\n added_by TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS maintenance (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n enabled INTEGER NOT NULL DEFAULT 0,\n reason TEXT DEFAULT '',\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n {\n sql: `INSERT OR IGNORE INTO maintenance (id, enabled, reason) VALUES (1, 0, '')`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS support_servers (\n guild_id TEXT PRIMARY KEY,\n category_id TEXT,\n info_channel_id TEXT,\n ticket_channel_id TEXT,\n apply_panel_channel_id TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n },\n ]);\n console.log(\"✅ Database migrations complete\");\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, emoji, roleId, roleName, label, description,\n config.message_channel_id, config.request_channel_id,\n config.log_channel_id, 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 updateEmojiRole(\n guildId: string,\n emoji: string,\n roleId: string,\n roleName: string,\n label: string,\n description: string,\n) {\n await sqlite.execute({\n sql: `UPDATE emoji_roles SET role_id = ?, role_name = ?, label = ?, description = ? \n WHERE guild_id = ? AND emoji = ?`,\n args: [roleId, roleName, label, description, 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(\n guildId: string, userId: string, emoji: string, roleId: string,\n) {\n const result = 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 return { id: result.lastInsertRowid };\n}\n\nexport async function updateApplicationStatus(id: number, status: string, reviewedBy?: string) {\n await sqlite.execute({\n sql: \"UPDATE applications SET status = ?, reviewed_by = ? WHERE id = ?\",\n args: [status, reviewedBy || null, 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\n// ─── BOT OWNERS ─────────────────────────────────────────────────\nexport async function isOwner(userId: string): Promise {\n // Primary owner from env is always owner\n const primaryOwner = Deno.env.get(\"BOT_OWNER_ID\");\n if (primaryOwner && userId === primaryOwner) return true;\n const result = await sqlite.execute({\n sql: \"SELECT 1 FROM bot_owners WHERE user_id = ?\",\n args: [userId],\n });\n return result.rows.length > 0;\n}\n\nexport async function addOwner(userId: string, addedBy: string) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO bot_owners (user_id, added_by) VALUES (?, ?)\",\n args: [userId, addedBy],\n });\n}\n\nexport async function removeOwner(userId: string) {\n await sqlite.execute({\n sql: \"DELETE FROM bot_owners WHERE user_id = ?\",\n args: [userId],\n });\n}\n\nexport async function listOwners(): Promise {\n const result = await sqlite.execute({ sql: \"SELECT * FROM bot_owners\", args: [] });\n return result.rows;\n}\n\n// ─── KEY USERS ──────────────────────────────────────────────────\nexport async function isKeyUser(userId: string): Promise {\n if (await isOwner(userId)) return true;\n const result = await sqlite.execute({\n sql: \"SELECT 1 FROM key_users WHERE user_id = ?\",\n args: [userId],\n });\n return result.rows.length > 0;\n}\n\nexport async function addKeyUser(userId: string, guildId: string | null, addedBy: string) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO key_users (user_id, guild_id, added_by) VALUES (?, ?, ?)\",\n args: [userId, guildId, addedBy],\n });\n}\n\nexport async function removeKeyUser(userId: string) {\n await sqlite.execute({\n sql: \"DELETE FROM key_users WHERE user_id = ?\",\n args: [userId],\n });\n}\n\nexport async function listKeyUsers(): Promise {\n const result = await sqlite.execute({ sql: \"SELECT * FROM key_users\", args: [] });\n return result.rows;\n}\n\n// ─── MAINTENANCE ────────────────────────────────────────────────\nexport async function isMaintenanceEnabled(): Promise<{ enabled: boolean; reason: string }> {\n const result = await sqlite.execute({\n sql: \"SELECT enabled, reason FROM maintenance WHERE id = 1\",\n args: [],\n });\n if (result.rows.length === 0) return { enabled: false, reason: \"\" };\n const row = result.rows[0] as any;\n return { enabled: !!row.enabled, reason: row.reason || \"\" };\n}\n\nexport async function setMaintenance(enabled: boolean, reason: string) {\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO maintenance (id, enabled, reason, updated_at) VALUES (1, ?, ?, datetime('now'))\",\n args: [enabled ? 1 : 0, reason],\n });\n}\n\n// ─── SUPPORT SERVER ─────────────────────────────────────────────\nexport async function getSupportServer(guildId: string) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM support_servers WHERE guild_id = ?\",\n args: [guildId],\n });\n return result.rows[0] || null;\n}\n\nexport async function setSupportServer(\n guildId: string,\n categoryId: string,\n infoChannelId: string,\n ticketChannelId: string,\n applyPanelChannelId: string,\n) {\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO support_servers \n (guild_id, category_id, info_channel_id, ticket_channel_id, apply_panel_channel_id) \n VALUES (?, ?, ?, ?, ?)`,\n args: [guildId, categoryId, infoChannelId, ticketChannelId, applyPanelChannelId],\n });\n}\n\nexport async function deleteSupportServer(guildId: string) {\n await sqlite.execute({\n sql: \"DELETE FROM support_servers WHERE guild_id = ?\",\n args: [guildId],\n });\n}\n","createdAt",["D",1776192158306],"branchVersion","branchId","73503406-3831-11f1-a548-42b51c65c3df","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",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_19":-5,"_109":110,"_111":31},"branch",{"_13":93,"_38":94,"_50":49,"_95":51,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":52,"_102":103},"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=1789549199&sig=1972e1b3d6c849142b69f454a173d3c7afa34f42e1f91dde8c3a5ee3ead0a730","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_50":51,"_38":52,"_45":227,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":-5,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":228,"_88":229,"_90":230,"_92":31},"tree",[179,181,185,186],"files",[179,180,181,182,183,184,185,186],"counts",{"_169":70,"_170":142,"_171":70,"_172":173,"_174":175},"contents",[135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_50":163,"_38":164,"_36":165,"_141":-5,"_48":49,"_47":166,"_143":66,"_45":167,"_13":70,"_40":161,"_42":-5,"_30":31,"_147":-5,"_33":168},{"_50":156,"_38":157,"_36":158,"_141":-5,"_48":49,"_47":159,"_143":66,"_45":160,"_13":70,"_40":161,"_42":-5,"_30":31,"_147":-5,"_33":162},{"_50":149,"_38":150,"_36":151,"_141":-5,"_48":49,"_47":152,"_143":31,"_45":153,"_13":70,"_40":26,"_42":154,"_30":31,"_147":-5,"_33":155},{"_50":139,"_38":140,"_36":64,"_141":-5,"_48":49,"_47":142,"_143":66,"_45":144,"_13":70,"_40":145,"_42":146,"_30":31,"_147":-5,"_33":148},"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",[140],"8074ac66-3831-11f1-81ab-42b51c65c3df","README.md","8074ad38-3831-11f1-81ab-42b51c65c3df",2,["D",1776192068461],"# discord-emoji-apply-bot",[150],"82842c7a-3831-11f1-980a-42b51c65c3df","discord","edf9ef2f-dca3-4f2c-9269-8df6b96b33e2",3,["D",1776192071914],"directory",[157],"96784f2c-3831-11f1-b0ca-42b51c65c3df","database","8037ee09-94a8-4c55-885e-f98c41a82cbb",5,["D",1776192105406],[164],"pulls","branches","forks","envVars",{"_176":70,"_178":70},"connections",{"_176":70,"_177":70},"count","unfilledCount","emptyCount",{"_50":163,"_38":164,"_36":165,"_141":-5,"_48":49,"_47":166,"_143":66,"_45":224,"_13":70,"_40":161,"_42":-5,"_30":31,"_147":-5,"_188":225,"_33":226},{"_50":220,"_38":39,"_36":37,"_141":165,"_48":49,"_47":14,"_143":66,"_45":221,"_13":142,"_40":41,"_42":44,"_30":31,"_147":-5,"_188":222,"_33":223},{"_50":156,"_38":157,"_36":158,"_141":-5,"_48":49,"_47":159,"_143":66,"_45":217,"_13":70,"_40":161,"_42":-5,"_30":31,"_147":-5,"_188":218,"_33":219},{"_50":209,"_38":210,"_36":211,"_141":158,"_48":49,"_47":212,"_143":31,"_45":213,"_13":70,"_40":41,"_42":214,"_30":31,"_147":-5,"_188":215,"_33":216},{"_50":201,"_38":202,"_36":203,"_141":158,"_48":49,"_47":204,"_143":31,"_45":205,"_13":70,"_40":41,"_42":206,"_30":31,"_147":-5,"_188":207,"_33":208},{"_50":194,"_38":195,"_36":196,"_141":158,"_48":49,"_47":159,"_143":66,"_45":197,"_13":70,"_40":41,"_42":198,"_30":31,"_147":-5,"_188":199,"_33":200},{"_50":149,"_38":150,"_36":151,"_141":-5,"_48":49,"_47":152,"_143":31,"_45":191,"_13":70,"_40":26,"_42":154,"_30":31,"_147":-5,"_188":192,"_33":193},{"_50":139,"_38":140,"_36":64,"_141":-5,"_48":49,"_47":142,"_143":66,"_45":187,"_13":70,"_40":145,"_42":146,"_30":31,"_147":-5,"_188":189,"_33":190},["D",1776192065301],"children",[],[140],["D",1776192068461],[],[150],"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",[],[157,195],"9b419b12-3831-11f1-b0ca-42b51c65c3df","handler.ts","9b419be4-3831-11f1-b0ca-42b51c65c3df",6,["D",1776192113439],"/**\n * Main interaction handler - routes to commands and buttons\n */\n\nimport { initDatabase } from \"../database/schema.ts\";\nimport { handleSlashCommand } from \"./commands.ts\";\nimport { handleButton } from \"./buttons.ts\";\n\n// Interaction types\nconst INTERACTION_TYPE = {\n PING: 1,\n APPLICATION_COMMAND: 2,\n MESSAGE_COMPONENT: 3,\n AUTOCOMPLETE: 4,\n MODAL_SUBMIT: 5,\n};\n\n// Response types \nconst RESPONSE_TYPE = {\n PONG: 1,\n CHANNEL_MESSAGE: 4,\n DEFERRED_CHANNEL_MESSAGE: 5,\n DEFERRED_UPDATE: 6,\n UPDATE_MESSAGE: 7,\n};\n\nexport async function handleInteraction(interaction: any): Promise {\n await initDatabase();\n\n try {\n switch (interaction.type) {\n case INTERACTION_TYPE.APPLICATION_COMMAND:\n return handleSlashCommand(interaction);\n\n case INTERACTION_TYPE.MESSAGE_COMPONENT:\n return handleButton(interaction);\n\n default:\n return Response.json({\n type: RESPONSE_TYPE.CHANNEL_MESSAGE,\n data: { content: \"❌ Unbekannter Interaction-Typ.\", flags: 64 },\n });\n }\n } catch (error) {\n console.error(\"Interaction handler error:\", error);\n return Response.json({\n type: RESPONSE_TYPE.CHANNEL_MESSAGE,\n data: { content: `❌ Fehler: ${error.message}`, flags: 64 },\n });\n }\n}\n",[],[157,202],"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",[],[157,210],["D",1776192071914],[182,183,184],[157],"b605ca0e-3831-11f1-8a8a-42b51c65c3df",["D",1776192158306],[],[164,39],["D",1776192105406],[180],[164],["D",1776192046430],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_19":-5,"_109":110,"_111":31},{"_13":93,"_38":94,"_50":49,"_95":51,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":52,"_102":103},"ctx",{"_86":-5,"_132":264,"_265":266,"_267":268,"_269":31,"_270":31,"_271":31,"_272":66,"_273":-5,"_274":-7,"_275":-7,"_276":70,"_277":31,"_278":31,"_279":-5,"_280":31,"_281":31,"_282":31,"_283":-5},"ENV",{"_235":236,"_237":238,"_239":94,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263},"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 · v7