[{"_1":2,"_391":-5,"_392":-5},"loaderData",{"_3":4,"_96":97,"_373":374},"root",{"_5":6,"_37":38,"_69":70},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":-5,"_32":33,"_34":22,"_35":22,"_36":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isBusinessOrgMember","isHigherTownieTier","ENV",{"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","efeea19332d9bfe7de1049656877be9cb817c45f","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_71":72},"__internal_clerk_state",{"_73":74,"_75":48,"_76":77,"_78":77,"_79":22,"_80":77,"_81":77,"_82":77,"_83":77,"_84":85,"_94":22,"_95":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_86":22,"_21":22,"_87":77,"_88":89,"_90":77,"_91":48,"_92":22,"_93":77},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_98":99,"_100":101,"_102":46,"_103":77,"_104":105,"_106":107,"_162":163,"_330":331,"_332":333,"_344":345,"_318":-5,"_367":-5,"_368":-5,"_369":22,"_370":22,"_371":372},"handle","CyberCore","name","discord-emoji-apply-bot","branchName","path","version",16,"project",{"_108":109,"_100":101,"_110":111,"_112":-5,"_113":22,"_114":115,"_116":117,"_118":-5,"_14":119,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":33,"_16":127,"_128":-5,"_129":-5,"_130":-5,"_131":-5,"_132":133,"_134":133,"_135":136,"_137":136,"_138":136,"_139":133,"_140":133,"_23":141,"_144":145,"_149":150,"_161":22},"id","734f95d2-3831-11f1-a548-42b51c65c3df","createdAt",["D",1776192046430],"deletedAt","legacyEnvVars","privacy","public","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","019d8d4b-5635-76cf-ac0c-e26664ce89f6","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_98":99,"_142":143},"profileImageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/87a0b6a2-3e42-41a1-3ec2-d561aa654100/square512","org",{"_98":99,"_146":143,"_14":-5,"_147":148},"avatar","tier","free","branch",{"_104":151,"_100":46,"_108":152,"_153":109,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":101,"_160":99},25,"73503406-3831-11f1-a548-42b51c65c3df","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[164,191,208,226,296,312,322],{"_108":165,"_100":166,"_167":168,"_169":-5,"_170":152,"_171":105,"_172":123,"_110":173,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_179":180,"_103":190},"e3c2124a-3831-11f1-b601-42b51c65c3df","commands","fileId","55dc5238-dd62-4333-8775-bd5aa8bd31b9","parentId","branchId","branchVersion","latest",["D",1776192235079],"fileType","directory","content","deleted","label","children",[181],{"_108":182,"_100":183,"_167":184,"_169":168,"_170":152,"_171":105,"_172":22,"_110":185,"_104":33,"_174":186,"_176":187,"_177":22,"_178":-5,"_179":188,"_103":189},"e3c1ed4c-3831-11f1-b601-42b51c65c3df","router.ts","e3c1edf6-3831-11f1-b601-42b51c65c3df",["D",1776192235079],"script","/**\n * Slash command router - dispatches to individual command handlers\n */\n\nimport { ephemeral } from \"../discord/handler.ts\";\nimport { handleEmojiAdd, handleEmojiRemove, handleEmojiEdit } from \"./emoji.ts\";\nimport { handleSetupCreate, handleSetupConfig } from \"./setup.ts\";\nimport {\n handleOwnerAdd,\n handleOwnerRemove,\n handleOwnerList,\n handleKeyAdd,\n handleKeyRemove,\n handleKeyList,\n handleMaintenance,\n handleRestart,\n handleSupportCreate,\n handleSupportDelete,\n} from \"./owner.ts\";\n\nexport function handleSlashCommand(interaction: any): Response | Promise {\n const commandName = interaction.data.name;\n\n switch (commandName) {\n // Emoji commands\n case \"emoji-add\":\n return handleEmojiAdd(interaction);\n case \"emoji-remove\":\n return handleEmojiRemove(interaction);\n case \"emoji-edit\":\n return handleEmojiEdit(interaction);\n\n // Setup commands\n case \"setup-create\":\n return handleSetupCreate(interaction);\n case \"setup-config\":\n return handleSetupConfig(interaction);\n\n // Owner commands\n case \"owner-add\":\n return handleOwnerAdd(interaction);\n case \"owner-remove\":\n return handleOwnerRemove(interaction);\n case \"owner-list\":\n return handleOwnerList(interaction);\n case \"key-add\":\n return handleKeyAdd(interaction);\n case \"key-remove\":\n return handleKeyRemove(interaction);\n case \"key-list\":\n return handleKeyList(interaction);\n case \"maintenance\":\n return handleMaintenance(interaction);\n case \"restart\":\n return handleRestart(interaction);\n case \"support-create\":\n return handleSupportCreate(interaction);\n case \"support-delete\":\n return handleSupportDelete(interaction);\n\n default:\n return ephemeral(`❓ Unbekannter Befehl: \\`/${commandName}\\``);\n }\n}\n",[],[166,183],[166],{"_108":192,"_100":193,"_167":194,"_169":-5,"_170":152,"_171":195,"_172":123,"_110":196,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_179":197,"_103":207},"d52acbb4-3831-11f1-9b40-42b51c65c3df","cron","88e963d7-5f46-4392-a402-aba78d75508b",13,["D",1776192210594],[198],{"_108":199,"_100":200,"_167":201,"_169":194,"_170":152,"_171":195,"_172":123,"_110":202,"_104":33,"_174":203,"_176":204,"_177":22,"_178":-5,"_179":205,"_103":206},"d52aa904-3831-11f1-9b40-42b51c65c3df","poll-reactions.ts","d52aa9d6-3831-11f1-9b40-42b51c65c3df",["D",1776192210594],"interval","/**\n * Cron job: Polls reactions on the apply message every minute.\n * When a new reaction from a user is detected, it creates an application\n * and sends a review request to the admin channel.\n * \n * Runs every 1 minute.\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDatabase, getEmojiRoles, getGuildConfig, createApplication, setApplicationAdminMessage, getPendingApplication } from \"../database/schema.ts\";\nimport { sendMessage } from \"../discord/api.ts\";\n\nconst DISCORD_API = \"https://discord.com/api/v10\";\n\nfunction getToken(): string {\n return Deno.env.get(\"DISCORD_BOT_TOKEN\") || \"\";\n}\n\nasync function getReactions(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}?limit=100`,\n {\n headers: { \"Authorization\": `Bot ${getToken()}` },\n },\n );\n if (!res.ok) {\n console.error(`getReactions error for ${emoji}:`, await res.text());\n return [];\n }\n return res.json();\n}\n\nasync function removeUserReaction(\n channelId: string,\n messageId: string,\n emoji: string,\n userId: string,\n): Promise {\n const encoded = encodeURIComponent(emoji);\n const res = await fetch(\n `${DISCORD_API}/channels/${channelId}/messages/${messageId}/reactions/${encoded}/${userId}`,\n {\n method: \"DELETE\",\n headers: { \"Authorization\": `Bot ${getToken()}` },\n },\n );\n if (!res.ok) {\n console.error(`removeUserReaction error:`, await res.text());\n }\n}\n\nexport default async function(interval: Interval) {\n if (!getToken()) {\n console.log(\"No DISCORD_BOT_TOKEN set, skipping.\");\n return;\n }\n\n await initDatabase();\n\n // Get all guild configs\n const configs = await sqlite.execute(\"SELECT * FROM guild_config WHERE apply_message_id IS NOT NULL\");\n\n for (const config of configs.rows) {\n const guildId = config.guild_id as string;\n const messageChannelId = config.message_channel_id as string;\n const applyMessageId = config.apply_message_id as string;\n const requestChannelId = config.request_channel_id as string;\n\n if (!applyMessageId) continue;\n\n const emojiRoles = await getEmojiRoles(guildId);\n\n for (const er of emojiRoles) {\n const emoji = er.emoji as string;\n const roleId = er.role_id as string;\n const roleName = er.role_name as string;\n const label = er.label as string;\n\n // Get reactions for this emoji\n const users = await getReactions(messageChannelId, applyMessageId, emoji);\n\n // Get bot's own user ID to filter out\n const botId = Deno.env.get(\"DISCORD_APPLICATION_ID\") || \"\";\n\n for (const user of users) {\n // Skip bots\n if (user.bot) continue;\n if (user.id === botId) continue;\n\n // Check if already has a pending application\n const existing = await getPendingApplication(guildId, user.id, emoji);\n if (existing) {\n // Remove the reaction so they can apply again later\n await removeUserReaction(messageChannelId, applyMessageId, emoji, user.id);\n continue;\n }\n\n // Check if already accepted for this role (prevent spam)\n const accepted = await sqlite.execute({\n sql: \"SELECT * FROM applications WHERE guild_id = ? AND user_id = ? AND emoji = ? AND status = 'accepted'\",\n args: [guildId, user.id, emoji],\n });\n if (accepted.rows.length > 0) {\n await removeUserReaction(messageChannelId, applyMessageId, emoji, user.id);\n continue;\n }\n\n // Create application\n const app = await createApplication(guildId, user.id, emoji, roleId);\n const appId = (app as any).id ?? (app as any)[\"last_insert_rowid()\"];\n\n // Send review message to admin channel\n try {\n const adminMsg = await sendMessage(requestChannelId, {\n embeds: [{\n title: \"📋 Neue Bewerbung\",\n color: 0xFEE75C,\n fields: [\n { name: \"👤 Bewerber\", value: `<@${user.id}>\\n(${user.username}#${user.discriminator || \"0\"})`, inline: true },\n { name: \"📛 Rolle\", value: `<@&${roleId}>\\n(${roleName})`, inline: true },\n { name: `${emoji} Emoji`, value: `${emoji} — ${label}`, inline: true },\n ],\n thumbnail: {\n url: user.avatar \n ? `https://cdn.discordapp.com/avatars/${user.id}/${user.avatar}.png?size=128` \n : `https://cdn.discordapp.com/embed/avatars/${parseInt(user.discriminator || \"0\") % 5}.png`,\n },\n footer: { text: `Bewerbungs-ID: ${appId}` },\n timestamp: new Date().toISOString(),\n }],\n components: [\n {\n type: 1,\n components: [\n {\n type: 2,\n style: 3, // green\n label: \"✅ Akzeptieren\",\n custom_id: `accept_${appId}`,\n },\n {\n type: 2,\n style: 4, // red\n label: \"❌ Ablehnen\",\n custom_id: `reject_${appId}`,\n },\n ],\n },\n ],\n });\n\n await setApplicationAdminMessage(appId, adminMsg.id);\n } catch (e) {\n console.error(\"Failed to send admin review message:\", e);\n }\n\n // Remove the user's reaction\n await removeUserReaction(messageChannelId, applyMessageId, emoji, user.id);\n\n console.log(`New application: User ${user.id} for role ${roleName} (${emoji})`);\n }\n }\n }\n}\n",[],[193,200],[193],{"_108":209,"_100":210,"_167":211,"_169":-5,"_170":152,"_171":212,"_172":123,"_110":213,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_179":214,"_103":225},"96784f2c-3831-11f1-b0ca-42b51c65c3df","database","8037ee09-94a8-4c55-885e-f98c41a82cbb",5,["D",1776192105406],[215],{"_108":216,"_100":217,"_167":218,"_169":211,"_170":152,"_171":219,"_172":123,"_110":220,"_104":221,"_174":186,"_176":222,"_177":22,"_178":-5,"_179":223,"_103":224},"b605ca0e-3831-11f1-8a8a-42b51c65c3df","schema.ts","967831b8-3831-11f1-b0ca-42b51c65c3df",7,["D",1776192158306],1,"/**\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",[],[210,217],[210],{"_108":227,"_100":228,"_167":229,"_169":-5,"_170":152,"_171":230,"_172":123,"_110":231,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_179":232,"_103":295},"82842c7a-3831-11f1-980a-42b51c65c3df","discord","edf9ef2f-dca3-4f2c-9269-8df6b96b33e2",3,["D",1776192071914],[233,242,251,260,269,278,287],{"_108":234,"_100":235,"_167":236,"_169":229,"_170":152,"_171":237,"_172":123,"_110":238,"_104":221,"_174":186,"_176":239,"_177":22,"_178":-5,"_179":240,"_103":241},"c183f9f0-3831-11f1-89d9-42b51c65c3df","api.ts","8b37ca20-3831-11f1-b0ca-42b51c65c3df",9,["D",1776192177615],"/**\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\nasync function discordFetch(url: string, options: RequestInit = {}): Promise {\n const res = await fetch(`${DISCORD_API}${url}`, {\n ...options,\n headers: { ...headers(), ...(options.headers as Record || {}) },\n });\n return res;\n}\n\nasync function discordJson(url: string, options: RequestInit = {}): Promise {\n const res = await discordFetch(url, options);\n if (!res.ok) {\n const err = await res.text();\n console.error(`Discord API error ${url}:`, err);\n throw new Error(`Discord API error: ${res.status} - ${err}`);\n }\n return res.json();\n}\n\n// ─── MESSAGES ───────────────────────────────────────────────────\nexport async function sendMessage(channelId: string, data: any): Promise {\n return discordJson(`/channels/${channelId}/messages`, {\n method: \"POST\",\n body: JSON.stringify(data),\n });\n}\n\nexport async function editMessage(channelId: string, messageId: string, data: any): Promise {\n return discordJson(`/channels/${channelId}/messages/${messageId}`, {\n method: \"PATCH\",\n body: JSON.stringify(data),\n });\n}\n\nexport async function deleteMessage(channelId: string, messageId: string): Promise {\n await discordFetch(`/channels/${channelId}/messages/${messageId}`, {\n method: \"DELETE\",\n });\n}\n\n// ─── ROLES ──────────────────────────────────────────────────────\nexport async function addRole(guildId: string, userId: string, roleId: string): Promise {\n const res = await discordFetch(`/guilds/${guildId}/members/${userId}/roles/${roleId}`, {\n method: \"PUT\",\n });\n if (!res.ok) {\n const err = await res.text();\n throw new Error(`addRole error: ${res.status} - ${err}`);\n }\n}\n\nexport async function removeRole(guildId: string, userId: string, roleId: string): Promise {\n const res = await discordFetch(`/guilds/${guildId}/members/${userId}/roles/${roleId}`, {\n method: \"DELETE\",\n });\n if (!res.ok) {\n const err = await res.text();\n throw new Error(`removeRole error: ${res.status} - ${err}`);\n }\n}\n\nexport async function getGuildRoles(guildId: string): Promise {\n return discordJson(`/guilds/${guildId}/roles`);\n}\n\n// ─── USERS ──────────────────────────────────────────────────────\nexport async function getUser(userId: string): Promise {\n return discordJson(`/users/${userId}`);\n}\n\nexport async function getGuildMember(guildId: string, userId: string): Promise {\n return discordJson(`/guilds/${guildId}/members/${userId}`);\n}\n\n// ─── REACTIONS ──────────────────────────────────────────────────\nexport async function addReaction(channelId: string, messageId: string, emoji: string): Promise {\n const encoded = encodeURIComponent(emoji);\n await discordFetch(\n `/channels/${channelId}/messages/${messageId}/reactions/${encoded}/@me`,\n { method: \"PUT\" },\n );\n}\n\nexport async function removeAllReactions(channelId: string, messageId: string): Promise {\n await discordFetch(\n `/channels/${channelId}/messages/${messageId}/reactions`,\n { method: \"DELETE\" },\n );\n}\n\n// ─── CHANNELS ───────────────────────────────────────────────────\nexport async function createChannel(guildId: string, data: {\n name: string;\n type: number; // 0=text, 2=voice, 4=category\n parent_id?: string;\n topic?: string;\n permission_overwrites?: any[];\n}): Promise {\n return discordJson(`/guilds/${guildId}/channels`, {\n method: \"POST\",\n body: JSON.stringify(data),\n });\n}\n\nexport async function deleteChannel(channelId: string): Promise {\n await discordFetch(`/channels/${channelId}`, { method: \"DELETE\" });\n}\n\nexport async function editChannel(channelId: string, data: any): Promise {\n return discordJson(`/channels/${channelId}`, {\n method: \"PATCH\",\n body: JSON.stringify(data),\n });\n}\n\n// ─── GUILD ROLES (create) ──────────────────────────────────────\nexport async function createRole(guildId: string, data: {\n name: string;\n color?: number;\n permissions?: string;\n}): Promise {\n return discordJson(`/guilds/${guildId}/roles`, {\n method: \"POST\",\n body: JSON.stringify(data),\n });\n}\n\n// ─── WEBHOOKS / FOLLOW-UP ──────────────────────────────────────\nexport async function followUpMessage(\n applicationId: string,\n interactionToken: string,\n data: any,\n): 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\nexport async function editOriginalResponse(\n applicationId: string,\n interactionToken: string,\n data: any,\n): Promise {\n return discordJson(`/webhooks/${applicationId}/${interactionToken}/messages/@original`, {\n method: \"PATCH\",\n body: JSON.stringify(data),\n });\n}\n",[],[228,235],{"_108":243,"_100":244,"_167":245,"_169":229,"_170":152,"_171":246,"_172":123,"_110":247,"_104":33,"_174":186,"_176":248,"_177":22,"_178":-5,"_179":249,"_103":250},"c3903bc8-3831-11f1-9b40-42b51c65c3df","buttons.ts","c3903cb8-3831-11f1-9b40-42b51c65c3df",10,["D",1776192181054],"/**\n * Button interaction handler\n * Handles accept/reject buttons from admin review channel\n */\n\nimport { addRole, sendMessage, editMessage, followUpMessage } from \"./api.ts\";\nimport {\n getApplicationById,\n updateApplicationStatus,\n getGuildConfig,\n getEmojiRole,\n} from \"../database/schema.ts\";\n\nexport async function handleButton(interaction: any): Promise {\n const { data, guild_id, member, message } = interaction;\n const customId = data.custom_id;\n\n // Format: accept_ or reject_\n const [action, appIdStr] = customId.split(\"_\");\n const appId = parseInt(appIdStr);\n\n if (![\"accept\", \"reject\"].includes(action) || isNaN(appId)) {\n return ephemeral(\"❌ Ungültige Interaktion.\");\n }\n\n // Permission check\n const permissions = BigInt(member?.permissions || \"0\");\n if (!(permissions & 0x20n)) {\n return ephemeral(\"❌ Du benötigst die **Server verwalten** Berechtigung.\");\n }\n\n const application = await getApplicationById(appId);\n if (!application) {\n return ephemeral(\"❌ Bewerbung nicht gefunden.\");\n }\n\n if (application.status !== \"pending\") {\n return ephemeral(`❌ Diese Bewerbung wurde bereits **${application.status === \"accepted\" ? \"akzeptiert\" : \"abgelehnt\"}**.`);\n }\n\n const config = await getGuildConfig(guild_id);\n if (!config) {\n return ephemeral(\"❌ Server-Konfiguration nicht gefunden.\");\n }\n\n const adminUser = member.user;\n const userId = application.user_id as string;\n const roleId = application.role_id as string;\n const emoji = application.emoji as string;\n\n if (action === \"accept\") {\n // Add role to user\n try {\n await addRole(guild_id, userId, roleId);\n } catch (e) {\n console.error(\"Failed to add role:\", e);\n return ephemeral(`❌ Konnte die Rolle nicht hinzufügen: ${e.message}`);\n }\n\n await updateApplicationStatus(appId, \"accepted\");\n\n // Update the admin message\n const updatedEmbed = {\n ...message.embeds[0],\n color: 0x57F287,\n fields: [\n ...message.embeds[0].fields,\n { name: \"✅ Status\", value: `Akzeptiert von <@${adminUser.id}>`, inline: false },\n ],\n };\n\n // Log\n try {\n await sendMessage(config.log_channel_id as string, {\n embeds: [{\n title: \"✅ Bewerbung akzeptiert\",\n color: 0x57F287,\n fields: [\n { name: \"Bewerber\", value: `<@${userId}>`, inline: true },\n { name: \"Rolle\", value: `<@&${roleId}>`, inline: true },\n { name: \"Emoji\", value: emoji, inline: true },\n { name: \"Akzeptiert von\", value: `<@${adminUser.id}>`, inline: true },\n ],\n timestamp: new Date().toISOString(),\n }],\n });\n } catch (e) {\n console.error(\"Log error:\", e);\n }\n\n // Respond by updating the message (type 7 = UPDATE_MESSAGE)\n return Response.json({\n type: 7,\n data: {\n embeds: [updatedEmbed],\n components: [\n {\n type: 1,\n components: [\n {\n type: 2,\n style: 3,\n label: `✅ Akzeptiert von ${adminUser.username}`,\n custom_id: `done_${appId}`,\n disabled: true,\n },\n ],\n },\n ],\n },\n });\n } else {\n // Reject\n await updateApplicationStatus(appId, \"rejected\");\n\n const updatedEmbed = {\n ...message.embeds[0],\n color: 0xED4245,\n fields: [\n ...message.embeds[0].fields,\n { name: \"❌ Status\", value: `Abgelehnt von <@${adminUser.id}>`, inline: false },\n ],\n };\n\n // Log\n try {\n await sendMessage(config.log_channel_id as string, {\n embeds: [{\n title: \"❌ Bewerbung abgelehnt\",\n color: 0xED4245,\n fields: [\n { name: \"Bewerber\", value: `<@${userId}>`, inline: true },\n { name: \"Rolle\", value: `<@&${roleId}>`, inline: true },\n { name: \"Emoji\", value: emoji, inline: true },\n { name: \"Abgelehnt von\", value: `<@${adminUser.id}>`, inline: true },\n ],\n timestamp: new Date().toISOString(),\n }],\n });\n } catch (e) {\n console.error(\"Log error:\", e);\n }\n\n return Response.json({\n type: 7,\n data: {\n embeds: [updatedEmbed],\n components: [\n {\n type: 1,\n components: [\n {\n type: 2,\n style: 4,\n label: `❌ Abgelehnt von ${adminUser.username}`,\n custom_id: `done_${appId}`,\n disabled: true,\n },\n ],\n },\n ],\n },\n });\n }\n}\n\nfunction ephemeral(content: string): Response {\n return Response.json({\n type: 4,\n data: { content, flags: 64 },\n });\n}\n",[],[228,244],{"_108":252,"_100":253,"_167":254,"_169":229,"_170":152,"_171":255,"_172":123,"_110":256,"_104":33,"_174":186,"_176":257,"_177":22,"_178":-5,"_179":258,"_103":259},"b6dabfb6-3831-11f1-a836-42b51c65c3df","commands.ts","b6dac06a-3831-11f1-a836-42b51c65c3df",8,["D",1776192159741],"/**\n * Slash command handlers:\n * /setup-create - Setup channels for this guild\n * /emoji-add - Add emoji → role mapping\n * /emoji-remove - Remove emoji → role mapping\n * /emoji-edit - Edit emoji → role mapping\n * /apply-send - Send/update the apply message\n */\n\nimport {\n getGuildConfig,\n setGuildConfig,\n addEmojiRole,\n removeEmojiRole,\n getEmojiRoles,\n getEmojiRole,\n setApplyMessageId,\n} from \"../database/schema.ts\";\nimport { sendMessage, editMessage, addReaction, removeReaction, followUpMessage } from \"./api.ts\";\n\nconst EPHEMERAL = 64;\n\nexport async function handleSlashCommand(interaction: any): Promise {\n const { data, guild_id, member } = interaction;\n const commandName = data.name;\n\n // Permission check: require MANAGE_GUILD (bit 5 = 0x20)\n const permissions = BigInt(member?.permissions || \"0\");\n if (!(permissions & 0x20n) && commandName !== \"ping\") {\n return ephemeral(\"❌ Du benötigst die **Server verwalten** Berechtigung.\");\n }\n\n switch (commandName) {\n case \"setup-create\":\n return handleSetupCreate(interaction);\n case \"emoji-add\":\n return handleEmojiAdd(interaction);\n case \"emoji-remove\":\n return handleEmojiRemove(interaction);\n case \"emoji-edit\":\n return handleEmojiEdit(interaction);\n case \"apply-send\":\n return handleApplySend(interaction);\n case \"ping\":\n return ephemeral(\"🏓 Pong! Bot läuft.\");\n default:\n return ephemeral(\"❌ Unbekannter Befehl.\");\n }\n}\n\n// ---------- /setup-create ----------\nasync function handleSetupCreate(interaction: any): Promise {\n const { guild_id, data } = interaction;\n const options = parseOptions(data.options);\n\n const messageChannel = options[\"nachricht-channel\"];\n const requestChannel = options[\"anfragen-channel\"];\n const logChannel = options[\"log-channel\"];\n const setupChannel = options[\"setup-channel\"];\n\n await setGuildConfig(guild_id, messageChannel, requestChannel, logChannel, setupChannel);\n\n // Send confirmation to setup channel\n try {\n await sendMessage(setupChannel, {\n embeds: [{\n title: \"⚙️ Emoji-Bewerbungssystem eingerichtet\",\n color: 0x5865F2,\n fields: [\n { name: \"📩 Bewerbungs-Nachricht\", value: `<#${messageChannel}>`, inline: true },\n { name: \"📋 Anfragen-Channel\", value: `<#${requestChannel}>`, inline: true },\n { name: \"📝 Log-Channel\", value: `<#${logChannel}>`, inline: true },\n { name: \"🔧 Setup-Channel\", value: `<#${setupChannel}>`, inline: true },\n ],\n footer: { text: \"Nutze /emoji-add um Emoji-Rollen hinzuzufügen\" },\n timestamp: new Date().toISOString(),\n }],\n });\n } catch (e) {\n console.error(\"Could not send setup message:\", e);\n }\n\n return ephemeral(\n \"✅ **Setup abgeschlossen!**\\n\\n\" +\n `📩 Bewerbungs-Nachricht: <#${messageChannel}>\\n` +\n `📋 Anfragen: <#${requestChannel}>\\n` +\n `📝 Logs: <#${logChannel}>\\n` +\n `🔧 Setup: <#${setupChannel}>\\n\\n` +\n \"Nutze jetzt `/emoji-add` um Emoji → Rollen-Zuordnungen hinzuzufügen.\"\n );\n}\n\n// ---------- /emoji-add ----------\nasync function handleEmojiAdd(interaction: any): Promise {\n const { guild_id, data, token } = interaction;\n const appId = Deno.env.get(\"DISCORD_APPLICATION_ID\") || \"\";\n\n const config = await getGuildConfig(guild_id);\n if (!config) {\n return ephemeral(\"❌ Bitte zuerst `/setup-create` ausführen!\");\n }\n\n const options = parseOptions(data.options);\n const emoji = options[\"emoji\"];\n const roleId = options[\"rolle\"];\n const label = options[\"label\"] || emoji;\n const description = options[\"beschreibung\"] || \"\";\n\n // Check if emoji already exists\n const existing = await getEmojiRole(guild_id, emoji);\n if (existing) {\n return ephemeral(`❌ Das Emoji **${emoji}** ist bereits mit der Rolle <@&${existing.role_id}> verknüpft. Nutze \\`/emoji-edit\\` zum Bearbeiten.`);\n }\n\n // Get role name from resolved data\n const roleName = data.resolved?.roles?.[roleId]?.name || \"Unbekannte Rolle\";\n\n await addEmojiRole(guild_id, emoji, roleId, roleName, label, description, config);\n\n // Log the addition\n try {\n await sendMessage(config.log_channel_id as string, {\n embeds: [{\n title: \"➕ Emoji-Rolle hinzugefügt\",\n color: 0x57F287,\n fields: [\n { name: \"Emoji\", value: emoji, inline: true },\n { name: \"Rolle\", value: `<@&${roleId}>`, inline: true },\n { name: \"Label\", value: label, inline: true },\n { name: \"Beschreibung\", value: description || \"Keine\", inline: false },\n { name: \"Hinzugefügt von\", value: `<@${interaction.member.user.id}>`, inline: true },\n ],\n timestamp: new Date().toISOString(),\n }],\n });\n } catch (e) {\n console.error(\"Log error:\", e);\n }\n\n // Respond immediately, then update the apply message in background\n const response = ephemeral(\n `✅ **Emoji-Rolle hinzugefügt!**\\n\\n` +\n `${emoji} → <@&${roleId}> (${label})\\n` +\n `${description ? `Beschreibung: ${description}\\n` : \"\"}` +\n `\\nNutze \\`/apply-send\\` um die Bewerbungs-Nachricht zu aktualisieren.`\n );\n\n return response;\n}\n\n// ---------- /emoji-remove ----------\nasync function handleEmojiRemove(interaction: any): Promise {\n const { guild_id, data } = interaction;\n\n const config = await getGuildConfig(guild_id);\n if (!config) return ephemeral(\"❌ Bitte zuerst `/setup-create` ausführen!\");\n\n const options = parseOptions(data.options);\n const emoji = options[\"emoji\"];\n\n const existing = await getEmojiRole(guild_id, emoji);\n if (!existing) {\n return ephemeral(`❌ Das Emoji **${emoji}** ist nicht konfiguriert.`);\n }\n\n await removeEmojiRole(guild_id, emoji);\n\n // Log\n try {\n await sendMessage(config.log_channel_id as string, {\n embeds: [{\n title: \"➖ Emoji-Rolle entfernt\",\n color: 0xED4245,\n fields: [\n { name: \"Emoji\", value: emoji, inline: true },\n { name: \"Rolle\", value: `<@&${existing.role_id}>`, inline: true },\n { name: \"Entfernt von\", value: `<@${interaction.member.user.id}>`, inline: true },\n ],\n timestamp: new Date().toISOString(),\n }],\n });\n } catch (e) {\n console.error(\"Log error:\", e);\n }\n\n return ephemeral(\n `✅ **Emoji-Rolle entfernt!**\\n\\n` +\n `${emoji} → <@&${existing.role_id}> wurde gelöscht.\\n` +\n `Nutze \\`/apply-send\\` um die Bewerbungs-Nachricht zu aktualisieren.`\n );\n}\n\n// ---------- /emoji-edit ----------\nasync function handleEmojiEdit(interaction: any): Promise {\n const { guild_id, data } = interaction;\n\n const config = await getGuildConfig(guild_id);\n if (!config) return ephemeral(\"❌ Bitte zuerst `/setup-create` ausführen!\");\n\n const options = parseOptions(data.options);\n const emoji = options[\"emoji\"];\n\n const existing = await getEmojiRole(guild_id, emoji);\n if (!existing) {\n return ephemeral(`❌ Das Emoji **${emoji}** ist nicht konfiguriert. Nutze \\`/emoji-add\\`.`);\n }\n\n const roleId = options[\"rolle\"] || existing.role_id;\n const label = options[\"label\"] || existing.label;\n const description = options[\"beschreibung\"] !== undefined ? options[\"beschreibung\"] : existing.description;\n const roleName = data.resolved?.roles?.[roleId]?.name || existing.role_name;\n\n await addEmojiRole(guild_id, emoji, roleId as string, roleName, label, description, config);\n\n // Log\n try {\n await sendMessage(config.log_channel_id as string, {\n embeds: [{\n title: \"✏️ Emoji-Rolle bearbeitet\",\n color: 0xFEE75C,\n fields: [\n { name: \"Emoji\", value: emoji, inline: true },\n { name: \"Rolle\", value: `<@&${roleId}>`, inline: true },\n { name: \"Label\", value: label, inline: true },\n { name: \"Beschreibung\", value: description || \"Keine\", inline: false },\n { name: \"Bearbeitet von\", value: `<@${interaction.member.user.id}>`, inline: true },\n ],\n timestamp: new Date().toISOString(),\n }],\n });\n } catch (e) {\n console.error(\"Log error:\", e);\n }\n\n return ephemeral(\n `✅ **Emoji-Rolle bearbeitet!**\\n\\n` +\n `${emoji} → <@&${roleId}> (${label})\\n` +\n `Nutze \\`/apply-send\\` um die Bewerbungs-Nachricht zu aktualisieren.`\n );\n}\n\n// ---------- /apply-send ----------\nasync function handleApplySend(interaction: any): Promise {\n const { guild_id } = interaction;\n const appId = Deno.env.get(\"DISCORD_APPLICATION_ID\") || \"\";\n\n const config = await getGuildConfig(guild_id);\n if (!config) return ephemeral(\"❌ Bitte zuerst `/setup-create` ausführen!\");\n\n const emojiRoles = await getEmojiRoles(guild_id);\n if (emojiRoles.length === 0) {\n return ephemeral(\"❌ Keine Emoji-Rollen konfiguriert. Nutze `/emoji-add` zuerst.\");\n }\n\n // Build the embed\n const roleList = emojiRoles.map((er: any) => \n `${er.emoji} — **${er.label}** → <@&${er.role_id}>${er.description ? `\\n┗ _${er.description}_` : \"\"}`\n ).join(\"\\n\\n\");\n\n const embed = {\n title: \"📋 Bewerbungen — Reagiere mit einem Emoji!\",\n description:\n \"Reagiere auf diese Nachricht mit dem entsprechenden Emoji, um dich für eine Rolle zu bewerben.\\n\" +\n \"Ein Admin wird deine Bewerbung prüfen.\\n\\n\" +\n \"**Verfügbare Rollen:**\\n\\n\" +\n roleList,\n color: 0x5865F2,\n footer: { text: \"Emoji-Bewerbungssystem • Reagiere zum Bewerben\" },\n timestamp: new Date().toISOString(),\n };\n\n // Send as deferred, then follow up\n // Actually, we respond immediately and do the API call\n const messageChannelId = config.message_channel_id as string;\n\n // Check if we should edit or send new\n if (config.apply_message_id) {\n try {\n await editMessage(messageChannelId, config.apply_message_id as string, { embeds: [embed] });\n\n return ephemeral(\"✅ Bewerbungs-Nachricht wurde **aktualisiert**!\");\n } catch (e) {\n console.error(\"Edit failed, sending new:\", e);\n }\n }\n\n // Send new message\n const msg = await sendMessage(messageChannelId, { embeds: [embed] });\n await setApplyMessageId(guild_id, msg.id);\n\n // Add all emoji reactions to the message\n for (const er of emojiRoles) {\n try {\n await addReaction(messageChannelId, msg.id, er.emoji as string);\n } catch (e) {\n console.error(`Failed to add reaction ${er.emoji}:`, e);\n }\n }\n\n return ephemeral(\"✅ Bewerbungs-Nachricht wurde **gesendet**! Reaktionen wurden hinzugefügt.\");\n}\n\n// ---------- Helpers ----------\nfunction ephemeral(content: string): Response {\n return Response.json({\n type: 4,\n data: { content, flags: EPHEMERAL },\n });\n}\n\nfunction parseOptions(options: any[]): Record {\n const result: Record = {};\n if (!options) return result;\n for (const opt of options) {\n result[opt.name] = opt.value;\n }\n return result;\n}\n",[],[228,253],{"_108":261,"_100":262,"_167":263,"_169":229,"_170":152,"_171":264,"_172":123,"_110":265,"_104":33,"_174":186,"_176":266,"_177":22,"_178":-5,"_179":267,"_103":268},"d29f41fe-3831-11f1-84db-42b51c65c3df","embeds.ts","d29f42a8-3831-11f1-84db-42b51c65c3df",12,["D",1776192206333],"/**\n * Reusable embed builders for consistent bot UI\n */\n\n// Colors\nexport const COLORS = {\n PRIMARY: 0x5865F2, // Discord Blurple\n SUCCESS: 0x57F287, // Green\n DANGER: 0xED4245, // Red\n WARNING: 0xFEE75C, // Yellow\n INFO: 0x5865F2, // Blue\n MAINT: 0xEB459E, // Fuchsia\n LOG: 0x99AAB5, // Gray\n};\n\nexport function successEmbed(title: string, description: string) {\n return {\n title: `✅ ${title}`,\n description,\n color: COLORS.SUCCESS,\n timestamp: new Date().toISOString(),\n };\n}\n\nexport function errorEmbed(title: string, description: string) {\n return {\n title: `❌ ${title}`,\n description,\n color: COLORS.DANGER,\n timestamp: new Date().toISOString(),\n };\n}\n\nexport function infoEmbed(title: string, description: string) {\n return {\n title: `ℹ️ ${title}`,\n description,\n color: COLORS.INFO,\n timestamp: new Date().toISOString(),\n };\n}\n\nexport function warningEmbed(title: string, description: string) {\n return {\n title: `⚠️ ${title}`,\n description,\n color: COLORS.WARNING,\n timestamp: new Date().toISOString(),\n };\n}\n\nexport function logEmbed(title: string, description: string, fields?: { name: string; value: string; inline?: boolean }[]) {\n return {\n title: `📋 ${title}`,\n description,\n color: COLORS.LOG,\n fields: fields || [],\n timestamp: new Date().toISOString(),\n };\n}\n\nexport function applicationEmbed(\n userId: string,\n emoji: string,\n roleName: string,\n roleId: string,\n applicationId: number,\n) {\n return {\n title: \"📬 Neue Bewerbung\",\n description: `**Bewerber:** <@${userId}>\\n**Emoji:** ${emoji}\\n**Rolle:** <@&${roleId}> (${roleName})`,\n color: COLORS.PRIMARY,\n fields: [\n { name: \"Bewerbungs-ID\", value: `#${applicationId}`, inline: true },\n { name: \"Status\", value: \"⏳ Ausstehend\", inline: true },\n ],\n timestamp: new Date().toISOString(),\n footer: { text: `User ID: ${userId}` },\n };\n}\n\nexport function applyPanelEmbed(\n emojiRoles: { emoji: string; role_name: string; description: string }[],\n) {\n const lines = emojiRoles.map(\n (er) => `${er.emoji} → **${er.role_name}**${er.description ? ` — ${er.description}` : \"\"}`,\n );\n return {\n title: \"📋 Bewerbungs-Panel\",\n description:\n \"Reagiere mit einem Emoji um dich für die entsprechende Rolle zu bewerben!\\n\\n\" +\n (lines.length > 0 ? lines.join(\"\\n\") : \"*Noch keine Emoji-Rollen konfiguriert.*\"),\n color: COLORS.PRIMARY,\n footer: { text: \"Deine Bewerbung wird von einem Admin geprüft.\" },\n };\n}\n\nexport function maintenanceEmbed(enabled: boolean, reason: string) {\n if (enabled) {\n return {\n title: \"🔧 Wartungsmodus AKTIV\",\n description: reason || \"Der Bot ist vorübergehend deaktiviert.\",\n color: COLORS.MAINT,\n timestamp: new Date().toISOString(),\n };\n }\n return {\n title: \"✅ Wartungsmodus DEAKTIVIERT\",\n description: \"Der Bot ist wieder für alle Nutzer verfügbar.\",\n color: COLORS.SUCCESS,\n timestamp: new Date().toISOString(),\n };\n}\n",[],[228,262],{"_108":270,"_100":271,"_167":272,"_169":229,"_170":152,"_171":273,"_172":123,"_110":274,"_104":221,"_174":186,"_176":275,"_177":22,"_178":-5,"_179":276,"_103":277},"de64e85e-3831-11f1-aa22-42b51c65c3df","handler.ts","9b419be4-3831-11f1-b0ca-42b51c65c3df",14,["D",1776192226078],"/**\n * Main interaction router — dispatches slash commands, buttons, etc.\n */\n\nimport { initDatabase } from \"../database/schema.ts\";\nimport { checkMaintenance } from \"./permissions.ts\";\nimport { errorEmbed } from \"./embeds.ts\";\nimport { handleSlashCommand } from \"../commands/router.ts\";\nimport { handleButton } from \"../handlers/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\nexport const RESPONSE = {\n PONG: 1,\n CHANNEL_MESSAGE: 4,\n DEFERRED_CHANNEL_MESSAGE: 5,\n DEFERRED_UPDATE: 6,\n UPDATE_MESSAGE: 7,\n};\n\nexport function ephemeral(content: string, embeds?: any[]) {\n return Response.json({\n type: RESPONSE.CHANNEL_MESSAGE,\n data: { content, embeds, flags: 64 },\n });\n}\n\nexport function reply(content: string, embeds?: any[], components?: any[]) {\n return Response.json({\n type: RESPONSE.CHANNEL_MESSAGE,\n data: { content, embeds, components },\n });\n}\n\nexport function deferReply(ephemeralFlag = true) {\n return Response.json({\n type: RESPONSE.DEFERRED_CHANNEL_MESSAGE,\n data: ephemeralFlag ? { flags: 64 } : {},\n });\n}\n\nexport function updateMessage(data: any) {\n return Response.json({\n type: RESPONSE.UPDATE_MESSAGE,\n data,\n });\n}\n\nexport async function handleInteraction(interaction: any): Promise {\n // Init DB on every request (idempotent)\n await initDatabase();\n\n const userId = interaction.member?.user?.id || interaction.user?.id;\n\n // Maintenance check (owners bypass)\n if (interaction.type === INTERACTION_TYPE.APPLICATION_COMMAND\n || interaction.type === INTERACTION_TYPE.MESSAGE_COMPONENT) {\n const maintMsg = await checkMaintenance(userId);\n if (maintMsg) {\n return ephemeral(maintMsg);\n }\n }\n\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 ephemeral(\"❓ Unbekannte Interaktion.\");\n }\n}\n",[],[228,271],{"_108":279,"_100":280,"_167":281,"_169":229,"_170":152,"_171":282,"_172":123,"_110":283,"_104":33,"_174":186,"_176":284,"_177":22,"_178":-5,"_179":285,"_103":286},"c94be3a0-3831-11f1-84db-42b51c65c3df","permissions.ts","c94be472-3831-11f1-84db-42b51c65c3df",11,["D",1776192190656],"/**\n * Permission checks: Owner, Key-User, Admin, Maintenance\n */\n\nimport { isOwner, isKeyUser, isMaintenanceEnabled } from \"../database/schema.ts\";\n\n/** Discord permission bit for ADMINISTRATOR */\nconst ADMIN_FLAG = 0x8n;\n\nexport type PermLevel = \"owner\" | \"key\" | \"admin\" | \"member\";\n\nexport function getMemberPermissions(interaction: any): bigint {\n const perms = interaction.member?.permissions;\n if (!perms) return 0n;\n return BigInt(perms);\n}\n\nexport function isDiscordAdmin(interaction: any): boolean {\n return (getMemberPermissions(interaction) & ADMIN_FLAG) === ADMIN_FLAG;\n}\n\n/**\n * Check if user can use the bot at all (maintenance check).\n * Owners always bypass maintenance.\n */\nexport async function checkMaintenance(userId: string): Promise {\n const ownerStatus = await isOwner(userId);\n if (ownerStatus) return null; // Owners bypass maintenance\n\n const maint = await isMaintenanceEnabled();\n if (maint.enabled) {\n return `🔧 **Wartungsmodus aktiv**\\n${maint.reason ? `Grund: ${maint.reason}` : \"Der Bot ist vorübergehend deaktiviert.\"}`;\n }\n return null;\n}\n\n/**\n * Require Owner permission. Returns error message or null if ok.\n */\nexport async function requireOwner(userId: string): Promise {\n if (await isOwner(userId)) return null;\n return \"🚫 **Zugriff verweigert** — Nur Bot-Owner können diesen Befehl verwenden.\";\n}\n\n/**\n * Require Key-User or Owner. Returns error message or null if ok.\n */\nexport async function requireKeyUser(userId: string): Promise {\n if (await isKeyUser(userId)) return null;\n return \"🚫 **Zugriff verweigert** — Nur Key-User und Owner können diesen Befehl verwenden.\";\n}\n\n/**\n * Require Discord Admin OR Key-User/Owner on this server.\n */\nexport async function requireAdminOrKey(userId: string, interaction: any): Promise {\n if (await isKeyUser(userId)) return null;\n if (isDiscordAdmin(interaction)) return null;\n return \"🚫 **Zugriff verweigert** — Du brauchst Administrator-Rechte oder Key-User Status.\";\n}\n",[],[228,280],{"_108":288,"_100":289,"_167":290,"_169":229,"_170":152,"_171":230,"_172":123,"_110":291,"_104":33,"_174":186,"_176":292,"_177":22,"_178":-5,"_179":293,"_103":294},"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",[],[228,289],[228],{"_108":297,"_100":298,"_167":299,"_169":-5,"_170":152,"_171":300,"_172":123,"_110":301,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_179":302,"_103":311},"e0be6378-3831-11f1-adf3-42b51c65c3df","scripts","d534483a-3816-4d71-99e6-5b5e0ff24e99",15,["D",1776192230018],[303],{"_108":304,"_100":305,"_167":306,"_169":299,"_170":152,"_171":300,"_172":22,"_110":307,"_104":33,"_174":186,"_176":308,"_177":22,"_178":-5,"_179":309,"_103":310},"e0be2be2-3831-11f1-adf3-42b51c65c3df","register-commands.ts","e0be2c96-3831-11f1-adf3-42b51c65c3df",["D",1776192230018],"/**\n * Run this script ONCE to register all slash commands with Discord.\n * \n * Before running, set these env vars:\n * - DISCORD_BOT_TOKEN\n * - DISCORD_APPLICATION_ID\n */\n\nconst DISCORD_API = \"https://discord.com/api/v10\";\nconst APP_ID = Deno.env.get(\"DISCORD_APPLICATION_ID\");\nconst TOKEN = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n\nif (!APP_ID || !TOKEN) {\n console.error(\"Missing DISCORD_APPLICATION_ID or DISCORD_BOT_TOKEN env vars!\");\n Deno.exit(1);\n}\n\n// Command option types\nconst STRING = 3;\nconst ROLE = 8;\nconst CHANNEL = 7;\n\nconst commands = [\n {\n name: \"ping\",\n description: \"Prüfe ob der Bot läuft\",\n },\n {\n name: \"setup-create\",\n description: \"Richte das Emoji-Bewerbungssystem für diesen Server ein\",\n default_member_permissions: \"32\", // MANAGE_GUILD\n options: [\n {\n name: \"nachricht-channel\",\n description: \"Channel für die Bewerbungs-Nachricht (wo User reagieren)\",\n type: CHANNEL,\n required: true,\n channel_types: [0], // GUILD_TEXT only\n },\n {\n name: \"anfragen-channel\",\n description: \"Channel wo Admin-Anfragen erscheinen\",\n type: CHANNEL,\n required: true,\n channel_types: [0],\n },\n {\n name: \"log-channel\",\n description: \"Channel für Logs (alle Aktionen)\",\n type: CHANNEL,\n required: true,\n channel_types: [0],\n },\n {\n name: \"setup-channel\",\n description: \"Channel für Setup-Einstellungen\",\n type: CHANNEL,\n required: true,\n channel_types: [0],\n },\n ],\n },\n {\n name: \"emoji-add\",\n description: \"Füge eine Emoji → Rollen-Zuordnung hinzu\",\n default_member_permissions: \"32\",\n options: [\n {\n name: \"emoji\",\n description: \"Das Emoji (z.B. 🎮 oder ein Custom-Emoji)\",\n type: STRING,\n required: true,\n },\n {\n name: \"rolle\",\n description: \"Die Rolle, die vergeben werden soll\",\n type: ROLE,\n required: true,\n },\n {\n name: \"label\",\n description: \"Anzeigename (z.B. 'Content Creator')\",\n type: STRING,\n required: false,\n },\n {\n name: \"beschreibung\",\n description: \"Kurze Beschreibung der Rolle\",\n type: STRING,\n required: false,\n },\n ],\n },\n {\n name: \"emoji-remove\",\n description: \"Entferne eine Emoji → Rollen-Zuordnung\",\n default_member_permissions: \"32\",\n options: [\n {\n name: \"emoji\",\n description: \"Das Emoji das entfernt werden soll\",\n type: STRING,\n required: true,\n },\n ],\n },\n {\n name: \"emoji-edit\",\n description: \"Bearbeite eine bestehende Emoji → Rollen-Zuordnung\",\n default_member_permissions: \"32\",\n options: [\n {\n name: \"emoji\",\n description: \"Das Emoji das bearbeitet werden soll\",\n type: STRING,\n required: true,\n },\n {\n name: \"rolle\",\n description: \"Neue Rolle (optional)\",\n type: ROLE,\n required: false,\n },\n {\n name: \"label\",\n description: \"Neuer Anzeigename (optional)\",\n type: STRING,\n required: false,\n },\n {\n name: \"beschreibung\",\n description: \"Neue Beschreibung (optional)\",\n type: STRING,\n required: false,\n },\n ],\n },\n {\n name: \"apply-send\",\n description: \"Sende oder aktualisiere die Bewerbungs-Nachricht\",\n default_member_permissions: \"32\",\n },\n];\n\n// Register commands globally\nconst url = `${DISCORD_API}/applications/${APP_ID}/commands`;\n\nconsole.log(\"Registriere Slash Commands...\");\n\nconst res = await fetch(url, {\n method: \"PUT\",\n headers: {\n \"Authorization\": `Bot ${TOKEN}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(commands),\n});\n\nif (res.ok) {\n const data = await res.json();\n console.log(`✅ ${data.length} Commands erfolgreich registriert:`);\n for (const cmd of data) {\n console.log(` /${cmd.name} (ID: ${cmd.id})`);\n }\n} else {\n const error = await res.text();\n console.error(`❌ Fehler beim Registrieren: ${res.status}`);\n console.error(error);\n}\n",[],[298,305],[298],{"_108":313,"_100":314,"_167":315,"_169":-5,"_170":152,"_171":316,"_172":22,"_110":317,"_104":33,"_174":318,"_176":319,"_177":22,"_178":-5,"_179":320,"_103":321},"8074ac66-3831-11f1-81ab-42b51c65c3df","README.md","8074ad38-3831-11f1-81ab-42b51c65c3df",2,["D",1776192068461],"file","# discord-emoji-apply-bot",[],[314],{"_108":323,"_100":324,"_167":121,"_169":-5,"_170":152,"_171":221,"_172":123,"_110":325,"_104":33,"_174":326,"_176":327,"_177":22,"_178":-5,"_179":328,"_103":329},"7e9097b6-3831-11f1-980a-42b51c65c3df","main.ts",["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",[],[324],"files",[164,181,191,198,208,215,226,233,242,251,260,269,278,287,296,303,312,322],"counts",{"_334":33,"_335":221,"_336":33,"_337":338,"_341":342},"pulls","branches","forks","envVars",{"_339":33,"_340":33},"count","emptyCount","connections",{"_339":33,"_343":33},"unfilledCount","contents",[346,349,352,355,358,361,364],{"_108":165,"_100":166,"_167":168,"_169":-5,"_170":152,"_171":105,"_172":123,"_110":347,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_103":348},["D",1776192235079],[166],{"_108":192,"_100":193,"_167":194,"_169":-5,"_170":152,"_171":195,"_172":123,"_110":350,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_103":351},["D",1776192210594],[193],{"_108":209,"_100":210,"_167":211,"_169":-5,"_170":152,"_171":212,"_172":123,"_110":353,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_103":354},["D",1776192105406],[210],{"_108":227,"_100":228,"_167":229,"_169":-5,"_170":152,"_171":230,"_172":123,"_110":356,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_103":357},["D",1776192071914],[228],{"_108":297,"_100":298,"_167":299,"_169":-5,"_170":152,"_171":300,"_172":123,"_110":359,"_104":33,"_174":175,"_176":-5,"_177":22,"_178":-5,"_103":360},["D",1776192230018],[298],{"_108":313,"_100":314,"_167":315,"_169":-5,"_170":152,"_171":316,"_172":22,"_110":362,"_104":33,"_174":318,"_176":319,"_177":22,"_178":-5,"_103":363},["D",1776192068461],[314],{"_108":323,"_100":324,"_167":121,"_169":-5,"_170":152,"_171":221,"_172":123,"_110":365,"_104":33,"_174":326,"_176":327,"_177":22,"_178":-5,"_103":366},["D",1776192065301],[324],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_106":375,"_104":105,"_380":381},{"_108":109,"_100":101,"_110":376,"_112":-5,"_113":22,"_114":115,"_116":117,"_118":-5,"_14":119,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":33,"_16":127,"_128":-5,"_129":-5,"_130":-5,"_131":-5,"_132":133,"_134":133,"_135":136,"_137":136,"_138":136,"_139":133,"_140":133,"_23":377,"_144":378,"_149":379,"_161":22},["D",1776192046430],{"_98":99,"_142":143},{"_98":99,"_146":143,"_14":-5,"_147":148},{"_104":151,"_100":46,"_108":152,"_153":109,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":101,"_160":99},"changes",[382,387],{"_318":383,"_385":-7,"_177":22,"_103":166,"_386":166},{"_167":168,"_100":166,"_174":175,"_176":-5,"_110":384,"_171":105,"_170":152},["D",1776192235079],"previous","latestPath",{"_318":388,"_385":-7,"_177":22,"_103":390,"_386":390},{"_167":184,"_100":183,"_174":186,"_176":187,"_110":389,"_171":105,"_170":152},["D",1776192235079],"commands/router.ts","actionData","errors"]