package fr.thedarven.statistiques;

import java.io.File;
import java.io.FileWriter;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

import org.bukkit.ChatColor;
import org.bukkit.Material;
import org.bukkit.entity.Player;
import org.bukkit.plugin.java.JavaPlugin;
import org.bukkit.potion.PotionEffect;
import org.bukkit.potion.PotionEffectType;
import fr.thedarven.events.Commandes;
import fr.thedarven.events.EventsManager;

public class Statistiques extends JavaPlugin{

	public SqlConnection sql;
	public static Statistiques instance;
	public static Statistiques getInstance(){
		return instance;
	}

	// je propose que lorsqu'on tombe dans le vide, on est téléporté au spawn MAIS on perd 50% de notre stuff
	// COLLISION OFF
	public static float strength[] = {100,500,1000,5000,10000};
	public static float agility[] = {1000,10000,50000,100000,500000};
	public static float haste[] = {3456,17280,43200,86400,172800};
	public static float poison_resistance[] = {100,200,500,1000,5000};
	public static float fire_resistance[] = {100,200,500,1000,5000};
	public static float all_resistance[] = {500,1000,2000,5000,10000};
	public static float falling_resistance[] = {100,500,1000,2000,5000};

	public static Material hasteExp[] = {Material.STONE, Material.COBBLESTONE, Material.SMOOTH_BRICK};

	public void onEnable(){
		instance = this;

		EventsManager.registerEvents(this);
		sql = new SqlConnection("jdbc:mysql://","localhost","semi-rp","root","");
        sql.connection();

        try{
			File ff = new File("plugins//Statistiques//logs.txt");
			ff.createNewFile();
			FileWriter ffw=new FileWriter(ff, true);
			DateFormat dateFormat = new SimpleDateFormat("[dd/MM/yyyy][HH:mm:ss]");
			Date date = new Date();
			ffw.write(dateFormat.format(date)+" ==================== SERVEUR OUVERT ====================");
			ffw.write("\r\n");
			ffw.close();
		} catch (Exception ee) {}

        getCommand("stats").setExecutor(new Commandes());
	}

	public void onDisable(){
        sql.disconnect();
        try{
			File ff = new File("plugins//Statistiques//logs.txt");
			ff.createNewFile();
			FileWriter ffw=new FileWriter(ff, true);
			DateFormat dateFormat = new SimpleDateFormat("[dd/MM/yyyy][HH:mm:ss]");
			Date date = new Date();
			ffw.write(dateFormat.format(date)+" ==================== SERVEUR FERME ====================");
			ffw.write("\r\n");
			ffw.close();
		} catch (Exception ee) {}
    }

	public static boolean changeLevel(float[] str, int level, int valor, Player player, String stats){
		for(int i = 0; i < str.length; i++){
			if(str[i] <= valor && i+1 > level){
				switch (stats){
					case "strength":
						try {
							PreparedStatement q = SqlConnection.connection.prepareStatement("UPDATE players SET strength = ? WHERE uuid = ?");
				            q.setInt(1, i+1);
							q.setString(2, player.getUniqueId().toString());
				            q.execute();
				            q.close();
				        } catch (SQLException error) {
				        	error.printStackTrace();
				        }

						level++;
						player.sendMessage(ChatColor.GREEN+"Félicitations, vous avez débloqué "+ChatColor.RED+"✽Force "+level);

						setEffet(player);
						return true;
					case "agility":
						try {
							PreparedStatement q = SqlConnection.connection.prepareStatement("UPDATE players SET agility = ? WHERE uuid = ?");
				            q.setInt(1, i+1);
							q.setString(2, player.getUniqueId().toString());
				            q.execute();
				            q.close();
				        } catch (SQLException error) {
				        	error.printStackTrace();
				        }

						level++;
						player.sendMessage(ChatColor.GREEN+"Félicitations, vous avez débloqué "+ChatColor.AQUA+"❄Agilité "+level);

						setEffet(player);
						return true;
					case "haste":
						try {
							PreparedStatement q = SqlConnection.connection.prepareStatement("UPDATE players SET haste = ? WHERE uuid = ?");
				            q.setInt(1, i+1);
							q.setString(2, player.getUniqueId().toString());
				            q.execute();
				            q.close();
				        } catch (SQLException error) {
				        	error.printStackTrace();
				        }

						level++;
						player.sendMessage(ChatColor.GREEN+"Félicitations, vous avez débloqué "+ChatColor.AQUA+"❃Haste "+level);

						setEffet(player);
						return true;
					case "poison_resistance":
						try {
							PreparedStatement q = SqlConnection.connection.prepareStatement("UPDATE players SET poison_resistance = ? WHERE uuid = ?");
				            q.setInt(1, i+1);
							q.setString(2, player.getUniqueId().toString());
				            q.execute();
				            q.close();
				        } catch (SQLException error) {
				        	error.printStackTrace();
				        }

						level++;
						player.sendMessage(ChatColor.GREEN+"Félicitations, vous avez débloqué "+ChatColor.AQUA+"❃Résistance au poison "+level);

						setEffet(player);
						return true;
					case "fire_resistance":
						try {
							PreparedStatement q = SqlConnection.connection.prepareStatement("UPDATE players SET fire_resistance = ? WHERE uuid = ?");
				            q.setInt(1, i+1);
							q.setString(2, player.getUniqueId().toString());
				            q.execute();
				            q.close();
				        } catch (SQLException error) {
				        	error.printStackTrace();
				        }

						level++;
						player.sendMessage(ChatColor.GREEN+"Félicitations, vous avez débloqué "+ChatColor.AQUA+"❃Résistance au feu "+level);

						setEffet(player);
						return true;
					case "falling_resistance":
						try {
							PreparedStatement q = SqlConnection.connection.prepareStatement("UPDATE players SET falling_resistance = ? WHERE uuid = ?");
				            q.setInt(1, i+1);
							q.setString(2, player.getUniqueId().toString());
				            q.execute();
				            q.close();
				        } catch (SQLException error) {
				        	error.printStackTrace();
				        }

						level++;
						player.sendMessage(ChatColor.GREEN+"Félicitations, vous avez débloqué "+ChatColor.AQUA+"❃Résistance à la chute "+level);

						setEffet(player);
						return true;
					case "all_resistance":
						try {
							PreparedStatement q = SqlConnection.connection.prepareStatement("UPDATE players SET all_resistance = ? WHERE uuid = ?");
				            q.setInt(1, i+1);
							q.setString(2, player.getUniqueId().toString());
				            q.execute();
				            q.close();
				        } catch (SQLException error) {
				        	error.printStackTrace();
				        }

						level++;
						player.sendMessage(ChatColor.GREEN+"Félicitations, vous avez débloqué "+ChatColor.AQUA+"❃Résistance au front "+level);

						setEffet(player);
						return true;
					default:
				    /*Action*/;
				}
			}
		}
		return false;
	}

