package com.chickenstyle.report;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import org.bukkit.Bukkit;
import org.bukkit.ChatColor;
import org.bukkit.entity.Player;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.inventory.InventoryClickEvent;
import org.bukkit.plugin.java.JavaPlugin;

public class Main extends JavaPlugin implements Listener {
	   private static Connection connection;
	   private String host, database, username, password;
	   private int port;
       public void onEnable() {
   		getCommand("report").setExecutor(new Report());
   		Bukkit.getPluginManager().registerEvents(this, this);
   		host = "localhost";
   		port = 3306;
   		database = "player_report";
   		username = "root";
   		password = "";
   		try {
   			openConnection();

   			System.out.println(ChatColor.GREEN + "MySQL Connected!");
   		}catch (SQLException x) {
   			x.printStackTrace();
   		}

       }

       public static PreparedStatement prepareStatement(String query) {
    	   PreparedStatement ps = null;
    	   try {
    		   ps = connection.prepareStatement(query);
    	   } catch (SQLException x) {
    		   x.printStackTrace();
    	   }
    	   return ps;
       }
       private void openConnection() throws SQLException {
    	   if (connection != null && !connection.isClosed()) {
    		   return;
    	   }

    	   connection = DriverManager.getConnection("jdbc:mysql://" + this.host + ":" + this.port + "/" + this.database, this.username, this.password);
       }

        @EventHandler
        public void onClick(InventoryClickEvent e) {
    	Player player = (Player) e.getWhoClicked();
    	int slot = e.getSlot();
    	if (ChatColor.translateAlternateColorCodes('&', e.getClickedInventory().getTitle()).equals(ChatColor.GOLD + "ReportMenu")) {
    		e.setCancelled(true);
    		if (slot >= 11 && slot <= 15) {
    			player.closeInventory();
    			player.sendMessage(ChatColor.GOLD + "" + ChatColor.BOLD + "Thanks for your report!");

    		}
    	}

        }
}