package me.hobblyhobo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.bukkit.Bukkit;
import org.bukkit.entity.Player;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.player.PlayerLoginEvent;
import org.bukkit.plugin.ServicesManager;
import org.bukkit.plugin.java.JavaPlugin;

import me.lucko.luckperms.api.LuckPermsApi;
import me.lucko.luckperms.api.User;

public class Main extends JavaPlugin implements Listener {
	private static Connection connection;
	public LuckPermsApi luckPerms;

	public void onEnable(){
		getServer().getPluginManager().registerEvents(this, this);
		ServicesManager manager = Bukkit.getServicesManager();
		if (manager.isProvidedFor(LuckPermsApi.class)) {
		    final LuckPermsApi api = manager.getRegistration(LuckPermsApi.class).getProvider();
		    luckPerms = api;
		}
	}

	public void onDisable(){
		try {
			if(connection != null && !connection.isClosed()){
				connection.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public synchronized static void openConnection() {
		try {
			connection = DriverManager.getConnection("jdbc:mysql://167.114.64.143:3306/piggpigl41854DB","piggpigl41854","bEtambyiFVJi");
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public synchronized static void closeConnection() {
		try {
			connection.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public synchronized static boolean playerDataContiansPlayer(Player player){
		try {
			PreparedStatement sql = connection
					.prepareStatement("SELECT * FROM `store_data` WHERE UUID=?;");
			sql.setString(1, player.getUniqueId().toString());
			ResultSet resultSet = sql.executeQuery();
			boolean containsPlayer = resultSet.next();
			sql.close();
			resultSet.close();

			return containsPlayer;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
	}

	public String getDonationRank(Player player){
		openConnection();
		String donationRank = "none";
		try {
			if (playerDataContiansPlayer(player)){
				PreparedStatement sql = connection.prepareStatement("SELECT donation_rank FROM `store_data` WHERE UUID=?;");
				sql.setString(1, player.getUniqueId().toString());

				ResultSet result =  sql.executeQuery();
				result.next();
				donationRank = result.getString("donation_rank");
				sql.close();
				result.close();
			} else {
				PreparedStatement newPlayer = connection.prepareStatement("INSERT INTO `store_data` values(?,?,none);");
				newPlayer.setString(1, player.getUniqueId().toString());
				newPlayer.setString(2, player.getName());
				newPlayer.execute();
				newPlayer.close();
			}

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			closeConnection();
		}
		return donationRank;
	}

	@EventHandler
	public void onPlayerEnter(PlayerLoginEvent e){
		String donationRank = getDonationRank(e.getPlayer());
		User user = luckPerms.getUser(e.getPlayer().getUniqueId());
		if (donationRank == "none"){

		}

	}

}