//Chris Lodge
/* Packages used
+-- discord.js@11.5.1
| +-- long@4.0.0
| +-- prism-media@0.0.3
| +-- snekfetch@3.6.4
| +-- tweetnacl@1.0.1
| `-- ws@6.2.1
|   `-- async-limiter@1.0.1
+-- ffmpeg@0.0.4
| `-- when@3.7.8
+-- mysql@2.17.1
| +-- bignumber.js@7.2.1
| +-- readable-stream@2.3.6
| | +-- core-util-is@1.0.2
| | +-- inherits@2.0.4
| | +-- isarray@1.0.0
| | +-- process-nextick-args@2.0.1
| | +-- safe-buffer@5.1.2 deduped
| | +-- string_decoder@1.1.1
| | | `-- safe-buffer@5.1.2 deduped
| | `-- util-deprecate@1.0.2
| +-- safe-buffer@5.1.2
| `-- sqlstring@2.3.1
`-- ytdl-core@1.0.0
  +-- html-entities@1.2.1
  +-- m3u8stream@0.6.2
  | +-- miniget@1.6.1 deduped
  | `-- sax@1.2.4 deduped
  +-- miniget@1.6.1
  `-- sax@1.2.4
*/
const Discord = require('discord.js');
const client = new Discord.Client();
const auth = require('./auth.json');
const https = require('https');
const http = require('http');
var mysql = require('mysql');
const ytdl = require('ytdl-core');

