z7GrnLWz

1
2const { MessageEmbed } = require('discord.js')
3
4const sqlite3 = require('sqlite3')
5const Database = new sqlite3.Database('./database/suggest.sqlite')
6
7module.exports.run = (client,message,args) => {
8    if(!message.member.hasPermission("MANAGE_GUILD")) return message.channel.send("¡No tienes los permisos suficientes!")
9    let channel = message.mentions.channels.first()
10    if(!channel) return message.channel.send("¡Debes mencionar el canal!")
11    let SQLCreate = "CREATE TABLE IF NOT EXISTS suggest(channelid INTEGER, id INTEGER)"
12    
13    Database.run(SQLCreate, (error) =>{ if(error) return console.log(error)
14    })
15    
16    let channelInsert = `INSERT INTO suggest(channelid, id) VALUES (${channel.id}, ${message.guild.id})`
17    
18    let channelUpdate = `UPDATE suggest SET channelid = ${channel.id} WHERE id = ${message.guild.name}`
19    
20    let channelShow = `SELECT * FROM suggest WHERE id = ${message.guild.id}`
21    
22    Database.get(channelShow, (error, filas) => {
23        if(error) return console.error(error)
24        if(!filas){
25            Database.run(channelInsert, (err) => {
26                if(err) return console.error(err)
27                const embed = new MessageEmbed()
28                .setTitle("GhostyBot | SetSuggest")
29                .setDescription(`Se ha puesto <#${channel.id}> como canal de sugerencias.`)
30                .setColor(0x71FF56)
31              message.channel.send(embed)
32            })
33        }else{
34            Database.run(channelUpdaye, (err) => {
35                if(err) return console.error(err)
36                const embed = new MessageEmbed()
37                .setTitle("GhostyBot | SetSuggest")
38                .setDescription(`Se ha actualizado <#${channel.id}> como canal de sugerencias.`)
39                .setColor(0x71FF56)
40              message.channel.send(embed)
41    })
42      }
43    })
44}
45module.exports.help = {
46    name: "setsuggest",
47    aliases: [],
48	description: "Comando para setear el canal de sugggest",
49	usage: "g?setsuggest <channel>",
50	category: "Staff",
51};