[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_375":376,"_377":378},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_39":-7,"_128":-5,"_19":129,"_130":131,"_132":133,"_134":135,"_136":137,"_21":138,"_139":-5,"_140":-5,"_141":30,"_142":143,"_144":24,"_145":-5,"_146":-5,"_147":148},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":30,"_31":-5},"handle","CyberCore","name","discord-emoji-apply-bot","branchName","main","path","cron","project",{"_33":76,"_13":14,"_37":77,"_78":-5,"_79":30,"_80":81,"_82":81,"_83":84,"_85":-5,"_31":69,"_86":87,"_88":24,"_89":-5,"_90":-5,"_91":26,"_41":92,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":98,"_99":98,"_100":101,"_102":101,"_103":101,"_104":98,"_105":98,"_53":106,"_107":108,"_109":110,"_111":30},"file",{"_63":73,"_13":18,"_66":74,"_68":30,"_75":-5},"isDirectory",true,"page",0,"history",[32],"hasNext",false,"userId",{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":54,"_21":55,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":61},"id","d52def24-3831-11f1-9b40-42b51c65c3df","branchId","73503406-3831-11f1-a548-42b51c65c3df","createdAt",["D",1776192210594],"version",13,"orgId","019d8d4a-de22-740e-8624-c25b4105e246","parentId","d2a0fb98-3831-11f1-84db-42b51c65c3df","incomingCommitId","aiChatMessageId","9823b296-72ca-45be-a955-308c58b319c3","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_33":69,"_41":42,"_11":70,"_71":72},{"_63":64,"_13":65,"_66":67,"_68":30},"pull","merge","revert","multiple","commits",[62],{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":54,"_21":55,"_56":-5,"_57":-5,"_58":-5},"fileId","d52aa9d6-3831-11f1-9b40-42b51c65c3df","poll-reactions.ts","fileType","interval","deleted","40d60734-a91c-4cc2-9305-b592a890bee5","luca0202marcel","avatar","","88e963d7-5f46-4392-a402-aba78d75508b","directory","deletedAtVersion","734f95d2-3831-11f1-a548-42b51c65c3df",["D",1776192046430],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Discord Bot: Emoji-Bewerbungssystem mit Admin-Panel","imageUrl","pinnedFileId","7e90986a-3831-11f1-980a-42b51c65c3df","pinPreview","pinMigrated","screenshotVersion","likeCount","019d8d4b-5635-76cf-ac0c-e26664ce89f6","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_127":123},"org",{"_11":12,"_121":122,"_71":123,"_31":-5,"_124":125,"_126":30},"branch",{"_39":112,"_13":16,"_33":36,"_113":76,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":14,"_120":12},"isOwned",25,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","CyberCore ","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/87a0b6a2-3e42-41a1-3ec2-d561aa654100/square512?exp=1789577999&sig=357a387f842b473da7ea5025b079c0bdb311777ece8ad80f4280a192a71e65f8","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":76,"_13":14,"_37":371,"_78":-5,"_79":30,"_80":81,"_82":81,"_83":84,"_85":-5,"_31":69,"_86":87,"_88":24,"_89":-5,"_90":-5,"_91":26,"_41":92,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":98,"_99":98,"_100":101,"_102":101,"_103":101,"_104":98,"_105":98,"_53":372,"_107":373,"_109":374,"_111":30},"tree",[172,178,180,182,190,192,194,195],"files",[172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195],"counts",{"_161":26,"_162":163,"_164":26,"_165":166,"_167":168},"contents",[155],{"_33":149,"_35":36,"_63":73,"_13":18,"_150":-5,"_66":74,"_39":26,"_43":-5,"_37":151,"_152":40,"_153":-5,"_17":154},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"d52acbb4-3831-11f1-9b40-42b51c65c3df","content",["D",1776192210594],"branchVersion","label",[18],{"_33":156,"_13":65,"_63":64,"_43":73,"_35":36,"_152":40,"_157":24,"_37":158,"_39":26,"_66":67,"_150":159,"_68":30,"_153":-5,"_17":160},"d52aa904-3831-11f1-9b40-42b51c65c3df","latest",["D",1776192210594],"/**\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",[18,65],"pulls","branches",1,"forks","envVars",{"_169":26,"_171":26},"connections",{"_169":26,"_170":26},"count","unfilledCount","emptyCount",{"_33":366,"_13":333,"_63":327,"_43":-5,"_35":36,"_152":367,"_157":24,"_37":368,"_39":26,"_66":74,"_150":-5,"_68":30,"_153":-5,"_201":369,"_17":370},{"_33":358,"_13":359,"_63":360,"_43":327,"_35":36,"_152":361,"_157":24,"_37":362,"_39":26,"_66":217,"_150":363,"_68":30,"_153":-5,"_201":364,"_17":365},{"_33":350,"_13":351,"_63":352,"_43":327,"_35":36,"_152":353,"_157":24,"_37":354,"_39":26,"_66":217,"_150":355,"_68":30,"_153":-5,"_201":356,"_17":357},{"_33":342,"_13":343,"_63":344,"_43":327,"_35":36,"_152":345,"_157":24,"_37":346,"_39":26,"_66":217,"_150":347,"_68":30,"_153":-5,"_201":348,"_17":349},{"_33":334,"_13":335,"_63":336,"_43":327,"_35":36,"_152":337,"_157":24,"_37":338,"_39":163,"_66":217,"_150":339,"_68":30,"_153":-5,"_201":340,"_17":341},{"_33":324,"_13":325,"_63":326,"_43":327,"_35":36,"_152":328,"_157":24,"_37":329,"_39":26,"_66":217,"_150":330,"_68":30,"_153":-5,"_201":331,"_17":332},{"_33":149,"_13":18,"_63":73,"_43":-5,"_35":36,"_152":40,"_157":24,"_37":321,"_39":26,"_66":74,"_150":-5,"_68":30,"_153":-5,"_201":322,"_17":323},{"_33":156,"_13":65,"_63":64,"_43":73,"_35":36,"_152":40,"_157":24,"_37":318,"_39":26,"_66":67,"_150":159,"_68":30,"_153":-5,"_201":319,"_17":320},{"_33":313,"_13":312,"_63":306,"_43":-5,"_35":36,"_152":314,"_157":24,"_37":315,"_39":26,"_66":74,"_150":-5,"_68":30,"_153":-5,"_201":316,"_17":317},{"_33":303,"_13":304,"_63":305,"_43":306,"_35":36,"_152":307,"_157":24,"_37":308,"_39":163,"_66":217,"_150":309,"_68":30,"_153":-5,"_201":310,"_17":311},{"_33":299,"_13":251,"_63":245,"_43":-5,"_35":36,"_152":246,"_157":24,"_37":300,"_39":26,"_66":74,"_150":-5,"_68":30,"_153":-5,"_201":301,"_17":302},{"_33":291,"_13":292,"_63":293,"_43":245,"_35":36,"_152":294,"_157":24,"_37":295,"_39":163,"_66":217,"_150":296,"_68":30,"_153":-5,"_201":297,"_17":298},{"_33":284,"_13":228,"_63":285,"_43":245,"_35":36,"_152":286,"_157":24,"_37":287,"_39":26,"_66":217,"_150":288,"_68":30,"_153":-5,"_201":289,"_17":290},{"_33":276,"_13":277,"_63":278,"_43":245,"_35":36,"_152":279,"_157":24,"_37":280,"_39":26,"_66":217,"_150":281,"_68":30,"_153":-5,"_201":282,"_17":283},{"_33":268,"_13":269,"_63":270,"_43":245,"_35":36,"_152":271,"_157":24,"_37":272,"_39":26,"_66":217,"_150":273,"_68":30,"_153":-5,"_201":274,"_17":275},{"_33":260,"_13":261,"_63":262,"_43":245,"_35":36,"_152":263,"_157":24,"_37":264,"_39":163,"_66":217,"_150":265,"_68":30,"_153":-5,"_201":266,"_17":267},{"_33":252,"_13":253,"_63":254,"_43":245,"_35":36,"_152":255,"_157":24,"_37":256,"_39":26,"_66":217,"_150":257,"_68":30,"_153":-5,"_201":258,"_17":259},{"_33":242,"_13":243,"_63":244,"_43":245,"_35":36,"_152":246,"_157":24,"_37":247,"_39":26,"_66":217,"_150":248,"_68":30,"_153":-5,"_201":249,"_17":250},{"_33":237,"_13":236,"_63":230,"_43":-5,"_35":36,"_152":238,"_157":24,"_37":239,"_39":26,"_66":74,"_150":-5,"_68":30,"_153":-5,"_201":240,"_17":241},{"_33":227,"_13":228,"_63":229,"_43":230,"_35":36,"_152":231,"_157":24,"_37":232,"_39":26,"_66":217,"_150":233,"_68":30,"_153":-5,"_201":234,"_17":235},{"_33":222,"_13":221,"_63":214,"_43":-5,"_35":36,"_152":223,"_157":24,"_37":224,"_39":26,"_66":74,"_150":-5,"_68":30,"_153":-5,"_201":225,"_17":226},{"_33":211,"_13":212,"_63":213,"_43":214,"_35":36,"_152":215,"_157":24,"_37":216,"_39":163,"_66":217,"_150":218,"_68":30,"_153":-5,"_201":219,"_17":220},{"_33":204,"_13":205,"_63":206,"_43":-5,"_35":36,"_152":112,"_157":24,"_37":207,"_39":163,"_66":21,"_150":208,"_68":30,"_153":-5,"_201":209,"_17":210},{"_33":196,"_13":197,"_63":87,"_43":-5,"_35":36,"_152":163,"_157":24,"_37":198,"_39":26,"_66":199,"_150":200,"_68":30,"_153":-5,"_201":202,"_17":203},"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","children",[],[197],"75608be6-3832-11f1-910e-42b51c65c3df","README.md","8074ad38-3831-11f1-81ab-42b51c65c3df",["D",1776192479380],"# 🎭 Discord Emoji-Bewerbungssystem Bot\n\nEin Discord Bot, bei dem sich Member mit Emoji-Reaktionen auf einer Nachricht für Rollen bewerben können. Admins sehen die Bewerbungen in einem separaten Channel und können sie akzeptieren oder ablehnen.\n\n## ✨ Features\n\n### Bewerbungssystem\n- **Emoji-Reaktions-Bewerbung** — User reagieren auf eine Panel-Nachricht mit einem Emoji\n- **Admin-Review** — Bewerbungen erscheinen in einem Admin-Channel mit Akzeptieren/Ablehnen-Buttons\n- **Automatische Rollenvergabe** — Bei Akzeptierung bekommt der User die Rolle automatisch\n- **Vollständiges Logging** — Alle Aktionen werden in einem Log-Channel protokolliert\n\n### Admin Commands\n| Command | Beschreibung |\n|---------|-------------|\n| `/setup-create` | Kanäle konfigurieren (Nachricht, Anfragen, Log, Setup) |\n| `/setup-config` | Aktuelle Konfiguration anzeigen |\n| `/emoji-add` | Emoji → Rolle Zuordnung hinzufügen |\n| `/emoji-remove` | Emoji → Rolle Zuordnung entfernen |\n| `/emoji-edit` | Emoji → Rolle Zuordnung bearbeiten |\n| `/apply-send` | Bewerbungs-Panel senden/aktualisieren |\n\n### 🔒 Owner-Only Commands\n| Command | Beschreibung |\n|---------|-------------|\n| `/owner-add` | Bot-Owner hinzufügen |\n| `/owner-remove` | Bot-Owner entfernen |\n| `/owner-list` | Alle Bot-Owner anzeigen |\n| `/key-add` | Key-User mit erweiterten Rechten hinzufügen |\n| `/key-remove` | Key-User entfernen |\n| `/key-list` | Alle Key-User anzeigen |\n| `/maintenance` | Wartungsmodus ein/aus (Bot für normale User deaktivieren) |\n| `/restart` | Bot-Neustart (DB-Migrationen neu ausführen) |\n| `/support-create` | Support-Server mit Kanälen & Panels erstellen |\n| `/support-delete` | Support-Server Setup löschen |\n\n## 🏗️ Architektur\n\n```mermaid\ngraph TD\n A[Discord User] -->|Emoji Reaktion| B[Bewerbungs-Nachricht]\n B -->|Cron pollt Reaktionen| C[poll-reactions.ts]\n C -->|Erstellt Bewerbung| D[(SQLite DB)]\n C -->|Sendet Review| E[Admin-Channel]\n E -->|Akzeptieren/Ablehnen| F[Button Handler]\n F -->|Akzeptiert| G[Rolle vergeben]\n F -->|Log| H[Log-Channel]\n \n I[Admin] -->|/setup-create| J[Interaction Handler]\n I -->|/emoji-add| J\n J -->|Speichert Config| D\n```\n\n## 📂 Projektstruktur\n\n```\nmain.ts — HTTP Endpoint (Discord Interactions)\ncommands/\n router.ts — Command-Dispatcher\n emoji.ts — /emoji-add, /emoji-remove, /emoji-edit\n apply.ts — /apply-send\n setup.ts — /setup-create, /setup-config\n owner.ts — Owner-Only Commands\nhandlers/\n buttons.ts — Akzeptieren/Ablehnen Button Handler\ndiscord/\n api.ts — Discord REST API Helpers\n handler.ts — Interaction Router & Response Helpers\n verify.ts — Ed25519 Signatur-Verifizierung\n embeds.ts — Embed-Builder\n permissions.ts — Owner/Key-User/Admin Checks\n commands.ts — (Legacy) Slash Command Definitions\n buttons.ts — (Legacy) Button Handler\ndatabase/\n schema.ts — SQLite Migrations & Queries\ncron/\n poll-reactions.ts — Pollt Emoji-Reaktionen (Interval)\nscripts/\n register-commands.ts — Registriert Slash Commands bei Discord\n```\n\n## ⚙️ Environment Variables\n\n| Variable | Beschreibung |\n|----------|-------------|\n| `DISCORD_BOT_TOKEN` | Bot Token aus dem Developer Portal |\n| `DISCORD_PUBLIC_KEY` | Public Key für Signatur-Verifizierung |\n| `DISCORD_APPLICATION_ID` | Application ID des Bots |\n| `BOT_OWNER_ID` | Discord User ID des Hauptbesitzers |\n\n## 🚀 Setup\n\n1. Bot im [Discord Developer Portal](https://discord.com/developers/applications) erstellen\n2. Environment Variables setzen\n3. `scripts/register-commands.ts` einmal ausführen\n4. Bot Interactions Endpoint URL auf die `main.ts` Endpoint-URL setzen\n5. Bot zum Server einladen (Scopes: `bot`, `applications.commands`)\n6. `/setup-create` auf dem Server ausführen\n7. `/emoji-add` um Emoji-Rollen hinzuzufügen\n8. `/apply-send` um das Bewerbungs-Panel zu senden\n\n## 🔐 Berechtigungssystem\n\n- **Owner** — Vollzugriff auf alle Commands (über `BOT_OWNER_ID` oder `/owner-add`)\n- **Key-User** — Erweiterte Rechte, ähnlich wie Admin (über `/key-add`)\n- **Discord Admin** — Server-Admins können Emoji-Commands nutzen\n- **Member** — Können sich nur über Emoji-Reaktionen bewerben\n\nDer **Wartungsmodus** deaktiviert den Bot für alle außer Owner.\n",[],[205],"6574e22c-3832-11f1-9f23-42b51c65c3df","register-commands.ts","e0be2c96-3831-11f1-adf3-42b51c65c3df","d534483a-3816-4d71-99e6-5b5e0ff24e99",24,["D",1776192452664],"script","/**\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 BOOLEAN = 5;\nconst USER = 6;\nconst CHANNEL = 7;\nconst ROLE = 8;\n\nconst commands = [\n // ─── Utility ──────────────────────────────────────────\n {\n name: \"ping\",\n description: \"Prüfe ob der Bot läuft\",\n },\n\n // ─── Setup ────────────────────────────────────────────\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],\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: \"setup-config\",\n description: \"Zeige die aktuelle Konfiguration des Bewerbungssystems\",\n default_member_permissions: \"32\",\n },\n\n // ─── Emoji Commands ───────────────────────────────────\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 // ─── Owner-Only Commands ──────────────────────────────\n {\n name: \"owner-add\",\n description: \"🔒 Füge einen Bot-Owner hinzu (nur Owner)\",\n default_member_permissions: \"0\", // No one by default — checked in code\n options: [\n {\n name: \"user\",\n description: \"Der User der Owner werden soll\",\n type: USER,\n required: true,\n },\n ],\n },\n {\n name: \"owner-remove\",\n description: \"🔒 Entferne einen Bot-Owner (nur Owner)\",\n default_member_permissions: \"0\",\n options: [\n {\n name: \"user\",\n description: \"Der User der entfernt werden soll\",\n type: USER,\n required: true,\n },\n ],\n },\n {\n name: \"owner-list\",\n description: \"🔒 Zeige alle Bot-Owner (nur Owner)\",\n default_member_permissions: \"0\",\n },\n {\n name: \"key-add\",\n description: \"🔒 Füge einen Key-User mit erweiterten Rechten hinzu (nur Owner)\",\n default_member_permissions: \"0\",\n options: [\n {\n name: \"user\",\n description: \"Der User der Key-User werden soll\",\n type: USER,\n required: true,\n },\n ],\n },\n {\n name: \"key-remove\",\n description: \"🔒 Entferne einen Key-User (nur Owner)\",\n default_member_permissions: \"0\",\n options: [\n {\n name: \"user\",\n description: \"Der User der entfernt werden soll\",\n type: USER,\n required: true,\n },\n ],\n },\n {\n name: \"key-list\",\n description: \"🔒 Zeige alle Key-User (nur Owner)\",\n default_member_permissions: \"0\",\n },\n {\n name: \"maintenance\",\n description: \"🔒 Wartungsmodus aktivieren/deaktivieren (nur Owner)\",\n default_member_permissions: \"0\",\n options: [\n {\n name: \"aktiv\",\n description: \"Wartungsmodus ein/aus\",\n type: BOOLEAN,\n required: false,\n },\n {\n name: \"grund\",\n description: \"Grund für den Wartungsmodus\",\n type: STRING,\n required: false,\n },\n ],\n },\n {\n name: \"restart\",\n description: \"🔒 Bot-Neustart (DB-Migrationen neu ausführen, nur Owner)\",\n default_member_permissions: \"0\",\n },\n {\n name: \"support-create\",\n description: \"🔒 Erstelle das Support-Server Setup mit allen Kanälen (nur Owner)\",\n default_member_permissions: \"0\",\n },\n {\n name: \"support-delete\",\n description: \"🔒 Lösche das Support-Server Setup (nur Owner)\",\n default_member_permissions: \"0\",\n },\n];\n\n// Register commands globally\nconst url = `${DISCORD_API}/applications/${APP_ID}/commands`;\n\nconsole.log(`Registriere ${commands.length} 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",[],[221,212],"scripts","e0be6378-3831-11f1-adf3-42b51c65c3df",15,["D",1776192230018],[193],[221],"2a798f74-3832-11f1-b905-42b51c65c3df","buttons.ts","2a799014-3832-11f1-b905-42b51c65c3df","1db93d52-3832-11f1-8f84-42b51c65c3df",20,["D",1776192353725],"/**\n * Button interaction handler\n * Handles accept/reject buttons from admin review channel\n */\n\nimport { addRole, sendMessage } from \"../discord/api.ts\";\nimport {\n getApplicationById,\n updateApplicationStatus,\n getGuildConfig,\n} from \"../database/schema.ts\";\nimport { ephemeral } from \"../discord/handler.ts\";\nimport { COLORS } from \"../discord/embeds.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 parts = customId.split(\"_\");\n const action = parts[0];\n const appId = parseInt(parts[1]);\n\n if (![\"accept\", \"reject\"].includes(action) || isNaN(appId)) {\n return ephemeral(\"❌ Ungültige Interaktion.\");\n }\n\n // Permission check: MANAGE_GUILD\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(\n `❌ Diese Bewerbung wurde bereits **${application.status === \"accepted\" ? \"akzeptiert\" : \"abgelehnt\"}**.`,\n );\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: any) {\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\", adminUser.id);\n\n // Update the admin message embed\n const updatedEmbed = {\n ...message.embeds[0],\n color: COLORS.SUCCESS,\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: COLORS.SUCCESS,\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 // Type 7 = UPDATE_MESSAGE\n return Response.json({\n type: 7,\n data: {\n embeds: [updatedEmbed],\n components: [{\n type: 1,\n components: [{\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 } else {\n // Reject\n await updateApplicationStatus(appId, \"rejected\", adminUser.id);\n\n const updatedEmbed = {\n ...message.embeds[0],\n color: COLORS.DANGER,\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: COLORS.DANGER,\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 type: 1,\n components: [{\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",[],[236,228],"handlers","1db93c80-3832-11f1-8f84-42b51c65c3df",19,["D",1776192332313],[191],[236],"82841fa0-3831-11f1-980a-42b51c65c3df","verify.ts","8284204a-3831-11f1-980a-42b51c65c3df","edf9ef2f-dca3-4f2c-9269-8df6b96b33e2",3,["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",[],[251,243],"discord","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",[],[251,253],"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",[],[251,261],"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",[],[251,269],"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",[],[251,277],"c3903bc8-3831-11f1-9b40-42b51c65c3df","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",[],[251,228],"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",[],[251,292],"82842c7a-3831-11f1-980a-42b51c65c3df",["D",1776192071914],[183,184,185,186,187,188,189],[251],"b605ca0e-3831-11f1-8a8a-42b51c65c3df","schema.ts","967831b8-3831-11f1-b0ca-42b51c65c3df","8037ee09-94a8-4c55-885e-f98c41a82cbb",7,["D",1776192158306],"/**\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",[],[312,304],"database","96784f2c-3831-11f1-b0ca-42b51c65c3df",5,["D",1776192105406],[181],[312],["D",1776192210594],[],[18,65],["D",1776192210594],[179],[18],"145252a8-3832-11f1-ae13-42b51c65c3df","setup.ts","14525370-3832-11f1-ae13-42b51c65c3df","55dc5238-dd62-4333-8775-bd5aa8bd31b9",18,["D",1776192316555],"/**\n * Setup command handlers: /setup-create, /setup-config\n */\n\nimport {\n getGuildConfig,\n setGuildConfig,\n} from \"../database/schema.ts\";\nimport { sendMessage } from \"../discord/api.ts\";\nimport { requireAdminOrKey } from \"../discord/permissions.ts\";\nimport { ephemeral } from \"../discord/handler.ts\";\nimport { COLORS } from \"../discord/embeds.ts\";\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\n// ─── /setup-create ──────────────────────────────────────────────\nexport async function handleSetupCreate(interaction: any): Promise {\n const { guild_id, data, member } = interaction;\n const userId = member?.user?.id;\n\n const denied = await requireAdminOrKey(userId, interaction);\n if (denied) return ephemeral(denied);\n\n const options = parseOptions(data.options);\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: COLORS.PRIMARY,\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// ─── /setup-config ──────────────────────────────────────────────\nexport async function handleSetupConfig(interaction: any): Promise {\n const { guild_id, member } = interaction;\n const userId = member?.user?.id;\n\n const denied = await requireAdminOrKey(userId, interaction);\n if (denied) return ephemeral(denied);\n\n const config = await getGuildConfig(guild_id);\n if (!config) {\n return ephemeral(\"❌ Kein Setup gefunden. Nutze `/setup-create` zuerst.\");\n }\n\n return ephemeral(\n \"⚙️ **Aktuelle Konfiguration:**\\n\\n\" +\n `📩 Bewerbungs-Nachricht: <#${config.message_channel_id}>\\n` +\n `📋 Anfragen: <#${config.request_channel_id}>\\n` +\n `📝 Logs: <#${config.log_channel_id}>\\n` +\n `🔧 Setup: <#${config.setup_channel_id}>\\n` +\n `📨 Apply-Message: ${config.apply_message_id || \"Noch nicht gesendet\"}\\n\\n` +\n \"Nutze `/setup-create` um die Konfiguration zu ändern.\",\n );\n}\n",[],[333,325],"commands","4de15186-3832-11f1-910e-42b51c65c3df","router.ts","e3c1edf6-3831-11f1-b601-42b51c65c3df",22,["D",1776192413103],"/**\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 { handleApplySend } from \"./apply.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 // ─── Apply Command ────────────────────────────\n case \"apply-send\":\n return handleApplySend(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 // ─── Utility ──────────────────────────────────\n case \"ping\":\n return ephemeral(\"🏓 Pong! Bot läuft.\");\n\n default:\n return ephemeral(`❓ Unbekannter Befehl: \\`/${commandName}\\``);\n }\n}\n",[],[333,335],"468bb12e-3832-11f1-bd59-42b51c65c3df","owner.ts","468bb1ce-3832-11f1-bd59-42b51c65c3df",21,["D",1776192400820],"/**\n * Owner-Only Commands:\n * /owner-add, /owner-remove, /owner-list\n * /key-add, /key-remove, /key-list\n * /maintenance\n * /restart\n * /support-create, /support-delete\n */\n\nimport { ephemeral, deferReply } from \"../discord/handler.ts\";\nimport { requireOwner, requireKeyUser } from \"../discord/permissions.ts\";\nimport {\n successEmbed, errorEmbed, logEmbed, maintenanceEmbed, COLORS,\n} from \"../discord/embeds.ts\";\nimport {\n addOwner, removeOwner, listOwners, isOwner,\n addKeyUser, removeKeyUser, listKeyUsers,\n setMaintenance, isMaintenanceEnabled,\n getSupportServer, setSupportServer, deleteSupportServer,\n initDatabase,\n} from \"../database/schema.ts\";\nimport {\n sendMessage, createChannel, deleteChannel, createRole,\n followUpMessage,\n} from \"../discord/api.ts\";\n\nfunction getOption(options: any[], name: string): any {\n return options?.find((o: any) => o.name === name)?.value;\n}\n\nfunction getUserId(interaction: any): string {\n return interaction.member?.user?.id || interaction.user?.id;\n}\n\n// ─── /owner-add ─────────────────────────────────────────────────\nexport async function handleOwnerAdd(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const targetUser = getOption(interaction.data.options, \"user\");\n if (!targetUser) return ephemeral(\"\", [errorEmbed(\"Fehler\", \"Bitte gib einen User an.\")]);\n\n if (await isOwner(targetUser)) {\n return ephemeral(\"\", [errorEmbed(\"Bereits Owner\", `<@${targetUser}> ist bereits ein Bot-Owner.`)]);\n }\n\n await addOwner(targetUser, userId);\n return ephemeral(\"\", [successEmbed(\"Owner hinzugefügt\", `<@${targetUser}> ist jetzt ein Bot-Owner.`)]);\n}\n\n// ─── /owner-remove ──────────────────────────────────────────────\nexport async function handleOwnerRemove(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const targetUser = getOption(interaction.data.options, \"user\");\n if (!targetUser) return ephemeral(\"\", [errorEmbed(\"Fehler\", \"Bitte gib einen User an.\")]);\n\n const primaryOwner = Deno.env.get(\"BOT_OWNER_ID\");\n if (targetUser === primaryOwner) {\n return ephemeral(\"\", [errorEmbed(\"Nicht erlaubt\", \"Der Hauptbesitzer kann nicht entfernt werden.\")]);\n }\n\n await removeOwner(targetUser);\n return ephemeral(\"\", [successEmbed(\"Owner entfernt\", `<@${targetUser}> ist kein Bot-Owner mehr.`)]);\n}\n\n// ─── /owner-list ────────────────────────────────────────────────\nexport async function handleOwnerList(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const owners = await listOwners();\n const primaryOwner = Deno.env.get(\"BOT_OWNER_ID\");\n\n let list = \"\";\n if (primaryOwner) list += `👑 <@${primaryOwner}> *(Hauptbesitzer)*\\n`;\n for (const o of owners) {\n if (o.user_id === primaryOwner) continue;\n list += `🔑 <@${o.user_id}> *(hinzugefügt von <@${o.added_by}>)*\\n`;\n }\n\n return ephemeral(\"\", [{\n title: \"👑 Bot-Owner Liste\",\n description: list || \"*Keine Owner konfiguriert.*\",\n color: COLORS.PRIMARY,\n timestamp: new Date().toISOString(),\n }]);\n}\n\n// ─── /key-add ───────────────────────────────────────────────────\nexport async function handleKeyAdd(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const targetUser = getOption(interaction.data.options, \"user\");\n if (!targetUser) return ephemeral(\"\", [errorEmbed(\"Fehler\", \"Bitte gib einen User an.\")]);\n\n const guildId = interaction.guild_id || null;\n await addKeyUser(targetUser, guildId, userId);\n return ephemeral(\"\", [successEmbed(\"Key-User hinzugefügt\", `<@${targetUser}> hat jetzt erweiterte Rechte.`)]);\n}\n\n// ─── /key-remove ────────────────────────────────────────────────\nexport async function handleKeyRemove(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const targetUser = getOption(interaction.data.options, \"user\");\n if (!targetUser) return ephemeral(\"\", [errorEmbed(\"Fehler\", \"Bitte gib einen User an.\")]);\n\n await removeKeyUser(targetUser);\n return ephemeral(\"\", [successEmbed(\"Key-User entfernt\", `<@${targetUser}> hat keine erweiterten Rechte mehr.`)]);\n}\n\n// ─── /key-list ──────────────────────────────────────────────────\nexport async function handleKeyList(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const keyUsers = await listKeyUsers();\n let list = \"\";\n for (const k of keyUsers) {\n list += `🔑 <@${k.user_id}>${k.guild_id ? ` *(Server: ${k.guild_id})*` : \" *(global)*\"} — hinzugefügt von <@${k.added_by}>\\n`;\n }\n\n return ephemeral(\"\", [{\n title: \"🔑 Key-User Liste\",\n description: list || \"*Keine Key-User konfiguriert.*\",\n color: COLORS.PRIMARY,\n timestamp: new Date().toISOString(),\n }]);\n}\n\n// ─── /maintenance ───────────────────────────────────────────────\nexport async function handleMaintenance(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const options = interaction.data.options || [];\n const enabled = getOption(options, \"aktiv\");\n const reason = getOption(options, \"grund\") || \"\";\n\n if (enabled === undefined || enabled === null) {\n // Show current status\n const status = await isMaintenanceEnabled();\n return ephemeral(\"\", [maintenanceEmbed(status.enabled, status.reason)]);\n }\n\n await setMaintenance(!!enabled, reason);\n\n return ephemeral(\"\", [maintenanceEmbed(!!enabled, reason)]);\n}\n\n// ─── /restart ───────────────────────────────────────────────────\nexport async function handleRestart(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n // Re-run database migrations (essentially a \"soft restart\")\n await initDatabase();\n\n return ephemeral(\"\", [successEmbed(\"Neustart\", \"✅ Datenbank-Migrationen wurden neu ausgeführt.\\nDer Bot ist bereit.\")]);\n}\n\n// ─── /support-create ────────────────────────────────────────────\nexport async function handleSupportCreate(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const guildId = interaction.guild_id;\n const appId = Deno.env.get(\"DISCORD_APPLICATION_ID\")!;\n const token = interaction.token;\n\n // Check if already exists\n const existing = await getSupportServer(guildId);\n if (existing) {\n return ephemeral(\"\", [errorEmbed(\n \"Bereits vorhanden\",\n \"Es existiert bereits ein Support-Setup auf diesem Server.\\nNutze `/support-delete` um es zu löschen und `/support-create` erneut.\",\n )]);\n }\n\n // Deferred response — this takes a while\n const bgWork = (async () => {\n try {\n // 1. Create category\n const category = await createChannel(guildId, {\n name: \"📋 Bewerbungssystem\",\n type: 4, // GUILD_CATEGORY\n });\n\n // 2. Create info channel\n const infoChannel = await createChannel(guildId, {\n name: \"ℹ│informationen\",\n type: 0, // GUILD_TEXT\n parent_id: category.id,\n topic: \"Informationen über das Emoji-Bewerbungssystem\",\n });\n\n // 3. Create ticket/request channel (admin only)\n const ticketChannel = await createChannel(guildId, {\n name: \"📋│bewerbungen\",\n type: 0,\n parent_id: category.id,\n topic: \"Hier erscheinen neue Bewerbungen zur Prüfung\",\n });\n\n // 4. Create apply panel channel (public, read-only for members)\n const applyChannel = await createChannel(guildId, {\n name: \"📩│bewerben\",\n type: 0,\n parent_id: category.id,\n topic: \"Reagiere mit einem Emoji um dich zu bewerben!\",\n });\n\n // Save to DB\n await setSupportServer(guildId, category.id, infoChannel.id, ticketChannel.id, applyChannel.id);\n\n // Send info message\n await sendMessage(infoChannel.id, {\n embeds: [{\n title: \"📋 Emoji-Bewerbungssystem\",\n description:\n \"**So funktioniert es:**\\n\\n\" +\n `1️⃣ Gehe in <#${applyChannel.id}> und reagiere mit dem passenden Emoji\\n` +\n \"2️⃣ Deine Bewerbung wird automatisch erstellt\\n\" +\n `3️⃣ Ein Admin prüft deine Bewerbung in <#${ticketChannel.id}>\\n` +\n \"4️⃣ Bei Annahme bekommst du die entsprechende Rolle\\n\\n\" +\n \"**Befehle (Admin):**\\n\" +\n \"`/emoji-add` — Emoji-Rolle hinzufügen\\n\" +\n \"`/emoji-remove` — Emoji-Rolle entfernen\\n\" +\n \"`/emoji-edit` — Emoji-Rolle bearbeiten\\n\" +\n \"`/apply-send` — Bewerbungs-Panel senden/aktualisieren\\n\" +\n \"`/setup-create` — Kanäle konfigurieren\\n\" +\n \"`/setup-config` — Aktuelle Konfiguration anzeigen\",\n color: COLORS.PRIMARY,\n footer: { text: \"Emoji-Bewerbungssystem v1.0\" },\n timestamp: new Date().toISOString(),\n }],\n });\n\n await followUpMessage(appId, token, {\n embeds: [successEmbed(\n \"Support-Server erstellt\",\n `**Kanäle wurden erstellt:**\\n\\n` +\n `📂 Kategorie: **${category.name}**\\n` +\n `ℹ️ Info: <#${infoChannel.id}>\\n` +\n `📋 Bewerbungen: <#${ticketChannel.id}>\\n` +\n `📩 Bewerben: <#${applyChannel.id}>\\n\\n` +\n `Nutze jetzt \\`/setup-create\\` um die Kanäle dem System zuzuweisen,\\n` +\n `oder setze manuell:\\n` +\n `• Nachricht-Channel → <#${applyChannel.id}>\\n` +\n `• Anfragen-Channel → <#${ticketChannel.id}>\\n` +\n `• Log-Channel → (erstelle einen eigenen)\\n` +\n `• Setup-Channel → (erstelle einen eigenen)`,\n )],\n flags: 64,\n });\n } catch (e: any) {\n console.error(\"support-create error:\", e);\n await followUpMessage(appId, token, {\n embeds: [errorEmbed(\"Fehler beim Erstellen\", `${e.message || e}`)],\n flags: 64,\n });\n }\n })();\n\n bgWork.catch(console.error);\n return deferReply();\n}\n\n// ─── /support-delete ────────────────────────────────────────────\nexport async function handleSupportDelete(interaction: any): Promise {\n const userId = getUserId(interaction);\n const err = await requireOwner(userId);\n if (err) return ephemeral(err);\n\n const guildId = interaction.guild_id;\n const appId = Deno.env.get(\"DISCORD_APPLICATION_ID\")!;\n const token = interaction.token;\n\n const support = await getSupportServer(guildId);\n if (!support) {\n return ephemeral(\"\", [errorEmbed(\"Nicht gefunden\", \"Kein Support-Setup auf diesem Server vorhanden.\")]);\n }\n\n const bgWork = (async () => {\n try {\n // Delete channels (children first, then category)\n const channelIds = [\n support.info_channel_id,\n support.ticket_channel_id,\n support.apply_panel_channel_id,\n support.category_id,\n ].filter(Boolean);\n\n for (const chId of channelIds) {\n try {\n await deleteChannel(chId as string);\n } catch (e) {\n console.error(`Failed to delete channel ${chId}:`, e);\n }\n }\n\n await deleteSupportServer(guildId);\n\n await followUpMessage(appId, token, {\n embeds: [successEmbed(\"Support-Server gelöscht\", \"Alle Kanäle und die Konfiguration wurden entfernt.\")],\n flags: 64,\n });\n } catch (e: any) {\n console.error(\"support-delete error:\", e);\n await followUpMessage(appId, token, {\n embeds: [errorEmbed(\"Fehler beim Löschen\", `${e.message || e}`)],\n flags: 64,\n });\n }\n })();\n\n bgWork.catch(console.error);\n return deferReply();\n}\n",[],[333,343],"f6b0d648-3831-11f1-b601-42b51c65c3df","emoji.ts","f6b0d7e2-3831-11f1-b601-42b51c65c3df",17,["D",1776192266833],"/**\n * /emoji-add, /emoji-remove, /emoji-edit commands\n * Require Discord Admin or Key-User\n */\n\nimport { ephemeral, deferReply } from \"../discord/handler.ts\";\nimport { requireAdminOrKey } from \"../discord/permissions.ts\";\nimport { successEmbed, errorEmbed, logEmbed } from \"../discord/embeds.ts\";\nimport {\n getGuildConfig, getEmojiRoles, getEmojiRole,\n addEmojiRole, removeEmojiRole, updateEmojiRole,\n setApplyMessageId,\n} from \"../database/schema.ts\";\nimport { sendMessage, editMessage, addReaction, followUpMessage, removeAllReactions } from \"../discord/api.ts\";\nimport { applyPanelEmbed } from \"../discord/embeds.ts\";\n\nfunction getOption(options: any[], name: string): any {\n return options?.find((o: any) => o.name === name)?.value;\n}\n\nasync function refreshApplyMessage(guildId: string, config: any) {\n const emojiRoles = await getEmojiRoles(guildId);\n const embed = applyPanelEmbed(emojiRoles as any[]);\n\n if (config.apply_message_id) {\n try {\n await editMessage(config.message_channel_id, config.apply_message_id, { embeds: [embed] });\n // Re-add all reactions\n await removeAllReactions(config.message_channel_id, config.apply_message_id);\n for (const er of emojiRoles) {\n await addReaction(config.message_channel_id, config.apply_message_id, (er as any).emoji);\n }\n return;\n } catch {\n // Message deleted, create new\n }\n }\n\n // Send new apply message\n const msg = await sendMessage(config.message_channel_id, { embeds: [embed] });\n await setApplyMessageId(guildId, msg.id);\n\n // Add reactions\n for (const er of emojiRoles) {\n await addReaction(config.message_channel_id, msg.id, (er as any).emoji);\n }\n}\n\n// ─── /emoji-add ─────────────────────────────────────────────────\nexport async function handleEmojiAdd(interaction: any): Promise {\n const userId = interaction.member.user.id;\n const guildId = interaction.guild_id;\n const options = interaction.data.options;\n\n const permErr = await requireAdminOrKey(userId, interaction);\n if (permErr) return ephemeral(permErr);\n\n const config = await getGuildConfig(guildId);\n if (!config) {\n return ephemeral(\"\", [errorEmbed(\"Nicht konfiguriert\", \"Bitte erst `/setup-create` oder `/setup-config` verwenden!\")]);\n }\n\n const emoji = getOption(options, \"emoji\");\n const role = getOption(options, \"rolle\");\n const label = getOption(options, \"label\") || \"\";\n const description = getOption(options, \"beschreibung\") || \"\";\n\n if (!emoji || !role) {\n return ephemeral(\"\", [errorEmbed(\"Fehler\", \"Emoji und Rolle sind Pflichtfelder!\")]);\n }\n\n // Check if emoji already exists\n const existing = await getEmojiRole(guildId, emoji);\n if (existing) {\n return ephemeral(\"\", [errorEmbed(\"Bereits vorhanden\", `Das Emoji ${emoji} ist bereits konfiguriert.`)]);\n }\n\n // Get role name from guild\n const roleName = `<@&${role}>`;\n\n await addEmojiRole(guildId, emoji, role, label || roleName, label || \"Rolle\", description, config);\n\n // Refresh the apply panel message\n const appId = Deno.env.get(\"DISCORD_APPLICATION_ID\")!;\n const token = interaction.token;\n\n // Deferred response, do background work\n const responsePromise = (async () => {\n try {\n await refreshApplyMessage(guildId, config);\n\n // Log\n await sendMessage(config.log_channel_id, {\n embeds: [logEmbed(\"Emoji hinzugefügt\", `**Admin:** <@${userId}>\\n**Emoji:** ${emoji}\\n**Rolle:** <@&${role}>\\n**Label:** ${label || \"-\"}\\n**Beschreibung:** ${description || \"-\"}`)],\n });\n\n await followUpMessage(appId, token, {\n embeds: [successEmbed(\"Emoji hinzugefügt\", `${emoji} → <@&${role}> wurde erfolgreich konfiguriert!`)],\n flags: 64,\n });\n } catch (e) {\n console.error(\"emoji-add error:\", e);\n await followUpMessage(appId, token, {\n embeds: [errorEmbed(\"Fehler\", `${e}`)],\n flags: 64,\n });\n }\n })();\n\n // Fire and forget the background task\n responsePromise.catch(console.error);\n\n return deferReply();\n}\n\n// ─── /emoji-remove ──────────────────────────────────────────────\nexport async function handleEmojiRemove(interaction: any): Promise {\n const userId = interaction.member.user.id;\n const guildId = interaction.guild_id;\n const options = interaction.data.options;\n\n const permErr = await requireAdminOrKey(userId, interaction);\n if (permErr) return ephemeral(permErr);\n\n const config = await getGuildConfig(guildId);\n if (!config) {\n return ephemeral(\"\", [errorEmbed(\"Nicht konfiguriert\", \"Bitte erst `/setup-create` oder `/setup-config` verwenden!\")]);\n }\n\n const emoji = getOption(options, \"emoji\");\n if (!emoji) return ephemeral(\"\", [errorEmbed(\"Fehler\", \"Emoji ist ein Pflichtfeld!\")]);\n\n const existing = await getEmojiRole(guildId, emoji);\n if (!existing) {\n return ephemeral(\"\", [errorEmbed(\"Nicht gefunden\", `Kein Emoji ${emoji} in der Konfiguration gefunden.`)]);\n }\n\n await removeEmojiRole(guildId, emoji);\n\n const appId = Deno.env.get(\"DISCORD_APPLICATION_ID\")!;\n const token = interaction.token;\n\n (async () => {\n try {\n await refreshApplyMessage(guildId, config);\n await sendMessage(config.log_channel_id, {\n embeds: [logEmbed(\"Emoji entfernt\", `**Admin:** <@${userId}>\\n**Emoji:** ${emoji}\\n**Rolle:** <@&${(existing as any).role_id}>`)],\n });\n await followUpMessage(appId, token, {\n embeds: [successEmbed(\"Emoji entfernt\", `${emoji} wurde erfolgreich entfernt!`)],\n flags: 64,\n });\n } catch (e) {\n console.error(\"emoji-remove error:\", e);\n await followUpMessage(appId, token, {\n embeds: [errorEmbed(\"Fehler\", `${e}`)],\n flags: 64,\n });\n }\n })().catch(console.error);\n\n return deferReply();\n}\n\n// ─── /emoji-edit ────────────────────────────────────────────────\nexport async function handleEmojiEdit(interaction: any): Promise {\n const userId = interaction.member.user.id;\n const guildId = interaction.guild_id;\n const options = interaction.data.options;\n\n const permErr = await requireAdminOrKey(userId, interaction);\n if (permErr) return ephemeral(permErr);\n\n const config = await getGuildConfig(guildId);\n if (!config) {\n return ephemeral(\"\", [errorEmbed(\"Nicht konfiguriert\", \"Bitte erst `/setup-create` oder `/setup-config` verwenden!\")]);\n }\n\n const emoji = getOption(options, \"emoji\");\n if (!emoji) return ephemeral(\"\", [errorEmbed(\"Fehler\", \"Emoji ist ein Pflichtfeld!\")]);\n\n const existing = await getEmojiRole(guildId, emoji);\n if (!existing) {\n return ephemeral(\"\", [errorEmbed(\"Nicht gefunden\", `Kein Emoji ${emoji} in der Konfiguration gefunden.`)]);\n }\n\n const ex = existing as any;\n const newRole = getOption(options, \"rolle\") || ex.role_id;\n const newLabel = getOption(options, \"label\") || ex.label;\n const newDescription = getOption(options, \"beschreibung\") ?? ex.description;\n const newRoleName = newRole !== ex.role_id ? `<@&${newRole}>` : ex.role_name;\n\n await updateEmojiRole(guildId, emoji, newRole, newRoleName, newLabel, newDescription);\n\n const appId = Deno.env.get(\"DISCORD_APPLICATION_ID\")!;\n const token = interaction.token;\n\n (async () => {\n try {\n await refreshApplyMessage(guildId, config);\n await sendMessage(config.log_channel_id, {\n embeds: [logEmbed(\"Emoji bearbeitet\", `**Admin:** <@${userId}>\\n**Emoji:** ${emoji}\\n**Neue Rolle:** <@&${newRole}>\\n**Label:** ${newLabel}\\n**Beschreibung:** ${newDescription || \"-\"}`)],\n });\n await followUpMessage(appId, token, {\n embeds: [successEmbed(\"Emoji bearbeitet\", `${emoji} wurde erfolgreich aktualisiert!`)],\n flags: 64,\n });\n } catch (e) {\n console.error(\"emoji-edit error:\", e);\n await followUpMessage(appId, token, {\n embeds: [errorEmbed(\"Fehler\", `${e}`)],\n flags: 64,\n });\n }\n })().catch(console.error);\n\n return deferReply();\n}\n",[],[333,351],"54b1b44c-3832-11f1-910e-42b51c65c3df","apply.ts","54b1b50a-3832-11f1-910e-42b51c65c3df",23,["D",1776192424557],"/**\n * /apply-send command handler\n * Sends or updates the emoji reaction application panel message\n */\n\nimport { ephemeral, deferReply } from \"../discord/handler.ts\";\nimport { requireAdminOrKey } from \"../discord/permissions.ts\";\nimport { successEmbed, errorEmbed, applyPanelEmbed } from \"../discord/embeds.ts\";\nimport {\n getGuildConfig,\n getEmojiRoles,\n setApplyMessageId,\n} from \"../database/schema.ts\";\nimport {\n sendMessage, editMessage, addReaction, removeAllReactions,\n followUpMessage,\n} from \"../discord/api.ts\";\n\nexport async function handleApplySend(interaction: any): Promise {\n const userId = interaction.member?.user?.id;\n const guildId = interaction.guild_id;\n\n const permErr = await requireAdminOrKey(userId, interaction);\n if (permErr) return ephemeral(permErr);\n\n const config = await getGuildConfig(guildId);\n if (!config) {\n return ephemeral(\"\", [errorEmbed(\"Nicht konfiguriert\", \"Bitte erst `/setup-create` verwenden!\")]);\n }\n\n const emojiRoles = await getEmojiRoles(guildId);\n if (emojiRoles.length === 0) {\n return ephemeral(\"\", [errorEmbed(\"Keine Emojis\", \"Keine Emoji-Rollen konfiguriert. Nutze `/emoji-add` zuerst.\")]);\n }\n\n const appId = Deno.env.get(\"DISCORD_APPLICATION_ID\")!;\n const token = interaction.token;\n\n const bgWork = (async () => {\n try {\n const embed = applyPanelEmbed(emojiRoles as any[]);\n const channelId = config.message_channel_id as string;\n\n // Try to update existing message\n if (config.apply_message_id) {\n try {\n await editMessage(channelId, config.apply_message_id as string, { embeds: [embed] });\n await removeAllReactions(channelId, config.apply_message_id as string);\n for (const er of emojiRoles) {\n await addReaction(channelId, config.apply_message_id as string, (er as any).emoji);\n }\n\n await followUpMessage(appId, token, {\n embeds: [successEmbed(\"Aktualisiert\", \"Die Bewerbungs-Nachricht wurde aktualisiert!\")],\n flags: 64,\n });\n return;\n } catch {\n // Message was deleted, send a new one\n }\n }\n\n // Send new message\n const msg = await sendMessage(channelId, { embeds: [embed] });\n await setApplyMessageId(guildId, msg.id);\n\n for (const er of emojiRoles) {\n await addReaction(channelId, msg.id, (er as any).emoji);\n }\n\n await followUpMessage(appId, token, {\n embeds: [successEmbed(\"Gesendet\", \"Bewerbungs-Nachricht wurde gesendet! Reaktionen wurden hinzugefügt.\")],\n flags: 64,\n });\n } catch (e: any) {\n console.error(\"apply-send error:\", e);\n await followUpMessage(appId, token, {\n embeds: [errorEmbed(\"Fehler\", `${e.message || e}`)],\n flags: 64,\n });\n }\n })();\n\n bgWork.catch(console.error);\n return deferReply();\n}\n",[],[333,359],"e3c2124a-3831-11f1-b601-42b51c65c3df",16,["D",1776192235079],[173,174,175,176,177],[333],["D",1776192046430],{"_11":12,"_127":123},{"_11":12,"_121":122,"_71":123,"_31":-5,"_124":125,"_126":30},{"_39":112,"_13":16,"_33":36,"_113":76,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":14,"_120":12},"ctx",{"_53":-5,"_146":408,"_409":410,"_411":412,"_413":30,"_414":30,"_415":30,"_416":24,"_417":-5,"_418":-7,"_419":-7,"_420":26,"_421":30,"_422":30,"_423":-5,"_424":30,"_425":30,"_426":30,"_427":-5},"ENV",{"_379":380,"_381":382,"_383":16,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407},"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"]

History · cron