package net.minedev.cronikkk.economycraft;

import java.io.File;
import java.net.MalformedURLException;
import java.util.logging.Logger;

import org.bukkit.event.Event;
import org.bukkit.plugin.Plugin;
import org.bukkit.plugin.PluginDescriptionFile;
import org.bukkit.plugin.PluginManager;
import org.bukkit.plugin.java.JavaPlugin;
import com.alta189.sqlLibrary.MySQL.*;
import com.nijiko.permissions.PermissionHandler;
import com.nijikokun.bukkit.Permissions.Permissions;

import net.minedev.cronikkk.economycraft.SettingsHandler;

public class EconomyCraft extends JavaPlugin{
    public mysqlCore dbManager;
    public String logPrefix = "[EconomyCraft] ";
    public File pFolder = new File("plugins/EconomyCraft");
    public Logger log = Logger.getLogger("Minecraft");
    public static PermissionHandler permissionHandler;
    public SettingsHandler settings = new SettingsHandler("settings.properties", "plugins/EconomyCraft/settings.properties");
    public MoneyFunctions functions = new MoneyFunctions(this);


    //MySQL Details Variables\\
    public String dbHost = null;
    public String dbUser = null;
    public String dbPass = null;
    public String dbName = null;

    //Money Variables
    public String currencyName;
    public int startingMoney;

    @Override
    public void onEnable() {
        // Get Version Etc
        PluginDescriptionFile pdfFile = this.getDescription();

        //Plugin Manager
        PluginManager pm = this.getServer().getPluginManager();

        //Register Events
        pm.registerEvent(Event.Type.PLAYER_JOIN, new ECraftPlayerListener(this), Event.Priority.Normal, this);

        // Load Settings
        this.createPluginFolder();
        settings.load();


        //Money Variables Define
        currencyName = this.settings.getPropertyString("currencyname");
        startingMoney = this.settings.getPropertyInteger("startingcurrency");

        //Check if settings file is existant
        if(settings.file.exists()) {
            //Get Database information
            dbHost = this.settings.getPropertyString("dbhost");
            dbUser = this.settings.getPropertyString("dbuser");
            dbPass = this.settings.getPropertyString("dbpass");
            dbName = this.settings.getPropertyString("dbname");

            //Create core
            dbManager = new mysqlCore(log, logPrefix, dbHost, dbName, dbUser, dbPass);
            log.info(logPrefix + "Initializing EconomyCraft MySQL!");
            dbManager.initialize();

            try {
                //Connect to mysql (test it)
                if(dbManager.checkConnection()){
                    log.info(logPrefix + "MySQL Connection Successful!");
                    if(!dbManager.checkTable("users")) {
                        log.info(logPrefix + "Creating Users Table..");
                        String query = "CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, player VARCHAR(80), money INT);";
                        dbManager.createTable(query);
                        log.info(logPrefix + "MySQL Initilized!");
                    }
                } else {
                    log.severe(logPrefix + "MySQL Connection Failed...");
                }
            } catch (MalformedURLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (InstantiationException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (IllegalAccessException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }

        //Initiate permissions
        setupPermissions();
        log.info(logPrefix + "Permissions initated.");
        log.info(logPrefix + "v" + pdfFile.getVersion() + " started!");

        //Register commands
        getCommand("balance").setExecutor(new ECraftCommandHandler(this));
        getCommand("money").setExecutor(new ECraftCommandHandler(this));
    }

    @Override
    public void onDisable() {

    }

    private void setupPermissions() {
        Plugin permissionsPlugin = this.getServer().getPluginManager().getPlugin("Permissions");

        if (EconomyCraft.permissionHandler == null) {
            if (permissionsPlugin != null) {
                EconomyCraft.permissionHandler = ((Permissions) permissionsPlugin).getHandler();
            } else {
                log.info("Permission system not detected! ITS REQUIRED FOR THIS PLUGIN!");
            }
        }
    }

    public void createPluginFolder() {
        if (!this.pFolder.exists()) {
            pFolder.mkdir();
        }
    }
}