package me.velxcity.nextbuilderts3system;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.bukkit.plugin.java.JavaPlugin;

public class Main extends JavaPlugin {

    public static String prefix = "§7[§aVerify§7] ";
    public static MySQL mysql;

    @Override
    public void onDisable() {

    }

    @Override
    public void onEnable() {
        getCommand("verify").setExecutor(new Commands());
        getCommand("unverify").setExecutor(new Commands());
        mysql = new MySQL("213.202.228.75", "admin", "d7a5e07a7175f9f88fbb3212", "Teamspeak");
        mysql.connect();
        mysql.createTable("Teamspeak", "NAME VARCHAR(100), UUID VARCHAR(100), ID VARCHAR(100), RANG INTEGER, TYPE INTEGER");
    }

    public static boolean UUIDExist(String ID) {
        try {
            ResultSet rs = mysql.getResult("SELECT * FROM Teamspeak WHERE ID= '" + ID + "'");
            if(rs.next()) {
                return rs.getString("ID") != null;
            }
        }catch(SQLException e) {
            e.printStackTrace();
        }
        return false;
    }


    public static boolean NameExist(String Name) {
        try {
            ResultSet rs = mysql.getResult("SELECT * FROM Teamspeak WHERE NAME= '" + Name + "'");
            if(rs.next()) {
                return rs.getString("UUID") != null;
            }
        }catch(SQLException e) {
            e.printStackTrace();
        }
        return false;
    }


    public static boolean playerExist(String UUID) {
        try {
            ResultSet rs = mysql.getResult("SELECT * FROM Teamspeak WHERE UUID= '" + UUID + "'");
            if(rs.next()) {
                return rs.getString("NAME") != null;
            }
        }catch(SQLException e) {
            e.printStackTrace();
        }
        return false;
    }

    public static void createPlayer(String Name, String uuid, String ID, String rang) {
        if(!(playerExist(uuid))) {
            int Rang = 0;
            if(rang.equalsIgnoreCase("Admin")) {
                Rang = 85;
            }else {
                Rang = 86;
            }
            mysql.update("INSERT INTO Teamspeak(NAME, UUID, ID, RANG, TYPE) VALUES ('" + Name + "', '" + uuid + "', '" + ID + "', '" + rang + "', 0");
        }
    }
    public static void Delete(String Name) {
        mysql.update("DELETE FROM Teamspeak WHERE NAME= '" + Name + "'");
    }
    public static void DeleteUUID(String UUID) {
        mysql.update("DELETE FROM Teamspeak WHERE UUID= '" + UUID + "'");
    }

    public static void updateRang(String UUID, String Rang) {
        int ID = 0;
        if(Rang.equalsIgnoreCase("Admin")) {
            ID = 85;
        }else {
            ID = 86;
        }
        mysql.update("UPDATE Teamspeak SET RANG= '" + ID + "' WHERE UUID= '" + UUID + "'");
    }
    public static void updateType(String NAME, int i) {
        mysql.update("UPDATE Teamspeak SET TYPE='" + i + "' WHERE NAME= '" + NAME + "'");
    }
    public static Integer getTyoe(String uuid) {
        int i = 0;
        try {
            ResultSet rs = mysql.getResult("SELECT * FROM Teamspeak WHERE UUID='" + uuid + "'");
            if((!rs.next()) || (Integer.valueOf(rs.getInt("TYPE")) == null));
            i = rs.getInt("TYPE");
            return i;
        }catch(SQLException e) {
            e.printStackTrace();
        }
        return 0;
    }

}