60 lines
No EOL
1.8 KiB
JavaScript
60 lines
No EOL
1.8 KiB
JavaScript
const Discord = require('discord.js')
|
|
const fs = require("fs");
|
|
const ms = require("ms");
|
|
const moment = require("moment");
|
|
const database = JSON.parse(fs.readFileSync("./database.json", `utf8`));
|
|
const mysql = require("mysql");
|
|
|
|
module.exports.run = async (client, message, args) => {
|
|
var con = mysql.createConnection({
|
|
host: database.host,
|
|
user: database.user,
|
|
password: database.password,
|
|
database: database.database,
|
|
charset : 'utf8mb4'
|
|
});
|
|
con.connect(err => {
|
|
if (err) throw err;
|
|
});
|
|
|
|
|
|
|
|
if(!message.member.hasPermission("KICK_MEMBERS")) return message.channel.send(`:)`);
|
|
var cname = args[0];
|
|
var value2change = "visible"
|
|
var newvalue = "true"
|
|
|
|
var filter = m => m.author.id === message.author.id
|
|
|
|
message.channel.send("🗑️ **Naam** | Welk bedrijf moet weer zichtbaar zijn?")
|
|
message.channel.awaitMessages(filter, {
|
|
max: 1,}).then(collected => {
|
|
cname = collected.first().content;
|
|
|
|
con.query(`SELECT * FROM data`, (err, rows) => {
|
|
|
|
if (err) throw err;
|
|
|
|
if (rows.length < 1) {
|
|
con.query(`UPDATE data SET ${value2change} = '${newvalue}' WHERE name = '${cname}'`);
|
|
setTimeout(function(){
|
|
message.channel.send(`${cname} is nu weer zichtbaar op de website.`)
|
|
}, 10);
|
|
|
|
} else {
|
|
con.query(`UPDATE data SET ${value2change} = '${newvalue}' WHERE name = '${cname}'`);
|
|
setTimeout(function(){
|
|
message.channel.send(`${cname} is nu weer zichtbaar op de website.`)
|
|
}, 10);
|
|
|
|
}
|
|
|
|
})
|
|
|
|
});
|
|
|
|
}
|
|
|
|
module.exports.help = {
|
|
name: "show"
|
|
} |