package zensiert;

import java.sql.*;

public class zensiert
{
    public static boolean playerExists(final String UUID)
    {
        try
        {
            final ResultSet rs = Main.mysql.query("SELECT * FROM test WHERE UUID='" + UUID + "'");
            if (rs.next())
            {
                return rs.getString("UUID") != null;
            }
        }
        catch (SQLException ex)
        {

        }
        return false;
    }

    public static void createPlayer(final String UUID)
    {
        if (!playerExists(UUID))
        {
        	Main.mysql.update("INSERT INTO test (UUID, TEST) VALUES ('" + UUID + "', '0')");
        }
    }

    public static void setTest(final String UUID, final int Test)
    {
        if (playerExists(UUID))
        {
        	Main.mysql.update("UPDATE test SET TEST='" + Test + "' WHERE UUID='" + UUID + "'");
        }
        else
        {
            createPlayer(UUID);
            setTest(UUID, Test);
        }
    }

    public static Integer getTest(final String UUID)
    {
        if (playerExists(UUID))
        {
            try
            {
                final ResultSet rs = Main.mysql.query("SELECT * FROM test WHERE UUID='" + UUID + "'");
                if (rs.next())
                {
                    return rs.getInt("TEST");
                }
                return 0;
            }
            catch (SQLException ex)
            {
                return 0;
            }
        }
        createPlayer(UUID);
        getTest(UUID);
        return 0;
    }
}