package cryston.AutoRank;
import java.io.File;
import java.sql.*;
public class AutoRankAccess {

	public AutoRankAccess(File rootdir)
	{

	}

	public Update[] getChanges() {
		// TODO Auto-generated method stub
		return null;
	}
	public int getRank(String playerName)
	{
		  Connection conn = null;
		  String url = "jdbc:mysql://localhost:3306/";
		  String dbName = "AutoRankDB";
		  String driver = "com.mysql.jdbc.Driver";
		  String userName = "root";
		  String password = "CENSORED";
		  try {
		  Class.forName(driver).newInstance();
		  conn = DriverManager.getConnection(url+dbName,userName,password);
		  Statement stmt = conn.createStatement();
		  int rows = stmt.executeUpdate("SELECT totalamount FROM AutoRankTable WHERE playername = 'playerName'", Statement.RETURN_GENERATED_KEYS); //FIX IF DOES NOT WORK!
		  ResultSet rs = stmt.getGeneratedKeys();
		  int result = rs.getInt("1");
		  rs.close();
		  stmt.close();
		  conn.close();
		  } catch (Exception e) {
		  e.printStackTrace();
		  }
		  return(result);
	}
	}