[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_288":289,"_290":291},"routes/_app.x.$handle.$name",{"_108":107,"_38":56,"_117":98,"_33":118,"_13":14,"_119":-5,"_11":120,"_121":122,"_123":124,"_125":126,"_127":128,"_27":-5,"_129":-5,"_130":-5,"_131":31,"_132":133,"_134":70,"_135":-5,"_136":-5,"_137":138},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_54":55,"_38":56,"_44":57,"_58":-5,"_59":31,"_60":61,"_62":61,"_63":64,"_65":-5,"_19":66,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":74,"_75":76,"_77":-5,"_78":-5,"_79":-5,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":91,"_92":93,"_94":95,"_96":31},"version",13,"changes",[25,26],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","9823b296-72ca-45be-a955-308c58b319c3","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_27":49,"_29":-7,"_30":31,"_32":31,"_33":50,"_35":50},{"_27":28,"_29":-7,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous","deleted",false,"deletedHere","path","cron/poll-reactions.ts","latestPath","fileId","d52aa9d6-3831-11f1-9b40-42b51c65c3df","name","poll-reactions.ts","fileType","interval","content","/**\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","createdAt",["D",1776192210594],"branchVersion","branchId","73503406-3831-11f1-a548-42b51c65c3df",{"_36":51,"_38":50,"_40":52,"_42":-5,"_44":53,"_46":14,"_47":48,"_30":31},"cron","88e963d7-5f46-4392-a402-aba78d75508b","directory",["D",1776192210594],"id","734f95d2-3831-11f1-a548-42b51c65c3df","discord-emoji-apply-bot",["D",1776192046430],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Discord Bot: Emoji-Bewerbungssystem mit Admin-Panel","imageUrl","40d60734-a91c-4cc2-9305-b592a890bee5","pinnedFileId","7e90986a-3831-11f1-980a-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d8d4b-5635-76cf-ac0c-e26664ce89f6","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_108":107,"_116":112},"org",{"_108":107,"_109":110,"_111":112,"_19":-5,"_113":114,"_115":31},"branch",{"_13":97,"_38":98,"_54":48,"_99":55,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":56,"_106":107},"isOwned",25,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","CyberCore","handle","displayName","CyberCore ","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/87a0b6a2-3e42-41a1-3ec2-d561aa654100/square512?exp=1789577999&sig=357a387f842b473da7ea5025b079c0bdb311777ece8ad80f4280a192a71e65f8","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_54":55,"_38":56,"_44":284,"_58":-5,"_59":31,"_60":61,"_62":61,"_63":64,"_65":-5,"_19":66,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":74,"_75":76,"_77":-5,"_78":-5,"_79":-5,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":285,"_92":286,"_94":287,"_96":31},"tree",[186,188,190,198,199],"files",[186,187,188,189,190,191,192,193,194,195,196,197,198,199],"counts",{"_176":74,"_177":147,"_178":74,"_179":180,"_181":182},"contents",[139,140,141,142,143],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_54":173,"_38":50,"_36":51,"_146":-5,"_47":48,"_46":14,"_148":70,"_44":174,"_13":74,"_40":52,"_42":-5,"_30":31,"_152":-5,"_33":175},{"_54":167,"_38":168,"_36":169,"_146":-5,"_47":48,"_46":170,"_148":70,"_44":171,"_13":74,"_40":52,"_42":-5,"_30":31,"_152":-5,"_33":172},{"_54":161,"_38":162,"_36":163,"_146":-5,"_47":48,"_46":164,"_148":70,"_44":165,"_13":74,"_40":52,"_42":-5,"_30":31,"_152":-5,"_33":166},{"_54":154,"_38":155,"_36":156,"_146":-5,"_47":48,"_46":157,"_148":31,"_44":158,"_13":74,"_40":27,"_42":159,"_30":31,"_152":-5,"_33":160},{"_54":144,"_38":145,"_36":68,"_146":-5,"_47":48,"_46":147,"_148":70,"_44":149,"_13":74,"_40":150,"_42":151,"_30":31,"_152":-5,"_33":153},"7e9097b6-3831-11f1-980a-42b51c65c3df","main.ts","parentId",1,"latest",["D",1776192065301],"http","/**\n * Discord Emoji-Bewerbungssystem Bot\n * \n * Interactions Endpoint - Handles Discord slash commands and button interactions.\n * Set this URL as your bot's INTERACTIONS ENDPOINT URL in Discord Developer Portal.\n * \n * Required env vars:\n * - DISCORD_BOT_TOKEN\n * - DISCORD_PUBLIC_KEY\n * - DISCORD_APPLICATION_ID\n */\n\nimport { verifyDiscordRequest } from \"./discord/verify.ts\";\nimport { handleInteraction } from \"./discord/handler.ts\";\n\nexport default async function(req: Request): Promise {\n if (req.method === \"GET\") {\n return new Response(\"🤖 Discord Emoji-Bewerbungssystem Bot is running!\", {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n // Verify the request is from Discord\n const publicKey = Deno.env.get(\"DISCORD_PUBLIC_KEY\");\n if (!publicKey) {\n return new Response(\"Missing DISCORD_PUBLIC_KEY\", { status: 500 });\n }\n\n const body = await req.text();\n const signature = req.headers.get(\"x-signature-ed25519\");\n const timestamp = req.headers.get(\"x-signature-timestamp\");\n\n if (!signature || !timestamp) {\n return new Response(\"Missing signature headers\", { status: 401 });\n }\n\n const isValid = await verifyDiscordRequest(body, signature, timestamp, publicKey);\n if (!isValid) {\n return new Response(\"Invalid signature\", { status: 401 });\n }\n\n const interaction = JSON.parse(body);\n\n // PING - Discord verification\n if (interaction.type === 1) {\n return Response.json({ type: 1 });\n }\n\n // Handle slash commands (type 2), buttons (type 3), modals (type 5)\n return handleInteraction(interaction);\n}\n","label",[145],"8074ac66-3831-11f1-81ab-42b51c65c3df","README.md","8074ad38-3831-11f1-81ab-42b51c65c3df",2,["D",1776192068461],"# discord-emoji-apply-bot",[155],"82842c7a-3831-11f1-980a-42b51c65c3df","discord","edf9ef2f-dca3-4f2c-9269-8df6b96b33e2",3,["D",1776192071914],[162],"96784f2c-3831-11f1-b0ca-42b51c65c3df","database","8037ee09-94a8-4c55-885e-f98c41a82cbb",5,["D",1776192105406],[168],"d52acbb4-3831-11f1-9b40-42b51c65c3df",["D",1776192210594],[50],"pulls","branches","forks","envVars",{"_183":74,"_185":74},"connections",{"_183":74,"_184":74},"count","unfilledCount","emptyCount",{"_54":173,"_38":50,"_36":51,"_146":-5,"_47":48,"_46":14,"_148":70,"_44":281,"_13":74,"_40":52,"_42":-5,"_30":31,"_152":-5,"_201":282,"_33":283},{"_54":277,"_38":39,"_36":37,"_146":51,"_47":48,"_46":14,"_148":70,"_44":278,"_13":74,"_40":41,"_42":43,"_30":31,"_152":-5,"_201":279,"_33":280},{"_54":167,"_38":168,"_36":169,"_146":-5,"_47":48,"_46":170,"_148":70,"_44":274,"_13":74,"_40":52,"_42":-5,"_30":31,"_152":-5,"_201":275,"_33":276},{"_54":266,"_38":267,"_36":268,"_146":169,"_47":48,"_46":269,"_148":70,"_44":270,"_13":147,"_40":211,"_42":271,"_30":31,"_152":-5,"_201":272,"_33":273},{"_54":161,"_38":162,"_36":163,"_146":-5,"_47":48,"_46":164,"_148":70,"_44":263,"_13":74,"_40":52,"_42":-5,"_30":31,"_152":-5,"_201":264,"_33":265},{"_54":255,"_38":256,"_36":257,"_146":163,"_47":48,"_46":258,"_148":70,"_44":259,"_13":147,"_40":211,"_42":260,"_30":31,"_152":-5,"_201":261,"_33":262},{"_54":247,"_38":248,"_36":249,"_146":163,"_47":48,"_46":250,"_148":70,"_44":251,"_13":74,"_40":211,"_42":252,"_30":31,"_152":-5,"_201":253,"_33":254},{"_54":239,"_38":240,"_36":241,"_146":163,"_47":48,"_46":242,"_148":70,"_44":243,"_13":74,"_40":211,"_42":244,"_30":31,"_152":-5,"_201":245,"_33":246},{"_54":231,"_38":232,"_36":233,"_146":163,"_47":48,"_46":234,"_148":70,"_44":235,"_13":74,"_40":211,"_42":236,"_30":31,"_152":-5,"_201":237,"_33":238},{"_54":223,"_38":224,"_36":225,"_146":163,"_47":48,"_46":226,"_148":31,"_44":227,"_13":74,"_40":211,"_42":228,"_30":31,"_152":-5,"_201":229,"_33":230},{"_54":215,"_38":216,"_36":217,"_146":163,"_47":48,"_46":218,"_148":70,"_44":219,"_13":74,"_40":211,"_42":220,"_30":31,"_152":-5,"_201":221,"_33":222},{"_54":207,"_38":208,"_36":209,"_146":163,"_47":48,"_46":164,"_148":70,"_44":210,"_13":74,"_40":211,"_42":212,"_30":31,"_152":-5,"_201":213,"_33":214},{"_54":154,"_38":155,"_36":156,"_146":-5,"_47":48,"_46":157,"_148":31,"_44":204,"_13":74,"_40":27,"_42":159,"_30":31,"_152":-5,"_201":205,"_33":206},{"_54":144,"_38":145,"_36":68,"_146":-5,"_47":48,"_46":147,"_148":70,"_44":200,"_13":74,"_40":150,"_42":151,"_30":31,"_152":-5,"_201":202,"_33":203},["D",1776192065301],"children",[],[145],["D",1776192068461],[],[155],"82841fa0-3831-11f1-980a-42b51c65c3df","verify.ts","8284204a-3831-11f1-980a-42b51c65c3df",["D",1776192071914],"script","/**\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",[],[162,208],"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",[],[162,216],"9b419b12-3831-11f1-b0ca-42b51c65c3df","handler.ts","9b419be4-3831-11f1-b0ca-42b51c65c3df",6,["D",1776192113439],"/**\n * Main interaction handler - routes to commands and buttons\n */\n\nimport { initDatabase } from \"../database/schema.ts\";\nimport { handleSlashCommand } from \"./commands.ts\";\nimport { handleButton } from \"./buttons.ts\";\n\n// Interaction types\nconst INTERACTION_TYPE = {\n PING: 1,\n APPLICATION_COMMAND: 2,\n MESSAGE_COMPONENT: 3,\n AUTOCOMPLETE: 4,\n MODAL_SUBMIT: 5,\n};\n\n// Response types \nconst RESPONSE_TYPE = {\n PONG: 1,\n CHANNEL_MESSAGE: 4,\n DEFERRED_CHANNEL_MESSAGE: 5,\n DEFERRED_UPDATE: 6,\n UPDATE_MESSAGE: 7,\n};\n\nexport async function handleInteraction(interaction: any): Promise {\n await initDatabase();\n\n try {\n switch (interaction.type) {\n case INTERACTION_TYPE.APPLICATION_COMMAND:\n return handleSlashCommand(interaction);\n\n case INTERACTION_TYPE.MESSAGE_COMPONENT:\n return handleButton(interaction);\n\n default:\n return Response.json({\n type: RESPONSE_TYPE.CHANNEL_MESSAGE,\n data: { content: \"❌ Unbekannter Interaction-Typ.\", flags: 64 },\n });\n }\n } catch (error) {\n console.error(\"Interaction handler error:\", error);\n return Response.json({\n type: RESPONSE_TYPE.CHANNEL_MESSAGE,\n data: { content: `❌ Fehler: ${error.message}`, flags: 64 },\n });\n }\n}\n",[],[162,224],"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",[],[162,232],"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",[],[162,240],"c3903bc8-3831-11f1-9b40-42b51c65c3df","buttons.ts","c3903cb8-3831-11f1-9b40-42b51c65c3df",10,["D",1776192181054],"/**\n * Button interaction handler\n * Handles accept/reject buttons from admin review channel\n */\n\nimport { addRole, sendMessage, editMessage, followUpMessage } from \"./api.ts\";\nimport {\n getApplicationById,\n updateApplicationStatus,\n getGuildConfig,\n getEmojiRole,\n} from \"../database/schema.ts\";\n\nexport async function handleButton(interaction: any): Promise {\n const { data, guild_id, member, message } = interaction;\n const customId = data.custom_id;\n\n // Format: accept_ or reject_\n const [action, appIdStr] = customId.split(\"_\");\n const appId = parseInt(appIdStr);\n\n if (![\"accept\", \"reject\"].includes(action) || isNaN(appId)) {\n return ephemeral(\"❌ Ungültige Interaktion.\");\n }\n\n // Permission check\n const permissions = BigInt(member?.permissions || \"0\");\n if (!(permissions & 0x20n)) {\n return ephemeral(\"❌ Du benötigst die **Server verwalten** Berechtigung.\");\n }\n\n const application = await getApplicationById(appId);\n if (!application) {\n return ephemeral(\"❌ Bewerbung nicht gefunden.\");\n }\n\n if (application.status !== \"pending\") {\n return ephemeral(`❌ Diese Bewerbung wurde bereits **${application.status === \"accepted\" ? \"akzeptiert\" : \"abgelehnt\"}**.`);\n }\n\n const config = await getGuildConfig(guild_id);\n if (!config) {\n return ephemeral(\"❌ Server-Konfiguration nicht gefunden.\");\n }\n\n const adminUser = member.user;\n const userId = application.user_id as string;\n const roleId = application.role_id as string;\n const emoji = application.emoji as string;\n\n if (action === \"accept\") {\n // Add role to user\n try {\n await addRole(guild_id, userId, roleId);\n } catch (e) {\n console.error(\"Failed to add role:\", e);\n return ephemeral(`❌ Konnte die Rolle nicht hinzufügen: ${e.message}`);\n }\n\n await updateApplicationStatus(appId, \"accepted\");\n\n // Update the admin message\n const updatedEmbed = {\n ...message.embeds[0],\n color: 0x57F287,\n fields: [\n ...message.embeds[0].fields,\n { name: \"✅ Status\", value: `Akzeptiert von <@${adminUser.id}>`, inline: false },\n ],\n };\n\n // Log\n try {\n await sendMessage(config.log_channel_id as string, {\n embeds: [{\n title: \"✅ Bewerbung akzeptiert\",\n color: 0x57F287,\n fields: [\n { name: \"Bewerber\", value: `<@${userId}>`, inline: true },\n { name: \"Rolle\", value: `<@&${roleId}>`, inline: true },\n { name: \"Emoji\", value: emoji, inline: true },\n { name: \"Akzeptiert von\", value: `<@${adminUser.id}>`, inline: true },\n ],\n timestamp: new Date().toISOString(),\n }],\n });\n } catch (e) {\n console.error(\"Log error:\", e);\n }\n\n // Respond by updating the message (type 7 = UPDATE_MESSAGE)\n return Response.json({\n type: 7,\n data: {\n embeds: [updatedEmbed],\n components: [\n {\n type: 1,\n components: [\n {\n type: 2,\n style: 3,\n label: `✅ Akzeptiert von ${adminUser.username}`,\n custom_id: `done_${appId}`,\n disabled: true,\n },\n ],\n },\n ],\n },\n });\n } else {\n // Reject\n await updateApplicationStatus(appId, \"rejected\");\n\n const updatedEmbed = {\n ...message.embeds[0],\n color: 0xED4245,\n fields: [\n ...message.embeds[0].fields,\n { name: \"❌ Status\", value: `Abgelehnt von <@${adminUser.id}>`, inline: false },\n ],\n };\n\n // Log\n try {\n await sendMessage(config.log_channel_id as string, {\n embeds: [{\n title: \"❌ Bewerbung abgelehnt\",\n color: 0xED4245,\n fields: [\n { name: \"Bewerber\", value: `<@${userId}>`, inline: true },\n { name: \"Rolle\", value: `<@&${roleId}>`, inline: true },\n { name: \"Emoji\", value: emoji, inline: true },\n { name: \"Abgelehnt von\", value: `<@${adminUser.id}>`, inline: true },\n ],\n timestamp: new Date().toISOString(),\n }],\n });\n } catch (e) {\n console.error(\"Log error:\", e);\n }\n\n return Response.json({\n type: 7,\n data: {\n embeds: [updatedEmbed],\n components: [\n {\n type: 1,\n components: [\n {\n type: 2,\n style: 4,\n label: `❌ Abgelehnt von ${adminUser.username}`,\n custom_id: `done_${appId}`,\n disabled: true,\n },\n ],\n },\n ],\n },\n });\n }\n}\n\nfunction ephemeral(content: string): Response {\n return Response.json({\n type: 4,\n data: { content, flags: 64 },\n });\n}\n",[],[162,248],"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",[],[162,256],["D",1776192071914],[191,192,193,194,195,196,197],[162],"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",[],[168,267],["D",1776192105406],[189],[168],"d52aa904-3831-11f1-9b40-42b51c65c3df",["D",1776192210594],[],[50,39],["D",1776192210594],[187],[50],["D",1776192046430],{"_108":107,"_116":112},{"_108":107,"_109":110,"_111":112,"_19":-5,"_113":114,"_115":31},{"_13":97,"_38":98,"_54":48,"_99":55,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":56,"_106":107},"ctx",{"_90":-5,"_136":321,"_322":323,"_324":325,"_326":31,"_327":31,"_328":31,"_329":70,"_330":-5,"_331":-7,"_332":-7,"_333":74,"_334":31,"_335":31,"_336":-5,"_337":31,"_338":31,"_339":31,"_340":-5},"ENV",{"_292":293,"_294":295,"_296":98,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v13