package com.runeage.core.network.mysql;

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

import com.runeage.rs2.content.skill.Skill;
import com.runeage.rs2.entity.player.Player;


public class Highscores implements Runnable {

	public static final String HOST = "107.180.43.74"; // website ip address
	public static final String USER = "runeage_hs";
	public static final String PASS = "snug9183d";
	public static final String DATABASE = "runeage_hs";

	private Player player;
	private Connection conn;
	private Statement stmt;

	public Highscores(Player player) {
		this.player = player;
	}

	public boolean connect(String host, String database, String user, String pass) {
		try {
			this.conn = DriverManager.getConnection("jdbc:mysql://"+host+":3306/"+database, user, pass);
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
	}

	@Override
	public void run() {
		try {
			if (!connect(HOST, DATABASE, USER, PASS)) {
				return;
			}

			String name = player.getUsername();

			PreparedStatement stmt1 = prepare("DELETE FROM hs_users WHERE username=?");
			stmt1.setString(1, name);
			stmt1.execute();

			PreparedStatement stmt2 = prepare(generateQuery());

			stmt2.setString(1, name);
			stmt2.setInt(2, player.getRights());
			stmt2.setLong(3, player.getSkill().getTotalExperience());


			for (int i = 0; i < 22; i++)
				stmt2.setInt(4 + i, (int)player.getSkill().getExperience()[i]);
			stmt2.execute();

			destroy();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public PreparedStatement prepare(String query) throws SQLException {
		return conn.prepareStatement(query);
	}

	public void destroy() {
        try {
    		conn.close();
        	conn = null;
        	if (stmt != null) {
    			stmt.close();
        		stmt = null;
        	}
        } catch(Exception e) {
            e.printStackTrace();
        }
    }

	public static String generateQuery() {
		StringBuilder sb = new StringBuilder();
		sb.append("INSERT INTO hs_users (");
		sb.append("username, ");
		sb.append("rights, ");
		sb.append("overall_xp, ");
		sb.append("attack_xp, ");
		sb.append("defence_xp, ");
		sb.append("strength_xp, ");
		sb.append("constitution_xp, ");
		sb.append("ranged_xp, ");
		sb.append("prayer_xp, ");
		sb.append("magic_xp, ");
		sb.append("cooking_xp, ");
		sb.append("woodcutting_xp, ");
		sb.append("fletching_xp, ");
		sb.append("fishing_xp, ");
		sb.append("firemaking_xp, ");
		sb.append("crafting_xp, ");
		sb.append("smithing_xp, ");
		sb.append("mining_xp, ");
		sb.append("herblore_xp, ");
		sb.append("agility_xp, ");
		sb.append("thieving_xp, ");
		sb.append("slayer_xp, ");
		sb.append("farming_xp, ");
		sb.append("runecrafting_xp, ");
		sb.append("hunter_xp, ");
		sb.append("VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
		return sb.toString();
	}



}