package net.test;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.entity.PlayerDeathEvent;
import org.bukkit.plugin.java.JavaPlugin;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

import org.bukkit.event.player.PlayerDropItemEvent;
import org.bukkit.entity.Player;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.bukkit.ChatColor;
import org.bukkit.Material;
import org.bukkit.command.Command;
import org.bukkit.command.CommandExecutor;
import org.bukkit.command.CommandSender;

public class TutMain extends JavaPlugin implements Listener, CommandExecutor{
    private Connection connection;
    private String host, database, username, password;
    private int port;
    public void onEnable(){
        host = "localhost";
        port = 3306;
        database = "rank";
        username = "xd";
        password = "xd";

        getLogger().info("Plugin wlaczony");
        getServer().getPluginManager().registerEvents(this, this);

    }
    public void openConnection() throws SQLException, ClassNotFoundException {
        if (connection != null && !connection.isClosed()) {
            return;
        }

        synchronized (this) {
            if (connection != null && !connection.isClosed()) {
                return;
            }
            Class.forName("com.mysql.jdbc.Driver");
            connection = (Connection) DriverManager.getConnection("jdbc:mysql://" + this.host+ ":" + this.port + "/" + this.database, this.username, this.password);
        }
    }
    public void onDisable(){
        getLogger().info("Plugin wylaczony");
    }
    @EventHandler
    public void onDrop(PlayerDropItemEvent event) {
        Player player=event.getPlayer();
        if(event.getItemDrop().getItemStack().getType()==Material.STONE){
            event.setCancelled(true);
            player.sendMessage(ChatColor.YELLOW+"[AntyDrop] "+ChatColor.GREEN+" Drop jest tymczasowo wylaczony!");
        }
    }
    @Override
    public boolean onCommand(CommandSender sender, Command cmd, String arg, String[] args){
        if(cmd.getName().equalsIgnoreCase("drop_test")){
            sender.sendMessage(ChatColor.YELLOW+"[AntyDrop] "+ChatColor.GREEN+" Reload udany!");
        }
        return false;
    }
    @EventHandler
    public void onPlayerDeath(PlayerDeathEvent event) {
        Player player = event.getEntity().getPlayer();
        //This is the player who is killed

        Player killer = event.getEntity().getKiller();
        //This is the killer

        //Now you can use "player" and "killer" like so: (Example)
        try {
            openConnection();
            Statement statement = (Statement) connection.createStatement();
            ResultSet result = statement.executeQuery("SELECT * FROM rank WHERE uuid = "+killer.getUniqueId().toString());
            ArrayList<String> bankruptPlayers = new ArrayList<String>();
            while (result.next()) {
                String name = result.getString("PLAYERNAME");
                bankruptPlayers.add(name);
            }
            if(bankruptPlayers.size()==0){
                statement.executeUpdate("INSERT INTO `rank`(`uuid`, `name`) VALUES ("+killer.getUniqueId().toString()+","+killer.getDisplayName()+")");
            }else{
                statement.executeUpdate("UPDATE `rank` SET `kills`=`kills` + 1 WHERE `uuid` = "+killer.getUniqueId().toString());

            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        killer.sendMessage("You killed " + player.getName() + "!");
        player.sendMessage(killer.getName() + " killed you!");
    }
}