public provinceInfo getProvinceByID(int id) {
		if (id == 0)
			return null;

		if (provinceIDCache.containsKey(id))
			return provinceIDCache.get(id);

		provinceInfo province = null;
		String SQL = "SELECT * FROM `Monarchy_Provinces` WHERE `id` = ?";

		Connection con = getSQLConnection();

		try {

			PreparedStatement statement = con.prepareStatement(SQL);
			statement.setInt(1, id);

			ResultSet result = statement.executeQuery();

			while (result.next()) {
				String together = result.getString(3) + "+" + result.getInt(4) + "+" + result.getInt(5);

				province = new provinceInfo(result.getInt(1), // id
					result.getString(2),// player
					result.getString(3),// world
					result.getInt(4),// x
					result.getInt(5),// z
					result.getInt(6),// parent
					//result.getInt(7),// permitted
					result.getString(7),// invited
					(result.getTimestamp(8).getTime() / 1000D) // time
				);

				provinceLocCache.put(together, id);
				provinceIDCache.put(id, province);

			}

			statement.close();
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return province;
	}