const Discord = require("discord.js");

const mysql = require('mysql');

         var con = mysql.createConnection({
            host: "localhost",
            user: "Website",
            password: "PASS",
            database: "discordverify"
});

module.exports = {
    name: "upgrade",
    description: "Get a valid lsit of commands.",
    execute: (message, args) => {

con.connect(function(err) {
      if (err) throw err;
    setInterval(function(){
        con.query(`SELECT * FROM vip WHERE discord_name = '${message.author.username}'`, function (err, result2, fields2) {
        if(result2[0].completed == '1'){
            if(result2[0].botcompleted == '0'){
                  var sql2 = `UPDATE vip SET botcompleted = '1' WHERE discord_name = '${message.author.username}'`;
                  con.query(sql2, function (err, result3) {
                      let viprole = message.guild.roles.find(`name`, "VIP");
                      if (err) throw err;
                              message.member.addRole(viprole.id);
                              let img = "https://cdn.discordapp.com/attachments/397851090411847681/424512693819539456/wt.png";
                              let thmb = "https://cdn.discordapp.com/attachments/397851090411847681/424512593844240396/t.png";
                              let img2 = message.author.avatarURL;
                              let embed = new Discord.RichEmbed()
                              .setDescription("YulxVol, " + "[website](https://www.yulxvol.com/)")
                              .addField("**Upgraded**", `Thank You ${message.author.username} for buying VIP and supporting YulxVol`, inline=true)
                              .setImage("https://i.imgur.com/kBLwm9b.gif")
                              .setThumbnail(img2)
                              .setTimestamp("")
                              .setFooter("© YulxVol" + "  |  yulxvol.com", img)
                              .setColor("#a108a3");
                              let upgradeschannel = message.guild.channels.find(`name`, "recent-upgrades");

        upgradeschannel.send(embed);
                      });
            }
        }
    });
      }, 5000);



});





    }
}