package BrotGames.HubSystem.Main;

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

import org.bukkit.Bukkit;

public class MySQL {

	public static String username;
	public static String password;
	public static String database;
	public static String host;
	public static String port;
	public static Connection con;

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

	public static void close() {
		if (isConnected()) {
			try {
				con.close();
				Bukkit.getConsoleSender().sendMessage(
						HubSystem.getInstance().pr
								+ "MySQL Verbindung gestoppt!");
			} catch (SQLException e) {
				e.printStackTrace();
			}

		}
	}

	public static boolean isConnected() {
		return con != null;

	}

	public static void createTable() {
		// Spielername, UUID, Ende, Grund
		if (isConnected()) {
			try {
				con.createStatement().executeUpdate("CREATE TABLE IF NOT EXISTS BannedPlayers (Spielername VARCHAR(100), UUID VARCHAR(100), Ende VARCHAR(100), Grund VARCHAR(100)");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}

}