ShortCuts.java 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239
  1. /*
  2. * Copyright (C) 2004-2013 L2J Server
  3. *
  4. * This file is part of L2J Server.
  5. *
  6. * L2J Server is free software: you can redistribute it and/or modify
  7. * it under the terms of the GNU General Public License as published by
  8. * the Free Software Foundation, either version 3 of the License, or
  9. * (at your option) any later version.
  10. *
  11. * L2J Server is distributed in the hope that it will be useful,
  12. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
  14. * General Public License for more details.
  15. *
  16. * You should have received a copy of the GNU General Public License
  17. * along with this program. If not, see <http://www.gnu.org/licenses/>.
  18. */
  19. package com.l2jserver.gameserver.model;
  20. import java.sql.Connection;
  21. import java.sql.PreparedStatement;
  22. import java.sql.ResultSet;
  23. import java.util.Map;
  24. import java.util.TreeMap;
  25. import java.util.logging.Level;
  26. import java.util.logging.Logger;
  27. import com.l2jserver.L2DatabaseFactory;
  28. import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
  29. import com.l2jserver.gameserver.model.items.instance.L2ItemInstance;
  30. import com.l2jserver.gameserver.model.items.type.L2EtcItemType;
  31. import com.l2jserver.gameserver.network.serverpackets.ExAutoSoulShot;
  32. import com.l2jserver.gameserver.network.serverpackets.ShortCutInit;
  33. import com.l2jserver.gameserver.network.serverpackets.ShortCutRegister;
  34. public class ShortCuts
  35. {
  36. private static Logger _log = Logger.getLogger(ShortCuts.class.getName());
  37. private static final int MAX_SHORTCUTS_PER_BAR = 12;
  38. private final L2PcInstance _owner;
  39. private final Map<Integer, L2ShortCut> _shortCuts = new TreeMap<>();
  40. public ShortCuts(L2PcInstance owner)
  41. {
  42. _owner = owner;
  43. }
  44. public L2ShortCut[] getAllShortCuts()
  45. {
  46. return _shortCuts.values().toArray(new L2ShortCut[_shortCuts.values().size()]);
  47. }
  48. public L2ShortCut getShortCut(int slot, int page)
  49. {
  50. L2ShortCut sc = _shortCuts.get(slot + (page * MAX_SHORTCUTS_PER_BAR));
  51. // Verify shortcut
  52. if ((sc != null) && (sc.getType() == L2ShortCut.TYPE_ITEM))
  53. {
  54. if (_owner.getInventory().getItemByObjectId(sc.getId()) == null)
  55. {
  56. deleteShortCut(sc.getSlot(), sc.getPage());
  57. sc = null;
  58. }
  59. }
  60. return sc;
  61. }
  62. public synchronized void registerShortCut(L2ShortCut shortcut)
  63. {
  64. // Verify shortcut
  65. if (shortcut.getType() == L2ShortCut.TYPE_ITEM)
  66. {
  67. final L2ItemInstance item = _owner.getInventory().getItemByObjectId(shortcut.getId());
  68. if (item == null)
  69. {
  70. return;
  71. }
  72. shortcut.setSharedReuseGroup(item.getSharedReuseGroup());
  73. }
  74. final L2ShortCut oldShortCut = _shortCuts.put(shortcut.getSlot() + (shortcut.getPage() * MAX_SHORTCUTS_PER_BAR), shortcut);
  75. registerShortCutInDb(shortcut, oldShortCut);
  76. }
  77. private void registerShortCutInDb(L2ShortCut shortcut, L2ShortCut oldShortCut)
  78. {
  79. if (oldShortCut != null)
  80. {
  81. deleteShortCutFromDb(oldShortCut);
  82. }
  83. try (Connection con = L2DatabaseFactory.getInstance().getConnection();
  84. PreparedStatement statement = con.prepareStatement("REPLACE INTO character_shortcuts (charId,slot,page,type,shortcut_id,level,class_index) values(?,?,?,?,?,?,?)"))
  85. {
  86. statement.setInt(1, _owner.getObjectId());
  87. statement.setInt(2, shortcut.getSlot());
  88. statement.setInt(3, shortcut.getPage());
  89. statement.setInt(4, shortcut.getType());
  90. statement.setInt(5, shortcut.getId());
  91. statement.setInt(6, shortcut.getLevel());
  92. statement.setInt(7, _owner.getClassIndex());
  93. statement.execute();
  94. }
  95. catch (Exception e)
  96. {
  97. _log.log(Level.WARNING, "Could not store character shortcut: " + e.getMessage(), e);
  98. }
  99. }
  100. /**
  101. * @param slot
  102. * @param page
  103. */
  104. public synchronized void deleteShortCut(int slot, int page)
  105. {
  106. final L2ShortCut old = _shortCuts.remove(slot + (page * MAX_SHORTCUTS_PER_BAR));
  107. if ((old == null) || (_owner == null))
  108. {
  109. return;
  110. }
  111. deleteShortCutFromDb(old);
  112. if (old.getType() == L2ShortCut.TYPE_ITEM)
  113. {
  114. L2ItemInstance item = _owner.getInventory().getItemByObjectId(old.getId());
  115. if ((item != null) && (item.getItemType() == L2EtcItemType.SHOT))
  116. {
  117. if (_owner.removeAutoSoulShot(item.getId()))
  118. {
  119. _owner.sendPacket(new ExAutoSoulShot(item.getId(), 0));
  120. }
  121. }
  122. }
  123. _owner.sendPacket(new ShortCutInit(_owner));
  124. for (int shotId : _owner.getAutoSoulShot())
  125. {
  126. _owner.sendPacket(new ExAutoSoulShot(shotId, 1));
  127. }
  128. }
  129. public synchronized void deleteShortCutByObjectId(int objectId)
  130. {
  131. for (L2ShortCut shortcut : _shortCuts.values())
  132. {
  133. if ((shortcut.getType() == L2ShortCut.TYPE_ITEM) && (shortcut.getId() == objectId))
  134. {
  135. deleteShortCut(shortcut.getSlot(), shortcut.getPage());
  136. break;
  137. }
  138. }
  139. }
  140. /**
  141. * @param shortcut
  142. */
  143. private void deleteShortCutFromDb(L2ShortCut shortcut)
  144. {
  145. try (Connection con = L2DatabaseFactory.getInstance().getConnection();
  146. PreparedStatement statement = con.prepareStatement("DELETE FROM character_shortcuts WHERE charId=? AND slot=? AND page=? AND class_index=?"))
  147. {
  148. statement.setInt(1, _owner.getObjectId());
  149. statement.setInt(2, shortcut.getSlot());
  150. statement.setInt(3, shortcut.getPage());
  151. statement.setInt(4, _owner.getClassIndex());
  152. statement.execute();
  153. }
  154. catch (Exception e)
  155. {
  156. _log.log(Level.WARNING, "Could not delete character shortcut: " + e.getMessage(), e);
  157. }
  158. }
  159. public void restore()
  160. {
  161. _shortCuts.clear();
  162. try (Connection con = L2DatabaseFactory.getInstance().getConnection();
  163. PreparedStatement statement = con.prepareStatement("SELECT charId, slot, page, type, shortcut_id, level FROM character_shortcuts WHERE charId=? AND class_index=?"))
  164. {
  165. statement.setInt(1, _owner.getObjectId());
  166. statement.setInt(2, _owner.getClassIndex());
  167. try (ResultSet rset = statement.executeQuery())
  168. {
  169. while (rset.next())
  170. {
  171. int slot = rset.getInt("slot");
  172. int page = rset.getInt("page");
  173. int type = rset.getInt("type");
  174. int id = rset.getInt("shortcut_id");
  175. int level = rset.getInt("level");
  176. _shortCuts.put(slot + (page * MAX_SHORTCUTS_PER_BAR), new L2ShortCut(slot, page, type, id, level, 1));
  177. }
  178. }
  179. }
  180. catch (Exception e)
  181. {
  182. _log.log(Level.WARNING, "Could not restore character shortcuts: " + e.getMessage(), e);
  183. }
  184. // Verify shortcuts
  185. for (L2ShortCut sc : getAllShortCuts())
  186. {
  187. if (sc.getType() == L2ShortCut.TYPE_ITEM)
  188. {
  189. L2ItemInstance item = _owner.getInventory().getItemByObjectId(sc.getId());
  190. if (item == null)
  191. {
  192. deleteShortCut(sc.getSlot(), sc.getPage());
  193. }
  194. else if (item.isEtcItem())
  195. {
  196. sc.setSharedReuseGroup(item.getEtcItem().getSharedReuseGroup());
  197. }
  198. }
  199. }
  200. }
  201. /**
  202. * Updates the shortcut bars with the new skill.
  203. * @param skillId the skill Id to search and update.
  204. * @param skillLevel the skill level to update.
  205. */
  206. public synchronized void updateShortCuts(int skillId, int skillLevel)
  207. {
  208. // Update all the shortcuts for this skill
  209. for (L2ShortCut sc : _shortCuts.values())
  210. {
  211. if ((sc.getId() == skillId) && (sc.getType() == L2ShortCut.TYPE_SKILL))
  212. {
  213. L2ShortCut newsc = new L2ShortCut(sc.getSlot(), sc.getPage(), sc.getType(), sc.getId(), skillLevel, 1);
  214. _owner.sendPacket(new ShortCutRegister(newsc));
  215. _owner.registerShortCut(newsc);
  216. }
  217. }
  218. }
  219. }