package de.mcown.main;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.bukkit.Bukkit;

import de.mcown.mysql.MySQL;

public class BanManager {

	public static void ban(String uuid,String playername,String reason) {

		MySQL.update("INSERT INTO BannedPlayers (Spielername,UUID,Grund) VALUES ('"+playername+"','"+uuid+"','"+reason+"')");

	}
	public static void unban(String uuid) {
		MySQL.update("DELETE FROM BannedPlayers WHERE UUID='"+uuid+"'");
	}
	public static boolean isbanned(String uuid) {
		ResultSet rs = MySQL.getResault("SELECT * FROM BannedPlayers WHERE UUID='"+uuid+"'");
		try {
			return rs.next();
		} catch (SQLException e) {

			e.printStackTrace();
		}
		return false;
	}
	public static String getReason(String uuid) {
		ResultSet rs = MySQL.getResault("SELECT * FROM BannedPlayers WHERE UUID='"+uuid+"'");
		try {
			while(rs.next()) {
				return rs.getString("Grund");
			}
		}catch(SQLException e)
		{
			e.printStackTrace();
		}
		return "";

	}
	public static List<String> getBannedPlayers() {
		List<String> list = new ArrayList<String>();
		ResultSet rs = MySQL.getResault("SELECT * FROM BannedPlayers");
		try {
			while(rs.next()) {
				list.add(rs.getString("Spielername"));
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}
		return list;
	}

}