LevelUpData.java 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128
  1. /*
  2. * This program is free software: you can redistribute it and/or modify it under
  3. * the terms of the GNU General Public License as published by the Free Software
  4. * Foundation, either version 3 of the License, or (at your option) any later
  5. * version.
  6. *
  7. * This program is distributed in the hope that it will be useful, but WITHOUT
  8. * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  9. * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
  10. * details.
  11. *
  12. * You should have received a copy of the GNU General Public License along with
  13. * this program. If not, see <http://www.gnu.org/licenses/>.
  14. */
  15. package net.sf.l2j.gameserver.datatables;
  16. import java.sql.Connection;
  17. import java.sql.PreparedStatement;
  18. import java.sql.ResultSet;
  19. import java.util.Map;
  20. import java.util.logging.Level;
  21. import java.util.logging.Logger;
  22. import javolution.util.FastMap;
  23. import net.sf.l2j.L2DatabaseFactory;
  24. import net.sf.l2j.gameserver.model.L2LvlupData;
  25. import net.sf.l2j.gameserver.model.base.ClassId;
  26. /**
  27. * This class ...
  28. *
  29. * @author NightMarez
  30. * @version $Revision: 1.3.2.4.2.3 $ $Date: 2005/03/27 15:29:18 $
  31. */
  32. public class LevelUpData
  33. {
  34. private static final String SELECT_ALL = "SELECT classid, defaulthpbase, defaulthpadd, defaulthpmod, defaultcpbase, defaultcpadd, defaultcpmod, defaultmpbase, defaultmpadd, defaultmpmod, class_lvl FROM lvlupgain";
  35. private static final String CLASS_LVL = "class_lvl";
  36. private static final String MP_MOD = "defaultmpmod";
  37. private static final String MP_ADD = "defaultmpadd";
  38. private static final String MP_BASE = "defaultmpbase";
  39. private static final String HP_MOD = "defaulthpmod";
  40. private static final String HP_ADD = "defaulthpadd";
  41. private static final String HP_BASE = "defaulthpbase";
  42. private static final String CP_MOD = "defaultcpmod";
  43. private static final String CP_ADD = "defaultcpadd";
  44. private static final String CP_BASE = "defaultcpbase";
  45. private static final String CLASS_ID = "classid";
  46. private static Logger _log = Logger.getLogger(LevelUpData.class.getName());
  47. private Map<Integer, L2LvlupData> _lvlTable;
  48. public static LevelUpData getInstance()
  49. {
  50. return SingletonHolder._instance;
  51. }
  52. private LevelUpData()
  53. {
  54. _lvlTable = new FastMap<Integer, L2LvlupData>();
  55. Connection con = null;
  56. try
  57. {
  58. con = L2DatabaseFactory.getInstance().getConnection();
  59. PreparedStatement statement = con.prepareStatement(SELECT_ALL);
  60. ResultSet rset = statement.executeQuery();
  61. L2LvlupData lvlDat;
  62. while (rset.next())
  63. {
  64. lvlDat = new L2LvlupData();
  65. lvlDat.setClassid(rset.getInt(CLASS_ID));
  66. lvlDat.setClassLvl(rset.getInt(CLASS_LVL));
  67. lvlDat.setClassHpBase(rset.getFloat(HP_BASE));
  68. lvlDat.setClassHpAdd(rset.getFloat(HP_ADD));
  69. lvlDat.setClassHpModifier(rset.getFloat(HP_MOD));
  70. lvlDat.setClassCpBase(rset.getFloat(CP_BASE));
  71. lvlDat.setClassCpAdd(rset.getFloat(CP_ADD));
  72. lvlDat.setClassCpModifier(rset.getFloat(CP_MOD));
  73. lvlDat.setClassMpBase(rset.getFloat(MP_BASE));
  74. lvlDat.setClassMpAdd(rset.getFloat(MP_ADD));
  75. lvlDat.setClassMpModifier(rset.getFloat(MP_MOD));
  76. _lvlTable.put(Integer.valueOf(lvlDat.getClassid()), lvlDat);
  77. }
  78. rset.close();
  79. statement.close();
  80. _log.config("LevelUpData: Loaded " + _lvlTable.size() + " Character Level Up Templates.");
  81. }
  82. catch (Exception e)
  83. {
  84. _log.log(Level.SEVERE, "Error loading Level Up data.", e);
  85. }
  86. finally
  87. {
  88. try
  89. {
  90. con.close();
  91. }
  92. catch (Exception e)
  93. {
  94. }
  95. }
  96. }
  97. /**
  98. * @param template id
  99. * @return
  100. */
  101. public L2LvlupData getTemplate(int classId)
  102. {
  103. return _lvlTable.get(classId);
  104. }
  105. public L2LvlupData getTemplate(ClassId classId)
  106. {
  107. return _lvlTable.get(classId.getId());
  108. }
  109. @SuppressWarnings("synthetic-access")
  110. private static class SingletonHolder
  111. {
  112. protected static final LevelUpData _instance = new LevelUpData();
  113. }
  114. }