package me.boykev.firekingdom;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.UUID;

import org.bukkit.entity.Player;

public class SqlManagement {
	private Main instance;
	public Connection con;
	private DatabaseManager db;
	private String host, database, username, password;
	private int port;

    public SqlManagement(Main main) {
		this.instance = main;
	}

    public void openConnection() throws SQLException, ClassNotFoundException {
    	db = new DatabaseManager(instance);
    	host = db.getConfig().getString("db.host");
    	database = db.getConfig().getString("db.database");
    	port = db.getConfig().getInt("db.port");
    	username = db.getConfig().getString("db.username");
    	password = db.getConfig().getString("db.password");
    if (con != null && !con.isClosed()) {
        return;
    }

    synchronized (this) {
        if (con != null && !con.isClosed()) {
            return;
        }
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://" + this.host + ":" + this.port + "/" + this.database, this.username, this.password);
    }
}

	public void setSql(Player p, String string) {
    	UUID uuid = p.getUniqueId();
        try {
            openConnection();
            Statement statement = con.createStatement();
            statement.executeUpdate("INSERT INTO PlayerData (PLAYERNAME, UUID, STATUS) VALUES ('" + p.getName() + "', '" + uuid + "', '" + string + "');");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }

	}
    public boolean checkSql(Player p, String string, UUID uuid) {
        try {
        	openConnection();
            Statement statement = con.createStatement();
            ResultSet result = statement.executeQuery("SELECT * FROM PlayerData WHERE UUID = '" + p.getUniqueId() + "'");
            while (result.next()) {
            	String status = result.getString("STATUS");
            	if(status.equals("valid")){
            		return true;
            	}
            	return false;
            }


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

	}


}