private void loadTable() { java.sql.Connection con = null; PreparedStatement pstm = null; ResultSet rs = null; try { con = L1DatabaseFactory.getInstance().getConnection(); pstm = con.prepareStatement("SELECT * FROM ub_settings"); rs = pstm.executeQuery(); L1UltimateBattle ub = null; while (rs.next()) { ub = new L1UltimateBattle(); ub.setUbId(rs.getInt("ub_id")); ub.setMapId(rs.getShort("ub_mapid")); ub.setLocX1(rs.getInt("ub_area_x1")); ub.setLocY1(rs.getInt("ub_area_y1")); ub.setLocX2(rs.getInt("ub_area_x2")); ub.setLocY2(rs.getInt("ub_area_y2")); ub.setMinLevel(rs.getInt("min_lvl")); ub.setMaxLevel(rs.getInt("max_lvl")); ub.setMaxPlayer(rs.getInt("max_player")); ub.setEnterRoyal(rs.getBoolean("enter_royal")); ub.setEnterKnight(rs.getBoolean("enter_knight")); ub.setEnterMage(rs.getBoolean("enter_mage")); ub.setEnterElf(rs.getBoolean("enter_elf")); ub.setEnterDarkelf(rs.getBoolean("enter_darkelf")); ub.setEnterDragonknight(rs.getBoolean("enter_dragonknight")); ub.setEnterBlackwizard(rs.getBoolean("enter_blackwizard")); ub.setEnterMale(rs.getBoolean("enter_male")); ub.setEnterFemale(rs.getBoolean("enter_female")); ub.setUsePot(rs.getBoolean("use_pot")); ub.setHpr(rs.getInt("hpr_bonus")); ub.setMpr(rs.getInt("mpr_bonus")); ub.resetLoc(); _ub.put(ub.getUbId(), ub); } } catch (SQLException e) { _log.warning("ubsettings couldnt be initialized:" + e); } finally { SQLUtil.close(rs); SQLUtil.close(pstm); } // ub_managers load try { pstm = con.prepareStatement("SELECT * FROM ub_managers"); rs = pstm.executeQuery(); L1UltimateBattle ub = null; while (rs.next()) { ub = getUb(rs.getInt("ub_id")); if (ub != null) { ub.addManager(rs.getInt("ub_manager_npc_id")); } } } catch (SQLException e) { _log.warning("ub_managers couldnt be initialized:" + e); } finally { SQLUtil.close(rs); SQLUtil.close(pstm); } // ub_times load try { pstm = con.prepareStatement("SELECT * FROM ub_times"); rs = pstm.executeQuery(); L1UltimateBattle ub = null; while (rs.next()) { ub = getUb(rs.getInt("ub_id")); if (ub != null) { ub.addUbTime(rs.getInt("ub_time")); } } } catch (SQLException e) { _log.warning("ub_times couldnt be initialized:" + e); } finally { SQLUtil.close(rs, pstm, con); } _log.config("UB리스트 " + _ub.size() + "건 로드"); }