package pl.mines.xcraftrayx.crafttabs;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class MySQL
{
    private static Connection conn;
    private static Statement stat;

    public static String DB_URL;

    private static String DRIVER = "com.mysql.jdbc.Driver";


    public static void connect()
    {
        try
        {
            Class.forName(DRIVER);
        }
        catch (ClassNotFoundException e)
        {
            System.err.println("Problem with MySQL Driver...");
            e.printStackTrace();
        }

        try
        {
                DB_URL = "jdbc:mysql://" + Config.host + ":" + Config.port + "/" + Config.base + "?autoReconnect=true&user=" + Config.user + "&password=" + Config.pass;

            if(conn == null)
            {
                conn = DriverManager.getConnection(DB_URL);
                stat = conn.createStatement();
            }
        }
        catch(SQLException e)
        {
            System.err.println("Problem with opening connection with Database...");
            e.printStackTrace();
        }
    }

    public static void closeConnection()
    {
        try
        {
            if(conn != null)
            {
                conn.close();
            }
        }
        catch (SQLException e)
        {
         System.err.println("Problem with closing connection with Database...");
            e.printStackTrace();
        }
    }

    public static String[][] getTopFactions()
    {
        String[][] lista = new String[15][2];

        try
        {
            ResultSet result = stat.executeQuery("SELECT name, wins FROM `factionWars` ORDER BY wins, kills DESC LIMIT 15;");

            int i = 0;
            while(result.next())
            {
                String name = String.valueOf(result.getString("name"));
                String wins = String.valueOf(result.getInt("wins"));

                lista[i][0] = name;
                lista[i][1] = wins;

                i++;
            }
        }
        catch (SQLException e)
        {
            System.err.println("Problem with getting top factions stats!");
            e.printStackTrace();
            return null;
        }
        return lista;
    }

    public static String[][] getTopPlayers()
    {
        String[][] lista = new String[15][3];

        try
        {
            ResultSet result = stat.executeQuery("SELECT name, kills, elo FROM pvpstats ORDER BY elo DESC LIMIT 15;");

            int i = 0;
            while(result.next())
            {
                String name = String.valueOf(result.getString("name"));
                String kills = String.valueOf(result.getInt("kills"));
                String elo = String.valueOf(result.getInt("elo"));

                lista[i][0] = name;
                lista[i][1] = kills;
                lista[i][2] = elo;

                i++;
            }
        }
        catch (SQLException e)
        {
            System.err.println("Problem with getting top users!");
            e.printStackTrace();
            return null;
        }
        return lista;
    }
}