bot.on('message', message => {
    if (message.content.startsWith('ping')) {
    if(message.channel.type == "dm") return; {
        message.channel.send(`**Pong!**\nOdpowiadam w ciągu ${bot.ping}ms.`);
    }}

    if(!message.content.startsWith('!')) return
    if(message.channel.type == "dm") return

    const args = message.content.substring(1).split(' ')
    const cmd = args.shift()

    if (cmd === 'ticket') {
        const content = args.join(' ');
        const id = jSql.query("select from db.json").length;

        message.guild.createChannel(`ticket-${id}`).then(channel => {
            channel.overwritePermissions(message.author, { 'READ_MESSAGES': true, 'SEND_MESSAGES': true, 'CREATE_INSTANT_INVITE': false });
            channel.overwritePermissions(message.guild.roles.find(role => role.name === "Użytkownik"), { 'READ_MESSAGES': false, 'SEND_MESSAGES': false, 'CREATE_INSTANT_INVITE': false });
            channel.overwritePermissions(message.guild.roles.find(role => role.name === "@everyone"), { 'READ_MESSAGES': false, 'SEND_MESSAGES': false, 'CREATE_INSTANT_INVITE': false });
            channel.overwritePermissions(message.guild.roles.find(role => role.name === "Tickety"), { 'READ_MESSAGES': true, 'SEND_MESSAGES': true });
            channel.setParent('612221857139130378');

        const embed = new Discord.RichEmbed()
        .setAuthor("System ticketów - Server Status Checker", bot.user.avatarURL)
        .setDescription("Stworzyłeś swój ticket, gratulacje. Aktualnie przebywasz na kanale z administracją.")
        .addField("Ticket stworzony przez:", `${message.author.username}#${message.author.discriminator}`, true)
        .addField("Treść ticketa:", `${content}`, true)
        .setFooter(`Data`, bot.user.avatarURL)
        .setTimestamp()
        .setColor('#00FF00');

        const embed1 = new Discord.RichEmbed()
        .setAuthor(`System ticketów - Server Status Checker`, bot.user.avatarURL)
        .setDescription(`Udało Ci się utworzyć ticket, zajrzyj teraz do niego i posługuj się dalej wraz z instrukcją.`)
        .addField("Ticket stworzony przez:", `${message.author.username}#${message.author.discriminator}`, true)
        .addField("Kanał ticketu:", `[${channel.toString()}]`, true)
        .setFooter(`Data`, bot.user.avatarURL)
        .setTimestamp()
        .setColor('#00FF00');

    message.channel.send(embed1);

    channel.send(embed);
  });

  jSql.query(`insert into db.json { "id": ${id}, "content": "${content}", "openedby": ${message.author.id}, "closed": false, "openDate": "${new Date()}" }`);
    }

    if (cmd === 'close') {
        if (!message.member.roles.has(message.guild.roles.find(role => role.name === "Tickety").id)) return;

        const id = message.channel.name.split("ticket-")[1];

        if (!id) return;

        const ticket = jSql.query(`select from db.json where id=${id}`);

        bot.users.find(user => user.id == ticket.openedby).send("Twój ticket został zamknięty przez administrację.");

        jSql.query(`update db.json set where id=${id} { "id": ${id}, "content": "${ticket.content}", "openedby": ${ticket.openedby}, "closed": true, "openDate": "${ticket.opendate}", "closeDate": "${new Date()}" }`);

        message.channel.delete();
    }

    const cmdFile = bot.commands.get(cmd);

    if (cmdFile) {
        cmdFile.run(bot, message, args);
    }
  });