package de.GamingWolves.MySQL;

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 de.GamingWolves.Lobby.Main;
import net.md_5.bungee.api.ChatColor;


public class MySQL {

	public static String host ="127.0.0.1";
	public static String port ="3306";
	public static String datebase = "lobby";
	public static String username = "root";
	public static String password = "";
	public static Connection con;


	public static void connect(){
		if(!isConnected()){
			try {
				con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + datebase,username,password);
				Bukkit.getConsoleSender().sendMessage(ChatColor.GREEN + "[MySQL] Verbindung aufgebaut!");
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}


	public static void disConnect(){
		if(isConnected()){
			try {
				con.close();
				Bukkit.getConsoleSender().sendMessage(ChatColor.RED + "[MySQL] Verbindung geschlossen!");
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	public static boolean isConnected(){
		return(con == null ? false : true);
	}



	public static Connection getConnection(){
		return con;
	}

	public static void checkMySQLConnection(Player p){
		String state = null;

		if(con == null){
			state = "§cnicht verbunden";
		}else if(con != null){
			state = "§averbunden";
		}
		if(p instanceof Player){
			p.sendMessage(Main.prefix + ChatColor.GOLD + "Der Aktuelle MySQL Status: " + state);
		}else{
			Bukkit.getConsoleSender().sendMessage(Main.prefix + ChatColor.GOLD + "Der Aktuelle MySQL Status: " + state);

		}

	}



	public static boolean isUserInDatabase(String uuid){
		try{
			PreparedStatement ps = con.prepareStatement("SELECT * FROM `hideplayer` WHERE UUID = ?");
			ps.setString(1, uuid);
			ResultSet rs = ps.executeQuery();
			return rs.next();
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}

	public static boolean isWarpNameInDatabase(String WarpName){
		try{
			PreparedStatement ps = con.prepareStatement("SELECT * FROM `warps` WHERE Name = ?");
			ps.setString(1, WarpName);
			ResultSet rs = ps.executeQuery();
			return rs.next();
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}
	public static boolean isUserWithBootsinDatabase(String uuid){

		try{
			PreparedStatement ps = con.prepareStatement("SELECT * FROM `boots` WHERE UUID = ?");
			ps.setString(1, uuid);
			ps.execute();
		}catch (SQLException e) {

		}

		return false;

	}
	public static boolean isUserInDatabase_Boots0(String uuid, String Boots){

		try{
			PreparedStatement ps = con.prepareStatement("SELECT * FROM ");
			ps.setString(1, uuid);
			ps.setString(2, Boots);
		}catch (SQLException e) {

		}

		return false;

	}

}