CharSummonTable.java 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218
  1. /*
  2. * Copyright © 2004-2019 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.data.sql.impl;
  20. import static com.l2jserver.gameserver.config.Configuration.character;
  21. import java.util.Map;
  22. import java.util.concurrent.ConcurrentHashMap;
  23. import org.slf4j.Logger;
  24. import org.slf4j.LoggerFactory;
  25. import com.l2jserver.commons.database.ConnectionFactory;
  26. import com.l2jserver.gameserver.data.xml.impl.NpcData;
  27. import com.l2jserver.gameserver.data.xml.impl.PetDataTable;
  28. import com.l2jserver.gameserver.datatables.SkillData;
  29. import com.l2jserver.gameserver.model.L2PetData;
  30. import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
  31. import com.l2jserver.gameserver.model.actor.instance.L2PetInstance;
  32. import com.l2jserver.gameserver.model.actor.instance.L2ServitorInstance;
  33. import com.l2jserver.gameserver.model.actor.templates.L2NpcTemplate;
  34. import com.l2jserver.gameserver.model.items.instance.L2ItemInstance;
  35. import com.l2jserver.gameserver.model.skills.Skill;
  36. import com.l2jserver.gameserver.network.serverpackets.PetItemList;
  37. /**
  38. * @author Nyaran
  39. */
  40. public class CharSummonTable {
  41. private static final Logger LOG = LoggerFactory.getLogger(CharSummonTable.class);
  42. private static final Map<Integer, Integer> _pets = new ConcurrentHashMap<>();
  43. private static final Map<Integer, Integer> _servitors = new ConcurrentHashMap<>();
  44. // SQL
  45. private static final String INIT_PET = "SELECT ownerId, item_obj_id FROM pets WHERE restore = 'true'";
  46. private static final String INIT_SUMMONS = "SELECT ownerId, summonSkillId FROM character_summons";
  47. private static final String LOAD_SUMMON = "SELECT curHp, curMp, time FROM character_summons WHERE ownerId = ? AND summonSkillId = ?";
  48. private static final String REMOVE_SUMMON = "DELETE FROM character_summons WHERE ownerId = ?";
  49. private static final String SAVE_SUMMON = "REPLACE INTO character_summons (ownerId,summonSkillId,curHp,curMp,time) VALUES (?,?,?,?,?)";
  50. public Map<Integer, Integer> getPets() {
  51. return _pets;
  52. }
  53. public Map<Integer, Integer> getServitors() {
  54. return _servitors;
  55. }
  56. public void init() {
  57. if (character().restoreServitorOnReconnect()) {
  58. try (var con = ConnectionFactory.getInstance().getConnection();
  59. var s = con.createStatement();
  60. var rs = s.executeQuery(INIT_SUMMONS)) {
  61. while (rs.next()) {
  62. _servitors.put(rs.getInt("ownerId"), rs.getInt("summonSkillId"));
  63. }
  64. } catch (Exception e) {
  65. LOG.warn("Error while loading saved servitor!", e);
  66. }
  67. }
  68. if (character().restorePetOnReconnect()) {
  69. try (var con = ConnectionFactory.getInstance().getConnection();
  70. var s = con.createStatement();
  71. var rs = s.executeQuery(INIT_PET)) {
  72. while (rs.next()) {
  73. _pets.put(rs.getInt("ownerId"), rs.getInt("item_obj_id"));
  74. }
  75. } catch (Exception e) {
  76. LOG.warn("Error while loading saved pet!", e);
  77. }
  78. }
  79. }
  80. public void removeServitor(L2PcInstance activeChar) {
  81. _servitors.remove(activeChar.getObjectId());
  82. try (var con = ConnectionFactory.getInstance().getConnection();
  83. var ps = con.prepareStatement(REMOVE_SUMMON)) {
  84. ps.setInt(1, activeChar.getObjectId());
  85. ps.execute();
  86. } catch (Exception e) {
  87. LOG.warn("Summon cannot be removed!", e);
  88. }
  89. }
  90. public void restorePet(L2PcInstance activeChar) {
  91. final L2ItemInstance item = activeChar.getInventory().getItemByObjectId(_pets.get(activeChar.getObjectId()));
  92. if (item == null) {
  93. LOG.warn("Null pet summoning item for player {}!", activeChar);
  94. return;
  95. }
  96. final L2PetData petData = PetDataTable.getInstance().getPetDataByItemId(item.getId());
  97. if (petData == null) {
  98. LOG.warn("Null pet data for: {} and summoning item {}!", activeChar, item);
  99. return;
  100. }
  101. final L2NpcTemplate npcTemplate = NpcData.getInstance().getTemplate(petData.getNpcId());
  102. if (npcTemplate == null) {
  103. LOG.warn("Null pet NPC template for player {} and pet ID {}!", activeChar, petData.getNpcId());
  104. return;
  105. }
  106. final L2PetInstance pet = L2PetInstance.spawnPet(npcTemplate, activeChar, item);
  107. if (pet == null) {
  108. LOG.warn("Null pet instance for player {} and pet NPC template {}!", activeChar, npcTemplate);
  109. return;
  110. }
  111. pet.setShowSummonAnimation(true);
  112. pet.setTitle(activeChar.getName());
  113. if (!pet.isRespawned()) {
  114. pet.setCurrentHp(pet.getMaxHp());
  115. pet.setCurrentMp(pet.getMaxMp());
  116. pet.setExp(pet.getExpForThisLevel());
  117. pet.setCurrentFed(pet.getMaxFed());
  118. }
  119. pet.setRunning();
  120. if (!pet.isRespawned()) {
  121. pet.storeMe();
  122. }
  123. item.setEnchantLevel(pet.getLevel());
  124. activeChar.setPet(pet);
  125. pet.spawnMe(activeChar.getX() + 50, activeChar.getY() + 100, activeChar.getZ());
  126. pet.startFeed();
  127. pet.setFollowStatus(true);
  128. pet.getOwner().sendPacket(new PetItemList(pet.getInventory().getItems()));
  129. pet.broadcastStatusUpdate();
  130. }
  131. public void restoreServitor(L2PcInstance activeChar) {
  132. int skillId = _servitors.get(activeChar.getObjectId());
  133. try (var con = ConnectionFactory.getInstance().getConnection();
  134. var ps = con.prepareStatement(LOAD_SUMMON)) {
  135. ps.setInt(1, activeChar.getObjectId());
  136. ps.setInt(2, skillId);
  137. try (var rs = ps.executeQuery()) {
  138. Skill skill;
  139. while (rs.next()) {
  140. int curHp = rs.getInt("curHp");
  141. int curMp = rs.getInt("curMp");
  142. int time = rs.getInt("time");
  143. skill = SkillData.getInstance().getSkill(skillId, activeChar.getSkillLevel(skillId));
  144. if (skill == null) {
  145. removeServitor(activeChar);
  146. return;
  147. }
  148. skill.applyEffects(activeChar, activeChar);
  149. if (activeChar.hasServitor()) {
  150. final L2ServitorInstance summon = (L2ServitorInstance) activeChar.getSummon();
  151. summon.setCurrentHp(curHp);
  152. summon.setCurrentMp(curMp);
  153. summon.setLifeTimeRemaining(time);
  154. }
  155. }
  156. }
  157. } catch (Exception e) {
  158. LOG.warn("Servitor cannot be restored!", e);
  159. }
  160. }
  161. public void saveSummon(L2ServitorInstance summon) {
  162. if ((summon == null) || (summon.getLifeTimeRemaining() <= 0)) {
  163. return;
  164. }
  165. _servitors.put(summon.getOwner().getObjectId(), summon.getReferenceSkill());
  166. try (var con = ConnectionFactory.getInstance().getConnection();
  167. var ps = con.prepareStatement(SAVE_SUMMON)) {
  168. ps.setInt(1, summon.getOwner().getObjectId());
  169. ps.setInt(2, summon.getReferenceSkill());
  170. ps.setInt(3, (int) Math.round(summon.getCurrentHp()));
  171. ps.setInt(4, (int) Math.round(summon.getCurrentMp()));
  172. ps.setInt(5, summon.getLifeTimeRemaining());
  173. ps.execute();
  174. } catch (Exception e) {
  175. LOG.warn("Failed to store summon {} from {}!", summon, summon.getOwner(), e);
  176. }
  177. }
  178. public static CharSummonTable getInstance() {
  179. return SingletonHolder._instance;
  180. }
  181. private static class SingletonHolder {
  182. protected static final CharSummonTable _instance = new CharSummonTable();
  183. }
  184. }