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.event.Listener;
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());
   		getCommand("reports").setExecutor(new Reports());
   		Bukkit.getPluginManager().registerEvents(this, this);
   		host = "localhost";
   		port = 3306;
   		database = "playerreport";
   		username = "root";
   		password = "";
   		try {
   			openConnection();

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

       }

       public static PreparedStatement prepareState(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);
       }

}