package me.aberdeener.vaultcore.listeners;

import java.sql.SQLException;

import org.bukkit.ChatColor;
import org.bukkit.Statistic;
import org.bukkit.entity.Player;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.player.PlayerJoinEvent;

import me.aberdeener.vaultcore.VaultCore;

public class PlayerJoinListener implements Listener {

    @EventHandler
    public void onJoin(PlayerJoinEvent join) throws SQLException {

        Player player = join.getPlayer();

        String uuid = player.getUniqueId().toString();

        String username = player.getName();

        long firstseen = player.getFirstPlayed();

        long lastseen = player.getLastPlayed();

        long playtime = player.getStatistic(Statistic.PLAY_ONE_MINUTE);

        String rank = VaultCore.getChat().getPrimaryGroup(player).toString();

        String ip = player.getAddress().getAddress().getHostAddress().toString();

        join.setJoinMessage(
                ChatColor.YELLOW + player.getName() + " has " + ChatColor.GREEN + "joined" + ChatColor.YELLOW + ".");

        // send message from config
        player.sendMessage(ChatColor.translateAlternateColorCodes('&',
                VaultCore.getInstance().getConfig().getString("welcome-message")));

        VaultCore.getInstance().connection.createStatement()
                .executeUpdate("INSERT INTO players (uuid, username, firstseen, lastseen, playtime, rank, ip) VALUES ("
                        + uuid + ", " + username + ", " + firstseen + ", " + lastseen + ", " + playtime + ", " + rank
                        + ", " + ip + ");");
    }
}