package de.xplore.bansystembungee;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.UUID;

import net.md_5.bungee.api.event.PreLoginEvent;
import net.md_5.bungee.api.plugin.Listener;
import net.md_5.bungee.api.plugin.Plugin;
import net.md_5.bungee.event.EventHandler;

public class Main extends Plugin implements Listener{

	public void onEnable(){
		try {
			PropertyMethod.load();
		} catch (IOException e) {
			e.printStackTrace();
		}
		MySQLMethod.open();
		getProxy().getPluginManager().registerListener(this, this);
	}

	@EventHandler
	public void onPreLogin(PreLoginEvent ev){
		UUID connectionUUID = ev.getConnection().getUniqueId();
		ResultSet resultSet = MySQLMethod.select("SELECT banid, banreason, date, enddate FROM x_ban WHERE banneduuid = '" + connectionUUID.toString() + "'");
		try {
			if(resultSet.next()){
				if(new Date().before(resultSet.getDate("enddate"))){
					ev.setCancelled(true);
					ev.setCancelReason(resultSet.getString("banreason"));
				}
				else{
					MySQLMethod.insert("DELETE FROM x_ban WHERE banid = " + resultSet.getInt("banid"));
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}