	public static void setEffet(Player player){
		int agilityLevel = 0;
		boolean agilityActive = true;
		int hasteLevel = 0;
		boolean hasteActive = true;

		try {
            PreparedStatement q = SqlConnection.connection.prepareStatement("SELECT agility,agility_active FROM players WHERE uuid = ?");
            q.setString(1, player.getUniqueId().toString());
            ResultSet resultat = q.executeQuery();
            while(resultat.next()){
            	 agilityLevel = resultat.getInt("agility");
            	 agilityActive = resultat.getBoolean("agility_active");
            }
            q.close();

            if(agilityActive == true){
            	switch(agilityLevel){
				case 1:
					player.setWalkSpeed(0.215F);
				break;
				case 2:
					player.setWalkSpeed(0.23F);
				break;
				case 3:
					player.setWalkSpeed(0.245F);
				break;
				case 4:
					player.setWalkSpeed(0.26F);
				break;
				case 5:
					player.setWalkSpeed(0.275F);
				break;
				default:
					player.setWalkSpeed(0.2F);
	            }
            }else{
            	player.setWalkSpeed(0.2F);
            }

        } catch (SQLException error) {
        	error.printStackTrace();
        }

		try {
            PreparedStatement q = SqlConnection.connection.prepareStatement("SELECT haste,haste_active FROM players WHERE uuid = ?");
            q.setString(1, player.getUniqueId().toString());
            ResultSet resultat = q.executeQuery();
            while(resultat.next()){
            	 hasteLevel = resultat.getInt("haste");
            }
            q.close();

            if(hasteActive == true){
	            switch(hasteLevel){
				case 1:
					player.removePotionEffect(PotionEffectType.FAST_DIGGING);
					player.addPotionEffect(new PotionEffect(PotionEffectType.FAST_DIGGING, 100000, 0));
				break;
				case 2:
					player.removePotionEffect(PotionEffectType.FAST_DIGGING);
					player.addPotionEffect(new PotionEffect(PotionEffectType.FAST_DIGGING, 100000, 0));
				break;
				case 3:
					player.removePotionEffect(PotionEffectType.FAST_DIGGING);
					player.addPotionEffect(new PotionEffect(PotionEffectType.FAST_DIGGING, 100000, 0));
				break;
				case 4:
					player.removePotionEffect(PotionEffectType.FAST_DIGGING);
					player.addPotionEffect(new PotionEffect(PotionEffectType.FAST_DIGGING, 100000, 0));
				break;
				case 5:
					player.removePotionEffect(PotionEffectType.FAST_DIGGING);
					player.addPotionEffect(new PotionEffect(PotionEffectType.FAST_DIGGING, 100000, 1));
				break;
	            }
            }else{
            	player.removePotionEffect(PotionEffectType.FAST_DIGGING);
            }

        } catch (SQLException error) {
        	error.printStackTrace();
        }
	}
}