var con = mysql.createConnection({
    host: "",
    user: "",
    password: "",
    database: ""
});
con.connect(function(err) {
    if (err) throw err;
    console.log("Connected!");
});
function longSend(msg,txt){
    let toSend=[];
    while(txt.length>1800){
        toSend.push(txt.substring(0,1800));
        txt=txt.substring(1800);
    }
    toSend.push(txt);
    toSend.forEach(function(item,index,array){
        msg.reply(item);
    });
}
function isAdmin(msg){
    if(msg.member.hasPermission("ADMINISTRATOR")){
        return true;
    }else{
        msg.reply("You should not be doing that");
        return false;
    }
}
function magicEight(msg){
    let outcomes=["It is certain","It is decidedly so","Without a doubt","Yes - definitely",
                  "You may rely on it","As I see it, yes","Most likely","Outlook good","Yes",
                  "Signs point to yes","Reply hazy, try again","Ask again later","Better not tell you now",
                  "Cannot predict now","Concentrate and ask again","Don't count on it","My reply is no",
                  "My sources say no","Outlook not so good","Very doubtful"];
    res=Math.floor(Math.random()*20);
    msg.reply(outcomes[res]);
}
function getFact(msg){
    https.get('https://uselessfacts.jsph.pl/random.txt', (resp) => {
        let content = '';
        resp.on('data', (chunk) => {
            content += chunk;
        });
        resp.on('end', () => {
           msg.reply(content.substr(1));
        });
    });
}
function getJoke(msg){
    https.get('https://icanhazdadjoke.com/', (resp) => {
        let content = '';
        resp.on('data', (chunk) => {
            content += chunk;
        });
        resp.on('end', () => {
            var b=content.indexOf('<p class="subtitle">');
            var e=content.indexOf('<footer class="card-footer"');
            if(b==-1){
                msg.reply('Eror, please try again');
            }else{
                var det=content.substring(b,e);
                msg.reply(cleanHtml(det));   
            }
        });
    });
}
function pokemon(msg){
    let args=msg.content.split(" ");
    if(args[1]){
        https.get('https://pokeapi.co/api/v2/pokemon/'+args[1], (resp) => {
            let data = '';
            resp.on('data', (chunk) => {
                data += chunk;
            });
            resp.on('end', () => {
                if(data=='Not Found'){
                    msg.reply('Could not find this pokemon')
                }else{
                    let ret='';
                    let pokemon=JSON.parse(data);
                    pokemon.stats.forEach(function(stat){
                       ret+=stat.stat.name+':'+stat.base_stat+'\r\n';
                    });
                    msg.reply('Stats for '+args[1]+'\r\n'+ret);   
                }
            });
        });   
    }else{
        msg.reply("Please provide a pokemon");
    }
}
function taco(msg){
    http.get('http://taco-randomizer.herokuapp.com/random/', (resp) => {
        let data = '';
        resp.on('data', (chunk) => {
            data += chunk;
        });
        resp.on('end', () => {
            let taco=JSON.parse(data);
            msg.reply(taco.base_layer.recipe);   
            msg.reply(taco.shell.recipe);   
            msg.reply(taco.mixin.recipe);   
            msg.reply(taco.condiment.recipe);   
        });
    });   
}
function meme(msg){
    https.get('https://meme-api.herokuapp.com/gimme', (resp) => {
        let data = '';
        resp.on('data', (chunk) => {
            data += chunk;
        });
        resp.on('end', () => {
            let pic=JSON.parse(data);
            msg.reply(pic.url);    
        });
    });   
}
function nasa(msg){
    https.get('https://api.nasa.gov/planetary/apod?api_key=ebiPkEFF92olEOlmZmsqebUlQkLvX0VALNI38SJt', (resp) => {
        let data = '';
        resp.on('data', (chunk) => {
            data += chunk;
        });
        resp.on('end', () => {
            let pic=JSON.parse(data);
            msg.reply(pic.title+'\r\n'+pic.explanation);   
            msg.reply(pic.url);   
        });
    });   
}
function trivia(msg){
    http.get('http://jservice.io/api/random', (resp) => {
        let data = '';
        resp.on('data', (chunk) => {
            data += chunk;
        });
        resp.on('end', () => {
            let question=JSON.parse(data);
            question.forEach(function(question){
               msg.reply(question.question+'\r\n||'+question.answer+'||'); 
            });
        });
    });   
}
function trump(msg){
    https.get('https://api.tronalddump.io/random/quote', (resp) => {
        let data = '';
        resp.on('data', (chunk) => {
            data += chunk;
        });
        resp.on('end', () => {
            let quote=JSON.parse(data);
            msg.reply(quote.value);   
        });
    });   
}
function advice(msg){
    https.get('https://api.adviceslip.com/advice', (resp) => {
        let data = '';
        resp.on('data', (chunk) => {
            data += chunk;
        });
        resp.on('end', () => {
            let quote=JSON.parse(data);
            msg.reply(quote.slip.advice);   
        });
    });   
}
function getWeather(msg){
    let args=msg.content.split(" ");
    let city='';
    if(args[1]){
        for(i=1;i<args.length;i++){
            city+=args[i]+" ";
        }
        https.get('https://api.openweathermap.org/data/2.5/weather?q='+city+'&APPID=1d65e03f9895a4722bfa5097c5c825d8&units=imperial', (resp) => {
            let data = '';
            resp.on('data', (chunk) => {
                data += chunk;
            });
            resp.on('end', () => {
                let weather=JSON.parse(data);
                if(weather["weather"]){
                    msg.reply('It looks like the weather is '+weather["weather"][0]["description"]+' in '+city+' with a temperature of '+weather['main']['temp']+'F');
                }else{
                    msg.reply('Could not find this location');
                }
            });
        });   
    }else{
        msg.reply("Please provide a location");
    }
}
function getDateTime(msg){
    var date = new Date();
    msg.reply("The current date and time is: "+ (date.getMonth() + 1) + "-" + date.getDate() +"-" +date.getFullYear() + " " +  date.getHours() + ":" + date.getMinutes() + ":" + date.getSeconds());
}
function rollDice(msg){
    let args=msg.content.split(" ");
    if(args[1]){
        let size=args[1];
        let number=args.length>2?args[2]:1;
        let res=0;
        for(i=0;i<number;i++){
            res+=Math.floor(Math.random()*size)+1;
        }
        msg.reply('You rolled '+number+' '+size+' sided die and got a '+res);        
    }else{
        msg.reply("Please provide a size for the dice you want to role");
    }
}
function getUsers(msg,status){
    let members = msg.guild.members.filter(member => member.presence.status === status);
    let listString="The members currently "+status+" are:";
    members.forEach(function(member) {
        listString+="\r\n"+member.displayName;
      });
    msg.reply(listString);
}
function createRole(msg){
    let args=msg.content.split(" ");
    let name="";
    if(args[1]){
        for(i=1;i<args.length;i++){
            name+=args[i];
        }
        msg.guild.createRole({name: name,mentionable: true}).then(role => msg.reply(`Created new role with name ${role.name}`)).catch(console.error);      
    }else{
        msg.reply("Please provide a role name");
    }
  
}
function createChannel(msg){
    let args=msg.content.split(" ");
    if(args[1]){
        msg.guild.createChannel(args[1],{type:(args.length>2?args[2]:'text')}).then(role => msg.reply(`Created new channel with name ${role.name}`)).catch(console.error);        
    }else{
        msg.reply("Please provide a channel name");
    }
}
function kickAfk(msg){
    let args=msg.content.split(" ");
    if(args[1]){
        msg.guild.pruneMembers(parseInt(args[1])).then(pruned => msg.reply(`I just kicked ${pruned} people!`)).catch(console.error);        
    }else{
        msg.reply("Please provided how many days you want to prune for");
    }
}
function addSelfRole(msg){
    let role = msg.mentions.roles.first();
    if(role!=undefined){
        msg.member.addRole(role).then(msg.reply(`Role added!`)).catch(console.error);
    }else{
        msg.reply('Role not found');
    }
}
function addOtherRole(msg){
    let role = msg.mentions.roles.first();
    if(role!=undefined){
        if(msg.mentions.members.first()){
            msg.mentions.members.first().addRole(role).then(msg.reply(`Role added!`)).catch(console.error);
        }else{
            msg.reply('User not found');
        }
    }else{
        msg.reply('Role not found');
    }
}
function kickUser(msg){
    if(msg.mentions.members.first()){
        msg.mentions.members.first().kick().then(msg.reply(`User kicked`)).catch(console.error);
    }else{
        msg.reply('User not found');
    }
}
function banUser(msg){
    if(msg.mentions.members.first()){
        msg.mentions.members.first().ban().then(msg.reply(`User banned`)).catch(console.error);
    }else{
        msg.reply('User not found');
    }
}
function muteUser(msg,mute){
    if(msg.mentions.members.first()){
        msg.mentions.members.first().setMute(mute).then(msg.reply(mute?'User muted':'User unmuted')).catch(console.error);
    }else{
        msg.reply('User not found');
    }
}
function clearChannel(msg){
    let args=msg.content.split(" ");
    if(args[1]){
        let num=parseInt(args[1]);
        if(Number.isInteger(num)){
            if(msg.mentions.channels.first()&&msg.mentions.channels.first().type=="text"){
                msg.mentions.channels.first().bulkDelete(num).then(msg.reply('Cleared old messages')).catch(console.error);
            }else{
                msg.reply('Text channel not found');
            }      
        }else{
            msg.reply("Please provided a number of messages to delete");
        }
    }else{
        msg.reply("Please provided a number of messages to delete");
    }
}
function addTodo(msg){
    let desc="";
    let args=msg.content.split(" ");
    if(args[1]){
        for(i=1;i<args.length;i++){
            desc+=args[i]+" ";
        }
        var sql="SELECT COUNT(*) as count FROM todo where user='"+msg.member.user.id+"'";
        con.query(sql, function (err, result) {
            if (err){
              msg.reply('Task was not added, please try again later');
            }else{
                let num=parseInt(result[0].count)+1;
                var sql = "INSERT INTO todo (user, description,num) VALUES ('"+msg.member.user.id+"', '"+desc+"',"+num+")";
                con.query(sql, function (err, result) {
                  if (err){
                    msg.reply('Task was not added, please try again later');
                  }else{
                    msg.reply('Task Added');
                  }
                });
            }
          });   
    }else{
        msg.reply("No task was provided");
    }
}
function listTodo(msg){
    var sql="SELECT ID,num,status,description from todo WHERE user='"+msg.member.user.id+"' order by num asc";
    con.query(sql, function (err, result) {
        if (err) msg.reply('Could not access tasks, please try again later');
        let ret="";
        result.forEach(row=>{
            ret+=(row.status?"[X]":"[ ]")+row.num+". "+row.description+"\r\n";
        });
        msg.reply((msg==""?"No tasks found":ret));
    });
}
function finishTodo(msg){
    let args=msg.content.split(" ");
    if(args[1]){
        var sql = "UPDATE todo set status=1 where user='"+msg.member.user.id+"' and num ="+args[1];
        con.query(sql, function (err, result) {
          if (err){
            msg.reply('Task was not finished, please try again later');
          }else{
            msg.reply('Task Finished');
          }
        });   
    }else{
        msg.reply("No task number provided")
    }
}
function removeTodo(msg){
    let args=msg.content.split(" ");
    if(args[1]){
        var sql = "delete from todo where user='"+msg.member.user.id+"' and num ="+args[1];
        con.query(sql, function (err, result) {
          if (err){
            msg.reply('Task was not removed, please try again later');
          }else{
            msg.reply('Task Removed');
          }
        });   
    }else{
        msg.reply("No task number provided")
    }
}
function play(msg){
    let args=msg.content.split(" ");
    if(args[1]){
        if(args[1].startsWith("https://www.youtube.com/watch")){
            if (msg.member.voiceChannel) {
                const connection = msg.member.voiceChannel.join().then(connection=>{
                    const stream = ytdl(args[1], { filter : 'audioonly' });
                    const dispatcher = connection.playStream(stream);
                  })
                  .catch(console.error);
            } else {
                msg.reply('You need to join a voice channel first');
            }   
        }else{
            msg.reply('Link has to be a youtube video');
        }   
    }else{
        msg.reply("No link was provided");
    }
}
function stop(msg){
    if(msg.member.voiceChannel){
        msg.member.voiceChannel.leave();
    }
}
function cleanHtml(html){
    return html.replace(/<[^>]*>?/gm,'').replace(/&lt;/gi,'<').replace(/&gt;/gi,'>');
}
function searchHtml(msg){
    let args=msg.content.split(" ");
    if(args[1]){
          https.get('https://www.w3schools.com/tags/tag_'+args[1]+'.asp', function(res) {
            res.setEncoding("utf8");
            var content;
            res.on("data", function (chunk) {
                content += chunk;
            });
        
            res.on("end", function () {
                var b=content.indexOf("<h2>Definition and Usage</h2>")+29;
                var e=content.indexOf("<h2>Browser Support</h2>");
                if(b==28){
                    msg.reply('Could not find any information on this tag');
                }else{
                    var det=content.substring(b,e);
                    msg.reply(cleanHtml(det));   
                }
            });
          }).on('error', function(e) {
              msg.reply('There was an error reaching the resource website, please try again later');
          });   
    }else{
        msg.reply('Nothing to search for');
    }
}
function searchWikipedia(msg){
    let args=msg.content.split(" ");
    if(args[1]){
          https.get('https://en.wikipedia.org/wiki/'+args[1], function(res) {
            res.setEncoding("utf8");
            var content;
            res.on("data", function (chunk) {
                content += chunk;
            });
            res.on("end", function () {
                if(content){
                    var b=content.indexOf('<div class="shortdescription nomobile noexcerpt noprint searchaux" style="display:none">');
                    var e=content.indexOf('<div role="note"');
                    if(b==-1){
                        msg.reply('Could not find any information on this');
                    }else{
                        var det=content.substring(b,e);
                        longSend(msg,cleanHtml(det));
                        //msg.reply(cleanHtml(det));   
                    }   
                }else{
                    msg.reply('Could not find anything');
                }
            });
          }).on('error', function(e) {
              msg.reply('There was an error reaching the resource website, please try again later');
          });   
    }else{
        msg.reply('Nothing to search for');
    }
}
function ascii(msg){
    let args=msg.content.split(" ");
    let art='';
    if(args[1]){
        for(i=1;i<args.length;i++){
            art+=args[i]+"+";
        }
        art=art.slice(0,-1)
        http.get('http://artii.herokuapp.com/make?text='+art, (resp) => {
            let data = '';
            resp.on('data', (chunk) => {
                data += chunk;
            });
            resp.on('end', () => {
                msg.reply('```\r\n'+data+'```');
            });
        });        
    }else{
        msg.reply('Please provide a word or phrase')
    }
}
function help(msg){
    msg.member.send(`Here is a list of all the commands I support:\r\n
!ping: The bot will respond with pong, used for testing\r\n
!weather: Provide a location and to get a weather report for that area\r\n
!dateTime: Provides the current time for the bot's location\r\n
!rollDice: Give the size of the die and number of them (if > 1) to simulate dice roling\r\n
!onlineMembers: Lists all online members\r\n
!offlineMembers: Lists all offline members\r\n
!afkMembers: Lists all afk members\r\n
!dndMembers: Lists all do not disturb members\r\n
!magic8: Get a magic 8 ball like response\r\n
!help: For some reason I think you already know what this does (sends dm with bot informtation)\r\n
!createChannel: Provide a channel name and a channel type (voice/text) to create a channel\r\n
!createRole: Provide a role name to create a roll\r\n
!kickAFK: Provide a number of days and users that have been offline for that amount will be kicked\r\n
!addSelfRole: Provide a @role to assign it to yourself\r\n
!addOtherRole: Provide a @role and a @user to assign the role to the user\r\n
!kick: Provide a @user to kick them\r\n
!ban: Provide a @user to ban them\r\n
!mute: Provide a @user to mute them\r\n`);
msg.member.send(`!unmute: Provide a @user to unmute them\r\n
!clearChannel: Provide a number of messages to delete and a #channel to mass delete messages\r\n
!addTodo: Provide a task to add it to your todo list\r\n
!listTodo: Lists all tasks in your todo list\r\n
!finishTodo: Provide a task number to mark it as completed\r\n
!removeTodo: Provide a task number to remove it\r\n
!play: Provide a youtube link to play audio in your current voice channel\r\n
!stop: Stop the bot from playing music\r\n
!html: Provide a html tag to get info on it\r\n
!wiki: Get a short snippet from wikipedia about something\r\n
!joke: Get a random joke\r\n
!fact: Get a random fact\r\n
!ascii: Provide text to get the ascii art version of it\r\n
!pokemon: Provide a pokemon name to get its stats\r\n
!trump: Gets a random trump quote\r\n
!advice: Gives dad advice\r\n
!taco: Give a random taco recipe\r\n
!trivia: Gives a random trivia question\r\n
!nasa: Provides NASA picture of the day\r\n
!meme: Provides a random meme from reddit (USE WITH CAUTION AS THESE ARE TRULY RANDOM)\r\n`);
}
client.on('ready', ()=>{
    console.log('Logged in as '+client.user.tag);
});
client.on('message', msg=>{
    if(msg.content.charAt(0) ==='!'){
        if(msg.content==='!ping'){
            msg.reply('pong');
        }else if(msg.content.startsWith('!weather')){
           getWeather(msg);
        }else if(msg.content.startsWith('!dateTime')){
            getDateTime(msg);
        }else if(msg.content.startsWith('!rollDice')){
            rollDice(msg);
        }else if(msg.content.startsWith('!onlineMembers')){
            getUsers(msg,'online');
        }else if(msg.content.startsWith('!offlineMembers')){
            getUsers(msg,'offline');
        }else if(msg.content.startsWith('!afkMembers')){
            getUsers(msg,'idle');
        }else if(msg.content.startsWith('!dndMembers')){
            getUsers(msg,'dnd');
        }else if(msg.content.startsWith('!magic8')){
            magicEight(msg);
        }else if(msg.content.startsWith('!help')){
            help(msg);
        }else if(msg.content.startsWith('!createChannel')&&isAdmin(msg)){
            createChannel(msg);
        }else if(msg.content.startsWith('!createRole')&&isAdmin(msg)){
            createRole(msg);
        }else if(msg.content.startsWith('!kickAFK')&&isAdmin(msg)){
            kickAfk(msg);
        }else if(msg.content.startsWith('!addSelfRole')&&isAdmin(msg)){
            addSelfRole(msg);
        }else if(msg.content.startsWith('!addOtherRole')&&isAdmin(msg)){
            addOtherRole(msg);
        }else if(msg.content.startsWith('!kick')&&isAdmin(msg)){
            kickUser(msg);
        }else if(msg.content.startsWith('!ban')&&isAdmin(msg)){
            banUser(msg);0
        }else if(msg.content.startsWith('!mute')&&isAdmin(msg)){
            muteUser(msg,true);
        }else if(msg.content.startsWith('!unmute')&&isAdmin(msg)){
            muteUser(msg,false);
        }else if(msg.content.startsWith('!clearChannel')&&isAdmin(msg)){
            clearChannel(msg);
        }else if(msg.content.startsWith('!addTodo')){
            addTodo(msg);
        }else if(msg.content.startsWith('!listTodo')){
            listTodo(msg);
        }else if(msg.content.startsWith('!finishTodo')){
            finishTodo(msg);
        }else if(msg.content.startsWith('!removeTodo')){
            removeTodo(msg);
        }else if(msg.content.startsWith('!play')){
            play(msg);
        }else if(msg.content.startsWith('!stop')){
            stop(msg);
        }else if(msg.content.startsWith('!html')){
            searchHtml(msg);
        }else if(msg.content.startsWith('!wiki')){
            searchWikipedia(msg);
        }else if(msg.content.startsWith('!ascii')){
            ascii(msg);
        }else if(msg.content.startsWith('!joke')){
            getJoke(msg);
        }else if(msg.content.startsWith('!fact')){
            getFact(msg);
        }else if(msg.content.startsWith('!pokemon')){
            pokemon(msg);
        }else if(msg.content.startsWith('!trump')){
            trump(msg);
        }else if(msg.content.startsWith('!advice')){
            advice(msg);
        }else if(msg.content.startsWith('!taco')){
            taco(msg);
        }else if(msg.content.startsWith('!trivia')){
            trivia(msg);
        }else if(msg.content.startsWith('!nasa')){
            nasa(msg);
        }else if(msg.content.startsWith('!meme')){
            meme(msg);
        }
    }else{  
    }
});
client.login(auth.token);