package ru.pixelfine.guistats;

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

import ru.pixelfine.guistats.minigames.PlayerData;

public class Database {

    private static Connection connection;

    public static void connect() {
        try {
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/minigames", "root", "HfkIe3i73nM12FkE8pF");
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

    public static void close() {
        try {
            connection.close();
        } catch (SQLException ex) {}
    }

    public static void getBWStats(PlayerData data) {
        try {
            String query = "SELECT `Games`, `Kills`, `Wins`, `Beds` FROM `BedWars` WHERE `Name` LIKE '" + data.getPlayerName() + "'";
            Statement statement = connection.createStatement();
            ResultSet rs = statement.executeQuery(query);
            if (rs.next()) data.bw_games = rs.getInt(1);
            if (rs.next()) data.bw_kills = rs.getInt(2);
            if (rs.next()) data.bw_wins = rs.getInt(3);
            if (rs.next()) data.bw_beds = rs.getInt(4);
            statement.close();
            rs.close();
        } catch (Exception ex) {
            System.out.println(("[Stats] Ошибко загрузки BedWars статистики игрока " + data.getPlayerName()));
            ex.printStackTrace();
        }
    }

    public static void getBBStats(PlayerData data) {
        try {
            String query = "SELECT `Games`, `Wins`, `FirstPlaces`, `SecondPlaces`, `ThirdPlaces` FROM `BuildBattle` WHERE `Name` LIKE '" + data.getPlayerName() + "'";
            Statement statement = connection.createStatement();
            ResultSet rs = statement.executeQuery(query);

            if (rs.next()) data.bw_games = rs.getInt(1);
   			if (rs.next()) data.bw_kills = rs.getInt(2);
        	if (rs.next()) data.bw_wins = rs.getInt(3);
            if (rs.next()) data.bw_beds = rs.getInt(4);

            statement.close();
            rs.close();
        } catch (Exception ex) {
            System.out.println("[Stats] Ошибко загрузки BuildBattle статистики игрока " + data.getPlayerName());
            ex.printStackTrace();
        }
    }

}