[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_265":266,"_267":268},"routes/_app.x.$handle.$name",{"_102":101,"_37":50,"_111":92,"_32":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_26":-5,"_123":-5,"_124":-5,"_125":30,"_126":127,"_128":64,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":30},"version",12,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","561e7b96-e640-4c96-b6e3-271110bbbc1c","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","discord/embeds.ts","latestPath","fileId","d29f42a8-3831-11f1-84db-42b51c65c3df","name","embeds.ts","fileType","script","content","/**\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","createdAt",["D",1776192206333],"branchVersion","branchId","73503406-3831-11f1-a548-42b51c65c3df","id","734f95d2-3831-11f1-a548-42b51c65c3df","discord-emoji-apply-bot",["D",1776192046430],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Discord Bot: Emoji-Bewerbungssystem mit Admin-Panel","imageUrl","40d60734-a91c-4cc2-9305-b592a890bee5","pinnedFileId","7e90986a-3831-11f1-980a-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d8d4b-5635-76cf-ac0c-e26664ce89f6","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_110":106},"org",{"_102":101,"_103":104,"_105":106,"_19":-5,"_107":108,"_109":30},"branch",{"_13":91,"_37":92,"_48":47,"_93":49,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":50,"_100":101},"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=1789581599&sig=86b41c8e10aeb694fded220b9855a9a783ec4150d50f42cea53bb1a61769c393","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":261,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":262,"_86":263,"_88":264,"_90":30},"tree",[177,179,187,188],"files",[177,178,179,180,181,182,183,184,185,186,187,188],"counts",{"_167":68,"_168":140,"_169":68,"_170":171,"_172":173},"contents",[133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":161,"_37":162,"_35":163,"_139":-5,"_46":47,"_45":164,"_141":64,"_43":165,"_13":68,"_39":159,"_41":-5,"_29":30,"_145":-5,"_32":166},{"_48":154,"_37":155,"_35":156,"_139":-5,"_46":47,"_45":157,"_141":64,"_43":158,"_13":68,"_39":159,"_41":-5,"_29":30,"_145":-5,"_32":160},{"_48":147,"_37":148,"_35":149,"_139":-5,"_46":47,"_45":150,"_141":30,"_43":151,"_13":68,"_39":26,"_41":152,"_29":30,"_145":-5,"_32":153},{"_48":137,"_37":138,"_35":62,"_139":-5,"_46":47,"_45":140,"_141":64,"_43":142,"_13":68,"_39":143,"_41":144,"_29":30,"_145":-5,"_32":146},"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",[138],"8074ac66-3831-11f1-81ab-42b51c65c3df","README.md","8074ad38-3831-11f1-81ab-42b51c65c3df",2,["D",1776192068461],"# discord-emoji-apply-bot",[148],"82842c7a-3831-11f1-980a-42b51c65c3df","discord","edf9ef2f-dca3-4f2c-9269-8df6b96b33e2",3,["D",1776192071914],"directory",[155],"96784f2c-3831-11f1-b0ca-42b51c65c3df","database","8037ee09-94a8-4c55-885e-f98c41a82cbb",5,["D",1776192105406],[162],"pulls","branches","forks","envVars",{"_174":68,"_176":68},"connections",{"_174":68,"_175":68},"count","unfilledCount","emptyCount",{"_48":161,"_37":162,"_35":163,"_139":-5,"_46":47,"_45":164,"_141":64,"_43":258,"_13":68,"_39":159,"_41":-5,"_29":30,"_145":-5,"_190":259,"_32":260},{"_48":250,"_37":251,"_35":252,"_139":163,"_46":47,"_45":253,"_141":64,"_43":254,"_13":140,"_39":40,"_41":255,"_29":30,"_145":-5,"_190":256,"_32":257},{"_48":154,"_37":155,"_35":156,"_139":-5,"_46":47,"_45":157,"_141":64,"_43":247,"_13":68,"_39":159,"_41":-5,"_29":30,"_145":-5,"_190":248,"_32":249},{"_48":239,"_37":240,"_35":241,"_139":156,"_46":47,"_45":242,"_141":64,"_43":243,"_13":140,"_39":40,"_41":244,"_29":30,"_145":-5,"_190":245,"_32":246},{"_48":231,"_37":232,"_35":233,"_139":156,"_46":47,"_45":234,"_141":64,"_43":235,"_13":68,"_39":40,"_41":236,"_29":30,"_145":-5,"_190":237,"_32":238},{"_48":223,"_37":224,"_35":225,"_139":156,"_46":47,"_45":226,"_141":64,"_43":227,"_13":68,"_39":40,"_41":228,"_29":30,"_145":-5,"_190":229,"_32":230},{"_48":219,"_37":38,"_35":36,"_139":156,"_46":47,"_45":14,"_141":64,"_43":220,"_13":68,"_39":40,"_41":42,"_29":30,"_145":-5,"_190":221,"_32":222},{"_48":211,"_37":212,"_35":213,"_139":156,"_46":47,"_45":214,"_141":30,"_43":215,"_13":68,"_39":40,"_41":216,"_29":30,"_145":-5,"_190":217,"_32":218},{"_48":203,"_37":204,"_35":205,"_139":156,"_46":47,"_45":206,"_141":64,"_43":207,"_13":68,"_39":40,"_41":208,"_29":30,"_145":-5,"_190":209,"_32":210},{"_48":196,"_37":197,"_35":198,"_139":156,"_46":47,"_45":157,"_141":64,"_43":199,"_13":68,"_39":40,"_41":200,"_29":30,"_145":-5,"_190":201,"_32":202},{"_48":147,"_37":148,"_35":149,"_139":-5,"_46":47,"_45":150,"_141":30,"_43":193,"_13":68,"_39":26,"_41":152,"_29":30,"_145":-5,"_190":194,"_32":195},{"_48":137,"_37":138,"_35":62,"_139":-5,"_46":47,"_45":140,"_141":64,"_43":189,"_13":68,"_39":143,"_41":144,"_29":30,"_145":-5,"_190":191,"_32":192},["D",1776192065301],"children",[],[138],["D",1776192068461],[],[148],"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",[],[155,197],"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",[],[155,204],"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",[],[155,212],"d29f41fe-3831-11f1-84db-42b51c65c3df",["D",1776192206333],[],[155,38],"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",[],[155,224],"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",[],[155,232],"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",[],[155,240],["D",1776192071914],[180,181,182,183,184,185,186],[155],"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",[],[162,251],["D",1776192105406],[178],[162],["D",1776192046430],{"_102":101,"_110":106},{"_102":101,"_103":104,"_105":106,"_19":-5,"_107":108,"_109":30},{"_13":91,"_37":92,"_48":47,"_93":49,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":50,"_100":101},"ctx",{"_84":-5,"_130":298,"_299":300,"_301":302,"_303":30,"_304":30,"_305":30,"_306":64,"_307":-5,"_308":-7,"_309":-7,"_310":68,"_311":30,"_312":30,"_313":-5,"_314":30,"_315":30,"_316":30,"_317":-5},"ENV",{"_269":270,"_271":272,"_273":92,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297},"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 · v12