예제 #1
0
 public L1UltimateBattle getUbForNpcId(int npcId) {
   for (L1UltimateBattle ub : _ub.values()) {
     if (ub.containsManager(npcId)) {
       return ub;
     }
   }
   return null;
 }
예제 #2
0
  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() + "건 로드");
  }