package me.advancepunishments.commands;

import me.advancepunishments.util.MySQL;
import org.bukkit.Bukkit;
import org.bukkit.OfflinePlayer;
import org.bukkit.command.Command;
import org.bukkit.command.CommandExecutor;
import org.bukkit.command.CommandSender;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * Created by BladianYT
 */
public class ComIP implements CommandExecutor
{

    private Connection connection = MySQL.connection;

    @Override
    public boolean onCommand(CommandSender commandSender, Command command, String s, String[] strings)
    {
        if (command.getName().equalsIgnoreCase("ip"))
        {
            if (!commandSender.hasPermission("rank.admin"))
            {
                return true;
            }
            if (strings.length == 0)
            {
                commandSender.sendMessage("§c/ip <player>");
                return true;
            }
            OfflinePlayer t = Bukkit.getOfflinePlayer(strings[0]);
            final String URL = "jdbc:mysql://localhost:3306/";
            final String USER = "root";
            final String PASSWORD = "2QzvUr6En4pP";
            final String DATABASE = "serenity";
            final String TABLE = "ip";
            commandSender.sendMessage("§aStarted finding all IP's related to " + t.getName());
            try
            {
                connection = DriverManager.getConnection(URL, USER, PASSWORD);
                PreparedStatement statement = connection.prepareStatement("USE `" + DATABASE + "`;");
                statement.executeUpdate();
                PreparedStatement statement1 = connection.prepareStatement("SELECT * FROM `ip` WHERE `uuid` = ?;");
                statement1.setString(1, t.getUniqueId().toString());
                statement1.executeQuery();
                ResultSet rs = statement1.getResultSet();
                if (rs.isBeforeFirst())
                {
                    commandSender.sendMessage("§aIP's§7 related to §6" + t.getName() + ":");
                    while (rs.next())
                    {
                        commandSender.sendMessage("§7   -§c " + rs.getString("ip"));
                    }

                }
                else
                {
                    commandSender.sendMessage("§cPlayer has no IP's on the server or doesn't exist");
                }
            } catch (SQLException e)
            {
                e.printStackTrace();
            }
        }
        return false;
    }
}