import discord from discord.ext import commands from discord.ui import Button, View import os from dotenv import load_dotenv import asyncio import logging from datetime import datetime import aiosqlite import json import io load_dotenv() DEFAULT_CONFIG = { 'ticket_category': None, 'log_channel': None, 'support_roles': [], 'admin_roles': [], 'language': 'en', 'ticket_counter': 0, 'max_tickets_per_user': 3, 'transcript_enabled': True } COLORS = { 'success': discord.Color.green(), 'error': discord.Color.red(), 'info': discord.Color.blue(), 'warning': discord.Color.orange(), 'ticket': discord.Color.purple() } EMOJIS = { 'ticket': '🎫', 'lock': '🔒', 'unlock': '🔓', 'close': '❌', 'claim': '✋', 'log': '📝', 'success': '✅', 'error': '❌', 'warning': '⚠️' } TRANSLATIONS = { 'en': { "ticket_title": "Ticket #{number}", "ticket_description": "Thank you for creating a ticket! Our support team will be with you shortly.\n\nPlease describe your issue in detail.", "ticket_creator": "Created by", "ticket_status": "Status", "status_open": "🟢 Open", "ticket_footer": "Click the buttons below to manage this ticket", "panel_title": "Support Ticket System", "panel_description": "Need help? Create a support ticket by clicking the button below!\n\nOur support team will assist you as soon as possible.", "panel_how_to_title": "How to create a ticket", "panel_how_to_content": "Click the **Create Ticket** button below to open a private support channel.", "panel_footer": "Ticket System • Click the button to get started", "log_title": "Ticket Activity Log", "log_action": "Action", "log_user": "User", "log_ticket": "Ticket", "log_details": "Details", "log_action_created": "Ticket Created", "log_action_closed": "Ticket Closed", "log_action_claimed": "Ticket Claimed", "log_action_user_added": "User Added", "log_action_user_removed": "User Removed", "log_details_created": "New ticket opened", "transcript_title": "Ticket #{number} Transcript", "transcript_description": "This ticket contained {count} messages.", "stats_title": "Ticket Statistics", "stats_description": "Statistics for {name}", "stats_total": "Total Tickets", "stats_open": "Open Tickets", "stats_closed": "Closed Tickets", "error_max_tickets": "You already have {max} open tickets! Please close one before creating another.", "error_no_category": "Ticket category not configured. Contact an administrator.", "error_invalid_category": "Invalid ticket category. Please reconfigure.", "error_not_ticket": "This command can only be used in ticket channels.", "error_no_permission": "You don't have permission to do that.", "error_role_exists": "This role is already configured.", "error_role_not_found": "This role is not configured.", "error_invalid_max": "Maximum tickets must be between 1 and 10.", "success_ticket_created": "Ticket created! {channel}", "success_ticket_closing": "This ticket will be closed in 10 seconds...", "success_ticket_claimed": "Ticket claimed by {user}", "success_user_added": "{user} has been added to this ticket.", "success_user_removed": "{user} has been removed from this ticket.", "success_category_set": "Ticket category set to: {category}", "success_log_set": "Log channel set to: {channel}", "success_support_added": "Support role added: {role}", "success_support_removed": "Support role removed: {role}", "success_admin_added": "Admin role added: {role}", "success_admin_removed": "Admin role removed: {role}", "success_language_set": "Language set to English!", "success_max_set": "Maximum tickets per user set to {max}", "success_closeall": "Successfully closed {count} tickets.", "closeall_title": "Close All Tickets", "closeall_description": "Are you sure you want to close ALL open tickets? This action cannot be undone.\nReact with ✅ to confirm or ❌ to cancel.", "closeall_cancelled": "Close all tickets cancelled.", "closeall_timeout": "Close all tickets timed out.", "help_title": "Ticket Bot Help", "help_description": "Welcome to the Ticket Bot! Here are the available commands:", "help_commands": "Commands", "help_panel": "Create a ticket panel (Admin only)", "help_add": "Add a user to the ticket", "help_remove": "Remove a user from the ticket", "help_stats": "View ticket statistics", "help_setup": "View setup commands", "help_footer": "For more help, contact an administrator", "setup_title": "Ticket Bot Setup", "setup_description": "Configure the ticket system for your server:", "setup_commands": "Setup Commands", "setup_category": "Set the category for tickets", "setup_log": "Set the log channel", "setup_support_role": "Add a support role", "setup_remove_support": "Remove a support role", "setup_admin_role": "Add an admin role", "setup_remove_admin": "Remove an admin role", "setup_language": "Set the language", "setup_max_tickets": "Set max tickets per user", "setup_languages": "Available Languages" }, 'es': { "ticket_title": "Ticket #{number}", "ticket_description": "¡Gracias por crear un ticket! Nuestro equipo de soporte estará contigo en breve.\n\nPor favor, describe tu problema en detalle.", "ticket_creator": "Creado por", "ticket_status": "Estado", "status_open": "🟢 Abierto", "ticket_footer": "Haz clic en los botones de abajo para gestionar este ticket", "panel_title": "Sistema de Tickets de Soporte", "panel_description": "¿Necesitas ayuda? ¡Crea un ticket de soporte haciendo clic en el botón de abajo!\n\nNuestro equipo de soporte te ayudará lo antes posible.", "panel_how_to_title": "Cómo crear un ticket", "panel_how_to_content": "Haz clic en el botón **Crear Ticket** de abajo para abrir un canal de soporte privado.", "panel_footer": "Sistema de Tickets • Haz clic en el botón para comenzar", "log_title": "Registro de Actividad del Ticket", "log_action": "Acción", "log_user": "Usuario", "log_ticket": "Ticket", "log_details": "Detalles", "log_action_created": "Ticket Creado", "log_action_closed": "Ticket Cerrado", "log_action_claimed": "Ticket Reclamado", "log_action_user_added": "Usuario Añadido", "log_action_user_removed": "Usuario Eliminado", "log_details_created": "Nuevo ticket abierto", "transcript_title": "Transcripción del Ticket #{number}", "transcript_description": "Este ticket contenía {count} mensajes.", "stats_title": "Estadísticas de Tickets", "stats_description": "Estadísticas para {name}", "stats_total": "Tickets Totales", "stats_open": "Tickets Abiertos", "stats_closed": "Tickets Cerrados", "error_max_tickets": "¡Ya tienes {max} tickets abiertos! Por favor, cierra uno antes de crear otro.", "error_no_category": "Categoría de tickets no configurada. Contacta a un administrador.", "error_invalid_category": "Categoría de tickets inválida. Por favor, reconfigura.", "error_not_ticket": "Este comando solo se puede usar en canales de tickets.", "error_no_permission": "No tienes permiso para hacer eso.", "error_role_exists": "Este rol ya está configurado.", "error_role_not_found": "Este rol no está configurado.", "error_invalid_max": "El máximo de tickets debe estar entre 1 y 10.", "success_ticket_created": "¡Ticket creado! {channel}", "success_ticket_closing": "Este ticket se cerrará en 10 segundos...", "success_ticket_claimed": "Ticket reclamado por {user}", "success_user_added": "{user} ha sido añadido a este ticket.", "success_user_removed": "{user} ha sido eliminado de este ticket.", "success_category_set": "Categoría de tickets establecida en: {category}", "success_log_set": "Canal de registros establecido en: {channel}", "success_support_added": "Rol de soporte añadido: {role}", "success_support_removed": "Rol de soporte eliminado: {role}", "success_admin_added": "Rol de administrador añadido: {role}", "success_admin_removed": "Rol de administrador eliminado: {role}", "success_language_set": "¡Idioma establecido en Español!", "success_max_set": "Máximo de tickets por usuario establecido en {max}", "success_closeall": "Se cerraron exitosamente {count} tickets.", "closeall_title": "Cerrar Todos los Tickets", "closeall_description": "¿Estás seguro de que quieres cerrar TODOS los tickets abiertos? Esta acción no se puede deshacer.\nReacciona con ✅ para confirmar o ❌ para cancelar.", "closeall_cancelled": "Cerrar todos los tickets cancelado.", "closeall_timeout": "Cerrar todos los tickets expiró.", "help_title": "Ayuda del Bot de Tickets", "help_description": "¡Bienvenido al Bot de Tickets! Aquí están los comandos disponibles:", "help_commands": "Comandos", "help_panel": "Crear un panel de tickets (Solo administradores)", "help_add": "Añadir un usuario al ticket", "help_remove": "Eliminar un usuario del ticket", "help_stats": "Ver estadísticas de tickets", "help_setup": "Ver comandos de configuración", "help_footer": "Para más ayuda, contacta a un administrador", "setup_title": "Configuración del Bot de Tickets", "setup_description": "Configura el sistema de tickets para tu servidor:", "setup_commands": "Comandos de Configuración", "setup_category": "Establecer la categoría para tickets", "setup_log": "Establecer el canal de registros", "setup_support_role": "Añadir un rol de soporte", "setup_remove_support": "Eliminar un rol de soporte", "setup_admin_role": "Añadir un rol de administrador", "setup_remove_admin": "Eliminar un rol de administrador", "setup_language": "Establecer el idioma", "setup_max_tickets": "Establecer máximo de tickets por usuario", "setup_languages": "Idiomas Disponibles" }, 'fr': { "ticket_title": "Ticket #{number}", "ticket_description": "Merci d'avoir créé un ticket ! Notre équipe de support sera avec vous sous peu.\n\nVeuillez décrire votre problème en détail.", "ticket_creator": "Créé par", "ticket_status": "Statut", "status_open": "🟢 Ouvert", "ticket_footer": "Cliquez sur les boutons ci-dessous pour gérer ce ticket", "panel_title": "Système de Tickets de Support", "panel_description": "Besoin d'aide ? Créez un ticket de support en cliquant sur le bouton ci-dessous !\n\nNotre équipe de support vous assistera dès que possible.", "panel_how_to_title": "Comment créer un ticket", "panel_how_to_content": "Cliquez sur le bouton **Créer un Ticket** ci-dessous pour ouvrir un canal de support privé.", "panel_footer": "Système de Tickets • Cliquez sur le bouton pour commencer", "log_title": "Journal d'Activité du Ticket", "log_action": "Action", "log_user": "Utilisateur", "log_ticket": "Ticket", "log_details": "Détails", "log_action_created": "Ticket Créé", "log_action_closed": "Ticket Fermé", "log_action_claimed": "Ticket Réclamé", "log_action_user_added": "Utilisateur Ajouté", "log_action_user_removed": "Utilisateur Retiré", "log_details_created": "Nouveau ticket ouvert", "transcript_title": "Transcription du Ticket #{number}", "transcript_description": "Ce ticket contenait {count} messages.", "stats_title": "Statistiques des Tickets", "stats_description": "Statistiques pour {name}", "stats_total": "Tickets Totaux", "stats_open": "Tickets Ouverts", "stats_closed": "Tickets Fermés", "error_max_tickets": "Vous avez déjà {max} tickets ouverts ! Veuillez en fermer un avant d'en créer un autre.", "error_no_category": "Catégorie de tickets non configurée. Contactez un administrateur.", "error_invalid_category": "Catégorie de tickets invalide. Veuillez reconfigurer.", "error_not_ticket": "Cette commande ne peut être utilisée que dans les canaux de tickets.", "error_no_permission": "Vous n'avez pas la permission de faire cela.", "error_role_exists": "Ce rôle est déjà configuré.", "error_role_not_found": "Ce rôle n'est pas configuré.", "error_invalid_max": "Le maximum de tickets doit être entre 1 et 10.", "success_ticket_created": "Ticket créé ! {channel}", "success_ticket_closing": "Ce ticket sera fermé dans 10 secondes...", "success_ticket_claimed": "Ticket réclamé par {user}", "success_user_added": "{user} a été ajouté à ce ticket.", "success_user_removed": "{user} a été retiré de ce ticket.", "success_category_set": "Catégorie de tickets définie sur : {category}", "success_log_set": "Canal de journal défini sur : {channel}", "success_support_added": "Rôle de support ajouté : {role}", "success_support_removed": "Rôle de support retiré : {role}", "success_admin_added": "Rôle d'administrateur ajouté : {role}", "success_admin_removed": "Rôle d'administrateur retiré : {role}", "success_language_set": "Langue définie sur Français !", "success_max_set": "Maximum de tickets par utilisateur défini sur {max}", "success_closeall": "{count} tickets fermés avec succès.", "closeall_title": "Fermer Tous les Tickets", "closeall_description": "Êtes-vous sûr de vouloir fermer TOUS les tickets ouverts ? Cette action ne peut pas être annulée.\nRéagissez avec ✅ pour confirmer ou ❌ pour annuler.", "closeall_cancelled": "Fermeture de tous les tickets annulée.", "closeall_timeout": "Fermeture de tous les tickets expirée.", "help_title": "Aide du Bot de Tickets", "help_description": "Bienvenue sur le Bot de Tickets ! Voici les commandes disponibles :", "help_commands": "Commandes", "help_panel": "Créer un panneau de tickets (Admin seulement)", "help_add": "Ajouter un utilisateur au ticket", "help_remove": "Retirer un utilisateur du ticket", "help_stats": "Voir les statistiques des tickets", "help_setup": "Voir les commandes de configuration", "help_footer": "Pour plus d'aide, contactez un administrateur", "setup_title": "Configuration du Bot de Tickets", "setup_description": "Configurez le système de tickets pour votre serveur :", "setup_commands": "Commandes de Configuration", "setup_category": "Définir la catégorie pour les tickets", "setup_log": "Définir le canal de journal", "setup_support_role": "Ajouter un rôle de support", "setup_remove_support": "Retirer un rôle de support", "setup_admin_role": "Ajouter un rôle d'administrateur", "setup_remove_admin": "Retirer un rôle d'administrateur", "setup_language": "Définir la langue", "setup_max_tickets": "Définir le maximum de tickets par utilisateur", "setup_languages": "Langues Disponibles" }, 'de': { "ticket_title": "Ticket #{number}", "ticket_description": "Vielen Dank für die Erstellung eines Tickets! Unser Support-Team wird sich in Kürze bei Ihnen melden.\n\nBitte beschreiben Sie Ihr Problem detailliert.", "ticket_creator": "Erstellt von", "ticket_status": "Status", "status_open": "🟢 Offen", "ticket_footer": "Klicken Sie auf die Schaltflächen unten, um dieses Ticket zu verwalten", "panel_title": "Support-Ticket-System", "panel_description": "Benötigen Sie Hilfe? Erstellen Sie ein Support-Ticket, indem Sie auf die Schaltfläche unten klicken!\n\nUnser Support-Team wird Ihnen so schnell wie möglich helfen.", "panel_how_to_title": "So erstellen Sie ein Ticket", "panel_how_to_content": "Klicken Sie auf die Schaltfläche **Ticket Erstellen** unten, um einen privaten Support-Kanal zu öffnen.", "panel_footer": "Ticket-System • Klicken Sie auf die Schaltfläche, um zu beginnen", "log_title": "Ticket-Aktivitätsprotokoll", "log_action": "Aktion", "log_user": "Benutzer", "log_ticket": "Ticket", "log_details": "Details", "log_action_created": "Ticket Erstellt", "log_action_closed": "Ticket Geschlossen", "log_action_claimed": "Ticket Beansprucht", "log_action_user_added": "Benutzer Hinzugefügt", "log_action_user_removed": "Benutzer Entfernt", "log_details_created": "Neues Ticket geöffnet", "transcript_title": "Ticket #{number} Transkript", "transcript_description": "Dieses Ticket enthielt {count} Nachrichten.", "stats_title": "Ticket-Statistiken", "stats_description": "Statistiken für {name}", "stats_total": "Gesamttickets", "stats_open": "Offene Tickets", "stats_closed": "Geschlossene Tickets", "error_max_tickets": "Sie haben bereits {max} offene Tickets! Bitte schließen Sie eines, bevor Sie ein weiteres erstellen.", "error_no_category": "Ticket-Kategorie nicht konfiguriert. Kontaktieren Sie einen Administrator.", "error_invalid_category": "Ungültige Ticket-Kategorie. Bitte neu konfigurieren.", "error_not_ticket": "Dieser Befehl kann nur in Ticket-Kanälen verwendet werden.", "error_no_permission": "Sie haben keine Berechtigung dafür.", "error_role_exists": "Diese Rolle ist bereits konfiguriert.", "error_role_not_found": "Diese Rolle ist nicht konfiguriert.", "error_invalid_max": "Maximale Tickets müssen zwischen 1 und 10 liegen.", "success_ticket_created": "Ticket erstellt! {channel}", "success_ticket_closing": "Dieses Ticket wird in 10 Sekunden geschlossen...", "success_ticket_claimed": "Ticket beansprucht von {user}", "success_user_added": "{user} wurde zu diesem Ticket hinzugefügt.", "success_user_removed": "{user} wurde von diesem Ticket entfernt.", "success_category_set": "Ticket-Kategorie festgelegt auf: {category}", "success_log_set": "Protokollkanal festgelegt auf: {channel}", "success_support_added": "Support-Rolle hinzugefügt: {role}", "success_support_removed": "Support-Rolle entfernt: {role}", "success_admin_added": "Admin-Rolle hinzugefügt: {role}", "success_admin_removed": "Admin-Rolle entfernt: {role}", "success_language_set": "Sprache auf Deutsch eingestellt!", "success_max_set": "Maximale Tickets pro Benutzer auf {max} festgelegt", "success_closeall": "{count} Tickets erfolgreich geschlossen.", "closeall_title": "Alle Tickets Schließen", "closeall_description": "Sind Sie sicher, dass Sie ALLE offenen Tickets schließen möchten? Diese Aktion kann nicht rückgängig gemacht werden.\nReagieren Sie mit ✅ zum Bestätigen oder ❌ zum Abbrechen.", "closeall_cancelled": "Alle Tickets schließen abgebrochen.", "closeall_timeout": "Alle Tickets schließen ist abgelaufen.", "help_title": "Ticket-Bot Hilfe", "help_description": "Willkommen beim Ticket-Bot! Hier sind die verfügbaren Befehle:", "help_commands": "Befehle", "help_panel": "Ein Ticket-Panel erstellen (Nur Admin)", "help_add": "Einen Benutzer zum Ticket hinzufügen", "help_remove": "Einen Benutzer vom Ticket entfernen", "help_stats": "Ticket-Statistiken anzeigen", "help_setup": "Setup-Befehle anzeigen", "help_footer": "Für weitere Hilfe wenden Sie sich an einen Administrator", "setup_title": "Ticket-Bot-Einrichtung", "setup_description": "Konfigurieren Sie das Ticket-System für Ihren Server:", "setup_commands": "Einrichtungsbefehle", "setup_category": "Die Kategorie für Tickets festlegen", "setup_log": "Den Protokollkanal festlegen", "setup_support_role": "Eine Support-Rolle hinzufügen", "setup_remove_support": "Eine Support-Rolle entfernen", "setup_admin_role": "Eine Admin-Rolle hinzufügen", "setup_remove_admin": "Eine Admin-Rolle entfernen", "setup_language": "Die Sprache festlegen", "setup_max_tickets": "Maximale Tickets pro Benutzer festlegen", "setup_languages": "Verfügbare Sprachen" } } def get_text(lang, key, **kwargs): if lang not in TRANSLATIONS: lang = 'en' text = TRANSLATIONS.get(lang, {}).get(key, key) if kwargs: try: text = text.format(**kwargs) except KeyError: pass return text def create_ticket_embed(lang, user, ticket_number): embed = discord.Embed( title=f"{EMOJIS['ticket']} {get_text(lang, 'ticket_title', number=ticket_number)}", description=get_text(lang, 'ticket_description'), color=COLORS['ticket'], timestamp=datetime.utcnow() ) embed.set_author(name=user.display_name, icon_url=user.display_avatar.url) embed.add_field(name=f"{EMOJIS['ticket']} {get_text(lang, 'ticket_creator')}", value=user.mention, inline=True) embed.add_field(name=f"📊 {get_text(lang, 'ticket_status')}", value=get_text(lang, 'status_open'), inline=True) embed.add_field(name="🆔 Ticket Number", value=f"`#{ticket_number:04d}`", inline=True) embed.set_thumbnail(url=user.display_avatar.url) embed.set_footer(text=get_text(lang, 'ticket_footer'), icon_url="https://cdn.discordapp.com/emojis/1234567890.png") return embed def create_panel_embed(lang, guild=None): embed = discord.Embed( title=f"{EMOJIS['ticket']} {get_text(lang, 'panel_title')}", description=f"━━━━━━━━━━━━━━━━━━━\n\n{get_text(lang, 'panel_description')}\n\n━━━━━━━━━━━━━━━━━━━", color=COLORS['info'] ) embed.add_field( name=f"📋 {get_text(lang, 'panel_how_to_title')}", value=f"```\n{get_text(lang, 'panel_how_to_content')}\n```", inline=False ) if guild: embed.set_thumbnail(url=guild.icon.url if guild.icon else None) embed.set_footer(text=get_text(lang, 'panel_footer')) embed.set_image(url="https://i.imgur.com/AfFp7pu.png") return embed def create_success_embed(lang, message, user=None): embed = discord.Embed( title=f"{EMOJIS['success']} Success", description=message, color=COLORS['success'], timestamp=datetime.utcnow() ) if user: embed.set_footer(text=f"Action by {user.display_name}", icon_url=user.display_avatar.url) return embed def create_error_embed(lang, message, user=None): embed = discord.Embed( title=f"{EMOJIS['error']} Error", description=message, color=COLORS['error'], timestamp=datetime.utcnow() ) if user: embed.set_footer(text=f"Requested by {user.display_name}", icon_url=user.display_avatar.url) return embed def create_log_embed(lang, action, user, ticket_channel, details=None): embed = discord.Embed( title=f"{EMOJIS['log']} {get_text(lang, 'log_title')}", color=COLORS['info'], timestamp=datetime.utcnow() ) embed.set_author(name=user.display_name, icon_url=user.display_avatar.url) embed.add_field(name=f"⚡ {get_text(lang, 'log_action')}", value=f"```{action}```", inline=False) embed.add_field(name=f"👤 {get_text(lang, 'log_user')}", value=user.mention, inline=True) embed.add_field(name=f"🎫 {get_text(lang, 'log_ticket')}", value=ticket_channel.mention, inline=True) if details: embed.add_field(name=f"📝 {get_text(lang, 'log_details')}", value=details, inline=False) embed.set_thumbnail(url=user.display_avatar.url) embed.set_footer(text=f"User ID: {user.id} • Ticket: {ticket_channel.name}") return embed def create_transcript_embed(lang, ticket_number, messages_count, user): embed = discord.Embed( title=f"{EMOJIS['log']} {get_text(lang, 'transcript_title', number=ticket_number)}", description=f"━━━━━━━━━━━━━━━━━━━\n\n{get_text(lang, 'transcript_description', count=messages_count)}\n\n━━━━━━━━━━━━━━━━━━━", color=COLORS['info'], timestamp=datetime.utcnow() ) embed.set_author(name=user.display_name, icon_url=user.display_avatar.url) embed.add_field(name=f"👤 {get_text(lang, 'ticket_creator')}", value=user.mention, inline=True) embed.add_field(name="💬 Messages", value=f"`{messages_count}`", inline=True) embed.add_field(name="🆔 Ticket", value=f"`#{ticket_number:04d}`", inline=True) embed.set_thumbnail(url=user.display_avatar.url) embed.set_footer(text=f"Ticket closed • User ID: {user.id}") return embed def create_stats_embed(lang, guild, stats): closed_rate = round((stats['closed'] / stats['total'] * 100) if stats['total'] > 0 else 0, 1) embed = discord.Embed( title=f"📊 {get_text(lang, 'stats_title')}", description=f"**{get_text(lang, 'stats_description', name=guild.name)}**\n━━━━━━━━━━━━━━━━━━━", color=COLORS['info'], timestamp=datetime.utcnow() ) embed.add_field( name=f"🎫 {get_text(lang, 'stats_total')}", value=f"```\n{stats['total']}\n```", inline=True ) embed.add_field( name=f"🟢 {get_text(lang, 'stats_open')}", value=f"```\n{stats['open']}\n```", inline=True ) embed.add_field( name=f"🔒 {get_text(lang, 'stats_closed')}", value=f"```\n{stats['closed']}\n```", inline=True ) embed.add_field( name="📈 Close Rate", value=f"```\n{closed_rate}%\n```", inline=True ) embed.add_field( name="⏰ Average Response", value=f"```\n< 5 min\n```", inline=True ) embed.add_field( name="⭐ Rating", value=f"```\n★★★★★\n```", inline=True ) if guild.icon: embed.set_thumbnail(url=guild.icon.url) embed.set_footer(text=f"{guild.name} • Statistics", icon_url=guild.icon.url if guild.icon else None) return embed class Database: def __init__(self, db_path='tickets.db'): self.db_path = db_path self.connection = None async def initialize(self): self.connection = await aiosqlite.connect(self.db_path) await self._create_tables() async def _create_tables(self): await self.connection.execute(''' CREATE TABLE IF NOT EXISTS guild_config ( guild_id INTEGER PRIMARY KEY, config TEXT NOT NULL ) ''') await self.connection.execute(''' CREATE TABLE IF NOT EXISTS tickets ( ticket_id INTEGER PRIMARY KEY AUTOINCREMENT, guild_id INTEGER NOT NULL, channel_id INTEGER NOT NULL, user_id INTEGER NOT NULL, ticket_number INTEGER NOT NULL, status TEXT DEFAULT 'open', claimed_by INTEGER, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, closed_at TIMESTAMP, close_reason TEXT ) ''') await self.connection.execute(''' CREATE TABLE IF NOT EXISTS ticket_logs ( log_id INTEGER PRIMARY KEY AUTOINCREMENT, ticket_id INTEGER NOT NULL, user_id INTEGER NOT NULL, action TEXT NOT NULL, details TEXT, timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (ticket_id) REFERENCES tickets (ticket_id) ) ''') await self.connection.execute(''' CREATE TABLE IF NOT EXISTS ticket_messages ( message_id INTEGER PRIMARY KEY, ticket_id INTEGER NOT NULL, user_id INTEGER NOT NULL, content TEXT NOT NULL, timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (ticket_id) REFERENCES tickets (ticket_id) ) ''') await self.connection.commit() async def get_guild_config(self, guild_id): async with self.connection.execute('SELECT config FROM guild_config WHERE guild_id = ?', (guild_id,)) as cursor: row = await cursor.fetchone() if row: return json.loads(row[0]) else: await self.create_guild_config(guild_id) return DEFAULT_CONFIG.copy() async def create_guild_config(self, guild_id): config = json.dumps(DEFAULT_CONFIG) await self.connection.execute('INSERT OR IGNORE INTO guild_config (guild_id, config) VALUES (?, ?)', (guild_id, config)) await self.connection.commit() async def update_guild_config(self, guild_id, config): config_json = json.dumps(config) await self.connection.execute('UPDATE guild_config SET config = ? WHERE guild_id = ?', (config_json, guild_id)) await self.connection.commit() async def create_ticket(self, guild_id, channel_id, user_id, ticket_number): cursor = await self.connection.execute('INSERT INTO tickets (guild_id, channel_id, user_id, ticket_number) VALUES (?, ?, ?, ?)', (guild_id, channel_id, user_id, ticket_number)) await self.connection.commit() return cursor.lastrowid async def get_ticket_by_channel(self, channel_id): async with self.connection.execute('SELECT * FROM tickets WHERE channel_id = ? AND status = "open"', (channel_id,)) as cursor: return await cursor.fetchone() async def get_user_open_tickets(self, guild_id, user_id): async with self.connection.execute('SELECT COUNT(*) FROM tickets WHERE guild_id = ? AND user_id = ? AND status = "open"', (guild_id, user_id)) as cursor: row = await cursor.fetchone() return row[0] if row else 0 async def close_ticket(self, ticket_id, reason=None): await self.connection.execute('UPDATE tickets SET status = "closed", closed_at = CURRENT_TIMESTAMP, close_reason = ? WHERE ticket_id = ?', (reason, ticket_id)) await self.connection.commit() async def claim_ticket(self, ticket_id, user_id): await self.connection.execute('UPDATE tickets SET claimed_by = ? WHERE ticket_id = ?', (user_id, ticket_id)) await self.connection.commit() async def add_ticket_log(self, ticket_id, user_id, action, details=None): await self.connection.execute('INSERT INTO ticket_logs (ticket_id, user_id, action, details) VALUES (?, ?, ?, ?)', (ticket_id, user_id, action, details)) await self.connection.commit() async def add_ticket_message(self, message_id, ticket_id, user_id, content): await self.connection.execute('INSERT INTO ticket_messages (message_id, ticket_id, user_id, content) VALUES (?, ?, ?, ?)', (message_id, ticket_id, user_id, content)) await self.connection.commit() async def get_ticket_transcript(self, ticket_id): async with self.connection.execute('SELECT user_id, content, timestamp FROM ticket_messages WHERE ticket_id = ? ORDER BY timestamp ASC', (ticket_id,)) as cursor: return await cursor.fetchall() async def get_guild_stats(self, guild_id): async with self.connection.execute('SELECT COUNT(*) FROM tickets WHERE guild_id = ?', (guild_id,)) as cursor: total = (await cursor.fetchone())[0] async with self.connection.execute('SELECT COUNT(*) FROM tickets WHERE guild_id = ? AND status = "open"', (guild_id,)) as cursor: open_tickets = (await cursor.fetchone())[0] async with self.connection.execute('SELECT COUNT(*) FROM tickets WHERE guild_id = ? AND status = "closed"', (guild_id,)) as cursor: closed = (await cursor.fetchone())[0] return {'total': total, 'open': open_tickets, 'closed': closed} async def close(self): if self.connection: await self.connection.close() class TicketButtons(View): def __init__(self, bot): super().__init__(timeout=None) self.bot = bot @discord.ui.button(label='Create Ticket', style=discord.ButtonStyle.green, custom_id='create_ticket', emoji='🎫') async def create_ticket(self, interaction: discord.Interaction, button: Button): await interaction.response.defer(ephemeral=True) config = await self.bot.db.get_guild_config(interaction.guild.id) lang = config.get('language', 'en') open_tickets = await self.bot.db.get_user_open_tickets(interaction.guild.id, interaction.user.id) max_tickets = config.get('max_tickets_per_user', 3) if open_tickets >= max_tickets: embed = create_error_embed(lang, get_text(lang, 'error_max_tickets', max=max_tickets)) await interaction.followup.send(embed=embed, ephemeral=True) return category_id = config.get('ticket_category') if not category_id: embed = create_error_embed(lang, get_text(lang, 'error_no_category')) await interaction.followup.send(embed=embed, ephemeral=True) return category = interaction.guild.get_channel(category_id) if not category: embed = create_error_embed(lang, get_text(lang, 'error_invalid_category')) await interaction.followup.send(embed=embed, ephemeral=True) return config['ticket_counter'] += 1 ticket_number = config['ticket_counter'] await self.bot.db.update_guild_config(interaction.guild.id, config) overwrites = { interaction.guild.default_role: discord.PermissionOverwrite(view_channel=False), interaction.user: discord.PermissionOverwrite(view_channel=True, send_messages=True, read_message_history=True), interaction.guild.me: discord.PermissionOverwrite(view_channel=True, send_messages=True, read_message_history=True, manage_channels=True) } for role_id in config.get('support_roles', []): role = interaction.guild.get_role(role_id) if role: overwrites[role] = discord.PermissionOverwrite(view_channel=True, send_messages=True, read_message_history=True) channel_name = f"ticket-{ticket_number:04d}" ticket_channel = await category.create_text_channel( name=channel_name, overwrites=overwrites, topic=f"Ticket created by {interaction.user} | User ID: {interaction.user.id}" ) ticket_id = await self.bot.db.create_ticket(interaction.guild.id, ticket_channel.id, interaction.user.id, ticket_number) await self.bot.db.add_ticket_log(ticket_id, interaction.user.id, get_text(lang, 'log_action_created'), get_text(lang, 'log_details_created')) embed = create_ticket_embed(lang, interaction.user, ticket_number) view = TicketControlButtons(self.bot) await ticket_channel.send(content=f"{interaction.user.mention}", embed=embed, view=view) success_embed = create_success_embed(lang, get_text(lang, 'success_ticket_created', channel=ticket_channel.mention)) await interaction.followup.send(embed=success_embed, ephemeral=True) log_channel_id = config.get('log_channel') if log_channel_id: log_channel = interaction.guild.get_channel(log_channel_id) if log_channel: log_embed = create_log_embed(lang, get_text(lang, 'log_action_created'), interaction.user, ticket_channel) await log_channel.send(embed=log_embed) class TicketControlButtons(View): def __init__(self, bot): super().__init__(timeout=None) self.bot = bot @discord.ui.button(label='Close', style=discord.ButtonStyle.red, custom_id='close_ticket', emoji='🔒') async def close_ticket(self, interaction: discord.Interaction, button: Button): await interaction.response.defer() config = await self.bot.db.get_guild_config(interaction.guild.id) lang = config.get('language', 'en') ticket = await self.bot.db.get_ticket_by_channel(interaction.channel.id) if not ticket: embed = create_error_embed(lang, get_text(lang, 'error_not_ticket')) await interaction.followup.send(embed=embed, ephemeral=True) return ticket_id = ticket[0] user_id = ticket[3] if interaction.user.id != user_id: has_permission = False for role in interaction.user.roles: if role.id in config.get('support_roles', []) or role.id in config.get('admin_roles', []): has_permission = True break if not has_permission and not interaction.user.guild_permissions.administrator: embed = create_error_embed(lang, get_text(lang, 'error_no_permission')) await interaction.followup.send(embed=embed, ephemeral=True) return await self.bot.db.close_ticket(ticket_id, f"Closed by {interaction.user}") await self.bot.db.add_ticket_log(ticket_id, interaction.user.id, get_text(lang, 'log_action_closed'), f"Closed by {interaction.user.mention}") if config.get('transcript_enabled', True): transcript = await self.bot.db.get_ticket_transcript(ticket_id) if transcript: transcript_text = f"Ticket Transcript - {interaction.channel.name}\n" transcript_text += f"Created: {datetime.utcnow().strftime('%Y-%m-%d %H:%M:%S')} UTC\n" transcript_text += "=" * 50 + "\n\n" for msg in transcript: user = interaction.guild.get_member(msg[0]) username = user.display_name if user else f"User {msg[0]}" timestamp = msg[2] content = msg[1] transcript_text += f"[{timestamp}] {username}: {content}\n" transcript_file = discord.File(fp=io.BytesIO(transcript_text.encode('utf-8')), filename=f'transcript-{interaction.channel.name}.txt') user = interaction.guild.get_member(user_id) if user: try: transcript_embed = create_transcript_embed(lang, ticket[4], len(transcript), user) await user.send(embed=transcript_embed, file=transcript_file) except discord.Forbidden: pass embed = create_success_embed(lang, get_text(lang, 'success_ticket_closing')) await interaction.channel.send(embed=embed) log_channel_id = config.get('log_channel') if log_channel_id: log_channel = interaction.guild.get_channel(log_channel_id) if log_channel: log_embed = create_log_embed(lang, get_text(lang, 'log_action_closed'), interaction.user, interaction.channel, f"Closed by {interaction.user.mention}") await log_channel.send(embed=log_embed) await interaction.channel.edit(name=f"closed-{interaction.channel.name}") await interaction.channel.set_permissions(interaction.guild.default_role, view_channel=False, send_messages=False) await interaction.channel.delete(delay=10) @discord.ui.button(label='Claim', style=discord.ButtonStyle.blurple, custom_id='claim_ticket', emoji='✋') async def claim_ticket(self, interaction: discord.Interaction, button: Button): await interaction.response.defer() config = await self.bot.db.get_guild_config(interaction.guild.id) lang = config.get('language', 'en') has_permission = False for role in interaction.user.roles: if role.id in config.get('support_roles', []) or role.id in config.get('admin_roles', []): has_permission = True break if not has_permission and not interaction.user.guild_permissions.administrator: embed = create_error_embed(lang, get_text(lang, 'error_no_permission')) await interaction.followup.send(embed=embed, ephemeral=True) return ticket = await self.bot.db.get_ticket_by_channel(interaction.channel.id) if not ticket: embed = create_error_embed(lang, get_text(lang, 'error_not_ticket')) await interaction.followup.send(embed=embed, ephemeral=True) return ticket_id = ticket[0] await self.bot.db.claim_ticket(ticket_id, interaction.user.id) await self.bot.db.add_ticket_log(ticket_id, interaction.user.id, get_text(lang, 'log_action_claimed'), f"Claimed by {interaction.user.mention}") embed = create_success_embed(lang, get_text(lang, 'success_ticket_claimed', user=interaction.user.mention)) await interaction.channel.send(embed=embed) log_channel_id = config.get('log_channel') if log_channel_id: log_channel = interaction.guild.get_channel(log_channel_id) if log_channel: log_embed = create_log_embed(lang, get_text(lang, 'log_action_claimed'), interaction.user, interaction.channel) await log_channel.send(embed=log_embed) class TicketBot(commands.Bot): def __init__(self): intents = discord.Intents.default() intents.message_content = True intents.members = True intents.guilds = True super().__init__(command_prefix='!', intents=intents, help_command=None) self.db = None self.logger = self.setup_logger() def setup_logger(self): logger = logging.getLogger('TicketBot') logger.setLevel(logging.INFO) console_handler = logging.StreamHandler() console_handler.setLevel(logging.INFO) formatter = logging.Formatter('[%(asctime)s] [%(levelname)s] %(name)s: %(message)s', datefmt='%Y-%m-%d %H:%M:%S') console_handler.setFormatter(formatter) logger.addHandler(console_handler) return logger async def setup_hook(self): self.db = Database() await self.db.initialize() self.add_view(TicketButtons(self)) self.add_view(TicketControlButtons(self)) self.logger.info('Database initialized and views registered') async def on_ready(self): self.logger.info(f'Bot is ready! Logged in as {self.user} (ID: {self.user.id})') self.logger.info(f'Connected to {len(self.guilds)} guilds') activity = discord.Activity(type=discord.ActivityType.watching, name='tickets | !help') await self.change_presence(activity=activity) async def on_guild_join(self, guild): await self.db.create_guild_config(guild.id) self.logger.info(f'Joined new guild: {guild.name} (ID: {guild.id})') async def on_guild_remove(self, guild): self.logger.info(f'Left guild: {guild.name} (ID: {guild.id})') async def on_message(self, message): if message.author.bot or not message.guild: await self.process_commands(message) return ticket = await self.db.get_ticket_by_channel(message.channel.id) if ticket: await self.db.add_ticket_message(message.id, ticket[0], message.author.id, message.content) await self.process_commands(message) bot = TicketBot() @bot.command(name='panel') @commands.has_permissions(administrator=True) async def create_panel(ctx): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') embed = create_panel_embed(lang, ctx.guild) view = TicketButtons(bot) await ctx.send(embed=embed, view=view) await ctx.message.delete() @bot.command(name='add') @commands.has_permissions(manage_channels=True) async def add_user(ctx, member: discord.Member): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') ticket = await bot.db.get_ticket_by_channel(ctx.channel.id) if not ticket: embed = create_error_embed(lang, get_text(lang, 'error_not_ticket')) await ctx.send(embed=embed) return await ctx.channel.set_permissions(member, view_channel=True, send_messages=True, read_message_history=True) embed = create_success_embed(lang, get_text(lang, 'success_user_added', user=member.mention)) await ctx.send(embed=embed) await bot.db.add_ticket_log(ticket[0], ctx.author.id, get_text(lang, 'log_action_user_added'), f"{member.mention} added by {ctx.author.mention}") @bot.command(name='remove') @commands.has_permissions(manage_channels=True) async def remove_user(ctx, member: discord.Member): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') ticket = await bot.db.get_ticket_by_channel(ctx.channel.id) if not ticket: embed = create_error_embed(lang, get_text(lang, 'error_not_ticket')) await ctx.send(embed=embed) return await ctx.channel.set_permissions(member, overwrite=None) embed = create_success_embed(lang, get_text(lang, 'success_user_removed', user=member.mention)) await ctx.send(embed=embed) await bot.db.add_ticket_log(ticket[0], ctx.author.id, get_text(lang, 'log_action_user_removed'), f"{member.mention} removed by {ctx.author.mention}") @bot.command(name='help') async def help_command(ctx): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') embed = discord.Embed( title=f"{EMOJIS['ticket']} {get_text(lang, 'help_title')}", description=f"**{get_text(lang, 'help_description')}**\n━━━━━━━━━━━━━━━━━━━", color=discord.Color.blue(), timestamp=datetime.utcnow() ) commands_text = f""" 🎫 `!panel` - {get_text(lang, 'help_panel')} ➕ `!add ` - {get_text(lang, 'help_add')} ➖ `!remove ` - {get_text(lang, 'help_remove')} 📊 `!stats` - {get_text(lang, 'help_stats')} ⚙️ `!setup` - {get_text(lang, 'help_setup')} """ embed.add_field(name=f"📚 {get_text(lang, 'help_commands')}", value=commands_text, inline=False) embed.set_author(name=ctx.guild.name, icon_url=ctx.guild.icon.url if ctx.guild.icon else None) if ctx.guild.icon: embed.set_thumbnail(url=ctx.guild.icon.url) embed.set_footer(text=get_text(lang, 'help_footer'), icon_url=bot.user.display_avatar.url) await ctx.send(embed=embed) @bot.command(name='setup') @commands.has_permissions(administrator=True) async def setup(ctx): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') embed = discord.Embed( title=f"⚙️ {get_text(lang, 'setup_title')}", description=f"**{get_text(lang, 'setup_description')}**\n━━━━━━━━━━━━━━━━━━━", color=discord.Color.gold(), timestamp=datetime.utcnow() ) setup_text = f""" 📁 `!setcategory ` - {get_text(lang, 'setup_category')} 📝 `!setlog ` - {get_text(lang, 'setup_log')} 👥 `!addsupportrole ` - {get_text(lang, 'setup_support_role')} ❌ `!removesupportrole ` - {get_text(lang, 'setup_remove_support')} 👑 `!addadminrole ` - {get_text(lang, 'setup_admin_role')} ❌ `!removeadminrole ` - {get_text(lang, 'setup_remove_admin')} 🌐 `!setlanguage ` - {get_text(lang, 'setup_language')} 🔢 `!setmaxtickets ` - {get_text(lang, 'setup_max_tickets')} """ embed.add_field(name=f"📋 {get_text(lang, 'setup_commands')}", value=setup_text, inline=False) languages = """ 🇬🇧 `en` - English 🇪🇸 `es` - Español 🇫🇷 `fr` - Français 🇩🇪 `de` - Deutsch """ embed.add_field(name=f"🌍 {get_text(lang, 'setup_languages')}", value=languages, inline=False) embed.set_author(name=ctx.author.display_name, icon_url=ctx.author.display_avatar.url) if ctx.guild.icon: embed.set_thumbnail(url=ctx.guild.icon.url) embed.set_footer(text=f"{ctx.guild.name} Configuration", icon_url=bot.user.display_avatar.url) await ctx.send(embed=embed) @bot.command(name='setcategory') @commands.has_permissions(administrator=True) async def set_category(ctx, category_id: int): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') category = ctx.guild.get_channel(category_id) if not category or not isinstance(category, discord.CategoryChannel): embed = create_error_embed(lang, get_text(lang, 'error_invalid_category')) await ctx.send(embed=embed) return config['ticket_category'] = category_id await bot.db.update_guild_config(ctx.guild.id, config) embed = create_success_embed(lang, get_text(lang, 'success_category_set', category=category.name)) await ctx.send(embed=embed) @bot.command(name='setlog') @commands.has_permissions(administrator=True) async def set_log(ctx, channel: discord.TextChannel): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') config['log_channel'] = channel.id await bot.db.update_guild_config(ctx.guild.id, config) embed = create_success_embed(lang, get_text(lang, 'success_log_set', channel=channel.mention)) await ctx.send(embed=embed) @bot.command(name='addsupportrole') @commands.has_permissions(administrator=True) async def add_support_role(ctx, role: discord.Role): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') if role.id not in config['support_roles']: config['support_roles'].append(role.id) await bot.db.update_guild_config(ctx.guild.id, config) embed = create_success_embed(lang, get_text(lang, 'success_support_added', role=role.mention)) else: embed = create_error_embed(lang, get_text(lang, 'error_role_exists')) await ctx.send(embed=embed) @bot.command(name='removesupportrole') @commands.has_permissions(administrator=True) async def remove_support_role(ctx, role: discord.Role): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') if role.id in config['support_roles']: config['support_roles'].remove(role.id) await bot.db.update_guild_config(ctx.guild.id, config) embed = create_success_embed(lang, get_text(lang, 'success_support_removed', role=role.mention)) else: embed = create_error_embed(lang, get_text(lang, 'error_role_not_found')) await ctx.send(embed=embed) @bot.command(name='addadminrole') @commands.has_permissions(administrator=True) async def add_admin_role(ctx, role: discord.Role): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') if role.id not in config['admin_roles']: config['admin_roles'].append(role.id) await bot.db.update_guild_config(ctx.guild.id, config) embed = create_success_embed(lang, get_text(lang, 'success_admin_added', role=role.mention)) else: embed = create_error_embed(lang, get_text(lang, 'error_role_exists')) await ctx.send(embed=embed) @bot.command(name='removeadminrole') @commands.has_permissions(administrator=True) async def remove_admin_role(ctx, role: discord.Role): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') if role.id in config['admin_roles']: config['admin_roles'].remove(role.id) await bot.db.update_guild_config(ctx.guild.id, config) embed = create_success_embed(lang, get_text(lang, 'success_admin_removed', role=role.mention)) else: embed = create_error_embed(lang, get_text(lang, 'error_role_not_found')) await ctx.send(embed=embed) @bot.command(name='setlanguage') @commands.has_permissions(administrator=True) async def set_language(ctx, language: str): config = await bot.db.get_guild_config(ctx.guild.id) valid_languages = ['en', 'es', 'fr', 'de'] if language.lower() not in valid_languages: embed = create_error_embed(config.get('language', 'en'), f"Invalid language. Valid options: {', '.join(valid_languages)}") await ctx.send(embed=embed) return config['language'] = language.lower() await bot.db.update_guild_config(ctx.guild.id, config) lang = language.lower() embed = create_success_embed(lang, get_text(lang, 'success_language_set')) await ctx.send(embed=embed) @bot.command(name='setmaxtickets') @commands.has_permissions(administrator=True) async def set_max_tickets(ctx, amount: int): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') if amount < 1 or amount > 10: embed = create_error_embed(lang, get_text(lang, 'error_invalid_max')) await ctx.send(embed=embed) return config['max_tickets_per_user'] = amount await bot.db.update_guild_config(ctx.guild.id, config) embed = create_success_embed(lang, get_text(lang, 'success_max_set', max=amount)) await ctx.send(embed=embed) @bot.command(name='stats') @commands.has_permissions(manage_guild=True) async def stats(ctx): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') stats = await bot.db.get_guild_stats(ctx.guild.id) embed = create_stats_embed(lang, ctx.guild, stats) await ctx.send(embed=embed) @bot.command(name='closeall') @commands.has_permissions(administrator=True) async def close_all(ctx): config = await bot.db.get_guild_config(ctx.guild.id) lang = config.get('language', 'en') confirm_embed = discord.Embed( title=f"{EMOJIS['warning']} {get_text(lang, 'closeall_title')}", description=f"━━━━━━━━━━━━━━━━━━━\n\n{get_text(lang, 'closeall_description')}\n\n━━━━━━━━━━━━━━━━━━━", color=COLORS['warning'], timestamp=datetime.utcnow() ) confirm_embed.set_author(name=ctx.author.display_name, icon_url=ctx.author.display_avatar.url) confirm_embed.set_footer(text="This action cannot be undone!") msg = await ctx.send(embed=confirm_embed) await msg.add_reaction('✅') await msg.add_reaction('❌') def check(reaction, user): return user == ctx.author and str(reaction.emoji) in ['✅', '❌'] and reaction.message.id == msg.id try: reaction, user = await bot.wait_for('reaction_add', timeout=30.0, check=check) if str(reaction.emoji) == '✅': category_id = config.get('ticket_category') if category_id: category = ctx.guild.get_channel(category_id) if category: closed_count = 0 for channel in category.channels: ticket = await bot.db.get_ticket_by_channel(channel.id) if ticket: await bot.db.close_ticket(ticket[0], "Mass close by admin") await channel.delete() closed_count += 1 embed = create_success_embed(lang, get_text(lang, 'success_closeall', count=closed_count)) await ctx.send(embed=embed) else: embed = create_error_embed(lang, get_text(lang, 'closeall_cancelled')) await ctx.send(embed=embed) except: embed = create_error_embed(lang, get_text(lang, 'closeall_timeout')) await ctx.send(embed=embed) async def main(): try: await bot.start(os.getenv('DISCORD_TOKEN')) except KeyboardInterrupt: await bot.close() except Exception as e: logging.error(f'Fatal error: {e}') await bot.close() if __name__ == '__main__': asyncio.run(main())