package fr.flashback083.gtm;

import java.io.IOException;
import java.sql.SQLException;
import java.util.Calendar;
import java.util.GregorianCalendar;

import com.pixelmonmod.pixelmon.Pixelmon;

import fr.flashback083.commands.GTM;
import fr.flashback083.config.SQL;
import fr.flashback083.proxy.CommonProxy;
import net.minecraftforge.common.MinecraftForge;
import net.minecraftforge.common.config.Configuration;
import net.minecraftforge.fml.common.Mod;
import net.minecraftforge.fml.common.SidedProxy;
import net.minecraftforge.fml.common.event.FMLInitializationEvent;
import net.minecraftforge.fml.common.event.FMLPostInitializationEvent;
import net.minecraftforge.fml.common.event.FMLPreInitializationEvent;
import net.minecraftforge.fml.common.event.FMLServerStartingEvent;
import net.minecraftforge.fml.common.event.FMLServerStoppingEvent;


@Mod(modid = Main.MODID, name = Main.MODNAME, version = Main.VERSION, acceptableRemoteVersions="*", acceptedMinecraftVersions="[1.10.2]", dependencies = "required-after:pixelmon", serverSideOnly = true)
public class Main {

    public static final String MODID = "globaltrademarket";
    public static final String MODNAME = "GTM";
    public static final String VERSION = "1.0.0";
    public SQL sql;


    public static org.apache.logging.log4j.Logger logger;

    @SidedProxy(clientSide = "fr.flashback083.proxy.ClientProxy" ,serverSide = "fr.flashback083.proxy.ServerProxy")
    public static CommonProxy proxy;



    @Mod.EventHandler
    public void preInit(FMLPreInitializationEvent event) throws IOException {
        logger = event.getModLog();
        proxy.preInit(event);
        Configuration cfg = CommonProxy.configbdd;
        boolean sql = cfg.get("Base de donnees","BDDSQL", false).getBoolean();
        if (sql == true) {
            this.sql = new SQL("jdbc:mysql://",cfg.getCategory("Base de donnees").get("Host").getString(),cfg.getCategory("Base de donnees").get("Database").getString(),cfg.getCategory("Base de donnees").get("User").getString(),cfg.getCategory("Base de donnees").get("MDP").getString());
            this.sql.connection();
        }



    }



    @Mod.EventHandler
    public void init(FMLInitializationEvent e) {
        proxy.init(e);
        MinecraftForge.EVENT_BUS.register(new EventHandler());
        Pixelmon.EVENT_BUS.register(new EventHandlerPixelmon());
    }

    @Mod.EventHandler
    public void postInit(FMLPostInitializationEvent e) {
        proxy.postInit(e);
    }

    @SuppressWarnings("deprecation")
    @Mod.EventHandler
    public void onServerStart(FMLServerStartingEvent e) throws SQLException {
        Configuration cfg = CommonProxy.configbdd;
        boolean sql = cfg.get("Base de donnees","BDDSQL", false).getBoolean();
        if (sql == true) {
        e.registerServerCommand(new GTM());
         Calendar c=new GregorianCalendar();
         int d =c.getTime().getDate();
         this.sql = new SQL("jdbc:mysql://",cfg.getCategory("Base de donnees").get("Host").getString(),cfg.getCategory("Base de donnees").get("Database").getString(),cfg.getCategory("Base de donnees").get("User").getString(),cfg.getCategory("Base de donnees").get("MDP").getString());
          this.sql.connection();
           String sqlReset = "UPDATE GTM SET Etat=1 WHERE Date='"+d+"'";
           java.sql.Statement stmt = this.sql.connection.createStatement();
           stmt.execute(sqlReset);

        }
    }

    @Mod.EventHandler
    public void onServerStop(FMLServerStoppingEvent e) {

    }




}