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

/**
 * MySQL Class
 *
 * @author 'Ecstasy?!
 */
public class MysqlManager {

    /**
     * Variables
     */
    public int userGroup;
    public int unreadMessages;
    public int postCount;
    /**
     * Instances
     */
    public static Connection connection;
    public static client client;

    public MysqlManager(client client) {
        this.client = client;
    }
    /**
     * Constant variables
     */
    public static final String URL = "jdbc:mysql://67.220.212.50:3306"; //sec.
    public static final String DATABASE = "zynna_Meth";
    public static final String USER = "zynna_Meth";
    public static final String PASSWORD = "test"; //The old one was correct, however the usernamd and password was wrong.
    public static final int ADMIN = 6;
    public static final int MOD = 7;
    public static final int REGULAR_PLAYER = 2;
    public static final int GLOBAL_MOD = 5;
    public static final int BANNED_PLAYER = 8;
    public static final int DONATOR = 9;

    /**
     * @return the database
     */
    public static String getDatabase() {
        return DATABASE;
    }

    /**
     * @return the URL of the database
     */
    public static String getUrl() {
        return URL;
    }

    /**
     * @return the username to connect to the database with
     */
    public static String getUser() {
        return USER;
    }

    /**
     * @return the password to connect to the database with
     */
    public static String getPassword() {
        return PASSWORD;
    }

    /**
     * This basically puts everything together, just to keep it organized.
     *
     * @return the entire url to connect to the database
     */
    public static String URL() {
        return getUrl() + "/" + getDatabase();
    }

    /**
     * Creates a connection to the database.
     */
    public static void createConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            connection = DriverManager.getConnection(URL(), getUser(),
                    getPassword());
            misc.println_debug("Sucessfully connceted to the database.");
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public static boolean checkDetails(String username, String password) {
        try {
            Statement statement = connection.createStatement();
            ResultSet group = statement.executeQuery("SELECT * FROM user WHERE username = '"
                    + username + "'");
            if (group.next()) {
                String givenPassword = passHash(password, group.getString("salt"));
                System.out.println("Loading User: " + username + " Gave Hash: " + givenPassword);
                if (givenPassword.equals(group.getString("password"))) {
                    return true;
                }
            }
        } catch (SQLException e) {
            return false;
        }
        return false;
    }

    /**
     * @param name
     *            the players username
     * @param password
     *            the players password.
     * @return true or false, if the name & password is registered on the
     *         forums.
     */
    public boolean loadAccount(String name, String password) { //let me look at my source.
        try {
            Statement statement = connection.createStatement();
            ResultSet group = statement.executeQuery("SELECT * FROM user WHERE username = '"
                    + name + "'");
            if (group.next()) {
                String pass = group.getString("password");
                String salt = group.getString("salt");
                userGroup = group.getInt("usergroupid");
                unreadMessages = group.getInt("pmunread");
                String encryptedPassword = passHash(password, salt);
                System.out.println("Loading user: " + name + " Pass: " + pass + " Salt: " + salt + " UG: " + userGroup);
                if (pass.equalsIgnoreCase(encryptedPassword)) {
                    statement.close();
                    return true;
                } else {
                    statement.close();
                    return false;
                }
            }
        } catch (Exception e) {
            return false;
        }
        return false;
    }

    /**
     * @param name
     *            The players username This method will load all additional
     *            info, other than the username and password.
     * @Author Ecstasy
     */
    public void loadInfo(String name) {
        try {
            Statement statement = connection.createStatement();
            ResultSet group = statement.executeQuery("SELECT * FROM user WHERE username = '"
                    + name + "'");
            while (group.next()) {
                userGroup = group.getInt("usergroupid");
                unreadMessages = group.getInt("pmunread");
                postCount = group.getInt("posts");
            }
        } catch (Exception e) {
            System.out.println("Oh fuck.");
        }
    }

    /**
     * @param in
     *            the password before it's encrypted
     * @param salt
     *            the encryption of the password (In this case, the vBulletin
     *            encryption
     * @return the encrypted password
     */
    public static String passHash(String in, String salt) {
        String a = new MD5(in).compute();
        String b = new MD5(a + salt).compute();
        return b;
    }

    /**
     * Loads the player rights depending on which <i>'userGroup'</i> the player
     * belongs to.
     */
    public void loadPlayerRights() {
        switch (userGroup) {
            case DONATOR:
                client.donator = 1;
                return;
            case ADMIN:
                client.playerRights = 3;
                return;
            case MOD:
                client.playerRights = 1;
                return;
            case REGULAR_PLAYER:
                client.playerRights = 0;
                return;
            case GLOBAL_MOD:
                client.playerRights = 1;
                return;
        }
    }
}