const { SlashCommandBuilder, EmbedBuilder, ChannelType, PermissionFlagBits } = require('discord.js'); const db = require('../database/Database'); const config = require('../config/config'); module.exports = { name: 'setup', description: 'Setup bot features for your server', data: new SlashCommandBuilder() .setName('setup') .setDescription('Setup bot features for your server') .addSubcommand(sub => sub.setName('welcome') .setDescription('Setup welcome messages') .addChannelOption(opt => opt.setName('channel').setDescription('Welcome channel').setRequired(true).addChannelTypes(ChannelType.GuildText)) .addStringOption(opt => opt.setName('message').setDescription('Welcome message (use {user} for mention, {server} for server name)').setRequired(true)) .addRoleOption(opt => opt.setName('autorole').setDescription('Auto-assign role on join')) ) .addSubcommand(sub => sub.setName('leave') .setDescription('Setup leave messages') .addChannelOption(opt => opt.setName('channel').setDescription('Leave channel').setRequired(true).addChannelTypes(ChannelType.GuildText)) .addStringOption(opt => opt.setName('message').setDescription('Leave message (use {user} for username, {server} for server name)').setRequired(true)) ) .addSubcommand(sub => sub.setName('logs') .setDescription('Setup logging channel') .addChannelOption(opt => opt.setName('channel').setDescription('Logs channel').setRequired(true).addChannelTypes(ChannelType.GuildText)) ) .addSubcommand(sub => sub.setName('automod') .setDescription('Setup automod system') .addIntegerOption(opt => opt.setName('level').setDescription('Automod level (1-4)').setRequired(true).setMinValue(1).setMaxValue(4)) .addChannelOption(opt => opt.setName('logchannel').setDescription('Automod log channel').addChannelTypes(ChannelType.GuildText)) ) .addSubcommand(sub => sub.setName('verification') .setDescription('Setup verification system') .addChannelOption(opt => opt.setName('channel').setDescription('Verification channel').setRequired(true).addChannelTypes(ChannelType.GuildText)) .addRoleOption(opt => opt.setName('role').setDescription('Role to give after verification').setRequired(true)) ) .addSubcommand(sub => sub.setName('tickets') .setDescription('Setup ticket system') .addChannelOption(opt => opt.setName('channel').setDescription('Ticket panel channel').setRequired(true).addChannelTypes(ChannelType.GuildText)) .addChannelOption(opt => opt.setName('category').setDescription('Category for tickets').setRequired(true).addChannelTypes(ChannelType.GuildCategory)) .addRoleOption(opt => opt.setName('staffrole').setDescription('Staff role for tickets')) ) .addSubcommand(sub => sub.setName('view') .setDescription('View current server setup') ) .setDefaultMemberPermissions(PermissionFlagBits.Administrator), async execute(interaction, args, client) { const isSlash = interaction.isChatInputCommand && interaction.isChatInputCommand(); if (!interaction.member.permissions.has(PermissionFlagBits.Administrator)) { const embed = new EmbedBuilder() .setDescription('❌ You need Administrator permission to use this command.') .setColor(config.errorColor); return interaction.reply({ embeds: [embed], ephemeral: isSlash }); } if (isSlash) { const subcommand = interaction.options.getSubcommand(); if (subcommand === 'welcome') { const channel = interaction.options.getChannel('channel'); const message = interaction.options.getString('message'); const autoRole = interaction.options.getRole('autorole'); if (db.type === 'mongodb') { await db.models.WelcomeConfig.findOneAndUpdate( { guild_id: interaction.guild.id }, { channel_id: channel.id, message: message, auto_role: autoRole?.id || null, enabled: true }, { upsert: true } ); } else { const stmt = db.db.prepare(` INSERT INTO welcome_config (guild_id, channel_id, message, auto_role, enabled) VALUES (?, ?, ?, ?, 1) ON CONFLICT(guild_id) DO UPDATE SET channel_id = excluded.channel_id, message = excluded.message, auto_role = excluded.auto_role, enabled = 1 `); stmt.bind([interaction.guild.id, channel.id, message, autoRole?.id || null]); stmt.step(); stmt.free(); db.saveDatabase(); } const embed = new EmbedBuilder() .setTitle('✅ Welcome System Setup') .setDescription(`**Channel:** ${channel}\n**Message:** ${message}${autoRole ? `\n**Auto Role:** ${autoRole}` : ''}`) .setColor(config.successColor) .setTimestamp(); await interaction.reply({ embeds: [embed] }); } else if (subcommand === 'leave') { const channel = interaction.options.getChannel('channel'); const message = interaction.options.getString('message'); if (db.type === 'mongodb') { await db.models.LeaveConfig.findOneAndUpdate( { guild_id: interaction.guild.id }, { channel_id: channel.id, message: message, enabled: true }, { upsert: true } ); } else { const stmt = db.db.prepare(` INSERT INTO leave_config (guild_id, channel_id, message, enabled) VALUES (?, ?, ?, 1) ON CONFLICT(guild_id) DO UPDATE SET channel_id = excluded.channel_id, message = excluded.message, enabled = 1 `); stmt.bind([interaction.guild.id, channel.id, message]); stmt.step(); stmt.free(); db.saveDatabase(); } const embed = new EmbedBuilder() .setTitle('✅ Leave System Setup') .setDescription(`**Channel:** ${channel}\n**Message:** ${message}`) .setColor(config.successColor) .setTimestamp(); await interaction.reply({ embeds: [embed] }); } else if (subcommand === 'logs') { const channel = interaction.options.getChannel('channel'); if (db.type === 'mongodb') { await db.models.LogsConfig.findOneAndUpdate( { guild_id: interaction.guild.id }, { message_log: channel.id, mod_log: channel.id }, { upsert: true } ); } else { const stmt = db.db.prepare(` INSERT INTO logs_config (guild_id, message_log, mod_log) VALUES (?, ?, ?) ON CONFLICT(guild_id) DO UPDATE SET message_log = excluded.message_log, mod_log = excluded.mod_log `); stmt.bind([interaction.guild.id, channel.id, channel.id]); stmt.step(); stmt.free(); db.saveDatabase(); } const embed = new EmbedBuilder() .setTitle('✅ Logging System Setup') .setDescription(`**Channel:** ${channel}`) .setColor(config.successColor) .setTimestamp(); await interaction.reply({ embeds: [embed] }); } else if (subcommand === 'automod') { const level = interaction.options.getInteger('level'); const logChannel = interaction.options.getChannel('logchannel'); if (db.type === 'mongodb') { await db.models.AutomodConfig.findOneAndUpdate( { guild_id: interaction.guild.id }, { anti_spam: true, anti_link: true, anti_invite: true, bad_words: true, anti_caps: true, anti_mention: true, anti_emoji: true, anti_ghost_ping: true, anti_phishing: true, anti_raid: true, anti_alt: true, log_channel: logChannel?.id || null }, { upsert: true } ); await db.models.Guild.findOneAndUpdate( { guild_id: interaction.guild.id }, { security_level: level }, { upsert: true } ); } else { const stmt1 = db.db.prepare(` INSERT INTO automod_config (guild_id, anti_spam, anti_link, anti_invite, bad_words, anti_caps, anti_mention, anti_emoji, anti_ghost_ping, anti_phishing, anti_raid, anti_alt, log_channel) VALUES (?, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, ?) ON CONFLICT(guild_id) DO UPDATE SET anti_spam = 1, anti_link = 1, anti_invite = 1, bad_words = 1, anti_caps = 1, anti_mention = 1, anti_emoji = 1, anti_ghost_ping = 1, anti_phishing = 1, anti_raid = 1, anti_alt = 1, log_channel = excluded.log_channel `); stmt1.bind([interaction.guild.id, logChannel?.id || null]); stmt1.step(); stmt1.free(); const stmt2 = db.db.prepare('UPDATE guilds SET security_level = ? WHERE guild_id = ?'); stmt2.bind([level, interaction.guild.id]); stmt2.step(); stmt2.free(); db.saveDatabase(); } const levelName = config.automod.levels[level].name; const embed = new EmbedBuilder() .setTitle('✅ Automod System Setup') .setDescription(`**Level:** ${level} (${levelName})${logChannel ? `\n**Log Channel:** ${logChannel}` : ''}`) .setColor(config.successColor) .setTimestamp(); await interaction.reply({ embeds: [embed] }); } else if (subcommand === 'verification') { const channel = interaction.options.getChannel('channel'); const role = interaction.options.getRole('role'); if (db.type === 'mongodb') { await db.models.Verification.findOneAndUpdate( { guild_id: interaction.guild.id }, { channel_id: channel.id, role_id: role.id, enabled: true }, { upsert: true } ); } else { const stmt = db.db.prepare(` INSERT INTO verification (guild_id, channel_id, role_id, enabled) VALUES (?, ?, ?, 1) ON CONFLICT(guild_id) DO UPDATE SET channel_id = excluded.channel_id, role_id = excluded.role_id, enabled = 1 `); stmt.bind([interaction.guild.id, channel.id, role.id]); stmt.step(); stmt.free(); db.saveDatabase(); } const embed = new EmbedBuilder() .setTitle('✅ Verification System Setup') .setDescription(`**Channel:** ${channel}\n**Role:** ${role}`) .setColor(config.successColor) .setTimestamp(); await interaction.reply({ embeds: [embed] }); } else if (subcommand === 'tickets') { const channel = interaction.options.getChannel('channel'); const category = interaction.options.getChannel('category'); const staffRole = interaction.options.getRole('staffrole'); if (db.type === 'mongodb') { await db.models.TicketConfig.findOneAndUpdate( { guild_id: interaction.guild.id }, { panel_channel: channel.id, category_id: category.id, staff_role: staffRole?.id || null, categories: JSON.stringify(['Support', 'General Questions', 'Bug Report', 'Payment', 'Player Report']) }, { upsert: true } ); } else { const stmt = db.db.prepare(` INSERT INTO ticket_config (guild_id, panel_channel, category_id, staff_role, categories) VALUES (?, ?, ?, ?, ?) ON CONFLICT(guild_id) DO UPDATE SET panel_channel = excluded.panel_channel, category_id = excluded.category_id, staff_role = excluded.staff_role, categories = excluded.categories `); stmt.bind([ interaction.guild.id, channel.id, category.id, staffRole?.id || null, JSON.stringify(['Support', 'General Questions', 'Bug Report', 'Payment', 'Player Report']) ]); stmt.step(); stmt.free(); db.saveDatabase(); } const embed = new EmbedBuilder() .setTitle('✅ Ticket System Setup') .setDescription(`**Panel Channel:** ${channel}\n**Ticket Category:** ${category}${staffRole ? `\n**Staff Role:** ${staffRole}` : ''}`) .setColor(config.successColor) .setTimestamp(); await interaction.reply({ embeds: [embed] }); } else if (subcommand === 'view') { const embed = new EmbedBuilder() .setTitle('⚙️ Server Setup Configuration') .setColor(config.embedColor) .setTimestamp(); let hasConfig = false; if (db.type === 'mongodb') { const welcome = await db.models.WelcomeConfig.findOne({ guild_id: interaction.guild.id, enabled: true }); const leave = await db.models.LeaveConfig.findOne({ guild_id: interaction.guild.id, enabled: true }); const verification = await db.models.Verification.findOne({ guild_id: interaction.guild.id, enabled: true }); const ticketConfig = await db.models.TicketConfig.findOne({ guild_id: interaction.guild.id }); const automodConfig = await db.models.AutomodConfig.findOne({ guild_id: interaction.guild.id }); const guild = await db.models.Guild.findOne({ guild_id: interaction.guild.id }); const logs = await db.models.LogsConfig.findOne({ guild_id: interaction.guild.id }); if (welcome) { embed.addFields({ name: '👋 Welcome System', value: `Channel: <#${welcome.channel_id}>\nMessage: ${welcome.message}${welcome.auto_role ? `\nAuto Role: <@&${welcome.auto_role}>` : ''}`, inline: false }); hasConfig = true; } if (leave) { embed.addFields({ name: '👋 Leave System', value: `Channel: <#${leave.channel_id}>\nMessage: ${leave.message}`, inline: false }); hasConfig = true; } if (logs && logs.message_log) { embed.addFields({ name: '📝 Logging', value: `Channel: <#${logs.message_log}>`, inline: false }); hasConfig = true; } if (automodConfig && guild) { const levelName = config.automod.levels[guild.security_level]?.name || 'Unknown'; embed.addFields({ name: '🛡️ Automod', value: `Level: ${guild.security_level} (${levelName})${automodConfig.log_channel ? `\nLog Channel: <#${automodConfig.log_channel}>` : ''}`, inline: false }); hasConfig = true; } if (verification) { embed.addFields({ name: '✅ Verification', value: `Channel: <#${verification.channel_id}>\nRole: <@&${verification.role_id}>`, inline: false }); hasConfig = true; } if (ticketConfig) { embed.addFields({ name: '🎫 Tickets', value: `Panel: <#${ticketConfig.panel_channel}>\nCategory: <#${ticketConfig.category_id}>${ticketConfig.staff_role ? `\nStaff Role: <@&${ticketConfig.staff_role}>` : ''}`, inline: false }); hasConfig = true; } } else { const stmt1 = db.db.prepare('SELECT * FROM welcome_config WHERE guild_id = ? AND enabled = 1'); stmt1.bind([interaction.guild.id]); const welcome = stmt1.step() ? stmt1.getAsObject() : null; stmt1.free(); const stmt2 = db.db.prepare('SELECT * FROM leave_config WHERE guild_id = ? AND enabled = 1'); stmt2.bind([interaction.guild.id]); const leave = stmt2.step() ? stmt2.getAsObject() : null; stmt2.free(); const stmt3 = db.db.prepare('SELECT * FROM verification WHERE guild_id = ? AND enabled = 1'); stmt3.bind([interaction.guild.id]); const verification = stmt3.step() ? stmt3.getAsObject() : null; stmt3.free(); const stmt4 = db.db.prepare('SELECT * FROM ticket_config WHERE guild_id = ?'); stmt4.bind([interaction.guild.id]); const ticketConfig = stmt4.step() ? stmt4.getAsObject() : null; stmt4.free(); const stmt5 = db.db.prepare('SELECT * FROM automod_config WHERE guild_id = ?'); stmt5.bind([interaction.guild.id]); const automodConfig = stmt5.step() ? stmt5.getAsObject() : null; stmt5.free(); const stmt6 = db.db.prepare('SELECT * FROM guilds WHERE guild_id = ?'); stmt6.bind([interaction.guild.id]); const guild = stmt6.step() ? stmt6.getAsObject() : null; stmt6.free(); const stmt7 = db.db.prepare('SELECT * FROM logs_config WHERE guild_id = ?'); stmt7.bind([interaction.guild.id]); const logs = stmt7.step() ? stmt7.getAsObject() : null; stmt7.free(); if (welcome) { embed.addFields({ name: '👋 Welcome System', value: `Channel: <#${welcome.channel_id}>\nMessage: ${welcome.message}${welcome.auto_role ? `\nAuto Role: <@&${welcome.auto_role}>` : ''}`, inline: false }); hasConfig = true; } if (leave) { embed.addFields({ name: '👋 Leave System', value: `Channel: <#${leave.channel_id}>\nMessage: ${leave.message}`, inline: false }); hasConfig = true; } if (logs && logs.message_log) { embed.addFields({ name: '📝 Logging', value: `Channel: <#${logs.message_log}>`, inline: false }); hasConfig = true; } if (automodConfig && guild) { const levelName = config.automod.levels[guild.security_level]?.name || 'Unknown'; embed.addFields({ name: '🛡️ Automod', value: `Level: ${guild.security_level} (${levelName})${automodConfig.log_channel ? `\nLog Channel: <#${automodConfig.log_channel}>` : ''}`, inline: false }); hasConfig = true; } if (verification) { embed.addFields({ name: '✅ Verification', value: `Channel: <#${verification.channel_id}>\nRole: <@&${verification.role_id}>`, inline: false }); hasConfig = true; } if (ticketConfig) { embed.addFields({ name: '🎫 Tickets', value: `Panel: <#${ticketConfig.panel_channel}>\nCategory: <#${ticketConfig.category_id}>${ticketConfig.staff_role ? `\nStaff Role: <@&${ticketConfig.staff_role}>` : ''}`, inline: false }); hasConfig = true; } } if (!hasConfig) { embed.setDescription('❌ No setup found for this server. Use `/setup` commands to configure features.'); } await interaction.reply({ embeds: [embed] }); } } else { const subcommand = args[0]?.toLowerCase(); if (!subcommand || subcommand === 'help') { const embed = new EmbedBuilder() .setTitle('⚙️ Setup Command') .setDescription('Configure bot features for your server\n\n**Available Commands:**') .addFields( { name: 'View Setup', value: '`as setup view`', inline: false } ) .setColor(config.embedColor) .setFooter({ text: 'Use slash commands for full setup options' }); return interaction.reply({ embeds: [embed] }); } if (subcommand === 'view') { const embed = new EmbedBuilder() .setTitle('⚙️ Server Setup Configuration') .setColor(config.embedColor) .setTimestamp(); let hasConfig = false; if (db.type === 'mongodb') { const welcome = await db.models.WelcomeConfig.findOne({ guild_id: interaction.guild.id, enabled: true }); const leave = await db.models.LeaveConfig.findOne({ guild_id: interaction.guild.id, enabled: true }); const verification = await db.models.Verification.findOne({ guild_id: interaction.guild.id, enabled: true }); const ticketConfig = await db.models.TicketConfig.findOne({ guild_id: interaction.guild.id }); const automodConfig = await db.models.AutomodConfig.findOne({ guild_id: interaction.guild.id }); const guild = await db.models.Guild.findOne({ guild_id: interaction.guild.id }); if (welcome) { embed.addFields({ name: '👋 Welcome System', value: `Channel: <#${welcome.channel_id}>\nMessage: ${welcome.message}`, inline: false }); hasConfig = true; } if (leave) { embed.addFields({ name: '👋 Leave System', value: `Channel: <#${leave.channel_id}>\nMessage: ${leave.message}`, inline: false }); hasConfig = true; } if (automodConfig && guild) { const levelName = config.automod.levels[guild.security_level]?.name || 'Unknown'; embed.addFields({ name: '🛡️ Automod', value: `Level: ${guild.security_level} (${levelName})`, inline: false }); hasConfig = true; } if (verification) { embed.addFields({ name: '✅ Verification', value: `Channel: <#${verification.channel_id}>\nRole: <@&${verification.role_id}>`, inline: false }); hasConfig = true; } if (ticketConfig) { embed.addFields({ name: '🎫 Tickets', value: `Panel: <#${ticketConfig.panel_channel}>\nCategory: <#${ticketConfig.category_id}>`, inline: false }); hasConfig = true; } } else { const stmt1 = db.db.prepare('SELECT * FROM welcome_config WHERE guild_id = ? AND enabled = 1'); stmt1.bind([interaction.guild.id]); const welcome = stmt1.step() ? stmt1.getAsObject() : null; stmt1.free(); const stmt2 = db.db.prepare('SELECT * FROM leave_config WHERE guild_id = ? AND enabled = 1'); stmt2.bind([interaction.guild.id]); const leave = stmt2.step() ? stmt2.getAsObject() : null; stmt2.free(); const stmt3 = db.db.prepare('SELECT * FROM verification WHERE guild_id = ? AND enabled = 1'); stmt3.bind([interaction.guild.id]); const verification = stmt3.step() ? stmt3.getAsObject() : null; stmt3.free(); const stmt4 = db.db.prepare('SELECT * FROM ticket_config WHERE guild_id = ?'); stmt4.bind([interaction.guild.id]); const ticketConfig = stmt4.step() ? stmt4.getAsObject() : null; stmt4.free(); const stmt5 = db.db.prepare('SELECT * FROM automod_config WHERE guild_id = ?'); stmt5.bind([interaction.guild.id]); const automodConfig = stmt5.step() ? stmt5.getAsObject() : null; stmt5.free(); const stmt6 = db.db.prepare('SELECT * FROM guilds WHERE guild_id = ?'); stmt6.bind([interaction.guild.id]); const guild = stmt6.step() ? stmt6.getAsObject() : null; stmt6.free(); if (welcome) { embed.addFields({ name: '👋 Welcome System', value: `Channel: <#${welcome.channel_id}>\nMessage: ${welcome.message}`, inline: false }); hasConfig = true; } if (leave) { embed.addFields({ name: '👋 Leave System', value: `Channel: <#${leave.channel_id}>\nMessage: ${leave.message}`, inline: false }); hasConfig = true; } if (automodConfig && guild) { const levelName = config.automod.levels[guild.security_level]?.name || 'Unknown'; embed.addFields({ name: '🛡️ Automod', value: `Level: ${guild.security_level} (${levelName})`, inline: false }); hasConfig = true; } if (verification) { embed.addFields({ name: '✅ Verification', value: `Channel: <#${verification.channel_id}>\nRole: <@&${verification.role_id}>`, inline: false }); hasConfig = true; } if (ticketConfig) { embed.addFields({ name: '🎫 Tickets', value: `Panel: <#${ticketConfig.panel_channel}>\nCategory: <#${ticketConfig.category_id}>`, inline: false }); hasConfig = true; } } if (!hasConfig) { embed.setDescription('❌ No setup found for this server.'); } return interaction.reply({ embeds: [embed] }); } else { const embed = new EmbedBuilder() .setDescription('❌ Invalid subcommand. Use `as setup view` or slash commands for full setup.') .setColor(config.errorColor); await interaction.reply({ embeds: [embed] }); } } } };