package me.supermaxman.xaldinguide;
import java.io.BufferedInputStream;
import com.alta189.sqlLibrary.MySQL.*;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Properties;
import java.util.Timer;
import java.util.TimerTask;
import java.util.logging.Logger;

import org.bukkit.ChatColor;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.event.Event.Priority;
import org.bukkit.event.Event;
import org.bukkit.plugin.PluginDescriptionFile;
import org.bukkit.plugin.java.JavaPlugin;

import com.mysql.jdbc.Driver;
import java.io.File;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.logging.Logger;

import me.supermaxman.xaldinguide.XaldinGuide;

import org.bukkit.ChatColor;
import org.bukkit.Server;
import org.bukkit.block.Block;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.event.Event;
import org.bukkit.plugin.PluginDescriptionFile;
import org.bukkit.plugin.PluginLoader;
import org.bukkit.plugin.PluginManager;
import org.bukkit.plugin.java.JavaPlugin;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.net.MalformedURLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Properties;
import java.util.Timer;
import org.bukkit.ChatColor;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.event.Event.Priority;
import org.bukkit.event.Event;
import org.bukkit.plugin.PluginDescriptionFile;
import org.bukkit.plugin.java.JavaPlugin;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import org.bukkit.plugin.PluginManager;
import java.sql.Connection;
import java.sql.DriverManager;

public class XaldinGuide extends JavaPlugin{
	public static XaldinGuide plugin;
	public final Logger logger = Logger.getLogger("Minecraft");
	private final XaldinGuidePlayerListener playerListener = new XaldinGuidePlayerListener(this);
	private Connection connect = null;
	private Statement statement = null;
	private PreparedStatement preparedStatement = null;
	private ResultSet resultSet = null;
    static String driver = "com.mysql.jdbc.Driver";
    static String connection = "jdbc:mysql://server.projectxaldin.com:3306/xaldin_site";
    static String user = "max";
    static String password = "pinkfluff";
    public mysqlCore manageMySQL;
	public Boolean MySQL = false;
	public String dbHost = "server.projectxaldin.com";
	public String dbUser = "max";
	public String dbPass = "pinkfluff";
	public String dbDatabase = "xaldin_site";
	public String logPrefix = "[XaldinGuide] "; // Prefix to go in front of all log entries
	public Logger log = Logger.getLogger("Minecraft"); // Minecraft log and console
	public XaldinGuide(){
	    super();
	  }
	@Override
	public void onDisable() {


		this.logger.info("XaldinGuide is Disabled.");



	}
	@Override
	public void onEnable() {
		PluginManager pm = getServer().getPluginManager();
		PluginDescriptionFile pdfFile = this.getDescription();this.logger.info( pdfFile.getName() + " version " + pdfFile.getVersion() + " is enabled!");

		pm.registerEvent(Event.Type.PLAYER_JOIN, this.playerListener, Event.Priority.Normal, this);

	}
	public boolean onCommand(CommandSender sender, Command cmd, String commandLabel, String[] args){
		if (commandLabel.equalsIgnoreCase("info") || commandLabel.equalsIgnoreCase("xaldinedge") || commandLabel.equalsIgnoreCase("xaldin")|| commandLabel.equalsIgnoreCase("projectxaldin")) {

			infoPage((Player) sender);

	}else if (commandLabel.equalsIgnoreCase("staff")){
		staffPage((Player) sender);
	}else if (commandLabel.equalsIgnoreCase("news")){
		newsPage((Player) sender);
	}else if (commandLabel.equalsIgnoreCase("rules")){
		rulesPage((Player) sender);
	}else if (commandLabel.equalsIgnoreCase("more")){

		morePage((Player) sender);
	}
	return true;
}
	public void infoPage(Player player){

			player.sendMessage(ChatColor.BLUE + "Welcome to the Xaldin Edge Minecraft Survival Server!");
			player.sendMessage(ChatColor.YELLOW + "Type /Staff for info on our Staff.");
			player.sendMessage(ChatColor.GREEN + "Type /News for the latest news.");
			player.sendMessage(ChatColor.RED + "Type /Rules for the basic regulations here.");
			player.sendMessage(ChatColor.WHITE + "Type /More for various other info.");
	}
	public void staffPage(Player player){
		player.sendMessage(ChatColor.WHITE +"Staff:");
        player.sendMessage(ChatColor.RED + "Owner: PunJedi, Michaelssiebert");
        player.sendMessage(ChatColor.YELLOW + "Admins: Puremin0rez, xMikexBx, Whosur, Booisthebest, Alutemu");
        player.sendMessage(ChatColor.BLUE + "Mods: Supermaxman, Ponadok, Subprimal, Congra, Fiftysilver");
	}
	public void newsPage(Player player){
		player.sendMessage(ChatColor.WHITE + "News:");
		player.sendMessage(ChatColor.BLUE + "Hello everyone, today we introduce McMMO for Donators!! ");
		player.sendMessage(ChatColor.BLUE + "/stats will be your most used feature.");
		player.sendMessage(ChatColor.BLUE + "Right click your tool to enable its Super Mode, ");
		player.sendMessage(ChatColor.BLUE + "as you level up your skills you can stay in your Super Mode longer!");
		player.sendMessage(ChatColor.GREEN + "Learn more at TheXaldinEdge.com");


	}
	public void rulesPage(Player player){
		player.sendMessage(ChatColor.YELLOW + "#1: No Trolling.");
		player.sendMessage(ChatColor.YELLOW + "#2: No Griefing.");
		player.sendMessage(ChatColor.YELLOW + "#3: No Stealing from other players.");
		player.sendMessage(ChatColor.YELLOW + "#4: PvP is on in the Nether.");
		player.sendMessage(ChatColor.YELLOW + "#5: Do not ask to be made a Mod or Admin.");
		player.sendMessage(ChatColor.YELLOW + "#6: Enjoy your time here at Xaldin Edge!");
	}
	public void morePage(Player player){
		player.sendMessage(ChatColor.WHITE + "Nothing here yet...");
		System.out.println("1");
		onDatabaseLoad();



	}




	public void onDatabaseLoad(){
		System.out.println("2");
		this.MySQL = true;
		this.manageMySQL = new mysqlCore(this.log, this.logPrefix, this.dbHost, this.dbDatabase, this.dbUser, this.dbPass);
		this.manageMySQL.initialize();
		System.out.println("3");
		String query = "SELECT * FROM vbuser  WHERE username = 'supermaxman'";
		try {
			ResultSet resultset = this.manageMySQL.sqlQuery(query);
			System.out.println(resultset);
			System.out.println("4");
		} catch (MalformedURLException e) {

		} catch (InstantiationException e) {

		} catch (IllegalAccessException e) {

		}
	}















}