package qmaks.anticheat;

import java.util.HashMap;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import org.bukkit.plugin.java.JavaPlugin;
import org.bukkit.configuration.file.FileConfiguration;

/**
 *
 * @author Анатолий
 */
public class Database {

    static HashMap<String, PreparedStatement> preparedStatements = new HashMap<String, PreparedStatement>();

    public Database(JavaPlugin pluginInstance) {
        try {
            FileConfiguration config = pluginInstance.getConfig();
            Class.forName("com.mysql.jdbc.Driver");
            Connection connection = DriverManager.getConnection("jdbc:mysql://" + config.getString("url"), config.getString("username"), config.getString("password"));

            preparedStatements.put("addScreenshot",
                    connection.prepareStatement(
                            "INSERT INTO `" + config.getString("table") + "` (player, screenshots) VALUES (?,?)"
                            + " ON DUPLICATE KEY "
                            + "UPDATE screenshots = IF(player=?,CONCAT(screenshots,?),screenshots);"));
            preparedStatements.put("getScreenshots", connection.prepareStatement("SELECT screenshots FROM " + config.getString("table") + " WHERE player=?;"));
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void addScreenshot(String player, String screenID) {
        PreparedStatement addScreenshot = preparedStatements.get("addScreenshot");

        try {
            addScreenshot.setString(1, player);
            addScreenshot.setString(2, screenID);
            addScreenshot.setString(3, player);
            addScreenshot.setString(4, ";" +screenID);

            addScreenshot.executeUpdate();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public String getScreenshots(String player) {
        PreparedStatement getScreenshots = preparedStatements.get("getScreenshots");

        ResultSet rs = null;
        try {
            getScreenshots.setString(1, player);

            rs = getScreenshots.executeQuery();
            while (rs.next()) {
                return rs.getString("screenshots");
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (Exception ex) {
                    ex.printStackTrace();
                }
            }
        }
        return "";
    }
}