package pl.otekplay.dailyquest.manager;

import org.bukkit.Bukkit;
import pl.otekplay.dailyquest.Log;
import pl.otekplay.dailyquest.Main;
import pl.otekplay.dailyquest.data.Qplayer;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.UUID;

/**
 * Created by OTEQ on 2014-10-24.
 */
public class MySQLManager {


    private Main plugin = Main.getInst();

    public void savePlayer(UUID uuid) throws SQLException {
        Statement stat = plugin.c.createStatement();
        Qplayer qp = plugin.qplayers.get(uuid);
        stat.executeUpdate("UPDATE `Daily` SET `var1` = '" + qp.getVar1() + "',`var2`= '" + qp.getVar2() + "',`var2`= '" + qp.getVar3() + "',`var2`= '" + qp.getVar4() + "',`complete`= '" + qp.isComplete() + "'");

    }

    public void loadPlayer(UUID uuid) throws SQLException {
        Statement stat = plugin.c.createStatement();
        ResultSet res = stat.executeQuery("SELECT * FROM `'Daily` WHERE uuid = '" + uuid.toString() + "'");
        if (res.equals(null)) {
            stat.executeUpdate("INSERT INTO `Daily` (`uuid`,`name`,`var1`,`var2`,`var3`,`var4`,`complete`) VALUES ('" + uuid + "','" + Bukkit.getPlayer(uuid).getName() + "','" + 0 + "','" + 0 + "','" + 0 + "','" + 0 + "','" + false + "')");
            boolean complete = res.getBoolean("complete");
            Qplayer qp = new Qplayer(uuid, Bukkit.getPlayer(uuid).getName(), complete);
            qp.setVar1(0);
            qp.setVar2(0);
            qp.setVar3(0);
            qp.setVar4(0);
            plugin.qplayers.put(uuid, qp);
            return;
        }
        String uuidstring = res.getString("uuid");
        String name = res.getString("name");
        int var1 = res.getInt("var1");
        int var2 = res.getInt("var2");
        int var3 = res.getInt("var3");
        int var4 = res.getInt("var4");
        boolean complete = res.getBoolean("complete");
        Qplayer qp = new Qplayer(UUID.fromString(uuidstring), name, complete);
        qp.setVar1(var1);
        qp.setVar2(var2);
        qp.setVar3(var3);
        qp.setVar4(var4);
        plugin.qplayers.put(UUID.fromString(uuidstring), qp);
        plugin.Info("&4Gracz &6&l" + name + " &4wczytany");

    }

}