[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_365":366,"_367":368},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_85":67,"_86":87,"_65":-7,"_88":-5,"_13":89,"_90":91,"_11":92,"_93":94,"_95":96,"_97":-5,"_98":-5,"_99":-5,"_100":26,"_101":102,"_103":38,"_104":-5,"_105":-5,"_106":107},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":50,"_52":53,"_54":53,"_55":53,"_56":50,"_57":50,"_58":59,"_60":61,"_62":63,"_64":26},"query","handle","CyberCore","id","734f95d2-3831-11f1-a548-42b51c65c3df","name","discord-emoji-apply-bot","createdAt",["D",1776192046430],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Discord Bot: Emoji-Bewerbungssystem mit Admin-Panel","imageUrl","userId","40d60734-a91c-4cc2-9305-b592a890bee5","pinnedFileId","7e90986a-3831-11f1-980a-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d8d4b-5635-76cf-ac0c-e26664ce89f6","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_16":17,"_84":80},"org",{"_16":17,"_77":78,"_79":80,"_33":-5,"_81":82,"_83":26},"branch",{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"isOwned","version",25,"main","73503406-3831-11f1-a548-42b51c65c3df","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","CyberCore ","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/87a0b6a2-3e42-41a1-3ec2-d561aa654100/square512?exp=1789567199&sig=888b71d22315e8746e9a8dc0dac39300908710a0ca1158f98e6cc80a2f66d3ff","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":361,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":50,"_52":53,"_54":53,"_55":53,"_56":50,"_57":50,"_58":362,"_60":363,"_62":364,"_64":26},"tree",[185,191,193,195,203,205,207,208],[185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208],"counts",{"_175":42,"_176":122,"_177":42,"_178":179,"_180":181},"contents",[108,109,110,111,112,113,114,115],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_18":169,"_20":170,"_118":171,"_119":-5,"_120":68,"_121":172,"_123":38,"_22":173,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_86":174},{"_18":163,"_20":164,"_118":165,"_119":-5,"_120":68,"_121":166,"_123":38,"_22":167,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_86":168},{"_18":157,"_20":158,"_118":159,"_119":-5,"_120":68,"_121":160,"_123":38,"_22":161,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_86":162},{"_18":151,"_20":152,"_118":153,"_119":-5,"_120":68,"_121":154,"_123":38,"_22":155,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_86":156},{"_18":145,"_20":146,"_118":147,"_119":-5,"_120":68,"_121":148,"_123":38,"_22":149,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_86":150},{"_18":138,"_20":139,"_118":140,"_119":-5,"_120":68,"_121":141,"_123":38,"_22":142,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_86":144},{"_18":132,"_20":133,"_118":134,"_119":-5,"_120":68,"_121":66,"_123":38,"_22":135,"_65":122,"_125":97,"_127":136,"_129":26,"_130":-5,"_86":137},{"_18":116,"_20":117,"_118":36,"_119":-5,"_120":68,"_121":122,"_123":38,"_22":124,"_65":42,"_125":126,"_127":128,"_129":26,"_130":-5,"_86":131},"7e9097b6-3831-11f1-980a-42b51c65c3df","main.ts","fileId","parentId","branchId","branchVersion",1,"latest",["D",1776192065301],"fileType","http","content","/**\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","deleted","label",[117],"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",[133],"e0be6378-3831-11f1-adf3-42b51c65c3df","scripts","d534483a-3816-4d71-99e6-5b5e0ff24e99",15,["D",1776192230018],"directory",[139],"1db93c80-3832-11f1-8f84-42b51c65c3df","handlers","1db93d52-3832-11f1-8f84-42b51c65c3df",19,["D",1776192332313],[146],"82842c7a-3831-11f1-980a-42b51c65c3df","discord","edf9ef2f-dca3-4f2c-9269-8df6b96b33e2",3,["D",1776192071914],[152],"96784f2c-3831-11f1-b0ca-42b51c65c3df","database","8037ee09-94a8-4c55-885e-f98c41a82cbb",5,["D",1776192105406],[158],"d52acbb4-3831-11f1-9b40-42b51c65c3df","cron","88e963d7-5f46-4392-a402-aba78d75508b",13,["D",1776192210594],[164],"e3c2124a-3831-11f1-b601-42b51c65c3df","commands","55dc5238-dd62-4333-8775-bd5aa8bd31b9",16,["D",1776192235079],[170],"pulls","branches","forks","envVars",{"_182":42,"_184":42},"connections",{"_182":42,"_183":42},"count","unfilledCount","emptyCount",{"_18":169,"_20":170,"_118":171,"_119":-5,"_120":68,"_121":172,"_123":38,"_22":358,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_210":359,"_86":360},{"_18":350,"_20":351,"_118":352,"_119":171,"_120":68,"_121":353,"_123":38,"_22":354,"_65":42,"_125":221,"_127":355,"_129":26,"_130":-5,"_210":356,"_86":357},{"_18":342,"_20":343,"_118":344,"_119":171,"_120":68,"_121":345,"_123":38,"_22":346,"_65":42,"_125":221,"_127":347,"_129":26,"_130":-5,"_210":348,"_86":349},{"_18":334,"_20":335,"_118":336,"_119":171,"_120":68,"_121":337,"_123":38,"_22":338,"_65":42,"_125":221,"_127":339,"_129":26,"_130":-5,"_210":340,"_86":341},{"_18":326,"_20":327,"_118":328,"_119":171,"_120":68,"_121":329,"_123":38,"_22":330,"_65":122,"_125":221,"_127":331,"_129":26,"_130":-5,"_210":332,"_86":333},{"_18":318,"_20":319,"_118":320,"_119":171,"_120":68,"_121":321,"_123":38,"_22":322,"_65":42,"_125":221,"_127":323,"_129":26,"_130":-5,"_210":324,"_86":325},{"_18":163,"_20":164,"_118":165,"_119":-5,"_120":68,"_121":166,"_123":38,"_22":315,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_210":316,"_86":317},{"_18":307,"_20":308,"_118":309,"_119":165,"_120":68,"_121":166,"_123":38,"_22":310,"_65":42,"_125":311,"_127":312,"_129":26,"_130":-5,"_210":313,"_86":314},{"_18":157,"_20":158,"_118":159,"_119":-5,"_120":68,"_121":160,"_123":38,"_22":304,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_210":305,"_86":306},{"_18":296,"_20":297,"_118":298,"_119":159,"_120":68,"_121":299,"_123":38,"_22":300,"_65":122,"_125":221,"_127":301,"_129":26,"_130":-5,"_210":302,"_86":303},{"_18":151,"_20":152,"_118":153,"_119":-5,"_120":68,"_121":154,"_123":38,"_22":293,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_210":294,"_86":295},{"_18":285,"_20":286,"_118":287,"_119":153,"_120":68,"_121":288,"_123":38,"_22":289,"_65":122,"_125":221,"_127":290,"_129":26,"_130":-5,"_210":291,"_86":292},{"_18":278,"_20":229,"_118":279,"_119":153,"_120":68,"_121":280,"_123":38,"_22":281,"_65":42,"_125":221,"_127":282,"_129":26,"_130":-5,"_210":283,"_86":284},{"_18":270,"_20":271,"_118":272,"_119":153,"_120":68,"_121":273,"_123":38,"_22":274,"_65":42,"_125":221,"_127":275,"_129":26,"_130":-5,"_210":276,"_86":277},{"_18":262,"_20":263,"_118":264,"_119":153,"_120":68,"_121":265,"_123":38,"_22":266,"_65":42,"_125":221,"_127":267,"_129":26,"_130":-5,"_210":268,"_86":269},{"_18":254,"_20":255,"_118":256,"_119":153,"_120":68,"_121":257,"_123":38,"_22":258,"_65":122,"_125":221,"_127":259,"_129":26,"_130":-5,"_210":260,"_86":261},{"_18":246,"_20":247,"_118":248,"_119":153,"_120":68,"_121":249,"_123":38,"_22":250,"_65":42,"_125":221,"_127":251,"_129":26,"_130":-5,"_210":252,"_86":253},{"_18":239,"_20":240,"_118":241,"_119":153,"_120":68,"_121":154,"_123":38,"_22":242,"_65":42,"_125":221,"_127":243,"_129":26,"_130":-5,"_210":244,"_86":245},{"_18":145,"_20":146,"_118":147,"_119":-5,"_120":68,"_121":148,"_123":38,"_22":236,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_210":237,"_86":238},{"_18":228,"_20":229,"_118":230,"_119":147,"_120":68,"_121":231,"_123":38,"_22":232,"_65":42,"_125":221,"_127":233,"_129":26,"_130":-5,"_210":234,"_86":235},{"_18":138,"_20":139,"_118":140,"_119":-5,"_120":68,"_121":141,"_123":38,"_22":225,"_65":42,"_125":143,"_127":-5,"_129":26,"_130":-5,"_210":226,"_86":227},{"_18":216,"_20":217,"_118":218,"_119":140,"_120":68,"_121":219,"_123":38,"_22":220,"_65":122,"_125":221,"_127":222,"_129":26,"_130":-5,"_210":223,"_86":224},{"_18":132,"_20":133,"_118":134,"_119":-5,"_120":68,"_121":66,"_123":38,"_22":213,"_65":122,"_125":97,"_127":136,"_129":26,"_130":-5,"_210":214,"_86":215},{"_18":116,"_20":117,"_118":36,"_119":-5,"_120":68,"_121":122,"_123":38,"_22":209,"_65":42,"_125":126,"_127":128,"_129":26,"_130":-5,"_210":211,"_86":212},["D",1776192065301],"children",[],[117],["D",1776192479380],[],[133],"6574e22c-3832-11f1-9f23-42b51c65c3df","register-commands.ts","e0be2c96-3831-11f1-adf3-42b51c65c3df",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",[],[139,217],["D",1776192230018],[206],[139],"2a798f74-3832-11f1-b905-42b51c65c3df","buttons.ts","2a799014-3832-11f1-b905-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",[],[146,229],["D",1776192332313],[204],[146],"82841fa0-3831-11f1-980a-42b51c65c3df","verify.ts","8284204a-3831-11f1-980a-42b51c65c3df",["D",1776192071914],"/**\n * Verify Discord interaction requests using Ed25519 signatures\n */\n\nexport async function verifyDiscordRequest(\n body: string,\n signature: string,\n timestamp: string,\n publicKey: string,\n): Promise {\n try {\n const key = await crypto.subtle.importKey(\n \"raw\",\n hexToUint8Array(publicKey),\n { name: \"Ed25519\", namedCurve: \"Ed25519\" },\n false,\n [\"verify\"],\n );\n\n const encoder = new TextEncoder();\n const message = encoder.encode(timestamp + body);\n const sig = hexToUint8Array(signature);\n\n return await crypto.subtle.verify(\"Ed25519\", key, sig, message);\n } catch (e) {\n console.error(\"Verification error:\", e);\n return false;\n }\n}\n\nfunction hexToUint8Array(hex: string): Uint8Array {\n const bytes = new Uint8Array(hex.length / 2);\n for (let i = 0; i < hex.length; i += 2) {\n bytes[i / 2] = parseInt(hex.substring(i, i + 2), 16);\n }\n return bytes;\n}\n",[],[152,240],"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",[],[152,247],"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",[],[152,255],"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",[],[152,263],"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",[],[152,271],"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",[],[152,229],"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",[],[152,286],["D",1776192071914],[196,197,198,199,200,201,202],[152],"b605ca0e-3831-11f1-8a8a-42b51c65c3df","schema.ts","967831b8-3831-11f1-b0ca-42b51c65c3df",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",[],[158,297],["D",1776192105406],[194],[158],"d52aa904-3831-11f1-9b40-42b51c65c3df","poll-reactions.ts","d52aa9d6-3831-11f1-9b40-42b51c65c3df",["D",1776192210594],"interval","/**\n * Cron job: Polls reactions on the apply message every minute.\n * When a new reaction from a user is detected, it creates an application\n * and sends a review request to the admin channel.\n * \n * Runs every 1 minute.\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDatabase, getEmojiRoles, getGuildConfig, createApplication, setApplicationAdminMessage, getPendingApplication } from \"../database/schema.ts\";\nimport { sendMessage } from \"../discord/api.ts\";\n\nconst DISCORD_API = \"https://discord.com/api/v10\";\n\nfunction getToken(): string {\n return Deno.env.get(\"DISCORD_BOT_TOKEN\") || \"\";\n}\n\nasync function getReactions(channelId: string, messageId: string, emoji: string): Promise {\n const encoded = encodeURIComponent(emoji);\n const res = await fetch(\n `${DISCORD_API}/channels/${channelId}/messages/${messageId}/reactions/${encoded}?limit=100`,\n {\n headers: { \"Authorization\": `Bot ${getToken()}` },\n },\n );\n if (!res.ok) {\n console.error(`getReactions error for ${emoji}:`, await res.text());\n return [];\n }\n return res.json();\n}\n\nasync function removeUserReaction(\n channelId: string,\n messageId: string,\n emoji: string,\n userId: string,\n): Promise {\n const encoded = encodeURIComponent(emoji);\n const res = await fetch(\n `${DISCORD_API}/channels/${channelId}/messages/${messageId}/reactions/${encoded}/${userId}`,\n {\n method: \"DELETE\",\n headers: { \"Authorization\": `Bot ${getToken()}` },\n },\n );\n if (!res.ok) {\n console.error(`removeUserReaction error:`, await res.text());\n }\n}\n\nexport default async function(interval: Interval) {\n if (!getToken()) {\n console.log(\"No DISCORD_BOT_TOKEN set, skipping.\");\n return;\n }\n\n await initDatabase();\n\n // Get all guild configs\n const configs = await sqlite.execute(\"SELECT * FROM guild_config WHERE apply_message_id IS NOT NULL\");\n\n for (const config of configs.rows) {\n const guildId = config.guild_id as string;\n const messageChannelId = config.message_channel_id as string;\n const applyMessageId = config.apply_message_id as string;\n const requestChannelId = config.request_channel_id as string;\n\n if (!applyMessageId) continue;\n\n const emojiRoles = await getEmojiRoles(guildId);\n\n for (const er of emojiRoles) {\n const emoji = er.emoji as string;\n const roleId = er.role_id as string;\n const roleName = er.role_name as string;\n const label = er.label as string;\n\n // Get reactions for this emoji\n const users = await getReactions(messageChannelId, applyMessageId, emoji);\n\n // Get bot's own user ID to filter out\n const botId = Deno.env.get(\"DISCORD_APPLICATION_ID\") || \"\";\n\n for (const user of users) {\n // Skip bots\n if (user.bot) continue;\n if (user.id === botId) continue;\n\n // Check if already has a pending application\n const existing = await getPendingApplication(guildId, user.id, emoji);\n if (existing) {\n // Remove the reaction so they can apply again later\n await removeUserReaction(messageChannelId, applyMessageId, emoji, user.id);\n continue;\n }\n\n // Check if already accepted for this role (prevent spam)\n const accepted = await sqlite.execute({\n sql: \"SELECT * FROM applications WHERE guild_id = ? AND user_id = ? AND emoji = ? AND status = 'accepted'\",\n args: [guildId, user.id, emoji],\n });\n if (accepted.rows.length > 0) {\n await removeUserReaction(messageChannelId, applyMessageId, emoji, user.id);\n continue;\n }\n\n // Create application\n const app = await createApplication(guildId, user.id, emoji, roleId);\n const appId = (app as any).id ?? (app as any)[\"last_insert_rowid()\"];\n\n // Send review message to admin channel\n try {\n const adminMsg = await sendMessage(requestChannelId, {\n embeds: [{\n title: \"📋 Neue Bewerbung\",\n color: 0xFEE75C,\n fields: [\n { name: \"👤 Bewerber\", value: `<@${user.id}>\\n(${user.username}#${user.discriminator || \"0\"})`, inline: true },\n { name: \"📛 Rolle\", value: `<@&${roleId}>\\n(${roleName})`, inline: true },\n { name: `${emoji} Emoji`, value: `${emoji} — ${label}`, inline: true },\n ],\n thumbnail: {\n url: user.avatar \n ? `https://cdn.discordapp.com/avatars/${user.id}/${user.avatar}.png?size=128` \n : `https://cdn.discordapp.com/embed/avatars/${parseInt(user.discriminator || \"0\") % 5}.png`,\n },\n footer: { text: `Bewerbungs-ID: ${appId}` },\n timestamp: new Date().toISOString(),\n }],\n components: [\n {\n type: 1,\n components: [\n {\n type: 2,\n style: 3, // green\n label: \"✅ Akzeptieren\",\n custom_id: `accept_${appId}`,\n },\n {\n type: 2,\n style: 4, // red\n label: \"❌ Ablehnen\",\n custom_id: `reject_${appId}`,\n },\n ],\n },\n ],\n });\n\n await setApplicationAdminMessage(appId, adminMsg.id);\n } catch (e) {\n console.error(\"Failed to send admin review message:\", e);\n }\n\n // Remove the user's reaction\n await removeUserReaction(messageChannelId, applyMessageId, emoji, user.id);\n\n console.log(`New application: User ${user.id} for role ${roleName} (${emoji})`);\n }\n }\n }\n}\n",[],[164,308],["D",1776192210594],[192],[164],"145252a8-3832-11f1-ae13-42b51c65c3df","setup.ts","14525370-3832-11f1-ae13-42b51c65c3df",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",[],[170,319],"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",[],[170,327],"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",[],[170,335],"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",[],[170,343],"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",[],[170,351],["D",1776192235079],[186,187,188,189,190],[170],["D",1776192046430],{"_16":17,"_84":80},{"_16":17,"_77":78,"_79":80,"_33":-5,"_81":82,"_83":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"ctx",{"_58":-5,"_105":398,"_399":400,"_401":402,"_403":26,"_404":26,"_405":26,"_406":38,"_407":-5,"_408":-7,"_409":-7,"_410":42,"_411":26,"_412":26,"_413":-5,"_414":26,"_415":26,"_416":26,"_417":-5},"ENV",{"_369":370,"_371":372,"_373":67,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Search