var Discord = require('discord.js');
var client = new Discord.Client();
var oke = require('request');
var url = 'http://94.177.231.83:28961';
var url1 = 'http://94.177.231.83:28962';
var mysql = require('mysql');
var id;
var name;
var result;
var connection = mysql.createConnection({
		host: '94.177.231.83',
		user: 'root',
		password: 'slawek1',
		database: 'b3'
	 });



client.on('message', e =>
{
value = e.content.split(" ")[1];

  if (e.content === '!guly') {
    e.channel.sendMessage('is siq :100:');
  }


  else if (e.content === '!vvlnt' || e.content === '!wlnt') {
    e.channel.sendMessage('suqs');
  }


  else if (e.content === '!status' || e.content === '!s') {
	    e.channel.sendMessage("**Server Status**");
		oke(url, function (error) {
		if(!error){
		e.channel.sendMessage("```Guly TSD [ONLINE]\n```");
		}
		else if(error){
		e.channel.sendMessage("```Guly TSD [OFFLINE]\n```");
			}
		});

		oke(url1, function (error) {
		if(!error){
		e.channel.sendMessage("```Guly FFA Last Nice [ONLINE]```");
		}
		else if(error){
		e.channel.sendMessage("```Guly FFA Last Nice [OFFLINE]```");
			}
		});
}
	else if (e.content === '!name', value )   <----- BUGUJE SIE COŚ ZLEW NO
	{
	id = value;
	connection.query('SELECT `name` FROM `clients` WHERE `id` = ' + id, function (err,result)
	{
	    e.channel.sendMessage("**Success!**\n");
		e.channel.sendMessage("**\nPlayer Nickname:**"+"```"+ result[0].name + "```");
		console.log(result[0].name)
		connection.destroy();
	});
	}


});

client.login('MjMyNTU2Nzg0MTg1OTAxMDU5.CtQo9Q.OBxfJscH1vy_NhPKz3D9oKKquhI');